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
AG05000085  2017-11-01                  333-0864  埼玉県川口市          2017-11-01 11:34:46  MG00000001  2018-05-04 15:58:23  AG05000085  View Edit Delete
AG01003387  2018-04-12    貸し出し用機材  貸し出し用機材                        2018-04-12 17:14:45  AG01003367  2018-05-05 12:00:46  AG01003387  View Edit Delete
AG01003385  2018-04-12    貸し出し用機材  貸し出し用機材                        2018-04-12 17:14:45  AG01003367  2018-05-05 12:03:54  AG01003385  View Edit Delete
AG05000053  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-05-07 16:12:13  AG05000053  View Edit Delete
AG03000001  2018-03-20                                MG00000002  2018-05-09 13:51:50  AG03000001  View Edit Delete
AG01003336  2018-01-26                              2018-01-26 00:00:00  MG00000001  2018-05-09 15:24:48  AG01003336  View Edit Delete
AG01003350  2018-01-26                              2018-01-26 00:00:00  MG00000001  2018-05-09 15:25:15  AG01003350  View Edit Delete
AG02100035  2018-05-11                              2018-05-11 09:38:57  MG00000001  2018-05-11 11:13:18  AG02100035  View Edit Delete
AG02100039  2018-05-11                              2018-05-11 09:52:32  MG00000001  2018-05-11 11:19:55  AG02100039  View Edit Delete
AG03000025  2018-03-20                                MG00000001  2018-05-12 17:44:54  AG03000025  View Edit Delete
AG01003399  2018-05-15                              2018-05-15 09:18:59  MG00000001  2018-05-18 13:36:04  AG01003399  View Edit Delete
AG01003272  2017-10-30    貸し出し用機材  貸し出し用機材                          AG01003270  2018-05-21 10:22:07  AG01003272  View Edit Delete
AG01001155  2017-08-01  2018-07-31                            2016-08-30 12:23:25  AG01001155  2018-05-21 10:26:12  AG01001155  View Edit Delete
AG05000016  2017-11-01                  339-0044  埼玉県さいたま市岩槻区          2017-11-01 11:34:46  MG00000001  2018-05-21 15:01:50  AG05000016  View Edit Delete
AG02100045  2018-05-21                              2018-05-21 14:01:48  MG00000001  2018-05-22 11:45:45  AG02100045  View Edit Delete
AG02100047  2018-05-21                              2018-05-21 14:05:12  MG00000001  2018-05-22 11:47:21  AG02100047  View Edit Delete
AG02100048  2018-05-21                              2018-05-21 14:07:03  MG00000001  2018-05-22 11:48:30  AG02100048  View Edit Delete
AG05000084  2017-11-01                  337-0001  埼玉県さいたま市見沼区          2017-11-01 11:34:46  MG00000001  2018-05-22 17:27:29  AG05000084  View Edit Delete
AG01003305  2017-11-17    貸し出し用機材  貸し出し用機材                        2017-11-17 11:30:00  MG00000001  2018-05-23 17:14:27  AG01003305  View Edit Delete
AG01003278  2017-10-30    貸し出し用機材  貸し出し用機材                          AG01003270  2018-05-23 17:15:00  AG01003278  View Edit Delete

Page 15 of 250, showing 20 records out of 5000 total, starting on record 281, ending on 300

(default) 2 queries took 15 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 280, 2020204
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