Query: select "item"."id", "item"."handle", "item"."module", "item"."body_html", "item"."title", "item"."short_url", "item"."dispatch", "item"."seo_title", "item"."seo_h1", "item"."seo_description", "item"."seo_body_html", "item"."indexable", COALESCE(i18n.title, item.title) as title, COALESCE(i18n.handle, item.handle) as handle, COALESCE(i18n.body_html, item.body_html) as body_html from "item" as "item" inner join "item_i18n" as "i18n" on "item"."id" = "i18n"."item_id" and "i18n"."lang_id" = ? where "i18n"."handle" = ? and "item"."module" = ? and "item"."short_url" = ? Time: 0.003283866 ms
Query: (select "item"."module", NULL AS lang_id, "item"."handle", "item"."short_url" from "item" as "item" where "item"."id" = ? limit 1) union all (select "item"."module", "i18n"."lang_id", "i18n"."handle", "item"."short_url" from "item" as "item" inner join "item_i18n" as "i18n" on "item"."id" = "i18n"."item_id" where "item"."id" = ? limit 2) Time: 0.00081264 ms
Query: SELECT * FROM collection WHERE item_id = :collection_id Time: 0.000394794 ms
Query: select "item"."module", "item"."handle", "item"."title", "item"."short_url" from "collection_collections" as "connect" inner join "item" as "item" on "connect"."connect_id" = "item"."id" where "connect"."collection_id" = ? order by "connect"."position" asc Time: 0.000821404 ms
Query: select "item".*, "filter"."position", "product".*, "variant"."price" from (select "item"."id" as "id", "connect"."position" from "item" as "item" inner join "collection_product" as "connect" on "item"."id" = "connect"."product_id" inner join "product" as "product" on "item"."id" = "product"."item_id" where "connect"."collection_id" = ? and exists (select 1 from "product_variant" as "variant" where variant.product_id = connect.product_id) order by "connect"."position" desc limit 50) as "filter" inner join "item" as "item" on "item"."id" = "filter"."id" inner join "product" as "product" on "product"."item_id" = "filter"."id" inner join lateral (select * from "product_variant" where "item"."id" = "product_id" limit 1) as "variant" on true Time: 0.004590746 ms
