0.15 ms (8.75%)
|
1 |
SELECT t0.id AS id_1, t0.redirection_type AS redirection_type_2, t0.redirection_video AS redirection_video_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.position AS position_6, t0.format AS format_7, t0.background_class AS background_class_8, t0.page_id AS page_id_9, t0.title_id AS title_id_10, t0.redirection_link_id AS redirection_link_id_11, t0.redirection_page_id AS redirection_page_id_12, t13.id AS id_14, t13.created_at AS created_at_15, t13.updated_at AS updated_at_16, t13.enabled AS enabled_17, t13.publication_start_date AS publication_start_date_18, t13.publication_end_date AS publication_end_date_19, t13.is_nav_back_button_enabled AS is_nav_back_button_enabled_20, t13.title_id AS title_id_21, t13.slug_id AS slug_id_22, t13.template_id AS template_id_23, t13.internal_template_id AS internal_template_id_24, t13.article_template_id AS article_template_id_25, t13.list_articles_template_id AS list_articles_template_id_26, t13.switch_home_template_id AS switch_home_template_id_27, t13.switch_home_location_template_id AS switch_home_location_template_id_28, t13.seo_id AS seo_id_29, t13.contact_template_id AS contact_template_id_30, t13.sitemap_template_id AS sitemap_template_id_31, t13.landing_template_id AS landing_template_id_32, t13.nav_back_button_title_id AS nav_back_button_title_id_33, t13.nav_back_button_page_id AS nav_back_button_page_id_34, t13.parent_id AS parent_id_35, t0.nav_id AS nav_id_36, t0.sub_nav_id AS sub_nav_id_37 FROM nav_link t0 LEFT JOIN page t13 ON t0.redirection_page_id = t13.id WHERE t0.nav_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.redirection_type AS redirection_type_2, t0.redirection_video AS redirection_video_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.position AS position_6, t0.format AS format_7, t0.background_class AS background_class_8, t0.page_id AS page_id_9, t0.title_id AS title_id_10, t0.redirection_link_id AS redirection_link_id_11, t0.redirection_page_id AS redirection_page_id_12, t13.id AS id_14, t13.created_at AS created_at_15, t13.updated_at AS updated_at_16, t13.enabled AS enabled_17, t13.publication_start_date AS publication_start_date_18, t13.publication_end_date AS publication_end_date_19, t13.is_nav_back_button_enabled AS is_nav_back_button_enabled_20, t13.title_id AS title_id_21, t13.slug_id AS slug_id_22, t13.template_id AS template_id_23, t13.internal_template_id AS internal_template_id_24, t13.article_template_id AS article_template_id_25, t13.list_articles_template_id AS list_articles_template_id_26, t13.switch_home_template_id AS switch_home_template_id_27, t13.switch_home_location_template_id AS switch_home_location_template_id_28, t13.seo_id AS seo_id_29, t13.contact_template_id AS contact_template_id_30, t13.sitemap_template_id AS sitemap_template_id_31, t13.landing_template_id AS landing_template_id_32, t13.nav_back_button_title_id AS nav_back_button_title_id_33, t13.nav_back_button_page_id AS nav_back_button_page_id_34, t13.parent_id AS parent_id_35, t0.nav_id AS nav_id_36, t0.sub_nav_id AS sub_nav_id_37 FROM nav_link t0 LEFT JOIN page t13 ON t0.redirection_page_id = t13.id WHERE t0.nav_id = 2 ORDER BY t0.position ASC;
|
0.11 ms (6.29%)
|
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.enabled AS enabled_4, t0.publication_start_date AS publication_start_date_5, t0.publication_end_date AS publication_end_date_6, t0.is_nav_back_button_enabled AS is_nav_back_button_enabled_7, t0.title_id AS title_id_8, t0.slug_id AS slug_id_9, t0.template_id AS template_id_10, t0.internal_template_id AS internal_template_id_11, t0.article_template_id AS article_template_id_12, t0.list_articles_template_id AS list_articles_template_id_13, t0.switch_home_template_id AS switch_home_template_id_14, t0.switch_home_location_template_id AS switch_home_location_template_id_15, t0.seo_id AS seo_id_16, t0.contact_template_id AS contact_template_id_17, t0.sitemap_template_id AS sitemap_template_id_18, t0.landing_template_id AS landing_template_id_19, t0.nav_back_button_title_id AS nav_back_button_title_id_20, t0.nav_back_button_page_id AS nav_back_button_page_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.enabled AS enabled_26, t22.publication_start_date AS publication_start_date_27, t22.publication_end_date AS publication_end_date_28, t22.is_nav_back_button_enabled AS is_nav_back_button_enabled_29, t22.title_id AS title_id_30, t22.slug_id AS slug_id_31, t22.template_id AS template_id_32, t22.internal_template_id AS internal_template_id_33, t22.article_template_id AS article_template_id_34, t22.list_articles_template_id AS list_articles_template_id_35, t22.switch_home_template_id AS switch_home_template_id_36, t22.switch_home_location_template_id AS switch_home_location_template_id_37, t22.seo_id AS seo_id_38, t22.contact_template_id AS contact_template_id_39, t22.sitemap_template_id AS sitemap_template_id_40, t22.landing_template_id AS landing_template_id_41, t22.nav_back_button_title_id AS nav_back_button_title_id_42, t22.nav_back_button_page_id AS nav_back_button_page_id_43, t22.parent_id AS parent_id_44, t0.parent_id AS parent_id_45 FROM page t0 LEFT JOIN page t22 ON t0.nav_back_button_page_id = t22.id WHERE t0.parent_id IN (?)
SELECT
t0.id AS id_1,
t0.created_at AS created_at_2,
t0.updated_at AS updated_at_3,
t0.enabled AS enabled_4,
t0.publication_start_date AS publication_start_date_5,
t0.publication_end_date AS publication_end_date_6,
t0.is_nav_back_button_enabled AS is_nav_back_button_enabled_7,
t0.title_id AS title_id_8,
t0.slug_id AS slug_id_9,
t0.template_id AS template_id_10,
t0.internal_template_id AS internal_template_id_11,
t0.article_template_id AS article_template_id_12,
t0.list_articles_template_id AS list_articles_template_id_13,
t0.switch_home_template_id AS switch_home_template_id_14,
t0.switch_home_location_template_id AS switch_home_location_template_id_15,
t0.seo_id AS seo_id_16,
t0.contact_template_id AS contact_template_id_17,
t0.sitemap_template_id AS sitemap_template_id_18,
t0.landing_template_id AS landing_template_id_19,
t0.nav_back_button_title_id AS nav_back_button_title_id_20,
t0.nav_back_button_page_id AS nav_back_button_page_id_21,
t22.id AS id_23,
t22.created_at AS created_at_24,
t22.updated_at AS updated_at_25,
t22.enabled AS enabled_26,
t22.publication_start_date AS publication_start_date_27,
t22.publication_end_date AS publication_end_date_28,
t22.is_nav_back_button_enabled AS is_nav_back_button_enabled_29,
t22.title_id AS title_id_30,
t22.slug_id AS slug_id_31,
t22.template_id AS template_id_32,
t22.internal_template_id AS internal_template_id_33,
t22.article_template_id AS article_template_id_34,
t22.list_articles_template_id AS list_articles_template_id_35,
t22.switch_home_template_id AS switch_home_template_id_36,
t22.switch_home_location_template_id AS switch_home_location_template_id_37,
t22.seo_id AS seo_id_38,
t22.contact_template_id AS contact_template_id_39,
t22.sitemap_template_id AS sitemap_template_id_40,
t22.landing_template_id AS landing_template_id_41,
t22.nav_back_button_title_id AS nav_back_button_title_id_42,
t22.nav_back_button_page_id AS nav_back_button_page_id_43,
t22.parent_id AS parent_id_44,
t0.parent_id AS parent_id_45
FROM
page t0
LEFT JOIN page t22 ON t0.nav_back_button_page_id = t22.id
WHERE
t0.parent_id IN (?)
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.enabled AS enabled_4, t0.publication_start_date AS publication_start_date_5, t0.publication_end_date AS publication_end_date_6, t0.is_nav_back_button_enabled AS is_nav_back_button_enabled_7, t0.title_id AS title_id_8, t0.slug_id AS slug_id_9, t0.template_id AS template_id_10, t0.internal_template_id AS internal_template_id_11, t0.article_template_id AS article_template_id_12, t0.list_articles_template_id AS list_articles_template_id_13, t0.switch_home_template_id AS switch_home_template_id_14, t0.switch_home_location_template_id AS switch_home_location_template_id_15, t0.seo_id AS seo_id_16, t0.contact_template_id AS contact_template_id_17, t0.sitemap_template_id AS sitemap_template_id_18, t0.landing_template_id AS landing_template_id_19, t0.nav_back_button_title_id AS nav_back_button_title_id_20, t0.nav_back_button_page_id AS nav_back_button_page_id_21, t22.id AS id_23, t22.created_at AS created_at_24, t22.updated_at AS updated_at_25, t22.enabled AS enabled_26, t22.publication_start_date AS publication_start_date_27, t22.publication_end_date AS publication_end_date_28, t22.is_nav_back_button_enabled AS is_nav_back_button_enabled_29, t22.title_id AS title_id_30, t22.slug_id AS slug_id_31, t22.template_id AS template_id_32, t22.internal_template_id AS internal_template_id_33, t22.article_template_id AS article_template_id_34, t22.list_articles_template_id AS list_articles_template_id_35, t22.switch_home_template_id AS switch_home_template_id_36, t22.switch_home_location_template_id AS switch_home_location_template_id_37, t22.seo_id AS seo_id_38, t22.contact_template_id AS contact_template_id_39, t22.sitemap_template_id AS sitemap_template_id_40, t22.landing_template_id AS landing_template_id_41, t22.nav_back_button_title_id AS nav_back_button_title_id_42, t22.nav_back_button_page_id AS nav_back_button_page_id_43, t22.parent_id AS parent_id_44, t0.parent_id AS parent_id_45 FROM page t0 LEFT JOIN page t22 ON t0.nav_back_button_page_id = t22.id WHERE t0.parent_id IN (16);
|