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
TR08000108  vegeus-farm@arai-group.co.jp  T平塚土屋の直売所  ひらつかつちやのちょくばいじょ  11  c55104ba172037d21bbdad9518aa66b82bc97092  vegeus-farm@arai-group.co.jp    2024-01-24 12:06:03  2023-03-23 00:00:00    2023-03-23 13:36:27  MG00000001  2023-03-23 14:23:04  MG00000001  View Edit Delete
TR08000107  shouzou-saigusa@arai-group.co.jp  T三枝 賞造  さいぐさ しょうぞう  11  e3b8ace069bcb03280bdb518f575199bad65d066  shouzou-saigusa@arai-group.co.jp    2023-03-23 09:52:46  2018-11-26 00:00:00    2018-11-26 17:04:28  MG00000002  2023-03-23 13:16:57  MG00000001  View Edit Delete
TR08000106  test_arai@gmail.com  Tテスト_荒井ベジアス  てすとあらべじあす  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test_arai@gmail.com    2018-03-19 11:55:00  2018-03-10 17:59:39    2018-03-10 17:59:39    2018-03-10 18:02:18  MG00000002  View Edit Delete
TR08000001  08000001  T荒井ベジアス  あらいべじあす  11  170fb222d8782b2ac402824b541a26f7d9fe2f9c      2017-12-08 15:27:10  2018-03-08 00:00:00    2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
TR07000001  07000001  T山陽Amnak  さんようあむなっく  11  e41ecf46f6da93056732fbd1c5f5dd42c57bf83e      2017-12-08 15:27:10  2017-12-22 00:00:00    2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
TR05000105  kikuchi@okumurashoji.co.jp  T菊池  きくち  11  6f6bd0784f18eb7e8acf6a0008f519cf876b6571  kikuchi@okumurashoji.co.jp    2019-12-13 10:02:43  2018-04-20 00:00:00    2018-04-20 13:05:33  MG00000001  2019-01-03 14:58:23  MG00000001  View Edit Delete
TR05000104  nakayama@okumurashoji.co.jp  T中山  なかやま  11  fe18e2dd8fdcf5eca12a1019c4cf831c799a5d22  nakayama@okumurashoji.co.jp    2022-08-29 16:48:03  2018-04-20 00:00:00    2018-04-20 13:04:28  MG00000001  2018-04-20 17:49:48  MG00000001  View Edit Delete
TR05000103  test@okumurashoji.co.jp  T奥村商事(埼玉)テスト  おくむらしょうじてすと  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test@okumurashoji.co.jp    2022-06-29 14:23:41  2018-02-21 09:42:06    2018-02-21 09:42:06    2019-08-30 17:07:29  MG00000001  View Edit Delete
TR05000098  jab-keiri@okumurashoji.co.jp  T経理担当者  けいりたんとうしゃ  11  17cbd79a9a9ea21fe8df6ff4e2c97c944f4ed14c  jab-keiri@okumurashoji.co.jp    2017-12-27 16:55:43  2017-12-26 14:09:43    2017-12-26 14:09:43    2018-04-20 14:30:09  MG00000001  View Edit Delete
TR05000097  i.takeuchi@okumurashoji.co.jp  T竹内 今人  たけうち いまと  11  f074b51b1552e92541fa4f5c6ebf98153d15ac34  i.takeuchi@okumurashoji.co.jp    2018-03-29 17:17:43  2017-12-26 14:09:18    2017-12-26 14:09:18    2018-04-20 13:07:15  MG00000001  View Edit Delete
TR05000096  shimane@okumurashoji.co.jp  T島根 秀明  しまね ひであき  11  f918ab9cb639371db5c44c1b76f293414a0b7bd0  shimane@okumurashoji.co.jp    2019-05-24 16:51:27  2017-12-26 14:06:59    2017-12-26 14:06:59    2017-12-26 17:37:41  MG00000002  View Edit Delete
TR05000095  yamagishi@okumurashoji.co.jp  T山岸 愛  やまぎし あい  11  6548c964eb1e689c1c6561d647f33d7169360845  yamagishi@okumurashoji.co.jp    2022-10-25 10:03:56  2017-12-26 14:00:41    2017-12-26 14:00:41    2017-12-30 17:34:27  MG00000002  View Edit Delete
TR05000094  nagahara@okumurashoji.co.jp  T永原 鉄哉  ながはら てつや  11  02b8628923aa7a05a88ce3427a2fb25a0ad4e3bd  nagahara@okumurashoji.co.jp    2019-04-08 12:47:06  2017-12-26 13:58:24    2017-12-26 13:58:24    2018-01-03 15:40:25  MG00000002  View Edit Delete
TR05000001  05000001  T奥村商事テスト  おくむらしょうじてすと  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61      2018-02-13 18:38:50  2017-11-10 00:00:00    2017-11-01 11:34:46  MG00000001  2018-02-21 09:40:58  MG00000002  View Edit Delete
TR04000002  test@nosoken.jp  T農総研テスト  のうそうけんてすと  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test@nosoken.jp    2022-07-29 15:27:40  2022-06-29 00:00:00    2022-06-29 14:29:26  MG00000001  2022-06-29 14:29:26  MG00000001  View Edit Delete
TR04000001  nishimura@nousouken.jp  T西村直紘  にしむらなおひろ  11  faa8462b83a8b8084554c879070361d8ceafd225  nishimura@nousouken.jp    2024-01-24 15:18:47  2022-06-29 00:00:00    2022-06-29 14:19:30  MG00000001  2022-06-30 10:13:42  MG00000001  View Edit Delete
TR03000108  a-otani@hida-surugaya.com  T駿河屋魚一 大谷厚詞  するがやうおいち おおたにあつし  11  7cd79ca4441e569236746cfd8c9d2e01ac84600d  a-otani@hida-surugaya.com    2024-01-08 11:16:38  2018-04-02 10:22:07    2018-04-02 10:22:07    2018-04-02 15:32:24  MG00000002  View Edit Delete
TR03000102  test@hida-surugaya.com  T駿河屋テスト  するがやてすと  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test@hida-surugaya.com    2018-04-10 18:18:13  2018-02-21 09:40:21    2018-02-21 09:40:21    2018-04-01 16:29:38  MG00000002  View Edit Delete
TR03000099  otani@hida-surugaya.com  T駿河屋テスト  するがやてすと  11  8dd3a6d1676899d6666e63e609b9182831728a3c  otani@hida-surugaya.com    2018-04-02 10:18:25  2017-12-26 18:04:36    2017-12-26 18:04:36    2018-04-02 10:20:34  MG00000002  View Edit Delete
TR02000104  test_maze.vegetable@gmail.com  T南風ベジタブルテスト  まぜべじたぶるてすと  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test_maze.vegetable@gmail.com    2021-02-02 14:48:49  2018-02-21 09:43:18    2018-02-21 09:43:18    2018-02-21 09:46:10  MG00000002  View Edit Delete

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

< previous123456789
(default) 2 queries took 318 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`.`id` desc LIMIT 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 = 11174