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
AG01001929  2017-09-25                              2016-08-30 12:23:32  MG00000001  2023-02-02 15:42:06  AG01001929  View Edit Delete
AG01001556  2017-09-25                              2016-08-30 12:23:29  MG00000001  2023-02-02 15:41:46  AG01001556  View Edit Delete
AG01004719  2022-05-25                              2022-05-25 11:14:11  MG00000001  2023-02-02 15:39:19  AG01004719  View Edit Delete
AG01005415  2023-01-26                              2023-01-26 00:00:00  MG00000001  2023-02-02 15:38:52  AG01005415  View Edit Delete
AG01001910  2017-09-25                              2016-08-30 12:23:32  MG00000001  2023-02-02 15:37:17  AG01001910  View Edit Delete
AG01005424  2023-01-26                              2023-01-26 00:00:00  MG00000001  2023-02-02 15:36:42  AG01005424  View Edit Delete
AG01001765  2017-09-25                              2016-08-30 12:23:31  MG00000001  2023-02-02 15:36:24  AG01001765  View Edit Delete
AG01001252  2017-09-25                  771-3310  徳島県名西郡神山町神領字本上角152番地  09030502261        2016-08-30 12:23:26  MG00000001  2023-02-02 15:36:03  AG01001252  View Edit Delete
AG01004564  2021-07-26                              2021-07-26 12:18:36  MG00000001  2023-02-02 15:35:46  AG01004564  View Edit Delete
AG01004353  2021-03-09                              2021-03-09 09:45:40  MG00000001  2023-02-02 15:35:30  AG01004353  View Edit Delete
AG01004716  2022-05-25                              2022-05-25 10:54:04  MG00000001  2023-02-02 15:35:12  AG01004716  View Edit Delete
AG01001888  2017-09-25                  779-3112  徳島県徳島市国府町芝原字橋本28  080-5577-9747        2016-08-30 12:23:32  MG00000001  2023-02-02 15:34:50  AG01001888  View Edit Delete
AG01001270  2017-09-25                              2016-08-30 12:23:26  MG00000001  2023-02-02 15:32:58  AG01001270  View Edit Delete
AG01001879  2017-09-25                              2016-08-30 12:23:32  MG00000002  2023-02-02 15:32:05  AG01001879  View Edit Delete
AG01005411  2023-01-26                              2023-01-26 00:00:00  MG00000001  2023-02-02 15:31:47  AG01005411  View Edit Delete
AG01004031  2020-03-31                              2020-03-31 15:54:55  MG00000001  2023-02-02 15:31:28  AG01004031  View Edit Delete
AG01005306  2022-11-17                              2022-11-17 14:29:21  MG00000001  2023-02-02 15:31:06  AG01005306  View Edit Delete
AG01001647  2017-09-25                              2016-08-30 12:23:30  MG00000001  2023-02-02 15:30:31  AG01001647  View Edit Delete
AG01004713  2022-05-25                              2022-05-25 10:02:00  MG00000001  2023-02-02 15:30:13  AG01004713  View Edit Delete
AG01005429  2023-01-26                              2023-01-26 00:00:00  MG00000001  2023-02-02 15:29:54  AG01005429  View Edit Delete

Page 72 of 250, showing 20 records out of 5000 total, starting on record 1421, ending on 1440

(default) 2 queries took 21 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 1420, 20202010
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