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
AG01004224  2021-01-19                              2021-01-19 10:27:05  MG00000005  2023-07-05 05:39:35  AG01004224  View Edit Delete
AG01001306  2017-09-25                              2016-08-30 12:23:27  MG00000001  2023-07-04 15:05:18  AG01001306  View Edit Delete
AG01004060  2020-05-11                              2020-05-11 14:39:37  MG00000001  2023-07-04 14:44:10  AG01004060  View Edit Delete
AG01003702  2019-04-24                              2019-04-24 09:30:28  MG00000001  2023-07-04 14:43:38  AG01003702  View Edit Delete
AG01003700  2019-04-18                              2019-04-18 09:40:45  MG00000001  2023-07-04 14:43:03  AG01003700  View Edit Delete
AG01003698  2019-04-18                              2019-04-18 09:29:45  MG00000001  2023-07-04 14:25:36  AG01003698  View Edit Delete
AG01001307  2017-09-25    6800                            2016-08-30 12:23:27  MG00000001  2023-07-04 13:48:22  AG01001307  View Edit Delete
AG01001087  2016-08-30                              2016-08-30 12:23:25  MG00000001  2023-07-03 16:53:09  AG01001087  View Edit Delete
AG01000762  2017-07-27                              2016-08-30 12:23:22  MG00000001  2023-07-03 16:50:25  AG01000762  View Edit Delete
AG01004990  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-07-03 13:01:13  AG01004990  View Edit Delete
AG04000021  2022-06-23                              2022-06-23 11:08:20  MG00000001  2023-07-01 15:12:03  AG04000021  View Edit Delete
AG01005479  2023-05-08                              2023-05-08 00:00:00  MG00000001  2023-07-01 08:24:21  AG01005479  View Edit Delete
AG01004915  2022-07-29                              2022-07-29 09:42:56  MG00000001  2023-06-30 11:00:27  AG01004915  View Edit Delete
AG01005483  2023-05-08                              2023-05-08 00:00:00  MG00000001  2023-06-30 09:26:16  AG01005483  View Edit Delete
AG01004955  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-06-29 14:45:27  AG01004955  View Edit Delete
AG01004994  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-06-28 13:55:25  AG01004994  View Edit Delete
AG01004105  2020-08-06                              2020-08-06 09:20:08  MG00000005  2023-06-27 17:57:39  AG01004105  View Edit Delete
AG04000151  2023-06-20                              2023-06-20 06:59:29  MG00000001  2023-06-27 12:41:11  AG04000151  View Edit Delete
AG01004130  2020-09-29                              2020-09-29 10:32:22  MG00000005  2023-06-27 10:55:01  AG01004130  View Edit Delete
AG01005073  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-06-27 10:37:30  AG01005073  View Edit Delete

Page 51 of 250, showing 20 records out of 5000 total, starting on record 1001, ending on 1020

(default) 2 queries took 21 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`.`modified` desc LIMIT 1000, 2020209
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