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
AG01003011  2017-08-17    貸し出し用機材  貸し出し用機材                          AG01003011  2018-06-11 21:36:25  AG01003011  View Edit Delete
AG01003379  2018-03-27    貸し出し用機材  貸し出し用機材                        2018-03-27 17:14:45  AG01003367  2018-06-11 12:56:05  AG01003379  View Edit Delete
AG01003381  2018-03-27    11  4800                771-1342  徳島県板野郡上板町佐藤塚字西167-1  090-1576-7015        2018-03-27 17:14:45  MG00000001  2018-06-11 10:14:17  AG01003381  View Edit Delete
AG05000011  2017-11-01                  349-0115  埼玉県蓮田市6          2017-11-01 11:34:46  MG00000001  2018-06-09 15:45:51  AG05000011  View Edit Delete
AG01002589  2017-03-15    11  4800                770-0062  徳島県徳島市不動東町5丁目457-2  090-2047-3888          MG00000002  2018-06-09 09:55:00  MG00000002  View Edit Delete
AG01001850  2017-03-15    11  4800                770-0062  徳島県徳島市不動東町5丁目457-2  090-2047-3888        2016-08-30 12:23:31  MG00000002  2018-06-09 09:54:28  MG00000002  View Edit Delete
AG03000017  2018-03-20                                MG00000001  2018-06-05 10:34:23  AG03000017  View Edit Delete
AG01003482  2018-05-31                              2018-05-31 09:50:45  MG00000001  2018-06-04 11:36:09  AG01003482  View Edit Delete
AG01003480  2018-05-31                              2018-05-31 09:49:24  MG00000001  2018-06-04 11:02:13  AG01003480  View Edit Delete
AG01003373  2018-03-09    貸し出し用機材  貸し出し用機材                        2018-03-09 17:29:49  AG01003373  2018-06-04 09:59:35  AG01003373  View Edit Delete
AG01003518  2018-06-01                              2018-06-01 15:18:00  MG00000001  2018-06-04 09:30:38  MG00000001  View Edit Delete
AG01003017  2017-09-11    5500  貸し出し用機材  貸し出し用機材                          MG00000002  2018-06-04 09:16:35  AG01003017  View Edit Delete
AG01003483  2018-06-01                              2018-06-01 15:18:09  MG00000001  2018-06-01 15:18:09  MG00000001  View Edit Delete
AG01003484  2018-06-01                              2018-06-01 15:18:00  MG00000001  2018-06-01 15:18:00  MG00000001  View Edit Delete
AG01003485  2018-06-01                              2018-06-01 15:18:00  MG00000001  2018-06-01 15:18:00  MG00000001  View Edit Delete
AG01003486  2018-06-01                              2018-06-01 15:18:00  MG00000001  2018-06-01 15:18:00  MG00000001  View Edit Delete
AG01003487  2018-06-01                              2018-06-01 15:18:00  MG00000001  2018-06-01 15:18:00  MG00000001  View Edit Delete
AG01003488  2018-06-01                              2018-06-01 15:18:00  MG00000001  2018-06-01 15:18:00  MG00000001  View Edit Delete
AG01003489  2018-06-01                              2018-06-01 15:18:00  MG00000001  2018-06-01 15:18:00  MG00000001  View Edit Delete
AG01003490  2018-06-01                              2018-06-01 15:18:00  MG00000001  2018-06-01 15:18:00  MG00000001  View Edit Delete

Page 232 of 250, showing 20 records out of 5000 total, starting on record 4621, ending on 4640

(default) 2 queries took 34 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 4620, 20202023
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