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
AG05000083  2017-11-01                  331-0823  埼玉県さいたま市北区          2017-11-01 11:34:46  MG00000001  2019-08-30 14:32:52  AG05000083  View Edit Delete
AG05000065  2017-11-01                  331-0047  埼玉県さいたま市西区          2017-11-01 11:34:46  MG00000001  2019-07-22 15:39:03  AG05000065  View Edit Delete
AG05000018  2017-11-01                  287-0214  千葉県成田市          2017-11-01 11:34:46  MG00000001  2018-08-11 14:48:38  AG05000018  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
AG05000047  2017-11-01                  278-0003  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-01-18 11:17:10  AG05000047  View Edit Delete
AG05000073  2017-11-01                  278-0001  千葉県野田市          2017-11-01 11:34:46  MG00000001  2017-12-11 14:33:44  AG05000073  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
AG05000021  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-07-03 13:58:21  AG05000021  View Edit Delete
AG05000022  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-01-29 13:57:18  AG05000022  View Edit Delete
AG05000024  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2019-04-08 13:32:07  AG05000024  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
AG05000043  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-05-04 13:51:29  AG05000043  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
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
AG05000057  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2020-05-07 11:29:27  MG00000001  View Edit Delete
AG05000064  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2017-12-05 14:04:38  AG05000064  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

Page 7 of 250, showing 20 records out of 5000 total, starting on record 121, ending on 140

(default) 2 queries took 16 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`.`user_post_number` desc LIMIT 120, 2020204
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