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
AG01003743  2019-06-19                              2019-06-19 08:56:46  MG00000001  2022-12-18 09:54:21  AG01003743  View Edit Delete
AG01005392  2022-12-19                              2022-12-19 00:00:00  MG00000001  2022-12-19 00:00:00  MG00000001  View Edit Delete
AG01003706  2019-05-08                              2019-05-08 08:38:51  MG00000001  2022-12-19 09:23:07  AG01003706  View Edit Delete
AG01003375  2018-03-09    貸し出し用機材  貸し出し用機材                        2018-03-09 17:29:49  MG00000001  2022-12-19 11:47:45  AG01003375  View Edit Delete
AG04000070  2022-06-23                              2022-06-23 11:08:20  MG00000001  2022-12-19 14:06:10  AG04000070  View Edit Delete
AG01004731  2022-05-25                              2022-05-25 13:09:09  MG00000001  2022-12-19 14:40:44  AG01004731  View Edit Delete
AG01005385  2022-11-28                              2022-11-28 00:00:00  MG00000001  2022-12-19 14:48:12  AG01005385  View Edit Delete
AG01005141  2022-09-13                              2022-09-13 08:45:36  MG00000001  2022-12-19 14:58:16  AG01005141  View Edit Delete
AG01004930  2022-07-29                              2022-07-29 09:42:56  MG00000001  2022-12-19 15:03:21  AG01004930  View Edit Delete
AG01004536  2021-06-21                              2021-06-21 10:50:42  MG00000001  2022-12-19 15:16:28  AG01004536  View Edit Delete
AG01004725  2022-05-25                              2022-05-25 13:09:09  MG00000001  2022-12-19 16:53:24  AG01004725  View Edit Delete
AG01005344  2022-11-22                              2022-11-22 15:07:01  MG00000001  2022-12-20 10:24:08  AG01005344  View Edit Delete
AG01004737  2022-05-25                              2022-05-25 13:09:09  MG00000001  2022-12-20 10:27:57  AG01004737  View Edit Delete
AG01004743  2022-05-25                              2022-05-25 13:09:09  MG00000001  2022-12-20 10:31:49  AG01004743  View Edit Delete
AG04000148  2022-12-14                              2022-12-14 22:16:28  MG00000001  2022-12-20 10:50:49  AG04000148  View Edit Delete
AG01005358  2022-11-22                              2022-11-22 15:07:01  MG00000001  2022-12-20 11:17:49  AG01005358  View Edit Delete
AG01004739  2022-05-25                              2022-05-25 13:09:09  MG00000001  2022-12-20 11:18:58  AG01004739  View Edit Delete
AG01004941  2022-08-05                              2022-08-05 15:10:13  MG00000001  2022-12-20 11:50:32  AG01004941  View Edit Delete
AG01003444  2018-05-25                              2018-05-25 09:40:00  MG00000001  2022-12-20 17:39:43  AG01003444  View Edit Delete
AG01004109  2020-09-02                              2020-09-02 15:57:16  MG00000001  2022-12-21 09:28:02  AG01004109  View Edit Delete

Page 167 of 250, showing 20 records out of 5000 total, starting on record 3321, ending on 3340

(default) 2 queries took 28 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` asc LIMIT 3320, 20202017
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