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
AG02000049  2017-09-06                              2017-02-22 00:00:00  MG00000001  2020-06-30 11:20:54  AG02000049  View Edit Delete
AG01003658  2019-02-19                              2019-02-19 09:40:18  MG00000001  2020-07-03 13:27:19  AG01003658  View Edit Delete
AG01003632  2018-10-30                              2018-10-30 11:09:39  MG00000001  2020-07-03 13:34:06  AG01003632  View Edit Delete
AG01003412  2018-05-25                              2018-05-25 09:40:00  MG00000001  2020-07-05 16:09:38  AG01003412  View Edit Delete
AG03000027  2018-03-20                                MG00000001  2020-07-07 16:58:41  AG03000027  View Edit Delete
AG03000007  2018-03-20                                MG00000001  2020-07-08 06:59:53  AG03000007  View Edit Delete
AG03000014  2018-03-20                                MG00000001  2020-07-08 07:04:42  AG03000014  View Edit Delete
AG03000018  2018-03-20                                MG00000001  2020-07-08 09:03:27  AG03000018  View Edit Delete
AG03000008  2018-03-20                                MG00000001  2020-07-09 07:39:09  AG03000008  View Edit Delete
AG01004089  2020-07-06                              2020-07-06 11:02:52  MG00000005  2020-07-09 07:48:15  AG01004089  View Edit Delete
AG02100093  2020-07-03                              2020-07-03 17:00:58  MG00000005  2020-07-09 14:22:01  AG02100093  View Edit Delete
AG03000013  2018-03-20                                MG00000001  2020-07-10 08:59:18  AG03000013  View Edit Delete
AG01003841  2019-08-08                              2019-08-08 08:40:58  MG00000001  2020-07-11 08:14:25  AG01003841  View Edit Delete
AG01004090  2020-07-13                              2020-07-13 10:17:45  MG00000005  2020-07-13 10:17:45  MG00000005  View Edit Delete
AG01004091  2020-07-13                              2020-07-13 10:21:01  MG00000005  2020-07-13 10:21:01  MG00000005  View Edit Delete
AG03000028  2018-03-20                                MG00000001  2020-07-14 10:12:26  AG03000028  View Edit Delete
AG01003759  2019-07-03                              2019-07-03 14:58:03  MG00000005  2020-07-15 09:16:37  MG00000005  View Edit Delete
AG01004097  2020-07-14                              2020-07-14 16:59:52  MG00000005  2020-07-17 10:57:38  AG01004097  View Edit Delete
AG05000128  2020-07-20                              2020-07-20 11:05:23  MG00000005  2020-07-20 14:26:19  AG05000128  View Edit Delete
AG02100091  2020-06-17                              2020-06-17 15:20:06  MG00000005  2020-07-21 13:09:53  AG02100091  View Edit Delete

Page 51 of 250, showing 20 records out of 5000 total, starting on record 1001, ending on 1020

(default) 2 queries took 21 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 1000, 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 = 11112