Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.type AS type_1,
  m0_.external_link AS external_link_2,
  m0_.name AS name_3,
  m0_.alias AS alias_4,
  m0_.route AS route_5,
  m0_.description AS description_6,
  m0_.priority AS priority_7,
  m0_.is_active AS is_active_8,
  m0_.image AS image_9,
  m0_.lft AS lft_10,
  m0_.lvl AS lvl_11,
  m0_.rgt AS rgt_12,
  m0_.created_at AS created_at_13,
  m0_.updated_at AS updated_at_14,
  m0_.parent_id AS parent_id_15,
  m0_.template_id AS template_id_16,
  m0_.layout_template_id AS layout_template_id_17,
  m0_.root_id AS root_id_18
FROM
  MLDev_Page m0_
WHERE
  m0_.parent_id IS NULL
ORDER BY
  m0_.lft ASC

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.external_link AS external_link_2, m0_.name AS name_3, m0_.alias AS alias_4, m0_.route AS route_5, m0_.description AS description_6, m0_.priority AS priority_7, m0_.is_active AS is_active_8, m0_.image AS image_9, m0_.lft AS lft_10, m0_.lvl AS lvl_11, m0_.rgt AS rgt_12, m0_.created_at AS created_at_13, m0_.updated_at AS updated_at_14, m0_.parent_id AS parent_id_15, m0_.template_id AS template_id_16, m0_.layout_template_id AS layout_template_id_17, m0_.root_id AS root_id_18 FROM MLDev_Page m0_ WHERE m0_.parent_id IS NULL ORDER BY m0_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.content AS content_4,
  t0.robots AS robots_5,
  t0.isActive AS isActive_6,
  t0.isDefault AS isDefault_7
FROM
  MLDev_SeoSite t0
WHERE
  t0.isActive = ?
  AND t0.isDefault = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.robots AS robots_5, t0.isActive AS isActive_6, t0.isDefault AS isDefault_7 FROM MLDev_SeoSite t0 WHERE t0.isActive = 1 AND t0.isDefault = 1 LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.type AS type_1,
  m0_.external_link AS external_link_2,
  m0_.name AS name_3,
  m0_.alias AS alias_4,
  m0_.route AS route_5,
  m0_.description AS description_6,
  m0_.priority AS priority_7,
  m0_.is_active AS is_active_8,
  m0_.image AS image_9,
  m0_.lft AS lft_10,
  m0_.lvl AS lvl_11,
  m0_.rgt AS rgt_12,
  m0_.created_at AS created_at_13,
  m0_.updated_at AS updated_at_14,
  m0_.parent_id AS parent_id_15,
  m0_.template_id AS template_id_16,
  m0_.layout_template_id AS layout_template_id_17,
  m0_.root_id AS root_id_18
FROM
  MLDev_Page m0_
WHERE
  (
    m0_.route = ?
    OR m0_.route = ?
  )
  AND m0_.is_active = 1
ORDER BY
  m0_.lft ASC,
  m0_.priority ASC

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.external_link AS external_link_2, m0_.name AS name_3, m0_.alias AS alias_4, m0_.route AS route_5, m0_.description AS description_6, m0_.priority AS priority_7, m0_.is_active AS is_active_8, m0_.image AS image_9, m0_.lft AS lft_10, m0_.lvl AS lvl_11, m0_.rgt AS rgt_12, m0_.created_at AS created_at_13, m0_.updated_at AS updated_at_14, m0_.parent_id AS parent_id_15, m0_.template_id AS template_id_16, m0_.layout_template_id AS layout_template_id_17, m0_.root_id AS root_id_18 FROM MLDev_Page m0_ WHERE (m0_.route = '/ru/katalog/taif/industrial-masla/belye-pishchevye' OR m0_.route = '/katalog/taif/industrial-masla/belye-pishchevye') AND m0_.is_active = 1 ORDER BY m0_.lft ASC, m0_.priority ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.is_layout AS is_layout_4
FROM
  MLDev_Page_Template t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.is_layout AS is_layout_4 FROM MLDev_Page_Template t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.is_layout AS is_layout_4
