Symfony Profiler

SELECT
  t0.meta_title AS meta_title_1,
  t0.meta_description AS meta_description_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.type AS type_5,
  t0.title AS title_6,
  t0.fixed_header_title AS fixed_header_title_7,
  t0.body AS body_8,
  t0.lft AS lft_9,
  t0.lvl AS lvl_10,
  t0.rgt AS rgt_11,
  t0.symlink_variable_pattern AS symlink_variable_pattern_12,
  t0.show_in_menu AS show_in_menu_13,
  t0.alias AS alias_14,
  t0.deletable AS deletable_15,
  t0.class AS class_16,
  t0.body_class AS body_class_17,
  t0.breadcrumbs AS breadcrumbs_18,
  t0.controller AS controller_19,
  t0.feature AS feature_20,
  t0.icon_class AS icon_class_21,
  t0.hide_title AS hide_title_22,
  t0.robots AS robots_23,
  t0.concept AS concept_24,
  t0.target AS target_25,
  t0.parent_id AS parent_id_26,
  t0.symlink_id AS symlink_id_27,
  t0.mega_menu_item_id AS mega_menu_item_id_28,
  t0.hero_configuration_id AS hero_configuration_id_29,
  t0.connexys_page_configuration_id AS connexys_page_configuration_id_30
FROM
  page t0
WHERE
  t0.parent_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.lft ASC

SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.type AS type_5, t0.title AS title_6, t0.fixed_header_title AS fixed_header_title_7, t0.body AS body_8, t0.lft AS lft_9, t0.lvl AS lvl_10, t0.rgt AS rgt_11, t0.symlink_variable_pattern AS symlink_variable_pattern_12, t0.show_in_menu AS show_in_menu_13, t0.alias AS alias_14, t0.deletable AS deletable_15, t0.class AS class_16, t0.body_class AS body_class_17, t0.breadcrumbs AS breadcrumbs_18, t0.controller AS controller_19, t0.feature AS feature_20, t0.icon_class AS icon_class_21, t0.hide_title AS hide_title_22, t0.robots AS robots_23, t0.concept AS concept_24, t0.target AS target_25, t0.parent_id AS parent_id_26, t0.symlink_id AS symlink_id_27, t0.mega_menu_item_id AS mega_menu_item_id_28, t0.hero_configuration_id AS hero_configuration_id_29, t0.connexys_page_configuration_id AS connexys_page_configuration_id_30 FROM page t0 WHERE t0.parent_id = 67 AND ((t0.deleted_at IS NULL)) ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.`name` AS name_2,
  t0.defaults AS defaults_3,
  t0.staticPrefix AS staticPrefix_4,
  t0.variable_pattern AS variable_pattern_5,
  t0.requirements AS requirements_6,
  t0.options AS options_7,
  t0.host AS host_8,
  t0.schemes AS schemes_9,
  t0.`methods` AS methods_10,
  t0.`condition` AS condition_11,
  t0.locale AS locale_12,
  t0.page_id AS page_id_13
FROM
  route t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.`name` AS name_2, t0.defaults AS defaults_3, t0.staticPrefix AS staticPrefix_4, t0.variable_pattern AS variable_pattern_5, t0.requirements AS requirements_6, t0.options AS options_7, t0.host AS host_8, t0.schemes AS schemes_9, t0.`methods` AS methods_10, t0.`condition` AS condition_11, t0.locale AS locale_12, t0.page_id AS page_id_13 FROM route t0 WHERE t0.page_id = 123;

SELECT
  t0.meta_title AS meta_title_1,
  t0.meta_description AS meta_description_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.type AS type_5,
  t0.title AS title_6,
  t0.fixed_header_title AS fixed_header_title_7,
  t0.body AS body_8,
  t0.lft AS lft_9,
  t0.lvl AS lvl_10,
  t0.rgt AS rgt_11,
  t0.symlink_variable_pattern AS symlink_variable_pattern_12,
  t0.show_in_menu AS show_in_menu_13,
  t0.alias AS alias_14,
  t0.deletable AS deletable_15,
  t0.class AS class_16,
  t0.body_class AS body_class_17,
  t0.breadcrumbs AS breadcrumbs_18,
  t0.controller AS controller_19,
  t0.feature AS feature_20,
  t0.icon_class AS icon_class_21,
  t0.hide_title AS hide_title_22,
  t0.robots AS robots_23,
  t0.concept AS concept_24,
  t0.target AS target_25,
  t0.parent_id AS parent_id_26,
  t0.symlink_id AS symlink_id_27,
  t0.mega_menu_item_id AS mega_menu_item_id_28,
  t0.hero_configuration_id AS hero_configuration_id_29,
  t0.connexys_page_configuration_id AS connexys_page_configuration_id_30
