| 1 |
0.45 ms |
SELECT t0_.id AS id_0, t0_.position AS position_1, t0_.created AS created_2, t0_.updated AS updated_3, t0_.domain_name AS domain_name_4, t0_.domain_is_default AS domain_is_default_5, t1_.id AS id_6, t1_.position AS position_7, t1_.created AS created_8, t1_.updated AS updated_9, t1_.site_name AS site_name_10, t1_.site_code AS site_code_11, t1_.site_is_default AS site_is_default_12, t0_.site_id AS site_id_13, t1_.layout_id AS layout_id_14, t1_.analytic_id AS analytic_id_15 FROM tv_domain t0_ INNER JOIN tv_sites t1_ ON t0_.site_id = t1_.id WHERE t0_.domain_name = ?
Parameters: [
"touristra.octelio.net"
]
SELECT t0_.id AS id_0, t0_.position AS position_1, t0_.created AS created_2, t0_.updated AS updated_3, t0_.domain_name AS domain_name_4, t0_.domain_is_default AS domain_is_default_5, t1_.id AS id_6, t1_.position AS position_7, t1_.created AS created_8, t1_.updated AS updated_9, t1_.site_name AS site_name_10, t1_.site_code AS site_code_11, t1_.site_is_default AS site_is_default_12, t0_.site_id AS site_id_13, t1_.layout_id AS layout_id_14, t1_.analytic_id AS analytic_id_15 FROM tv_domain t0_ INNER JOIN tv_sites t1_ ON t0_.site_id = t1_.id WHERE t0_.domain_name = 'touristra.octelio.net';
|
| 2 |
0.43 ms |
SELECT t0_.id AS id_0, t0_.position AS position_1, t0_.created AS created_2, t0_.updated AS updated_3, t0_.site_name AS site_name_4, t0_.site_code AS site_code_5, t0_.site_is_default AS site_is_default_6, t1_.id AS id_7, t1_.position AS position_8, t1_.created AS created_9, t1_.updated AS updated_10, t1_.google_analytic AS google_analytic_11, t1_.webmaster_tool AS webmaster_tool_12, t1_.analytic_meta AS analytic_meta_13, t1_.analytic_script AS analytic_script_14, t2_.id AS id_15, t2_.media_index AS media_index_16, t2_.media_description AS media_description_17, t2_.media_zoom AS media_zoom_18, t2_.position AS position_19, t0_.layout_id AS layout_id_20, t0_.analytic_id AS analytic_id_21, t1_.site_id AS site_id_22, t2_.block_id AS block_id_23, t2_.page_id AS page_id_24, t2_.seo_id AS seo_id_25, t2_.analytic_id AS analytic_id_26, t2_.banner_id AS banner_id_27, t2_.article_id AS article_id_28, t2_.slide_id AS slide_id_29, t2_.carouselItem_id AS carouselItem_id_30, t2_.textandimage_id AS textandimage_id_31, t2_.icone_id AS icone_id_32, t2_.link_id AS link_id_33, t2_.media_id AS media_id_34, t2_.categorydescription_id AS categorydescription_id_35, t2_.etabdescription_id AS etabdescription_id_36, t2_.etab_gallery_id AS etab_gallery_id_37, t2_.liste_id AS liste_id_38, t2_.pension_id AS pension_id_39, t2_.promo_id AS promo_id_40, t2_.roomfeature_id AS roomfeature_id_41, t2_.roomfeaturevalue_id AS roomfeaturevalue_id_42, t2_.postecategory_id AS postecategory_id_43, t2_.articlecategory_id AS articlecategory_id_44, t2_.thematicfilecategory_id AS thematicfilecategory_id_45, t2_.roomtype_id AS roomtype_id_46, t2_.tab_id AS tab_id_47 FROM tv_sites t0_ LEFT JOIN tv_seo_analytics t1_ ON t0_.analytic_id = t1_.id LEFT JOIN tv_medias_relations t2_ ON t1_.id = t2_.analytic_id WHERE t0_.site_is_default = ?
SELECT
t0_.id AS id_0,
t0_.position AS position_1,
t0_.created AS created_2,
t0_.updated AS updated_3,
t0_.site_name AS site_name_4,
t0_.site_code AS site_code_5,
t0_.site_is_default AS site_is_default_6,
t1_.id AS id_7,
t1_.position AS position_8,
t1_.created AS created_9,
t1_.updated AS updated_10,
t1_.google_analytic AS google_analytic_11,
t1_.webmaster_tool AS webmaster_tool_12,
t1_.analytic_meta AS analytic_meta_13,
t1_.analytic_script AS analytic_script_14,
t2_.id AS id_15,
t2_.media_index AS media_index_16,
t2_.media_description AS media_description_17,
t2_.media_zoom AS media_zoom_18,
t2_.position AS position_19,
t0_.layout_id AS layout_id_20,
t0_.analytic_id AS analytic_id_21,
t1_.site_id AS site_id_22,
t2_.block_id AS block_id_23,
t2_.page_id AS page_id_24,
t2_.seo_id AS seo_id_25,
t2_.analytic_id AS analytic_id_26,
t2_.banner_id AS banner_id_27,
t2_.article_id AS article_id_28,
t2_.slide_id AS slide_id_29,
t2_.carouselItem_id AS carouselItem_id_30,
t2_.textandimage_id AS textandimage_id_31,
t2_.icone_id AS icone_id_32,
t2_.link_id AS link_id_33,
t2_.media_id AS media_id_34,
t2_.categorydescription_id AS categorydescription_id_35,
t2_.etabdescription_id AS etabdescription_id_36,
t2_.etab_gallery_id AS etab_gallery_id_37,
t2_.liste_id AS liste_id_38,
t2_.pension_id AS pension_id_39,
t2_.promo_id AS promo_id_40,
t2_.roomfeature_id AS roomfeature_id_41,
t2_.roomfeaturevalue_id AS roomfeaturevalue_id_42,
t2_.postecategory_id AS postecategory_id_43,
t2_.articlecategory_id AS articlecategory_id_44,
t2_.thematicfilecategory_id AS thematicfilecategory_id_45,
t2_.roomtype_id AS roomtype_id_46,
t2_.tab_id AS tab_id_47
FROM
tv_sites t0_
LEFT JOIN tv_seo_analytics t1_ ON t0_.analytic_id = t1_.id
LEFT JOIN tv_medias_relations t2_ ON t1_.id = t2_.analytic_id
WHERE
t0_.site_is_default = ?
SELECT t0_.id AS id_0, t0_.position AS position_1, t0_.created AS created_2, t0_.updated AS updated_3, t0_.site_name AS site_name_4, t0_.site_code AS site_code_5, t0_.site_is_default AS site_is_default_6, t1_.id AS id_7, t1_.position AS position_8, t1_.created AS created_9, t1_.updated AS updated_10, t1_.google_analytic AS google_analytic_11, t1_.webmaster_tool AS webmaster_tool_12, t1_.analytic_meta AS analytic_meta_13, t1_.analytic_script AS analytic_script_14, t2_.id AS id_15, t2_.media_index AS media_index_16, t2_.media_description AS media_description_17, t2_.media_zoom AS media_zoom_18, t2_.position AS position_19, t0_.layout_id AS layout_id_20, t0_.analytic_id AS analytic_id_21, t1_.site_id AS site_id_22, t2_.block_id AS block_id_23, t2_.page_id AS page_id_24, t2_.seo_id AS seo_id_25, t2_.analytic_id AS analytic_id_26, t2_.banner_id AS banner_id_27, t2_.article_id AS article_id_28, t2_.slide_id AS slide_id_29, t2_.carouselItem_id AS carouselItem_id_30, t2_.textandimage_id AS textandimage_id_31, t2_.icone_id AS icone_id_32, t2_.link_id AS link_id_33, t2_.media_id AS media_id_34, t2_.categorydescription_id AS categorydescription_id_35, t2_.etabdescription_id AS etabdescription_id_36, t2_.etab_gallery_id AS etab_gallery_id_37, t2_.liste_id AS liste_id_38, t2_.pension_id AS pension_id_39, t2_.promo_id AS promo_id_40, t2_.roomfeature_id AS roomfeature_id_41, t2_.roomfeaturevalue_id AS roomfeaturevalue_id_42, t2_.postecategory_id AS postecategory_id_43, t2_.articlecategory_id AS articlecategory_id_44, t2_.thematicfilecategory_id AS thematicfilecategory_id_45, t2_.roomtype_id AS roomtype_id_46, t2_.tab_id AS tab_id_47 FROM tv_sites t0_ LEFT JOIN tv_seo_analytics t1_ ON t0_.analytic_id = t1_.id LEFT JOIN tv_medias_relations t2_ ON t1_.id = t2_.analytic_id WHERE t0_.site_is_default = 1;
|
| 3 |
0.38 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.subsite_name AS subsite_name_5, t0.subsite_code AS subsite_code_6 FROM tv_subsite t0 WHERE t0.subsite_code = ? LIMIT 1
Parameters: [
"touristra"
]
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.subsite_name AS subsite_name_5, t0.subsite_code AS subsite_code_6 FROM tv_subsite t0 WHERE t0.subsite_code = 'touristra' LIMIT 1;
|
| 4 |
0.41 ms |
SELECT t0_.id AS id_0, t0_.position AS position_1, t0_.created AS created_2, t0_.updated AS updated_3, t0_.site_name AS site_name_4, t0_.site_code AS site_code_5, t0_.site_is_default AS site_is_default_6, t1_.id AS id_7, t1_.position AS position_8, t1_.created AS created_9, t1_.updated AS updated_10, t1_.google_analytic AS google_analytic_11, t1_.webmaster_tool AS webmaster_tool_12, t1_.analytic_meta AS analytic_meta_13, t1_.analytic_script AS analytic_script_14, t2_.id AS id_15, t2_.media_index AS media_index_16, t2_.media_description AS media_description_17, t2_.media_zoom AS media_zoom_18, t2_.position AS position_19, t0_.layout_id AS layout_id_20, t0_.analytic_id AS analytic_id_21, t1_.site_id AS site_id_22, t2_.block_id AS block_id_23, t2_.page_id AS page_id_24, t2_.seo_id AS seo_id_25, t2_.analytic_id AS analytic_id_26, t2_.banner_id AS banner_id_27, t2_.article_id AS article_id_28, t2_.slide_id AS slide_id_29, t2_.carouselItem_id AS carouselItem_id_30, t2_.textandimage_id AS textandimage_id_31, t2_.icone_id AS icone_id_32, t2_.link_id AS link_id_33, t2_.media_id AS media_id_34, t2_.categorydescription_id AS categorydescription_id_35, t2_.etabdescription_id AS etabdescription_id_36, t2_.etab_gallery_id AS etab_gallery_id_37, t2_.liste_id AS liste_id_38, t2_.pension_id AS pension_id_39, t2_.promo_id AS promo_id_40, t2_.roomfeature_id AS roomfeature_id_41, t2_.roomfeaturevalue_id AS roomfeaturevalue_id_42, t2_.postecategory_id AS postecategory_id_43, t2_.articlecategory_id AS articlecategory_id_44, t2_.thematicfilecategory_id AS thematicfilecategory_id_45, t2_.roomtype_id AS roomtype_id_46, t2_.tab_id AS tab_id_47 FROM tv_sites t0_ LEFT JOIN tv_seo_analytics t1_ ON t0_.analytic_id = t1_.id LEFT JOIN tv_medias_relations t2_ ON t1_.id = t2_.analytic_id WHERE t0_.id = ?
SELECT
t0_.id AS id_0,
t0_.position AS position_1,
t0_.created AS created_2,
t0_.updated AS updated_3,
t0_.site_name AS site_name_4,
t0_.site_code AS site_code_5,
t0_.site_is_default AS site_is_default_6,
t1_.id AS id_7,
t1_.position AS position_8,
t1_.created AS created_9,
t1_.updated AS updated_10,
t1_.google_analytic AS google_analytic_11,
t1_.webmaster_tool AS webmaster_tool_12,
t1_.analytic_meta AS analytic_meta_13,
t1_.analytic_script AS analytic_script_14,
t2_.id AS id_15,
t2_.media_index AS media_index_16,
t2_.media_description AS media_description_17,
t2_.media_zoom AS media_zoom_18,
t2_.position AS position_19,
t0_.layout_id AS layout_id_20,
t0_.analytic_id AS analytic_id_21,
t1_.site_id AS site_id_22,
t2_.block_id AS block_id_23,
t2_.page_id AS page_id_24,
t2_.seo_id AS seo_id_25,
t2_.analytic_id AS analytic_id_26,
t2_.banner_id AS banner_id_27,
t2_.article_id AS article_id_28,
t2_.slide_id AS slide_id_29,
t2_.carouselItem_id AS carouselItem_id_30,
t2_.textandimage_id AS textandimage_id_31,
t2_.icone_id AS icone_id_32,
t2_.link_id AS link_id_33,
t2_.media_id AS media_id_34,
t2_.categorydescription_id AS categorydescription_id_35,
t2_.etabdescription_id AS etabdescription_id_36,
t2_.etab_gallery_id AS etab_gallery_id_37,
t2_.liste_id AS liste_id_38,
t2_.pension_id AS pension_id_39,
t2_.promo_id AS promo_id_40,
t2_.roomfeature_id AS roomfeature_id_41,
t2_.roomfeaturevalue_id AS roomfeaturevalue_id_42,
t2_.postecategory_id AS postecategory_id_43,
t2_.articlecategory_id AS articlecategory_id_44,
t2_.thematicfilecategory_id AS thematicfilecategory_id_45,
t2_.roomtype_id AS roomtype_id_46,
t2_.tab_id AS tab_id_47
FROM
tv_sites t0_
LEFT JOIN tv_seo_analytics t1_ ON t0_.analytic_id = t1_.id
LEFT JOIN tv_medias_relations t2_ ON t1_.id = t2_.analytic_id
WHERE
t0_.id = ?
SELECT t0_.id AS id_0, t0_.position AS position_1, t0_.created AS created_2, t0_.updated AS updated_3, t0_.site_name AS site_name_4, t0_.site_code AS site_code_5, t0_.site_is_default AS site_is_default_6, t1_.id AS id_7, t1_.position AS position_8, t1_.created AS created_9, t1_.updated AS updated_10, t1_.google_analytic AS google_analytic_11, t1_.webmaster_tool AS webmaster_tool_12, t1_.analytic_meta AS analytic_meta_13, t1_.analytic_script AS analytic_script_14, t2_.id AS id_15, t2_.media_index AS media_index_16, t2_.media_description AS media_description_17, t2_.media_zoom AS media_zoom_18, t2_.position AS position_19, t0_.layout_id AS layout_id_20, t0_.analytic_id AS analytic_id_21, t1_.site_id AS site_id_22, t2_.block_id AS block_id_23, t2_.page_id AS page_id_24, t2_.seo_id AS seo_id_25, t2_.analytic_id AS analytic_id_26, t2_.banner_id AS banner_id_27, t2_.article_id AS article_id_28, t2_.slide_id AS slide_id_29, t2_.carouselItem_id AS carouselItem_id_30, t2_.textandimage_id AS textandimage_id_31, t2_.icone_id AS icone_id_32, t2_.link_id AS link_id_33, t2_.media_id AS media_id_34, t2_.categorydescription_id AS categorydescription_id_35, t2_.etabdescription_id AS etabdescription_id_36, t2_.etab_gallery_id AS etab_gallery_id_37, t2_.liste_id AS liste_id_38, t2_.pension_id AS pension_id_39, t2_.promo_id AS promo_id_40, t2_.roomfeature_id AS roomfeature_id_41, t2_.roomfeaturevalue_id AS roomfeaturevalue_id_42, t2_.postecategory_id AS postecategory_id_43, t2_.articlecategory_id AS articlecategory_id_44, t2_.thematicfilecategory_id AS thematicfilecategory_id_45, t2_.roomtype_id AS roomtype_id_46, t2_.tab_id AS tab_id_47 FROM tv_sites t0_ LEFT JOIN tv_seo_analytics t1_ ON t0_.analytic_id = t1_.id LEFT JOIN tv_medias_relations t2_ ON t1_.id = t2_.analytic_id WHERE t0_.id = 1;
|
| 5 |
0.39 ms |
SELECT t0_.id AS id_0, t0_.position AS position_1, t0_.created AS created_2, t0_.updated AS updated_3, t0_.menu_name AS menu_name_4, t0_.menu_code AS menu_code_5, t0_.menu_template AS menu_template_6, t0_.menu_is_default AS menu_is_default_7, t0_.menu_sub_template AS menu_sub_template_8, t0_.menu_label AS menu_label_9, t0_.site_id AS site_id_10 FROM tv_menus t0_ LEFT JOIN tv_subsite_menu t2_ ON t0_.id = t2_.menu_id LEFT JOIN tv_subsite t1_ ON t1_.id = t2_.subsite_id WHERE t1_.id = ? AND t0_.site_id = ? AND t0_.menu_template = ? ORDER BY t0_.position ASC
Parameters: [
1
1
"megamenu"
]
SELECT t0_.id AS id_0, t0_.position AS position_1, t0_.created AS created_2, t0_.updated AS updated_3, t0_.menu_name AS menu_name_4, t0_.menu_code AS menu_code_5, t0_.menu_template AS menu_template_6, t0_.menu_is_default AS menu_is_default_7, t0_.menu_sub_template AS menu_sub_template_8, t0_.menu_label AS menu_label_9, t0_.site_id AS site_id_10 FROM tv_menus t0_ LEFT JOIN tv_subsite_menu t2_ ON t0_.id = t2_.menu_id LEFT JOIN tv_subsite t1_ ON t1_.id = t2_.subsite_id WHERE t1_.id = 1 AND t0_.site_id = 1 AND t0_.menu_template = 'megamenu' ORDER BY t0_.position ASC;
|
| 6 |
0.46 ms |
SELECT t0_.id AS id_0, t0_.position AS position_1, t0_.created AS created_2, t0_.updated AS updated_3, t0_.page_name AS page_name_4, t0_.page_name_back AS page_name_back_5, t0_.page_code AS page_code_6, t0_.page_is_default AS page_is_default_7, t0_.page_level AS page_level_8, t0_.online AS online_9, t0_.page_plan AS page_plan_10, t0_.page_arbo AS page_arbo_11, t0_.subsite AS subsite_12, t1_.id AS id_13, t1_.position AS position_14, t1_.created AS created_15, t1_.updated AS updated_16, t1_.layout_name AS layout_name_17, t1_.layout_code AS layout_code_18, t2_.id AS id_19, t2_.position AS position_20, t2_.created AS created_21, t2_.updated AS updated_22, t2_.template_name AS template_name_23, t2_.template_code AS template_code_24, t2_.template_width AS template_width_25, t2_.template_padding AS template_padding_26, t2_.template_is_active AS template_is_active_27, t3_.id AS id_28, t3_.media_index AS media_index_29, t3_.media_description AS media_description_30, t3_.media_zoom AS media_zoom_31, t3_.position AS position_32, t4_.id AS id_33, t4_.position AS position_34, t4_.created AS created_35, t4_.updated AS updated_36, t4_.meta_title AS meta_title_37, t4_.meta_description AS meta_description_38, t4_.meta_canonical AS meta_canonical_39, t4_.meta_index AS meta_index_40, t4_.meta_follow AS meta_follow_41, t4_.meta_og_title AS meta_og_title_42, t4_.meta_og_description AS meta_og_description_43, t5_.id AS id_44, t5_.media_index AS media_index_45, t5_.media_description AS media_description_46, t5_.media_zoom AS media_zoom_47, t5_.position AS position_48, t0_.layout_id AS layout_id_49, t0_.site_id AS site_id_50, t0_.template_id AS template_id_51, t0_.parent_id AS parent_id_52, t0_.article_categorie_id AS article_categorie_id_53, t0_.thematic_categorie_id AS thematic_categorie_id_54, t3_.block_id AS block_id_55, t3_.page_id AS page_id_56, t3_.seo_id AS seo_id_57, t3_.analytic_id AS analytic_id_58, t3_.banner_id AS banner_id_59, t3_.article_id AS article_id_60, t3_.slide_id AS slide_id_61, t3_.carouselItem_id AS carouselItem_id_62, t3_.textandimage_id AS textandimage_id_63, t3_.icone_id AS icone_id_64, t3_.link_id AS link_id_65, t3_.media_id AS media_id_66, t3_.categorydescription_id AS categorydescription_id_67, t3_.etabdescription_id AS etabdescription_id_68, t3_.etab_gallery_id AS etab_gallery_id_69, t3_.liste_id AS liste_id_70, t3_.pension_id AS pension_id_71, t3_.promo_id AS promo_id_72, t3_.roomfeature_id AS roomfeature_id_73, t3_.roomfeaturevalue_id AS roomfeaturevalue_id_74, t3_.postecategory_id AS postecategory_id_75, t3_.articlecategory_id AS articlecategory_id_76, t3_.thematicfilecategory_id AS thematicfilecategory_id_77, t3_.roomtype_id AS roomtype_id_78, t3_.tab_id AS tab_id_79, t4_.page_id AS page_id_80, t5_.block_id AS block_id_81, t5_.page_id AS page_id_82, t5_.seo_id AS seo_id_83, t5_.analytic_id AS analytic_id_84, t5_.banner_id AS banner_id_85, t5_.article_id AS article_id_86, t5_.slide_id AS slide_id_87, t5_.carouselItem_id AS carouselItem_id_88, t5_.textandimage_id AS textandimage_id_89, t5_.icone_id AS icone_id_90, t5_.link_id AS link_id_91, t5_.media_id AS media_id_92, t5_.categorydescription_id AS categorydescription_id_93, t5_.etabdescription_id AS etabdescription_id_94, t5_.etab_gallery_id AS etab_gallery_id_95, t5_.liste_id AS liste_id_96, t5_.pension_id AS pension_id_97, t5_.promo_id AS promo_id_98, t5_.roomfeature_id AS roomfeature_id_99, t5_.roomfeaturevalue_id AS roomfeaturevalue_id_100, t5_.postecategory_id AS postecategory_id_101, t5_.articlecategory_id AS articlecategory_id_102, t5_.thematicfilecategory_id AS thematicfilecategory_id_103, t5_.roomtype_id AS roomtype_id_104, t5_.tab_id AS tab_id_105 FROM tv_pages t0_ LEFT JOIN tv_layouts t1_ ON t0_.layout_id = t1_.id INNER JOIN tv_templates t2_ ON t0_.template_id = t2_.id LEFT JOIN tv_medias_relations t3_ ON t0_.id = t3_.page_id LEFT JOIN tv_seo t4_ ON t0_.id = t4_.page_id LEFT JOIN tv_medias_relations t5_ ON t4_.id = t5_.seo_id WHERE t0_.page_is_default = ? AND t0_.site_id = ? AND t0_.subsite IS NULL
SELECT
t0_.id AS id_0,
t0_.position AS position_1,
t0_.created AS created_2,
t0_.updated AS updated_3,
t0_.page_name AS page_name_4,
t0_.page_name_back AS page_name_back_5,
t0_.page_code AS page_code_6,
t0_.page_is_default AS page_is_default_7,
t0_.page_level AS page_level_8,
t0_.online AS online_9,
t0_.page_plan AS page_plan_10,
t0_.page_arbo AS page_arbo_11,
t0_.subsite AS subsite_12,
t1_.id AS id_13,
t1_.position AS position_14,
t1_.created AS created_15,
t1_.updated AS updated_16,
t1_.layout_name AS layout_name_17,
t1_.layout_code AS layout_code_18,
t2_.id AS id_19,
t2_.position AS position_20,
t2_.created AS created_21,
t2_.updated AS updated_22,
t2_.template_name AS template_name_23,
t2_.template_code AS template_code_24,
t2_.template_width AS template_width_25,
t2_.template_padding AS template_padding_26,
t2_.template_is_active AS template_is_active_27,
t3_.id AS id_28,
t3_.media_index AS media_index_29,
t3_.media_description AS media_description_30,
t3_.media_zoom AS media_zoom_31,
t3_.position AS position_32,
t4_.id AS id_33,
t4_.position AS position_34,
t4_.created AS created_35,
t4_.updated AS updated_36,
t4_.meta_title AS meta_title_37,
t4_.meta_description AS meta_description_38,
t4_.meta_canonical AS meta_canonical_39,
t4_.meta_index AS meta_index_40,
t4_.meta_follow AS meta_follow_41,
t4_.meta_og_title AS meta_og_title_42,
t4_.meta_og_description AS meta_og_description_43,
t5_.id AS id_44,
t5_.media_index AS media_index_45,
t5_.media_description AS media_description_46,
t5_.media_zoom AS media_zoom_47,
t5_.position AS position_48,
t0_.layout_id AS layout_id_49,
t0_.site_id AS site_id_50,
t0_.template_id AS template_id_51,
t0_.parent_id AS parent_id_52,
t0_.article_categorie_id AS article_categorie_id_53,
t0_.thematic_categorie_id AS thematic_categorie_id_54,
t3_.block_id AS block_id_55,
t3_.page_id AS page_id_56,
t3_.seo_id AS seo_id_57,
t3_.analytic_id AS analytic_id_58,
t3_.banner_id AS banner_id_59,
t3_.article_id AS article_id_60,
t3_.slide_id AS slide_id_61,
t3_.carouselItem_id AS carouselItem_id_62,
t3_.textandimage_id AS textandimage_id_63,
t3_.icone_id AS icone_id_64,
t3_.link_id AS link_id_65,
t3_.media_id AS media_id_66,
t3_.categorydescription_id AS categorydescription_id_67,
t3_.etabdescription_id AS etabdescription_id_68,
t3_.etab_gallery_id AS etab_gallery_id_69,
t3_.liste_id AS liste_id_70,
t3_.pension_id AS pension_id_71,
t3_.promo_id AS promo_id_72,
t3_.roomfeature_id AS roomfeature_id_73,
t3_.roomfeaturevalue_id AS roomfeaturevalue_id_74,
t3_.postecategory_id AS postecategory_id_75,
t3_.articlecategory_id AS articlecategory_id_76,
t3_.thematicfilecategory_id AS thematicfilecategory_id_77,
t3_.roomtype_id AS roomtype_id_78,
t3_.tab_id AS tab_id_79,
t4_.page_id AS page_id_80,
t5_.block_id AS block_id_81,
t5_.page_id AS page_id_82,
t5_.seo_id AS seo_id_83,
t5_.analytic_id AS analytic_id_84,
t5_.banner_id AS banner_id_85,
t5_.article_id AS article_id_86,
t5_.slide_id AS slide_id_87,
t5_.carouselItem_id AS carouselItem_id_88,
t5_.textandimage_id AS textandimage_id_89,
t5_.icone_id AS icone_id_90,
t5_.link_id AS link_id_91,
t5_.media_id AS media_id_92,
t5_.categorydescription_id AS categorydescription_id_93,
t5_.etabdescription_id AS etabdescription_id_94,
t5_.etab_gallery_id AS etab_gallery_id_95,
t5_.liste_id AS liste_id_96,
t5_.pension_id AS pension_id_97,
t5_.promo_id AS promo_id_98,
t5_.roomfeature_id AS roomfeature_id_99,
t5_.roomfeaturevalue_id AS roomfeaturevalue_id_100,
t5_.postecategory_id AS postecategory_id_101,
t5_.articlecategory_id AS articlecategory_id_102,
t5_.thematicfilecategory_id AS thematicfilecategory_id_103,
t5_.roomtype_id AS roomtype_id_104,
t5_.tab_id AS tab_id_105
FROM
tv_pages t0_
LEFT JOIN tv_layouts t1_ ON t0_.layout_id = t1_.id
INNER JOIN tv_templates t2_ ON t0_.template_id = t2_.id
LEFT JOIN tv_medias_relations t3_ ON t0_.id = t3_.page_id
LEFT JOIN tv_seo t4_ ON t0_.id = t4_.page_id
LEFT JOIN tv_medias_relations t5_ ON t4_.id = t5_.seo_id
WHERE
t0_.page_is_default = ?
AND t0_.site_id = ?
AND t0_.subsite IS NULL
SELECT t0_.id AS id_0, t0_.position AS position_1, t0_.created AS created_2, t0_.updated AS updated_3, t0_.page_name AS page_name_4, t0_.page_name_back AS page_name_back_5, t0_.page_code AS page_code_6, t0_.page_is_default AS page_is_default_7, t0_.page_level AS page_level_8, t0_.online AS online_9, t0_.page_plan AS page_plan_10, t0_.page_arbo AS page_arbo_11, t0_.subsite AS subsite_12, t1_.id AS id_13, t1_.position AS position_14, t1_.created AS created_15, t1_.updated AS updated_16, t1_.layout_name AS layout_name_17, t1_.layout_code AS layout_code_18, t2_.id AS id_19, t2_.position AS position_20, t2_.created AS created_21, t2_.updated AS updated_22, t2_.template_name AS template_name_23, t2_.template_code AS template_code_24, t2_.template_width AS template_width_25, t2_.template_padding AS template_padding_26, t2_.template_is_active AS template_is_active_27, t3_.id AS id_28, t3_.media_index AS media_index_29, t3_.media_description AS media_description_30, t3_.media_zoom AS media_zoom_31, t3_.position AS position_32, t4_.id AS id_33, t4_.position AS position_34, t4_.created AS created_35, t4_.updated AS updated_36, t4_.meta_title AS meta_title_37, t4_.meta_description AS meta_description_38, t4_.meta_canonical AS meta_canonical_39, t4_.meta_index AS meta_index_40, t4_.meta_follow AS meta_follow_41, t4_.meta_og_title AS meta_og_title_42, t4_.meta_og_description AS meta_og_description_43, t5_.id AS id_44, t5_.media_index AS media_index_45, t5_.media_description AS media_description_46, t5_.media_zoom AS media_zoom_47, t5_.position AS position_48, t0_.layout_id AS layout_id_49, t0_.site_id AS site_id_50, t0_.template_id AS template_id_51, t0_.parent_id AS parent_id_52, t0_.article_categorie_id AS article_categorie_id_53, t0_.thematic_categorie_id AS thematic_categorie_id_54, t3_.block_id AS block_id_55, t3_.page_id AS page_id_56, t3_.seo_id AS seo_id_57, t3_.analytic_id AS analytic_id_58, t3_.banner_id AS banner_id_59, t3_.article_id AS article_id_60, t3_.slide_id AS slide_id_61, t3_.carouselItem_id AS carouselItem_id_62, t3_.textandimage_id AS textandimage_id_63, t3_.icone_id AS icone_id_64, t3_.link_id AS link_id_65, t3_.media_id AS media_id_66, t3_.categorydescription_id AS categorydescription_id_67, t3_.etabdescription_id AS etabdescription_id_68, t3_.etab_gallery_id AS etab_gallery_id_69, t3_.liste_id AS liste_id_70, t3_.pension_id AS pension_id_71, t3_.promo_id AS promo_id_72, t3_.roomfeature_id AS roomfeature_id_73, t3_.roomfeaturevalue_id AS roomfeaturevalue_id_74, t3_.postecategory_id AS postecategory_id_75, t3_.articlecategory_id AS articlecategory_id_76, t3_.thematicfilecategory_id AS thematicfilecategory_id_77, t3_.roomtype_id AS roomtype_id_78, t3_.tab_id AS tab_id_79, t4_.page_id AS page_id_80, t5_.block_id AS block_id_81, t5_.page_id AS page_id_82, t5_.seo_id AS seo_id_83, t5_.analytic_id AS analytic_id_84, t5_.banner_id AS banner_id_85, t5_.article_id AS article_id_86, t5_.slide_id AS slide_id_87, t5_.carouselItem_id AS carouselItem_id_88, t5_.textandimage_id AS textandimage_id_89, t5_.icone_id AS icone_id_90, t5_.link_id AS link_id_91, t5_.media_id AS media_id_92, t5_.categorydescription_id AS categorydescription_id_93, t5_.etabdescription_id AS etabdescription_id_94, t5_.etab_gallery_id AS etab_gallery_id_95, t5_.liste_id AS liste_id_96, t5_.pension_id AS pension_id_97, t5_.promo_id AS promo_id_98, t5_.roomfeature_id AS roomfeature_id_99, t5_.roomfeaturevalue_id AS roomfeaturevalue_id_100, t5_.postecategory_id AS postecategory_id_101, t5_.articlecategory_id AS articlecategory_id_102, t5_.thematicfilecategory_id AS thematicfilecategory_id_103, t5_.roomtype_id AS roomtype_id_104, t5_.tab_id AS tab_id_105 FROM tv_pages t0_ LEFT JOIN tv_layouts t1_ ON t0_.layout_id = t1_.id INNER JOIN tv_templates t2_ ON t0_.template_id = t2_.id LEFT JOIN tv_medias_relations t3_ ON t0_.id = t3_.page_id LEFT JOIN tv_seo t4_ ON t0_.id = t4_.page_id LEFT JOIN tv_medias_relations t5_ ON t4_.id = t5_.seo_id WHERE t0_.page_is_default = 1 AND t0_.site_id = 1 AND t0_.subsite IS NULL;
|
| 7 |
0.48 ms |
SELECT t0_.id AS id_0, t0_.position AS position_1, t0_.created AS created_2, t0_.updated AS updated_3, t0_.page_name AS page_name_4, t0_.page_name_back AS page_name_back_5, t0_.page_code AS page_code_6, t0_.page_is_default AS page_is_default_7, t0_.page_level AS page_level_8, t0_.online AS online_9, t0_.page_plan AS page_plan_10, t0_.page_arbo AS page_arbo_11, t0_.subsite AS subsite_12, t1_.id AS id_13, t1_.position AS position_14, t1_.created AS created_15, t1_.updated AS updated_16, t1_.layout_name AS layout_name_17, t1_.layout_code AS layout_code_18, t2_.id AS id_19, t2_.position AS position_20, t2_.created AS created_21, t2_.updated AS updated_22, t2_.template_name AS template_name_23, t2_.template_code AS template_code_24, t2_.template_width AS template_width_25, t2_.template_padding AS template_padding_26, t2_.template_is_active AS template_is_active_27, t3_.id AS id_28, t3_.media_index AS media_index_29, t3_.media_description AS media_description_30, t3_.media_zoom AS media_zoom_31, t3_.position AS position_32, t4_.id AS id_33, t4_.position AS position_34, t4_.created AS created_35, t4_.updated AS updated_36, t4_.meta_title AS meta_title_37, t4_.meta_description AS meta_description_38, t4_.meta_canonical AS meta_canonical_39, t4_.meta_index AS meta_index_40, t4_.meta_follow AS meta_follow_41, t4_.meta_og_title AS meta_og_title_42, t4_.meta_og_description AS meta_og_description_43, t5_.id AS id_44, t5_.media_index AS media_index_45, t5_.media_description AS media_description_46, t5_.media_zoom AS media_zoom_47, t5_.position AS position_48, t0_.layout_id AS layout_id_49, t0_.site_id AS site_id_50, t0_.template_id AS template_id_51, t0_.parent_id AS parent_id_52, t0_.article_categorie_id AS article_categorie_id_53, t0_.thematic_categorie_id AS thematic_categorie_id_54, t3_.block_id AS block_id_55, t3_.page_id AS page_id_56, t3_.seo_id AS seo_id_57, t3_.analytic_id AS analytic_id_58, t3_.banner_id AS banner_id_59, t3_.article_id AS article_id_60, t3_.slide_id AS slide_id_61, t3_.carouselItem_id AS carouselItem_id_62, t3_.textandimage_id AS textandimage_id_63, t3_.icone_id AS icone_id_64, t3_.link_id AS link_id_65, t3_.media_id AS media_id_66, t3_.categorydescription_id AS categorydescription_id_67, t3_.etabdescription_id AS etabdescription_id_68, t3_.etab_gallery_id AS etab_gallery_id_69, t3_.liste_id AS liste_id_70, t3_.pension_id AS pension_id_71, t3_.promo_id AS promo_id_72, t3_.roomfeature_id AS roomfeature_id_73, t3_.roomfeaturevalue_id AS roomfeaturevalue_id_74, t3_.postecategory_id AS postecategory_id_75, t3_.articlecategory_id AS articlecategory_id_76, t3_.thematicfilecategory_id AS thematicfilecategory_id_77, t3_.roomtype_id AS roomtype_id_78, t3_.tab_id AS tab_id_79, t4_.page_id AS page_id_80, t5_.block_id AS block_id_81, t5_.page_id AS page_id_82, t5_.seo_id AS seo_id_83, t5_.analytic_id AS analytic_id_84, t5_.banner_id AS banner_id_85, t5_.article_id AS article_id_86, t5_.slide_id AS slide_id_87, t5_.carouselItem_id AS carouselItem_id_88, t5_.textandimage_id AS textandimage_id_89, t5_.icone_id AS icone_id_90, t5_.link_id AS link_id_91, t5_.media_id AS media_id_92, t5_.categorydescription_id AS categorydescription_id_93, t5_.etabdescription_id AS etabdescription_id_94, t5_.etab_gallery_id AS etab_gallery_id_95, t5_.liste_id AS liste_id_96, t5_.pension_id AS pension_id_97, t5_.promo_id AS promo_id_98, t5_.roomfeature_id AS roomfeature_id_99, t5_.roomfeaturevalue_id AS roomfeaturevalue_id_100, t5_.postecategory_id AS postecategory_id_101, t5_.articlecategory_id AS articlecategory_id_102, t5_.thematicfilecategory_id AS thematicfilecategory_id_103, t5_.roomtype_id AS roomtype_id_104, t5_.tab_id AS tab_id_105 FROM tv_pages t0_ LEFT JOIN tv_layouts t1_ ON t0_.layout_id = t1_.id INNER JOIN tv_templates t2_ ON t0_.template_id = t2_.id LEFT JOIN tv_medias_relations t3_ ON t0_.id = t3_.page_id LEFT JOIN tv_seo t4_ ON t0_.id = t4_.page_id LEFT JOIN tv_medias_relations t5_ ON t4_.id = t5_.seo_id WHERE t0_.page_code = ? AND t0_.site_id = ?
Parameters: [
"robots.txt"
1
]
SELECT
t0_.id AS id_0,
t0_.position AS position_1,
t0_.created AS created_2,
t0_.updated AS updated_3,
t0_.page_name AS page_name_4,
t0_.page_name_back AS page_name_back_5,
t0_.page_code AS page_code_6,
t0_.page_is_default AS page_is_default_7,
t0_.page_level AS page_level_8,
t0_.online AS online_9,
t0_.page_plan AS page_plan_10,
t0_.page_arbo AS page_arbo_11,
t0_.subsite AS subsite_12,
t1_.id AS id_13,
t1_.position AS position_14,
t1_.created AS created_15,
t1_.updated AS updated_16,
t1_.layout_name AS layout_name_17,
t1_.layout_code AS layout_code_18,
t2_.id AS id_19,
t2_.position AS position_20,
t2_.created AS created_21,
t2_.updated AS updated_22,
t2_.template_name AS template_name_23,
t2_.template_code AS template_code_24,
t2_.template_width AS template_width_25,
t2_.template_padding AS template_padding_26,
t2_.template_is_active AS template_is_active_27,
t3_.id AS id_28,
t3_.media_index AS media_index_29,
t3_.media_description AS media_description_30,
t3_.media_zoom AS media_zoom_31,
t3_.position AS position_32,
t4_.id AS id_33,
t4_.position AS position_34,
t4_.created AS created_35,
t4_.updated AS updated_36,
t4_.meta_title AS meta_title_37,
t4_.meta_description AS meta_description_38,
t4_.meta_canonical AS meta_canonical_39,
t4_.meta_index AS meta_index_40,
t4_.meta_follow AS meta_follow_41,
t4_.meta_og_title AS meta_og_title_42,
t4_.meta_og_description AS meta_og_description_43,
t5_.id AS id_44,
t5_.media_index AS media_index_45,
t5_.media_description AS media_description_46,
t5_.media_zoom AS media_zoom_47,
t5_.position AS position_48,
t0_.layout_id AS layout_id_49,
t0_.site_id AS site_id_50,
t0_.template_id AS template_id_51,
t0_.parent_id AS parent_id_52,
t0_.article_categorie_id AS article_categorie_id_53,
t0_.thematic_categorie_id AS thematic_categorie_id_54,
t3_.block_id AS block_id_55,
t3_.page_id AS page_id_56,
t3_.seo_id AS seo_id_57,
t3_.analytic_id AS analytic_id_58,
t3_.banner_id AS banner_id_59,
t3_.article_id AS article_id_60,
t3_.slide_id AS slide_id_61,
t3_.carouselItem_id AS carouselItem_id_62,
t3_.textandimage_id AS textandimage_id_63,
t3_.icone_id AS icone_id_64,
t3_.link_id AS link_id_65,
t3_.media_id AS media_id_66,
t3_.categorydescription_id AS categorydescription_id_67,
t3_.etabdescription_id AS etabdescription_id_68,
t3_.etab_gallery_id AS etab_gallery_id_69,
t3_.liste_id AS liste_id_70,
t3_.pension_id AS pension_id_71,
t3_.promo_id AS promo_id_72,
t3_.roomfeature_id AS roomfeature_id_73,
t3_.roomfeaturevalue_id AS roomfeaturevalue_id_74,
t3_.postecategory_id AS postecategory_id_75,
t3_.articlecategory_id AS articlecategory_id_76,
t3_.thematicfilecategory_id AS thematicfilecategory_id_77,
t3_.roomtype_id AS roomtype_id_78,
t3_.tab_id AS tab_id_79,
t4_.page_id AS page_id_80,
t5_.block_id AS block_id_81,
t5_.page_id AS page_id_82,
t5_.seo_id AS seo_id_83,
t5_.analytic_id AS analytic_id_84,
t5_.banner_id AS banner_id_85,
t5_.article_id AS article_id_86,
t5_.slide_id AS slide_id_87,
t5_.carouselItem_id AS carouselItem_id_88,
t5_.textandimage_id AS textandimage_id_89,
t5_.icone_id AS icone_id_90,
t5_.link_id AS link_id_91,
t5_.media_id AS media_id_92,
t5_.categorydescription_id AS categorydescription_id_93,
t5_.etabdescription_id AS etabdescription_id_94,
t5_.etab_gallery_id AS etab_gallery_id_95,
t5_.liste_id AS liste_id_96,
t5_.pension_id AS pension_id_97,
t5_.promo_id AS promo_id_98,
t5_.roomfeature_id AS roomfeature_id_99,
t5_.roomfeaturevalue_id AS roomfeaturevalue_id_100,
t5_.postecategory_id AS postecategory_id_101,
t5_.articlecategory_id AS articlecategory_id_102,
t5_.thematicfilecategory_id AS thematicfilecategory_id_103,
t5_.roomtype_id AS roomtype_id_104,
t5_.tab_id AS tab_id_105
FROM
tv_pages t0_
LEFT JOIN tv_layouts t1_ ON t0_.layout_id = t1_.id
INNER JOIN tv_templates t2_ ON t0_.template_id = t2_.id
LEFT JOIN tv_medias_relations t3_ ON t0_.id = t3_.page_id
LEFT JOIN tv_seo t4_ ON t0_.id = t4_.page_id
LEFT JOIN tv_medias_relations t5_ ON t4_.id = t5_.seo_id
WHERE
t0_.page_code = ?
AND t0_.site_id = ?
SELECT t0_.id AS id_0, t0_.position AS position_1, t0_.created AS created_2, t0_.updated AS updated_3, t0_.page_name AS page_name_4, t0_.page_name_back AS page_name_back_5, t0_.page_code AS page_code_6, t0_.page_is_default AS page_is_default_7, t0_.page_level AS page_level_8, t0_.online AS online_9, t0_.page_plan AS page_plan_10, t0_.page_arbo AS page_arbo_11, t0_.subsite AS subsite_12, t1_.id AS id_13, t1_.position AS position_14, t1_.created AS created_15, t1_.updated AS updated_16, t1_.layout_name AS layout_name_17, t1_.layout_code AS layout_code_18, t2_.id AS id_19, t2_.position AS position_20, t2_.created AS created_21, t2_.updated AS updated_22, t2_.template_name AS template_name_23, t2_.template_code AS template_code_24, t2_.template_width AS template_width_25, t2_.template_padding AS template_padding_26, t2_.template_is_active AS template_is_active_27, t3_.id AS id_28, t3_.media_index AS media_index_29, t3_.media_description AS media_description_30, t3_.media_zoom AS media_zoom_31, t3_.position AS position_32, t4_.id AS id_33, t4_.position AS position_34, t4_.created AS created_35, t4_.updated AS updated_36, t4_.meta_title AS meta_title_37, t4_.meta_description AS meta_description_38, t4_.meta_canonical AS meta_canonical_39, t4_.meta_index AS meta_index_40, t4_.meta_follow AS meta_follow_41, t4_.meta_og_title AS meta_og_title_42, t4_.meta_og_description AS meta_og_description_43, t5_.id AS id_44, t5_.media_index AS media_index_45, t5_.media_description AS media_description_46, t5_.media_zoom AS media_zoom_47, t5_.position AS position_48, t0_.layout_id AS layout_id_49, t0_.site_id AS site_id_50, t0_.template_id AS template_id_51, t0_.parent_id AS parent_id_52, t0_.article_categorie_id AS article_categorie_id_53, t0_.thematic_categorie_id AS thematic_categorie_id_54, t3_.block_id AS block_id_55, t3_.page_id AS page_id_56, t3_.seo_id AS seo_id_57, t3_.analytic_id AS analytic_id_58, t3_.banner_id AS banner_id_59, t3_.article_id AS article_id_60, t3_.slide_id AS slide_id_61, t3_.carouselItem_id AS carouselItem_id_62, t3_.textandimage_id AS textandimage_id_63, t3_.icone_id AS icone_id_64, t3_.link_id AS link_id_65, t3_.media_id AS media_id_66, t3_.categorydescription_id AS categorydescription_id_67, t3_.etabdescription_id AS etabdescription_id_68, t3_.etab_gallery_id AS etab_gallery_id_69, t3_.liste_id AS liste_id_70, t3_.pension_id AS pension_id_71, t3_.promo_id AS promo_id_72, t3_.roomfeature_id AS roomfeature_id_73, t3_.roomfeaturevalue_id AS roomfeaturevalue_id_74, t3_.postecategory_id AS postecategory_id_75, t3_.articlecategory_id AS articlecategory_id_76, t3_.thematicfilecategory_id AS thematicfilecategory_id_77, t3_.roomtype_id AS roomtype_id_78, t3_.tab_id AS tab_id_79, t4_.page_id AS page_id_80, t5_.block_id AS block_id_81, t5_.page_id AS page_id_82, t5_.seo_id AS seo_id_83, t5_.analytic_id AS analytic_id_84, t5_.banner_id AS banner_id_85, t5_.article_id AS article_id_86, t5_.slide_id AS slide_id_87, t5_.carouselItem_id AS carouselItem_id_88, t5_.textandimage_id AS textandimage_id_89, t5_.icone_id AS icone_id_90, t5_.link_id AS link_id_91, t5_.media_id AS media_id_92, t5_.categorydescription_id AS categorydescription_id_93, t5_.etabdescription_id AS etabdescription_id_94, t5_.etab_gallery_id AS etab_gallery_id_95, t5_.liste_id AS liste_id_96, t5_.pension_id AS pension_id_97, t5_.promo_id AS promo_id_98, t5_.roomfeature_id AS roomfeature_id_99, t5_.roomfeaturevalue_id AS roomfeaturevalue_id_100, t5_.postecategory_id AS postecategory_id_101, t5_.articlecategory_id AS articlecategory_id_102, t5_.thematicfilecategory_id AS thematicfilecategory_id_103, t5_.roomtype_id AS roomtype_id_104, t5_.tab_id AS tab_id_105 FROM tv_pages t0_ LEFT JOIN tv_layouts t1_ ON t0_.layout_id = t1_.id INNER JOIN tv_templates t2_ ON t0_.template_id = t2_.id LEFT JOIN tv_medias_relations t3_ ON t0_.id = t3_.page_id LEFT JOIN tv_seo t4_ ON t0_.id = t4_.page_id LEFT JOIN tv_medias_relations t5_ ON t4_.id = t5_.seo_id WHERE t0_.page_code = 'robots.txt' AND t0_.site_id = 1;
|