GET https://leroy.goconcept8.be/destinations/moyen-orient

Query Metrics

129 Database Queries
17 Different statements
1487.97 ms Query time
0 Invalid entities
112 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
417.30 ms
(28.05%)
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
]
353.41 ms
(23.75%)
10
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:
[
  "destination-thumb-small"
]
277.10 ms
(18.62%)
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
]
211.83 ms
(14.24%)
2
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:
[
  "destination-listing"
]
86.88 ms
(5.84%)
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/moyen-orient"
]
36.53 ms
(2.46%)
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
]
34.47 ms
(2.32%)
8
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:
[
  "continent"
  51
]
20.85 ms
(1.40%)
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
]
18.66 ms
(1.25%)
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
]
11.71 ms
(0.79%)
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
]
7.87 ms
(0.53%)
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.continent_id = ?
Parameters:
[
  51
]
4.35 ms
(0.29%)
4
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:
[
  116
]
2.82 ms
(0.19%)
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
]
1.79 ms
(0.12%)
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"
]
1.32 ms
(0.09%)
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/moyen-orient"
]
0.58 ms
(0.04%)
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:
[
  51
]
0.52 ms
(0.03%)
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:
[
  28
]

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 33
App\Entity\ImageStyle 4
App\Entity\ResponsiveImageStyleMapping 4
App\Entity\Breakpoint 4
App\Entity\Destination\Country 3
App\Entity\Menu 3
App\Entity\Content 2
App\Entity\Destination\Continent 1
App\Entity\ResponsiveImageStyle 1