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
AG06000098  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000099  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000100  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000101  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000102  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000103  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000104  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000105  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000106  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000107  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000108  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000109  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000110  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000111  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000112  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000113  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000114  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000115  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000116  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000117  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  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 18 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`.`user_address` asc LIMIT 1000, 2020207
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