Query Metrics

26 Database Queries
16 Different statements
59.53 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
18.77 ms
(31.53%)
4
SELECT d0_.host AS host_0, d0_.identifier AS identifier_1, d0_.id AS id_2, c1_.title AS title_3, c1_.main AS main_4, c1_.id AS id_5, d2_.host AS host_6, d2_.identifier AS identifier_7, d2_.id AS id_8, l3_.code AS code_9, l3_.language_code AS language_code_10, l3_.country_code AS country_code_11, l3_.id AS id_12, d0_.discriminator AS discriminator_13, d0_.channel_id AS channel_id_14, c1_.discriminator AS discriminator_15, c1_.locale_id AS locale_id_16, d2_.discriminator AS discriminator_17, d2_.channel_id AS channel_id_18, l3_.discriminator AS discriminator_19 FROM domain d0_ LEFT JOIN channel c1_ ON d0_.channel_id = c1_.id AND c1_.discriminator IN ('basechannel') LEFT JOIN domain d2_ ON c1_.id = d2_.channel_id AND d2_.discriminator IN ('basedomain') LEFT JOIN domain_locale d4_ ON d2_.id = d4_.domain_id LEFT JOIN locale l3_ ON l3_.id = d4_.locale_id AND l3_.discriminator IN ('baselocale') WHERE (d0_.host = ?) AND d0_.discriminator IN ('basedomain')
Parameters:
[
  "components.dapprgemaakt.nl"
]
11.30 ms
(18.98%)
1
SELECT b0_.published AS published_0, b0_.indexable AS indexable_1, b0_.created_by AS created_by_2, b0_.updated_by AS updated_by_3, b0_.id AS id_4, b0_.image_title AS image_title_5, b0_.image_alt AS image_alt_6, b0_.order_id AS order_id_7, b0_.created AS created_8, b0_.updated AS updated_9, b0_.discriminator AS discriminator_10, b0_.upload_id AS upload_id_11, b0_.parent_id AS parent_id_12 FROM blog_category b0_ LEFT JOIN blog_category_channel b2_ ON b0_.id = b2_.blog_category_id LEFT JOIN channel c1_ ON c1_.id = b2_.channel_id AND c1_.discriminator IN ('basechannel') LEFT JOIN blog_category_content b3_ ON b0_.id = b3_.category_id AND b3_.discriminator IN ('baseblogcategorycontent') WHERE (b3_.slug = 'effengordijnen' AND b0_.published = 1 AND c1_.id = 1) AND b0_.discriminator IN ('baseblogcategory') ORDER BY b0_.order_id ASC LIMIT 1
Parameters:
[]
11.07 ms
(18.59%)
1
SELECT t0.title AS title_1, t0.browser_title AS browser_title_2, t0.meta_description AS meta_description_3, t0.meta_keywords AS meta_keywords_4, t0.slug AS slug_5, t0.html_content_intro AS html_content_intro_6, t0.html_content AS html_content_7, t0.id AS id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.created AS created_11, t0.updated AS updated_12, t0.channel_id AS channel_id_13, t0.locale_id AS locale_id_14, t0.category_id AS category_id_15, t0.discriminator FROM blog_category_content t0 WHERE t0.category_id = ? AND t0.discriminator IN ('baseblogcategorycontent')
Parameters:
[
  9
]
6.50 ms
(10.92%)
2
SELECT t0.title AS title_1, t0.browser_title AS browser_title_2, t0.meta_description AS meta_description_3, t0.meta_keywords AS meta_keywords_4, t0.slug AS slug_5, t0.html_content AS html_content_6, t0.id AS id_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.created AS created_10, t0.updated AS updated_11, t0.channel_id AS channel_id_12, t0.locale_id AS locale_id_13, t0.page_id AS page_id_14, t0.discriminator FROM page_content t0 WHERE t0.page_id = ? AND t0.discriminator IN ('basepagecontent')
Parameters:
[
  12
]
6.46 ms
(10.85%)
1
SELECT p0_.published AS published_0, p0_.indexable AS indexable_1, p0_.layout AS layout_2, p0_.system_page AS system_page_3, p0_.components AS components_4, p0_.created_by AS created_by_5, p0_.updated_by AS updated_by_6, p0_.id AS id_7, p0_.order_id AS order_id_8, p0_.created AS created_9, p0_.updated AS updated_10, p0_.discriminator AS discriminator_11, p0_.parent_id AS parent_id_12 FROM page p0_ LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id AND p1_.discriminator IN ('basepagecontent') LEFT JOIN page_channel p3_ ON p0_.id = p3_.page_id LEFT JOIN channel c2_ ON c2_.id = p3_.channel_id AND c2_.discriminator IN ('basechannel') WHERE (p1_.slug = 'blog' AND c2_.id = 1) AND p0_.discriminator IN ('basepage') GROUP BY p0_.id
Parameters:
[]
1.68 ms
(2.82%)
1
SELECT b0_.publication_date AS publication_date_0, b0_.unpublication_date AS unpublication_date_1, b0_.published AS published_2, b0_.indexable AS indexable_3, b0_.id AS id_4, b0_.created_by AS created_by_5, b0_.updated_by AS updated_by_6, b0_.image_title AS image_title_7, b0_.image_alt AS image_alt_8, b0_.created AS created_9, b0_.updated AS updated_10, b0_.discriminator AS discriminator_11, b0_.upload_id AS upload_id_12, b0_.category_id AS category_id_13 FROM blog_post b0_ LEFT JOIN blog_post_channel b2_ ON b0_.id = b2_.blog_post_id LEFT JOIN channel c1_ ON c1_.id = b2_.channel_id AND c1_.discriminator IN ('basechannel') LEFT JOIN blog_post_content b3_ ON b0_.id = b3_.blog_post_id AND b3_.discriminator IN ('baseblogpostcontent') WHERE (b3_.slug = 'test-fusce-ut-velit-vitae' AND b0_.published = 1 AND (b0_.publication_date IS NULL OR b0_.publication_date <= '2025-12-24 15:41:37') AND (b0_.unpublication_date IS NULL OR b0_.unpublication_date >= '2025-12-24 15:41:37') AND c1_.id = 1) AND b0_.discriminator IN ('baseblogpost') ORDER BY b0_.publication_date ASC LIMIT 1
Parameters:
[]
1.44 ms
(2.41%)
2
SELECT d0_.host AS host_0, d0_.identifier AS identifier_1, d0_.id AS id_2, d0_.discriminator AS discriminator_3, d0_.channel_id AS channel_id_4 FROM domain d0_ WHERE d0_.discriminator IN ('basedomain') GROUP BY d0_.id
Parameters:
[]
0.43 ms
(0.72%)
2
SELECT c0_.title AS title_0, c0_.main AS main_1, c0_.id AS id_2, c0_.discriminator AS discriminator_3, c0_.locale_id AS locale_id_4 FROM channel c0_ WHERE c0_.discriminator IN ('basechannel') GROUP BY c0_.id
Parameters:
[]
0.33 ms
(0.56%)
3
SELECT t0.title AS title_1, t0.published AS published_2, t0.factory AS factory_3, t0.link AS link_4, t0.target_blank AS target_blank_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.id AS id_8, t0.order_id AS order_id_9, t0.created AS created_10, t0.updated AS updated_11, t0.menu_id AS menu_id_12, t0.parent_id AS parent_id_13, t0.discriminator FROM menu_item t0 WHERE t0.menu_id = ? AND t0.discriminator IN ('basemenuitem') ORDER BY t0.order_id ASC
Parameters:
[
  1
]
0.29 ms
(0.48%)
2
SELECT l0_.code AS code_0, l0_.language_code AS language_code_1, l0_.country_code AS country_code_2, l0_.id AS id_3, l0_.discriminator AS discriminator_4 FROM locale l0_ WHERE l0_.discriminator IN ('baselocale') GROUP BY l0_.id
Parameters:
[]
0.28 ms
(0.47%)
1
SELECT p0_.published AS published_0, p0_.indexable AS indexable_1, p0_.layout AS layout_2, p0_.system_page AS system_page_3, p0_.components AS components_4, p0_.created_by AS created_by_5, p0_.updated_by AS updated_by_6, p0_.id AS id_7, p0_.order_id AS order_id_8, p0_.created AS created_9, p0_.updated AS updated_10, p0_.discriminator AS discriminator_11, p0_.parent_id AS parent_id_12 FROM page p0_ LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id AND p1_.discriminator IN ('basepagecontent') WHERE (p0_.id = '1' AND p0_.published = 1) AND p0_.discriminator IN ('basepage') GROUP BY p0_.id
Parameters:
[]
0.27 ms
(0.46%)
2
SELECT t0.title AS title_1, t0.main AS main_2, t0.id AS id_3, t0.locale_id AS locale_id_4, t0.discriminator FROM channel t0 INNER JOIN menu_channel ON t0.id = menu_channel.channel_id WHERE menu_channel.menu_id = ? AND t0.discriminator IN ('basechannel')
Parameters:
[
  2
]
0.19 ms
(0.32%)
1
SELECT t0.title AS title_1, t0.browser_title AS browser_title_2, t0.meta_description AS meta_description_3, t0.meta_keywords AS meta_keywords_4, t0.slug AS slug_5, t0.html_content_intro AS html_content_intro_6, t0.html_content AS html_content_7, t0.author AS author_8, t0.source AS source_9, t0.id AS id_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.created AS created_13, t0.updated AS updated_14, t0.channel_id AS channel_id_15, t0.locale_id AS locale_id_16, t0.blog_post_id AS blog_post_id_17, t0.discriminator FROM blog_post_content t0 WHERE t0.blog_post_id = ? AND t0.discriminator IN ('baseblogpostcontent')
Parameters:
[
  4
]
0.19 ms
(0.32%)
1
SELECT s0_.name AS name_0, s0_.value AS value_1, s0_.reference AS reference_2, s0_.scope AS scope_3, s0_.permission AS permission_4, s0_.factory AS factory_5, s0_.id AS id_6, s0_.discriminator AS discriminator_7 FROM setting s0_ WHERE s0_.discriminator IN ('basesetting') GROUP BY s0_.id
Parameters:
[]
0.19 ms
(0.31%)
1
SELECT m0_.title AS title_0, m0_.reference AS reference_1, m0_.created_by AS created_by_2, m0_.updated_by AS updated_by_3, m0_.id AS id_4, m0_.order_id AS order_id_5, m0_.created AS created_6, m0_.updated AS updated_7, c1_.title AS title_8, c1_.main AS main_9, c1_.id AS id_10, m0_.discriminator AS discriminator_11, c1_.discriminator AS discriminator_12, c1_.locale_id AS locale_id_13 FROM menu m0_ LEFT JOIN menu_channel m2_ ON m0_.id = m2_.menu_id LEFT JOIN channel c1_ ON c1_.id = m2_.channel_id AND c1_.discriminator IN ('basechannel') WHERE (m0_.reference = 'main' AND c1_.id = 1) AND m0_.discriminator IN ('basemenu') GROUP BY m0_.id
Parameters:
[]
0.16 ms
(0.27%)
1
SELECT m0_.title AS title_0, m0_.reference AS reference_1, m0_.created_by AS created_by_2, m0_.updated_by AS updated_by_3, m0_.id AS id_4, m0_.order_id AS order_id_5, m0_.created AS created_6, m0_.updated AS updated_7, m0_.discriminator AS discriminator_8 FROM menu m0_ WHERE m0_.discriminator IN ('basemenu') GROUP BY m0_.id
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
VisualMedia\TranslationBundle\Entity\BaseChannel No errors.
VisualMedia\TranslationBundle\Entity\BaseDomain No errors.
VisualMedia\TranslationBundle\Entity\BaseLocale No errors.
VisualMedia\RoutingBundle\Entity\BaseRoute No errors.
VisualMedia\PageBundle\Entity\BasePage No errors.
VisualMedia\PageBundle\Entity\BasePageContent No errors.
VisualMedia\VisualBundle\Entity\BaseVisual No errors.
VisualMedia\BlockTemplateBundle\Entity\Block No errors.
VisualMedia\BlogBundle\Entity\BaseBlogCategory No errors.
VisualMedia\BlogBundle\Entity\BaseBlogCategoryContent No errors.
VisualMedia\FileBundle\Entity\BaseUpload No errors.
VisualMedia\BlogBundle\Entity\BaseBlogCategoryLink No errors.
VisualMedia\BlogBundle\Entity\BaseBlogPost No errors.
VisualMedia\BlogBundle\Entity\BaseBlogPostContent No errors.
VisualMedia\SettingsBundle\Entity\BaseSetting No errors.
VisualMedia\ContentBlockBundle\Entity\BaseContentBlock No errors.
VisualMedia\VacancyBundle\Entity\BaseVacancy No errors.
VisualMedia\ProjectBundle\Entity\BaseProject No errors.
VisualMedia\ProductBundle\Entity\BaseProductCategory No errors.
VisualMedia\ProductBundle\Entity\BaseProduct No errors.
VisualMedia\EmployeeBundle\Entity\BaseEmployee No errors.
VisualMedia\MenuBundle\Entity\BaseMenu No errors.
VisualMedia\MenuBundle\Entity\BaseMenuItem No errors.