https://components.dapprgemaakt.nl/inloggen/

Query Metrics

11 Database Queries
7 Different statements
6.52 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.92 ms
(44.76%)
3
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"
]
1.28 ms
(19.71%)
2
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 = '/inloggen/' AND r0_.active = 1) AND r0_.discriminator IN ('baseredirect') GROUP BY r0_.id
Parameters:
[]
1.23 ms
(18.82%)
2
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 = '/inloggen/' AND l1_.code IN ('nl_NL') AND r0_.active = 1) AND r0_.discriminator IN ('baseroute') GROUP BY r0_.id
Parameters:
[]
0.42 ms
(6.37%)
1
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.30 ms
(4.59%)
1
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.22 ms
(3.38%)
1
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
]
0.15 ms
(2.38%)
1
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:
[]

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\SettingsBundle\Entity\BaseSetting No errors.
VisualMedia\ContentBlockBundle\Entity\BaseContentBlock No errors.
VisualMedia\PageBundle\Entity\BasePage 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\ContentBlockBundle\Entity\BaseContentBlockContent No errors.
VisualMedia\FileBundle\Entity\BaseUpload No errors.
VisualMedia\PageBundle\Entity\BasePageContent No errors.
VisualMedia\VisualBundle\Entity\BaseVisual No errors.
VisualMedia\BlockTemplateBundle\Entity\Block 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.