Query Metrics
36
Database Queries
13
Different statements
52.72 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
10.16 ms (19.28%) |
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"
]
|
7.25 ms (13.75%) |
6 |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (NULL)
Parameters:
[] |
5.86 ms (11.13%) |
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
]
|
5.78 ms (10.96%) |
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
]
|
4.56 ms (8.66%) |
1 |
SELECT p0_.value AS value_0 FROM param p0_ WHERE p0_.name = ?
Parameters:
[
"maintenance_mode"
]
|
4.33 ms (8.21%) |
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
]
|
3.73 ms (7.07%) |
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
]
|
3.38 ms (6.41%) |
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.88 ms (5.46%) |
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
]
|
2.01 ms (3.82%) |
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:
[] |
1.56 ms (2.95%) |
3 |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (?)
Parameters:
[
32
]
|
0.73 ms (1.38%) |
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.49 ms (0.93%) |
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. |