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
AG01003908  2019-11-06                              2019-11-06 09:17:49  MG00000001  2019-11-06 10:19:31  AG01003908  View Edit Delete
AG01003378  2018-03-22    貸し出し用機材  貸し出し用機材                        2018-03-22 17:14:45  AG01003367  2019-11-06 14:22:38  AG01003378  View Edit Delete
AG01003531  2018-06-05                              2018-06-05 09:17:26  MG00000001  2019-11-06 14:27:30  AG01003531  View Edit Delete
AG01003657  2019-02-19                              2019-02-19 09:31:37  MG00000001  2019-11-06 14:28:46  AG01003657  View Edit Delete
AG01003708  2019-05-15                              2019-05-15 08:55:45  MG00000001  2019-11-06 14:33:46  AG01003708  View Edit Delete
AG01003727  2019-06-11                              2019-06-11 08:47:15  MG00000001  2019-11-06 14:38:02  AG01003727  View Edit Delete
AG01003709  2019-05-15                              2019-05-15 08:57:30  MG00000001  2019-11-06 14:51:57  AG01003709  View Edit Delete
AG01003642  2018-12-12                              2018-12-12 09:10:04  MG00000001  2019-11-06 14:53:52  AG01003642  View Edit Delete
AG01002762  2017-04-20    貸し出し用機材  貸し出し用機材                        2017-04-18 13:36:00  MG00000001  2019-11-06 14:57:20  AG01002762  View Edit Delete
AG01003000  2017-04-27    貸し出し用機材  貸し出し用機材                          MG00000001  2019-11-06 14:58:13  AG01003000  View Edit Delete
AG01003294  2017-11-09    貸し出し用機材  貸し出し用機材                          AG01003292  2019-11-06 14:58:56  AG01003294  View Edit Delete
AG01003441  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-11-07 10:38:53  AG01003441  View Edit Delete
AG01003910  2019-11-06                              2019-11-06 16:10:15  AG01003910  2019-11-07 11:54:04  AG01003910  View Edit Delete
AG01003445  2018-05-25                              2018-05-25 09:40:00  MG00000001  2019-11-11 07:47:37  AG01003445  View Edit Delete
AG01003318  2017-12-19    貸し出し用機材  貸し出し用機材                        2017-12-01 17:00:22  AG01003010  2019-11-11 15:48:12  AG01003318  View Edit Delete
AG01003895  2019-09-13                              2019-09-13 10:02:39  MG00000001  2019-11-12 17:59:28  AG01003895  View Edit Delete
AG01003601  2018-08-01                              2018-08-01 15:54:07  MG00000001  2019-11-13 10:00:51  AG01003601  View Edit Delete
AG02000093  2018-05-16                              2018-05-16 10:23:28  MG00000001  2019-11-14 13:02:36  AG02000093  View Edit Delete
AG01001979  2017-04-12    98  貸し出し用機材  貸し出し用機材                        2016-08-30 12:23:32  AG01001979  2019-11-14 21:07:36  AG01001979  View Edit Delete
AG01002088  2017-04-12    貸し出し用機材  貸し出し用機材                        2016-08-30 12:23:33  AG01002088  2019-11-14 21:10:37  AG01002088  View Edit Delete

Page 43 of 250, showing 20 records out of 5000 total, starting on record 841, ending on 860

(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 840, 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 = 11112