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
AG01005088  01005088  T横田 文  よこたふみ  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-23 10:49:06  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01005089  01005089  T吉岡 博  よしおかひろし  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-08-30 16:59:29  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
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
AG01005106  01005106  T石尾 照彦  いわおてるひこ  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2        2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2023-03-30 11:10:13  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

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

(default) 2 queries took 362 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` desc LIMIT 2080, 202020284
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 = 11178