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
AG01005684  01005684  T(直)森崎 優佳  もりさきゆか  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-09-03 11:00:05  2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
AG01005685  01005685  T(直)井上しいたけ園  いのうえしいたけえん  01  a414b2d4cfef84f98d8c45e856482cf9c215707c      2023-09-03 11:00:36  2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
AG01005686  01005686  T土井 明仁  どいあきひと  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-12 15:05:19  2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
AG01005687  01005687  T寺田 大地  てらだだいち  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2024-01-24 09:42:06  2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
AG01005688  01005688  T森崎 武春  もりさきたけはる  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-11-04 11:12:45  2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
AG01005689  01005689  T岡本淳一(穂谷)  おかもとじゅんいちほたに  01  53f33fde010262a202402871990526942d6c949e      2024-01-19 14:37:20  2023-09-08 00:00:00    2023-09-08 10:07:09  MG00000001  2023-09-08 10:07:09  MG00000001  View Edit Delete
AG01005690  01005690  T岡本千代(穂谷)  おかもとちよほたに  01  53f33fde010262a202402871990526942d6c949e      2024-01-19 14:26:47  2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
AG01005691  01005691  T重村政子(穂谷)  しげむらまさこほたに  01  53f33fde010262a202402871990526942d6c949e      2024-01-19 14:47:33  2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
AG01005692  01005692  T谷口玲子(穂谷)  たにぐちれいこほたに  01  53f33fde010262a202402871990526942d6c949e      2024-01-19 14:42:14  2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
AG01005693  01005693  T井上育子(穂谷)  いのうえいくこほたに  01  53f33fde010262a202402871990526942d6c949e      2024-01-05 11:23:34  2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
AG01005694  01005694  T穂谷自然農園  ほたにしぜんのうえん  01  53f33fde010262a202402871990526942d6c949e      2023-12-15 13:54:12  2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
AG01005695  01005695  T新田育郎(穂谷)  にったいくろうほたに  01  53f33fde010262a202402871990526942d6c949e      2024-01-12 11:54:18  2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
AG01005696  01005696  T阿部亜紀(穂谷)  あべあきほたに  01  53f33fde010262a202402871990526942d6c949e      2024-01-23 15:19:10  2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
AG01005697  01005697  Tあさひファーム  あさひふぁーむ  01  2f0c78a81cd898220d61897f96ddf022065401f7      2023-09-12 17:24:08  2023-09-12 00:00:00    2023-09-12 00:00:00  MG00000001  2023-09-12 00:00:00  MG00000001  View Edit Delete
AG01005698  01005698  T泉南グリーンファーム(泉南)  せんなんぐりーんふぁーむせんなん  01  c80da4b6a537d3260687f0bc750db8dc82965c57      2023-11-11 15:23:22  2023-09-13 00:00:00    2023-09-13 09:44:57  MG00000001  2023-09-13 09:44:57  MG00000001  View Edit Delete
AG01005699  01005699  T口野有規(泉南)  くちのゆうきせんなん  01  c80da4b6a537d3260687f0bc750db8dc82965c57      2024-01-15 10:40:30  2023-09-13 00:00:00    2023-09-13 00:00:00  MG00000001  2023-09-13 00:00:00  MG00000001  View Edit Delete
AG01005700  01005700  T渡邊隆哉(泉南)  わたなべたかやせんなん  01  c80da4b6a537d3260687f0bc750db8dc82965c57      2023-12-19 14:05:23  2023-09-13 00:00:00    2023-09-13 00:00:00  MG00000001  2023-09-13 00:00:00  MG00000001  View Edit Delete
AG01005701  01005701  T上野麻紀子(泉南)  うえのまきこせんなん  01  c80da4b6a537d3260687f0bc750db8dc82965c57      2024-01-22 10:04:51  2023-09-13 00:00:00    2023-09-13 00:00:00  MG00000001  2023-09-13 00:00:00  MG00000001  View Edit Delete
AG01005702  01005702  T南出昭人(泉南)  みなみであきとせんなん  01  c80da4b6a537d3260687f0bc750db8dc82965c57      2023-10-27 16:55:36  2023-09-13 00:00:00    2023-09-13 00:00:00  MG00000001  2023-09-13 00:00:00  MG00000001  View Edit Delete
AG01005703  01005703  T井坂常典  いさかじょうてん  01  fc6f9792e236e87475b061b820ab409d54768952      2024-01-23 13:04:30  2023-09-13 00:00:00    2023-09-13 09:50:26  MG00000001  2023-09-13 09:50:26  MG00000001  View Edit Delete

Page 137 of 256, showing 20 records out of 5104 total, starting on record 2721, ending on 2740

(default) 2 queries took 216 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 2720, 202020144
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 = 11172