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
AG05000069  2017-11-01                  339-0076  埼玉県さいたま市岩槻区          2017-11-01 11:34:46  MG00000001  2020-03-28 14:28:02  AG05000069  View Edit Delete
AG01003813  2019-08-01                              2019-08-01 09:23:08  MG00000001  2020-03-29 20:53:26  AG01003813  View Edit Delete
AG01003797  2019-08-01                              2019-08-01 08:27:54  MG00000001  2020-03-29 20:55:28  AG01003797  View Edit Delete
AG01003478  2018-05-28                              2018-05-28 10:41:47  AG01003478  2020-04-03 17:31:02  AG01003478  View Edit Delete
AG01003945  2019-12-10                              2019-12-10 16:04:51  MG00000001  2020-04-08 16:25:33  AG01003945  View Edit Delete
AG01004026  2020-03-13                              2020-03-13 09:53:22  MG00000001  2020-04-09 15:08:13  AG01004026  View Edit Delete
AG08000035  2020-04-09                              2020-04-09 13:51:40  MG00000001  2020-04-11 11:16:40  AG08000035  View Edit Delete
AG02000025  2017-02-22                  774-3421  徳島県名西郡神山町下分字喜来244  090-6283-2786        2017-02-22 00:00:00  MG00000001  2020-04-13 14:29:21  AG02000025  View Edit Delete
AG01003821  2019-08-05                              2019-08-05 15:51:29  MG00000001  2020-04-19 11:03:45  AG01003821  View Edit Delete
AG01003390  2018-04-18    貸し出し用機材  貸し出し用機材                        2018-04-18 17:14:45  MG00000001  2020-04-23 10:15:28  AG01003390  View Edit Delete
AG01004044  2020-05-01                              2020-05-01 16:01:29  MG00000001  2020-05-01 16:01:29  MG00000001  View Edit Delete
AG01004047  2020-05-01                              2020-05-01 16:07:02  MG00000001  2020-05-01 16:07:02  MG00000001  View Edit Delete
AG05000057  2017-11-01                  270-0222  千葉県野田市          2017-11-01 11:34:46  MG00000001  2020-05-07 11:29:27  MG00000001  View Edit Delete
AG02000086  2018-04-03                              2018-03-16 10:34:30  MG00000001  2020-05-11 11:31:04  AG02000086  View Edit Delete
AG02100090  2020-05-11                              2020-05-11 14:14:48  MG00000001  2020-05-11 14:46:17  AG02100090  View Edit Delete
AG02100059  2018-08-23                              2018-08-23 14:19:21  MG00000001  2020-05-11 15:19:13  AG02100059  View Edit Delete
AG01004059  2020-05-11                              2020-05-11 10:46:27  MG00000001  2020-05-12 10:07:03  AG01004059  View Edit Delete
AG02000007  2017-02-22                  779-0222  徳島県鳴門市大麻町三俣字走り出16  090-3185-5355        2017-02-22 00:00:00  MG00000001  2020-05-13 09:30:34  AG02000007  View Edit Delete
AG02000038  2017-06-29                              2017-02-22 00:00:00  MG00000002  2020-05-13 11:45:20  AG02000038  View Edit Delete
AG02100049  2018-05-21                              2018-05-21 14:09:09  MG00000001  2020-05-14 16:06:58  AG02100049  View Edit Delete

Page 49 of 250, showing 20 records out of 5000 total, starting on record 961, ending on 980

(default) 2 queries took 18 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 960, 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 = 11111