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
AG01004379  2021-03-10                              2021-03-10 10:00:48  MG00000005  2023-07-20 10:46:11  AG01004379  View Edit Delete
AG01001918  2017-10-01    6800                779-3222  徳島県名西郡石井町高河原字市楽365-4  090-3187-8596      79878042  2016-08-30 12:23:32  MG00000001  2023-07-20 10:46:04  AG01001918  View Edit Delete
AG01005319  2022-11-21                              2022-11-21 09:54:45  MG00000001  2023-07-20 02:57:05  AG01005319  View Edit Delete
AG01005338  2022-11-21                              2022-11-21 09:54:45  MG00000001  2023-07-20 02:49:08  AG01005338  View Edit Delete
AG01005336  2022-11-21                              2022-11-21 09:54:45  MG00000001  2023-07-20 02:47:04  AG01005336  View Edit Delete
AG06000012  2021-11-25                              2021-11-25 12:48:57  MG00000001  2023-07-19 13:05:43  AG06000012  View Edit Delete
AG01001278  2017-09-25                              2016-08-30 12:23:26  MG00000001  2023-07-19 11:28:26  AG01001278  View Edit Delete
AG01001995  2017-09-27    5500                  香川県三豊市高瀬町比地3441  0875-82-6280        2016-08-30 12:23:32  MG00000001  2023-07-19 10:32:05  AG01001995  View Edit Delete
AG08000068  2023-07-18                              2023-07-18 09:13:57  MG00000001  2023-07-18 09:13:57  MG00000001  View Edit Delete
AG01005051  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-07-17 14:41:41  AG01005051  View Edit Delete
AG01005057  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-07-17 14:41:26  AG01005057  View Edit Delete
AG01005069  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-07-17 14:41:08  AG01005069  View Edit Delete
AG01005070  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-07-17 14:40:59  AG01005070  View Edit Delete
AG01005471  2023-04-27                              2023-04-27 00:00:00  MG00000001  2023-07-17 10:38:24  AG01005471  View Edit Delete
AG01004944  2022-08-08                              2022-08-08 15:29:04  MG00000001  2023-07-17 10:23:13  AG01004944  View Edit Delete
AG01005615  2023-07-14                              2023-07-14 00:00:00  MG00000001  2023-07-17 10:12:26  AG01005615  View Edit Delete
AG01005013  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-07-16 16:26:10  AG01005013  View Edit Delete
AG08000039  2020-06-05                              2020-06-05 09:05:20  MG00000001  2023-07-15 07:18:49  AG08000039  View Edit Delete
AG01004630  2022-02-04                              2022-02-04 09:02:57  MG00000001  2023-07-14 19:00:11  AG01004630  View Edit Delete
AG01001271  2017-09-25                              2016-08-30 12:23:26  MG00000001  2023-07-14 17:02:56  AG01001271  View Edit Delete

Page 48 of 250, showing 20 records out of 5000 total, starting on record 941, ending on 960

(default) 2 queries took 20 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 940, 2020209
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