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
AG01004607  2021-12-03                              2021-12-03 11:09:22  MG00000001  2023-12-06 16:41:25  AG01004607  View Edit Delete
AG01004726  2022-05-25                              2022-05-25 13:09:09  MG00000001  2023-12-06 13:20:17  AG01004726  View Edit Delete
AG01005521  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-12-06 10:31:40  AG01005521  View Edit Delete
AG01005770  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-12-05 16:31:16  AG01005770  View Edit Delete
AG01004367  2021-03-09                              2021-03-09 11:09:11  MG00000005  2023-12-05 12:39:28  AG01004367  View Edit Delete
AG01005322  2022-11-21                              2022-11-21 09:54:45  AG01005322  2023-12-04 19:09:11  AG01005322  View Edit Delete
AG01004018  2020-02-19                              2020-02-19 11:28:55  MG00000001  2023-12-04 19:01:58  AG01004018  View Edit Delete
AG01005158  2022-09-30                              2022-09-30 14:22:50  MG00000001  2023-12-04 18:54:53  AG01005158  View Edit Delete
AG01005327  2022-11-21                              2022-11-21 09:54:45  MG00000001  2023-12-04 18:53:39  AG01005327  View Edit Delete
AG01005838  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-12-03 10:53:50  AG01005838  View Edit Delete
AG01005771  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-12-02 16:02:45  AG01005771  View Edit Delete
AG01001569  2017-01-16    91  3000  ご購入  ご自身のタブレット利用            771-1505  徳島県阿波市土成町郡624  088-695-3216        2016-08-30 12:23:29  AG01001569  2023-12-01 13:56:33  AG01001569  View Edit Delete
AG01001994  2017-04-12    貸し出し用機材  貸し出し用機材                        2016-08-30 12:23:32  MG00000001  2023-12-01 10:56:14  AG01001994  View Edit Delete
AG01004505  2021-04-26                              2021-04-26 17:25:58  MG00000001  2023-12-01 10:37:15  AG01004505  View Edit Delete
AG01004048  2020-05-01                              2020-05-01 16:09:06  MG00000001  2023-12-01 09:47:21  AG01004048  View Edit Delete
AG01005517  2023-07-03                              2023-07-03 00:00:00  MG00000001  2023-11-30 14:20:18  AG01005517  View Edit Delete
AG01004529  2021-06-11                              2021-06-11 09:09:05  MG00000001  2023-11-30 11:20:13  AG01004529  View Edit Delete
AG01005931  2023-10-25                              2023-10-25 00:00:00  MG00000001  2023-11-30 08:04:07  AG01005931  View Edit Delete
AG01005858  2023-10-16                              2023-10-16 00:00:00  MG00000001  2023-11-29 15:43:10  AG01005858  View Edit Delete
AG01005742  2023-09-28                              2023-09-28 00:00:00  MG00000001  2023-11-29 14:27:58  AG01005742  View Edit Delete

Page 10 of 250, showing 20 records out of 5000 total, starting on record 181, ending on 200

(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` desc LIMIT 180, 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