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
AG01004927  2022-07-29                              2022-07-29 09:42:56  MG00000001  2022-07-29 09:42:56  MG00000001  View Edit Delete
AG01004928  2022-07-29                              2022-07-29 09:42:56  MG00000001  2022-07-29 09:42:56  MG00000001  View Edit Delete
AG01004929  2022-07-29                              2022-07-29 09:42:56  MG00000001  2023-03-28 14:07:05  MG00000001  View Edit Delete
AG01004931  2022-07-29                              2022-07-29 09:42:56  MG00000001  2022-07-29 09:42:56  MG00000001  View Edit Delete
AG01004932  2022-07-29                              2022-07-29 09:42:56  MG00000001  2022-07-29 09:42:56  MG00000001  View Edit Delete
AG01004936  2022-08-02                              2022-08-02 09:43:11  MG00000001  2022-08-02 09:43:11  MG00000001  View Edit Delete
AG01004938  2022-08-05                              2022-08-05 15:06:38  MG00000001  2022-08-05 15:06:38  MG00000001  View Edit Delete
AG01004991  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-01-12 10:27:13  MG00000001  View Edit Delete
AG01005032  2022-08-22                              2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005047  2022-08-22                              2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005081  2022-08-22                              2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005106  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-03-30 11:10:13  MG00000001  View Edit Delete
AG01005144  2022-09-13                              2022-09-13 09:43:00  MG00000001  2023-02-06 11:11:10  MG00000001  View Edit Delete
AG01005151  2022-09-14                              2022-09-14 14:36:28  MG00000001  2022-09-14 14:36:28  MG00000001  View Edit Delete
AG01005168  2022-10-03                              2022-10-03 10:27:27  MG00000001  2022-10-03 10:27:27  MG00000001  View Edit Delete
AG01005197  2022-10-18                              2022-10-18 08:58:23  MG00000001  2023-03-24 11:04:06  MG00000001  View Edit Delete
AG01005212  2022-10-19                              2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005241  2022-11-11                              2022-11-11 10:09:38  MG00000001  2022-11-11 10:09:38  MG00000001  View Edit Delete
AG01005243  2022-11-11                              2022-11-11 10:09:38  MG00000001  2022-11-11 10:09:38  MG00000001  View Edit Delete
AG01005245  2022-11-11                              2022-11-11 10:09:38  MG00000001  2022-11-11 10:09:38  MG00000001  View Edit Delete

Page 170 of 250, showing 20 records out of 5000 total, starting on record 3381, ending on 3400

(default) 2 queries took 29 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 3380, 20202018
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