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
AG01005163  2022-10-03                              2022-10-03 10:27:27  MG00000001  2022-10-08 10:43:16  AG01005163  View Edit Delete
AG01004896  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-10-07 10:46:33  AG01004896  View Edit Delete
AG01005167  2022-10-03                              2022-10-03 10:27:27  MG00000001  2022-10-06 14:18:30  AG01005167  View Edit Delete
AG01005165  2022-10-03                              2022-10-03 10:27:27  MG00000001  2022-10-06 14:14:28  AG01005165  View Edit Delete
AG01004869  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-10-06 10:48:41  AG01004869  View Edit Delete
AG01005161  2022-10-03                              2022-10-03 10:27:27  MG00000001  2022-10-05 14:44:07  AG01005161  View Edit Delete
AG01004303  2021-01-22                              2021-01-22 15:34:28  MG00000005  2022-10-05 11:51:05  AG01004303  View Edit Delete
AG01004299  2021-01-22                              2021-01-22 13:59:54  MG00000005  2022-10-05 11:49:47  AG01004299  View Edit Delete
AG01005140  2022-09-08                              2022-09-08 10:57:30  MG00000001  2022-10-05 10:51:37  AG01005140  View Edit Delete
AG01004526  2021-06-02                              2021-06-02 17:22:22  MG00000001  2022-10-05 10:51:10  AG01004526  View Edit Delete
AG02000099  2018-05-28                              2018-05-28 15:12:26  MG00000001  2022-10-03 18:59:57  AG02000099  View Edit Delete
AG01004883  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-10-03 10:57:43  AG01004883  View Edit Delete
AG01005168  2022-10-03                              2022-10-03 10:27:27  MG00000001  2022-10-03 10:27:27  MG00000001  View Edit Delete
AG01003640  2018-11-27                              2018-11-27 23:01:14  MG00000001  2022-09-30 15:54:31  AG01003640  View Edit Delete
AG01004887  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-09-29 10:36:40  AG01004887  View Edit Delete
AG01004882  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-09-29 09:18:45  AG01004882  View Edit Delete
AG02000063  2017-12-12                              2017-12-04 10:34:30  MG00000005  2022-09-28 06:28:15  AG02000063  View Edit Delete
AG01004888  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-09-27 18:48:46  AG01004888  View Edit Delete
AG04000145  2022-09-06                              2022-09-06 09:14:44  MG00000001  2022-09-26 13:44:32  AG04000145  View Edit Delete
AG01005145  2022-09-13                              2022-09-13 09:56:20  MG00000001  2022-09-22 12:11:37  AG01005145  View Edit Delete

Page 93 of 250, showing 20 records out of 5000 total, starting on record 1841, ending on 1860

(default) 2 queries took 22 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 1840, 20202011
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