Query Metrics
92
Database Queries
3
Different statements
48.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
45.72 ms (94.51%) |
90 |
SELECT t0.locale AS locale_1, t0.field_name AS field_name_2, t0.translation AS translation_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.page_id AS page_id_7 FROM cms_page_translation t0 WHERE t0.page_id = ?
Parameters:
[
4
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (4.37%) |
1 |
SELECT c0_.page_name AS page_name_0, c0_.page_published AS page_published_1, c0_.page_css_file_global AS page_css_file_global_2, c0_.page_css_global AS page_css_global_3, c0_.page_js_file_global AS page_js_file_global_4, c0_.page_js_global AS page_js_global_5, c0_.page_order AS page_order_6, c0_.id AS id_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.uuid AS uuid_10, c1_.template_name AS template_name_11, c1_.template_html AS template_html_12, c1_.template_type AS template_type_13, c1_.id AS id_14, c1_.created_at AS created_at_15, c1_.updated_at AS updated_at_16, c1_.uuid AS uuid_17, c0_.template_id AS template_id_18, c0_.page_category_id AS page_category_id_19, c0_.page_content_seo_id AS page_content_seo_id_20 FROM cms_page c0_ INNER JOIN cms_page_category c2_ ON c0_.page_category_id = c2_.id INNER JOIN cms_template c1_ ON c0_.template_id = c1_.id
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.54 ms (1.11%) |
1 |
SELECT t0.page_name AS page_name_1, t0.page_published AS page_published_2, t0.page_css_file_global AS page_css_file_global_3, t0.page_css_global AS page_css_global_4, t0.page_js_file_global AS page_js_file_global_5, t0.page_js_global AS page_js_global_6, t0.page_order AS page_order_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.template_id AS template_id_12, t0.page_category_id AS page_category_id_13, t0.page_content_seo_id AS page_content_seo_id_14 FROM cms_page t0 WHERE t0.page_name = ? LIMIT 1
Parameters:
[
"404"
]
|
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 |
|---|---|
| Flagstone\CmsBundle\Entity\Page | No errors. |
| Flagstone\CmsBundle\Entity\PageCategory | No errors. |
| Flagstone\CmsBundle\Entity\Template | No errors. |
| Flagstone\CmsBundle\Entity\PageContentSeo | No errors. |
| Flagstone\CmsBundle\Entity\PageContent | No errors. |
| Flagstone\CmsBundle\Entity\PageExtraFieldContent | No errors. |
| Flagstone\CmsBundle\Entity\PageTranslation | No errors. |