Mastodonがタグのタイムラインを構築している

gistfile1.txt

13:43:42 web.1     | Started GET "/api/v1/timelines/tag/thisisthetag" for 127.0.0.1 at 2019-01-06 13:43:42 -1000
13:43:42 web.1     | Processing by Api::V1::Timelines::TagController#show as HTML
13:43:42 web.1     |   Parameters: {"id"=>"thisisthetag"}
13:43:42 web.1     |   Doorkeeper::AccessToken Load (0.4ms)  SELECT  "oauth_access_tokens".* FROM "oauth_access_tokens" WHERE "oauth_access_tokens"."token" = $1 LIMIT $2  [["token", "79d80f8feb192b6932f261239ee1554e1e353e01fda59d3138c990800d10098f"], ["LIMIT", 1]]
13:43:42 web.1     |   User Load (1.4ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
13:43:42 web.1     |   SessionActivation Load (0.4ms)  SELECT  "session_activations".* FROM "session_activations" WHERE "session_activations"."session_id" = $1 LIMIT $2  [["session_id", "4a0b3d5240015ee1e8a2f5710746cbe2"], ["LIMIT", 1]]
13:43:42 web.1     |   Tag Load (0.5ms)  SELECT  "tags".* FROM "tags" WHERE "tags"."name" = $1 LIMIT $2  [["name", "thisisthetag"], ["LIMIT", 1]]
13:43:42 web.1     |   Account Load (0.4ms)  SELECT  "accounts".* FROM "accounts" WHERE "accounts"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
13:43:42 web.1     |    (0.4ms)  SELECT "tags"."id" FROM "tags" WHERE "tags"."name" = $1  [["name", "thisisthetag"]]
13:43:42 web.1     |    (1.2ms)  SELECT "target_account_id" FROM "accounts" INNER JOIN "blocks" ON "accounts"."id" = "blocks"."target_account_id" WHERE "blocks"."account_id" = $1 ORDER BY blocks.id desc  [["account_id", 1]]
13:43:42 web.1     |    (1.0ms)  SELECT "account_id" FROM "accounts" INNER JOIN "blocks" ON "accounts"."id" = "blocks"."account_id" WHERE "blocks"."target_account_id" = $1 ORDER BY blocks.id desc  [["target_account_id", 1]]
13:43:42 web.1     |    (2.6ms)  SELECT "target_account_id" FROM "accounts" INNER JOIN "mutes" ON "accounts"."id" = "mutes"."target_account_id" WHERE "mutes"."account_id" = $1 ORDER BY mutes.id desc  [["account_id", 1]]
13:43:42 web.1     |    (0.5ms)  SELECT "account_domain_blocks"."domain" FROM "account_domain_blocks" WHERE "account_domain_blocks"."account_id" = $1  [["account_id", 1]]
13:43:42 web.1     |   Status Load (5.3ms)  SELECT  DISTINCT "statuses"."id", "statuses"."updated_at" FROM "statuses" INNER JOIN "statuses_tags" ON "statuses_tags"."status_id" = "statuses"."id" LEFT OUTER JOIN "accounts" ON "accounts"."id" = "statuses"."account_id" WHERE "statuses"."visibility" = $1 AND (statuses.reblog_of_id IS NULL) AND "statuses_tags"."tag_id" = $2 AND 1=1 AND "accounts"."silenced" = $3 ORDER BY "statuses"."id" DESC LIMIT $4  [["visibility", 0], ["tag_id", 3], ["silenced", false], ["LIMIT", 20]]
13:43:42 web.1     |   Status Load (0.9ms)  SELECT "statuses".* FROM "statuses" WHERE "statuses"."id" = $1 ORDER BY "statuses"."id" DESC  [["id", 101372278511825807]]
13:43:42 web.1     |   Doorkeeper::Application Load (0.5ms)  SELECT "oauth_applications".* FROM "oauth_applications" WHERE "oauth_applications"."id" = $1  [["id", 1]]
13:43:42 web.1     |   MediaAttachment Load (0.6ms)  SELECT "media_attachments".* FROM "media_attachments" WHERE "media_attachments"."status_id" = $1 ORDER BY "media_attachments"."id" ASC  [["status_id", 101372278511825807]]
13:43:42 web.1     |   Conversation Load (0.7ms)  SELECT "conversations".* FROM "conversations" WHERE "conversations"."id" = $1  [["id", 48]]
13:43:42 web.1     |   StatusStat Load (0.6ms)  SELECT "status_stats".* FROM "status_stats" WHERE "status_stats"."status_id" = $1  [["status_id", 101372278511825807]]
13:43:42 web.1     |   HABTM_Tags Load (0.6ms)  SELECT "statuses_tags".* FROM "statuses_tags" WHERE "statuses_tags"."status_id" = $1  [["status_id", 101372278511825807]]
13:43:42 web.1     |   Tag Load (0.9ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = $1  [["id", 3]]
13:43:42 web.1     |   HABTM_PreviewCards Load (0.6ms)  SELECT "preview_cards_statuses".* FROM "preview_cards_statuses" WHERE "preview_cards_statuses"."status_id" = $1  [["status_id", 101372278511825807]]
13:43:42 web.1     |   StreamEntry Load (0.6ms)  SELECT "stream_entries".* FROM "stream_entries" WHERE "stream_entries"."activity_type" = $1 AND "stream_entries"."activity_type" = $2 AND "stream_entries"."activity_id" = $3  [["activity_type", "Status"], ["activity_type", "Status"], ["activity_id", 101372278511825807]]
13:43:42 web.1     |   Account Load (0.6ms)  SELECT "accounts".* FROM "accounts" WHERE "accounts"."id" = $1  [["id", 1]]
13:43:42 web.1     |   AccountStat Load (1.7ms)  SELECT "account_stats".* FROM "account_stats" WHERE "account_stats"."account_id" = $1  [["account_id", 1]]
13:43:42 web.1     |   Mention Load (0.6ms)  SELECT "mentions".* FROM "mentions" WHERE "mentions"."silent" = $1 AND "mentions"."status_id" = $2  [["silent", false], ["status_id", 101372278511825807]]
13:43:42 web.1     |   Status Load (0.5ms)  SELECT "statuses"."reblog_of_id" FROM "statuses" WHERE "statuses"."reblog_of_id" = $1 AND "statuses"."account_id" = $2  [["reblog_of_id", 101372278511825807], ["account_id", 1]]
13:43:42 web.1     |   Favourite Load (0.6ms)  SELECT "favourites"."status_id" FROM "favourites" WHERE "favourites"."status_id" = $1 AND "favourites"."account_id" = $2  [["status_id", 101372278511825807], ["account_id", 1]]
13:43:42 web.1     |   ConversationMute Load (0.4ms)  SELECT "conversation_mutes"."conversation_id" FROM "conversation_mutes" WHERE "conversation_mutes"."conversation_id" = $1 AND "conversation_mutes"."account_id" = $2  [["conversation_id", 48], ["account_id", 1]]
13:43:42 web.1     |   StatusPin Load (4.3ms)  SELECT "status_pins"."status_id" FROM "status_pins" WHERE "status_pins"."status_id" = $1 AND "status_pins"."account_id" = $2  [["status_id", 101372278511825807], ["account_id", 1]]
13:43:42 web.1     | Completed 200 OK in 111ms (Views: 20.0ms | ActiveRecord: 28.7ms)