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
AG01001878  01001878  T生島洋子  いくしまようこ  01  87b61df05017322dc411d6eca20a205f57ed487e      2024-01-20 12:03:37  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2022-05-18 13:27:16  MG00000001  View Edit Delete
AG01001879  01001879  T濱貴仁  はまたかひと  01  87b61df05017322dc411d6eca20a205f57ed487e      2023-02-15 14:35:33  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000002  View Edit Delete
AG01001888  01001888  T日開野誠  ひかいのまこと  01  87b61df05017322dc411d6eca20a205f57ed487e  agrihigaino@outlook.jp    2023-02-15 14:42:13  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2022-05-17 16:02:01  MG00000001  View Edit Delete
AG01001890  01001890  T隆農園  たかのうえん  01  87b61df05017322dc411d6eca20a205f57ed487e      2023-02-21 13:52:30  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000002  View Edit Delete
AG01001892  01001892  T橘明美  たちばなあけみ  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2024-01-23 00:18:50  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2022-02-24 11:38:00  MG00000001  View Edit Delete
AG01001894  01001894  T森乃葉  もりのは  01  87b61df05017322dc411d6eca20a205f57ed487e      2023-02-16 11:49:29  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001905  01001905  T四宮孝枝  しのみやたかえ  01  87b61df05017322dc411d6eca20a205f57ed487e      2023-07-29 15:08:02  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  AG01001905  View Edit Delete
AG01001906  01001906  T中村恒夫  なかむらつねお  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001910  01001910  T藤森正三  ふじもりしょうぞう  01  87b61df05017322dc411d6eca20a205f57ed487e      2023-02-15 14:49:16  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2022-05-18 13:27:59  MG00000001  View Edit Delete
AG01001911  01001911  T西本純  にしもとじゅん  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001915  01001915  T板東農園  ばんとうのうえん  01  8f14cf117c8a77a294a63f30d72fe4b94f945c5f      2017-06-26 17:18:18  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-05-11 13:33:01  MG00000001  View Edit Delete
AG01001918  01001918  T福生武彦  ふくおたけひこ  01  76206ffc287e97b0993a4d8fbbb237304ad2492a      2024-01-18 07:46:50  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2022-06-01 11:43:24  MG00000001  View Edit Delete
AG01001920  01001920  T仙石徹  せんごくとおる  01  87b61df05017322dc411d6eca20a205f57ed487e      2024-01-12 14:27:30  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001924  01001924  T山添裕人  あぐりべすと  01  87b61df05017322dc411d6eca20a205f57ed487e      2023-12-02 12:11:55  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2022-06-16 08:30:43  MG00000001  View Edit Delete
AG01001925  01001925  T西地食品(徳島市)  にしじしょくひんとくしまし  01  87b61df05017322dc411d6eca20a205f57ed487e      2023-02-15 14:30:23  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001926  01001926  T半田手延素麺 八千代  はんだてのべそうめん  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001927  01001927  Tゆずシロップ  ゆずしろっぷ  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001928  01001928  T霜ふりゆずジャム  しもふりゆずじゃむ  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001929  01001929  Tみちこの有機ぽんず  みちこのゆうきぽんず  01  87b61df05017322dc411d6eca20a205f57ed487e      2023-02-15 14:56:14  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001931  01001931  Tたむらのタマゴ  たむらのたまご  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete

Page 11 of 256, showing 20 records out of 5104 total, starting on record 201, ending on 220

(default) 2 queries took 102 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 LIMIT 200, 20202029
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 = 11173