GET https://www.leroy.goconcept8.be/brochures

Query Metrics

139 Database Queries
14 Different statements
35.26 ms Query time
0 Invalid entities
108 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
15.07 ms
(42.75%)
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
]
5.63 ms
(15.98%)
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"
]
3.93 ms
(11.13%)
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
]
2.34 ms
(6.64%)
20
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:
[
  "brochure-cover-small"
]
1.64 ms
(4.65%)
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:
[
  "content"
  335
]
1.48 ms
(4.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
]
0.97 ms
(2.74%)
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:
[
  41
]
0.97 ms
(2.74%)
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
]
0.69 ms
(1.96%)
3
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:
[
  "Nos agences"
  1
]
0.64 ms
(1.80%)
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.url_alias_id = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  8806
]
0.61 ms
(1.74%)
3
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:
[
  335
]
0.55 ms
(1.57%)
4
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:
[
  "brochure-cover"
]
0.46 ms
(1.29%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.photo_file AS photo_file_3, t0.pdf_file AS pdf_file_4, t0.pdf_link AS pdf_link_5, t0.archived AS archived_6, t0.published AS published_7, t0.orderable AS orderable_8, t0.display_order AS display_order_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM brochure t0 WHERE t0.published = ? AND t0.archived = ? ORDER BY t0.display_order ASC
Parameters:
[
  1
  0
]
0.28 ms
(0.81%)
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:
[
  11
]

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 28
App\Entity\Brochure 4
App\Entity\ImageStyle 4
App\Entity\ResponsiveImageStyleMapping 4
App\Entity\Breakpoint 4
App\Entity\Menu 3
App\Entity\Content 3
App\Entity\ResponsiveImageStyle 1