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
AG01004153  2020-10-13                              2020-10-13 10:55:23  MG00000001  2021-12-08 15:24:24  AG01004153  View Edit Delete
AG01004377  2021-03-10                              2021-03-10 09:48:58  MG00000001  2021-12-08 15:46:30  AG01004377  View Edit Delete
AG01004373  2021-03-10                              2021-03-10 09:12:32  MG00000005  2021-12-10 10:23:46  AG01004373  View Edit Delete
AG01004617  2021-12-14                              2021-12-14 13:58:50  MG00000001  2021-12-14 13:58:50  MG00000001  View Edit Delete
AG01004622  2021-12-14                              2021-12-14 15:40:05  MG00000001  2021-12-14 15:40:05  MG00000001  View Edit Delete
AG01003423  2018-05-25                              2018-05-25 09:40:00  MG00000001  2021-12-16 14:39:32  AG01003423  View Edit Delete
AG02000013  2017-02-22                  771-1251  徳島県板野郡藍住町矢上字原55  090-5148-3750        2017-02-22 00:00:00  MG00000001  2021-12-16 15:04:17  AG02000013  View Edit Delete
AG02100101  2021-12-17                              2021-12-17 09:53:29  MG00000001  2021-12-20 10:06:07  AG02100101  View Edit Delete
AG01003474  2018-05-28                              2018-05-28 10:34:00  MG00000001  2021-12-23 16:58:18  AG01003474  View Edit Delete
AG01004494  2021-04-19                              2021-04-19 15:39:31  MG00000005  2021-12-24 12:57:01  AG01004494  View Edit Delete
AG01003405  2018-05-25                              2018-05-25 09:40:00  MG00000001  2021-12-24 14:34:33  AG01003405  View Edit Delete
AG01004618  2021-12-14                              2021-12-14 14:03:49  MG00000001  2021-12-25 11:14:00  AG01004618  View Edit Delete
AG01003331  2018-01-26                              2018-01-26 00:00:00  MG00000001  2021-12-26 15:55:24  AG01003331  View Edit Delete
AG02100100  2021-12-01                              2021-12-01 15:55:20  MG00000001  2021-12-26 17:25:23  AG02100100  View Edit Delete
AG01004314  2021-01-27                              2021-01-27 09:21:52  MG00000005  2021-12-28 14:50:01  AG01004314  View Edit Delete
AG02000115  2018-10-24                              2018-10-24 10:20:33  MG00000001  2022-01-04 16:26:49  AG02000115  View Edit Delete
AG02000112  2018-10-09                              2018-10-09 09:17:42  MG00000001  2022-01-04 16:27:02  AG02000112  View Edit Delete
AG02000108  2018-08-16                              2018-08-16 12:47:48  MG00000001  2022-01-04 16:27:16  AG02000108  View Edit Delete
AG02000107  2018-08-16                              2018-08-16 12:47:06  MG00000001  2022-01-04 16:27:27  AG02000107  View Edit Delete
AG02000105  2018-07-11                              2018-07-11 10:08:24  MG00000001  2022-01-04 16:27:36  AG02000105  View Edit Delete

Page 75 of 250, showing 20 records out of 5000 total, starting on record 1481, ending on 1500

(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` asc LIMIT 1480, 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