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
AG01004579  2021-10-13                              2021-10-13 09:49:32  MG00000001  2021-10-14 09:47:15  AG01004579  View Edit Delete
AG01004581  2021-10-13                              2021-10-13 09:54:55  MG00000001  2021-10-14 09:47:30  AG01004581  View Edit Delete
AG02100042  2018-05-11                              2018-05-11 09:56:17  MG00000001  2021-10-19 11:52:25  AG02100042  View Edit Delete
AG01003680  2019-04-10                              2019-04-10 13:31:09  MG00000001  2021-10-21 13:01:35  AG01003680  View Edit Delete
AG01004513  2021-05-11                              2021-05-11 09:15:36  MG00000001  2021-10-28 12:29:00  AG01004513  View Edit Delete
AG01004217  2021-01-18                              2021-01-18 16:59:57  MG00000005  2021-10-28 12:29:54  AG01004217  View Edit Delete
AG01004227  2021-01-19                              2021-01-19 11:43:44  MG00000005  2021-10-28 12:30:12  AG01004227  View Edit Delete
AG05000139  2021-10-28                              2021-10-28 14:11:02  MG00000001  2021-10-28 14:11:02  MG00000001  View Edit Delete
AG01004472  2021-03-30                              2021-03-30 14:03:21  MG00000002  2021-10-30 11:40:02  AG01004472  View Edit Delete
AG01001246  2017-09-25                              2016-08-30 12:23:26  MG00000001  2021-11-01 18:32:12  AG01001246  View Edit Delete
AG01003406  2018-05-25                              2018-05-25 09:40:00  MG00000001  2021-11-04 14:37:11  AG01003406  View Edit Delete
AG01003675  2019-04-10                              2019-04-10 11:44:30  MG00000002  2021-11-05 07:46:33  AG01003675  View Edit Delete
AG01003712  2019-05-16                              2019-05-16 08:57:04  MG00000001  2021-11-08 11:13:10  MG00000001  View Edit Delete
AG01004083  2020-06-30                              2020-06-30 10:13:12  MG00000001  2021-11-08 11:13:44  MG00000001  View Edit Delete
AG02100058  2018-08-23                              2018-08-23 14:18:22  MG00000001  2021-11-10 09:35:55  AG02100058  View Edit Delete
AG01004589  2021-10-28                              2021-10-28 10:32:23  MG00000001  2021-11-10 11:04:27  AG01004589  View Edit Delete
AG02000068  2018-01-16                              2018-01-16 10:34:30  MG00000001  2021-11-12 09:32:48  AG02000068  View Edit Delete
AG01004593  2021-11-10                              2021-11-10 13:56:04  MG00000001  2021-11-12 12:04:00  AG01004593  View Edit Delete
AG03000023  2018-03-20                                MG00000001  2021-11-14 14:51:26  AG03000023  View Edit Delete
AG01004145  2020-09-29                              2020-09-29 11:27:36  MG00000005  2021-11-15 14:19:05  AG01004145  View Edit Delete

Page 72 of 250, showing 20 records out of 5000 total, starting on record 1421, ending on 1440

(default) 2 queries took 22 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 1420, 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 = 11111