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
AG05000039  2017-11-01                  337-0026  埼玉県さいたま市見沼区          2017-11-01 11:34:46  MG00000001  2018-04-07 13:37:34  AG05000039  View Edit Delete
AG01003386  2018-04-12    貸し出し用機材  貸し出し用機材                        2018-04-12 17:14:45  AG01003367  2018-04-12 11:24:52  AG01003386  View Edit Delete
AG05000025  2017-11-01                  349-0103  埼玉県蓮田市          2017-11-01 11:34:46  MG00000001  2018-04-18 13:39:35  AG05000025  View Edit Delete
AG01003026  2017-09-25    貸し出し用機材  貸し出し用機材                          MG00000002  2018-04-19 09:00:49  AG01003026  View Edit Delete
AG01003382  2018-04-02    6800                  奈良県磯城郡田原本町松本          2018-04-02 17:14:45  AG01003382  2018-04-19 22:32:22  AG01003382  View Edit Delete
AG01002995  2017-04-24    貸し出し用機材  貸し出し用機材                          MG00000001  2018-04-21 14:42:18  AG01002995  View Edit Delete
AG01002999  2017-04-27    貸し出し用機材  貸し出し用機材                          MG00000001  2018-04-21 14:42:56  AG01002999  View Edit Delete
AG01003003  2017-06-08    貸し出し用機材  貸し出し用機材                          MG00000002  2018-04-21 14:44:07  AG01003003  View Edit Delete
AG01003005  2017-06-29    貸し出し用機材  貸し出し用機材                          MG00000001  2018-04-21 14:44:32  AG01003005  View Edit Delete
AG01003007  2017-07-21    貸し出し用機材  貸し出し用機材                          AG01003007  2018-04-21 14:53:16  AG01003007  View Edit Delete
AG01003008  2017-07-21    貸し出し用機材  貸し出し用機材                          AG01003008  2018-04-21 14:54:01  AG01003008  View Edit Delete
AG02100032  2018-04-24                              2018-04-24 09:26:21  MG00000001  2018-04-24 11:01:53  AG02100032  View Edit Delete
AG01003391  2018-04-24                              2018-04-24 12:52:12  MG00000001  2018-04-24 13:23:39  AG01003391  View Edit Delete
AG01003384  2018-04-09    貸し出し用機材  貸し出し用機材                        2018-04-09 17:14:45  AG01003367  2018-04-26 09:09:01  AG01003384  View Edit Delete
AG05000102  2018-04-13                    埼玉県          2018-04-13 11:34:46  MG00000001  2018-04-26 13:23:22  AG05000102  View Edit Delete
AG05000044  2017-11-01                  278-0015  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-04-27 13:51:55  AG05000044  View Edit Delete
AG05000052  2017-11-01                  337-0003  埼玉県さいたま市見沼区          2017-11-01 11:34:46  MG00000002  2018-04-29 20:46:40  AG05000052  View Edit Delete
AG05000086  2017-11-01                  337-0017  埼玉県さいたま市見沼区          2017-11-01 11:34:46  MG00000002  2018-04-29 20:49:26  AG05000086  View Edit Delete
AG01003389  2018-04-18    貸し出し用機材  貸し出し用機材                        2018-04-18 17:14:45  AG01003367  2018-05-03 11:20:26  AG01003389  View Edit Delete
AG05000043  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2018-05-04 13:51:29  AG05000043  View Edit Delete

Page 14 of 250, showing 20 records out of 5000 total, starting on record 261, ending on 280

(default) 2 queries took 21 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 260, 2020207
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 = 11114