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
AG01006033  01006033  佐藤テスト    01  0e8852433a57eb7742c6162444d97c02202e90b8      2024-03-14 11:39:00  2024-03-13 00:00:00    2024-03-13 11:04:37  TR01000110  2024-03-13 11:04:37  TR01000110  View Edit Delete
AG01006032  01006032  中間業者テスト    01  72a60a75775c1dd5dbef162bf95c107fc7711668      2024-03-15 14:34:26  2024-03-12 00:00:00    2024-03-12 11:41:45  TR01000110  2024-03-12 11:41:45  TR01000110  View Edit Delete
TR01000110  test3@test.com  中間業者テスト    11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test3@test.com    2024-03-15 14:26:49  2024-03-11 00:00:00    2024-03-11 13:55:09  MG00000001  2024-03-11 14:03:11  MG00000001  View Edit Delete
TR01000112  test4@test.com  中間業者テスト    11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test4@test.com      2024-03-12 00:00:00    2024-03-12 08:54:41  MG00000001  2024-03-12 08:54:41  MG00000001  View Edit Delete
TR01000113  test5@test.com  中間業者テスト    11  c2debdbc6537ad963c4aa33c00418a32194f4325  test5@test.com      2024-03-12 00:00:00    2024-03-12 08:55:24  MG00000001  2024-03-12 08:55:24  MG00000001  View Edit Delete
TR01000111  chukan1@example.com  中間 太郎  ちゅうかん たろう  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  chukan1@example.com      2024-03-11 00:00:00    2024-03-11 16:28:15  MG00000001  2024-03-11 16:28:15  MG00000001  View Edit Delete
TR01000109  test@test.com  やさい    11  c8ae6862b7efa8edf8404740c8bfef8d89dc8b3d  test@test.com      2024-02-27 00:00:00    2024-02-27 14:15:46  MG00000001  2024-02-27 14:15:46  MG00000001  View Edit Delete
AG01006030  01006030  てすとテスト    01  11d6dbda1a938bc96f4b8e125a039642173518a8        2024-02-27 00:00:00    2024-02-27 14:10:21  MG00000001  2024-02-27 14:10:21  MG00000001  View Edit Delete
AG01006031  01006031  てすと    01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c        2024-03-11 00:00:00    2024-03-11 14:34:18  TR01000110  2024-03-11 14:34:18  TR01000110  View Edit Delete
MG00000008  test2@test.com  くだもの    99  020d4b86eaf8e6ef9a2363fa468ca5b66dcd2918  test2@test.com      2024-02-27 00:00:00    2024-02-27 14:17:29  MG00000001  2024-02-27 14:17:29  MG00000001  View Edit Delete
AG01005044  01005044  Tファーム雲仙 青木茂  ふぁーむうんぜん  01  e7c6d41dc78c3b72c30f3a02ab6ec4c28a3bdca2      2023-12-12 13:39:09  2022-08-22 00:00:00    2022-08-22 12:05:04  MG00000001  2022-08-22 12:05:04  MG00000001  View Edit Delete
AG01004489  01004489  TエコファームMITANI  えこふぁーむみたに  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-12-19 16:00:09  2021-04-09 00:00:00    2021-04-09 16:12:31  MG00000005  2021-04-09 16:12:31  MG00000005  View Edit Delete
AG03000035  03000035  TToriDori Farm  とりどりふぁーむ  01  8dd3a6d1676899d6666e63e609b9182831728a3c      2024-01-22 10:27:15  2023-03-07 00:00:00    2023-03-07 13:26:13  MG00000001  2023-03-07 13:26:13  MG00000001  View Edit Delete
AG01004174  01004174  TOS豊後大野ファーム  おーえすぶんごおおのふぁーむ  01  f8e5c2269d1847370732491ad74318887ad014d0        2021-01-15 00:00:00    2021-01-15 10:31:46  MG00000005  2021-01-15 10:31:46  MG00000005  View Edit Delete
AG06001019  06001019  TMSBC合同会社 藤田博文  えむえすびーしー  01  650de8d26109de6e5413b38f87e3eb395798c415        2022-03-04 00:00:00    2022-03-04 15:42:45  MG00000001  2022-03-04 15:43:53  MG00000001  View Edit Delete
AG06001124  06001124  TM2企画  えむにきかく  01  650de8d26109de6e5413b38f87e3eb395798c415        2022-03-04 00:00:00    2022-03-04 15:42:45  MG00000001  2022-03-04 15:43:53  MG00000001  View Edit Delete
AG01002712  01002712  TK.ファーム  けーふぁーむ  01  87b61df05017322dc411d6eca20a205f57ed487e      2017-09-25 11:35:07  2016-08-29 00:00:00    2017-04-18 13:36:00  MG00000001  2017-09-25 11:34:31  MG00000001  View Edit Delete
AG04000145  04000145  THISファーマーズさんの野菜  えいちあいえすふぁーまーずさんのやさい  01  f7642b4366e3c1c48ab1630ae29a6f14a4f56678      2022-12-24 14:40:54  2022-09-06 00:00:00    2022-09-06 09:14:44  MG00000001  2022-09-06 09:14:44  MG00000001  View Edit Delete
AG04000102  04000102  T@FARM  あっとふぁーむ  01  f7642b4366e3c1c48ab1630ae29a6f14a4f56678      2023-07-31 13:59:53  2022-06-23 00:00:00    2022-06-23 11:08:20  MG00000001  2022-06-23 11:08:20  MG00000001  View Edit Delete
AG05000102  05000102  T@FARM  あっとふぁーむ  02  e41ecf46f6da93056732fbd1c5f5dd42c57bf83e      2018-11-05 18:21:27  2018-04-13 00:00:00    2018-04-13 11:34:46  MG00000001  2022-03-14 10:39:59  MG00000001  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 329 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`.`user_nm` desc LIMIT 202020257
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