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
AG01004664  01004664  T小松菜  こまつな  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-06-09 15:08:05  2022-05-09 00:00:00    2022-05-09 11:30:40  MG00000001  2022-05-09 11:30:40  MG00000001  View Edit Delete
AG01004665  01004665  Tそらまめ  そらまめ  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40        2022-05-09 00:00:00    2022-05-09 11:44:25  MG00000001  2022-05-09 11:44:25  MG00000001  View Edit Delete
AG01004666  01004666  Tそらまめ(赤)  そらまめあか  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40        2022-05-09 00:00:00    2022-05-09 11:47:07  MG00000001  2022-05-09 11:47:07  MG00000001  View Edit Delete
AG01004667  01004667  Tブロッコリー  ぶろっこりー  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-05-12 10:46:35  2022-05-09 00:00:00    2022-05-09 11:48:59  MG00000001  2022-05-09 11:48:59  MG00000001  View Edit Delete
AG01004668  01004668  T九条葱(京都府産)  くじょうねぎ  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-07-14 11:16:11  2022-05-09 00:00:00    2022-05-09 11:50:55  MG00000001  2022-05-09 11:50:55  MG00000001  View Edit Delete
AG01004669  01004669  Tチンゲン菜  ちんげんさい  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-05-12 13:00:49  2022-05-09 00:00:00    2022-05-09 11:53:10  MG00000001  2022-05-09 11:53:10  MG00000001  View Edit Delete
AG01004670  01004670  Tスナップえんどう  すなっぷえんどう  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-05-16 14:22:16  2022-05-09 00:00:00    2022-05-09 12:01:18  MG00000001  2022-05-09 12:01:18  MG00000001  View Edit Delete
AG01004671  01004671  T赤えんどう  あかえんどう  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-05-16 14:43:04  2022-05-09 00:00:00    2022-05-09 12:04:50  MG00000001  2022-05-09 12:04:50  MG00000001  View Edit Delete
AG01004672  01004672  T万能ねぎ  ばんのうねぎ  01  ad6d1c8aa6dd839cf4bde3baef1e4b667023ab40      2022-06-08 15:16:09  2022-05-09 00:00:00    2022-05-09 12:06:45  MG00000001  2022-05-09 12:06:45  MG00000001  View Edit Delete
AG01004673  01004673  T弓場一郎  ゆみばいちろう  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4        2022-05-10 00:00:00    2022-05-10 09:07:49  MG00000001  2022-05-10 09:07:49  MG00000001  View Edit Delete
AG01004674  01004674  T桑原秀実  くわばらひでみ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4        2022-05-10 00:00:00    2022-05-10 09:11:40  MG00000001  2022-05-10 09:11:40  MG00000001  View Edit Delete
AG01004675  01004675  T川本信治  かわもとしんじ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4        2022-05-10 00:00:00    2022-05-10 09:20:19  MG00000001  2022-05-10 09:20:19  MG00000001  View Edit Delete
AG01004676  01004676  T鈴木宏  すずきひろし  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4        2022-05-10 00:00:00    2022-05-10 09:33:25  MG00000001  2022-05-10 09:33:25  MG00000001  View Edit Delete
AG01004677  01004677  T岡本彰文  おかもとあきふみ  01  b9325ace7d99a05fe3b965b8671885aaab4513b4      2023-08-23 20:10:31  2022-05-10 00:00:00    2022-05-10 13:25:51  MG00000001  2022-05-10 13:25:51  MG00000001  View Edit Delete
AG01004678  01004678  T森岡康次  もりおかやすじ  01  b9325ace7d99a05fe3b965b8671885aaab4513b4      2023-11-14 08:28:36  2022-05-10 00:00:00    2022-05-10 13:32:13  MG00000001  2022-05-10 13:32:13  MG00000001  View Edit Delete
AG01004679  01004679  T山本敏雄  やまもととしお  01  b9325ace7d99a05fe3b965b8671885aaab4513b4      2024-01-20 07:36:56  2022-05-10 00:00:00    2022-05-10 13:34:01  MG00000001  2023-11-27 11:18:59  MG00000001  View Edit Delete
AG01004680  01004680  T小林則子  こばやしのりこ  01  b9325ace7d99a05fe3b965b8671885aaab4513b4      2023-09-16 07:19:22  2022-05-10 00:00:00    2022-05-10 13:37:08  MG00000001  2022-05-10 13:37:08  MG00000001  View Edit Delete
AG01004681  01004681  T山本成  やまもとせい  01  b9325ace7d99a05fe3b965b8671885aaab4513b4      2023-12-16 08:09:07  2022-05-10 00:00:00    2022-05-10 13:39:46  MG00000001  2022-05-10 13:39:46  MG00000001  View Edit Delete
AG01004682  01004682  T小林正史  こばやしまさふみ  01  b9325ace7d99a05fe3b965b8671885aaab4513b4      2023-08-23 17:09:11  2022-05-10 00:00:00    2022-05-10 13:41:23  MG00000001  2022-05-10 13:41:23  MG00000001  View Edit Delete
AG01004683  01004683  T和田守央  わだもりお  01  b9325ace7d99a05fe3b965b8671885aaab4513b4      2024-01-16 08:18:50  2022-05-10 00:00:00    2022-05-10 13:43:36  MG00000001  2022-05-10 13:43:36  MG00000001  View Edit Delete

Page 86 of 256, showing 20 records out of 5104 total, starting on record 1701, ending on 1720

(default) 2 queries took 162 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 1700, 20202088
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 = 11174