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
AG08000013  2018-10-02                              2018-09-25 12:37:43  MG00000001  2018-10-09 16:32:59  AG08000013  View Edit Delete
AG08000014  2018-10-02                              2018-09-25 12:38:23  MG00000001  2018-10-11 11:06:20  AG08000014  View Edit Delete
AG08000015  2018-10-02                              2018-09-25 12:39:13  MG00000001  2023-06-14 13:52:21  AG08000015  View Edit Delete
AG08000016  2018-10-02                              2018-09-25 12:39:45  MG00000001  2018-10-11 11:07:11  AG08000016  View Edit Delete
AG08000017  2018-10-02                              2018-09-25 12:40:29  MG00000001  2018-10-11 11:07:24  AG08000017  View Edit Delete
AG08000018  2018-10-02                              2018-09-25 12:41:31  MG00000001  2018-10-11 11:07:34  AG08000018  View Edit Delete
AG08000019  2018-10-02                              2018-09-25 12:42:08  MG00000001  2023-10-17 09:31:48  AG08000019  View Edit Delete
AG01003628  2018-09-25                              2018-09-25 14:55:55  MG00000001  2018-09-25 15:31:52  AG01003628  View Edit Delete
AG01003629  2018-10-01                              2018-10-01 10:07:28  MG00000001  2022-08-04 09:28:14  AG01003629  View Edit Delete
AG02000112  2018-10-09                              2018-10-09 09:17:42  MG00000001  2022-01-04 16:27:02  AG02000112  View Edit Delete
AG02100062  2018-10-19                              2018-10-19 11:56:20  MG00000001  2018-10-19 11:56:20  MG00000001  View Edit Delete
AG01003630  2018-10-19                              2018-10-19 12:42:27  MG00000001  2021-06-28 14:08:06  AG01003630  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
AG02000115  2018-10-24                              2018-10-24 10:20:33  MG00000001  2022-01-04 16:26:49  AG02000115  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
AG01003631  2018-10-30                              2018-10-30 10:31:53  MG00000001  2018-11-02 11:23:34  AG01003631  View Edit Delete

Page 55 of 250, showing 20 records out of 5000 total, starting on record 1081, ending on 1100

(default) 2 queries took 19 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`.`created` asc LIMIT 1080, 2020208
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