FROM
  page t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.type AS type_5, t0.title AS title_6, t0.fixed_header_title AS fixed_header_title_7, t0.body AS body_8, t0.lft AS lft_9, t0.lvl AS lvl_10, t0.rgt AS rgt_11, t0.symlink_variable_pattern AS symlink_variable_pattern_12, t0.show_in_menu AS show_in_menu_13, t0.alias AS alias_14, t0.deletable AS deletable_15, t0.class AS class_16, t0.body_class AS body_class_17, t0.breadcrumbs AS breadcrumbs_18, t0.controller AS controller_19, t0.feature AS feature_20, t0.icon_class AS icon_class_21, t0.hide_title AS hide_title_22, t0.robots AS robots_23, t0.concept AS concept_24, t0.target AS target_25, t0.parent_id AS parent_id_26, t0.symlink_id AS symlink_id_27, t0.mega_menu_item_id AS mega_menu_item_id_28, t0.hero_configuration_id AS hero_configuration_id_29, t0.connexys_page_configuration_id AS connexys_page_configuration_id_30 FROM page t0 WHERE t0.id = 66 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.file_size AS file_size_3,
  t0.file_mime_type AS file_mime_type_4,
  t0.meta_information AS meta_information_5,
  t0.updated_at AS updated_at_6,
  t0.external_id AS external_id_7,
  t0.folder_id AS folder_id_8
FROM
  asset t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.file_mime_type AS file_mime_type_4, t0.meta_information AS meta_information_5, t0.updated_at AS updated_at_6, t0.external_id AS external_id_7, t0.folder_id AS folder_id_8 FROM asset t0 WHERE t0.id = 4;

SELECT
  t0.meta_title AS meta_title_1,
  t0.meta_description AS meta_description_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.type AS type_5,
  t0.title AS title_6,
  t0.fixed_header_title AS fixed_header_title_7,
  t0.body AS body_8,
  t0.lft AS lft_9,
  t0.lvl AS lvl_10,
  t0.rgt AS rgt_11,
  t0.symlink_variable_pattern AS symlink_variable_pattern_12,
  t0.show_in_menu AS show_in_menu_13,
  t0.alias AS alias_14,
  t0.deletable AS deletable_15,
  t0.class AS class_16,
  t0.body_class AS body_class_17,
  t0.breadcrumbs AS breadcrumbs_18,
  t0.controller AS controller_19,
  t0.feature AS feature_20,
  t0.icon_class AS icon_class_21,
  t0.hide_title AS hide_title_22,
  t0.robots AS robots_23,
  t0.concept AS concept_24,
  t0.target AS target_25,
  t0.parent_id AS parent_id_26,
  t0.symlink_id AS symlink_id_27,
  t0.mega_menu_item_id AS mega_menu_item_id_28,
  t0.hero_configuration_id AS hero_configuration_id_29,
  t0.connexys_page_configuration_id AS connexys_page_configuration_id_30
FROM
  page t0
