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
AG01004580  2021-10-13                              2021-10-13 09:53:33  MG00000001  2023-07-28 18:59:25  AG01004580  View Edit Delete
AG01004651  2022-03-31                              2022-03-31 00:45:40  MG00000001  2023-07-28 18:48:34  AG01004651  View Edit Delete
AG01004718  2022-05-25                              2022-05-25 11:07:56  MG00000001  2023-07-28 15:10:41  AG01004718  View Edit Delete
AG01005401  2022-12-28                              2022-12-28 11:31:58  MG00000001  2023-07-28 13:21:17  AG01005401  View Edit Delete
AG01005138  2022-09-08                              2022-09-08 10:52:18  MG00000001  2023-07-28 13:11:29  AG01005138  View Edit Delete
AG01004700  2022-05-23                              2022-05-23 09:48:32  MG00000001  2023-07-27 11:27:02  AG01004700  View Edit Delete
AG01004699  2022-05-23                              2022-05-23 09:46:44  MG00000001  2023-07-27 11:26:21  AG01004699  View Edit Delete
AG01005608  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-07-27 08:55:16  AG01005608  View Edit Delete
AG01005605  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-07-26 21:11:21  AG01005605  View Edit Delete
AG01005602  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-07-26 20:54:08  AG01005602  View Edit Delete
AG01003403  2018-05-25                              2018-05-25 09:40:00  MG00000001  2023-07-26 15:39:18  AG01003403  View Edit Delete
AG01005607  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-07-26 11:54:57  AG01005607  View Edit Delete
AG01005606  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-07-26 11:37:24  AG01005606  View Edit Delete
AG01004416  2021-03-12                              2021-03-12 16:54:09  MG00000005  2023-07-25 18:09:33  AG01004416  View Edit Delete
AG01001296  2017-09-25                              2016-08-30 12:23:26  MG00000001  2023-07-25 14:40:22  AG01001296  View Edit Delete
AG01004712  2022-05-25                              2022-05-25 09:59:12  MG00000001  2023-07-25 13:08:46  AG01004712  View Edit Delete
AG01003751  2019-07-03                              2019-07-03 11:32:30  MG00000001  2023-07-25 12:19:11  AG01003751  View Edit Delete
AG01005623  2023-07-20                              2023-07-20 00:00:00  MG00000001  2023-07-24 16:43:17  AG01005623  View Edit Delete
AG01004518  2021-05-21                              2021-05-21 08:56:56  MG00000001  2023-07-24 16:13:21  AG01004518  View Edit Delete
AG01004702  2022-05-23                              2022-05-23 14:29:02  MG00000001  2023-07-24 16:04:14  AG01004702  View Edit Delete

Page 46 of 250, showing 20 records out of 5000 total, starting on record 901, ending on 920

(default) 2 queries took 22 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 900, 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 = 11113