FROM
  MLDev_Page_Template t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.is_layout AS is_layout_4 FROM MLDev_Page_Template t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.priority AS priority_3,
  t0.is_active AS is_active_4,
  t0.widget AS widget_5,
  t0.options AS options_6,
  t0.page_id AS page_id_7
FROM
  MLDev_Page_Content t0
WHERE
  (
    t0.is_active = ?
    AND t0.page_id = ?
  )
ORDER BY
  t0.priority ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.priority AS priority_3, t0.is_active AS is_active_4, t0.widget AS widget_5, t0.options AS options_6, t0.page_id AS page_id_7 FROM MLDev_Page_Content t0 WHERE (t0.is_active = 1 AND t0.page_id = 73) ORDER BY t0.priority ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.external_link AS external_link_3,
  t0.name AS name_4,
  t0.alias AS alias_5,
  t0.route AS route_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.is_active AS is_active_9,
  t0.image AS image_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.parent_id AS parent_id_16,
  t0.template_id AS template_id_17,
  t0.layout_template_id AS layout_template_id_18,
  t0.root_id AS root_id_19
FROM
  MLDev_Page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.id = 67;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.external_link AS external_link_3,
  t0.name AS name_4,
  t0.alias AS alias_5,
  t0.route AS route_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.is_active AS is_active_9,
  t0.image AS image_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.parent_id AS parent_id_16,
  t0.template_id AS template_id_17,
  t0.layout_template_id AS layout_template_id_18,
  t0.root_id AS root_id_19
FROM
  MLDev_Page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.id = 20;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.external_link AS external_link_3,
  t0.name AS name_4,
  t0.alias AS alias_5,
  t0.route AS route_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.is_active AS is_active_9,
  t0.image AS image_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.parent_id AS parent_id_16,
  t0.template_id AS template_id_17,
  t0.layout_template_id AS layout_template_id_18,
  t0.root_id AS root_id_19
FROM
  MLDev_Page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.external_link AS external_link_3,
  t0.name AS name_4,
  t0.alias AS alias_5,
  t0.route AS route_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.is_active AS is_active_9,
  t0.image AS image_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.parent_id AS parent_id_16,
  t0.template_id AS template_id_17,
  t0.layout_template_id AS layout_template_id_18,
  t0.root_id AS root_id_19
FROM
  MLDev_Page t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.priority ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.parent_id = 73 ORDER BY t0.priority ASC, t0.id ASC;

SELECT
  m0_.id AS id_0,
  m0_.external_id AS external_id_1,
  m0_.name AS name_2,
  m0_.alterName AS alterName_3,
  m0_.sku AS sku_4,
  m0_.amount AS amount_5,
  m0_.is_active AS is_active_6,
  m0_.is_new AS is_new_7,
  m0_.is_sale AS is_sale_8,
  m0_.use_on_yandex_market AS use_on_yandex_market_9,
  m0_.available_image_list AS available_image_list_10,
  m1_.id AS id_11,
  m1_.external_id AS external_id_12,
  m1_.name AS name_13,
  m1_.alter_name AS alter_name_14,
  m1_.alias AS alias_15,
  m1_.unit AS unit_16,
  m1_.annotation AS annotation_17,
  m1_.description AS description_18,
  m1_.priority AS priority_19,
  m1_.is_active AS is_active_20,
  m1_.extra_fields AS extra_fields_21,
  m1_.created_at AS created_at_22,
  m1_.updated_at AS updated_at_23,
  m0_.product_id AS product_id_24,
  m0_.product_image_id AS product_image_id_25,
  m0_.color_id AS color_id_26,
  m1_.brand_id AS brand_id_27
