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
AG01004064  2020-06-03                              2020-06-03 14:12:42  MG00000001  2022-06-13 09:59:15  MG00000001  View Edit Delete
AG01004065  2020-06-03                              2020-06-03 14:16:20  MG00000001  2023-01-06 10:19:02  AG01004065  View Edit Delete
AG01004077  2020-06-11                              2020-06-11 13:33:08  MG00000001  2022-12-07 09:25:41  AG01004077  View Edit Delete
AG01004083  2020-06-30                              2020-06-30 10:13:12  MG00000001  2021-11-08 11:13:44  MG00000001  View Edit Delete
AG01004084  2020-06-30                              2020-06-30 10:38:07  MG00000001  2022-06-01 11:31:29  MG00000001  View Edit Delete
AG01004085  2020-06-30                              2020-06-30 10:40:39  MG00000001  2023-01-24 10:40:22  AG01004085  View Edit Delete
AG01004086  2020-06-30                              2020-06-30 10:43:23  MG00000001  2023-01-05 10:55:36  AG01004086  View Edit Delete
AG01004087  2020-06-30                              2020-06-30 10:45:45  MG00000001  2023-08-04 12:29:37  AG01004087  View Edit Delete
AG01004100  2020-07-27                              2020-07-27 18:29:14  MG00000001  2022-12-05 12:38:04  AG01004100  View Edit Delete
AG01004109  2020-09-02                              2020-09-02 15:57:16  MG00000001  2022-12-21 09:28:02  AG01004109  View Edit Delete
AG01004114  2020-09-02                              2020-09-02 16:42:19  MG00000001  2023-03-09 12:05:21  AG01004114  View Edit Delete
AG01004121  2020-09-10                              2020-09-10 13:12:27  MG00000001  2023-08-02 10:52:33  AG01004121  View Edit Delete
AG01004122  2020-09-10                              2020-09-10 13:16:47  MG00000001  2022-12-21 10:07:26  AG01004122  View Edit Delete
AG01004134  2020-09-29                              2020-09-29 10:46:40  MG00000001  2023-02-17 10:53:27  MG00000001  View Edit Delete
AG01004137  2020-09-29                              2020-09-29 10:54:56  MG00000001  2023-02-17 09:14:08  MG00000001  View Edit Delete
AG01004146  2020-09-29                              2020-09-29 11:29:39  MG00000001  2023-02-17 10:53:52  MG00000001  View Edit Delete
AG01004152  2020-10-13                              2020-10-13 10:48:45  MG00000001  2023-02-15 17:19:13  AG01004152  View Edit Delete
AG01004153  2020-10-13                              2020-10-13 10:55:23  MG00000001  2021-12-08 15:24:24  AG01004153  View Edit Delete
AG01004154  2020-10-13                              2020-10-13 11:43:56  MG00000001  2022-02-22 09:15:32  MG00000001  View Edit Delete
AG01004158  2020-11-02                              2020-11-02 09:22:24  MG00000001  2023-01-24 11:20:00  AG01004158  View Edit Delete

Page 74 of 250, showing 20 records out of 5000 total, starting on record 1461, ending on 1480

(default) 2 queries took 23 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` desc LIMIT 1460, 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 = 11112