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
AG01003776  2019-07-31                              2019-07-31 14:00:36  MG00000001  2021-06-14 08:56:25  AG01003776  View Edit Delete
AG02000026  2017-02-22                      090-8974-9265        2017-02-22 00:00:00  MG00000002  2021-06-14 14:01:41  AG02000026  View Edit Delete
AG02000071  2018-02-05                              2018-02-05 10:34:30  MG00000001  2021-06-16 09:53:00  AG02000071  View Edit Delete
AG01004147  2020-09-29                              2020-09-29 11:31:30  MG00000005  2021-06-17 16:18:06  AG01004147  View Edit Delete
AG05000067  2017-11-01                  337-0051  埼玉県さいたま市見沼区          2017-11-01 11:34:46  MG00000001  2021-06-18 16:09:12  AG05000067  View Edit Delete
AG01004441  2021-03-19                              2021-03-19 18:27:50  MG00000005  2021-06-18 21:44:16  AG01004441  View Edit Delete
AG02100027  2018-02-09                              2018-02-09 00:00:00  MG00000001  2021-06-19 13:19:08  AG02100027  View Edit Delete
AG02100099  2021-05-10                              2021-05-10 14:03:24  MG00000001  2021-06-21 09:34:19  AG02100099  View Edit Delete
AG02000017  2017-02-22                  779-1109  徳島県阿南市山口町末広89-1  090-7781-3056        2017-02-22 00:00:00  MG00000002  2021-06-21 13:06:09  AG02000017  View Edit Delete
AG01003414  2018-05-25                              2018-05-25 09:40:00  MG00000001  2021-06-21 18:27:30  AG01003414  View Edit Delete
AG01003430  2018-05-25                              2018-05-25 09:40:00  MG00000001  2021-06-22 15:36:04  AG01003430  View Edit Delete
AG01004515  2021-05-18                              2021-05-18 18:17:36  MG00000005  2021-06-25 13:08:07  AG01004515  View Edit Delete
AG01004306  2021-01-22                              2021-01-22 15:53:19  MG00000005  2021-06-27 11:05:18  AG01004306  View Edit Delete
AG01003630  2018-10-19                              2018-10-19 12:42:27  MG00000001  2021-06-28 14:08:06  AG01003630  View Edit Delete
AG01003622  2018-08-02                              2018-08-02 15:23:53  MG00000001  2021-07-02 10:06:10  AG01003622  View Edit Delete
AG01004546  2021-07-02                              2021-07-02 10:53:38  MG00000001  2021-07-02 10:53:38  MG00000001  View Edit Delete
AG01004243  2021-01-20                              2021-01-20 09:06:42  MG00000005  2021-07-05 19:10:24  AG01004243  View Edit Delete
AG01003719  2019-05-20                              2019-05-20 13:58:09  MG00000001  2021-07-06 08:53:26  AG01003719  View Edit Delete
AG01003721  2019-05-20                              2019-05-20 14:03:19  MG00000001  2021-07-06 09:17:36  AG01003721  View Edit Delete

Page 68 of 250, showing 20 records out of 5000 total, starting on record 1341, ending on 1360

(default) 2 queries took 20 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 1340, 2020209
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