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
AG06000963  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000964  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000965  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000966  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000967  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000968  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000969  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000970  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000971  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000972  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000973  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000974  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000975  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000976  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000977  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000978  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000979  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000980  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000981  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete
AG06000982  2021-11-25                              2021-11-25 12:48:57  MG00000001  2022-03-04 15:43:25  MG00000001  View Edit Delete

Page 126 of 250, showing 20 records out of 5000 total, starting on record 2501, ending on 2520

(default) 2 queries took 25 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 2500, 20202014
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