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
AG01003629  2018-10-01                              2018-10-01 10:07:28  MG00000001  2022-08-04 09:28:14  AG01003629  View Edit Delete
AG01003628  2018-09-25                              2018-09-25 14:55:55  MG00000001  2018-09-25 15:31:52  AG01003628  View Edit Delete
AG02000111  2018-09-21                              2018-09-21 12:53:17  MG00000001  2019-11-25 14:32:21  AG02000111  View Edit Delete
AG01003627  2018-09-11                              2018-09-11 16:38:50  MG00000001  2021-08-05 15:37:16  AG01003627  View Edit Delete
AG01003626  2018-09-07                              2018-09-07 16:12:43  MG00000001  2018-10-24 11:42:31  AG01003626  View Edit Delete
AG02100058  2018-08-23                              2018-08-23 14:18:22  MG00000001  2021-11-10 09:35:55  AG02100058  View Edit Delete
AG02100059  2018-08-23                              2018-08-23 14:19:21  MG00000001  2020-05-11 15:19:13  AG02100059  View Edit Delete
AG02100060  2018-08-23                              2018-08-23 14:20:11  MG00000001  2021-10-05 13:44:42  AG02100060  View Edit Delete
AG02100061  2018-08-23                              2018-08-23 14:20:57  MG00000001  2024-01-19 12:48:09  AG02100061  View Edit Delete
AG01003625  2018-08-16                              2018-08-16 16:51:39  MG00000001  2018-08-16 16:51:39  MG00000001  View Edit Delete
AG02000107  2018-08-16                              2018-08-16 12:47:06  MG00000001  2022-01-04 16:27:27  AG02000107  View Edit Delete
AG02000108  2018-08-16                              2018-08-16 12:47:48  MG00000001  2022-01-04 16:27:16  AG02000108  View Edit Delete
AG02000109  2018-08-16                              2018-08-16 12:48:35  MG00000001  2021-02-04 10:31:54  AG02000109  View Edit Delete

Page 197 of 250, showing 20 records out of 5000 total, starting on record 3921, ending on 3940

(default) 2 queries took 29 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 3920, 20202019
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 = 11110