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
AG01003483  01003483  T上口嘉章  かみぐちよしあき  01  36b1fcdb66706b800161aaf145155ba1bc7fd5da        2018-06-01 00:00:00    2018-06-01 15:18:09  MG00000001  2018-06-01 15:18:09  MG00000001  View Edit Delete
AG01003531  01003531  T藤村正廣  ふじむらまさひろ  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2022-04-08 07:54:47  2018-06-05 00:00:00    2018-06-05 09:17:26  MG00000001  2018-06-05 09:17:26  MG00000001  View Edit Delete
AG01003532  01003532  T小西春吉  こにしはるきち  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2018-07-28 12:54:59  2018-06-11 00:00:00    2018-06-11 21:38:19  MG00000001  2018-06-11 21:39:01  MG00000001  View Edit Delete
AG01003533  01003533  T長江樹里男  ながえじゅりお  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2022-12-02 14:22:58  2018-06-15 00:00:00    2018-06-15 23:33:21  MG00000001  2018-06-15 23:33:21  MG00000001  View Edit Delete
AG01003534  01003534  T栗喜農園  くりきのうえん  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-02-21 09:53:06  2018-06-22 00:00:00    2018-06-22 09:45:46  MG00000001  2018-06-22 09:45:46  MG00000001  View Edit Delete
AG01003535  01003535  T富永誠  とみながまこと  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2023-11-14 13:49:07  2018-06-22 00:00:00    2018-06-22 09:46:36  MG00000001  2021-12-07 12:47:53  MG00000001  View Edit Delete
AG01003536  01003536  T京都長尾ファーム  きょうとながおふぁーむ  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-02-21 09:51:31  2018-06-22 00:00:00    2018-06-22 09:48:13  MG00000001  2018-06-22 09:48:13  MG00000001  View Edit Delete
AG01003537  01003537  T宮崎ファーミング②  みやざきふぁーみんぐに  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2019-07-06 08:11:08  2018-06-22 00:00:00    2018-06-22 13:19:14  MG00000001  2018-06-22 13:19:14  MG00000001  View Edit Delete
AG01003538  01003538  T永石俊夫  かぶしきがいしゃあいえぬえす  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2023-10-19 07:54:56  2018-07-02 00:00:00    2018-07-02 12:15:06  MG00000001  2022-06-14 10:38:35  MG00000001  View Edit Delete
AG01003539  01003539  T川村雅英  かわむらまさひで  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2019-01-15 08:12:53  2018-07-02 00:00:00    2018-07-02 12:15:58  MG00000001  2018-07-02 12:15:58  MG00000001  View Edit Delete
AG01003540  01003540  T栗原きのこ農園  くりはらきのこのうえん  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2019-05-10 15:03:08  2018-07-02 00:00:00    2018-07-02 12:16:52  MG00000001  2018-07-02 12:16:52  MG00000001  View Edit Delete
AG01003541  01003541  T小岸達也  こぎしたつや  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-04-10 07:53:00  2018-07-09 00:00:00    2018-07-09 11:16:49  MG00000001  2018-07-09 11:16:49  MG00000001  View Edit Delete
AG01003542  01003542  TOHNISHI AGRI ART  おおにしあぐりあーと  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-02-21 14:19:52  2018-07-09 00:00:00    2018-07-09 11:17:40  MG00000001  2018-07-23 10:44:33  AG01003542  View Edit Delete
AG01003543  01003543  T籾山宜隆  もみやまのりたか  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-08-23 07:54:42  2018-07-09 00:00:00    2018-07-09 11:22:26  MG00000001  2018-07-09 11:22:26  MG00000001  View Edit Delete
AG01003544  01003544  T城崎農園  しろさきのうえん  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-10-23 17:56:24  2018-07-09 00:00:00    2018-07-09 11:23:19  MG00000001  2018-07-09 11:23:19  MG00000001  View Edit Delete
AG01003545  01003545  T田内文弥  たうちふみや  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-02-21 14:25:22  2018-07-09 00:00:00    2018-07-09 11:24:12  MG00000001  2018-07-09 11:24:12  MG00000001  View Edit Delete
AG01003546  01003546  T上田三雄  うえだみつお  01  128daf96fd3b3f779b1dc0104b938fd122025e35      2019-02-21 14:21:59  2018-07-09 00:00:00    2018-07-09 11:27:24  MG00000001  2018-07-09 11:27:24  MG00000001  View Edit Delete
AG01003547  01003547  T北岡金夫  きたおかかねお  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2018-10-04 08:12:11  2018-07-09 00:00:00    2018-07-09 14:00:08  MG00000001  2018-07-09 14:00:08  MG00000001  View Edit Delete
AG01003548  01003548  T北岡秀隆  きたおかひでたか  01  cac7a3687b6ed9b2729ffee01f445c1938dcaf8d      2021-04-02 17:37:13  2018-07-09 00:00:00    2018-07-09 14:01:14  MG00000001  2018-07-09 14:01:14  MG00000001  View Edit Delete
AG01003549  01003549  T佐藤 頼孝  さとうよりたか  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2018-07-28 08:10:32  2018-07-11 00:00:00    2018-07-11 10:28:40  MG00000001  2018-07-11 10:28:40  MG00000001  View Edit Delete

Page 2 of 256, showing 20 records out of 5104 total, starting on record 21, ending on 40

(default) 2 queries took 319 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`.`mail_address_2` desc LIMIT 20, 202020244
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