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
AG06000002  2022-03-04                              2022-03-04 15:42:45  MG00000001  2022-03-15 10:43:38  AG06000002  View Edit Delete
AG05000138  2021-07-27                              2021-07-27 14:42:40  MG00000001  2021-11-19 14:11:32  AG05000138  View Edit Delete
AG05000137  2021-05-06                              2021-05-06 09:35:56  MG00000005  2021-06-05 16:34:10  AG05000137  View Edit Delete
AG05000136  2021-04-12                              2021-04-12 17:35:53  MG00000005  2021-05-28 10:29:47  AG05000136  View Edit Delete
AG05000135  2020-12-09                              2020-12-09 14:53:48  MG00000005  2021-05-24 16:56:14  AG05000135  View Edit Delete
AG05000134  2020-11-17                              2020-11-17 09:50:16  MG00000005  2021-05-28 10:29:56  AG05000134  View Edit Delete
AG05000133  2020-09-17                              2020-09-17 19:22:47  MG00000005  2021-04-01 14:28:24  AG05000133  View Edit Delete
AG05000132  2020-09-15                              2020-09-15 19:53:45  MG00000005  2021-07-12 14:09:00  AG05000132  View Edit Delete
AG05000131  2020-09-10                              2020-09-10 17:12:18  MG00000005  2021-04-12 14:11:57  AG05000131  View Edit Delete
AG05000130  2020-08-27                              2020-08-27 10:30:06  MG00000005  2021-07-12 14:08:42  AG05000130  View Edit Delete
AG05000129  2020-08-24                              2020-08-24 09:19:15  MG00000005  2020-09-17 13:23:02  AG05000129  View Edit Delete
AG05000128  2020-07-20                              2020-07-20 11:05:23  MG00000005  2020-07-20 14:26:19  AG05000128  View Edit Delete
AG05000127  2020-07-13                              2020-07-13 14:13:39  MG00000005  2021-10-11 15:33:43  AG05000127  View Edit Delete
AG05000126  2020-07-01                              2020-07-01 13:48:19  MG00000005  2021-05-24 16:56:26  AG05000126  View Edit Delete
AG05000125  2020-05-28                              2020-05-28 09:04:27  MG00000001  2021-05-24 16:57:47  AG05000125  View Edit Delete
AG05000124  2020-03-04                              2020-03-04 08:48:34  MG00000001  2021-04-02 16:06:15  AG05000124  View Edit Delete
AG05000123  2020-02-19                              2020-02-19 14:09:36  MG00000001  2020-02-21 09:50:41  AG05000123  View Edit Delete
AG05000122  2019-12-17                              2019-12-17 08:37:42  MG00000001  2021-05-28 10:34:23  AG05000122  View Edit Delete
AG05000121  2019-11-18                              2019-11-18 12:50:53  MG00000001  2019-11-19 13:47:13  AG05000121  View Edit Delete
AG05000120  2019-09-30                              2019-09-30 14:14:04  MG00000001  2020-02-20 09:13:01  AG05000120  View Edit Delete

Page 106 of 250, showing 20 records out of 5000 total, starting on record 2101, ending on 2120

(default) 2 queries took 23 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 2100, 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 = 11110