Query Metrics
13
Database Queries
9
Different statements
5.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.57 ms (49.92%) |
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"
]
|
|
0.55 ms (10.66%) |
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 = '/_next/' AND l1_.code IN ('nl_NL') AND r0_.active = 1) AND r0_.discriminator IN ('baseroute') GROUP BY r0_.id
Parameters:
[] |
|
0.42 ms (8.09%) |
1 |
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
]
|
|
0.36 ms (6.93%) |
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.31 ms (5.97%) |
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 = '_next' AND p0_.published = 1 AND c2_.id = 1) AND p0_.discriminator IN ('basepage') GROUP BY p0_.id
Parameters:
[] |
|
0.30 ms (5.82%) |
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 = '/_next/' AND r0_.active = 1) AND r0_.discriminator IN ('baseredirect') GROUP BY r0_.id
Parameters:
[] |
|
0.26 ms (5.10%) |
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.22 ms (4.32%) |
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.16 ms (3.19%) |
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\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. |