Query Metrics
53
Database Queries
6
Different statements
7.16 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.05 ms (84.46%) |
46 |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"api_token"
]
|
0.37 ms (5.10%) |
2 |
SELECT t0.id AS id_1, t0.category AS category_2, t0.unique_slug AS unique_slug_3, t0.name AS name_4, t0.content AS content_5, t0.is_visible AS is_visible_6 FROM cms_pages t0 WHERE t0.category = ? AND t0.is_visible = ?
Parameters:
[ "game" 1 ] |
0.27 ms (3.79%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM cms_news_category t0 WHERE t0.id = ?
Parameters:
[
2
]
|
0.21 ms (2.93%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.date AS date_4, t0.author AS author_5, t0.img_url AS img_url_6, t0.slug AS slug_7, t0.category_id AS category_id_8 FROM cms_news t0 ORDER BY t0.id DESC LIMIT 2
Parameters:
[] |
0.14 ms (1.99%) |
1 |
SELECT t0.id AS id_1, t0.id_item AS id_item_2, t0.price AS price_3, t0.forceddescription AS forceddescription_4, t0.quantity AS quantity_5, t0.promotion AS promotion_6, t0.visible AS visible_7, t0.name AS name_8, t0.image AS image_9 FROM cms_shop t0 WHERE t0.visible = ? ORDER BY t0.id DESC LIMIT 2
Parameters:
[
true
]
|
0.12 ms (1.73%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.date AS date_4, t0.author AS author_5, t0.img_url AS img_url_6, t0.slug AS slug_7, t0.category_id AS category_id_8 FROM cms_news t0 ORDER BY t0.id DESC LIMIT 5
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 |
---|---|
App\Entity\CmsSettings | No errors. |
App\Entity\CmsShop | No errors. |
App\Entity\CmsNews | No errors. |
App\Entity\CmsNewsCategory | No errors. |
App\Entity\CmsPages | No errors. |