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
AG01001932  01001932  Tかじもと農園  かじもとのうえん  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001933  01001933  T乾燥しいたけスライス  かんそうしいたけすらいす  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001934  01001934  T煎茶  せんちゃ  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001956  01001956  Tゆずみそちりめん  ゆずみそちりめん  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001957  01001957  Tおっさんみそ  おっさんみそ  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG01001979  01001979  T薄木数行  うすきかずゆき  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4      2019-11-14 21:07:36  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2018-09-10 09:57:14  AG01001979  View Edit Delete
AG01001994  01001994  T鈴木茂昌  すずきもりまさ  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4      2024-01-17 16:01:47  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2018-07-20 13:11:31  MG00000001  View Edit Delete
AG01001995  01001995  T白井悠貴  しらいゆうき  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4  info@shiraibudou.farm    2024-01-19 09:08:09  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2022-06-10 15:29:31  MG00000001  View Edit Delete
AG01001996  01001996  T二川大地  ふたがわだいち  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4      2024-01-23 09:54:41  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2020-02-27 09:31:44  AG01001996  View Edit Delete
AG01001998  01001998  T松尾和也  まつおかずや  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4      2024-01-24 10:00:37  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2018-07-20 13:13:55  AG01001998  View Edit Delete
AG01002006  01002006  T野口拓朗  のぐちたくろう  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4      2024-01-24 09:43:18  2016-08-29 00:00:00    2016-08-30 12:23:32  MG00000001  2022-01-17 10:33:41  MG00000001  View Edit Delete
AG01002018  01002018  T平井広昭  ひらいひろあき  01  a380abea9159183e2b32fca70c0c33268997835b  0ms784213883m0b@ezweb.ne.jp    2021-10-15 07:27:11  2016-08-29 00:00:00    2016-08-30 12:23:33  MG00000001  2022-06-13 09:23:08  MG00000001  View Edit Delete
AG01002021  01002021  T野田勝利  のだかつのり  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4      2019-08-16 16:15:38  2016-08-29 00:00:00    2016-08-30 12:23:33  MG00000001  2018-09-10 10:00:38  AG01002021  View Edit Delete
AG01002030  01002030  TAKファーム  えいけいふぁーむ  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4      2018-08-03 09:01:14  2016-08-29 00:00:00    2016-08-30 12:23:33  MG00000001  2018-08-03 09:01:47  MG00000001  View Edit Delete
AG01002042  01002042  T前堀啓二  まえぼりけいじ  01  173084370924d2b1cd05a936aadac753db795040  daichi.aozora@gmail.com    2018-07-13 13:37:27  2016-08-29 00:00:00    2016-08-30 12:23:33  MG00000001  2019-06-06 10:30:23  MG00000001  View Edit Delete
AG01002075  01002075  T林田由美  はやしだゆみ  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4      2019-08-07 10:36:11  2016-08-29 00:00:00    2016-08-30 12:23:33  MG00000001  2018-09-10 10:06:02  AG01002075  View Edit Delete
AG01002084  01002084  T永田和也  ながたかずや  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4      2023-12-26 21:11:56  2016-08-29 00:00:00    2016-08-30 12:23:33  MG00000001  2022-06-13 09:29:36  MG00000001  View Edit Delete
AG01002088  01002088  T今田雅人  いまだまさと  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4      2021-03-15 09:09:16  2016-08-29 00:00:00    2016-08-30 12:23:33  MG00000001  2018-09-10 10:03:48  AG01002088  View Edit Delete
AG01002100  01002100  T高橋光男  たかはしみつお  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4      2024-01-24 09:01:42  2016-08-29 00:00:00    2016-08-30 12:23:33  MG00000001  2023-05-24 14:59:43  MG00000001  View Edit Delete
AG01002102  01002102  T谷本農園(飯山)  たにもとのうえん  01  697c8cd626f6b7afe9dbc8a1230512d8a342fc77  rz534832@yj9.so-net.ne.jp    2020-11-30 11:02:59  2016-08-29 00:00:00    2016-08-30 12:23:33  MG00000001  2017-10-04 14:25:39  AG01002102  View Edit Delete

Page 12 of 256, showing 20 records out of 5104 total, starting on record 221, ending on 240

(default) 2 queries took 104 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 220, 20202030
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