Query Metrics
108
Database Queries
56
Different statements
14.99 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
7.03 ms (46.89%) |
48 |
SELECT a0_.id AS id_0, a0_.url AS url_1, a0_.title AS title_2, a0_.date AS date_3, a0_.vues AS vues_4, a0_.thumbnail AS thumbnail_5, a0_.categories AS categories_6, a0_.keywords AS keywords_7, a0_.tags AS tags_8, a0_.author AS author_9, a0_.description AS description_10 FROM article a0_ WHERE a0_.url = ?
Parameters:
[
"https://dane.ac-nancy-metz.fr/monbureaunumerique-ent/"
]
|
0.60 ms (4.00%) |
4 |
SELECT r0_.id AS id_0, r0_.user_id AS user_id_1, r0_.ordre AS ordre_2, r0_.cluster AS cluster_3, r0_.url AS url_4, r0_.score AS score_5, r0_.categorie_id AS categorie_id_6 FROM recommandation r0_ WHERE r0_.user_id = ? AND r0_.cluster = ? ORDER BY r0_.score DESC LIMIT 12
Parameters:
[ "mostpopular@ac-nancy-metz.fr" "0" ] |
0.52 ms (3.50%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2 FROM category t0
Parameters:
[] |
0.29 ms (1.91%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.nom_recherche AS nom_recherche_3, t0.category_id AS category_id_4 FROM sous_category t0
Parameters:
[] |
0.21 ms (1.43%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 635 ORDER BY c.date DESC
Parameters:
[] |
0.17 ms (1.12%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1291 ORDER BY c.date DESC
Parameters:
[] |
0.16 ms (1.09%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 261 ORDER BY c.date DESC
Parameters:
[] |
0.16 ms (1.07%) |
1 |
SELECT r0_.cluster AS cluster_0 FROM recommandation r0_ WHERE r0_.user_id = ? GROUP BY r0_.cluster LIMIT 4
Parameters:
[
"mostpopular@ac-nancy-metz.fr"
]
|
0.16 ms (1.07%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1133 ORDER BY c.date DESC
Parameters:
[] |
0.16 ms (1.04%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 813 ORDER BY c.date DESC
Parameters:
[] |
0.15 ms (1.02%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.choix_id AS choix_id_3 FROM requete t0
Parameters:
[] |
0.15 ms (0.98%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1132 ORDER BY c.date DESC
Parameters:
[] |
0.15 ms (0.98%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 695 ORDER BY c.date DESC
Parameters:
[] |
0.14 ms (0.95%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1800 ORDER BY c.date DESC
Parameters:
[] |
0.14 ms (0.94%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1138 ORDER BY c.date DESC
Parameters:
[] |
0.14 ms (0.92%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 731 ORDER BY c.date DESC
Parameters:
[] |
0.14 ms (0.91%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM choix t0
Parameters:
[] |
0.14 ms (0.91%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 32 ORDER BY c.date DESC
Parameters:
[] |
0.13 ms (0.89%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 758 ORDER BY c.date DESC
Parameters:
[] |
0.13 ms (0.89%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1704 ORDER BY c.date DESC
Parameters:
[] |
0.13 ms (0.85%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 759 ORDER BY c.date DESC
Parameters:
[] |
0.13 ms (0.85%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 692 ORDER BY c.date DESC
Parameters:
[] |
0.13 ms (0.84%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1080 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.81%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 824 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.81%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1256 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.80%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 811 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.80%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1301 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.80%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 757 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.79%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1304 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.79%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1564 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.79%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1707 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.79%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1705 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.78%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1371 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.78%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1670 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.77%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 893 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.77%) |
1 |
SELECT f.id, f.commentaire_id, f.renamed_name, f.extension FROM fichier f WHERE f.commentaire_id IN (2,1)
Parameters:
[] |
0.12 ms (0.77%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1708 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.77%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1702 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.76%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 999 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.75%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1653 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.75%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1706 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.75%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1153 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.74%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 947 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.74%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 994 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.74%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1136 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.73%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1137 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.73%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1621 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.73%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 685 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.73%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 60 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.73%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1820 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.72%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1134 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.71%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1150 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.71%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 540 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.71%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 474 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.71%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1135 ORDER BY c.date DESC
Parameters:
[] |
0.10 ms (0.69%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1652 ORDER BY c.date DESC
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\Category | No errors. |
App\Entity\SousCategory | No errors. |
App\Entity\Requete | No errors. |
App\Entity\Choix | No errors. |
App\Entity\Recommandation | No errors. |
App\Entity\Article | No errors. |
App\Entity\ArticlesFavoris | No errors. |
App\Entity\Commentaire | No errors. |