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
AG01005451  01005451  T石尾照彦 K  いしおてるひこ  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-09-11 13:47:34  2023-03-27 00:00:00    2023-03-27 00:00:00  MG00000001  2023-03-29 11:19:27  AG01005451  View Edit Delete
AG01005452  01005452  T前田利信 K  まえだとしのぶ  01  0e8852433a57eb7742c6162444d97c02202e90b8        2023-03-27 00:00:00    2023-03-27 00:00:00  MG00000001  2023-03-27 00:00:00  MG00000001  View Edit Delete
AG01005453  01005453  T宅島涼 K  たくしまりょう  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-21 18:58:21  2023-03-30 00:00:00    2023-03-30 00:00:00  MG00000001  2023-04-01 00:52:21  AG01005453  View Edit Delete
AG01005454  01005454  T籔本明也  やぶもとあきや  01  2f0c78a81cd898220d61897f96ddf022065401f7      2023-05-03 07:28:11  2023-04-03 00:00:00    2023-04-03 11:03:46  MG00000001  2023-04-03 11:03:46  MG00000001  View Edit Delete
AG01005455  01005455  T狩野圭朗  かのよしろう  01  2f0c78a81cd898220d61897f96ddf022065401f7      2023-08-07 07:17:03  2023-04-03 00:00:00    2023-04-03 00:00:00  MG00000001  2023-04-03 00:00:00  MG00000001  View Edit Delete
AG01005456  01005456  T小林康三  こばやしこうぞう  01  2f0c78a81cd898220d61897f96ddf022065401f7      2024-01-21 09:19:37  2023-04-03 00:00:00    2023-04-03 00:00:00  MG00000001  2023-04-03 00:00:00  MG00000001  View Edit Delete
AG01005457  01005457  T生田理恵  いくたりえ  01  2f0c78a81cd898220d61897f96ddf022065401f7      2023-12-23 08:39:09  2023-04-03 00:00:00    2023-04-03 00:00:00  MG00000001  2023-04-03 00:00:00  MG00000001  View Edit Delete
AG01005458  01005458  T長谷川貴浩  はせがわたかはる  01  2f0c78a81cd898220d61897f96ddf022065401f7      2023-12-23 08:38:44  2023-04-03 00:00:00    2023-04-03 00:00:00  MG00000001  2023-04-03 00:00:00  MG00000001  View Edit Delete
AG01005459  01005459  T中上直久  なかうえなおひさ  01  2f0c78a81cd898220d61897f96ddf022065401f7      2024-01-19 16:34:34  2023-04-03 00:00:00    2023-04-03 00:00:00  MG00000001  2023-04-03 00:00:00  MG00000001  View Edit Delete
AG01005460  01005460  T石本貴美子  いしもときみこ  01  2f0c78a81cd898220d61897f96ddf022065401f7      2023-06-28 08:23:16  2023-04-03 00:00:00    2023-04-03 00:00:00  MG00000001  2023-04-03 00:00:00  MG00000001  View Edit Delete
AG01005461  01005461  T永里 まどか  ながさとまどか  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-07-05 15:38:04  2023-04-03 00:00:00    2023-04-03 00:00:00  MG00000001  2023-04-03 14:45:53  AG01005461  View Edit Delete
AG01005462  01005462  T井口賀夫  いぐちよしお  01  87b61df05017322dc411d6eca20a205f57ed487e      2024-01-11 13:56:12  2023-04-03 00:00:00    2023-04-03 00:00:00  MG00000001  2023-04-03 00:00:00  MG00000001  View Edit Delete
AG01005463  01005463  T林梨映  はやしりえ  01  87b61df05017322dc411d6eca20a205f57ed487e      2024-01-24 12:32:04  2023-04-03 00:00:00    2023-04-03 00:00:00  MG00000001  2023-04-03 00:00:00  MG00000001  View Edit Delete
AG01005464  01005464  T臼杵英樹  うすきひでき  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4      2023-05-16 15:46:18  2023-04-03 00:00:00    2023-04-03 00:00:00  MG00000001  2023-04-03 00:00:00  MG00000001  View Edit Delete
AG01005465  01005465  T稲田元正  いなだもとまさ  01  dfc96ca392c33bfe56e989a4cddc873aa65448b2      2024-01-22 20:37:29  2023-04-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
AG01005466  01005466  T小林幹可  こばやしみきよし  01  dfc96ca392c33bfe56e989a4cddc873aa65448b2      2024-01-09 13:01:31  2023-04-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-13 14:26:14  MG00000001  View Edit Delete
AG01005467  01005467  T河本光浩  こうもとみつひろ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-05-23 12:07:58  2023-04-11 00:00:00    2023-04-11 00:00:00  MG00000001  2023-04-11 00:00:00  MG00000001  View Edit Delete
AG01005468  01005468  T永野修平  ながのしゅうへい  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-10-07 14:07:44  2023-04-13 00:00:00    2023-04-13 00:00:00  MG00000001  2023-04-13 00:00:00  MG00000001  View Edit Delete
AG01005469  01005469  T山下剛世  やましたごうぜい  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-04-18 11:57:37  2023-04-13 00:00:00    2023-04-13 00:00:00  MG00000001  2023-04-13 00:00:00  MG00000001  View Edit Delete
AG01005470  01005470  T竹市和幸  たけいちかずゆき  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-11-26 09:52:05  2023-04-13 00:00:00    2023-04-13 00:00:00  MG00000001  2023-04-13 00:00:00  MG00000001  View Edit Delete

Page 105 of 256, showing 20 records out of 5104 total, starting on record 2081, ending on 2100

(default) 2 queries took 360 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`.`insert_user` asc LIMIT 2080, 202020283
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 = 11177