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
AG01003863  2019-08-08                              2019-08-08 11:13:21  MG00000001  2019-08-08 11:13:21  MG00000001  View Edit Delete
AG01003861  2019-08-08                              2019-08-08 11:09:57  MG00000001  2019-08-08 11:09:57  MG00000001  View Edit Delete
AG01003858  2019-08-08                              2019-08-08 11:04:45  MG00000001  2019-08-08 11:04:45  MG00000001  View Edit Delete
AG01003851  2019-08-08                              2019-08-08 09:17:26  MG00000001  2019-08-08 09:17:26  MG00000001  View Edit Delete
AG01003850  2019-08-08                              2019-08-08 09:04:29  MG00000001  2019-08-08 09:04:29  MG00000001  View Edit Delete
AG01003849  2019-08-08                              2019-08-08 08:59:27  MG00000001  2019-08-08 08:59:27  MG00000001  View Edit Delete
AG01003840  2019-08-08                              2019-08-08 08:38:19  MG00000001  2019-08-08 08:38:19  MG00000001  View Edit Delete
AG01003818  2019-08-02                              2019-08-02 09:53:22  MG00000001  2019-08-07 09:46:25  AG01003818  View Edit Delete
AG01003837  2019-08-07                              2019-08-07 08:37:13  MG00000001  2019-08-07 08:37:13  MG00000001  View Edit Delete
AG01003836  2019-08-07                              2019-08-07 08:31:58  MG00000001  2019-08-07 08:31:58  MG00000001  View Edit Delete
AG01003834  2019-08-06                              2019-08-06 16:52:14  MG00000001  2019-08-06 16:52:14  MG00000001  View Edit Delete
AG01003831  2019-08-06                              2019-08-06 12:29:57  MG00000001  2019-08-06 12:29:57  MG00000001  View Edit Delete
AG01003830  2019-08-06                              2019-08-06 11:54:59  MG00000001  2019-08-06 11:54:59  MG00000001  View Edit Delete
AG01003829  2019-08-06                              2019-08-06 11:26:35  MG00000001  2019-08-06 11:26:35  MG00000001  View Edit Delete
AG01003824  2019-08-06                              2019-08-06 10:12:24  MG00000001  2019-08-06 10:12:24  MG00000001  View Edit Delete
AG01002075  2017-04-12    98  貸し出し用機材  貸し出し用機材                        2016-08-30 12:23:33  AG01002075  2019-08-05 17:31:34  AG01002075  View Edit Delete
AG01002021  2017-04-12    98  貸し出し用機材  貸し出し用機材                        2016-08-30 12:23:33  AG01002021  2019-08-01 13:29:45  AG01002021  View Edit Delete
AG01003810  2019-08-01                              2019-08-01 09:14:07  MG00000001  2019-08-01 09:14:07  MG00000001  View Edit Delete
AG01003809  2019-08-01                              2019-08-01 09:05:42  MG00000001  2019-08-01 09:05:42  MG00000001  View Edit Delete
AG01003803  2019-08-01                              2019-08-01 08:44:22  MG00000001  2019-08-01 08:44:22  MG00000001  View Edit Delete

Page 213 of 250, showing 20 records out of 5000 total, starting on record 4241, ending on 4260

(default) 2 queries took 31 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` desc LIMIT 4240, 20202020
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