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
AG01003632  2018-10-30                              2018-10-30 11:09:39  MG00000001  2020-07-03 13:34:06  AG01003632  View Edit Delete
AG08000020  2018-10-30                              2018-10-30 09:41:06  MG00000001  2023-09-15 08:34:54  AG08000020  View Edit Delete
AG08000021  2018-10-30                              2018-10-30 09:41:58  MG00000001  2023-05-21 09:13:36  AG08000021  View Edit Delete
AG08000022  2018-10-30                              2018-10-30 09:43:24  MG00000001  2023-10-22 10:58:59  AG08000022  View Edit Delete
AG02000115  2018-10-24                              2018-10-24 10:20:33  MG00000001  2022-01-04 16:26:49  AG02000115  View Edit Delete
AG02000113  2018-10-22                              2018-10-22 13:38:38  MG00000001  2022-01-04 16:28:05  AG02000113  View Edit Delete
AG02000114  2018-10-22                              2018-10-22 13:39:24  MG00000001  2022-11-29 10:07:57  AG02000114  View Edit Delete
AG05000106  2018-10-22                              2018-10-22 14:27:58  MG00000005  2021-03-29 14:29:33  AG05000106  View Edit Delete
AG01003630  2018-10-19                              2018-10-19 12:42:27  MG00000001  2021-06-28 14:08:06  AG01003630  View Edit Delete
AG02100062  2018-10-19                              2018-10-19 11:56:20  MG00000001  2018-10-19 11:56:20  MG00000001  View Edit Delete
AG02000112  2018-10-09                              2018-10-09 09:17:42  MG00000001  2022-01-04 16:27:02  AG02000112  View Edit Delete
AG08000004  2018-10-02                              2018-09-25 11:56:32  MG00000001  2022-12-08 15:59:17  AG08000004  View Edit Delete
AG08000005  2018-10-02                              2018-09-25 11:57:34  MG00000001  2022-12-21 11:55:52  AG08000005  View Edit Delete
AG08000006  2018-10-02                              2018-09-25 11:58:07  MG00000001  2022-12-21 11:56:01  AG08000006  View Edit Delete
AG08000007  2018-10-02                              2018-09-25 11:58:41  MG00000001  2022-12-09 09:17:28  AG08000007  View Edit Delete
AG08000008  2018-10-02                              2018-09-25 12:33:34  MG00000001  2023-06-27 09:18:06  AG08000008  View Edit Delete
AG08000009  2018-10-02                              2018-09-25 12:34:04  MG00000001  2023-07-14 09:43:30  AG08000009  View Edit Delete
AG08000010  2018-10-02                              2018-09-25 12:34:38  MG00000001  2018-11-07 11:25:19  AG08000010  View Edit Delete
AG08000011  2018-10-02                              2018-09-25 12:35:20  MG00000001  2018-10-11 11:06:01  AG08000011  View Edit Delete
AG08000012  2018-10-02                              2018-09-25 12:36:36  MG00000001  2018-10-11 11:06:46  AG08000012  View Edit Delete

Page 196 of 250, showing 20 records out of 5000 total, starting on record 3901, ending on 3920

(default) 2 queries took 33 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`.`agreement_start_day` desc LIMIT 3900, 20202021
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