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
AG01004329  2021-03-08                              2021-03-08 13:37:33  MG00000005  2023-08-12 07:47:07  AG01004329  View Edit Delete
AG01004330  2021-03-08                              2021-03-08 13:40:21  MG00000005  2022-05-31 10:38:02  AG01004330  View Edit Delete
AG01004331  2021-03-08                              2021-03-08 13:49:39  MG00000005  2023-08-26 14:50:27  AG01004331  View Edit Delete
AG01004332  2021-03-08                              2021-03-08 13:59:47  MG00000005  2023-02-21 01:39:38  AG01004332  View Edit Delete
AG01004333  2021-03-08                              2021-03-08 14:07:13  MG00000005  2023-10-29 08:57:49  AG01004333  View Edit Delete
AG01004334  2021-03-08                              2021-03-08 14:14:23  MG00000005  2023-08-29 15:38:08  AG01004334  View Edit Delete
AG01004335  2021-03-08                              2021-03-08 14:22:07  MG00000005  2023-09-16 07:08:19  AG01004335  View Edit Delete
AG01004337  2021-03-08                              2021-03-08 15:32:55  MG00000005  2023-02-24 09:41:18  AG01004337  View Edit Delete
AG01004338  2021-03-08                              2021-03-08 16:18:23  MG00000005  2023-05-23 14:43:04  AG01004338  View Edit Delete
AG01004339  2021-03-08                              2021-03-08 16:22:17  MG00000005  2021-03-29 12:59:45  AG01004339  View Edit Delete
AG01004340  2021-03-08                              2021-03-08 16:26:27  MG00000005  2023-11-05 12:46:08  AG01004340  View Edit Delete
AG01004341  2021-03-08                              2021-03-08 16:39:00  MG00000005  2023-11-03 07:58:18  AG01004341  View Edit Delete
AG01004342  2021-03-08                              2021-03-08 16:45:49  MG00000005  2023-04-06 10:23:17  AG01004342  View Edit Delete
AG01004343  2021-03-08                              2021-03-08 17:00:19  MG00000005  2023-10-07 11:15:22  AG01004343  View Edit Delete
AG01004344  2021-03-08                              2021-03-08 17:29:10  MG00000005  2023-09-16 07:20:39  AG01004344  View Edit Delete
AG01004345  2021-03-08                              2021-03-08 18:03:03  MG00000005  2023-11-22 11:42:04  AG01004345  View Edit Delete
AG01004346  2021-03-08                              2021-03-08 18:20:34  MG00000005  2023-11-02 07:52:54  AG01004346  View Edit Delete
AG01004347  2021-03-08                              2021-03-08 18:28:47  MG00000005  2022-05-24 11:33:01  AG01004347  View Edit Delete
AG01004348  2021-03-08                              2021-03-08 18:31:18  MG00000005  2023-06-19 16:56:48  AG01004348  View Edit Delete
AG01004349  2021-03-08                              2021-03-08 18:51:56  MG00000005  2022-07-11 07:47:13  AG01004349  View Edit Delete

Page 13 of 250, showing 20 records out of 5000 total, starting on record 241, ending on 260

(default) 2 queries took 18 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`.`insert_user` desc LIMIT 240, 2020205
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