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
AG05000037  2017-11-01                  337-0011  埼玉県さいたま市見沼区          2017-11-01 11:34:46  MG00000001  2017-12-08 15:37:17  AG05000037  View Edit Delete
AG05000038  2017-11-01                  270-0223  千葉県野田市岡田767          2017-11-01 11:34:46  MG00000001  2017-12-27 13:43:16  AG05000038  View Edit Delete
AG05000039  2017-11-01                  337-0026  埼玉県さいたま市見沼区          2017-11-01 11:34:46  MG00000001  2018-04-07 13:37:34  AG05000039  View Edit Delete
AG05000040  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-01-18 11:16:28  AG05000040  View Edit Delete
AG05000041  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-03-17 14:50:24  AG05000041  View Edit Delete
AG05000042  2017-11-01                  344-0106  埼玉県春日部市          2017-11-01 11:34:46  MG00000001  2020-02-29 12:41:56  AG05000042  View Edit Delete
AG05000043  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-05-04 13:51:29  AG05000043  View Edit Delete
AG05000044  2017-11-01                  278-0015  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-04-27 13:51:55  AG05000044  View Edit Delete
AG05000045  2017-11-01                  278-0015  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-06-24 15:53:36  AG05000045  View Edit Delete
AG05000046  2017-11-01                  336-0971  埼玉県さいたま市緑区          2017-11-01 11:34:46  MG00000001  2018-06-26 13:31:58  AG05000046  View Edit Delete
AG05000047  2017-11-01                  278-0003  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-01-18 11:17:10  AG05000047  View Edit Delete
AG05000048  2017-11-01                  349-0133  埼玉県蓮田市          2017-11-01 11:34:46  MG00000001  2017-12-08 15:47:37  AG05000048  View Edit Delete
AG05000049  2017-11-01                  344-0133  埼玉県春日部市          2017-11-01 11:34:46  MG00000001  2018-06-26 13:56:25  MG00000001  View Edit Delete
AG05000050  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-01-24 13:34:20  AG05000050  View Edit Delete
AG05000051  2017-11-01                  349-0226  埼玉県白岡市          2017-11-01 11:34:46  MG00000001  2018-11-12 16:26:47  AG05000051  View Edit Delete
AG05000053  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-05-07 16:12:13  AG05000053  View Edit Delete
AG05000054  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-01-25 12:59:43  AG05000054  View Edit Delete
AG05000055  2017-11-01                  345-0811  埼玉県埼玉郡宮代町          2017-11-01 11:34:46  MG00000001  2018-06-12 16:11:04  AG05000055  View Edit Delete
AG05000056  2017-11-01                  270-0221  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-11-09 09:34:22  AG05000056  View Edit Delete
AG05000057  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2020-05-07 11:29:27  MG00000001  View Edit Delete

Page 155 of 250, showing 20 records out of 5000 total, starting on record 3081, ending on 3100

(default) 2 queries took 27 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` asc LIMIT 3080, 20202016
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