Farmers

User Agreement Start Day Agreement End Day Plan Code Agreement Amount Rental Printer Sn Rental Tablet Sn Rental Tablet Tel Rental Tablet Gmail Label Flg Seal Flg Blog Flg Log Save Number User Post Number User Address User Tel Qr Url Notification File Plain Password Created Insert User Modified Update User Actions
AG01003688  2019-04-10                              2019-04-10 13:41:18  MG00000001  2019-04-20 10:22:42  AG01003688  View Edit Delete
AG01003452  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-04-22 08:37:41  AG01003452  View Edit Delete
AG01003692  2019-04-10                              2019-04-10 13:48:12  MG00000001  2019-04-23 14:52:09  AG01003692  View Edit Delete
AG01003697  2019-04-15                              2019-04-15 09:55:35  MG00000001  2019-04-23 14:53:10  AG01003697  View Edit Delete
AG05000115  2019-04-12                              2019-04-12 10:24:01  MG00000001  2019-04-24 14:12:35  AG05000115  View Edit Delete
AG01003413  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-04-30 10:51:18  AG01003413  View Edit Delete
AG01003417  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-04-30 10:52:33  AG01003417  View Edit Delete
AG01003420  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-04-30 10:54:06  AG01003420  View Edit Delete
AG01003421  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-04-30 10:54:22  AG01003421  View Edit Delete
AG01003424  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-04-30 10:55:26  AG01003424  View Edit Delete
AG01003425  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-04-30 10:55:38  AG01003425  View Edit Delete
AG01003426  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-04-30 10:55:51  AG01003426  View Edit Delete
AG01003429  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-04-30 10:57:57  AG01003429  View Edit Delete
AG02000028  2017-02-22                  771-0206  徳島県板野郡北島町高房字百居内36  090-1575-5944        2017-02-22 00:00:00  MG00000001  2019-05-02 12:23:13  AG02000028  View Edit Delete
AG02100065  2018-12-07                              2018-12-07 11:43:46  MG00000001  2019-05-14 13:54:45  AG02100065  View Edit Delete
AG01003710  2019-05-16                              2019-05-16 08:36:27  MG00000001  2019-05-16 08:36:27  MG00000001  View Edit Delete
AG01003711  2019-05-16                              2019-05-16 08:39:25  MG00000001  2019-05-16 08:39:25  MG00000001  View Edit Delete
AG01003664  2019-04-02                              2019-04-02 09:23:07  MG00000001  2019-05-16 18:36:50  AG01003664  View Edit Delete
AG01003661  2019-03-12                              2019-03-12 10:35:29  MG00000001  2019-05-17 09:44:15  AG01003661  View Edit Delete
AG05000088  2017-11-01                  349-0223  埼玉県白岡市          2017-11-01 11:34:46  MG00000001  2019-05-20 11:51:03  MG00000001  View Edit Delete

Page 34 of 250, showing 20 records out of 5000 total, starting on record 661, ending on 680

(default) 2 queries took 17 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Farmer`.`user_id`, `Farmer`.`agreement_start_day`, `Farmer`.`agreement_end_day`, `Farmer`.`plan_code`, `Farmer`.`agreement_amount`, `Farmer`.`rental_printer_sn`, `Farmer`.`rental_tablet_sn`, `Farmer`.`rental_tablet_tel`, `Farmer`.`rental_tablet_gmail`, `Farmer`.`label_flg`, `Farmer`.`seal_flg`, `Farmer`.`blog_flg`, `Farmer`.`log_save_number`, `Farmer`.`user_post_number`, `Farmer`.`user_address`, `Farmer`.`user_tel`, `Farmer`.`qr_url`, `Farmer`.`notification_file`, `Farmer`.`plain_password`, `Farmer`.`admin_memo`, `Farmer`.`biz_browser_authorized_devices_count`, `Farmer`.`biz_browser_authorized_devices_limit`, `Farmer`.`created`, `Farmer`.`insert_user`, `Farmer`.`modified`, `Farmer`.`update_user`, `ContractPlan`.`plan_code`, `ContractPlan`.`plan_nm`, `ContractPlan`.`contract_months`, `ContractPlan`.`agreement_amount`, `ContractPlan`.`created`, `ContractPlan`.`insert_user`, `ContractPlan`.`modified`, `ContractPlan`.`update_user`, `User`.`id`, `User`.`login_id`, `User`.`user_nm`, `User`.`user_fk`, `User`.`user_type`, `User`.`password`, `User`.`mail_address_1`, `User`.`mail_address_2`, `User`.`login_rock_flg`, `User`.`last_login_day`, `User`.`use_start_day`, `User`.`use_end_day`, `User`.`del_flg`, `User`.`init_pass_flg`, `User`.`created`, `User`.`insert_user`, `User`.`modified`, `User`.`update_user` FROM `sato_agri`.`farmers` AS `Farmer` LEFT JOIN `sato_agri`.`contract_plan` AS `ContractPlan` ON (`Farmer`.`plan_code` = `ContractPlan`.`plan_code`) LEFT JOIN `sato_agri`.`users` AS `User` ON (`User`.`id` = `Farmer`.`user_id`) WHERE 1 = 1 ORDER BY `Farmer`.`modified` asc LIMIT 660, 2020206
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`farmers` AS `Farmer` LEFT JOIN `sato_agri`.`contract_plan` AS `ContractPlan` ON (`Farmer`.`plan_code` = `ContractPlan`.`plan_code`) LEFT JOIN `sato_agri`.`users` AS `User` ON (`User`.`id` = `Farmer`.`user_id`) WHERE 1 = 11111