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
AG01003926  2019-12-09                              2019-12-09 10:42:34  MG00000001  2022-10-31 12:16:30  AG01003926  View Edit Delete
AG01004624  2022-01-05                              2022-01-05 09:21:23  MG00000001  2022-10-31 08:18:09  AG01004624  View Edit Delete
AG01004408  2021-03-11                              2021-03-11 13:22:30  MG00000005  2022-10-28 07:59:01  AG01004408  View Edit Delete
AG03000034  2022-10-17                              2022-10-17 13:52:04  MG00000001  2022-10-26 09:26:01  AG03000034  View Edit Delete
AG01004177  2021-01-15                              2021-01-15 13:22:43  MG00000005  2022-10-24 10:29:10  AG01004177  View Edit Delete
AG01004908  2022-07-29                              2022-07-29 09:42:56  MG00000001  2022-10-23 10:46:33  AG01004908  View Edit Delete
AG01005162  2022-10-03                              2022-10-03 10:27:27  MG00000001  2022-10-22 11:26:17  AG01005162  View Edit Delete
AG01005195  2022-10-18                              2022-10-18 08:23:56  MG00000001  2022-10-20 16:09:28  AG01005195  View Edit Delete
AG01005212  2022-10-19                              2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01002767  2017-04-20    貸し出し用機材  貸し出し用機材                        2017-04-18 13:36:00  MG00000005  2022-10-19 11:35:24  AG01002767  View Edit Delete
AG01005191  2022-10-12                              2022-10-12 14:02:12  MG00000001  2022-10-18 15:56:38  AG01005191  View Edit Delete
AG01004911  2022-07-29                              2022-07-29 09:42:56  MG00000001  2022-10-18 10:37:31  AG01004911  View Edit Delete
AG01004437  2021-03-19                              2021-03-19 17:21:44  MG00000005  2022-10-14 17:33:42  AG01004437  View Edit Delete
AG04000144  2022-07-14                              2022-07-14 09:26:57  MG00000001  2022-10-14 11:20:42  AG04000144  View Edit Delete
AG04000003  2022-06-23                              2022-06-23 11:08:20  MG00000001  2022-10-14 11:16:17  AG04000003  View Edit Delete
AG01005164  2022-10-03                              2022-10-03 10:27:27  MG00000001  2022-10-13 13:22:50  AG01005164  View Edit Delete
AG01004919  2022-07-29                              2022-07-29 10:56:15  MG00000001  2022-10-12 10:56:59  AG01004919  View Edit Delete
AG01004873  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-10-12 10:40:32  AG01004873  View Edit Delete
AG01005174  2022-10-04                              2022-10-04 16:00:53  MG00000001  2022-10-10 16:08:53  AG01005174  View Edit Delete
AG01004901  2022-07-20                              2022-07-20 14:28:28  MG00000001  2022-10-10 08:31:11  AG01004901  View Edit Delete

Page 92 of 250, showing 20 records out of 5000 total, starting on record 1821, ending on 1840

(default) 2 queries took 24 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 1820, 20202013
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