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
AG01003614  2018-08-01                              2018-08-01 16:59:13  MG00000001  2018-12-17 11:23:10  MG00000001  View Edit Delete
AG01003645  2018-12-18                              2018-12-18 13:06:22  MG00000001  2018-12-18 13:06:22  MG00000001  View Edit Delete
AG01003539  2018-07-02                              2018-07-02 12:15:58  MG00000001  2018-12-20 08:17:37  AG01003539  View Edit Delete
AG01003395  2018-05-11                              2018-05-11 13:53:58  MG00000001  2018-12-20 08:18:14  AG01003395  View Edit Delete
AG02000101  2018-06-12                              2018-06-12 09:34:22  MG00000001  2018-12-28 17:27:54  AG02000101  View Edit Delete
AG02000123  2018-12-19                              2018-12-19 10:42:45  MG00000001  2018-12-28 18:28:45  AG02000123  View Edit Delete
AG01003623  2018-08-02                              2018-08-02 15:25:02  MG00000001  2019-01-04 09:53:39  AG01003623  View Edit Delete
AG08000028  2019-01-07                              2019-01-07 15:36:52  MG00000001  2019-01-07 15:36:52  MG00000001  View Edit Delete
AG08000027  2019-01-07                              2019-01-07 15:35:31  MG00000001  2019-01-10 11:01:39  AG08000027  View Edit Delete
AG01003540  2018-07-02                              2018-07-02 12:16:52  MG00000001  2019-01-15 08:12:06  AG01003540  View Edit Delete
AG01003646  2018-12-28                              2018-12-28 09:00:21  MG00000001  2019-01-15 14:09:41  AG01003646  View Edit Delete
AG01003638  2018-11-15                              2018-11-15 09:27:34  MG00000001  2019-01-16 14:25:23  AG01003638  View Edit Delete
AG01003435  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-01-21 09:05:41  AG01003435  View Edit Delete
AG08000029  2019-01-22                              2019-01-22 13:53:47  MG00000001  2019-01-22 16:01:37  AG08000029  View Edit Delete
AG01003651  2019-01-21                              2019-01-21 09:47:07  MG00000001  2019-01-23 09:34:35  AG01003651  View Edit Delete
AG05000019  2017-11-01                  339-0082  埼玉県さいたま市岩槻区          2017-11-01 11:34:46  MG00000001  2019-01-24 15:01:13  AG05000019  View Edit Delete
AG01003653  2019-01-21                              2019-01-21 09:50:04  MG00000001  2019-01-25 09:13:48  AG01003653  View Edit Delete
AG01003371  2018-02-22    貸し出し用機材  貸し出し用機材                        2018-02-22 17:29:49  AG01003370  2019-01-26 08:57:13  AG01003371  View Edit Delete
AG01003654  2019-02-08                              2019-02-08 13:19:17  MG00000001  2019-02-08 15:50:07  AG01003654  View Edit Delete
AG01003584  2018-07-31                              2018-07-31 15:58:54  MG00000001  2019-02-14 17:39:32  AG01003584  View Edit Delete

Page 31 of 250, showing 20 records out of 5000 total, starting on record 601, ending on 620

(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`.`modified` asc LIMIT 600, 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