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
AG03000034  2022-10-17                              2022-10-17 13:52:04  MG00000001  2022-10-26 09:26:01  AG03000034  View Edit Delete
AG01005192  2022-10-13                              2022-10-13 15:28:14  MG00000001  2023-06-09 14:52:22  AG01005192  View Edit Delete
AG01005193  2022-10-13                              2022-10-13 15:29:56  MG00000001  2023-04-26 15:18:41  AG01005193  View Edit Delete
AG01005194  2022-10-13                              2022-10-13 15:50:03  MG00000001  2023-01-07 13:20:54  AG01005194  View Edit Delete
AG01005191  2022-10-12                              2022-10-12 14:02:12  MG00000001  2022-10-18 15:56:38  AG01005191  View Edit Delete
AG01005175  2022-10-11                              2022-10-11 10:07:27  MG00000001  2023-04-01 14:50:28  AG01005175  View Edit Delete
AG01005176  2022-10-11                              2022-10-11 10:10:34  MG00000001  2024-01-18 12:37:36  AG01005176  View Edit Delete
AG01005177  2022-10-11                              2022-10-11 10:12:55  MG00000001  2023-11-04 07:11:02  AG01005177  View Edit Delete
AG01005178  2022-10-11                              2022-10-11 10:14:40  MG00000001  2023-05-26 15:12:26  AG01005178  View Edit Delete
AG01005179  2022-10-11                              2022-10-11 10:15:56  MG00000001  2023-04-04 19:51:01  AG01005179  View Edit Delete
AG01005180  2022-10-11                              2022-10-11 10:18:23  MG00000001  2023-04-02 18:55:49  AG01005180  View Edit Delete
AG01005181  2022-10-11                              2022-10-11 10:20:09  MG00000001  2023-07-09 15:25:41  AG01005181  View Edit Delete
AG01005182  2022-10-11                              2022-10-11 10:24:52  MG00000001  2023-04-25 12:04:38  AG01005182  View Edit Delete
AG01005183  2022-10-11                              2022-10-11 10:33:04  MG00000001  2023-04-16 10:53:50  AG01005183  View Edit Delete
AG01005184  2022-10-11                              2022-10-11 10:38:27  MG00000001  2023-03-31 10:03:59  AG01005184  View Edit Delete
AG01005185  2022-10-11                              2022-10-11 10:41:36  MG00000001  2023-12-12 13:37:18  AG01005185  View Edit Delete
AG01005186  2022-10-11                              2022-10-11 10:43:17  MG00000001  2023-10-12 13:59:47  AG01005186  View Edit Delete
AG01005187  2022-10-11                              2022-10-11 10:47:23  MG00000001  2023-04-05 17:45:23  AG01005187  View Edit Delete
AG01005188  2022-10-11                              2022-10-11 10:50:02  MG00000001  2023-06-20 13:57:41  AG01005188  View Edit Delete
AG01005189  2022-10-11                              2022-10-11 10:52:12  MG00000001  2023-03-29 17:36:43  AG01005189  View Edit Delete

Page 45 of 250, showing 20 records out of 5000 total, starting on record 881, ending on 900

(default) 2 queries took 18 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`.`agreement_start_day` desc LIMIT 880, 2020207
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