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
AG01006003  2023-11-27                              2023-11-27 00:00:00  MG00000001  2023-11-27 00:00:00  MG00000001  View Edit Delete
AG04000165  2023-11-20                              2023-11-20 10:11:36  MG00000001  2024-01-23 13:31:12  AG04000165  View Edit Delete
AG04000164  2023-11-16                              2023-11-16 14:09:05  MG00000001  2023-11-28 14:56:12  AG04000164  View Edit Delete
AG01005996  2023-11-15                              2023-11-15 00:00:00  MG00000001  2023-11-15 12:02:46  AG01005996  View Edit Delete
AG01005997  2023-11-15                              2023-11-15 00:00:00  MG00000001  2023-11-23 23:08:53  AG01005997  View Edit Delete
AG01005994  2023-11-10                              2023-11-10 00:00:00  MG00000001  2023-11-10 00:00:00  MG00000001  View Edit Delete
AG01005995  2023-11-10                              2023-11-10 00:00:00  MG00000001  2023-11-16 14:10:25  AG01005995  View Edit Delete
AG08000070  2023-11-08                              2023-11-08 15:49:53  MG00000001  2023-11-10 10:52:27  AG08000070  View Edit Delete
AG01005968  2023-11-07                              2023-11-07 00:00:00  MG00000001  2023-12-11 12:21:27  AG01005968  View Edit Delete
AG01005969  2023-11-07                              2023-11-07 00:00:00  MG00000001  2023-11-16 08:08:38  AG01005969  View Edit Delete
AG01005970  2023-11-07                              2023-11-07 10:34:34  MG00000001  2023-11-15 09:48:43  AG01005970  View Edit Delete
AG01005971  2023-11-07                              2023-11-07 00:00:00  MG00000001  2023-11-15 10:44:19  AG01005971  View Edit Delete
AG01005972  2023-11-07                              2023-11-07 00:00:00  MG00000001  2023-11-15 14:31:51  AG01005972  View Edit Delete
AG01005973  2023-11-07                              2023-11-07 00:00:00  MG00000001  2023-11-25 08:52:37  AG01005973  View Edit Delete
AG01005974  2023-11-07                              2023-11-07 00:00:00  MG00000001  2023-11-17 10:38:29  AG01005974  View Edit Delete
AG01005975  2023-11-07                              2023-11-07 00:00:00  MG00000001  2023-11-15 10:06:10  AG01005975  View Edit Delete
AG01005976  2023-11-07                              2023-11-07 00:00:00  MG00000001  2023-11-15 10:36:04  AG01005976  View Edit Delete
AG01005977  2023-11-07                              2023-11-07 00:00:00  MG00000001  2023-12-19 10:46:01  AG01005977  View Edit Delete
AG01005978  2023-11-07                              2023-11-07 00:00:00  MG00000001  2023-11-15 09:57:03  MG00000001  View Edit Delete
AG01005979  2023-11-07                              2023-11-07 00:00:00  MG00000001  2023-11-15 10:43:52  AG01005979  View Edit Delete

Page 3 of 250, showing 20 records out of 5000 total, starting on record 41, ending on 60

(default) 2 queries took 15 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`.`agreement_start_day` desc LIMIT 40, 2020203
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