Query Metrics
2
Database Queries
2
Different statements
18.84 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
15.72 ms (83.44%) |
1 |
SELECT c0_.name AS name_0, c0_.title AS title_1, c0_.link_name AS link_name_2, c0_.lvl AS lvl_3, c0_.sort_order AS sort_order_4, c0_.seo_id AS seo_id_5, c0_.content AS content_6, c0_.status AS status_7, c0_.lang AS lang_8, c0_.parent_id AS parent_id_9, c0_.config_data AS config_data_10, c0_.layout AS layout_11, c0_.redirect_url AS redirect_url_12, c0_.redirect_window AS redirect_window_13, c0_.icon AS icon_14, c0_.teaser AS teaser_15, c0_.p_search AS p_search_16, c0_.id AS id_17, c0_.visibility AS visibility_18, c0_.created_at AS created_at_19, c0_.edited_at AS edited_at_20, c0_.last_check_at AS last_check_at_21, c0_.next_check_at AS next_check_at_22, c0_.parent_id AS parent_id_23 FROM cms_page c0_ LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id AND c1_.item_type IN ('page') LEFT JOIN cms_language_info c2_ ON (c0_.id = c2_.entity_id AND c2_.entity_name = 'Page') WHERE c0_.seo_id = ? LIMIT 20
Parameters:
[
"robots.txt"
]
|
3.12 ms (16.56%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM cms_page c0_ LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id AND c1_.item_type IN ('page') LEFT JOIN cms_language_info c2_ ON (c0_.id = c2_.entity_id AND c2_.entity_name = 'Page') WHERE c0_.seo_id = ?
Parameters:
[
"robots.txt"
]
|
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 |
---|---|
App\Entity\Api\Page | No errors. |
Score\CmsBundle\Entity\Page\Page | No errors. |
Score\CmsBundle\Entity\Multisite\SiteItem | No errors. |
Score\CmsBundle\Entity\Multisite\SiteItemPage | No errors. |
App\Entity\LanguageInfo | No errors. |
Score\CmsBundle\Entity\Stat | No errors. |