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
AG01005569  01005569  Tおかやま青果(岡山地区)  おかやませいかおかやまちく  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 10:10:00  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005570  01005570  Tおかやま青果(東備地区)  おかやませいかとうびちく  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-22 11:37:23  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005571  01005571  T安田孝治  やすだこうじ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 13:48:31  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005572  01005572  T大村ぶどう園  おおむらぶどうえん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-24 06:59:24  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005573  01005573  T青井悦子  あおいえつこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-10-12 12:06:48  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005574  01005574  T四谷道雄  よつやみちお  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-29 09:40:23  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005575  01005575  T岡﨑克哉  おかざきかつや  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-09-30 13:07:12  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005576  01005576  T株式会社百合貿易 代表 越野小百合  かぶしきがいしゃゆりぼうえきだいひょうこしのさゆり  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-18 14:23:18  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005577  01005577  T森本英次  もりもとえいじ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-14 11:38:43  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005578  01005578  T眞島昭人  まじまあきひと  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-10-12 18:56:56  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005579  01005579  T山口悟  やまぐちさとる  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-22 11:38:50  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005580  01005580  T西崎眞智子  にしざきまちこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-23 08:39:26  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005581  01005581  T平野勝美  ひらのかつみ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-10-10 11:36:36  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005582  01005582  T貞岡正和  ていおかまさかず  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-09-29 20:43:25  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005583  01005583  T柏えつこ  かしわえつこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-22 12:20:56  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005584  01005584  T柴田和正  しばたかずまさ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-10-11 12:04:17  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005585  01005585  T吉田秀敏  よしだひでとし  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-02 08:58:45  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005586  01005586  T美甘今子  みかもいまこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-23 08:54:49  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005587  01005587  T美甘久美子  みかもくみこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-23 08:37:18  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
AG01005588  01005588  T柳楽幸志  なぎらこうし  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-22 07:33:35  2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete

Page 109 of 256, showing 20 records out of 5104 total, starting on record 2161, ending on 2180

(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`.`update_user` asc LIMIT 2160, 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