https://components.dapprgemaakt.nl/blog/kindergordijnen/[default:website_link]/

Query Metrics

15 Database Queries
9 Different statements
6.14 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.66 ms
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"
]
2 0.29 ms
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"
]
3 0.20 ms
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:
[]
4 0.29 ms
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:
[]
5 0.14 ms
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:
[]
6 0.31 ms
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:
[]
7 0.38 ms
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
]
8 0.19 ms
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"
]
9 0.11 ms
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:
[]
10 0.13 ms
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:
[]
11 0.11 ms
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:
[]
12 0.32 ms
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 = 'kindergordijnen' AND b0_.published = 1 AND c1_.id = 1) AND b0_.discriminator IN ('baseblogcategory') ORDER BY b0_.order_id ASC LIMIT 1
Parameters:
[]
13 0.32 ms
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:
[
  1
]
14 1.30 ms
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 = '[default:website_link]' AND b0_.published = 1 AND (b0_.publication_date IS NULL OR b0_.publication_date <= '2026-02-08 05:10:22') AND (b0_.unpublication_date IS NULL OR b0_.unpublication_date >= '2026-02-08 05:10:22') AND c1_.id = 1) AND b0_.discriminator IN ('baseblogpost') ORDER BY b0_.publication_date ASC LIMIT 1
Parameters:
[]
15 0.39 ms
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"
]

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.