Query Metrics
29
Database Queries
4
Different statements
11.98 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.33 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.subtitle AS subtitle_2, a0_.creation_date AS creation_date_3, a0_.publication_date AS publication_date_4, a0_.source AS source_5, a0_.img_url AS img_url_6, a0_.texte AS texte_7, a0_.extrait AS extrait_8, a0_.is_pro AS is_pro_9, a0_.etat AS etat_10, a0_.slug AS slug_11, a0_.is_public AS is_public_12, a0_.external_link AS external_link_13, a0_.external_id AS external_id_14, a0_.id_admin_id AS id_admin_id_15, a0_.user_id AS user_id_16 FROM article a0_ WHERE a0_.is_pro IN (?) AND a0_.etat = ? ORDER BY a0_.publication_date DESC LIMIT 4
Parameters:
[
[
0
2
]
0
]
|
| 2 | 0.63 ms |
SELECT t0.id AS id_1, t0.id_article_id AS id_article_id_2, t0.id_categorie_id AS id_categorie_id_3 FROM article_categorie t0 WHERE t0.id_article_id = ?
Parameters:
[
406
]
|
| 3 | 0.29 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
21
]
|
| 4 | 0.34 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 5 | 0.29 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
181
]
|
| 6 | 0.31 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
87
]
|
| 7 | 0.26 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
13
]
|
| 8 | 0.27 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
340
]
|
| 9 | 0.39 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
25
]
|
| 10 | 0.48 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
75
]
|
| 11 | 0.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.birthdate AS birthdate_4, t0.mail AS mail_5, t0.password AS password_6, t0.pin AS pin_7, t0.id_profil_id AS id_profil_id_8 FROM administrateur t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[] |
| 12 | 0.56 ms |
SELECT t0.id AS id_1, t0.id_article_id AS id_article_id_2, t0.id_categorie_id AS id_categorie_id_3 FROM article_categorie t0 WHERE t0.id_article_id = ?
Parameters:
[
407
]
|
| 13 | 0.34 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
238
]
|
| 14 | 0.49 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
270
]
|
| 15 | 0.41 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
341
]
|
| 16 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.birthdate AS birthdate_4, t0.mail AS mail_5, t0.password AS password_6, t0.pin AS pin_7, t0.id_profil_id AS id_profil_id_8 FROM administrateur t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[] |
| 17 | 0.43 ms |
SELECT t0.id AS id_1, t0.id_article_id AS id_article_id_2, t0.id_categorie_id AS id_categorie_id_3 FROM article_categorie t0 WHERE t0.id_article_id = ?
Parameters:
[
408
]
|
| 18 | 0.31 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
342
]
|
| 19 | 0.28 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
343
]
|
| 20 | 0.28 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 21 | 0.26 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
344
]
|
| 22 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.birthdate AS birthdate_4, t0.mail AS mail_5, t0.password AS password_6, t0.pin AS pin_7, t0.id_profil_id AS id_profil_id_8 FROM administrateur t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[] |
| 23 | 0.42 ms |
SELECT t0.id AS id_1, t0.id_article_id AS id_article_id_2, t0.id_categorie_id AS id_categorie_id_3 FROM article_categorie t0 WHERE t0.id_article_id = ?
Parameters:
[
404
]
|
| 24 | 0.49 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
157
]
|
| 25 | 0.32 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
158
]
|
| 26 | 0.42 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
228
]
|
| 27 | 0.41 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
333
]
|
| 28 | 0.36 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
107
]
|
| 29 | 0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.birthdate AS birthdate_4, t0.mail AS mail_5, t0.password AS password_6, t0.pin AS pin_7, t0.id_profil_id AS id_profil_id_8 FROM administrateur t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[] |
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\Article | No errors. |
| App\Entity\Administrateur | No errors. |
| App\Entity\AccessControl\AccessUser | No errors. |
| App\Entity\ArticleCategorie | No errors. |
| App\Entity\ArticleTag | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\PageCategorie | No errors. |
| App\Entity\Profil | No errors. |