WHERE
  t0.alias = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.type AS type_5, t0.title AS title_6, t0.fixed_header_title AS fixed_header_title_7, t0.body AS body_8, t0.lft AS lft_9, t0.lvl AS lvl_10, t0.rgt AS rgt_11, t0.symlink_variable_pattern AS symlink_variable_pattern_12, t0.show_in_menu AS show_in_menu_13, t0.alias AS alias_14, t0.deletable AS deletable_15, t0.class AS class_16, t0.body_class AS body_class_17, t0.breadcrumbs AS breadcrumbs_18, t0.controller AS controller_19, t0.feature AS feature_20, t0.icon_class AS icon_class_21, t0.hide_title AS hide_title_22, t0.robots AS robots_23, t0.concept AS concept_24, t0.target AS target_25, t0.parent_id AS parent_id_26, t0.symlink_id AS symlink_id_27, t0.mega_menu_item_id AS mega_menu_item_id_28, t0.hero_configuration_id AS hero_configuration_id_29, t0.connexys_page_configuration_id AS connexys_page_configuration_id_30 FROM page t0 WHERE t0.alias = 'header_navigation' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.intro AS intro_4,
  t0.has_home_matches AS has_home_matches_5,
  t0.description AS description_6,
  t0.practical_info AS practical_info_7,
  t0.city_info AS city_info_8,
  t0.deleted AS deleted_9,
  t0.meta_title AS meta_title_10,
  t0.meta_description AS meta_description_11,
  t0.logo_id AS logo_id_12,
  t0.country_id AS country_id_13,
  t0.hero_id AS hero_id_14,
  t0.content_hero_id AS content_hero_id_15,
  t0.stadium_id AS stadium_id_16
