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
AG01005501  2023-05-22                              2023-05-22 00:00:00  MG00000001  2023-08-12 13:36:49  AG01005501  View Edit Delete
AG01005502  2023-05-22                              2023-05-22 00:00:00  MG00000001  2023-06-10 07:46:48  AG01005502  View Edit Delete
AG01005503  2023-05-22                              2023-05-22 00:00:00  MG00000001  2023-07-28 20:07:15  AG01005503  View Edit Delete
AG01005504  2023-05-22                              2023-05-22 00:00:00  MG00000001  2023-07-07 18:22:09  AG01005504  View Edit Delete
AG01005505  2023-05-22                              2023-05-22 00:00:00  MG00000001  2023-05-31 07:40:15  AG01005505  View Edit Delete
AG01005506  2023-05-29                              2023-05-29 00:00:00  MG00000001  2023-10-02 19:56:25  AG01005506  View Edit Delete
AG01005507  2023-06-02                              2023-06-02 00:00:00  AG01005507  2023-06-12 14:08:18  AG01005507  View Edit Delete
AG01005508  2023-06-09                              2023-06-09 00:00:00  MG00000001  2023-12-15 11:49:31  AG01005508  View Edit Delete
AG01005509  2023-06-09                              2023-06-09 00:00:00  MG00000001  2023-11-27 11:34:44  AG01005509  View Edit Delete
AG01005510  2023-06-09                              2023-06-09 00:00:00  MG00000001  2023-06-20 10:39:06  AG01005510  View Edit Delete
AG01005511  2023-06-13                              2023-06-13 00:00:00  MG00000001  2023-06-16 08:16:04  AG01005511  View Edit Delete
AG01005512  2023-06-13                              2023-06-13 00:00:00  MG00000001  2023-06-19 07:48:25  AG01005512  View Edit Delete
AG01005513  2023-06-13                              2023-06-13 00:00:00  MG00000001  2023-11-15 09:36:43  AG01005513  View Edit Delete
AG01005514  2023-06-13                              2023-06-13 00:00:00  MG00000001  2023-06-19 07:49:40  AG01005514  View Edit Delete
AG01005515  2023-06-13                              2023-06-13 00:00:00  MG00000001  2023-09-07 11:22:25  AG01005515  View Edit Delete
AG01005516  2023-06-28                              2023-06-28 00:00:00  MG00000001  2023-07-24 13:29:55  AG01005516  View Edit Delete
AG01005517  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-11-30 14:20:18  AG01005517  View Edit Delete
AG01005518  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-09-27 11:09:51  AG01005518  View Edit Delete
AG01005519  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-07-10 11:09:33  AG01005519  View Edit Delete
AG01005521  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-12-06 10:31:40  AG01005521  View Edit Delete

Page 14 of 250, showing 20 records out of 5000 total, starting on record 261, ending on 280

(default) 2 queries took 18 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`.`rental_tablet_tel` asc LIMIT 260, 2020205
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 = 11113