Users

Id Login User Nm User Fk User Type Password Mail Address 1 Mail Address 2 Login Rock Flg Last Login Day Use Start Day Use End Day Del Flg Init Pass Flg Created Insert User Modified Update User Actions
AG01001279  01001279  T住友英一  すみともえいいち  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001282  01001282  T西本啓子  にしもとけいこ  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001283  01001283  T石田幸夫  いしださちお  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001285  01001285  T川添フルーツ  かわぞえふるーつ  01  87b61df05017322dc411d6eca20a205f57ed487e      2023-02-15 13:34:08  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001286  01001286  T川添果樹園  かわぞえかじゅえん  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001288  01001288  T大住いちご園  おおすみいちごえん  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001289  01001289  T堤匡史  つつみただし  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001290  01001290  T田村宏  たむらひろし  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001291  01001291  T田中俊充  たなかとしみつ  01  87b61df05017322dc411d6eca20a205f57ed487e      2023-08-02 10:55:08  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001292  01001292  T唐渡義伯  からとよしみち  01  87b61df05017322dc411d6eca20a205f57ed487e      2023-02-15 14:21:17  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001293  01001293  T藤井陽一  ふじいよういち  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001295  01001295  T徳島野菜生産者共同組合  とくしまやさいせいさんしゃきょうどうくみあい  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001297  01001297  T楠正人  くすのきまさと  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001298  01001298  T武市美千代  たけいちみちよ  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001300  01001300  T武澤農園  たけさわのうえん  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001301  01001301  T平島義嗣  ひらじまよしつぐ  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:27  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001302  01001302  T木元彰彦  きもとあきひこ  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:27  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001304  01001304  T矢田高士  やだこうし  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:27  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001308  01001308  T吉永昭二  よしながしょうじ  02  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:27  MG00000001  2022-11-21 09:35:40  MG00000001  View Edit Delete
AG01001309  01001309  T日清紡  にっしんぼう  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:27  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete

Page 2 of 256, showing 20 records out of 5104 total, starting on record 21, ending on 40

(default) 2 queries took 327 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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`, `Admin`.`user_id`, `Admin`.`mail_flg`, `Admin`.`created`, `Admin`.`insert_user`, `Admin`.`modified`, `Admin`.`update_user`, `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`, `TraderUser`.`user_id`, `TraderUser`.`trader_id`, `TraderUser`.`created`, `TraderUser`.`insert_user`, `TraderUser`.`modified`, `TraderUser`.`update_user`, `UsersPickupPoint`.`farmer_id`, `UsersPickupPoint`.`pickup_point_id`, `UsersPickupPoint`.`use_start_day`, `UsersPickupPoint`.`use_end_day`, `UsersPickupPoint`.`created`, `UsersPickupPoint`.`insert_user`, `UsersPickupPoint`.`modified`, `UsersPickupPoint`.`update_user`, `TradersFarmer`.`farmer_id`, `TradersFarmer`.`trader_id`, `TradersFarmer`.`farmer_cd`, `TradersFarmer`.`created`, `TradersFarmer`.`insert_user`, `TradersFarmer`.`modified`, `TradersFarmer`.`update_user`, `TradersPickupPoint`.`pickup_point_id`, `TradersPickupPoint`.`trader_user_id`, `TradersPickupPoint`.`use_start_day`, `TradersPickupPoint`.`use_end_day`, `TradersPickupPoint`.`created`, `TradersPickupPoint`.`insert_user`, `TradersPickupPoint`.`modified`, `TradersPickupPoint`.`update_user` FROM `sato_agri`.`users` AS `User` LEFT JOIN `sato_agri`.`admins` AS `Admin` ON (`Admin`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Farmer`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`trader_users` AS `TraderUser` ON (`TraderUser`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` ON (`UsersPickupPoint`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_farmers` AS `TradersFarmer` ON (`TradersFarmer`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_pickup_points` AS `TradersPickupPoint` ON (`TradersPickupPoint`.`trader_user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY `User`.`mail_address_1` asc LIMIT 20, 202020252
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`users` AS `User` LEFT JOIN `sato_agri`.`admins` AS `Admin` ON (`Admin`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Farmer`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`trader_users` AS `TraderUser` ON (`TraderUser`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` ON (`UsersPickupPoint`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_farmers` AS `TradersFarmer` ON (`TradersFarmer`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_pickup_points` AS `TradersPickupPoint` ON (`TradersPickupPoint`.`trader_user_id` = `User`.`id`) WHERE 1 = 11175