GET https://www.leroy.goconcept8.be/destinations/pays/norvege

Query Metrics

127 Database Queries
19 Different statements
397.02 ms Query time
0 Invalid entities
112 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
115.17 ms
(29.01%)
27
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.path AS path_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.route_name AS route_name_6, t0.pathauto AS pathauto_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM url_alias t0 WHERE t0.id = ?
Parameters:
[
  8806
]
91.02 ms
(22.93%)
57
SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  676
]
28.07 ms
(7.07%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.min_width AS min_width_4 FROM breakpoint t0 WHERE t0.id = ?
Parameters:
[
  1
]
27.35 ms
(6.89%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.width AS width_4, t0.height AS height_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM image_style t0 WHERE t0.id = ?
Parameters:
[
  104
]
22.46 ms
(5.66%)
6
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.path AS path_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.route_name AS route_name_6, t0.pathauto AS pathauto_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM url_alias t0 WHERE t0.entity_type = ? AND t0.entity_id = ? LIMIT 1
Parameters:
[
  "country"
  336
]
18.50 ms
(4.66%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_h1 AS title_h1_3, t0.body AS body_4, t0.image AS image_5, t0.show_header_image AS show_header_image_6, t0.layout AS layout_7, t0.pinned AS pinned_8, t0.created_at AS created_at_9, t0.published_at AS published_at_10, t0.updated_at AS updated_at_11, t0.published AS published_12, t0.archived AS archived_13, t0.exclude_from_search AS exclude_from_search_14, t0.seo_title AS seo_title_15, t0.seo_description AS seo_description_16, t0.seo_keywords AS seo_keywords_17, t0.seo_canonical AS seo_canonical_18, t0.seo_key AS seo_key_19, t0.seo_robots AS seo_robots_20, t0.seo_sitemap AS seo_sitemap_21 FROM content t0 WHERE t0.title = ? AND t0.published = ? LIMIT 1
Parameters:
[
  "Politique de Cookies"
  1
]
17.45 ms
(4.40%)
2
SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.url_alias_id = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  8819
]
14.23 ms
(3.58%)
1
SELECT t0.id AS id_1, t0.old_path AS old_path_2, t0.target_url AS target_url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.target_alias_id AS target_alias_id_6 FROM url_redirect t0 WHERE t0.old_path = ? LIMIT 1
Parameters:
[
  "destinations/pays/norvege"
]
13.92 ms
(3.51%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.title_h1 AS title_h1_4, t0.period AS period_5, t0.time_difference AS time_difference_6, t0.currency AS currency_7, t0.formalities AS formalities_8, t0.good_to_know AS good_to_know_9, t0.body AS body_10, t0.intro AS intro_11, t0.image_content AS image_content_12, t0.image AS image_13, t0.main_menu AS main_menu_14, t0.favorite AS favorite_15, t0.active AS active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.seo_title AS seo_title_19, t0.seo_description AS seo_description_20, t0.seo_keywords AS seo_keywords_21, t0.seo_canonical AS seo_canonical_22, t0.seo_key AS seo_key_23, t0.seo_robots AS seo_robots_24, t0.seo_sitemap AS seo_sitemap_25 FROM region t0 INNER JOIN region_country ON t0.id = region_country.region_id WHERE region_country.country_id = ?
Parameters:
[
  336
]
11.11 ms
(2.80%)
7
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.width AS width_4, t0.height AS height_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM image_style t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "header-small"
]
9.94 ms
(2.50%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3 FROM menu t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "topbar"
]
8.56 ms
(2.16%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.path AS path_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.route_name AS route_name_6, t0.pathauto AS pathauto_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM url_alias t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
  "destinations/pays/norvege"
]
6.64 ms
(1.67%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.fallback_image_style_id AS fallback_image_style_id_6 FROM responsive_image_style t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "header-full-width"
]
4.91 ms
(1.24%)
2
SELECT t0.id AS id_1, t0.slot AS slot_2, t0.content_id AS content_id_3 FROM content_display_slot t0 WHERE t0.content_id = ?
Parameters:
[
  348
]
2.69 ms
(0.68%)
3
SELECT t0.id AS id_1, t0.label AS label_2, t0.external_url AS external_url_3, t0.target AS target_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8, t0.menu_id AS menu_id_9, t0.url_alias_id AS url_alias_id_10 FROM menu_link t0 WHERE t0.menu_id = ? AND t0.parent_id IS NULL ORDER BY t0.position ASC
Parameters:
[
  4
]
2.05 ms
(0.52%)
1
SELECT t0.id AS id_1, t0.offer_code AS offer_code_2, t0.offer_type AS offer_type_3, t0.unique_price AS unique_price_4, t0.unique_city AS unique_city_5, t0.unique_description AS unique_description_6, t0.unique_division AS unique_division_7, t0.variant_label AS variant_label_8, t0.canonical AS canonical_9, t0.title AS title_10, t0.teaser AS teaser_11, t0.description AS description_12, t0.intro AS intro_13, t0.chapeau1 AS chapeau1_14, t0.chapeau2 AS chapeau2_15, t0.qualite_leo AS qualite_leo_16, t0.entree_site AS entree_site_17, t0.price_comment AS price_comment_18, t0.gifts AS gifts_19, t0.good_to_know AS good_to_know_20, t0.important_info AS important_info_21, t0.duration AS duration_22, t0.duration_only_on_web AS duration_only_on_web_23, t0.minimum_length AS minimum_length_24, t0.is_stay AS is_stay_25, t0.published AS published_26, t0.special_offer_enabled AS special_offer_enabled_27, t0.special_offer_url AS special_offer_url_28, t0.not_in_brochure AS not_in_brochure_29, t0.brochure_page AS brochure_page_30, t0.brochure_column AS brochure_column_31, t0.print_title AS print_title_32, t0.print_intro AS print_intro_33, t0.print_schedule AS print_schedule_34, t0.print_starting_price AS print_starting_price_35, t0.print_price_notes AS print_price_notes_36, t0.print_date AS print_date_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.stay_services AS stay_services_40, t0.stay_room AS stay_room_41, t0.stay_catering AS stay_catering_42, t0.stay_animation AS stay_animation_43, t0.eco_impact_formula AS eco_impact_formula_44, t0.eco_impact_type AS eco_impact_type_45, t0.eco_impact_distance AS eco_impact_distance_46, t0.eco_impact_emissions AS eco_impact_emissions_47, t0.eco_impact_contribution AS eco_impact_contribution_48, t0.seo_title AS seo_title_49, t0.seo_description AS seo_description_50, t0.seo_keywords AS seo_keywords_51, t0.seo_canonical AS seo_canonical_52, t0.seo_key AS seo_key_53, t0.seo_robots AS seo_robots_54, t0.seo_sitemap AS seo_sitemap_55, t0.variant_group_id AS variant_group_id_56, t0.type_id AS type_id_57, t0.brochure_id AS brochure_id_58, t0.print_thematique_id AS print_thematique_id_59 FROM travel_description t0 INNER JOIN travel_description_country ON t0.id = travel_description_country.travel_description_id WHERE travel_description_country.country_id = ?
Parameters:
[
  336
]
1.42 ms
(0.36%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.title_h1 AS title_h1_4, t0.body AS body_5, t0.intro AS intro_6, t0.image_content AS image_content_7, t0.image AS image_8, t0.main_menu AS main_menu_9, t0.active AS active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.position AS position_13, t0.seo_title AS seo_title_14, t0.seo_description AS seo_description_15, t0.seo_keywords AS seo_keywords_16, t0.seo_canonical AS seo_canonical_17, t0.seo_key AS seo_key_18, t0.seo_robots AS seo_robots_19, t0.seo_sitemap AS seo_sitemap_20, t0.continent_id AS continent_id_21 FROM country t0 WHERE t0.id = ?
Parameters:
[
  336
]
0.99 ms
(0.25%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.title_h1 AS title_h1_4, t0.body AS body_5, t0.intro AS intro_6, t0.image_content AS image_content_7, t0.image AS image_8, t0.main_menu AS main_menu_9, t0.active AS active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.position AS position_13, t0.seo_title AS seo_title_14, t0.seo_description AS seo_description_15, t0.seo_keywords AS seo_keywords_16, t0.seo_canonical AS seo_canonical_17, t0.seo_key AS seo_key_18, t0.seo_robots AS seo_robots_19, t0.seo_sitemap AS seo_sitemap_20 FROM continent t0 WHERE t0.id = ?
Parameters:
[
  45
]
0.56 ms
(0.14%)
1
SELECT t0.id AS id_1, t0.multiplier AS multiplier_2, t0.responsive_image_style_id AS responsive_image_style_id_3, t0.breakpoint_id AS breakpoint_id_4, t0.image_style_id AS image_style_id_5 FROM responsive_image_style_mapping t0 WHERE t0.responsive_image_style_id = ?
Parameters:
[
  22
]

Database Connections

Name Service
default doctrine.dbal.default_connection
legacy_east doctrine.dbal.legacy_east_connection
legacy_west doctrine.dbal.legacy_west_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MenuLink 57
App\Entity\UrlAlias 31
App\Entity\ImageStyle 6
App\Entity\ResponsiveImageStyleMapping 6
App\Entity\Breakpoint 4
App\Entity\Menu 3
App\Entity\Content 2
App\Entity\Destination\Country 1
App\Entity\Destination\Continent 1
App\Entity\ResponsiveImageStyle 1