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
AG05000119  2019-08-26                              2019-08-26 08:34:08  MG00000001  2021-06-11 14:34:05  AG05000119  View Edit Delete
AG05000118  2019-06-24                              2019-06-24 09:35:35  MG00000001  2021-05-22 14:55:12  AG05000118  View Edit Delete
AG05000117  2019-06-17                              2019-06-17 08:39:17  MG00000001  2021-05-26 13:24:25  AG05000117  View Edit Delete
AG05000116  2019-05-29                              2019-05-29 11:11:12  MG00000001  2021-06-01 14:08:14  AG05000116  View Edit Delete
AG05000115  2019-04-12                              2019-04-12 10:24:01  MG00000001  2019-04-24 14:12:35  AG05000115  View Edit Delete
AG05000114  2019-03-29                              2019-03-29 11:44:54  MG00000001  2022-01-09 12:01:01  AG05000114  View Edit Delete
AG05000113  2019-03-04                              2019-03-04 15:14:17  MG00000001  2022-04-26 14:24:08  AG05000113  View Edit Delete
AG05000112  2019-02-28                              2019-02-28 09:17:41  MG00000001  2019-02-28 15:49:21  AG05000112  View Edit Delete
AG05000111  2019-02-14                              2019-02-14 09:35:47  MG00000001  2021-03-31 13:31:49  AG05000111  View Edit Delete
AG05000110  2018-11-28                              2018-11-28 09:43:36  MG00000001  2018-12-03 15:13:57  AG05000110  View Edit Delete
AG05000109  2018-11-05                              2018-11-05 09:23:15  MG00000001  2018-11-06 15:23:03  AG05000109  View Edit Delete
AG05000108  2018-11-05                              2018-11-05 09:22:14  MG00000001  2018-11-05 18:22:43  AG05000108  View Edit Delete
AG05000107  2018-11-02                              2018-11-02 10:31:09  MG00000001  2021-04-02 14:39:51  AG05000107  View Edit Delete
AG05000106  2018-10-22                              2018-10-22 14:27:58  MG00000005  2021-03-29 14:29:33  AG05000106  View Edit Delete
AG05000105  2018-07-30                              2018-07-30 14:35:37  MG00000001  2021-03-29 13:51:31  AG05000105  View Edit Delete
AG05000104  2018-06-04                              2018-06-04 09:03:53  MG00000001  2018-06-19 14:23:20  AG05000104  View Edit Delete
AG05000103  2018-05-24                              2018-05-24 09:12:08  MG00000001  2018-06-19 14:23:07  AG05000103  View Edit Delete
AG05000102  2018-04-13                    埼玉県          2018-04-13 11:34:46  MG00000001  2018-04-26 13:23:22  AG05000102  View Edit Delete
AG05000101  2018-03-15                    埼玉県白岡市          2018-03-15 11:34:46  MG00000001  2018-03-16 16:50:44  AG05000101  View Edit Delete
AG05000100  2018-01-24                    千葉県野田市          2018-01-24 11:34:46  MG00000001  2018-11-02 10:58:57  AG05000100  View Edit Delete

Page 107 of 250, showing 20 records out of 5000 total, starting on record 2121, ending on 2140

(default) 2 queries took 24 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`.`update_user` desc LIMIT 2120, 20202013
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