FROM
  MLDev_Product_Item m0_
  INNER JOIN MLDev_Product m1_ ON m0_.product_id = m1_.id
  INNER JOIN MLDev_Product_Page m3_ ON m1_.id = m3_.product_id
  INNER JOIN MLDev_Page m2_ ON m2_.id = m3_.page_id
  LEFT JOIN MLDev_Product_Item_Price m4_ ON m0_.id = m4_.product_item_id
WHERE
  m2_.id IN (73)
  AND m1_.is_active = 1
  AND m0_.is_active = 1
ORDER BY
  m0_.amount DESC,
  m1_.priority DESC,
  m1_.id ASC

SELECT m0_.id AS id_0, m0_.external_id AS external_id_1, m0_.name AS name_2, m0_.alterName AS alterName_3, m0_.sku AS sku_4, m0_.amount AS amount_5, m0_.is_active AS is_active_6, m0_.is_new AS is_new_7, m0_.is_sale AS is_sale_8, m0_.use_on_yandex_market AS use_on_yandex_market_9, m0_.available_image_list AS available_image_list_10, m1_.id AS id_11, m1_.external_id AS external_id_12, m1_.name AS name_13, m1_.alter_name AS alter_name_14, m1_.alias AS alias_15, m1_.unit AS unit_16, m1_.annotation AS annotation_17, m1_.description AS description_18, m1_.priority AS priority_19, m1_.is_active AS is_active_20, m1_.extra_fields AS extra_fields_21, m1_.created_at AS created_at_22, m1_.updated_at AS updated_at_23, m0_.product_id AS product_id_24, m0_.product_image_id AS product_image_id_25, m0_.color_id AS color_id_26, m1_.brand_id AS brand_id_27 FROM MLDev_Product_Item m0_ INNER JOIN MLDev_Product m1_ ON m0_.product_id = m1_.id INNER JOIN MLDev_Product_Page m3_ ON m1_.id = m3_.product_id INNER JOIN MLDev_Page m2_ ON m2_.id = m3_.page_id LEFT JOIN MLDev_Product_Item_Price m4_ ON m0_.id = m4_.product_item_id WHERE m2_.id IN (73) AND m1_.is_active = 1 AND m0_.is_active = 1 ORDER BY m0_.amount DESC, m1_.priority DESC, m1_.id ASC;

SELECT
  MIN(m0_.value) AS sclr_0,
  MAX(m0_.value) AS sclr_1
FROM
  MLDev_Product_Item m1_
  INNER JOIN MLDev_Product m2_ ON m1_.product_id = m2_.id
  INNER JOIN MLDev_Product_Page m4_ ON m2_.id = m4_.product_id
  INNER JOIN MLDev_Page m3_ ON m3_.id = m4_.page_id
  LEFT JOIN MLDev_Product_Item_Price m0_ ON m1_.id = m0_.product_item_id
WHERE
  m3_.id IN (73)
  AND m2_.is_active = 1
  AND m1_.is_active = 1
ORDER BY
  m1_.amount DESC,
  m2_.priority DESC,
  m2_.id ASC

SELECT MIN(m0_.value) AS sclr_0, MAX(m0_.value) AS sclr_1 FROM MLDev_Product_Item m1_ INNER JOIN MLDev_Product m2_ ON m1_.product_id = m2_.id INNER JOIN MLDev_Product_Page m4_ ON m2_.id = m4_.product_id INNER JOIN MLDev_Page m3_ ON m3_.id = m4_.page_id LEFT JOIN MLDev_Product_Item_Price m0_ ON m1_.id = m0_.product_item_id WHERE m3_.id IN (73) AND m2_.is_active = 1 AND m1_.is_active = 1 ORDER BY m1_.amount DESC, m2_.priority DESC, m2_.id ASC;

SELECT
  COUNT(*)
FROM
  MLDev_Product_Image t0
WHERE
  t0.product_id = ?

