Query Metrics
108
Database Queries
56
Different statements
18.26 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
8.89 ms (48.65%) |
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.95 ms (5.22%) |
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.46 ms (2.51%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2 FROM category t0
Parameters:
[] |
0.33 ms (1.79%) |
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.23 ms (1.25%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1080 ORDER BY c.date DESC
Parameters:
[] |
0.20 ms (1.08%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.choix_id AS choix_id_3 FROM requete t0
Parameters:
[] |
0.20 ms (1.07%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1800 ORDER BY c.date DESC
Parameters:
[] |
0.20 ms (1.07%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM choix t0
Parameters:
[] |
0.19 ms (1.06%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1136 ORDER BY c.date DESC
Parameters:
[] |
0.19 ms (1.01%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1820 ORDER BY c.date DESC
Parameters:
[] |
0.18 ms (0.98%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1707 ORDER BY c.date DESC
Parameters:
[] |
0.17 ms (0.96%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1652 ORDER BY c.date DESC
Parameters:
[] |
0.17 ms (0.95%) |
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.17 ms (0.92%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1135 ORDER BY c.date DESC
Parameters:
[] |
0.17 ms (0.91%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1702 ORDER BY c.date DESC
Parameters:
[] |
0.16 ms (0.90%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 813 ORDER BY c.date DESC
Parameters:
[] |
0.16 ms (0.90%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1706 ORDER BY c.date DESC
Parameters:
[] |
0.16 ms (0.89%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1705 ORDER BY c.date DESC
Parameters:
[] |
0.16 ms (0.89%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1670 ORDER BY c.date DESC
Parameters:
[] |
0.16 ms (0.89%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1132 ORDER BY c.date DESC
Parameters:
[] |
0.16 ms (0.88%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 474 ORDER BY c.date DESC
Parameters:
[] |
0.16 ms (0.86%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1653 ORDER BY c.date DESC
Parameters:
[] |
0.16 ms (0.85%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1138 ORDER BY c.date DESC
Parameters:
[] |
0.16 ms (0.85%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1564 ORDER BY c.date DESC
Parameters:
[] |
0.15 ms (0.84%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 695 ORDER BY c.date DESC
Parameters:
[] |
0.15 ms (0.83%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1708 ORDER BY c.date DESC
Parameters:
[] |
0.15 ms (0.82%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1137 ORDER BY c.date DESC
Parameters:
[] |
0.15 ms (0.82%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1134 ORDER BY c.date DESC
Parameters:
[] |
0.15 ms (0.81%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 261 ORDER BY c.date DESC
Parameters:
[] |
0.15 ms (0.81%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1153 ORDER BY c.date DESC
Parameters:
[] |
0.15 ms (0.81%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 999 ORDER BY c.date DESC
Parameters:
[] |
0.15 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.15 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.15 ms (0.80%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1371 ORDER BY c.date DESC
Parameters:
[] |
0.14 ms (0.79%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1704 ORDER BY c.date DESC
Parameters:
[] |
0.14 ms (0.78%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 692 ORDER BY c.date DESC
Parameters:
[] |
0.14 ms (0.78%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1304 ORDER BY c.date DESC
Parameters:
[] |
0.14 ms (0.77%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 759 ORDER BY c.date DESC
Parameters:
[] |
0.14 ms (0.76%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 994 ORDER BY c.date DESC
Parameters:
[] |
0.14 ms (0.75%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1133 ORDER BY c.date DESC
Parameters:
[] |
0.13 ms (0.73%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 947 ORDER BY c.date DESC
Parameters:
[] |
0.13 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.13 ms (0.73%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 757 ORDER BY c.date DESC
Parameters:
[] |
0.13 ms (0.70%) |
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.68%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 60 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.65%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 731 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.63%) |
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.62%) |
1 |
SELECT f.id, f.commentaire_id, f.renamed_name, f.extension FROM fichier f WHERE f.commentaire_id IN (2,1)
Parameters:
[] |
0.11 ms (0.62%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 32 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.59%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 893 ORDER BY c.date DESC
Parameters:
[] |
0.10 ms (0.57%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 685 ORDER BY c.date DESC
Parameters:
[] |
0.10 ms (0.57%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1291 ORDER BY c.date DESC
Parameters:
[] |
0.10 ms (0.56%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 758 ORDER BY c.date DESC
Parameters:
[] |
0.09 ms (0.51%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 811 ORDER BY c.date DESC
Parameters:
[] |
0.09 ms (0.49%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 540 ORDER BY c.date DESC
Parameters:
[] |
0.09 ms (0.48%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 635 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. |