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
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
AG05000052  2017-11-01                  337-0003  埼玉県さいたま市見沼区          2017-11-01 11:34:46  MG00000002  2018-04-29 20:46:40  AG05000052  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
AG05000058  2017-11-01                  337-0011  埼玉県さいたま市見沼区          2017-11-01 11:34:46  MG00000001  2017-12-13 14:10:42  AG05000058  View Edit Delete
AG05000059  2017-11-01                  336-0911  埼玉県さいたま市緑区          2017-11-01 11:34:46  MG00000001  2018-03-23 16:31:59  AG05000059  View Edit Delete
AG05000060  2017-11-01                  349-0221  埼玉県白岡市          2017-11-01 11:34:46  MG00000001  2019-09-05 13:26:44  MG00000001  View Edit Delete

Page 141 of 250, showing 20 records out of 5000 total, starting on record 2801, ending on 2820

(default) 2 queries took 25 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`.`plain_password` asc LIMIT 2800, 20202014
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