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
AG01005294  2022-11-16                              2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete
AG01005297  2022-11-17                              2022-11-17 09:42:27  MG00000001  2022-11-17 09:42:27  MG00000001  View Edit Delete
AG01005298  2022-11-17                              2022-11-17 09:45:46  MG00000001  2022-11-17 09:45:46  MG00000001  View Edit Delete
AG01005301  2022-11-17                              2022-11-17 11:02:36  MG00000001  2022-11-17 11:02:36  MG00000001  View Edit Delete
AG01005303  2022-11-17                              2022-11-17 14:20:36  MG00000001  2022-11-17 14:20:36  MG00000001  View Edit Delete
AG01005323  2022-11-21                              2022-11-21 09:54:45  MG00000001  2022-12-02 14:16:09  MG00000001  View Edit Delete
AG01005340  2022-11-21                              2022-11-21 10:29:56  MG00000001  2022-11-21 10:29:56  MG00000001  View Edit Delete
AG01005377  2022-11-24                              2022-11-24 11:06:27  MG00000001  2022-11-25 10:42:55  MG00000001  View Edit Delete
AG01005380  2022-11-28                              2022-11-28 00:00:00  MG00000001  2022-11-28 00:00:00  MG00000001  View Edit Delete
AG01005381  2022-11-28                              2022-11-28 00:00:00  MG00000001  2022-11-28 00:00:00  MG00000001  View Edit Delete
AG01005392  2022-12-19                              2022-12-19 00:00:00  MG00000001  2022-12-19 00:00:00  MG00000001  View Edit Delete
AG01005396  2022-12-26                              2022-12-26 10:33:48  MG00000001  2023-05-29 10:11:59  MG00000001  View Edit Delete
AG01005404  2023-01-12                              2023-01-12 10:30:34  MG00000001  2023-01-12 10:30:34  MG00000001  View Edit Delete
AG01005406  2023-01-17                              2023-01-17 00:00:00  MG00000001  2023-01-17 00:00:00  MG00000001  View Edit Delete
AG01005439  2023-02-15                              2023-02-15 09:58:52  MG00000001  2023-02-15 09:58:52  MG00000001  View Edit Delete
AG01005452  2023-03-27                              2023-03-27 00:00:00  MG00000001  2023-03-27 00:00:00  MG00000001  View Edit Delete
AG01005498  2023-05-22                              2023-05-22 00:00:00  MG00000001  2023-05-22 00:00:00  MG00000001  View Edit Delete
AG01005499  2023-05-22                              2023-05-22 00:00:00  MG00000001  2023-05-22 00:00:00  MG00000001  View Edit Delete
AG01005525  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-08-28 14:01:07  MG00000001  View Edit Delete
AG01005531  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-08-28 14:03:49  MG00000001  View Edit Delete

Page 172 of 250, showing 20 records out of 5000 total, starting on record 3421, ending on 3440

(default) 2 queries took 30 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` asc LIMIT 3420, 20202019
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