Query Metrics

108 Database Queries
56 Different statements
15.22 ms Query time
0 Invalid entities
  • Grouped Statements
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Show all queries

Time Count Info
7.21 ms
(47.34%)
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:
0 of 0
[ "https://dane.ac-nancy-metz.fr/monbureaunumerique-ent/" ]
0.65 ms
(4.25%)
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:
0 of 0
[ "mostpopular@ac-nancy-metz.fr" "0" ]
0.48 ms
(3.14%)
2
SELECT t0.id AS id_1, t0.title AS title_2 FROM category t0
Parameters:
[]
0.33 ms
(2.14%)
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.51%)
1
SELECT r0_.cluster AS cluster_0 FROM recommandation r0_ WHERE r0_.user_id = ? GROUP BY r0_.cluster LIMIT 4
Parameters:
0 of 0
[ "mostpopular@ac-nancy-metz.fr" ]
0.19 ms
(1.25%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM choix t0
Parameters:
[]
0.17 ms
(1.14%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.choix_id AS choix_id_3 FROM requete t0
Parameters:
[]
0.17 ms
(1.09%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 60
            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 = 1133
            ORDER BY c.date DESC
Parameters:
[]
0.15 ms
(0.96%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1291
            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 = 1301
            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 = 1304
            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 = 692
            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 = 1564
            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 = 994
            ORDER BY c.date DESC
Parameters:
[]
0.14 ms
(0.91%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 685
            ORDER BY c.date DESC
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.14 ms
(0.91%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 824
            ORDER BY c.date DESC
Parameters:
[]
0.14 ms
(0.91%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1653
            ORDER BY c.date DESC
Parameters:
[]
0.14 ms
(0.90%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1256
            ORDER BY c.date DESC
Parameters:
[]
0.14 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.13 ms
(0.85%)
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.83%)
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.82%)
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.82%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 759
            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 = 1137
            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 = 1138
            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 = 1080
            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 = 758
            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 = 474
            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 = 757
            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 = 540
            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 = 695
            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 = 1707
            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 = 261
            ORDER BY c.date DESC
Parameters:
[]
0.12 ms
(0.76%)
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.76%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 893
            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.75%)
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.75%)
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.75%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1652
            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 = 1706
            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 = 1708
            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.72%)
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.72%)
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.71%)
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.70%)
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.70%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1800
            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 = 731
            ORDER BY c.date DESC
Parameters:
[]
0.10 ms
(0.68%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1150
            ORDER BY c.date DESC
Parameters:
[]
0.10 ms
(0.66%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1704
            ORDER BY c.date DESC
Parameters:
[]
0.10 ms
(0.66%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1705
            ORDER BY c.date DESC
Parameters:
[]
0.10 ms
(0.66%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1670
            ORDER BY c.date DESC
Parameters:
[]
0.10 ms
(0.66%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 999
            ORDER BY c.date DESC
Parameters:
[]
0.10 ms
(0.64%)
1
SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 813
            ORDER BY c.date DESC
Parameters:
[]