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
AG01005998  2023-11-27                              2023-11-27 00:00:00  MG00000001  2023-12-15 11:36:08  AG01005998  View Edit Delete
AG01004510  2021-05-07                              2021-05-07 10:35:49  MG00000005  2023-12-15 09:25:51  AG01004510  View Edit Delete
AG01005094  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-12-14 18:34:26  AG01005094  View Edit Delete
AG01004088  2020-06-30                              2020-06-30 10:49:42  MG00000005  2023-12-14 16:40:22  AG01004088  View Edit Delete
AG02000030  2017-02-22                  771-0203  徳島県板野郡北島町中村字本須47  090-8692-4380        2017-02-22 00:00:00  MG00000001  2023-12-14 13:52:39  AG02000030  View Edit Delete
AG01005748  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-12-14 13:05:02  AG01005748  View Edit Delete
AG01004233  2021-01-20                              2021-01-20 08:55:40  MG00000005  2023-12-14 13:03:51  AG01004233  View Edit Delete
AG01004216  2021-01-18                              2021-01-18 16:40:13  MG00000005  2023-12-14 12:49:14  AG01004216  View Edit Delete
AG04000166  2023-12-14                              2023-12-14 08:44:11  MG00000001  2023-12-14 08:44:11  MG00000001  View Edit Delete
AG01005002  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-12-13 12:02:37  AG01005002  View Edit Delete
AG01005928  2023-10-25                              2023-10-25 00:00:00  MG00000001  2023-12-13 11:52:41  AG01005928  View Edit Delete
AG01006011  2023-12-07                              2023-12-07 00:00:00  MG00000001  2023-12-13 11:19:47  AG01006011  View Edit Delete
AG01006023  2023-12-12                              2023-12-12 00:00:00  MG00000001  2023-12-13 08:43:09  AG01006023  View Edit Delete
AG01004006  2020-01-31                              2020-01-31 09:47:10  MG00000001  2023-12-12 17:02:39  AG01004006  View Edit Delete
AG01006022  2023-12-12                              2023-12-12 00:00:00  MG00000001  2023-12-12 16:50:24  AG01006022  View Edit Delete
AG01006010  2023-12-07                              2023-12-07 00:00:00  MG00000001  2023-12-12 16:49:37  AG01006010  View Edit Delete
AG01005876  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-12-12 14:39:49  AG01005876  View Edit Delete
AG01005036  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-12-12 13:39:31  AG01005036  View Edit Delete
AG01005044  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-12-12 13:39:09  AG01005044  View Edit Delete
AG01005208  2022-10-19                              2022-10-19 16:32:38  MG00000001  2023-12-12 13:38:43  AG01005208  View Edit Delete

Page 8 of 250, showing 20 records out of 5000 total, starting on record 141, ending on 160

(default) 2 queries took 16 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 140, 2020204
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