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
AG01005894  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-11-04 16:58:27  AG01005894  View Edit Delete
AG01005403  2023-01-06                              2023-01-06 14:43:12  MG00000001  2023-11-04 14:23:17  AG01005403  View Edit Delete
AG01005688  2023-09-01                              2023-09-01 00:00:00  MG00000001  2023-11-04 11:10:29  AG01005688  View Edit Delete
AG01005056  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-11-04 11:09:42  AG01005056  View Edit Delete
AG01005055  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-11-04 11:09:24  AG01005055  View Edit Delete
AG01005871  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-11-04 09:13:09  AG01005871  View Edit Delete
AG01005926  2023-10-23                              2023-10-23 00:00:00  MG00000001  2023-11-04 08:18:26  AG01005926  View Edit Delete
AG01005957  2023-10-30                              2023-10-30 00:00:00  MG00000001  2023-11-04 07:44:55  AG01005957  View Edit Delete
AG01005177  2022-10-11                              2022-10-11 10:12:55  MG00000001  2023-11-04 07:11:02  AG01005177  View Edit Delete
AG01005717  2023-09-22                              2023-09-22 00:00:00  MG00000001  2023-11-04 06:40:51  AG01005717  View Edit Delete
AG01004433  2021-03-18                              2021-03-18 16:03:00  MG00000005  2023-11-04 06:30:52  AG01004433  View Edit Delete
AG01004365  2021-03-09                              2021-03-09 10:52:33  MG00000005  2023-11-03 18:03:44  AG01004365  View Edit Delete
AG04000141  2022-06-23                              2022-06-23 11:08:20  MG00000001  2023-11-03 14:39:29  AG04000141  View Edit Delete
AG01004341  2021-03-08                              2021-03-08 16:39:00  MG00000005  2023-11-03 07:58:18  AG01004341  View Edit Delete
AG01005960  2023-10-30                              2023-10-30 00:00:00  MG00000001  2023-11-03 07:06:28  AG01005960  View Edit Delete
AG01005821  2023-10-05                              2023-10-05 00:00:00  MG00000001  2023-11-02 17:26:27  AG01005821  View Edit Delete
AG01005964  2023-10-31                              2023-10-31 00:00:00  MG00000001  2023-11-02 17:10:37  AG01005964  View Edit Delete
AG01004498  2021-04-19                              2021-04-19 16:57:43  MG00000001  2023-11-02 13:39:35  AG01004498  View Edit Delete
AG01005958  2023-10-30                              2023-10-30 00:00:00  MG00000001  2023-11-02 13:06:02  AG01005958  View Edit Delete
AG01005959  2023-10-30                              2023-10-30 00:00:00  MG00000001  2023-11-02 13:05:16  AG01005959  View Edit Delete

Page 18 of 250, showing 20 records out of 5000 total, starting on record 341, ending on 360

(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`.`modified` desc LIMIT 340, 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 = 11112