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
AG01005264  01005264  T野田昭  のだひろし  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2023-05-15 11:15:50  2022-11-11 00:00:00    2022-11-11 10:09:38  MG00000001  2023-04-27 15:06:39  MG00000001  View Edit Delete
AG01005265  01005265  T奥山弥生  おくやまやよい  02  d98496bc13710e341b3e8cef8bdf56b92e8cf324        2022-11-11 00:00:00    2022-11-11 10:09:38  MG00000001  2022-12-22 09:31:11  MG00000001  View Edit Delete
AG01005266  01005266  T田中政一  たなかまさいち  02  d98496bc13710e341b3e8cef8bdf56b92e8cf324        2022-11-11 00:00:00    2022-11-11 10:09:38  MG00000001  2022-11-11 11:01:20  MG00000001  View Edit Delete
AG01005267  01005267  T大角祐美  おおすみゆみ  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2023-02-27 02:57:01  2022-11-11 00:00:00    2022-11-11 10:09:38  MG00000001  2022-11-11 10:09:38  MG00000001  View Edit Delete
AG01005268  01005268  T今倉昌子  いまくらしょうこ  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2023-01-24 10:32:54  2022-11-11 00:00:00    2022-11-11 10:09:38  MG00000001  2022-11-11 10:09:38  MG00000001  View Edit Delete
AG01005269  01005269  T新居紀子  しんきょきこ  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2023-03-17 09:09:30  2022-11-11 00:00:00    2022-11-11 10:09:38  MG00000001  2022-11-11 10:09:38  MG00000001  View Edit Delete
AG01005270  01005270  T原田翔  はらだしょう  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2024-01-24 10:07:13  2022-11-11 00:00:00    2022-11-11 10:09:38  MG00000001  2022-11-11 10:09:38  MG00000001  View Edit Delete
AG01005271  01005271  T小川大輔  おがわだいすけ  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2023-12-04 11:44:34  2022-11-11 00:00:00    2022-11-11 10:09:38  MG00000001  2022-11-11 10:09:38  MG00000001  View Edit Delete
AG01005272  01005272  T藤本秀典  ふじもとひでのり  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2023-02-21 09:53:14  2022-11-11 00:00:00    2022-11-11 10:09:38  MG00000001  2022-11-11 10:09:38  MG00000001  View Edit Delete
AG01005273  01005273  T畑山真也  なたやましんや  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2024-01-19 11:12:39  2022-11-11 00:00:00    2022-11-11 10:09:38  MG00000001  2022-11-11 10:09:38  MG00000001  View Edit Delete
AG01005274  01005274  T豊花農園  とよはなのうえん  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324        2022-11-11 00:00:00    2022-11-11 11:22:10  MG00000001  2022-11-11 11:22:10  MG00000001  View Edit Delete
AG01005275  01005275  T木内農園  きうちのうえん  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324        2022-11-11 00:00:00    2022-11-11 11:58:56  MG00000001  2022-11-11 11:58:56  MG00000001  View Edit Delete
AG01005276  01005276  TポテトJOBファーム  ぽてとじょぶふぁーむ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-23 10:52:32  2022-11-11 00:00:00    2022-11-11 18:28:20  MG00000001  2022-11-11 18:28:20  MG00000001  View Edit Delete
AG01005277  01005277  T泊農園  はくのうえん  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324        2022-11-16 00:00:00    2022-11-16 10:20:59  MG00000001  2022-11-16 10:20:59  MG00000001  View Edit Delete
AG01005278  01005278  T生島秀之  いくしまひでゆき  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2023-05-09 10:29:46  2022-11-16 00:00:00    2022-11-16 10:31:19  MG00000001  2022-11-16 10:31:19  MG00000001  View Edit Delete
AG01005279  01005279  T田中ファーム  たなかふぁーむ  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2023-01-20 11:18:44  2022-11-16 00:00:00    2022-11-16 10:33:41  MG00000001  2022-11-16 10:33:41  MG00000001  View Edit Delete
AG01005280  01005280  Tつるぎ農園  つるぎのうえん  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324        2022-11-16 00:00:00    2022-11-16 10:36:27  MG00000001  2022-11-16 10:36:27  MG00000001  View Edit Delete
AG01005281  01005281  T久米美恵子  くるめみえこ  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2023-01-20 11:19:25  2022-11-16 00:00:00    2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete
AG01005282  01005282  T大亀寿秀  おおがめひさひで  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324        2022-11-16 00:00:00    2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete
AG01005283  01005283  T大塚正時  おおつかしょうじ  01  d98496bc13710e341b3e8cef8bdf56b92e8cf324      2023-01-20 11:19:39  2022-11-16 00:00:00    2022-11-16 10:39:44  MG00000001  2022-11-16 10:39:44  MG00000001  View Edit Delete

Page 116 of 256, showing 20 records out of 5104 total, starting on record 2301, ending on 2320

(default) 2 queries took 194 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 2300, 202020118
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 = 11176