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
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
AG01005703  01005703  T井坂常典  いさかじょうてん  01  fc6f9792e236e87475b061b820ab409d54768952      2024-01-23 13:04:30  2023-09-13 00:00:00    2023-09-13 09:50:26  MG00000001  2023-09-13 09:50:26  MG00000001  View Edit Delete
AG01005704  01005704  T紀之定清壱  のりゆきじょうきよしいつ  01  fc6f9792e236e87475b061b820ab409d54768952      2024-01-22 15:11:25  2023-09-13 00:00:00    2023-09-13 00:00:00  MG00000001  2023-09-13 00:00:00  MG00000001  View Edit Delete
AG01005705  01005705  T大村拓矢  おおむらたくや  01  fc6f9792e236e87475b061b820ab409d54768952      2024-01-20 16:35:05  2023-09-13 00:00:00    2023-09-13 00:00:00  MG00000001  2023-09-13 00:00:00  MG00000001  View Edit Delete
AG01005819  01005819  T西川光一  にしかわこういち  01  fc6f9792e236e87475b061b820ab409d54768952      2024-01-22 08:17:04  2023-09-28 00:00:00    2023-09-28 00:00:00  MG00000001  2023-09-28 00:00:00  MG00000001  View Edit Delete
TR01000055  01000055  T市場町①  いちば  12  fb7ce140af599cda0ee4893fc0f467b285734078  01000055      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:55:26  MG00000001  View Edit Delete
AG01003647  01003647  T天羽幸子  あもうさちこ  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2023-07-11 09:25:13  2019-01-15 00:00:00    2019-01-15 11:06:18  MG00000001  2019-01-15 11:06:18  MG00000001  View Edit Delete
AG01003648  01003648  T松田純子  まつだじゅんこ  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2022-11-28 10:58:05  2019-01-15 00:00:00    2019-01-15 11:07:54  MG00000001  2022-08-08 14:21:25  MG00000001  View Edit Delete
AG01003649  01003649  T高橋浩司  たかはしこうじ  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2023-10-17 08:09:19  2019-01-15 00:00:00    2019-01-15 11:08:47  MG00000001  2019-01-15 11:08:47  MG00000001  View Edit Delete
AG01003964  01003964  T陶木真紀  すえきまき  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2024-01-23 08:59:01  2019-12-20 00:00:00    2019-12-20 11:07:05  MG00000001  2019-12-20 11:07:05  MG00000001  View Edit Delete
AG01003965  01003965  T(有)つちはし  ゆうげんがいしゃつちはし  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0        2019-12-20 00:00:00    2019-12-20 11:11:37  MG00000001  2019-12-20 11:11:37  MG00000001  View Edit Delete
AG01003969  01003969  T豊崎篤志  とよさきあつし  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2023-12-01 10:12:45  2019-12-23 00:00:00    2019-12-23 09:01:42  MG00000001  2019-12-23 09:01:42  MG00000001  View Edit Delete
AG01003970  01003970  T森野良一  もりのりょういち  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2023-03-29 08:59:03  2019-12-23 00:00:00    2019-12-23 09:08:02  MG00000001  2019-12-23 09:08:02  MG00000001  View Edit Delete
AG01003971  01003971  T橋谷鶴吉  はしたにつるきち  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2024-01-21 15:40:51  2019-12-23 00:00:00    2019-12-23 09:12:18  MG00000001  2019-12-23 09:12:18  MG00000001  View Edit Delete
AG01004005  01004005  T尾崎将弥  おざきしょうや  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2023-08-17 09:52:29  2020-01-31 00:00:00    2020-01-31 09:41:01  MG00000001  2020-01-31 09:41:01  MG00000001  View Edit Delete
AG01004006  01004006  T高橋宏治  たかはしひろはる  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2024-01-07 12:06:34  2020-01-31 00:00:00    2020-01-31 09:47:10  MG00000001  2020-01-31 09:47:10  MG00000001  View Edit Delete
AG01004018  01004018  T池田シゲミ  いけだしげみ  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2024-01-22 16:01:36  2020-02-19 00:00:00    2020-02-19 11:28:55  MG00000001  2020-02-19 11:28:55  MG00000001  View Edit Delete
AG01004032  01004032  T山田耕平  やまだこうへい  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2023-12-11 13:57:09  2020-03-31 00:00:00    2020-03-31 16:01:25  MG00000001  2020-03-31 16:01:25  MG00000001  View Edit Delete
AG01004075  01004075  T橋本祐樹  はしもとゆうき  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0      2022-11-28 11:05:01  2020-06-11 00:00:00    2020-06-11 13:28:21  MG00000005  2020-06-11 13:28:21  MG00000005  View Edit Delete
AG01004159  01004159  Ttomozo-farm  ともぞーふぁーむ  01  faf9d5b953a84c1c730c57cf8c439f8bc84458e0        2020-11-02 00:00:00    2020-11-02 09:26:31  MG00000005  2020-11-02 09:26:31  MG00000005  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 315 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`.`password` desc LIMIT 202020243
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 = 11172