Symfony Profiler

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 = ?

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 = 'https://dane.ac-nancy-metz.fr/monbureaunumerique-ent/';

"COMMIT"

"COMMIT";

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

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 = 'mostpopular@ac-nancy-metz.fr' AND r0_.cluster = '0' ORDER BY r0_.score DESC LIMIT 12;

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

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 = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  category t0

SELECT t0.id AS id_1, t0.title AS title_2 FROM category t0;

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

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;

UPDATE
  indicateurs
SET
  nombre_recherche_moteur = ?
WHERE
  id = ?

UPDATE indicateurs SET nombre_recherche_moteur = 2213 WHERE id = 1;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 731
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 731
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1135
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1135
            ORDER BY c.date DESC;

SELECT
  r0_.cluster AS cluster_0
FROM
  recommandation r0_
WHERE
  r0_.user_id = ?
GROUP BY
  r0_.cluster
LIMIT
  4

SELECT r0_.cluster AS cluster_0 FROM recommandation r0_ WHERE r0_.user_id = 'mostpopular@ac-nancy-metz.fr' GROUP BY r0_.cluster LIMIT 4;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 32
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 32
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1652
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1652
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 635
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 635
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1564
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1564
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1653
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1653
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 994
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 994
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 811
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 811
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1704
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1704
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 695
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 695
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1153
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1153
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1707
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1707
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1706
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1706
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 757
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 757
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1670
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1670
            ORDER BY c.date DESC;

SELECT
  f.id,
  f.commentaire_id,
  f.renamed_name,
  f.extension
FROM
  fichier f
WHERE
  f.commentaire_id IN (2, 1)

SELECT f.id, f.commentaire_id, f.renamed_name, f.extension
                FROM fichier f
                WHERE f.commentaire_id IN (2,1);

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 685
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 685
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 60
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 60
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1291
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1291
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 813
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 813
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 759
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 759
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 474
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 474
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 947
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 947
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 261
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 261
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1621
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1621
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1150
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1150
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1702
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1702
            ORDER BY c.date DESC;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1800
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1800
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 540
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 540
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1705
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1705
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1371
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1371
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1304
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1304
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1133
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1133
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 692
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 692
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 758
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 758
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 824
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 824
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1136
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1136
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1137
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1137
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 999
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 999
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1708
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1708
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1820
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1820
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 893
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 893
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1256
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1256
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1132
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1132
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1134
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1134
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1301
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1301
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1080
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1080
            ORDER BY c.date DESC;

SELECT
  c.article_id,
  c.id
FROM
  commentaire c
WHERE
  c.article_id = 1138
ORDER BY
  c.date DESC

SELECT c.article_id, c.id
            FROM commentaire c
            WHERE c.article_id = 1138
            ORDER BY c.date DESC;