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
AG05000130  2020-08-27                              2020-08-27 10:30:06  MG00000005  2021-07-12 14:08:42  AG05000130  View Edit Delete
AG05000132  2020-09-15                              2020-09-15 19:53:45  MG00000005  2021-07-12 14:09:00  AG05000132  View Edit Delete
AG01003304  2017-11-17    貸し出し用機材  貸し出し用機材                        2017-11-17 11:30:00  AG01003270  2021-07-16 13:07:47  AG01003304  View Edit Delete
AG01004125  2020-09-16                              2020-09-16 09:28:13  MG00000005  2021-07-19 15:17:23  AG01004125  View Edit Delete
AG01003274  2017-10-30    貸し出し用機材  貸し出し用機材                          AG01003270  2021-07-20 08:40:06  AG01003274  View Edit Delete
AG01003892  2019-08-27                              2019-08-27 15:45:04  MG00000001  2021-07-21 10:10:18  AG01003892  View Edit Delete
AG01004439  2021-03-19                              2021-03-19 17:45:34  MG00000005  2021-07-21 12:51:58  AG01004439  View Edit Delete
AG01004499  2021-04-19                              2021-04-19 17:06:13  MG00000005  2021-07-21 13:38:42  AG01004499  View Edit Delete
AG05000061  2017-11-01                  349-0202  埼玉県白岡市          2017-11-01 11:34:46  MG00000001  2021-07-22 14:35:44  AG05000061  View Edit Delete
AG01004361  2021-03-09                              2021-03-09 10:21:17  MG00000005  2021-07-26 09:58:12  AG01004361  View Edit Delete
AG01004566  2021-07-26                              2021-07-26 12:20:32  MG00000001  2021-07-26 12:20:32  MG00000001  View Edit Delete
AG01004104  2020-08-06                              2020-08-06 09:09:01  MG00000005  2021-07-27 08:22:18  AG01004104  View Edit Delete
AG01003316  2017-11-20    貸し出し用機材  貸し出し用機材                        2017-11-17 11:30:00  MG00000001  2021-07-27 11:07:30  MG00000001  View Edit Delete
AG01000001  2016-08-30    99                            2016-08-30 12:23:16  MG00000001  2021-07-28 14:59:20  AG01000001  View Edit Delete
AG01004565  2021-07-26                              2021-07-26 12:19:52  MG00000001  2021-08-02 11:02:46  AG01004565  View Edit Delete
AG02000016  2017-02-22                  775-0504  徳島県海部郡海陽町尾崎字八山85-2  090-8974-8243        2017-02-22 00:00:00  MG00000001  2021-08-05 10:24:12  AG02000016  View Edit Delete
AG01003627  2018-09-11                              2018-09-11 16:38:50  MG00000001  2021-08-05 15:37:16  AG01003627  View Edit Delete
AG01004542  2021-06-29                              2021-06-29 16:35:06  MG00000001  2021-08-11 10:52:23  AG01004542  View Edit Delete
AG01004426  2021-03-18                              2021-03-18 11:23:23  MG00000005  2021-08-14 14:26:21  AG01004426  View Edit Delete
AG01004574  2021-08-16                              2021-08-16 16:13:15  MG00000001  2021-08-17 10:16:58  AG01004574  View Edit Delete

Page 70 of 250, showing 20 records out of 5000 total, starting on record 1381, ending on 1400

(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 1380, 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