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
AG01005171  2022-10-03                              2022-10-03 10:27:27  MG00000001  2023-04-01 13:52:02  AG01005171  View Edit Delete
AG01004949  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-04-01 11:44:10  AG01004949  View Edit Delete
AG01004884  2022-07-20                              2022-07-20 10:53:45  MG00000001  2023-04-01 10:43:48  AG01004884  View Edit Delete
AG01005121  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-03-31 15:14:09  AG01005121  View Edit Delete
AG01005090  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-03-31 14:05:36  AG01005090  View Edit Delete
AG01005037  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-03-31 11:00:48  AG01005037  View Edit Delete
AG01005184  2022-10-11                              2022-10-11 10:38:27  MG00000001  2023-03-31 10:03:59  AG01005184  View Edit Delete
AG01005226  2022-10-19                              2022-10-19 16:32:38  MG00000001  2023-03-31 09:18:20  AG01005226  View Edit Delete
AG01004995  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-03-30 16:03:40  AG01004995  View Edit Delete
AG01004982  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-03-30 15:53:20  AG01004982  View Edit Delete
AG01005219  2022-10-19                              2022-10-19 16:32:38  MG00000001  2023-03-30 14:31:35  AG01005219  View Edit Delete
AG01005382  2022-11-28                              2022-11-28 00:00:00  MG00000001  2023-03-30 11:20:33  AG01005382  View Edit Delete
AG01005106  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-03-30 11:10:13  MG00000001  View Edit Delete
AG01004478  2021-03-31                              2021-03-31 09:34:51  MG00000005  2023-03-30 10:47:25  AG01004478  View Edit Delete
AG01004610  2021-12-07                              2021-12-07 14:58:26  MG00000001  2023-03-30 09:39:35  AG01004610  View Edit Delete
AG01004817  2022-06-16                              2022-06-16 09:48:15  MG00000001  2023-03-30 09:37:54  AG01004817  View Edit Delete
AG01004877  2022-07-20                              2022-07-20 10:53:45  MG00000001  2023-03-30 09:27:03  MG00000001  View Edit Delete
AG01004897  2022-07-20                              2022-07-20 10:53:45  MG00000001  2023-03-30 09:05:04  MG00000001  View Edit Delete
AG01004800  2022-06-08                              2022-06-08 14:50:05  MG00000001  2023-03-30 08:33:05  AG01004800  View Edit Delete
AG01004656  2022-05-09                              2022-05-09 08:42:37  MG00000001  2023-03-30 02:18:23  AG01004656  View Edit Delete

Page 64 of 250, showing 20 records out of 5000 total, starting on record 1261, ending on 1280

(default) 2 queries took 20 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 1260, 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 = 11111