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
AG01003864  2019-08-08                              2019-08-08 11:15:26  MG00000001  2019-08-08 11:15:26  MG00000001  View Edit Delete
AG01003866  2019-08-08                              2019-08-08 11:25:51  MG00000001  2019-08-08 11:25:51  MG00000001  View Edit Delete
AG01003867  2019-08-08                              2019-08-08 11:27:19  MG00000001  2019-08-08 11:27:19  MG00000001  View Edit Delete
AG01003868  2019-08-08                              2019-08-08 11:28:53  MG00000001  2019-08-08 11:28:53  MG00000001  View Edit Delete
AG01003869  2019-08-08                              2019-08-08 11:36:18  MG00000001  2019-08-08 11:36:18  MG00000001  View Edit Delete
AG01003870  2019-08-08                              2019-08-08 11:41:18  MG00000001  2019-08-08 11:41:18  MG00000001  View Edit Delete
AG01003871  2019-08-08                              2019-08-08 11:43:04  MG00000001  2019-08-08 11:43:04  MG00000001  View Edit Delete
AG01003872  2019-08-08                              2019-08-08 11:44:12  MG00000001  2019-08-08 11:44:12  MG00000001  View Edit Delete
AG01003873  2019-08-08                              2019-08-08 11:48:36  MG00000001  2019-08-08 11:48:36  MG00000001  View Edit Delete
AG01003875  2019-08-08                              2019-08-08 11:54:03  MG00000001  2019-08-08 11:54:03  MG00000001  View Edit Delete
AG01003876  2019-08-08                              2019-08-08 12:00:11  MG00000001  2019-08-08 12:00:11  MG00000001  View Edit Delete
AG01003880  2019-08-08                              2019-08-08 12:13:43  MG00000001  2019-08-08 12:13:43  MG00000001  View Edit Delete
AG01003882  2019-08-08                              2019-08-08 12:23:06  MG00000001  2019-08-08 12:23:06  MG00000001  View Edit Delete
AG02100075  2019-07-12                              2019-07-12 10:00:16  MG00000001  2019-08-10 07:47:24  AG02100075  View Edit Delete
AG01003004  2017-06-22    貸し出し用機材  貸し出し用機材                          MG00000001  2019-08-12 16:48:13  AG01003004  View Edit Delete
AG01003001  2017-05-18    貸し出し用機材  貸し出し用機材                          MG00000001  2019-08-12 16:48:25  AG01003001  View Edit Delete
AG01003002  2017-05-24    貸し出し用機材  貸し出し用機材                          MG00000001  2019-08-12 16:48:35  AG01003002  View Edit Delete
AG01003691  2019-04-10                              2019-04-10 13:47:24  MG00000001  2019-08-13 10:07:24  AG01003691  View Edit Delete
AG05000070  2017-11-01                  336-0972  埼玉県さいたま市緑区          2017-11-01 11:34:46  MG00000001  2019-08-23 13:10:12  AG05000070  View Edit Delete
AG02000040  2017-06-29                              2017-02-22 00:00:00  MG00000002  2019-08-24 14:23:57  AG02000040  View Edit Delete

Page 39 of 250, showing 20 records out of 5000 total, starting on record 761, ending on 780

(default) 2 queries took 19 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 760, 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 = 11112