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
AG08000040  2020-06-11                              2020-06-11 16:50:38  MG00000005  2023-04-29 10:20:28  AG08000040  View Edit Delete
AG01005251  2022-11-11                              2022-11-11 10:09:38  MG00000001  2023-04-27 15:07:10  MG00000001  View Edit Delete
AG01005264  2022-11-11                              2022-11-11 10:09:38  MG00000001  2023-04-27 15:06:39  MG00000001  View Edit Delete
AG01004701  2022-05-23                              2022-05-23 14:21:53  MG00000001  2023-04-27 11:09:27  AG01004701  View Edit Delete
AG01005457  2023-04-03                              2023-04-03 00:00:00  MG00000001  2023-04-27 10:42:41  AG01005457  View Edit Delete
AG01004971  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-04-27 10:38:45  AG01004971  View Edit Delete
AG01004986  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-04-26 20:03:09  AG01004986  View Edit Delete
AG01004649  2022-03-31                              2022-03-31 00:31:52  MG00000001  2023-04-26 18:46:09  AG01004649  View Edit Delete
AG01004234  2021-01-20                              2021-01-20 08:56:41  MG00000005  2023-04-26 18:22:54  AG01004234  View Edit Delete
AG01004422  2021-03-15                              2021-03-15 10:40:56  MG00000005  2023-04-26 17:38:22  AG01004422  View Edit Delete
AG01005460  2023-04-03                              2023-04-03 00:00:00  MG00000001  2023-04-26 17:08:37  AG01005460  View Edit Delete
AG01005458  2023-04-03                              2023-04-03 00:00:00  MG00000001  2023-04-26 17:04:25  AG01005458  View Edit Delete
AG01005456  2023-04-03                              2023-04-03 00:00:00  MG00000001  2023-04-26 17:02:07  AG01005456  View Edit Delete
AG01005455  2023-04-03                              2023-04-03 00:00:00  MG00000001  2023-04-26 16:58:10  AG01005455  View Edit Delete
AG01004950  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-04-26 16:38:40  AG01004950  View Edit Delete
AG01005193  2022-10-13                              2022-10-13 15:29:56  MG00000001  2023-04-26 15:18:41  AG01005193  View Edit Delete
AG01005432  2023-01-26                              2023-01-26 00:00:00  MG00000001  2023-04-26 13:42:49  AG01005432  View Edit Delete
AG01004970  2022-08-22                              2022-08-22 12:05:04  MG00000001  2023-04-26 11:50:00  AG01004970  View Edit Delete
AG01004326  2021-03-08                              2021-03-08 09:14:21  MG00000005  2023-04-26 08:29:36  AG01004326  View Edit Delete
AG01005182  2022-10-11                              2022-10-11 10:24:52  MG00000001  2023-04-25 12:04:38  AG01005182  View Edit Delete

Page 60 of 250, showing 20 records out of 5000 total, starting on record 1181, ending on 1200

(default) 2 queries took 19 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 1180, 2020208
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