SELECT COUNT(*) FROM MLDev_Product_Image t0 WHERE t0.product_id = 267;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.path AS path_3,
  t0.uri AS uri_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.product_id AS product_id_7
FROM
  MLDev_Product_Image t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.uri AS uri_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM MLDev_Product_Image t0 WHERE t0.product_id = 267;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.keywords AS keywords_3,
  t0.description AS description_4,
  t0.is_default AS is_default_5,
  t0.seo_site_id AS seo_site_id_6
FROM
  MLDev_SeoInfo t0
  INNER JOIN MLDev_Page_SeoInfo ON t0.id = MLDev_Page_SeoInfo.seo_info_id
WHERE
  MLDev_Page_SeoInfo.page_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.is_default AS is_default_5, t0.seo_site_id AS seo_site_id_6 FROM MLDev_SeoInfo t0 INNER JOIN MLDev_Page_SeoInfo ON t0.id = MLDev_Page_SeoInfo.seo_info_id WHERE MLDev_Page_SeoInfo.page_id = 73;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.content AS content_4,
  t0.is_active AS is_active_5
FROM
  MLDev_Block t0
WHERE
  t0.alias = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.is_active AS is_active_5 FROM MLDev_Block t0 WHERE t0.alias = 'header-contacts' AND t0.is_active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3
FROM
  MLDev_Menu t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM MLDev_Menu t0 WHERE t0.alias = 'default' LIMIT 1;

SELECT
  te.id AS id,
  te.type AS type,
  te.external_link AS external_link,
  te.name AS name,
  te.alias AS alias,
  te.route AS route,
  te.description AS description,
  te.priority AS priority,
  te.is_active AS is_active,
  te.image AS image,
  te.lft AS lft,
  te.lvl AS lvl,
  te.rgt AS rgt,
  te.created_at AS created_at,
  te.updated_at AS updated_at,
  te.parent_id AS parent_id,
  te.template_id AS template_id,
  te.layout_template_id AS layout_template_id,
  te.root_id AS root_id
FROM
  MLDev_Page te
  JOIN MLDev_Menu_Page t ON t.page_id = te.id
WHERE
  t.menu_id = ?
  AND te.is_active = ?
ORDER BY
  priority ASC

SELECT te.id AS id, te.type AS type, te.external_link AS external_link, te.name AS name, te.alias AS alias, te.route AS route, te.description AS description, te.priority AS priority, te.is_active AS is_active, te.image AS image, te.lft AS lft, te.lvl AS lvl, te.rgt AS rgt, te.created_at AS created_at, te.updated_at AS updated_at, te.parent_id AS parent_id, te.template_id AS template_id, te.layout_template_id AS layout_template_id, te.root_id AS root_id FROM MLDev_Page te JOIN MLDev_Menu_Page t ON t.page_id = te.id WHERE t.menu_id = 1 AND te.is_active = 1 ORDER BY priority ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3
FROM
  MLDev_Menu t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM MLDev_Menu t0 WHERE t0.alias = 'footer-1' LIMIT 1;

SELECT
  te.id AS id,
  te.type AS type,
  te.external_link AS external_link,
  te.name AS name,
  te.alias AS alias,
  te.route AS route,
  te.description AS description,
  te.priority AS priority,
  te.is_active AS is_active,
  te.image AS image,
  te.lft AS lft,
  te.lvl AS lvl,
  te.rgt AS rgt,
  te.created_at AS created_at,
  te.updated_at AS updated_at,
  te.parent_id AS parent_id,
  te.template_id AS template_id,
  te.layout_template_id AS layout_template_id,
  te.root_id AS root_id
FROM
  MLDev_Page te
  JOIN MLDev_Menu_Page t ON t.page_id = te.id
WHERE
  t.menu_id = ?
  AND te.is_active = ?
ORDER BY
  priority ASC

