Query Metrics
36
Database Queries
13
Different statements
44.34 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 3.54 ms |
SELECT p0_.value AS value_0 FROM param p0_ WHERE p0_.name = ?
Parameters:
[
"maintenance_mode"
]
|
2 | 4.54 ms |
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
]
|
3 | 4.03 ms |
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 | 3.45 ms |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (NULL)
Parameters:
[] |
5 | 0.74 ms |
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-presentation"
]
|
6 | 0.63 ms |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (?)
Parameters:
[
32
]
|
7 | 0.64 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:
[] |
8 | 0.40 ms |
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:
[
"contact-recruteur"
]
|
9 | 0.34 ms |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (NULL)
Parameters:
[] |
10 | 0.38 ms |
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-notre-metier"
]
|
11 | 0.32 ms |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (?)
Parameters:
[
29
]
|
12 | 0.39 ms |
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-testimonials"
]
|
13 | 0.37 ms |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (?, ?, ?)
Parameters:
[ 19 24 31 ] |
14 | 0.34 ms |
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-line"
]
|
15 | 0.30 ms |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (NULL)
Parameters:
[] |
16 | 0.38 ms |
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-services"
]
|
17 | 0.32 ms |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (?)
Parameters:
[
23
]
|
18 | 0.37 ms |
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:
[
"contact-recruteur"
]
|
19 | 0.30 ms |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (NULL)
Parameters:
[] |
20 | 0.37 ms |
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-blog"
]
|
21 | 0.30 ms |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (NULL)
Parameters:
[] |
22 | 3.28 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.is_visible = ?
Parameters:
[
1
]
|
23 | 0.86 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:
[
13
]
|
24 | 2.86 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
]
|
25 | 0.81 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:
[
14
]
|
26 | 0.48 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
]
|
27 | 0.47 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:
[
15
]
|
28 | 0.90 ms |
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:
[
"contact-candidat"
]
|
29 | 0.46 ms |
SELECT m0_.id AS id_0, m0_.filename AS filename_1 FROM media m0_ WHERE m0_.id IN (NULL)
Parameters:
[] |
30 | 3.33 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:
[] |
31 | 0.68 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"
]
|
32 | 3.32 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
]
|
33 | 2.66 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
]
|
34 | 0.65 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
]
|
35 | 0.59 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
]
|
36 | 0.57 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
]
|
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. |