Skip to content

Instantly share code, notes, and snippets.

@gutenye

gutenye/gist:9733735

Created March 24, 2014 03:39
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 gutenye/9733735 to your computer and use it in GitHub Desktop.
Save gutenye/9733735 to your computer and use it in GitHub Desktop.
Download ZIP
database query
Raw
gistfile1.txt
Started GET "/api/v1/channels?featured=true&auth_token=BzbsZNWneZPToi95GryR&channel_id=-1" for 127.0.0.1 at 2014-03-24 11:38:28 +0800
Processing by Api::V1::ChannelsController#index as JSON
Parameters: {"featured"=>"true", "auth_token"=>"BzbsZNWneZPToi95GryR", "channel_id"=>"-1"}
User Load (1.3ms) SELECT "users".* FROM "users" WHERE "users"."authentication_token" = 'BzbsZNWneZPToi95GryR' LIMIT 1
(0.3ms) BEGIN
SQL (0.9ms) UPDATE "users" SET "last_sign_in_at" = $1, "current_sign_in_at" = $2, "sign_in_count" = $3, "updated_at" = $4 WHERE "users"."id" = 2 [["last_sign_in_at", Mon, 24 Mar 2014 03:38:28 UTC +00:00], ["current_sign_in_at", Mon, 24 Mar 2014 03:38:28 UTC +00:00], ["sign_in_count", 865], ["updated_at", Mon, 24 Mar 2014 03:38:28 UTC +00:00]]
(3.2ms) COMMIT
Channel Load (1.2ms) SELECT "channels".* FROM "channels" WHERE "channels"."featured" = 't' AND (author_id = 2 OR (accessible_to_all = 't' AND approved = 't'))
Page Load (0.7ms) SELECT "pages".* FROM "pages" WHERE "pages"."channel_id" = $1 ORDER BY "pages"."id" ASC LIMIT 1 [["channel_id", 1]]
Channel Load (0.8ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 1]]
PageEntry Load (0.6ms) SELECT "page_entries".* FROM "page_entries" WHERE "page_entries"."page_id" = $1 [["page_id", 1]]
Page Load (0.6ms) SELECT "pages".* FROM "pages" WHERE "pages"."id" = $1 ORDER BY "pages"."id" ASC LIMIT 1 [["id", 1]]
PageLayout Load (0.5ms) SELECT "page_layouts".* FROM "page_layouts" WHERE "page_layouts"."page_entry_id" = $1 ORDER BY "page_layouts"."id" ASC LIMIT 1 [["page_entry_id", 1]]
PageEntry Load (0.6ms) SELECT "page_entries".* FROM "page_entries" WHERE "page_entries"."id" = $1 ORDER BY "page_entries"."id" ASC LIMIT 1 [["id", 1]]
PageRow Load (0.7ms) SELECT "page_rows".* FROM "page_rows" WHERE "page_rows"."page_layout_id" = $1 [["page_layout_id", 1]]
PageLayout Load (0.5ms) SELECT "page_layouts".* FROM "page_layouts" WHERE "page_layouts"."id" = $1 ORDER BY "page_layouts"."id" ASC LIMIT 1 [["id", 1]]
PageColumn Load (1.0ms) SELECT "page_columns".* FROM "page_columns" WHERE "page_columns"."page_row_id" = $1 [["page_row_id", 1]]
PageSection Load (0.7ms) SELECT "page_sections".* FROM "page_sections" WHERE "page_sections"."page_column_id" = $1 ORDER BY "page_sections"."id" ASC LIMIT 1 [["page_column_id", 1]]
CACHE (0.1ms) SELECT "page_entries".* FROM "page_entries" WHERE "page_entries"."id" = $1 ORDER BY "page_entries"."id" ASC LIMIT 1 [["id", 1]]
PageColumn Load (0.6ms) SELECT "page_columns".* FROM "page_columns" WHERE "page_columns"."id" = $1 ORDER BY "page_columns"."id" ASC LIMIT 1 [["id", 1]]
PageRow Load (0.5ms) SELECT "page_rows".* FROM "page_rows" WHERE "page_rows"."page_column_id" = $1 [["page_column_id", 1]]
PageRow Load (0.5ms) SELECT "page_rows".* FROM "page_rows" WHERE "page_rows"."id" = $1 ORDER BY "page_rows"."id" ASC LIMIT 1 [["id", 1]]
CACHE (0.0ms) SELECT "page_layouts".* FROM "page_layouts" WHERE "page_layouts"."id" = $1 ORDER BY "page_layouts"."id" ASC LIMIT 1 [["id", 1]]
PageColumn Load (0.5ms) SELECT "page_columns".* FROM "page_columns" WHERE "page_columns"."page_row_id" = $1 [["page_row_id", 3]]
PageSection Load (0.6ms) SELECT "page_sections".* FROM "page_sections" WHERE "page_sections"."page_column_id" = $1 ORDER BY "page_sections"."id" ASC LIMIT 1 [["page_column_id", 3]]
CACHE (0.0ms) SELECT "page_entries".* FROM "page_entries" WHERE "page_entries"."id" = $1 ORDER BY "page_entries"."id" ASC LIMIT 1 [["id", 1]]
PageColumn Load (0.6ms) SELECT "page_columns".* FROM "page_columns" WHERE "page_columns"."id" = $1 ORDER BY "page_columns"."id" ASC LIMIT 1 [["id", 3]]
PageRow Load (0.6ms) SELECT "page_rows".* FROM "page_rows" WHERE "page_rows"."page_column_id" = $1 [["page_column_id", 3]]
PageRow Load (0.6ms) SELECT "page_rows".* FROM "page_rows" WHERE "page_rows"."id" = $1 ORDER BY "page_rows"."id" ASC LIMIT 1 [["id", 3]]
CACHE (0.1ms) SELECT "page_layouts".* FROM "page_layouts" WHERE "page_layouts"."id" = $1 ORDER BY "page_layouts"."id" ASC LIMIT 1 [["id", 1]]
PageColumn Load (0.6ms) SELECT "page_columns".* FROM "page_columns" WHERE "page_columns"."page_row_id" = $1 [["page_row_id", 4]]
PageSection Load (0.5ms) SELECT "page_sections".* FROM "page_sections" WHERE "page_sections"."page_column_id" = $1 ORDER BY "page_sections"."id" ASC LIMIT 1 [["page_column_id", 4]]
PageRow Load (0.6ms) SELECT "page_rows".* FROM "page_rows" WHERE "page_rows"."page_column_id" = $1 [["page_column_id", 4]]
PageColumn Load (0.6ms) SELECT "page_columns".* FROM "page_columns" WHERE "page_columns"."id" = $1 ORDER BY "page_columns"."id" ASC LIMIT 1 [["id", 4]]
PageColumn Load (0.6ms) SELECT "page_columns".* FROM "page_columns" WHERE "page_columns"."page_row_id" = $1 [["page_row_id", 5]]
PageSection Load (0.6ms) SELECT "page_sections".* FROM "page_sections" WHERE "page_sections"."page_column_id" = $1 ORDER BY "page_sections"."id" ASC LIMIT 1 [["page_column_id", 5]]
CACHE (0.0ms) SELECT "page_entries".* FROM "page_entries" WHERE "page_entries"."id" = $1 ORDER BY "page_entries"."id" ASC LIMIT 1 [["id", 1]]
PageColumn Load (0.6ms) SELECT "page_columns".* FROM "page_columns" WHERE "page_columns"."id" = $1 ORDER BY "page_columns"."id" ASC LIMIT 1 [["id", 5]]
PageRow Load (0.6ms) SELECT "page_rows".* FROM "page_rows" WHERE "page_rows"."page_column_id" = $1 [["page_column_id", 5]]
PageRow Load (0.6ms) SELECT "page_rows".* FROM "page_rows" WHERE "page_rows"."id" = $1 ORDER BY "page_rows"."id" ASC LIMIT 1 [["id", 5]]
PageSection Load (0.7ms) SELECT "page_sections".* FROM "page_sections" WHERE "page_sections"."page_column_id" = $1 ORDER BY "page_sections"."id" ASC LIMIT 1 [["page_column_id", 6]]
CACHE (0.1ms) SELECT "page_entries".* FROM "page_entries" WHERE "page_entries"."id" = $1 ORDER BY "page_entries"."id" ASC LIMIT 1 [["id", 1]]
PageColumn Load (5.1ms) SELECT "page_columns".* FROM "page_columns" WHERE "page_columns"."id" = $1 ORDER BY "page_columns"."id" ASC LIMIT 1 [["id", 6]]
PageRow Load (0.6ms) SELECT "page_rows".* FROM "page_rows" WHERE "page_rows"."page_column_id" = $1 [["page_column_id", 6]]
CACHE (0.0ms) SELECT "page_rows".* FROM "page_rows" WHERE "page_rows"."id" = $1 ORDER BY "page_rows"."id" ASC LIMIT 1 [["id", 5]]
PageSection Load (0.7ms) SELECT "page_sections".* FROM "page_sections" WHERE "page_sections"."page_column_id" = $1 ORDER BY "page_sections"."id" ASC LIMIT 1 [["page_column_id", 7]]
CACHE (0.1ms) SELECT "page_entries".* FROM "page_entries" WHERE "page_entries"."id" = $1 ORDER BY "page_entries"."id" ASC LIMIT 1 [["id", 1]]
PageColumn Load (0.7ms) SELECT "page_columns".* FROM "page_columns" WHERE "page_columns"."id" = $1 ORDER BY "page_columns"."id" ASC LIMIT 1 [["id", 7]]
PageRow Load (0.6ms) SELECT "page_rows".* FROM "page_rows" WHERE "page_rows"."page_column_id" = $1 [["page_column_id", 7]]
CACHE (0.0ms) SELECT "page_rows".* FROM "page_rows" WHERE "page_rows"."id" = $1 ORDER BY "page_rows"."id" ASC LIMIT 1 [["id", 5]]
PageRow Load (0.6ms) SELECT "page_rows".* FROM "page_rows" WHERE "page_rows"."id" = $1 ORDER BY "page_rows"."id" ASC LIMIT 1 [["id", 4]]
PageSection Load (0.7ms) SELECT "page_sections".* FROM "page_sections" WHERE "page_sections"."page_entry_id" = $1 [["page_entry_id", 1]]
Header Load (0.7ms) SELECT "headers".* FROM "headers" WHERE "headers"."channel_id" = $1 ORDER BY "headers"."id" ASC LIMIT 1 [["channel_id", 1]]
CACHE (0.1ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 1]]
Footer Load (0.8ms) SELECT "footers".* FROM "footers" WHERE "footers"."channel_id" = $1 ORDER BY "footers"."id" ASC LIMIT 1 [["channel_id", 1]]
CACHE (0.1ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 1]]
User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 2]]
Layout Load (0.5ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."channel_id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["channel_id", 1]]
CACHE (0.0ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 1]]
LayoutRow Load (0.7ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."layout_id" = $1 [["layout_id", 1]]
Layout Load (0.5ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["id", 1]]
LayoutColumn Load (0.5ms) SELECT "layout_columns".* FROM "layout_columns" WHERE "layout_columns"."layout_row_id" = $1 [["layout_row_id", 1]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."parent_column_id" = $1 [["parent_column_id", 1]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."id" = $1 ORDER BY "layout_rows"."id" ASC LIMIT 1 [["id", 1]]
CACHE (0.0ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["id", 1]]
LayoutColumn Load (0.6ms) SELECT "layout_columns".* FROM "layout_columns" WHERE "layout_columns"."layout_row_id" = $1 [["layout_row_id", 2]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."parent_column_id" = $1 [["parent_column_id", 2]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."id" = $1 ORDER BY "layout_rows"."id" ASC LIMIT 1 [["id", 2]]
CACHE (0.0ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["id", 1]]
LayoutColumn Load (0.5ms) SELECT "layout_columns".* FROM "layout_columns" WHERE "layout_columns"."layout_row_id" = $1 [["layout_row_id", 3]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."parent_column_id" = $1 [["parent_column_id", 3]]
LayoutRow Load (0.6ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."id" = $1 ORDER BY "layout_rows"."id" ASC LIMIT 1 [["id", 3]]
Feature Load (0.7ms) SELECT "features".* FROM "features" WHERE "features"."channel_id" = $1 [["channel_id", 1]]
News Load (0.6ms) SELECT "news".* FROM "news" WHERE "news"."id" = $1 ORDER BY "news"."id" ASC LIMIT 1 [["id", 1]]
NewsEntry Load (0.7ms) SELECT "news_entries".* FROM "news_entries" WHERE "news_entries"."news_id" = $1 [["news_id", 1]]
CACHE (0.0ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 1]]
Blog Load (0.6ms) SELECT "blogs".* FROM "blogs" WHERE "blogs"."id" = $1 ORDER BY "blogs"."id" ASC LIMIT 1 [["id", 1]]
BlogEntry Load (0.8ms) SELECT "blog_entries".* FROM "blog_entries" WHERE "blog_entries"."blog_id" = $1 [["blog_id", 1]]
CACHE (0.0ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 1]]
Lineup Load (0.8ms) SELECT "lineups".* FROM "lineups" WHERE "lineups"."channel_id" = $1 AND "lineups"."user_id" = 2 [["channel_id", 1]]
EmailTemplate Load (0.7ms) SELECT "email_templates".* FROM "email_templates" WHERE "email_templates"."channel_id" = $1 [["channel_id", 1]]
Page Load (0.6ms) SELECT "pages".* FROM "pages" WHERE "pages"."channel_id" = $1 ORDER BY "pages"."id" ASC LIMIT 1 [["channel_id", 27]]
Channel Load (0.6ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 27]]
PageEntry Load (0.5ms) SELECT "page_entries".* FROM "page_entries" WHERE "page_entries"."page_id" = $1 [["page_id", 9]]
Header Load (0.6ms) SELECT "headers".* FROM "headers" WHERE "headers"."channel_id" = $1 ORDER BY "headers"."id" ASC LIMIT 1 [["channel_id", 27]]
CACHE (0.0ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 27]]
Footer Load (0.6ms) SELECT "footers".* FROM "footers" WHERE "footers"."channel_id" = $1 ORDER BY "footers"."id" ASC LIMIT 1 [["channel_id", 27]]
CACHE (0.0ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 27]]
User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 13]]
Layout Load (0.6ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."channel_id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["channel_id", 27]]
CACHE (0.0ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 27]]
LayoutRow Load (0.7ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."layout_id" = $1 [["layout_id", 9]]
Layout Load (0.6ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["id", 9]]
LayoutColumn Load (0.6ms) SELECT "layout_columns".* FROM "layout_columns" WHERE "layout_columns"."layout_row_id" = $1 [["layout_row_id", 23]]
LayoutRow Load (0.6ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."parent_column_id" = $1 [["parent_column_id", 23]]
LayoutRow Load (0.6ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."id" = $1 ORDER BY "layout_rows"."id" ASC LIMIT 1 [["id", 23]]
CACHE (0.1ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["id", 9]]
LayoutColumn Load (0.7ms) SELECT "layout_columns".* FROM "layout_columns" WHERE "layout_columns"."layout_row_id" = $1 [["layout_row_id", 24]]
LayoutRow Load (0.6ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."parent_column_id" = $1 [["parent_column_id", 24]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."id" = $1 ORDER BY "layout_rows"."id" ASC LIMIT 1 [["id", 24]]
CACHE (0.1ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["id", 9]]
LayoutColumn Load (0.8ms) SELECT "layout_columns".* FROM "layout_columns" WHERE "layout_columns"."layout_row_id" = $1 [["layout_row_id", 25]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."parent_column_id" = $1 [["parent_column_id", 25]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."id" = $1 ORDER BY "layout_rows"."id" ASC LIMIT 1 [["id", 25]]
Feature Load (0.6ms) SELECT "features".* FROM "features" WHERE "features"."channel_id" = $1 [["channel_id", 27]]
Lineup Load (0.7ms) SELECT "lineups".* FROM "lineups" WHERE "lineups"."channel_id" = $1 AND "lineups"."user_id" = 2 [["channel_id", 27]]
EmailTemplate Load (0.6ms) SELECT "email_templates".* FROM "email_templates" WHERE "email_templates"."channel_id" = $1 [["channel_id", 27]]
Page Load (0.7ms) SELECT "pages".* FROM "pages" WHERE "pages"."channel_id" = $1 ORDER BY "pages"."id" ASC LIMIT 1 [["channel_id", 29]]
Channel Load (0.6ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 29]]
PageEntry Load (0.5ms) SELECT "page_entries".* FROM "page_entries" WHERE "page_entries"."page_id" = $1 [["page_id", 11]]
Header Load (0.6ms) SELECT "headers".* FROM "headers" WHERE "headers"."channel_id" = $1 ORDER BY "headers"."id" ASC LIMIT 1 [["channel_id", 29]]
CACHE (0.0ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 29]]
Footer Load (0.6ms) SELECT "footers".* FROM "footers" WHERE "footers"."channel_id" = $1 ORDER BY "footers"."id" ASC LIMIT 1 [["channel_id", 29]]
CACHE (0.1ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 29]]
User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 1]]
Layout Load (0.6ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."channel_id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["channel_id", 29]]
CACHE (0.1ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 29]]
LayoutRow Load (0.8ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."layout_id" = $1 [["layout_id", 11]]
Layout Load (0.5ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["id", 11]]
LayoutColumn Load (0.5ms) SELECT "layout_columns".* FROM "layout_columns" WHERE "layout_columns"."layout_row_id" = $1 [["layout_row_id", 29]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."parent_column_id" = $1 [["parent_column_id", 29]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."id" = $1 ORDER BY "layout_rows"."id" ASC LIMIT 1 [["id", 29]]
CACHE (0.0ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["id", 11]]
LayoutColumn Load (0.5ms) SELECT "layout_columns".* FROM "layout_columns" WHERE "layout_columns"."layout_row_id" = $1 [["layout_row_id", 30]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."parent_column_id" = $1 [["parent_column_id", 30]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."id" = $1 ORDER BY "layout_rows"."id" ASC LIMIT 1 [["id", 30]]
CACHE (0.0ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["id", 11]]
LayoutColumn Load (0.6ms) SELECT "layout_columns".* FROM "layout_columns" WHERE "layout_columns"."layout_row_id" = $1 [["layout_row_id", 31]]
LayoutRow Load (0.6ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."parent_column_id" = $1 [["parent_column_id", 31]]
LayoutRow Load (0.6ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."id" = $1 ORDER BY "layout_rows"."id" ASC LIMIT 1 [["id", 31]]
Feature Load (0.6ms) SELECT "features".* FROM "features" WHERE "features"."channel_id" = $1 [["channel_id", 29]]
Lineup Load (0.6ms) SELECT "lineups".* FROM "lineups" WHERE "lineups"."channel_id" = $1 AND "lineups"."user_id" = 2 [["channel_id", 29]]
EmailTemplate Load (0.7ms) SELECT "email_templates".* FROM "email_templates" WHERE "email_templates"."channel_id" = $1 [["channel_id", 29]]
Page Load (0.5ms) SELECT "pages".* FROM "pages" WHERE "pages"."channel_id" = $1 ORDER BY "pages"."id" ASC LIMIT 1 [["channel_id", 30]]
Channel Load (0.8ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 30]]
PageEntry Load (0.5ms) SELECT "page_entries".* FROM "page_entries" WHERE "page_entries"."page_id" = $1 [["page_id", 12]]
Header Load (0.6ms) SELECT "headers".* FROM "headers" WHERE "headers"."channel_id" = $1 ORDER BY "headers"."id" ASC LIMIT 1 [["channel_id", 30]]
CACHE (0.1ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 30]]
Footer Load (0.8ms) SELECT "footers".* FROM "footers" WHERE "footers"."channel_id" = $1 ORDER BY "footers"."id" ASC LIMIT 1 [["channel_id", 30]]
CACHE (0.1ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 30]]
User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT 1 [["id", 12]]
Layout Load (0.5ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."channel_id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["channel_id", 30]]
CACHE (0.0ms) SELECT "channels".* FROM "channels" WHERE "channels"."id" = $1 ORDER BY "channels"."id" ASC LIMIT 1 [["id", 30]]
LayoutRow Load (0.7ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."layout_id" = $1 [["layout_id", 12]]
Layout Load (0.6ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["id", 12]]
LayoutColumn Load (0.6ms) SELECT "layout_columns".* FROM "layout_columns" WHERE "layout_columns"."layout_row_id" = $1 [["layout_row_id", 32]]
LayoutRow Load (0.6ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."parent_column_id" = $1 [["parent_column_id", 32]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."id" = $1 ORDER BY "layout_rows"."id" ASC LIMIT 1 [["id", 32]]
CACHE (0.0ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["id", 12]]
LayoutColumn Load (0.5ms) SELECT "layout_columns".* FROM "layout_columns" WHERE "layout_columns"."layout_row_id" = $1 [["layout_row_id", 33]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."parent_column_id" = $1 [["parent_column_id", 33]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."id" = $1 ORDER BY "layout_rows"."id" ASC LIMIT 1 [["id", 33]]
CACHE (0.0ms) SELECT "layouts".* FROM "layouts" WHERE "layouts"."id" = $1 ORDER BY "layouts"."id" ASC LIMIT 1 [["id", 12]]
LayoutColumn Load (0.5ms) SELECT "layout_columns".* FROM "layout_columns" WHERE "layout_columns"."layout_row_id" = $1 [["layout_row_id", 34]]
LayoutRow Load (0.6ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."parent_column_id" = $1 [["parent_column_id", 34]]
LayoutRow Load (0.5ms) SELECT "layout_rows".* FROM "layout_rows" WHERE "layout_rows"."id" = $1 ORDER BY "layout_rows"."id" ASC LIMIT 1 [["id", 34]]
Feature Load (0.5ms) SELECT "features".* FROM "features" WHERE "features"."channel_id" = $1 [["channel_id", 30]]
Lineup Load (0.7ms) SELECT "lineups".* FROM "lineups" WHERE "lineups"."channel_id" = $1 AND "lineups"."user_id" = 2 [["channel_id", 30]]
EmailTemplate Load (0.6ms) SELECT "email_templates".* FROM "email_templates" WHERE "email_templates"."channel_id" = $1 [["channel_id", 30]]
Completed 200 OK in 686ms (Views: 588.2ms | ActiveRecord: 86.1ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment