Query Metrics
36
Database Queries
13
Different statements
30.55 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.89 ms (22.56%) |
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"
]
|
4.13 ms (13.53%) |
1 |
SELECT p0_.value AS value_0 FROM param p0_ WHERE p0_.name = ?
Parameters:
[
"maintenance_mode"
]
|
3.46 ms (11.32%) |
6 |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (NULL)
Parameters:
[] |
3.04 ms (9.94%) |
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.69 ms (8.81%) |
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
]
|
2.10 ms (6.86%) |
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
]
|
1.88 ms (6.15%) |
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
]
|
1.73 ms (5.66%) |
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.52 ms (4.99%) |
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
]
|
1.17 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.15 ms (3.75%) |
3 |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (?)
Parameters:
[
32
]
|
0.41 ms (1.34%) |
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.39 ms (1.29%) |
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. |