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
AG01003341  01003341  Tえなみ農園Y  えなみのうえんわい  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-26 00:00:00  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003342  01003342  Tえなみ農園R  えなみのうえんあーる  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-26 00:00:00  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003343  01003343  Tえなみ農園S  えなみのうえんえす  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-26 00:00:00  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003344  01003344  Tタケモ(株)  たけもかぶしきがいしゃ  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-26 19:01:27  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003345  01003345  T飛川敏弘  とびかわとしひろ  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-26 00:00:00  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003346  01003346  T笹原  ささはら  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-30 09:57:40  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003347  01003347  T漆谷農園Uグループ  そめたにのうえんゆーぐるーぷ  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-26 00:00:00  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003348  01003348  T富沢農園  とみざわのうえん  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-26 00:00:00  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003349  01003349  T八田農園  やだのうえん  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-26 00:00:00  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003350  01003350  T井上農園  いのうえのうえん  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-05-09 15:25:15  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003351  01003351  T京都チーム亀岡1  きょうとちーむかめおかいち  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-12-03 17:43:16  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003352  01003352  T京都チーム亀岡2  きょうとちーむかめおかに  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-02-21 10:06:23  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003353  01003353  T京都チーム亀岡3  きょうとちーむかめおかさん  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2020-01-16 12:44:21  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003354  01003354  T京都チーム亀岡4  きょうとちーむかめおかよん  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-02-21 10:13:13  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003355  01003355  T京都チーム亀岡5  きょうとちーむかめおかご  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-02-21 10:15:29  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003356  01003356  TLEAFY  りーふぃ  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-26 00:00:00  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003357  01003357  T京野菜中善  きょうやさいなかぜん  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-26 00:00:00  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003358  01003358  Tファームセキモト  ふぁーむせきもと  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-12-20 10:05:43  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete
AG01003359  01003359  T橋本政明  はしもとまさあき  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2023-01-26 16:03:20  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2022-06-01 11:06:16  MG00000001  View Edit Delete
AG01003360  01003360  T俣野  またの  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2018-01-26 00:00:00  2018-01-26 00:00:00    2018-01-26 00:00:00  MG00000001  2018-01-26 00:00:00  MG00000001  View Edit Delete

Page 20 of 256, showing 20 records out of 5104 total, starting on record 381, ending on 400

(default) 2 queries took 106 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 380, 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 = 11176