Query Metrics
4
Database Queries
4
Different statements
4.12 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.85 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.label AS label_3, t0.type AS type_4, t0.slug AS slug_5, t0.target AS target_6, t0.publish_status AS publish_status_7, t0.published_at AS published_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.position AS position_11, t0.lft AS lft_12, t0.lvl AS lvl_13, t0.rgt AS rgt_14, t0.content AS content_15, t0.template_path AS template_path_16, t0.tree_root AS tree_root_17, t0.page_id AS page_id_18 FROM gesof_simplecms__page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"faq"
]
|
2 | 1.98 ms |
SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.description AS description_2, g0_.url AS url_3, g0_.taxonomy AS taxonomy_4, g0_.created_at AS created_at_5, g0_.updated_at AS updated_at_6, g0_.layout AS layout_7, g0_.position AS position_8, g0_.lft AS lft_9, g0_.lvl AS lvl_10, g0_.rgt AS rgt_11, g0_.image_name AS image_name_12, g0_.image_original_name AS image_original_name_13, g0_.image_mime_type AS image_mime_type_14, g0_.image_size AS image_size_15, g0_.image_dimensions AS image_dimensions_16, g0_.page_id AS page_id_17, g0_.tree_root AS tree_root_18, g0_.page_id AS page_id_19 FROM gesof_simplecms__content_item g1_, gesof_simplecms__content_item g0_ WHERE g0_.lvl = 0 AND g0_.page_id = ? ORDER BY g0_.tree_root ASC, g0_.lft ASC
Parameters:
[
3
]
|
3 | 0.67 ms |
SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.description AS description_2, g0_.url AS url_3, g0_.taxonomy AS taxonomy_4, g0_.created_at AS created_at_5, g0_.updated_at AS updated_at_6, g0_.layout AS layout_7, g0_.position AS position_8, g0_.lft AS lft_9, g0_.lvl AS lvl_10, g0_.rgt AS rgt_11, g0_.image_name AS image_name_12, g0_.image_original_name AS image_original_name_13, g0_.image_mime_type AS image_mime_type_14, g0_.image_size AS image_size_15, g0_.image_dimensions AS image_dimensions_16 FROM gesof_simplecms__content_item g0_ WHERE g0_.rgt < 16 AND g0_.lft > 1 AND g0_.tree_root = ? ORDER BY g0_.tree_root ASC, g0_.lft ASC
Parameters:
[
3
]
|
4 | 0.62 ms |
SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.label AS label_2, g0_.type AS type_3, g0_.slug AS slug_4, g0_.target AS target_5, g0_.publish_status AS publish_status_6, g0_.published_at AS published_at_7, g0_.created_at AS created_at_8, g0_.updated_at AS updated_at_9, g0_.position AS position_10, g0_.lft AS lft_11, g0_.lvl AS lvl_12, g0_.rgt AS rgt_13, g0_.content AS content_14, g0_.template_path AS template_path_15, g0_.tree_root AS tree_root_16, g0_.page_id AS page_id_17 FROM gesof_simplecms__page g0_ WHERE g0_.page_id IS NULL ORDER BY g0_.lft ASC
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 |
---|---|
Gesof\SimpleCMSBundle\Entity\Page | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |
Gesof\SimpleCMSBundle\Entity\ContentItem | No errors. |