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
AG01003370  2018-02-08    貸し出し用機材  貸し出し用機材                        2018-02-08 17:29:49  AG01003370  2018-03-27 11:08:43  AG01003370  View Edit Delete
AG01003371  2018-02-22    貸し出し用機材  貸し出し用機材                        2018-02-22 17:29:49  AG01003370  2019-01-26 08:57:13  AG01003371  View Edit Delete
AG01003373  2018-03-09    貸し出し用機材  貸し出し用機材                        2018-03-09 17:29:49  AG01003373  2018-06-04 09:59:35  AG01003373  View Edit Delete
AG01003374  2018-03-09    貸し出し用機材  貸し出し用機材                        2018-03-09 17:29:49  AG01003374  2018-06-26 12:06:56  AG01003374  View Edit Delete
AG01003376  2018-03-15    貸し出し用機材  貸し出し用機材                        2018-03-15 17:29:49  AG01003376  2018-03-16 10:19:22  AG01003376  View Edit Delete
AG01003382  2018-04-02    6800                  奈良県磯城郡田原本町松本          2018-04-02 17:14:45  AG01003382  2018-04-19 22:32:22  AG01003382  View Edit Delete
AG01003457  2018-05-25                              2018-05-25 09:40:00  AG01003457  2018-06-12 09:19:35  AG01003457  View Edit Delete
AG01003470  2018-05-25                              2018-05-25 09:40:00  AG01003470  2021-03-04 15:59:51  AG01003470  View Edit Delete
AG01003478  2018-05-28                              2018-05-28 10:41:47  AG01003478  2020-04-03 17:31:02  AG01003478  View Edit Delete
AG01003542  2018-07-09                              2018-07-09 11:17:40  AG01003542  2019-02-21 14:19:52  AG01003542  View Edit Delete
AG01003909  2019-11-06                              2019-11-06 16:03:20  AG01003909  2023-03-25 02:50:30  AG01003909  View Edit Delete
AG01003910  2019-11-06                              2019-11-06 16:10:15  AG01003910  2019-11-07 11:54:04  AG01003910  View Edit Delete
AG01004014  2020-02-19                              2020-02-19 10:30:50  AG01004014  2020-02-26 12:32:38  AG01004014  View Edit Delete
AG01004058  2020-05-11                              2020-05-11 10:44:51  AG01004058  2022-05-18 17:54:58  AG01004058  View Edit Delete
AG01004073  2020-06-11                              2020-06-11 13:18:04  AG01004073  2023-02-02 16:08:25  AG01004073  View Edit Delete
AG01004824  2022-06-20                              2022-06-20 10:59:35  AG01004824  2023-07-20 12:08:47  AG01004824  View Edit Delete
AG01004848  2022-06-22                              2022-06-22 09:56:58  AG01004848  2023-02-15 15:21:51  AG01004848  View Edit Delete
AG01004868  2022-07-20                              2022-07-20 10:53:45  AG01004868  2023-03-25 02:14:10  AG01004868  View Edit Delete
AG01005146  2022-09-13                              2022-09-13 11:53:59  AG01005146  2023-03-29 11:36:39  AG01005146  View Edit Delete
AG01005231  2022-10-31                              2022-10-31 15:26:41  AG01005231  2023-10-24 11:39:10  AG01005231  View Edit Delete

Page 6 of 250, showing 20 records out of 5000 total, starting on record 101, ending on 120

(default) 2 queries took 15 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 100, 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 = 11111