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
AG01001583  2017-09-25                              2016-08-30 12:23:29  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001584  2017-09-25                              2016-08-30 12:23:29  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001699  2017-09-25                              2016-08-30 12:23:30  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001718  2017-09-25                              2016-08-30 12:23:30  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001721  2017-09-25                              2016-08-30 12:23:30  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001740  2017-09-25                              2016-08-30 12:23:31  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001762  2017-09-25                              2016-08-30 12:23:31  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001772  2017-09-25                              2016-08-30 12:23:31  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001774  2017-09-25                              2016-08-30 12:23:31  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001831  2017-09-25                              2016-08-30 12:23:31  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001837  2017-09-25                              2016-08-30 12:23:31  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001860  2017-09-25                              2016-08-30 12:23:31  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001866  2017-09-25                              2016-08-30 12:23:32  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001906  2017-09-25                              2016-08-30 12:23:32  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001911  2017-09-25                              2016-08-30 12:23:32  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001926  2017-09-25                              2016-08-30 12:23:32  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001927  2017-09-25                              2016-08-30 12:23:32  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001928  2017-09-25                              2016-08-30 12:23:32  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001931  2017-09-25                              2016-08-30 12:23:32  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete
AG01001932  2017-09-25                              2016-08-30 12:23:32  MG00000001  2017-09-25 11:25:04  MG00000001  View Edit Delete

Page 153 of 250, showing 20 records out of 5000 total, starting on record 3041, ending on 3060

(default) 2 queries took 27 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` asc LIMIT 3040, 20202016
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