https://217.182.70.226/

Query Metrics

108 Database Queries
56 Different statements
14.99 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.