Query Metrics
36
Database Queries
13
Different statements
44.34 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
8.29 ms (18.69%) |
10 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.layout AS layout_4, t0.content AS content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.local AS local_8 FROM section t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"home-title"
]
|
5.14 ms (11.59%) |
6 |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (NULL)
Parameters:
[] |
4.54 ms (10.24%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.is_home AS is_home_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6 FROM page p0_ WHERE p0_.is_home = ?
Parameters:
[
1
]
|
4.47 ms (10.08%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_order AS menu_order_3, t0.is_visible AS is_visible_4, t0.link AS link_5, t0.article_id AS article_id_6, t0.category_id AS category_id_7, t0.page_id AS page_id_8 FROM menu t0 INNER JOIN menu_menu ON t0.id = menu_menu.menu_target WHERE menu_menu.menu_source = ?
Parameters:
[
1
]
|
3.96 ms (8.94%) |
2 |
SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.name AS name_2, p0_.value AS value_3, p0_.type AS type_4, p0_.media_id AS media_id_5 FROM param p0_
Parameters:
[] |
3.54 ms (7.99%) |
1 |
SELECT p0_.value AS value_0 FROM param p0_ WHERE p0_.name = ?
Parameters:
[
"maintenance_mode"
]
|
3.32 ms (7.49%) |
1 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.menu_order AS menu_order_2, m0_.is_visible AS is_visible_3, m0_.link AS link_4, m0_.article_id AS article_id_5, m0_.category_id AS category_id_6, m0_.page_id AS page_id_7 FROM menu m0_ WHERE m0_.is_visible = ? ORDER BY m0_.menu_order ASC
Parameters:
[
1
]
|
3.28 ms (7.40%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_visible AS is_visible_4, t0.content AS content_5, t0.featured_text AS featured_text_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.featured_image_id AS featured_image_id_9, t0.author_id AS author_id_10 FROM article t0 WHERE t0.is_visible = ?
Parameters:
[
1
]
|
2.86 ms (6.44%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.public_name AS public_name_3, t0.roles AS roles_4, t0.password AS password_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
2.62 ms (5.92%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.alt_text AS alt_text_4, t0.created_at AS created_at_5 FROM media t0 WHERE t0.id = ?
Parameters:
[
13
]
|
1.27 ms (2.86%) |
3 |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (?)
Parameters:
[
32
]
|
0.68 ms (1.54%) |
1 |
SELECT m0_.filename AS filename_0 FROM param p1_ LEFT JOIN media m0_ ON (p1_.media_id = m0_.id) WHERE p1_.name = ?
Parameters:
[
"site_logo_light"
]
|
0.37 ms (0.82%) |
1 |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (?, ?, ?)
Parameters:
[ 19 24 31 ] |
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\Param | No errors. |
App\Entity\Page | No errors. |
App\Entity\Section | No errors. |
App\Entity\Media | No errors. |
App\Entity\Article | No errors. |
App\Entity\User | No errors. |
App\Entity\Category | No errors. |
App\Entity\Comment | No errors. |
App\Entity\Menu | No errors. |