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
AG01005090  01005090  T吉岡秀掲  よしおかひでお  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-24 14:33:33  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-10-21 10:50:13  MG00000001  View Edit Delete
AG01005091  01005091  T吉田 誠浩  よしだせいじ  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-21 15:49:41  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005092  01005092  T吉永 広明  よしながひろあき  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-01-12 12:52:56  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005093  01005093  T渡辺 いずみ  わたなべいずみ  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-06-20 10:36:19  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005094  01005094  T渡部一生  わたべかずお  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-18 14:02:42  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2023-01-25 14:24:14  MG00000001  View Edit Delete
AG01005095  01005095  T渡辺 美和  わたなべみわ  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-06-19 14:44:52  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005096  01005096  T池田 美香  いけだみか  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-18 12:27:05  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005097  01005097  T北尾 和敏  きたおかずとし  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-05 14:05:18  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005098  01005098  T柴﨑 留美  しばさきとみ  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-08-13 14:25:46  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005099  01005099  Tふる里南島原便2  ふるさとゆうかびん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-23 18:23:00  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2023-03-30 11:00:59  MG00000001  View Edit Delete
AG01005100  01005100  Tふる里南島原便3  ふるさとゆうかびん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-24 09:35:27  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2023-03-30 11:01:19  MG00000001  View Edit Delete
AG01005101  01005101  Tふる里南島原便4  ふるさとゆうかびん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-23 14:38:12  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2023-03-30 11:01:47  MG00000001  View Edit Delete
AG01005102  01005102  Tふる里南島原便5  ふるさとゆうかびん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-21 18:06:56  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2023-03-30 11:02:22  MG00000001  View Edit Delete
AG01005103  01005103  Tふる里南島原便6  ふるさとゆうかびん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-21 18:08:39  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2023-03-30 11:02:48  MG00000001  View Edit Delete
AG01005104  01005104  Tふる里南島原便1  ふるさとゆうかびん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-23 18:19:50  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2023-03-30 11:00:37  MG00000001  View Edit Delete
AG01005105  01005105  T元村 勝久  もとむらかつひさ  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-09-15 14:40:57  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005107  01005107  T末吉 敬一  すえきちけいいち  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-01-12 13:01:34  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005108  01005108  T竹田 朱希  たけだみき  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-01-12 13:01:47  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005109  01005109  T中村物産株式会社  なかむらぶっさん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-21 18:57:29  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005110  01005110  T森川 拓海  もりかわたくみ  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-08-25 14:31:50  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete

Page 107 of 256, showing 20 records out of 5104 total, starting on record 2121, ending on 2140

(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`.`del_flg` asc LIMIT 2120, 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