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
AG01004855  2022-07-08                              2022-07-08 13:45:11  MG00000001  2022-07-14 11:15:30  AG01004855  View Edit Delete
AG01004856  2022-07-08                              2022-07-08 13:48:34  MG00000001  2022-07-14 11:23:32  AG01004856  View Edit Delete
AG01004857  2022-07-08                              2022-07-08 13:54:08  MG00000001  2022-07-14 10:10:35  AG01004857  View Edit Delete
AG01004858  2022-07-14                              2022-07-14 14:27:29  MG00000001  2022-07-20 13:10:24  AG01004858  View Edit Delete
AG01004859  2022-07-14                              2022-07-14 14:35:38  MG00000001  2023-02-02 14:11:06  AG01004859  View Edit Delete
AG01004860  2022-07-14                              2022-07-14 14:37:12  MG00000001  2023-02-02 15:24:19  AG01004860  View Edit Delete
AG01004861  2022-07-14                              2022-07-14 14:38:42  MG00000001  2023-02-02 15:28:10  AG01004861  View Edit Delete
AG01004862  2022-07-14                              2022-07-14 14:40:44  MG00000001  2023-02-17 10:39:52  AG01004862  View Edit Delete
AG01004863  2022-07-14                              2022-07-14 14:42:25  MG00000001  2023-02-02 15:21:32  AG01004863  View Edit Delete
AG01004864  2022-07-14                              2022-07-14 14:44:19  MG00000001  2023-02-02 15:26:50  AG01004864  View Edit Delete
AG01004865  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-08-24 13:58:19  AG01004865  View Edit Delete
AG01004866  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-09-06 13:50:07  AG01004866  View Edit Delete
AG01004867  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-09-02 09:17:10  AG01004867  View Edit Delete
AG01004869  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-10-06 10:48:41  AG01004869  View Edit Delete
AG01004870  2022-07-20                              2022-07-20 10:53:45  MG00000001  2023-01-11 14:16:10  AG01004870  View Edit Delete
AG01004871  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-07-20 10:53:45  MG00000001  View Edit Delete
AG01004872  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-07-20 10:53:45  MG00000001  View Edit Delete
AG01004873  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-10-12 10:40:32  AG01004873  View Edit Delete
AG01004874  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-11-13 10:15:13  AG01004874  View Edit Delete
AG01004875  2022-07-20                              2022-07-20 10:53:45  MG00000001  2022-09-10 10:27:17  AG01004875  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` asc 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