Created
March 24, 2014 03:39
-
-
Save gutenye/9733735 to your computer and use it in GitHub Desktop.
database query
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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