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
AG01003728  2019-06-13                              2019-06-13 09:40:30  MG00000001  2019-10-23 15:45:16  AG01003728  View Edit Delete
AG01003729  2019-06-13                              2019-06-13 09:41:42  MG00000001  2019-10-23 15:46:03  AG01003729  View Edit Delete
AG01003544  2018-07-09                              2018-07-09 11:23:19  MG00000001  2019-10-23 17:56:24  AG01003544  View Edit Delete
AG01003856  2019-08-08                              2019-08-08 09:28:18  MG00000001  2019-10-25 10:41:19  AG01003856  View Edit Delete
AG01003852  2019-08-08                              2019-08-08 09:18:53  MG00000001  2019-10-25 10:42:04  AG01003852  View Edit Delete
AG01003848  2019-08-08                              2019-08-08 08:58:07  MG00000001  2019-10-25 10:42:16  AG01003848  View Edit Delete
AG01003843  2019-08-08                              2019-08-08 08:45:12  MG00000001  2019-10-25 10:43:13  AG01003843  View Edit Delete
AG01003828  2019-08-06                              2019-08-06 10:31:23  MG00000001  2019-10-25 10:43:50  AG01003828  View Edit Delete
AG01003822  2019-08-05                              2019-08-05 16:41:03  MG00000001  2019-10-25 10:44:17  AG01003822  View Edit Delete
AG01002747  2017-04-24    98  貸し出し用機材  貸し出し用機材                        2017-04-18 13:36:00  AG01002747  2019-10-25 11:56:27  AG01002747  View Edit Delete
AG05000031  2017-11-01                  339-0076  埼玉県さいたま市岩槻区          2017-11-01 11:34:46  MG00000001  2019-10-26 14:48:57  AG05000031  View Edit Delete
AG01003524  2018-06-01                              2018-06-01 15:18:00  MG00000001  2019-10-29 11:34:40  AG01003524  View Edit Delete
AG01001256  2017-09-25                              2016-08-30 12:23:26  MG00000001  2019-10-29 11:51:38  AG01001256  View Edit Delete
AG01003766  2019-07-24                              2019-07-24 11:41:04  MG00000001  2019-11-01 09:52:27  AG01003766  View Edit Delete
AG01001259  2017-09-25                              2016-08-30 12:23:26  MG00000001  2019-11-01 11:27:00  AG01001259  View Edit Delete
AG01001559  2017-02-22    99                            2016-08-30 12:23:29  AG01001559  2019-11-01 11:37:20  AG01001559  View Edit Delete
AG01001266  2017-02-01    99                            2016-08-30 12:23:26  AG01001266  2019-11-01 11:38:38  AG01001266  View Edit Delete
AG01001598  2017-01-18    99                            2016-08-30 12:23:30  AG01001598  2019-11-01 11:39:51  AG01001598  View Edit Delete
AG01002997  2017-04-24    貸し出し用機材  貸し出し用機材                          MG00000001  2019-11-05 19:10:40  AG01002997  View Edit Delete
AG01003905  2019-11-05                              2019-11-05 14:16:29  MG00000001  2019-11-06 09:21:46  AG01003905  View Edit Delete

Page 42 of 250, showing 20 records out of 5000 total, starting on record 821, ending on 840

(default) 2 queries took 26 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 820, 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 = 11115