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
AG01005211  01005211  T七郎屋清水正和  しちろうやしみずまさかず  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-02-24 14:38:59  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005212  01005212  T森塚伸二  もりづかしんじ  01  05abfe712847623b3fd7f24f58f661a2856c36b5        2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005213  01005213  T上田勝義  うえだかつよし  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-18 12:34:43  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005214  01005214  T(株)アグリコーポレーション  あぐりこーぽれーしょん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-18 12:24:37  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2023-02-03 08:52:58  MG00000001  View Edit Delete
AG01005215  01005215  Tふる里南島原便1  ふるさとみなみしまばらびん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-03-29 18:43:05  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005216  01005216  Tふる里南島原便2  ふるさとみなみしまばらびん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-03-29 18:44:12  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005217  01005217  Tふる里南島原便3  ふるさとみなみしまばらびん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-03-30 14:32:56  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005218  01005218  Tふる里南島原便4  ふるさとみなみしまばらびん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-03-30 14:32:12  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005219  01005219  Tふる里南島原便5  ふるさとみなみしまばらびん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-03-30 14:31:35  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005220  01005220  Tふる里南島原便6  ふるさとみなみしまばらびん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-12 17:04:48  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005221  01005221  T株式会社まるまさ  かぶしきがいしゃまるまさ  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-20 09:46:41  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005222  01005222  T林田和也  はやしだかずや  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-09-19 08:44:18  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005223  01005223  T塩田治俊  しおたまさとし  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-05 14:05:44  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005224  01005224  T中里典枝  なかさとのりえ  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-12-21 15:37:16  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005225  01005225  T直塚一考  ただつかかずのり  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-02-24 15:54:47  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005226  01005226  T九州きばる株式会社  きゅうしゅうきばる  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-24 08:29:09  2022-10-19 00:00:00    2022-10-19 16:32:38  MG00000001  2022-10-19 16:32:38  MG00000001  View Edit Delete
AG01005227  01005227  T嶺実男  みねみつお  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-03-28 16:45:17  2022-10-21 00:00:00    2022-10-21 09:07:50  MG00000001  2022-10-21 09:07:50  MG00000001  View Edit Delete
AG01005228  01005228  T西九州マルタ高柳善仁  にしきゅうしゅうまるた  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-11-27 08:01:41  2022-10-21 00:00:00    2022-10-21 09:10:28  MG00000001  2022-10-21 09:10:28  MG00000001  View Edit Delete
AG01005229  01005229  T早田隆雄  そうだたかお  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-10-31 19:03:49  2022-10-21 00:00:00    2022-10-21 09:11:47  MG00000001  2022-10-21 09:11:47  MG00000001  View Edit Delete
AG01005230  01005230  T有家生産組合  ゆうけせいさんくみあい  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-18 12:25:50  2022-10-21 00:00:00    2022-10-21 09:14:12  MG00000001  2022-10-21 09:14:12  MG00000001  View Edit Delete

Page 113 of 256, showing 20 records out of 5104 total, starting on record 2241, ending on 2260

(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 2240, 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