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

Page 158 of 250, showing 20 records out of 5000 total, starting on record 3141, ending on 3160

(default) 2 queries took 27 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`.`insert_user` asc LIMIT 3140, 20202016
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