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
AG06001106  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001107  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001108  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001109  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001110  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001111  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001112  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001113  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001114  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001115  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001116  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001117  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001118  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001119  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001120  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001121  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001122  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001123  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001124  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06001125  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete

Page 102 of 250, showing 20 records out of 5000 total, starting on record 2021, ending on 2040

(default) 2 queries took 22 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_post_number` asc LIMIT 2020, 20202011
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