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
AG05000128  2020-07-20                              2020-07-20 11:05:23  MG00000005  2020-07-20 14:26:19  AG05000128  View Edit Delete
AG05000127  2020-07-13                              2020-07-13 14:13:39  MG00000005  2021-10-11 15:33:43  AG05000127  View Edit Delete
AG05000126  2020-07-01                              2020-07-01 13:48:19  MG00000005  2021-05-24 16:56:26  AG05000126  View Edit Delete
AG05000125  2020-05-28                              2020-05-28 09:04:27  MG00000001  2021-05-24 16:57:47  AG05000125  View Edit Delete
AG05000124  2020-03-04                              2020-03-04 08:48:34  MG00000001  2021-04-02 16:06:15  AG05000124  View Edit Delete
AG05000123  2020-02-19                              2020-02-19 14:09:36  MG00000001  2020-02-21 09:50:41  AG05000123  View Edit Delete
AG05000122  2019-12-17                              2019-12-17 08:37:42  MG00000001  2021-05-28 10:34:23  AG05000122  View Edit Delete
AG05000121  2019-11-18                              2019-11-18 12:50:53  MG00000001  2019-11-19 13:47:13  AG05000121  View Edit Delete
AG05000120  2019-09-30                              2019-09-30 14:14:04  MG00000001  2020-02-20 09:13:01  AG05000120  View Edit Delete
AG05000119  2019-08-26                              2019-08-26 08:34:08  MG00000001  2021-06-11 14:34:05  AG05000119  View Edit Delete
AG05000118  2019-06-24                              2019-06-24 09:35:35  MG00000001  2021-05-22 14:55:12  AG05000118  View Edit Delete
AG05000117  2019-06-17                              2019-06-17 08:39:17  MG00000001  2021-05-26 13:24:25  AG05000117  View Edit Delete
AG05000116  2019-05-29                              2019-05-29 11:11:12  MG00000001  2021-06-01 14:08:14  AG05000116  View Edit Delete
AG05000115  2019-04-12                              2019-04-12 10:24:01  MG00000001  2019-04-24 14:12:35  AG05000115  View Edit Delete
AG05000114  2019-03-29                              2019-03-29 11:44:54  MG00000001  2022-01-09 12:01:01  AG05000114  View Edit Delete
AG05000113  2019-03-04                              2019-03-04 15:14:17  MG00000001  2022-04-26 14:24:08  AG05000113  View Edit Delete
AG05000112  2019-02-28                              2019-02-28 09:17:41  MG00000001  2019-02-28 15:49:21  AG05000112  View Edit Delete
AG05000111  2019-02-14                              2019-02-14 09:35:47  MG00000001  2021-03-31 13:31:49  AG05000111  View Edit Delete
AG05000110  2018-11-28                              2018-11-28 09:43:36  MG00000001  2018-12-03 15:13:57  AG05000110  View Edit Delete
AG05000109  2018-11-05                              2018-11-05 09:23:15  MG00000001  2018-11-06 15:23:03  AG05000109  View Edit Delete

Page 68 of 250, showing 20 records out of 5000 total, starting on record 1341, ending on 1360

(default) 2 queries took 18 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`.`user_id` desc LIMIT 1340, 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 = 11112