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
AG01001048  01001048  T光川真一  みつかわしんいち  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-08-01 17:09:17  2016-08-29 00:00:00    2016-08-30 12:23:24  MG00000001  2017-07-28 11:45:05  MG00000001  View Edit Delete
AG01001087  01001087  T竹島和宏  やまとあぐろふぁーむ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2023-07-03 16:53:09  2016-08-29 00:00:00    2016-08-30 12:23:25  MG00000001  2022-06-15 08:49:31  MG00000001  View Edit Delete
AG01001107  01001107  T吉元サト子  よしもとさとこ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-08-01 17:11:19  2016-08-29 00:00:00    2016-08-30 12:23:25  MG00000001  2017-07-28 11:46:58  MG00000001  View Edit Delete
AG01001108  01001108  T奥八重子  おくやえこ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-10-25 18:18:19  2016-08-29 00:00:00    2016-08-30 12:23:25  MG00000001  2017-07-28 11:49:26  MG00000001  View Edit Delete
AG01001152  01001152  T東條裕子  とうじょうゆうこ  01  8f14cf117c8a77a294a63f30d72fe4b94f945c5f      2017-05-17 17:23:38  2016-08-29 00:00:00    2016-08-30 12:23:25  MG00000001  2017-03-03 14:02:53  MG00000001  View Edit Delete
AG01001155  01001155  T大和アグロファーム(キリン堂)  やまとあぐろふぁーむ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2019-10-29 11:49:39  2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:25  MG00000001  2017-10-20 15:42:46  AG01001155  View Edit Delete
AG01001168  01001168  T長谷川浩  はせがわひろし  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2024-01-20 08:57:56  2016-08-29 00:00:00    2016-08-30 12:23:25  MG00000001  2021-12-07 12:45:43  MG00000001  View Edit Delete
AG01001183  01001183  T吉村信雄  よしむらのぶお  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-08-01 17:24:11  2016-08-29 00:00:00    2016-08-30 12:23:25  MG00000001  2017-07-28 11:52:49  MG00000001  View Edit Delete
AG01001224  01001224  T羽山末和  はねやますえかず  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-12 18:32:35  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-08-03 17:56:01  MG00000002  View Edit Delete
AG01001244  01001244  Tファームとくしま  ふぁーむとくしま  01  8f14cf117c8a77a294a63f30d72fe4b94f945c5f      2017-06-07 16:39:16  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-03-09 10:59:32  MG00000001  View Edit Delete
AG01001246  01001246  Tあわアグリ  あわあぐり  02  87b61df05017322dc411d6eca20a205f57ed487e      2021-11-02 10:16:24  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2023-03-07 15:08:39  MG00000001  View Edit Delete
AG01001247  01001247  Tエルクス  えるくす  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-26 10:39:00  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001248  01001248  Tコルツファーム井村  こるつふぁーむいむら  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001249  01001249  Tそよ風農園  そよかぜのうえん  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001250  01001250  T仁木光俊  にきみつとし  01  87b61df05017322dc411d6eca20a205f57ed487e      2023-12-28 14:49:17  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2022-03-11 16:34:26  MG00000001  View Edit Delete
AG01001251  01001251  Tひい農園  ひいのうえん  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001252  01001252  T三澤勉  みさわつとむ  01  87b61df05017322dc411d6eca20a205f57ed487e  ah19810524@icloud.com    2023-12-01 14:17:42  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2022-05-17 16:55:46  MG00000001  View Edit Delete
AG01001253  01001253  Tベジハッピークラブ  べじはっぴーくらぶ  01  87b61df05017322dc411d6eca20a205f57ed487e      2023-08-04 14:10:13  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001254  01001254  Tマルチ園大久保  まるちえんおおくぼ  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001255  01001255  Tやまちゃん農園  やまちゃんのうえん  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:26  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete

Page 3 of 256, showing 20 records out of 5104 total, starting on record 41, ending on 60

(default) 2 queries took 101 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 40, 20202029
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