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
AG01001852  2017-02-14    99                771-0203  徳島県板野郡北島町中村字本須47  088-698-3458        2016-08-30 12:23:31  AG01001852  2023-09-02 10:04:40  AG01001852  View Edit Delete
AG01001864  2017-01-18    99                            2016-08-30 12:23:31  MG00000001  2017-03-16 14:51:36  AG01001864  View Edit Delete
AG01001869  2017-09-25                              2016-08-30 12:23:32  AG01001869  2017-09-25 11:25:04  AG01001869  View Edit Delete
AG01001870  2017-09-25                              2016-08-30 12:23:32  MG00000001  2017-09-25 11:25:04  AG01001870  View Edit Delete
AG01001873  2017-09-25                              2016-08-30 12:23:32  MG00000001  2023-06-10 10:57:55  AG01001873  View Edit Delete
AG01001874  2017-06-16    貸し出し用機材  貸し出し用機材            771-1610  徳島県阿波市市場町香美字郷社の北2番地  090-5911-6216        2016-08-30 12:23:32  AG01001874  2022-12-26 16:53:09  AG01001874  View Edit Delete
AG01001875  2017-09-25                              2016-08-30 12:23:32  MG00000001  2023-02-02 15:27:22  AG01001875  View Edit Delete
AG01001878  2017-09-25                              2016-08-30 12:23:32  MG00000001  2023-08-09 13:20:29  AG01001878  View Edit Delete
AG01001879  2017-09-25                              2016-08-30 12:23:32  MG00000002  2023-02-02 15:32:05  AG01001879  View Edit Delete
AG01001888  2017-09-25                  779-3112  徳島県徳島市国府町芝原字橋本28  080-5577-9747        2016-08-30 12:23:32  MG00000001  2023-02-02 15:34:50  AG01001888  View Edit Delete
AG01001890  2017-09-25                              2016-08-30 12:23:32  MG00000002  2023-02-02 15:23:41  AG01001890  View Edit Delete
AG01001892  2017-10-01    6800                771-4301  徳島県勝浦郡勝浦町大字沼江字三ツ石42  0885-46-0519        2016-08-30 12:23:32  MG00000001  2023-01-24 11:12:56  AG01001892  View Edit Delete
AG01001894  2017-09-25                              2016-08-30 12:23:32  MG00000001  2023-02-16 11:49:29  AG01001894  View Edit Delete
AG01001905  2017-09-25                              2016-08-30 12:23:32  AG01001905  2023-02-02 15:18:15  AG01001905  View Edit Delete
AG01001910  2017-09-25                              2016-08-30 12:23:32  MG00000001  2023-02-02 15:37:17  AG01001910  View Edit Delete
AG01001915  2017-05-10    99                            2016-08-30 12:23:32  MG00000001  2017-05-11 13:34:31  AG01001915  View Edit Delete
AG01001918  2017-10-01    6800                779-3222  徳島県名西郡石井町高河原字市楽365-4  090-3187-8596      79878042  2016-08-30 12:23:32  MG00000001  2023-07-20 10:46:04  AG01001918  View Edit Delete
AG01001920  2017-09-25                              2016-08-30 12:23:32  MG00000001  2023-04-13 00:48:38  AG01001920  View Edit Delete
AG01001924  2017-09-25                              2016-08-30 12:23:32  MG00000001  2023-02-02 15:45:47  AG01001924  View Edit Delete
AG01001925  2017-09-25                              2016-08-30 12:23:32  MG00000001  2023-02-02 15:29:18  AG01001925  View Edit Delete

Page 7 of 250, showing 20 records out of 5000 total, starting on record 121, ending on 140

(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`.`update_user` asc LIMIT 120, 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