Query Metrics
12
Database Queries
9
Different statements
23.88 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.72 ms |
SELECT p0_.value AS value_0 FROM param p0_ WHERE p0_.name = ?
Parameters:
[
"maintenance_mode"
]
|
2 | 3.45 ms |
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.slug = ? LIMIT 1
Parameters:
[
"le-cv-video"
]
|
3 | 1.32 ms |
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:
[] |
4 | 3.25 ms |
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"
]
|
5 | 3.15 ms |
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
]
|
6 | 2.53 ms |
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
]
|
7 | 0.56 ms |
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:
[
2
]
|
8 | 0.58 ms |
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:
[
3
]
|
9 | 0.52 ms |
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:
[
6
]
|
10 | 0.65 ms |
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:
[
17
]
|
11 | 2.00 ms |
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
]
|
12 | 3.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.color AS color_4 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?
Parameters:
[
6
]
|
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\Article | No errors. |
App\Entity\Media | No errors. |
App\Entity\User | No errors. |
App\Entity\Category | No errors. |
App\Entity\Comment | No errors. |
App\Entity\Menu | No errors. |
App\Entity\Page | No errors. |