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
AG01003281  01003281  T山本めい子  やまもとめいこ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2022-04-24 10:24:43  2017-10-30 00:00:00        2017-10-30 10:05:21  AG01003270  View Edit Delete
AG01003282  01003282  T山本覚大  やまもとあきひろ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2024-01-24 16:11:43  2017-10-30 00:00:00        2017-11-17 14:02:34  MG00000001  View Edit Delete
AG01003283  01003283  T杉本紘基  すぎもとひろき  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2020-06-27 10:27:26  2017-10-30 00:00:00            View Edit Delete
AG01003284  01003284  T藤原隆子  ふじわらたかこ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2018-09-25 16:55:02  2017-10-30 00:00:00            View Edit Delete
AG01003285  01003285  T山村敏秋  やまむらとしあき  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2023-03-20 15:39:00  2017-10-30 00:00:00            View Edit Delete
AG01003286  01003286  T山崎さつき  やまざきさつき  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2018-12-09 19:56:27  2017-10-30 00:00:00            View Edit Delete
AG01003287  01003287  T高森知佐子  たかもりちさこ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2018-12-09 19:58:58  2017-10-30 00:00:00            View Edit Delete
AG01003288  01003288  T原口俊晴  はらぐちとしはる  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2018-12-09 19:59:08  2017-10-30 00:00:00            View Edit Delete
AG01003289  01003289  T井手マサ子  いでまさこ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2022-11-14 16:26:54  2017-10-30 00:00:00            View Edit Delete
AG01003290  01003290  T㈱清和ミネラル会  せいわみねらるかい  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2020-09-25 07:34:11  2017-10-30 00:00:00            View Edit Delete
AG01003291  01003291  T上田清貴  うえだきよたか  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2018-05-03 15:33:10  2017-10-30 00:00:00            View Edit Delete
AG01003292  01003292  TMITSU THE FARM  みつざふぁーむ  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2018-12-01 12:17:23  2017-10-30 00:00:00        2017-10-30 15:44:16  AG01003292  View Edit Delete
AG01003293  01003293  T古野 克幸  ふるのかつゆき  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2018-07-03 11:59:44  2017-11-01 00:00:00        2017-10-30 15:44:16  AG01003292  View Edit Delete
AG01003294  01003294  T岸幸男  きしさちお  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2022-04-08 08:52:55  2017-11-09 00:00:00        2017-10-30 15:44:16  AG01003292  View Edit Delete
AG01003295  01003295  Tひきた農園  ひきたのうえん  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2018-12-13 08:57:51  2017-11-15 00:00:00        2017-09-19 16:42:53  MG00000001  View Edit Delete
AG01003296  01003296  T杉村園芸  すぎむらえんげい  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2018-11-22 09:23:15  2017-11-15 00:00:00        2017-09-19 16:42:53  MG00000001  View Edit Delete
AG01003297  01003297  T伊藤美津代  いとうみつよ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2020-09-02 07:22:23  2017-11-15 00:00:00        2017-10-30 10:05:21  AG01003270  View Edit Delete
AG01003298  01003298  T杉本トシヱ  すぎもととしえ  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2018-12-27 08:07:51  2017-11-15 00:00:00        2017-10-30 10:05:21  AG01003270  View Edit Delete
AG01003299  01003299  T山都市場生産者組合①  やまとしじょうせいさんしゃくみあいいち  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2019-03-20 14:05:59  2017-11-15 00:00:00        2017-10-30 10:05:21  AG01003270  View Edit Delete
AG01003300  01003300  T山都市場生産者組合②  やまとしじょうせいさんしゃくみあいに  01  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2019-03-20 14:44:28  2017-11-15 00:00:00        2017-10-30 10:05:21  AG01003270  View Edit Delete

Page 17 of 256, showing 20 records out of 5104 total, starting on record 321, ending on 340

(default) 2 queries took 105 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 320, 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 = 11175