https://components.dapprgemaakt.nl/_next/

Query Metrics

13 Database Queries
9 Different statements
5.14 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.83 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.36 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.26 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.36 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.16 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.22 ms
SELECT t0.code AS code_1, t0.language_code AS language_code_2, t0.country_code AS country_code_3, t0.id AS id_4, t0.discriminator FROM locale t0 INNER JOIN domain_locale ON t0.id = domain_locale.locale_id WHERE domain_locale.domain_id = ? AND t0.discriminator IN ('baselocale')
Parameters:
[
  1
]
7 0.24 ms
SELECT r0_.name AS name_0, r0_.url AS url_1, r0_.active AS active_2, r0_.controller AS controller_3, r0_.parameters AS parameters_4, r0_.entity_key AS entity_key_5, r0_.created_by AS created_by_6, r0_.updated_by AS updated_by_7, r0_.id AS id_8, r0_.created AS created_9, r0_.updated AS updated_10, l1_.code AS code_11, l1_.language_code AS language_code_12, l1_.country_code AS country_code_13, l1_.id AS id_14, r0_.discriminator AS discriminator_15, r0_.locale_id AS locale_id_16, l1_.discriminator AS discriminator_17 FROM route r0_ LEFT JOIN locale l1_ ON r0_.locale_id = l1_.id AND l1_.discriminator IN ('baselocale') WHERE (r0_.url = '/_next/' AND l1_.code IN ('nl_NL') AND r0_.active = 1) AND r0_.discriminator IN ('baseroute') GROUP BY r0_.id
Parameters:
[]
8 0.17 ms
SELECT r0_.type AS type_0, r0_.url_from AS url_from_1, r0_.url_to AS url_to_2, r0_.active AS active_3, r0_.auto_generated AS auto_generated_4, r0_.created_by AS created_by_5, r0_.updated_by AS updated_by_6, r0_.id AS id_7, r0_.created AS created_8, r0_.updated AS updated_9, r0_.discriminator AS discriminator_10 FROM redirect r0_ WHERE (r0_.url_from = '/_next/' AND r0_.active = 1) AND r0_.discriminator IN ('baseredirect') GROUP BY r0_.id
Parameters:
[]
9 0.31 ms
SELECT r0_.name AS name_0, r0_.url AS url_1, r0_.active AS active_2, r0_.controller AS controller_3, r0_.parameters AS parameters_4, r0_.entity_key AS entity_key_5, r0_.created_by AS created_by_6, r0_.updated_by AS updated_by_7, r0_.id AS id_8, r0_.created AS created_9, r0_.updated AS updated_10, l1_.code AS code_11, l1_.language_code AS language_code_12, l1_.country_code AS country_code_13, l1_.id AS id_14, r0_.discriminator AS discriminator_15, r0_.locale_id AS locale_id_16, l1_.discriminator AS discriminator_17 FROM route r0_ LEFT JOIN locale l1_ ON r0_.locale_id = l1_.id AND l1_.discriminator IN ('baselocale') WHERE (r0_.url = '/_next/' AND l1_.code IN ('nl_NL') AND r0_.active = 1) AND r0_.discriminator IN ('baseroute') GROUP BY r0_.id
Parameters:
[]
10 0.13 ms
SELECT r0_.type AS type_0, r0_.url_from AS url_from_1, r0_.url_to AS url_to_2, r0_.active AS active_3, r0_.auto_generated AS auto_generated_4, r0_.created_by AS created_by_5, r0_.updated_by AS updated_by_6, r0_.id AS id_7, r0_.created AS created_8, r0_.updated AS updated_9, r0_.discriminator AS discriminator_10 FROM redirect r0_ WHERE (r0_.url_from = '/_next/' AND r0_.active = 1) AND r0_.discriminator IN ('baseredirect') GROUP BY r0_.id
Parameters:
[]
11 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 = '_next' AND p0_.published = 1 AND c2_.id = 1) AND p0_.discriminator IN ('basepage') GROUP BY p0_.id
Parameters:
[]
12 0.37 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"
]
13 0.42 ms
SELECT t0.host AS host_1, t0.identifier AS identifier_2, t0.id AS id_3, t0.channel_id AS channel_id_4, t0.discriminator FROM domain t0 WHERE t0.channel_id = ? AND t0.discriminator IN ('basedomain')
Parameters:
[
  1
]

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\RoutingBundle\Entity\BaseRedirect No errors.
VisualMedia\PageBundle\Entity\BasePage No errors.
VisualMedia\PageBundle\Entity\BasePageContent 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\VisualBundle\Entity\BaseVisual No errors.
VisualMedia\BlockTemplateBundle\Entity\Block No errors.
VisualMedia\ContentBlockBundle\Entity\BaseContentBlockContent No errors.
VisualMedia\FileBundle\Entity\BaseUpload No errors.
VisualMedia\ProjectBundle\Entity\BaseProjectPhoto No errors.
VisualMedia\ProductBundle\Entity\BaseProductCategoryLink No errors.
VisualMedia\ProductBundle\Entity\BaseProductCategoryContent No errors.
VisualMedia\ProductBundle\Entity\BaseAttributeSet No errors.
VisualMedia\ProductBundle\Entity\BaseAttributeContent No errors.
VisualMedia\ProductBundle\Entity\BaseProductPhoto No errors.
VisualMedia\ProductBundle\Entity\BaseProductContent No errors.
VisualMedia\MenuBundle\Entity\BaseMenuItem No errors.