Query Metrics
27
Database Queries
16
Different statements
8.12 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.63 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.31 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.15 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.26 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.12 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.26 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 = 'blog' AND c2_.id = 1) AND p0_.discriminator IN ('basepage') GROUP BY p0_.id
Parameters:
[] |
| 7 | 0.22 ms |
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:
[
12
]
|
| 8 | 0.13 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"
]
|
| 9 | 0.12 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:
[] |
| 10 | 0.12 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:
[] |
| 11 | 0.09 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:
[] |
| 12 | 0.23 ms |
SELECT b0_.published AS published_0, b0_.indexable AS indexable_1, b0_.created_by AS created_by_2, b0_.updated_by AS updated_by_3, b0_.id AS id_4, b0_.image_title AS image_title_5, b0_.image_alt AS image_alt_6, b0_.order_id AS order_id_7, b0_.created AS created_8, b0_.updated AS updated_9, b0_.discriminator AS discriminator_10, b0_.upload_id AS upload_id_11, b0_.parent_id AS parent_id_12 FROM blog_category b0_ LEFT JOIN blog_category_channel b2_ ON b0_.id = b2_.blog_category_id LEFT JOIN channel c1_ ON c1_.id = b2_.channel_id AND c1_.discriminator IN ('basechannel') LEFT JOIN blog_category_content b3_ ON b0_.id = b3_.category_id AND b3_.discriminator IN ('baseblogcategorycontent') WHERE (b3_.slug = 'jongensgordijnen' AND b0_.published = 1 AND c1_.id = 1) AND b0_.discriminator IN ('baseblogcategory') ORDER BY b0_.order_id ASC LIMIT 1
Parameters:
[] |
| 13 | 0.22 ms |
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_intro AS html_content_intro_6, t0.html_content AS html_content_7, t0.id AS id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.created AS created_11, t0.updated AS updated_12, t0.channel_id AS channel_id_13, t0.locale_id AS locale_id_14, t0.category_id AS category_id_15, t0.discriminator FROM blog_category_content t0 WHERE t0.category_id = ? AND t0.discriminator IN ('baseblogcategorycontent')
Parameters:
[
3
]
|
| 14 | 1.59 ms |
SELECT b0_.publication_date AS publication_date_0, b0_.unpublication_date AS unpublication_date_1, b0_.published AS published_2, b0_.indexable AS indexable_3, b0_.id AS id_4, b0_.created_by AS created_by_5, b0_.updated_by AS updated_by_6, b0_.image_title AS image_title_7, b0_.image_alt AS image_alt_8, b0_.created AS created_9, b0_.updated AS updated_10, b0_.discriminator AS discriminator_11, b0_.upload_id AS upload_id_12, b0_.category_id AS category_id_13 FROM blog_post b0_ LEFT JOIN blog_post_channel b2_ ON b0_.id = b2_.blog_post_id LEFT JOIN channel c1_ ON c1_.id = b2_.channel_id AND c1_.discriminator IN ('basechannel') LEFT JOIN blog_post_content b3_ ON b0_.id = b3_.blog_post_id AND b3_.discriminator IN ('baseblogpostcontent') WHERE (b3_.slug = 'moet-nog-beginnen-test' AND b0_.published = 1 AND (b0_.publication_date IS NULL OR b0_.publication_date <= '2025-12-24 15:41:37') AND (b0_.unpublication_date IS NULL OR b0_.unpublication_date >= '2025-12-24 15:41:37') AND c1_.id = 1) AND b0_.discriminator IN ('baseblogpost') ORDER BY b0_.publication_date ASC LIMIT 1
Parameters:
[] |
| 15 | 0.23 ms |
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_intro AS html_content_intro_6, t0.html_content AS html_content_7, t0.author AS author_8, t0.source AS source_9, t0.id AS id_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.created AS created_13, t0.updated AS updated_14, t0.channel_id AS channel_id_15, t0.locale_id AS locale_id_16, t0.blog_post_id AS blog_post_id_17, t0.discriminator FROM blog_post_content t0 WHERE t0.blog_post_id = ? AND t0.discriminator IN ('baseblogpostcontent')
Parameters:
[
5
]
|
| 16 | 0.28 ms |
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:
[] |
| 17 | 0.26 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"
]
|
| 18 | 0.21 ms |
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:
[] |
| 19 | 0.19 ms |
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:
[] |
| 20 | 0.16 ms |
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
]
|
| 21 | 0.21 ms |
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
]
|
| 22 | 0.13 ms |
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:
[
2
]
|
| 23 | 0.13 ms |
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:
[
3
]
|
| 24 | 0.10 ms |
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:
[
3
]
|
| 25 | 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') WHERE (p0_.id = '1' AND p0_.published = 1) AND p0_.discriminator IN ('basepage') GROUP BY p0_.id
Parameters:
[] |
| 26 | 0.16 ms |
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:
[
1
]
|
| 27 | 0.28 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"
]
|
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\BlogBundle\Entity\BaseBlogCategory | No errors. |
| VisualMedia\BlogBundle\Entity\BaseBlogCategoryContent | No errors. |
| VisualMedia\FileBundle\Entity\BaseUpload | No errors. |
| VisualMedia\BlogBundle\Entity\BaseBlogCategoryLink | No errors. |
| VisualMedia\BlogBundle\Entity\BaseBlogPost | No errors. |
| VisualMedia\BlogBundle\Entity\BaseBlogPostContent | 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\BaseFolder | 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. |