Query Metrics
11
Database Queries
4
Different statements
13.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
7.15 ms (52.49%) |
8 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.visible AS visible_3, t0.parent_id AS parent_id_4, t0.sort_index AS sort_index_5, t0.type AS type_6, t0.content_id AS content_id_7, t0.lang AS lang_8, t0.external_url AS external_url_9 FROM menu t0 WHERE t0.lang = ? AND t0.parent_id = ? AND t0.visible = ? ORDER BY t0.sort_index ASC
Parameters:
[ "lv" 0 1 ]
|
||||||||||||||||||||||
|
4.26 ms (31.32%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.content AS content_4, t0.status AS status_5, t0.created AS created_6, t0.modified AS modified_7 FROM page t0 WHERE t0.lang = ? AND t0.id = ? LIMIT 1
Parameters:
[ "lv" 0 ]
|
||||||||||||||||||||||
|
1.15 ms (8.47%) |
1 |
SELECT l.*, m.content_id FROM link l LEFT JOIN menu m ON m.id=l.navigation_id WHERE l.lang='lv' ORDER BY l.sort_index ASC
Parameters:
[]
|
||||||||||||||||||||||
|
1.05 ms (7.73%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.modified AS modified_4, t0.lang AS lang_5, t0.status AS status_6, t0.title_image AS title_image_7, t0.intro AS intro_8, t0.body AS body_9, t0.title_image_aria_label AS title_image_aria_label_10, t0.title_image_alt_tag AS title_image_alt_tag_11 FROM news t0 WHERE t0.lang = ? AND t0.status = ? ORDER BY t0.modified DESC LIMIT 5
Parameters:
[ "lv" 1 ]
|
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\Menu | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\News | No errors. |