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
AG07000008  2018-06-15                              2018-06-15 22:53:37  MG00000001  2018-06-15 22:53:37  MG00000001  View Edit Delete
AG07000009  2018-06-15                              2018-06-15 22:54:29  MG00000001  2018-06-15 22:54:29  MG00000001  View Edit Delete
AG07000010  2018-06-15                              2018-06-15 22:55:09  MG00000001  2018-06-15 22:55:09  MG00000001  View Edit Delete
AG07000011  2018-06-15                              2018-06-15 22:57:00  MG00000001  2018-06-15 22:57:00  MG00000001  View Edit Delete
AG08000028  2019-01-07                              2019-01-07 15:36:52  MG00000001  2019-01-07 15:36:52  MG00000001  View Edit Delete
AG08000033  2020-01-16                              2020-01-16 08:34:23  MG00000001  2023-07-05 10:38:45  MG00000001  View Edit Delete
AG08000057  2022-08-16                              2022-08-16 10:59:21  MG00000001  2022-08-16 10:59:21  MG00000001  View Edit Delete
AG08000058  2023-01-24                              2023-01-24 10:14:29  MG00000001  2023-01-26 08:35:41  MG00000001  View Edit Delete
AG08000061  2023-03-03                              2023-03-03 08:44:09  MG00000001  2023-07-05 10:39:20  MG00000001  View Edit Delete
AG08000062  2023-04-10                              2023-04-10 10:50:59  MG00000001  2023-11-15 14:20:06  MG00000001  View Edit Delete
AG08000068  2023-07-18                              2023-07-18 09:13:57  MG00000001  2023-07-18 09:13:57  MG00000001  View Edit Delete
AG08000071  2023-12-22                              2023-12-22 18:14:01  MG00000001  2023-12-22 18:14:01  MG00000001  View Edit Delete
AG09000007  2018-06-17    6800                7691402  香川県三豊市仁尾町仁尾戊638  0825-82-5122        2018-06-17 00:04:35  MG00000001  2018-09-10 13:33:15  MG00000001  View Edit Delete
AG09000011  2018-06-17    11  4800                            2018-06-17 00:26:33  MG00000001  2018-07-06 09:24:58  MG00000001  View Edit Delete
AG09000019  2018-06-17                              2018-06-17 00:53:00  MG00000001  2018-07-23 15:23:55  MG00000001  View Edit Delete
AG09000021  2018-06-18                              2018-06-18 07:25:16  MG00000001  2018-08-02 16:36:52  MG00000001  View Edit Delete
AG09000022  2018-06-18                              2018-06-18 12:53:53  MG00000001  2018-07-18 14:17:10  MG00000001  View Edit Delete
AG09000027  2018-06-20                              2018-06-20 09:41:01  MG00000001  2018-06-20 09:41:01  MG00000001  View Edit Delete
AG09000029  2018-06-20                              2018-06-20 09:45:20  MG00000001  2018-06-20 09:45:20  MG00000001  View Edit Delete
AG09000030  2018-06-20                              2018-06-20 10:09:33  MG00000001  2018-06-20 10:09:33  MG00000001  View Edit Delete

Page 98 of 250, showing 20 records out of 5000 total, starting on record 1941, ending on 1960

(default) 2 queries took 27 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`.`update_user` desc LIMIT 1940, 20202015
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