Query Metrics
24
Database Queries
13
Different statements
15.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.77 ms (23.93%) |
5 |
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.34 ms (21.19%) |
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 = 'contact' AND c2_.id = 1) AND p0_.discriminator IN ('basepage') GROUP BY p0_.id
Parameters:
[] |
|
1.92 ms (12.18%) |
2 |
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:
[
2
]
|
|
1.68 ms (10.69%) |
1 |
SELECT t0.title AS title_1, t0.reference AS reference_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.id AS id_5, t0.image_title AS image_title_6, t0.image_alt AS image_alt_7, t0.created AS created_8, t0.updated AS updated_9, t0.upload_id AS upload_id_10, t0.discriminator FROM visual t0 INNER JOIN page_visual_link ON t0.id = page_visual_link.visual_id WHERE page_visual_link.page_id = ? AND t0.discriminator IN ('basevisual')
Parameters:
[
2
]
|
|
1.04 ms (6.60%) |
1 |
SELECT m0_.title AS title_0, m0_.reference AS reference_1, m0_.created_by AS created_by_2, m0_.updated_by AS updated_by_3, m0_.id AS id_4, m0_.order_id AS order_id_5, m0_.created AS created_6, m0_.updated AS updated_7, c1_.title AS title_8, c1_.main AS main_9, c1_.id AS id_10, m0_.discriminator AS discriminator_11, c1_.discriminator AS discriminator_12, c1_.locale_id AS locale_id_13 FROM menu m0_ LEFT JOIN menu_channel m2_ ON m0_.id = m2_.menu_id LEFT JOIN channel c1_ ON c1_.id = m2_.channel_id AND c1_.discriminator IN ('basechannel') WHERE (m0_.reference = 'main' AND c1_.id = 1) AND m0_.discriminator IN ('basemenu') GROUP BY m0_.id
Parameters:
[] |
|
0.80 ms (5.04%) |
3 |
SELECT t0.title AS title_1, t0.published AS published_2, t0.factory AS factory_3, t0.link AS link_4, t0.target_blank AS target_blank_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.id AS id_8, t0.order_id AS order_id_9, t0.created AS created_10, t0.updated AS updated_11, t0.menu_id AS menu_id_12, t0.parent_id AS parent_id_13, t0.discriminator FROM menu_item t0 WHERE t0.menu_id = ? AND t0.discriminator IN ('basemenuitem') ORDER BY t0.order_id ASC
Parameters:
[
1
]
|
|
0.73 ms (4.62%) |
1 |
SELECT m0_.title AS title_0, m0_.reference AS reference_1, m0_.created_by AS created_by_2, m0_.updated_by AS updated_by_3, m0_.id AS id_4, m0_.order_id AS order_id_5, m0_.created AS created_6, m0_.updated AS updated_7, m0_.discriminator AS discriminator_8 FROM menu m0_ WHERE m0_.discriminator IN ('basemenu') GROUP BY m0_.id
Parameters:
[] |
|
0.49 ms (3.10%) |
2 |
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.45 ms (2.88%) |
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') WHERE (p0_.id = '1' AND p0_.published = 1) AND p0_.discriminator IN ('basepage') GROUP BY p0_.id
Parameters:
[] |
|
0.43 ms (2.71%) |
2 |
SELECT t0.title AS title_1, t0.main AS main_2, t0.id AS id_3, t0.locale_id AS locale_id_4, t0.discriminator FROM channel t0 INNER JOIN menu_channel ON t0.id = menu_channel.channel_id WHERE menu_channel.menu_id = ? AND t0.discriminator IN ('basechannel')
Parameters:
[
2
]
|
|
0.40 ms (2.54%) |
1 |
SELECT s0_.name AS name_0, s0_.value AS value_1, s0_.reference AS reference_2, s0_.scope AS scope_3, s0_.permission AS permission_4, s0_.factory AS factory_5, s0_.id AS id_6, s0_.discriminator AS discriminator_7 FROM setting s0_ WHERE s0_.discriminator IN ('basesetting') GROUP BY s0_.id
Parameters:
[] |
|
0.39 ms (2.50%) |
2 |
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.32 ms (2.02%) |
2 |
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\PageBundle\Entity\BasePage | No errors. |
| VisualMedia\PageBundle\Entity\BasePageContent | No errors. |
| VisualMedia\VisualBundle\Entity\BaseVisual | No errors. |
| VisualMedia\BlockTemplateBundle\Entity\Block | 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\MenuBundle\Entity\BaseMenuItem | No errors. |
| VisualMedia\FileBundle\Entity\BaseUpload | No errors. |
| VisualMedia\ContentBlockBundle\Entity\BaseContentBlockContent | 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. |