Query Metrics
110
Database Queries
58
Different statements
18.47 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
7.44 ms (40.27%) |
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/"
]
|
1.47 ms (7.96%) |
1 |
"COMMIT"
Parameters:
[] |
0.75 ms (4.05%) |
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.60 ms (3.23%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2 FROM category t0
Parameters:
[] |
0.50 ms (2.69%) |
1 |
SELECT t0.id AS id_1, t0.visite_pj AS visite_pj_2, t0.visites_t AS visites_t_3, t0.nombre_reco_suivit AS nombre_reco_suivit_4, t0.nombre_recherche_moteur AS nombre_recherche_moteur_5, t0.nombres_acces_thematiques AS nombres_acces_thematiques_6, t0.nombres_utilisateurs_actifs AS nombres_utilisateurs_actifs_7, t0.nombre_de_connexion_max AS nombre_de_connexion_max_8 FROM indicateurs t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
0.45 ms (2.44%) |
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.43 ms (2.32%) |
1 |
UPDATE indicateurs SET nombre_recherche_moteur = ? WHERE id = ?
Parameters:
[ 2221 1 ] |
0.28 ms (1.50%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 540 ORDER BY c.date DESC
Parameters:
[] |
0.24 ms (1.29%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 32 ORDER BY c.date DESC
Parameters:
[] |
0.18 ms (0.99%) |
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.18 ms (0.98%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 60 ORDER BY c.date DESC
Parameters:
[] |
0.18 ms (0.97%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 685 ORDER BY c.date DESC
Parameters:
[] |
0.17 ms (0.92%) |
1 |
SELECT f.id, f.commentaire_id, f.renamed_name, f.extension FROM fichier f WHERE f.commentaire_id IN (2,1)
Parameters:
[] |
0.17 ms (0.90%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1301 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 = 813 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 = 1708 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 = 999 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 = 824 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 = 1133 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 = 758 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 = 811 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 = 1137 ORDER BY c.date DESC
Parameters:
[] |
0.14 ms (0.74%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1134 ORDER BY c.date DESC
Parameters:
[] |
0.14 ms (0.74%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 731 ORDER BY c.date DESC
Parameters:
[] |
0.13 ms (0.72%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1291 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 = 1702 ORDER BY c.date DESC
Parameters:
[] |
0.13 ms (0.69%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 635 ORDER BY c.date DESC
Parameters:
[] |
0.13 ms (0.68%) |
1 |
"START TRANSACTION"
Parameters:
[] |
0.12 ms (0.67%) |
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.67%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1800 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.66%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1706 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 = 1138 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 = 1621 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.64%) |
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.64%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 695 ORDER BY c.date DESC
Parameters:
[] |
0.12 ms (0.64%) |
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.64%) |
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.64%) |
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.63%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1704 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 = 1707 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 = 1135 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 = 1564 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.62%) |
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.61%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1304 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.61%) |
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.61%) |
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.60%) |
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.60%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1132 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.60%) |
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.60%) |
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.60%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 692 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 = 261 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.58%) |
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.58%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1371 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.57%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1256 ORDER BY c.date DESC
Parameters:
[] |
0.11 ms (0.57%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1652 ORDER BY c.date DESC
Parameters:
[] |
0.10 ms (0.55%) |
1 |
SELECT c.article_id, c.id FROM commentaire c WHERE c.article_id = 1820 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\Indicateurs | No errors. |
App\Entity\Recommandation | No errors. |
App\Entity\Article | No errors. |
App\Entity\ArticlesFavoris | No errors. |
App\Entity\Commentaire | No errors. |