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
AG01003995  2020-01-29                              2020-01-29 15:12:20  MG00000003  2020-11-25 12:12:20  AG01003995  View Edit Delete
AG01004028  2020-03-13                              2020-03-13 10:24:24  MG00000003  2022-04-14 19:13:31  AG01004028  View Edit Delete
AG01000611  2017-07-27                              2016-08-30 12:23:20  MG00000002  2023-05-02 13:57:16  AG01000611  View Edit Delete
AG01000675  2017-08-01                              2016-08-30 12:23:21  MG00000002  2017-09-08 13:55:16  AG01000675  View Edit Delete
AG01000683  2017-08-01                              2016-08-30 12:23:21  MG00000002  2017-08-03 17:33:28  MG00000002  View Edit Delete
AG01000692  2017-07-27                              2016-08-30 12:23:21  MG00000002  2017-08-03 17:34:21  MG00000002  View Edit Delete
AG01000704  2017-07-27                              2016-08-30 12:23:21  MG00000002  2017-08-03 17:36:56  MG00000002  View Edit Delete
AG01000710  2017-07-27                              2016-08-30 12:23:21  MG00000002  2017-08-03 17:38:45  MG00000002  View Edit Delete
AG01000723  2017-07-27                              2016-08-30 12:23:21  MG00000002  2017-08-03 17:42:19  MG00000002  View Edit Delete
AG01000900  2017-07-27                              2016-08-30 12:23:23  MG00000002  2017-08-03 17:43:19  MG00000002  View Edit Delete
AG01001019  2017-07-27                              2016-08-30 12:23:24  MG00000002  2017-08-03 17:45:43  MG00000002  View Edit Delete
AG01001224  2017-07-27                              2016-08-30 12:23:26  MG00000002  2017-08-03 17:56:01  MG00000002  View Edit Delete
AG01001551  2017-09-25                              2016-08-30 12:23:29  MG00000002  2023-02-02 15:26:33  AG01001551  View Edit Delete
AG01001723  2017-09-25                              2016-08-30 12:23:31  MG00000002  2023-02-02 14:06:22  AG01001723  View Edit Delete
AG01001739  2017-09-25                              2016-08-30 12:23:31  MG00000002  2023-07-12 11:34:26  AG01001739  View Edit Delete
AG01001850  2017-03-15    11  4800                770-0062  徳島県徳島市不動東町5丁目457-2  090-2047-3888        2016-08-30 12:23:31  MG00000002  2018-06-09 09:54:28  MG00000002  View Edit Delete
AG01001879  2017-09-25                              2016-08-30 12:23:32  MG00000002  2023-02-02 15:32:05  AG01001879  View Edit Delete
AG01001890  2017-09-25                              2016-08-30 12:23:32  MG00000002  2023-02-02 15:23:41  AG01001890  View Edit Delete
AG01002589  2017-03-15    11  4800                770-0062  徳島県徳島市不動東町5丁目457-2  090-2047-3888          MG00000002  2018-06-09 09:55:00  MG00000002  View Edit Delete
AG01002649  2017-07-27                              2017-04-18 13:36:00  MG00000002  2017-08-03 17:56:26  MG00000002  View Edit Delete

Page 23 of 250, showing 20 records out of 5000 total, starting on record 441, ending on 460

(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`.`insert_user` desc LIMIT 440, 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