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
AG01005238  2022-11-11                              2022-11-11 10:09:38  MG00000001  2023-10-24 11:13:43  AG01005238  View Edit Delete
AG01004392  2021-03-10                              2021-03-10 13:53:41  MG00000005  2023-10-24 11:06:08  AG01004392  View Edit Delete
AG01005878  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-10-24 07:33:41  AG01005878  View Edit Delete
AG01005864  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-10-23 14:00:51  AG01005864  View Edit Delete
AG01003736  2019-06-13                              2019-06-13 10:06:34  MG00000001  2023-10-23 11:13:57  AG01003736  View Edit Delete
AG01003756  2019-07-03                              2019-07-03 13:57:55  MG00000001  2023-10-23 11:11:18  AG01003756  View Edit Delete
AG01005544  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-10-23 09:11:09  AG01005544  View Edit Delete
AG08000022  2018-10-30                              2018-10-30 09:43:24  MG00000001  2023-10-22 10:58:59  AG08000022  View Edit Delete
AG01005728  2023-09-22                              2023-09-22 00:00:00  MG00000001  2023-10-22 06:52:32  AG01005728  View Edit Delete
AG01005725  2023-09-22                              2023-09-22 00:00:00  MG00000001  2023-10-22 06:46:47  AG01005725  View Edit Delete
AG01005714  2023-09-22                              2023-09-22 00:00:00  MG00000001  2023-10-22 06:45:31  AG01005714  View Edit Delete
AG01005846  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-10-21 11:43:37  AG01005846  View Edit Delete
AG01005865  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-10-21 11:08:04  AG01005865  View Edit Delete
AG01005859  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-10-21 09:29:56  AG01005859  View Edit Delete
AG01005879  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-10-21 08:12:32  AG01005879  View Edit Delete
AG01005884  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-10-21 07:54:57  AG01005884  View Edit Delete
AG01005873  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-10-21 07:52:08  AG01005873  View Edit Delete
AG01005895  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-10-21 07:20:38  AG01005895  View Edit Delete
AG01005872  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-10-21 07:19:31  AG01005872  View Edit Delete
AG01005870  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-10-21 07:12:10  AG01005870  View Edit Delete

Page 24 of 250, showing 20 records out of 5000 total, starting on record 461, ending on 480

(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`.`modified` desc LIMIT 460, 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