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
AG01005153  2022-09-16                              2022-09-16 09:10:53  MG00000001  2023-08-22 17:57:43  AG01005153  View Edit Delete
AG01005232  2022-11-07                              2022-11-07 13:00:11  MG00000001  2023-08-22 17:58:18  AG01005232  View Edit Delete
AG01005233  2022-11-07                              2022-11-07 13:11:24  MG00000001  2023-08-22 17:59:00  AG01005233  View Edit Delete
AG01005389  2022-11-28                              2022-11-28 14:50:15  MG00000001  2023-08-22 17:59:38  AG01005389  View Edit Delete
AG01005400  2022-12-28                              2022-12-28 11:25:49  MG00000001  2023-08-22 18:00:21  AG01005400  View Edit Delete
AG01005480  2023-05-08                              2023-05-08 00:00:00  MG00000001  2023-08-22 18:03:59  AG01005480  View Edit Delete
AG01005390  2022-12-06                              2022-12-06 00:00:00  MG00000001  2023-08-22 18:07:46  AG01005390  View Edit Delete
AG01005641  2023-08-23                              2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005644  2023-08-23                              2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005654  2023-08-23                              2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005658  2023-08-23                              2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005663  2023-08-23                              2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005665  2023-08-23                              2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005666  2023-08-23                              2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005667  2023-08-23                              2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005669  2023-08-23                              2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005670  2023-08-23                              2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005671  2023-08-23                              2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005672  2023-08-23                              2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01005673  2023-08-23                              2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete

Page 213 of 250, showing 20 records out of 5000 total, starting on record 4241, ending on 4260

(default) 2 queries took 32 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` asc LIMIT 4240, 20202021
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