SELECT te.id AS id, te.type AS type, te.external_link AS external_link, te.name AS name, te.alias AS alias, te.route AS route, te.description AS description, te.priority AS priority, te.is_active AS is_active, te.image AS image, te.lft AS lft, te.lvl AS lvl, te.rgt AS rgt, te.created_at AS created_at, te.updated_at AS updated_at, te.parent_id AS parent_id, te.template_id AS template_id, te.layout_template_id AS layout_template_id, te.root_id AS root_id FROM MLDev_Page te JOIN MLDev_Menu_Page t ON t.page_id = te.id WHERE t.menu_id = 2 AND te.is_active = 1 ORDER BY priority ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.external_link AS external_link_3,
  t0.name AS name_4,
  t0.alias AS alias_5,
  t0.route AS route_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.is_active AS is_active_9,
  t0.image AS image_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.parent_id AS parent_id_16,
  t0.template_id AS template_id_17,
  t0.layout_template_id AS layout_template_id_18,
  t0.root_id AS root_id_19
FROM
  MLDev_Page t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.priority ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.parent_id = 3 ORDER BY t0.priority ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3
FROM
  MLDev_Menu t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM MLDev_Menu t0 WHERE t0.alias = 'footer-2' LIMIT 1;

SELECT
  te.id AS id,
  te.type AS type,
  te.external_link AS external_link,
  te.name AS name,
  te.alias AS alias,
  te.route AS route,
  te.description AS description,
  te.priority AS priority,
  te.is_active AS is_active,
  te.image AS image,
  te.lft AS lft,
  te.lvl AS lvl,
  te.rgt AS rgt,
  te.created_at AS created_at,
  te.updated_at AS updated_at,
  te.parent_id AS parent_id,
  te.template_id AS template_id,
  te.layout_template_id AS layout_template_id,
  te.root_id AS root_id
FROM
  MLDev_Page te
  JOIN MLDev_Menu_Page t ON t.page_id = te.id
WHERE
  t.menu_id = ?
  AND te.is_active = ?
ORDER BY
  priority ASC

SELECT te.id AS id, te.type AS type, te.external_link AS external_link, te.name AS name, te.alias AS alias, te.route AS route, te.description AS description, te.priority AS priority, te.is_active AS is_active, te.image AS image, te.lft AS lft, te.lvl AS lvl, te.rgt AS rgt, te.created_at AS created_at, te.updated_at AS updated_at, te.parent_id AS parent_id, te.template_id AS template_id, te.layout_template_id AS layout_template_id, te.root_id AS root_id FROM MLDev_Page te JOIN MLDev_Menu_Page t ON t.page_id = te.id WHERE t.menu_id = 3 AND te.is_active = 1 ORDER BY priority ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.external_link AS external_link_3,
  t0.name AS name_4,
  t0.alias AS alias_5,
  t0.route AS route_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.is_active AS is_active_9,
  t0.image AS image_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.parent_id AS parent_id_16,
  t0.template_id AS template_id_17,
  t0.layout_template_id AS layout_template_id_18,
  t0.root_id AS root_id_19
FROM
  MLDev_Page t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.priority ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.parent_id = 23 ORDER BY t0.priority ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.external_link AS external_link_3,
  t0.name AS name_4,
  t0.alias AS alias_5,
  t0.route AS route_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.is_active AS is_active_9,
  t0.image AS image_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.parent_id AS parent_id_16,
  t0.template_id AS template_id_17,
  t0.layout_template_id AS layout_template_id_18,
  t0.root_id AS root_id_19
FROM
  MLDev_Page t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.priority ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.external_link AS external_link_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.description AS description_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.image AS image_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.parent_id AS parent_id_16, t0.template_id AS template_id_17, t0.layout_template_id AS layout_template_id_18, t0.root_id AS root_id_19 FROM MLDev_Page t0 WHERE t0.parent_id = 6 ORDER BY t0.priority ASC, t0.id ASC;