| 1 |
1.13 ms |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.template AS template_2, c0_.slug AS slug_3, c0_.breadcrumb AS breadcrumb_4, c0_.active AS active_5, c0_.roles AS roles_6, c0_.lft AS lft_7, c0_.lvl AS lvl_8, c0_.rgt AS rgt_9, c0_.no_index AS no_index_10, c0_.seo_title AS seo_title_11, c0_.seo_description AS seo_description_12, c0_.seo_keywords AS seo_keywords_13, c0_.seo_sitemap_priority AS seo_sitemap_priority_14, c0_.seo_sitemap_change_freq AS seo_sitemap_change_freq_15, c0_.og_title AS og_title_16, c0_.og_type AS og_type_17, c0_.og_description AS og_description_18, c0_.og_site_name AS og_site_name_19, c0_.twitter_card AS twitter_card_20, c0_.twitter_site AS twitter_site_21, c0_.twitter_title AS twitter_title_22, c0_.twitter_description AS twitter_description_23, c0_.twitter_creator AS twitter_creator_24, c0_.created_at AS created_at_25, c0_.updated_at AS updated_at_26, c1_.id AS id_27, c1_.name AS name_28, c1_.methods AS methods_29, c1_.path AS path_30, c1_.controller AS controller_31, c1_.defaults AS defaults_32, c1_.requirements AS requirements_33, c2_.id AS id_34, c2_.slug AS slug_35, c2_.label AS label_36, c2_.locale AS locale_37, c2_.host AS host_38, c2_.localhost AS localhost_39, c2_.host_multilingual AS host_multilingual_40, c2_.`default` AS default_41, c2_.flag_icon AS flag_icon_42, c2_.visible AS visible_43, c2_.template_filter AS template_filter_44, c3_.id AS id_45, c3_.title AS title_46, c3_.technic_name AS technic_name_47, c3_.locale AS locale_48, c3_.active AS active_49, c3_.params AS params_50, c3_.seo_title AS seo_title_51, c3_.seo_description AS seo_description_52, c3_.seo_keywords AS seo_keywords_53, c3_.seo_sitemap_priority AS seo_sitemap_priority_54, c3_.seo_sitemap_change_freq AS seo_sitemap_change_freq_55, c3_.og_title AS og_title_56, c3_.og_type AS og_type_57, c3_.og_description AS og_description_58, c3_.og_site_name AS og_site_name_59, c3_.twitter_card AS twitter_card_60, c3_.twitter_site AS twitter_site_61, c3_.twitter_title AS twitter_title_62, c3_.twitter_description AS twitter_description_63, c3_.twitter_creator AS twitter_creator_64, c0_.route_id AS route_id_65, c0_.site_id AS site_id_66, c0_.tree_root AS tree_root_67, c0_.parent_id AS parent_id_68, c0_.og_image_id AS og_image_id_69, c0_.twitter_image_id AS twitter_image_id_70, c1_.discr AS discr_71, c3_.page_id AS page_id_72, c3_.og_image_id AS og_image_id_73, c3_.twitter_image_id AS twitter_image_id_74 FROM cms__page c0_ LEFT JOIN cms__route c1_ ON c0_.route_id = c1_.id AND c1_.discr IN ('base') LEFT JOIN cms__site c2_ ON c0_.site_id = c2_.id LEFT JOIN cms__page_declination c3_ ON c0_.id = c3_.page_id WHERE c1_.name = ?
SELECT
c0_.id AS id_0,
c0_.title AS title_1,
c0_.template AS template_2,
c0_.slug AS slug_3,
c0_.breadcrumb AS breadcrumb_4,
c0_.active AS active_5,
c0_.roles AS roles_6,
c0_.lft AS lft_7,
c0_.lvl AS lvl_8,
c0_.rgt AS rgt_9,
c0_.no_index AS no_index_10,
c0_.seo_title AS seo_title_11,
c0_.seo_description AS seo_description_12,
c0_.seo_keywords AS seo_keywords_13,
c0_.seo_sitemap_priority AS seo_sitemap_priority_14,
c0_.seo_sitemap_change_freq AS seo_sitemap_change_freq_15,
c0_.og_title AS og_title_16,
c0_.og_type AS og_type_17,
c0_.og_description AS og_description_18,
c0_.og_site_name AS og_site_name_19,
c0_.twitter_card AS twitter_card_20,
c0_.twitter_site AS twitter_site_21,
c0_.twitter_title AS twitter_title_22,
c0_.twitter_description AS twitter_description_23,
c0_.twitter_creator AS twitter_creator_24,
c0_.created_at AS created_at_25,
c0_.updated_at AS updated_at_26,
c1_.id AS id_27,
c1_.name AS name_28,
c1_.methods AS methods_29,
c1_.path AS path_30,
c1_.controller AS controller_31,
c1_.defaults AS defaults_32,
c1_.requirements AS requirements_33,
c2_.id AS id_34,
c2_.slug AS slug_35,
c2_.label AS label_36,
c2_.locale AS locale_37,
c2_.host AS host_38,
c2_.localhost AS localhost_39,
c2_.host_multilingual AS host_multilingual_40,
c2_.`default` AS default_41,
c2_.flag_icon AS flag_icon_42,
c2_.visible AS visible_43,
c2_.template_filter AS template_filter_44,
c3_.id AS id_45,
c3_.title AS title_46,
c3_.technic_name AS technic_name_47,
c3_.locale AS locale_48,
c3_.active AS active_49,
c3_.params AS params_50,
c3_.seo_title AS seo_title_51,
c3_.seo_description AS seo_description_52,
c3_.seo_keywords AS seo_keywords_53,
c3_.seo_sitemap_priority AS seo_sitemap_priority_54,
c3_.seo_sitemap_change_freq AS seo_sitemap_change_freq_55,
c3_.og_title AS og_title_56,
c3_.og_type AS og_type_57,
c3_.og_description AS og_description_58,
c3_.og_site_name AS og_site_name_59,
c3_.twitter_card AS twitter_card_60,
c3_.twitter_site AS twitter_site_61,
c3_.twitter_title AS twitter_title_62,
c3_.twitter_description AS twitter_description_63,
c3_.twitter_creator AS twitter_creator_64,
c0_.route_id AS route_id_65,
c0_.site_id AS site_id_66,
c0_.tree_root AS tree_root_67,
c0_.parent_id AS parent_id_68,
c0_.og_image_id AS og_image_id_69,
c0_.twitter_image_id AS twitter_image_id_70,
c1_.discr AS discr_71,
c3_.page_id AS page_id_72,
c3_.og_image_id AS og_image_id_73,
c3_.twitter_image_id AS twitter_image_id_74
FROM
cms__page c0_
LEFT JOIN cms__route c1_ ON c0_.route_id = c1_.id
AND c1_.discr IN ('base')
LEFT JOIN cms__site c2_ ON c0_.site_id = c2_.id
LEFT JOIN cms__page_declination c3_ ON c0_.id = c3_.page_id
WHERE
c1_.name = ?
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.template AS template_2, c0_.slug AS slug_3, c0_.breadcrumb AS breadcrumb_4, c0_.active AS active_5, c0_.roles AS roles_6, c0_.lft AS lft_7, c0_.lvl AS lvl_8, c0_.rgt AS rgt_9, c0_.no_index AS no_index_10, c0_.seo_title AS seo_title_11, c0_.seo_description AS seo_description_12, c0_.seo_keywords AS seo_keywords_13, c0_.seo_sitemap_priority AS seo_sitemap_priority_14, c0_.seo_sitemap_change_freq AS seo_sitemap_change_freq_15, c0_.og_title AS og_title_16, c0_.og_type AS og_type_17, c0_.og_description AS og_description_18, c0_.og_site_name AS og_site_name_19, c0_.twitter_card AS twitter_card_20, c0_.twitter_site AS twitter_site_21, c0_.twitter_title AS twitter_title_22, c0_.twitter_description AS twitter_description_23, c0_.twitter_creator AS twitter_creator_24, c0_.created_at AS created_at_25, c0_.updated_at AS updated_at_26, c1_.id AS id_27, c1_.name AS name_28, c1_.methods AS methods_29, c1_.path AS path_30, c1_.controller AS controller_31, c1_.defaults AS defaults_32, c1_.requirements AS requirements_33, c2_.id AS id_34, c2_.slug AS slug_35, c2_.label AS label_36, c2_.locale AS locale_37, c2_.host AS host_38, c2_.localhost AS localhost_39, c2_.host_multilingual AS host_multilingual_40, c2_.`default` AS default_41, c2_.flag_icon AS flag_icon_42, c2_.visible AS visible_43, c2_.template_filter AS template_filter_44, c3_.id AS id_45, c3_.title AS title_46, c3_.technic_name AS technic_name_47, c3_.locale AS locale_48, c3_.active AS active_49, c3_.params AS params_50, c3_.seo_title AS seo_title_51, c3_.seo_description AS seo_description_52, c3_.seo_keywords AS seo_keywords_53, c3_.seo_sitemap_priority AS seo_sitemap_priority_54, c3_.seo_sitemap_change_freq AS seo_sitemap_change_freq_55, c3_.og_title AS og_title_56, c3_.og_type AS og_type_57, c3_.og_description AS og_description_58, c3_.og_site_name AS og_site_name_59, c3_.twitter_card AS twitter_card_60, c3_.twitter_site AS twitter_site_61, c3_.twitter_title AS twitter_title_62, c3_.twitter_description AS twitter_description_63, c3_.twitter_creator AS twitter_creator_64, c0_.route_id AS route_id_65, c0_.site_id AS site_id_66, c0_.tree_root AS tree_root_67, c0_.parent_id AS parent_id_68, c0_.og_image_id AS og_image_id_69, c0_.twitter_image_id AS twitter_image_id_70, c1_.discr AS discr_71, c3_.page_id AS page_id_72, c3_.og_image_id AS og_image_id_73, c3_.twitter_image_id AS twitter_image_id_74 FROM cms__page c0_ LEFT JOIN cms__route c1_ ON c0_.route_id = c1_.id AND c1_.discr IN ('base') LEFT JOIN cms__site c2_ ON c0_.site_id = c2_.id LEFT JOIN cms__page_declination c3_ ON c0_.id = c3_.page_id WHERE c1_.name = NULL;
|