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
AG01005280  2022-11-16                              2022-11-16 10:36:27  MG00000001  2022-11-16 10:36:27  MG00000001  View Edit Delete
AG01005282  2022-11-16                              2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete
AG01005284  2022-11-16                              2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete
AG01005285  2022-11-16                              2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete
AG01005286  2022-11-16                              2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete
AG01005287  2022-11-16                              2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete
AG01005288  2022-11-16                              2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete
AG01005289  2022-11-16                              2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete
AG01005290  2022-11-16                              2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete
AG01005292  2022-11-16                              2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete
AG01005293  2022-11-16                              2022-11-16 10:39:44  MG00000001  2022-12-01 10:39:34  MG00000001  View Edit Delete
AG01005294  2022-11-16                              2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete
AG01005297  2022-11-17                              2022-11-17 09:42:27  MG00000001  2022-11-17 09:42:27  MG00000001  View Edit Delete
AG01005298  2022-11-17                              2022-11-17 09:45:46  MG00000001  2022-11-17 09:45:46  MG00000001  View Edit Delete
AG01005301  2022-11-17                              2022-11-17 11:02:36  MG00000001  2022-11-17 11:02:36  MG00000001  View Edit Delete
AG01005303  2022-11-17                              2022-11-17 14:20:36  MG00000001  2022-11-17 14:20:36  MG00000001  View Edit Delete
AG01005323  2022-11-21                              2022-11-21 09:54:45  MG00000001  2022-12-02 14:16:09  MG00000001  View Edit Delete
AG01005340  2022-11-21                              2022-11-21 10:29:56  MG00000001  2022-11-21 10:29:56  MG00000001  View Edit Delete
AG01005377  2022-11-24                              2022-11-24 11:06:27  MG00000001  2022-11-25 10:42:55  MG00000001  View Edit Delete
AG01005380  2022-11-28                              2022-11-28 00:00:00  MG00000001  2022-11-28 00:00:00  MG00000001  View Edit Delete

Page 28 of 250, showing 20 records out of 5000 total, starting on record 541, ending on 560

(default) 2 queries took 17 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` desc LIMIT 540, 2020206
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