Skip to content

Instantly share code, notes, and snippets.

@abcang

abcang/gist:97ef7512c97cebf4f774c05354ced447

Last active November 15, 2017 13:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save abcang/97ef7512c97cebf4f774c05354ced447 to your computer and use it in GitHub Desktop.
Save abcang/97ef7512c97cebf4f774c05354ced447 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
REQUEST GET /web/accounts/689 20
SQL (0001.12ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [1, 1]
SQL (0000.30ms) SELECT "session_activations".* FROM "session_activations" WHERE "session_activations"."session_id" = $1 LIMIT $2 ["せっしょんあいでぃー", 1]
SQL (0000.42ms) SELECT "web_push_subscriptions".* FROM "web_push_subscriptions" WHERE "web_push_subscriptions"."id" = $1 LIMIT $2 [3, 1]
SQL (0000.48ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."id" = $1 LIMIT $2 [21, 1]
SQL (0000.57ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."uri" = $1 LIMIT $2 ["https://edge.mstdn.jp/users/nullkal", 1]
SQL (0000.22ms) SELECT "session_activations".* FROM "session_activations" WHERE "session_activations"."session_id" = $1 LIMIT $2 ["せっしょんあいでぃー", 1]
SQL (0000.25ms) SELECT "web_push_subscriptions".* FROM "web_push_subscriptions" WHERE "web_push_subscriptions"."id" = $1 LIMIT $2 [3, 1]
SQL (0000.24ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."id" = $1 LIMIT $2 [21, 1]
SQL (0000.20ms) SELECT "session_activations".* FROM "session_activations" WHERE "session_activations"."session_id" = $1 LIMIT $2 ["せっしょんあいでぃー", 1]
SQL (0000.19ms) SELECT "web_push_subscriptions".* FROM "web_push_subscriptions" WHERE "web_push_subscriptions"."id" = $1 LIMIT $2 [3, 1]
SQL (0000.26ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."id" = $1 LIMIT $2 [21, 1]
SQL (0000.29ms) SELECT "session_activations".* FROM "session_activations" WHERE "session_activations"."session_id" = $1 LIMIT $2 ["せっしょんあいでぃー", 1]
SQL (0000.26ms) SELECT "web_push_subscriptions".* FROM "web_push_subscriptions" WHERE "web_push_subscriptions"."id" = $1 LIMIT $2 [3, 1]
SQL (0000.26ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."id" = $1 LIMIT $2 [21, 1]
SQL (0000.51ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."uri" = $1 LIMIT $2 ["https://mstdn.maud.io/users/unarist", 1]
SQL (0000.66ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."uri" = $1 LIMIT $2 ["https://mstdn.maud.io/users/unarist", 1]
SQL (0000.48ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."uri" = $1 LIMIT $2 ["https://edge.mstdn.jp/users/nullkal", 1]
SQL (0000.28ms) SELECT "session_activations".* FROM "session_activations" WHERE "session_activations"."session_id" = $1 LIMIT $2 ["せっしょんあいでぃー", 1]
SQL (0000.21ms) SELECT "web_push_subscriptions".* FROM "web_push_subscriptions" WHERE "web_push_subscriptions"."id" = $1 LIMIT $2 [3, 1]
SQL (0000.21ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."id" = $1 LIMIT $2 [21, 1]
REQUEST GET /api/v1/accounts/689 1
SQL (0004.22ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [689, 1]
REQUEST GET /api/v1/accounts/relationships 0
REQUEST GET /api/v1/timelines/home 8
SQL (0001.44ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [1, 1]
SQL (0000.37ms) SELECT "session_activations".* FROM "session_activations" WHERE "session_activations"."session_id" = $1 LIMIT $2 ["せっしょんあいでぃー", 1]
SQL (0000.33ms) SELECT "web_push_subscriptions".* FROM "web_push_subscriptions" WHERE "web_push_subscriptions"."id" = $1 LIMIT $2 [3, 1]
SQL (0000.46ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."id" = $1 LIMIT $2 [21, 1]
SQL (0000.56ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."uri" = $1 LIMIT $2 ["https://edge.mstdn.jp/users/nullkal", 1]
SQL (0000.25ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT $2 ["おーおーすとーくん", 1]
SQL (0000.70ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [1, 1]
SQL (0001.16ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [1, 1]
REQUEST GET /api/v1/accounts/689/statuses 0
REQUEST GET /api/v1/notifications 25
SQL (0000.47ms) SELECT "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT $2 ["おーおーすとーくん", 1]
SQL (0000.69ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [1, 1]
SQL (0001.11ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [1, 1]
SQL (0000.20ms) SELECT "mentions".* FROM "mentions" WHERE "mentions"."id" = $1 LIMIT $2 [2912, 1]
SQL (0000.16ms) SELECT "favourites".* FROM "favourites" WHERE "favourites"."id" = $1 LIMIT $2 [386, 1]
SQL (0011.45ms) SELECT "favourites".* FROM "favourites" WHERE "favourites"."id" = $1 LIMIT $2 [372, 1]
SQL (0001.09ms) SELECT "mentions".* FROM "mentions" WHERE "mentions"."id" = $1 LIMIT $2 [2710, 1]
SQL (0000.39ms) SELECT "favourites".* FROM "favourites" WHERE "favourites"."id" = $1 LIMIT $2 [338, 1]
SQL (0000.50ms) SELECT "favourites".* FROM "favourites" WHERE "favourites"."id" = $1 LIMIT $2 [335, 1]
SQL (0000.19ms) SELECT "favourites".* FROM "favourites" WHERE "favourites"."id" = $1 LIMIT $2 [334, 1]
SQL (0000.15ms) SELECT "favourites".* FROM "favourites" WHERE "favourites"."id" = $1 LIMIT $2 [333, 1]
SQL (0000.16ms) SELECT "mentions".* FROM "mentions" WHERE "mentions"."id" = $1 LIMIT $2 [2560, 1]
SQL (0000.10ms) SELECT "favourites".* FROM "favourites" WHERE "favourites"."id" = $1 LIMIT $2 [328, 1]
SQL (0000.11ms) SELECT "favourites".* FROM "favourites" WHERE "favourites"."id" = $1 LIMIT $2 [327, 1]
SQL (0000.46ms) SELECT "tags".* FROM "tags" INNER JOIN "statuses_tags" ON "tags"."id" = "statuses_tags"."tag_id" WHERE "statuses_tags"."status_id" = $1 [98973907954013621]
SQL (0000.36ms) SELECT "tags".* FROM "tags" INNER JOIN "statuses_tags" ON "tags"."id" = "statuses_tags"."tag_id" WHERE "statuses_tags"."status_id" = $1 [98973516019597012]
SQL (0000.37ms) SELECT "tags".* FROM "tags" INNER JOIN "statuses_tags" ON "tags"."id" = "statuses_tags"."tag_id" WHERE "statuses_tags"."status_id" = $1 [98965996449227161]
SQL (0000.40ms) SELECT "tags".* FROM "tags" INNER JOIN "statuses_tags" ON "tags"."id" = "statuses_tags"."tag_id" WHERE "statuses_tags"."status_id" = $1 [98964026275122265]
SQL (0000.31ms) SELECT "tags".* FROM "tags" INNER JOIN "statuses_tags" ON "tags"."id" = "statuses_tags"."tag_id" WHERE "statuses_tags"."status_id" = $1 [98933284726245749]
SQL (0000.33ms) SELECT "tags".* FROM "tags" INNER JOIN "statuses_tags" ON "tags"."id" = "statuses_tags"."tag_id" WHERE "statuses_tags"."status_id" = $1 [98932146986572268]
SQL (0000.22ms) SELECT "tags".* FROM "tags" INNER JOIN "statuses_tags" ON "tags"."id" = "statuses_tags"."tag_id" WHERE "statuses_tags"."status_id" = $1 [98923341580512061]
SQL (0000.11ms) SELECT "tags".* FROM "tags" INNER JOIN "statuses_tags" ON "tags"."id" = "statuses_tags"."tag_id" WHERE "statuses_tags"."status_id" = $1 [98923316041655028]
SQL (0000.18ms) SELECT "tags".* FROM "tags" INNER JOIN "statuses_tags" ON "tags"."id" = "statuses_tags"."tag_id" WHERE "statuses_tags"."status_id" = $1 [98923303564209017]
SQL (0000.12ms) SELECT "tags".* FROM "tags" INNER JOIN "statuses_tags" ON "tags"."id" = "statuses_tags"."tag_id" WHERE "statuses_tags"."status_id" = $1 [98918108543654610]
SQL (0000.12ms) SELECT "tags".* FROM "tags" INNER JOIN "statuses_tags" ON "tags"."id" = "statuses_tags"."tag_id" WHERE "statuses_tags"."status_id" = $1 [98916679671742030]
REQUEST POST /inbox 1
SQL (0000.41ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."uri" = $1 LIMIT $2 ["https://don.crakac.com/users/crakaC", 1]
REQUEST POST /inbox 1
SQL (0000.48ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."uri" = $1 LIMIT $2 ["https://edge.mstdn.jp/users/nullkal", 1]
REQUEST POST /inbox 0
REQUEST POST /api/subscriptions/111 1
SQL (0000.93ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2 [111, 1]
REQUEST POST /inbox 1
SQL (0000.54ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."uri" = $1 LIMIT $2 ["https://mstdn.maud.io/users/unarist", 1]
REQUEST POST /inbox 0
REQUEST POST /inbox 0
REQUEST POST /inbox 1
SQL (0000.76ms) SELECT "accounts".* FROM "accounts" WHERE "accounts"."uri" = $1 LIMIT $2 ["https://don.crakac.com/users/crakaC", 1]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment