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"."short_url" = ? Time: 0.003177308 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.000736958 ms
Query: select * from "item" where title != '' order by "id" asc limit 100 Time: 0.00103025 ms