FROM
  club t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.intro AS intro_4, t0.has_home_matches AS has_home_matches_5, t0.description AS description_6, t0.practical_info AS practical_info_7, t0.city_info AS city_info_8, t0.deleted AS deleted_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.logo_id AS logo_id_12, t0.country_id AS country_id_13, t0.hero_id AS hero_id_14, t0.content_hero_id AS content_hero_id_15, t0.stadium_id AS stadium_id_16 FROM club t0 WHERE t0.id = 4 AND ((t0.deleted IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.place AS place_4,
  t0.address AS address_5,
  t0.pyton_place_id AS pyton_place_id_6,
  t0.description AS description_7,
  t0.city_description AS city_description_8,
  t0.centrum_longitude AS centrum_longitude_9,
  t0.centrumlatitude AS centrumlatitude_10,
  t0.country_id AS country_id_11
FROM
  stadium t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.place AS place_4, t0.address AS address_5, t0.pyton_place_id AS pyton_place_id_6, t0.description AS description_7, t0.city_description AS city_description_8, t0.centrum_longitude AS centrum_longitude_9, t0.centrumlatitude AS centrumlatitude_10, t0.country_id AS country_id_11 FROM stadium t0 WHERE t0.id = 6;

SELECT
  p0_.meta_title AS meta_title_0,
  p0_.meta_description AS meta_description_1,
  p0_.id AS id_2,
  p0_.deleted_at AS deleted_at_3,
  p0_.type AS type_4,
  p0_.title AS title_5,
  p0_.fixed_header_title AS fixed_header_title_6,
  p0_.body AS body_7,
  p0_.lft AS lft_8,
  p0_.lvl AS lvl_9,
  p0_.rgt AS rgt_10,
  p0_.symlink_variable_pattern AS symlink_variable_pattern_11,
  p0_.show_in_menu AS show_in_menu_12,
  p0_.alias AS alias_13,
  p0_.deletable AS deletable_14,
  p0_.class AS class_15,
  p0_.body_class AS body_class_16,
  p0_.breadcrumbs AS breadcrumbs_17,
  p0_.controller AS controller_18,
  p0_.feature AS feature_19,
  p0_.icon_class AS icon_class_20,
  p0_.hide_title AS hide_title_21,
  p0_.robots AS robots_22,
  p0_.concept AS concept_23,
  p0_.target AS target_24,
  r1_.id AS id_25,
  r1_.`name` AS name_26,
  r1_.defaults AS defaults_27,
  r1_.staticPrefix AS staticPrefix_28,
  r1_.variable_pattern AS variable_pattern_29,
  r1_.requirements AS requirements_30,
  r1_.options AS options_31,
  r1_.host AS host_32,
  r1_.schemes AS schemes_33,
  r1_.`methods` AS methods_34,
  r1_.`condition` AS condition_35,
  r1_.locale AS locale_36,
  p0_.parent_id AS parent_id_37,
  p0_.symlink_id AS symlink_id_38,
  p0_.mega_menu_item_id AS mega_menu_item_id_39,
  p0_.hero_configuration_id AS hero_configuration_id_40,
  p0_.connexys_page_configuration_id AS connexys_page_configuration_id_41,
  r1_.page_id AS page_id_42
FROM
  page p0_
  LEFT JOIN route r1_ ON p0_.id = r1_.page_id
WHERE
  (
    p0_.parent_id = ?
    AND p0_.show_in_menu = 1
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.lft ASC

SELECT p0_.meta_title AS meta_title_0, p0_.meta_description AS meta_description_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3, p0_.type AS type_4, p0_.title AS title_5, p0_.fixed_header_title AS fixed_header_title_6, p0_.body AS body_7, p0_.lft AS lft_8, p0_.lvl AS lvl_9, p0_.rgt AS rgt_10, p0_.symlink_variable_pattern AS symlink_variable_pattern_11, p0_.show_in_menu AS show_in_menu_12, p0_.alias AS alias_13, p0_.deletable AS deletable_14, p0_.class AS class_15, p0_.body_class AS body_class_16, p0_.breadcrumbs AS breadcrumbs_17, p0_.controller AS controller_18, p0_.feature AS feature_19, p0_.icon_class AS icon_class_20, p0_.hide_title AS hide_title_21, p0_.robots AS robots_22, p0_.concept AS concept_23, p0_.target AS target_24, r1_.id AS id_25, r1_.`name` AS name_26, r1_.defaults AS defaults_27, r1_.staticPrefix AS staticPrefix_28, r1_.variable_pattern AS variable_pattern_29, r1_.requirements AS requirements_30, r1_.options AS options_31, r1_.host AS host_32, r1_.schemes AS schemes_33, r1_.`methods` AS methods_34, r1_.`condition` AS condition_35, r1_.locale AS locale_36, p0_.parent_id AS parent_id_37, p0_.symlink_id AS symlink_id_38, p0_.mega_menu_item_id AS mega_menu_item_id_39, p0_.hero_configuration_id AS hero_configuration_id_40, p0_.connexys_page_configuration_id AS connexys_page_configuration_id_41, r1_.page_id AS page_id_42 FROM page p0_ LEFT JOIN route r1_ ON p0_.id = r1_.page_id WHERE (p0_.parent_id = 2 AND p0_.show_in_menu = 1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.location AS location_3,
  t0.script AS script_4,
  t0.type AS type_5
FROM
  google_tag_manager t0
WHERE
  t0.location = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.location AS location_3, t0.script AS script_4, t0.type AS type_5 FROM google_tag_manager t0 WHERE t0.location = 'heading_start';

SELECT
  t0.name AS name_1,
  t0.section AS section_2,
  t0.value AS value_3,
  t0.type AS type_4
FROM
  configuration_setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.section AS section_2, t0.value AS value_3, t0.type AS type_4 FROM configuration_setting t0 WHERE t0.name = 'site_open_graph_image' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.information AS information_3,
  t0.image_id AS image_id_4,
  t0.stadium_id AS stadium_id_5
FROM
  stadium_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.information AS information_3, t0.image_id AS image_id_4, t0.stadium_id AS stadium_id_5 FROM stadium_category t0 WHERE t0.id = 10;

SELECT
  f0_.name AS name_0,
  f0_.active AS active_1
FROM
  feature f0_

SELECT f0_.name AS name_0, f0_.active AS active_1 FROM feature f0_;

SELECT
  t0.id AS id_1,
  t0.`name` AS name_2,
  t0.defaults AS defaults_3,
  t0.staticPrefix AS staticPrefix_4,
  t0.variable_pattern AS variable_pattern_5,
  t0.requirements AS requirements_6,
  t0.options AS options_7,
  t0.host AS host_8,
  t0.schemes AS schemes_9,
  t0.`methods` AS methods_10,
  t0.`condition` AS condition_11,
  t0.locale AS locale_12,
  t0.page_id AS page_id_13
FROM
  route t0
WHERE
  t0.`name` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`name` AS name_2, t0.defaults AS defaults_3, t0.staticPrefix AS staticPrefix_4, t0.variable_pattern AS variable_pattern_5, t0.requirements AS requirements_6, t0.options AS options_7, t0.host AS host_8, t0.schemes AS schemes_9, t0.`methods` AS methods_10, t0.`condition` AS condition_11, t0.locale AS locale_12, t0.page_id AS page_id_13 FROM route t0 WHERE t0.`name` = 'checkout' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.airport_code AS airport_code_2,
  t0.airport_name AS airport_name_3,
  t0.airport_id AS airport_id_4,
  t0.airport_country_pretty_name AS airport_country_pretty_name_5,
  t0.airport_country_id AS airport_country_id_6,
  t0.airport_country_code AS airport_country_code_7,
  t0.airport_country_name AS airport_country_name_8,
  t0.synced AS synced_9,
  t0.indexable_departure AS indexable_departure_10,
  t0.indexable_arrival AS indexable_arrival_11,
  t0.default_arrival AS default_arrival_12
FROM
  airport t0
WHERE
  t0.airport_id IN (NULL)
ORDER BY
  t0.default_arrival DESC

SELECT t0.id AS id_1, t0.airport_code AS airport_code_2, t0.airport_name AS airport_name_3, t0.airport_id AS airport_id_4, t0.airport_country_pretty_name AS airport_country_pretty_name_5, t0.airport_country_id AS airport_country_id_6, t0.airport_country_code AS airport_country_code_7, t0.airport_country_name AS airport_country_name_8, t0.synced AS synced_9, t0.indexable_departure AS indexable_departure_10, t0.indexable_arrival AS indexable_arrival_11, t0.default_arrival AS default_arrival_12 FROM airport t0 WHERE t0.airport_id IN (NULL) ORDER BY t0.default_arrival DESC;

SELECT
  t0.id AS id_1,
  t0.airport_code AS airport_code_2,
  t0.airport_name AS airport_name_3,
  t0.airport_id AS airport_id_4,
  t0.airport_country_pretty_name AS airport_country_pretty_name_5,
  t0.airport_country_id AS airport_country_id_6,
  t0.airport_country_code AS airport_country_code_7,
  t0.airport_country_name AS airport_country_name_8,
  t0.synced AS synced_9,
  t0.indexable_departure AS indexable_departure_10,
  t0.indexable_arrival AS indexable_arrival_11,
  t0.default_arrival AS default_arrival_12
FROM
  airport t0
WHERE
  t0.indexable_departure = ?
ORDER BY
  t0.airport_country_code DESC,
  t0.airport_name ASC

SELECT t0.id AS id_1, t0.airport_code AS airport_code_2, t0.airport_name AS airport_name_3, t0.airport_id AS airport_id_4, t0.airport_country_pretty_name AS airport_country_pretty_name_5, t0.airport_country_id AS airport_country_id_6, t0.airport_country_code AS airport_country_code_7, t0.airport_country_name AS airport_country_name_8, t0.synced AS synced_9, t0.indexable_departure AS indexable_departure_10, t0.indexable_arrival AS indexable_arrival_11, t0.default_arrival AS default_arrival_12 FROM airport t0 WHERE t0.indexable_departure = 1 ORDER BY t0.airport_country_code DESC, t0.airport_name ASC;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.id AS id_1,
  t0.cheapest_accommodation AS cheapest_accommodation_2,
  t0.unavailable AS unavailable_3,
  t0.category_id AS category_id_4,
  t0.match_id AS match_id_5
FROM
  match_category t0
WHERE
  t0.match_id = ?

SELECT t0.id AS id_1, t0.cheapest_accommodation AS cheapest_accommodation_2, t0.unavailable AS unavailable_3, t0.category_id AS category_id_4, t0.match_id AS match_id_5 FROM match_category t0 WHERE t0.match_id = 112;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.default_time AS default_time_4,
  t0.description AS description_5,
  t0.meta_title AS meta_title_6,
  t0.meta_description AS meta_description_7,
  t0.country_id AS country_id_8,
  t0.logo_id AS logo_id_9
FROM
  competition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.default_time AS default_time_4, t0.description AS description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.country_id AS country_id_8, t0.logo_id AS logo_id_9 FROM competition t0 WHERE t0.id = 1;

SELECT
  p0_.meta_title AS meta_title_0,
  p0_.meta_description AS meta_description_1,
  p0_.id AS id_2,
  p0_.deleted_at AS deleted_at_3,
  p0_.type AS type_4,
  p0_.title AS title_5,
  p0_.fixed_header_title AS fixed_header_title_6,
  p0_.body AS body_7,
  p0_.lft AS lft_8,
  p0_.lvl AS lvl_9,
  p0_.rgt AS rgt_10,
  p0_.symlink_variable_pattern AS symlink_variable_pattern_11,
  p0_.show_in_menu AS show_in_menu_12,
  p0_.alias AS alias_13,
  p0_.deletable AS deletable_14,
  p0_.class AS class_15,
  p0_.body_class AS body_class_16,
  p0_.breadcrumbs AS breadcrumbs_17,
  p0_.controller AS controller_18,
  p0_.feature AS feature_19,
  p0_.icon_class AS icon_class_20,
  p0_.hide_title AS hide_title_21,
  p0_.robots AS robots_22,
  p0_.concept AS concept_23,
  p0_.target AS target_24,
  r1_.id AS id_25,
  r1_.`name` AS name_26,
  r1_.defaults AS defaults_27,
  r1_.staticPrefix AS staticPrefix_28,
  r1_.variable_pattern AS variable_pattern_29,
  r1_.requirements AS requirements_30,
  r1_.options AS options_31,
  r1_.host AS host_32,
  r1_.schemes AS schemes_33,
  r1_.`methods` AS methods_34,
  r1_.`condition` AS condition_35,
  r1_.locale AS locale_36,
  p0_.parent_id AS parent_id_37,
  p0_.symlink_id AS symlink_id_38,
  p0_.mega_menu_item_id AS mega_menu_item_id_39,
  p0_.hero_configuration_id AS hero_configuration_id_40,
  p0_.connexys_page_configuration_id AS connexys_page_configuration_id_41,
  r1_.page_id AS page_id_42
FROM
  page p0_
  LEFT JOIN route r1_ ON p0_.id = r1_.page_id
WHERE
  (
    p0_.rgt < 178
    AND p0_.lft > 119
    AND p0_.show_in_menu = 1
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.lft ASC

SELECT p0_.meta_title AS meta_title_0, p0_.meta_description AS meta_description_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3, p0_.type AS type_4, p0_.title AS title_5, p0_.fixed_header_title AS fixed_header_title_6, p0_.body AS body_7, p0_.lft AS lft_8, p0_.lvl AS lvl_9, p0_.rgt AS rgt_10, p0_.symlink_variable_pattern AS symlink_variable_pattern_11, p0_.show_in_menu AS show_in_menu_12, p0_.alias AS alias_13, p0_.deletable AS deletable_14, p0_.class AS class_15, p0_.body_class AS body_class_16, p0_.breadcrumbs AS breadcrumbs_17, p0_.controller AS controller_18, p0_.feature AS feature_19, p0_.icon_class AS icon_class_20, p0_.hide_title AS hide_title_21, p0_.robots AS robots_22, p0_.concept AS concept_23, p0_.target AS target_24, r1_.id AS id_25, r1_.`name` AS name_26, r1_.defaults AS defaults_27, r1_.staticPrefix AS staticPrefix_28, r1_.variable_pattern AS variable_pattern_29, r1_.requirements AS requirements_30, r1_.options AS options_31, r1_.host AS host_32, r1_.schemes AS schemes_33, r1_.`methods` AS methods_34, r1_.`condition` AS condition_35, r1_.locale AS locale_36, p0_.parent_id AS parent_id_37, p0_.symlink_id AS symlink_id_38, p0_.mega_menu_item_id AS mega_menu_item_id_39, p0_.hero_configuration_id AS hero_configuration_id_40, p0_.connexys_page_configuration_id AS connexys_page_configuration_id_41, r1_.page_id AS page_id_42 FROM page p0_ LEFT JOIN route r1_ ON p0_.id = r1_.page_id WHERE (p0_.rgt < 178 AND p0_.lft > 119 AND p0_.show_in_menu = 1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.body AS body_3,
  t0.slug AS slug_4,
  t0.multimedia_id AS multimedia_id_5
FROM
  site_block t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.slug AS slug_4, t0.multimedia_id AS multimedia_id_5 FROM site_block t0 WHERE t0.slug = 'match_pricedetails' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.cheapest_accommodation AS cheapest_accommodation_3,
  t0.match_ticket_price AS match_ticket_price_4,
  t0.match_ticket_price_base AS match_ticket_price_base_5,
  t0.final AS final_6,
  t0.offer AS offer_7,
  t0.popular AS popular_8,
  t0.has_flight AS has_flight_9,
  t0.disable_booking AS disable_booking_10,
  t0.first_of_month AS first_of_month_11,
  t0.last_sync_date AS last_sync_date_12,
  t0.sync_time AS sync_time_13,
  t0.sync_status AS sync_status_14,
  t0.sync_message AS sync_message_15,
  t0.home_club_id AS home_club_id_16,
  t0.away_club_id AS away_club_id_17,
  t0.match_country_id AS match_country_id_18,
  t0.competition_id AS competition_id_19,
  t0.stadium_id AS stadium_id_20
FROM
  `match` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.cheapest_accommodation AS cheapest_accommodation_3, t0.match_ticket_price AS match_ticket_price_4, t0.match_ticket_price_base AS match_ticket_price_base_5, t0.final AS final_6, t0.offer AS offer_7, t0.popular AS popular_8, t0.has_flight AS has_flight_9, t0.disable_booking AS disable_booking_10, t0.first_of_month AS first_of_month_11, t0.last_sync_date AS last_sync_date_12, t0.sync_time AS sync_time_13, t0.sync_status AS sync_status_14, t0.sync_message AS sync_message_15, t0.home_club_id AS home_club_id_16, t0.away_club_id AS away_club_id_17, t0.match_country_id AS match_country_id_18, t0.competition_id AS competition_id_19, t0.stadium_id AS stadium_id_20 FROM `match` t0 WHERE t0.id = '112';

SELECT
  p0_.meta_title AS meta_title_0,
  p0_.meta_description AS meta_description_1,
  p0_.id AS id_2,
  p0_.deleted_at AS deleted_at_3,
  p0_.type AS type_4,
  p0_.title AS title_5,
  p0_.fixed_header_title AS fixed_header_title_6,
  p0_.body AS body_7,
  p0_.lft AS lft_8,
  p0_.lvl AS lvl_9,
  p0_.rgt AS rgt_10,
  p0_.symlink_variable_pattern AS symlink_variable_pattern_11,
  p0_.show_in_menu AS show_in_menu_12,
  p0_.alias AS alias_13,
  p0_.deletable AS deletable_14,
  p0_.class AS class_15,
  p0_.body_class AS body_class_16,
  p0_.breadcrumbs AS breadcrumbs_17,
  p0_.controller AS controller_18,
  p0_.feature AS feature_19,
  p0_.icon_class AS icon_class_20,
  p0_.hide_title AS hide_title_21,
  p0_.robots AS robots_22,
  p0_.concept AS concept_23,
  p0_.target AS target_24,
  r1_.id AS id_25,
  r1_.`name` AS name_26,
  r1_.defaults AS defaults_27,
  r1_.staticPrefix AS staticPrefix_28,
  r1_.variable_pattern AS variable_pattern_29,
  r1_.requirements AS requirements_30,
  r1_.options AS options_31,
  r1_.host AS host_32,
  r1_.schemes AS schemes_33,
  r1_.`methods` AS methods_34,
  r1_.`condition` AS condition_35,
  r1_.locale AS locale_36,
  p0_.parent_id AS parent_id_37,
  p0_.symlink_id AS symlink_id_38,
  p0_.mega_menu_item_id AS mega_menu_item_id_39,
  p0_.hero_configuration_id AS hero_configuration_id_40,
  p0_.connexys_page_configuration_id AS connexys_page_configuration_id_41,
  r1_.page_id AS page_id_42
FROM
  page p0_
  LEFT JOIN route r1_ ON p0_.id = r1_.page_id
WHERE
  (
    p0_.rgt < 180
    AND p0_.lft > 179
    AND p0_.show_in_menu = 1
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.lft ASC