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
AG01004474  2021-03-30                              2021-03-30 16:12:07  MG00000002  2021-11-16 11:40:48  AG01004474  View Edit Delete
AG02100089  2020-04-01                              2020-04-01 16:42:47  MG00000005  2021-11-16 12:02:14  AG02100089  View Edit Delete
AG01003893  2019-09-06                              2019-09-06 10:48:16  MG00000001  2021-11-17 09:39:04  AG01003893  View Edit Delete
AG01004594  2021-11-10                              2021-11-10 16:21:09  MG00000001  2021-11-17 10:36:11  AG01004594  View Edit Delete
AG03000020  2018-03-20                                MG00000001  2021-11-17 17:33:47  AG03000020  View Edit Delete
AG01004595  2021-11-17                              2021-11-17 14:12:38  MG00000001  2021-11-19 09:24:29  AG01004595  View Edit Delete
AG05000138  2021-07-27                              2021-07-27 14:42:40  MG00000001  2021-11-19 14:11:32  AG05000138  View Edit Delete
AG02100009  2018-02-09                              2018-02-09 00:00:00  MG00000001  2021-11-21 10:52:18  AG02100009  View Edit Delete
AG02100083  2020-01-31                              2020-01-31 13:58:18  MG00000001  2021-11-24 13:19:23  AG02100083  View Edit Delete
AG05000140  2021-11-26                              2021-11-26 09:50:30  MG00000001  2021-11-26 09:50:30  MG00000001  View Edit Delete
AG01004603  2021-11-29                              2021-11-29 09:32:43  MG00000001  2021-11-29 09:32:43  MG00000001  View Edit Delete
AG02000002  2017-02-22                  770-0932  徳島県徳島市仲之町1丁目21-5-101  080-5664-3940        2017-02-22 00:00:00  MG00000002  2021-11-29 11:46:45  AG02000002  View Edit Delete
AG01004569  2021-07-26                              2021-07-26 16:51:28  MG00000001  2021-11-30 07:40:12  AG01004569  View Edit Delete
AG01004606  2021-12-03                              2021-12-03 10:11:20  MG00000001  2021-12-03 10:11:20  MG00000001  View Edit Delete
AG02100023  2018-02-09                              2018-02-09 00:00:00  MG00000001  2021-12-03 14:10:40  AG02100023  View Edit Delete
AG01003409  2018-05-25                              2018-05-25 09:40:00  MG00000001  2021-12-03 14:42:13  AG01003409  View Edit Delete
AG01003410  2018-05-25                              2018-05-25 09:40:00  MG00000001  2021-12-03 14:48:28  AG01003410  View Edit Delete
AG02100096  2021-01-20                              2021-01-20 13:08:44  MG00000001  2021-12-03 14:49:13  MG00000001  View Edit Delete
AG02100094  2020-09-24                              2020-09-24 08:53:31  MG00000001  2021-12-03 14:49:40  MG00000001  View Edit Delete
AG02100084  2020-02-06                              2020-02-06 10:00:01  MG00000001  2021-12-03 14:50:20  MG00000001  View Edit Delete

Page 73 of 250, showing 20 records out of 5000 total, starting on record 1441, ending on 1460

(default) 2 queries took 20 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 1440, 2020209
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