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
AG01005807  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-12-21 09:13:18  AG01005807  View Edit Delete
AG01005808  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-10-05 16:18:59  AG01005808  View Edit Delete
AG01005809  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-09-28 00:00:00  MG00000001  View Edit Delete
AG01005810  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-10-05 15:43:22  AG01005810  View Edit Delete
AG01005811  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-09-28 00:00:00  MG00000001  View Edit Delete
AG01005812  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-10-05 13:24:30  AG01005812  View Edit Delete
AG01005814  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-09-28 00:00:00  MG00000001  View Edit Delete
AG01005816  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-10-27 16:28:56  AG01005816  View Edit Delete
AG01005817  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-10-27 16:27:52  AG01005817  View Edit Delete
AG01005818  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-10-27 16:27:10  AG01005818  View Edit Delete
AG01005819  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-10-13 14:32:18  AG01005819  View Edit Delete
AG01005731  2023-09-22                              2023-09-22 10:59:35  MG00000001  2023-10-02 13:56:23  AG01005731  View Edit Delete
AG01005707  2023-09-22                              2023-09-22 10:49:52  MG00000001  2023-11-11 09:03:18  AG01005707  View Edit Delete
AG01005708  2023-09-22                              2023-09-22 00:00:00  MG00000001  2023-11-11 09:00:55  AG01005708  View Edit Delete
AG01005709  2023-09-22                              2023-09-22 00:00:00  MG00000001  2024-01-08 08:38:33  AG01005709  View Edit Delete
AG01005710  2023-09-22                              2023-09-22 00:00:00  MG00000001  2024-01-08 09:59:44  AG01005710  View Edit Delete
AG01005711  2023-09-22                              2023-09-22 00:00:00  MG00000001  2024-01-08 08:35:08  AG01005711  View Edit Delete
AG01005712  2023-09-22                              2023-09-22 00:00:00  MG00000001  2023-11-11 09:06:25  AG01005712  View Edit Delete
AG01005713  2023-09-22                              2023-09-22 00:00:00  MG00000001  2024-01-21 06:58:05  AG01005713  View Edit Delete
AG01005714  2023-09-22                              2023-09-22 00:00:00  MG00000001  2023-10-22 06:45:31  AG01005714  View Edit Delete

Page 16 of 250, showing 20 records out of 5000 total, starting on record 301, ending on 320

(default) 2 queries took 19 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`.`created` desc LIMIT 300, 2020206
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