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
AG01003811  2019-08-01                              2019-08-01 09:16:47  MG00000001  2019-12-05 09:25:15  AG01003811  View Edit Delete
AG01003351  2018-01-26                              2018-01-26 00:00:00  MG00000001  2019-12-03 17:43:16  AG01003351  View Edit Delete
AG01003916  2019-11-22                              2019-11-22 16:58:02  MG00000001  2019-12-02 15:32:49  AG01003916  View Edit Delete
AG01003917  2019-11-22                              2019-11-22 16:59:10  MG00000001  2019-12-02 15:12:09  AG01003917  View Edit Delete
AG01003918  2019-11-22                              2019-11-22 17:01:02  MG00000001  2019-12-02 15:09:03  AG01003918  View Edit Delete
AG01003919  2019-11-22                              2019-11-22 17:02:08  MG00000001  2019-12-02 14:32:50  AG01003919  View Edit Delete
AG01003730  2019-06-13                              2019-06-13 09:43:06  MG00000001  2019-11-26 17:21:04  AG01003730  View Edit Delete
AG01003454  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-11-26 10:13:53  AG01003454  View Edit Delete
AG01003443  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-11-25 18:45:34  AG01003443  View Edit Delete
AG02000045  2017-09-05                              2017-02-22 00:00:00  MG00000001  2019-11-25 14:36:48  AG02000045  View Edit Delete
AG02000111  2018-09-21                              2018-09-21 12:53:17  MG00000001  2019-11-25 14:32:21  AG02000111  View Edit Delete
AG01003473  2018-05-28                              2018-05-28 10:31:52  MG00000001  2019-11-21 22:28:32  AG01003473  View Edit Delete
AG01003548  2018-07-09                              2018-07-09 14:01:14  MG00000001  2019-11-21 22:28:13  AG01003548  View Edit Delete
AG05000121  2019-11-18                              2019-11-18 12:50:53  MG00000001  2019-11-19 13:47:13  AG05000121  View Edit Delete
AG01003704  2019-04-24                              2019-04-24 10:55:46  MG00000001  2019-11-16 14:25:43  AG01003704  View Edit Delete
AG01003014  2017-09-01    貸し出し用機材  貸し出し用機材                          AG01003014  2019-11-16 14:16:40  AG01003014  View Edit Delete
AG01003578  2018-07-31                              2018-07-31 13:33:58  MG00000001  2019-11-15 12:06:32  AG01003578  View Edit Delete
AG01003655  2019-02-08                              2019-02-08 13:23:08  MG00000001  2019-11-14 21:57:27  AG01003655  View Edit Delete
AG01002759  2017-04-24    貸し出し用機材  貸し出し用機材                        2017-04-18 13:36:00  MG00000001  2019-11-14 21:43:05  AG01002759  View Edit Delete
AG01003562  2018-07-24                              2018-07-24 14:54:36  MG00000001  2019-11-14 21:35:53  AG01003562  View Edit Delete

Page 207 of 250, showing 20 records out of 5000 total, starting on record 4121, ending on 4140

(default) 2 queries took 31 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 4120, 20202020
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