Query Metrics
10
Database Queries
7
Different statements
5.91 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.03 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.34 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.31 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.17 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.19 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 | 1.39 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 = '/winkelwagen' AND l1_.code IN ('nl_NL') AND r0_.active = 1) AND r0_.discriminator IN ('baseroute') GROUP BY r0_.id
Parameters:
[] |
| 8 | 0.77 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 = '/winkelwagen' 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 = '/winkelwagen' 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 = '/winkelwagen' AND r0_.active = 1) AND r0_.discriminator IN ('baseredirect') GROUP BY r0_.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. |