Symfony Profiler

SELECT
  v0_.id AS id_0,
  v0_.titre AS titre_1,
  v0_.video AS video_2,
  v0_.image AS image_3,
  v0_.description AS description_4,
  v0_.realisateur AS realisateur_5,
  v0_.producteur AS producteur_6,
  v0_.acteur AS acteur_7,
  v0_.annesortie AS annesortie_8,
  v0_.dateajout AS dateajout_9,
  v0_.titre_original AS titre_original_10,
  v0_.numero_partie AS numero_partie_11,
  v0_.categories AS categories_12,
  v0_.traducteur_id AS traducteur_id_13
FROM
  video v0_
WHERE
  v0_.titre_original = ?
ORDER BY
  v0_.numero_partie ASC

SELECT v0_.id AS id_0, v0_.titre AS titre_1, v0_.video AS video_2, v0_.image AS image_3, v0_.description AS description_4, v0_.realisateur AS realisateur_5, v0_.producteur AS producteur_6, v0_.acteur AS acteur_7, v0_.annesortie AS annesortie_8, v0_.dateajout AS dateajout_9, v0_.titre_original AS titre_original_10, v0_.numero_partie AS numero_partie_11, v0_.categories AS categories_12, v0_.traducteur_id AS traducteur_id_13 FROM video v0_ WHERE v0_.titre_original = 'HANUMAN' ORDER BY v0_.numero_partie ASC;

SELECT
  t0_.id AS id_0,
  t0_.nom AS nom_1,
  t0_.prenom AS prenom_2,
  t0_.email AS email_3,
  t0_.telephone AS telephone_4,
  t0_.photo AS photo_5,
  t0_.password AS password_6,
  t0_.deleted_at AS deleted_at_7
FROM
  traducteur t0_
WHERE
  t0_.nom = ?
  AND t0_.prenom = ?
  AND t0_.id <> ?

SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.prenom AS prenom_2, t0_.email AS email_3, t0_.telephone AS telephone_4, t0_.photo AS photo_5, t0_.password AS password_6, t0_.deleted_at AS deleted_at_7 FROM traducteur t0_ WHERE t0_.nom = 'Seydou Samaké' AND t0_.prenom = 'Badial' AND t0_.id <> 6;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.photo AS photo_6,
  t0.password AS password_7,
  t0.deleted_at AS deleted_at_8
FROM
  traducteur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.photo AS photo_6, t0.password AS password_7, t0.deleted_at AS deleted_at_8 FROM traducteur t0 WHERE t0.id = 6;

SELECT
  a0_.id AS id_0,
  a0_.type AS type_1,
  a0_.date_debut AS date_debut_2,
  a0_.date_expiration AS date_expiration_3,
  a0_.ordre AS ordre_4,
  a0_.actif AS actif_5,
  a0_.created_at AS created_at_6,
  a0_.video_id AS video_id_7,
  a0_.serie_id AS serie_id_8
FROM
  ala_une a0_
WHERE
  a0_.actif = 1
  AND a0_.date_debut <= ?
  AND (
    a0_.date_expiration IS NULL
    OR a0_.date_expiration > ?
  )
ORDER BY
  a0_.ordre ASC
LIMIT
  10

SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.date_debut AS date_debut_2, a0_.date_expiration AS date_expiration_3, a0_.ordre AS ordre_4, a0_.actif AS actif_5, a0_.created_at AS created_at_6, a0_.video_id AS video_id_7, a0_.serie_id AS serie_id_8 FROM ala_une a0_ WHERE a0_.actif = 1 AND a0_.date_debut <= '2026-09-20 23:54:51' AND (a0_.date_expiration IS NULL OR a0_.date_expiration > '2026-09-20 23:54:51') ORDER BY a0_.ordre ASC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.video AS video_3,
  t0.image AS image_4,
  t0.description AS description_5,
  t0.realisateur AS realisateur_6,
  t0.producteur AS producteur_7,
  t0.acteur AS acteur_8,
  t0.annesortie AS annesortie_9,
  t0.dateajout AS dateajout_10,
  t0.titre_original AS titre_original_11,
  t0.numero_partie AS numero_partie_12,
  t0.categories AS categories_13,
  t0.traducteur_id AS traducteur_id_14
FROM
  video t0

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.image AS image_4, t0.description AS description_5, t0.realisateur AS realisateur_6, t0.producteur AS producteur_7, t0.acteur AS acteur_8, t0.annesortie AS annesortie_9, t0.dateajout AS dateajout_10, t0.titre_original AS titre_original_11, t0.numero_partie AS numero_partie_12, t0.categories AS categories_13, t0.traducteur_id AS traducteur_id_14 FROM video t0;

SELECT
  t0.id AS id_1,
  t0.cle AS cle_2,
  t0.valeur AS valeur_3,
  t0.type AS type_4,
  t0.groupe AS groupe_5,
  t0.description AS description_6
FROM
  site_config t0

SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.type AS type_4, t0.groupe AS groupe_5, t0.description AS description_6 FROM site_config t0;

SELECT
  v0_.id AS id_0,
  v0_.titre AS titre_1,
  v0_.video AS video_2,
  v0_.image AS image_3,
  v0_.description AS description_4,
  v0_.realisateur AS realisateur_5,
  v0_.producteur AS producteur_6,
  v0_.acteur AS acteur_7,
  v0_.annesortie AS annesortie_8,
  v0_.dateajout AS dateajout_9,
  v0_.titre_original AS titre_original_10,
  v0_.numero_partie AS numero_partie_11,
  v0_.categories AS categories_12,
  v0_.traducteur_id AS traducteur_id_13
FROM
  video v0_
ORDER BY
  v0_.dateajout DESC
LIMIT
  30

SELECT v0_.id AS id_0, v0_.titre AS titre_1, v0_.video AS video_2, v0_.image AS image_3, v0_.description AS description_4, v0_.realisateur AS realisateur_5, v0_.producteur AS producteur_6, v0_.acteur AS acteur_7, v0_.annesortie AS annesortie_8, v0_.dateajout AS dateajout_9, v0_.titre_original AS titre_original_10, v0_.numero_partie AS numero_partie_11, v0_.categories AS categories_12, v0_.traducteur_id AS traducteur_id_13 FROM video v0_ ORDER BY v0_.dateajout DESC LIMIT 30;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.video AS video_3,
  t0.image AS image_4,
  t0.description AS description_5,
  t0.realisateur AS realisateur_6,
  t0.producteur AS producteur_7,
  t0.acteur AS acteur_8,
  t0.annesortie AS annesortie_9,
  t0.dateajout AS dateajout_10,
  t0.titre_original AS titre_original_11,
  t0.numero_partie AS numero_partie_12,
  t0.categories AS categories_13,
  t0.traducteur_id AS traducteur_id_14
FROM
  video t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.video AS video_3, t0.image AS image_4, t0.description AS description_5, t0.realisateur AS realisateur_6, t0.producteur AS producteur_7, t0.acteur AS acteur_8, t0.annesortie AS annesortie_9, t0.dateajout AS dateajout_10, t0.titre_original AS titre_original_11, t0.numero_partie AS numero_partie_12, t0.categories AS categories_13, t0.traducteur_id AS traducteur_id_14 FROM video t0 WHERE t0.id IN (65, 85, 77, 59, 119, 53, 94, 93, 115, 101, 111, 109, 120, 122, 121, 89, 79, 98);

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image_poster AS image_poster_3,
  t0.date_sortie AS date_sortie_4,
  t0.date_ajout AS date_ajout_5,
  t0.description AS description_6,
  t0.producteur AS producteur_7,
  t0.realisateur AS realisateur_8,
  t0.acteurs AS acteurs_9,
  t0.categorie_id AS categorie_id_10,
  t0.traducteur_id AS traducteur_id_11
FROM
  series t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image_poster AS image_poster_3, t0.date_sortie AS date_sortie_4, t0.date_ajout AS date_ajout_5, t0.description AS description_6, t0.producteur AS producteur_7, t0.realisateur AS realisateur_8, t0.acteurs AS acteurs_9, t0.categorie_id AS categorie_id_10, t0.traducteur_id AS traducteur_id_11 FROM series t0;

SELECT
  s0_.id AS id_0,
  s0_.nom AS nom_1,
  s0_.image_poster AS image_poster_2,
  s0_.date_sortie AS date_sortie_3,
  s0_.date_ajout AS date_ajout_4,
  s0_.description AS description_5,
  s0_.producteur AS producteur_6,
  s0_.realisateur AS realisateur_7,
  s0_.acteurs AS acteurs_8,
  s0_.categorie_id AS categorie_id_9,
  s0_.traducteur_id AS traducteur_id_10
FROM
  series s0_
ORDER BY
  s0_.date_ajout DESC
LIMIT
  6

SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.image_poster AS image_poster_2, s0_.date_sortie AS date_sortie_3, s0_.date_ajout AS date_ajout_4, s0_.description AS description_5, s0_.producteur AS producteur_6, s0_.realisateur AS realisateur_7, s0_.acteurs AS acteurs_8, s0_.categorie_id AS categorie_id_9, s0_.traducteur_id AS traducteur_id_10 FROM series s0_ ORDER BY s0_.date_ajout DESC LIMIT 6;

SELECT
  v.id,
  COUNT(h.id) as nb_vues
FROM
  video v
  LEFT JOIN historique h ON h.video_id = v.id
GROUP BY
  v.id
ORDER BY
  nb_vues DESC
LIMIT
  18

SELECT v.id, COUNT(h.id) as nb_vues
                FROM video v
                LEFT JOIN historique h ON h.video_id = v.id
                GROUP BY v.id
                ORDER BY nb_vues DESC
                LIMIT 18
            ;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image_poster AS image_poster_3,
  t0.date_sortie AS date_sortie_4,
  t0.date_ajout AS date_ajout_5,
  t0.description AS description_6,
  t0.producteur AS producteur_7,
  t0.realisateur AS realisateur_8,
  t0.acteurs AS acteurs_9,
  t0.categorie_id AS categorie_id_10,
  t0.traducteur_id AS traducteur_id_11
FROM
  series t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image_poster AS image_poster_3, t0.date_sortie AS date_sortie_4, t0.date_ajout AS date_ajout_5, t0.description AS description_6, t0.producteur AS producteur_7, t0.realisateur AS realisateur_8, t0.acteurs AS acteurs_9, t0.categorie_id AS categorie_id_10, t0.traducteur_id AS traducteur_id_11 FROM series t0 WHERE t0.id IN (17, 38, 15, 2, 8, 4);

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.dateajout AS dateajout_3
FROM
  categorie t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.dateajout AS dateajout_3 FROM categorie t0;

SELECT
  s.id,
  COUNT(h.id) as nb_vues
FROM
  series s
  LEFT JOIN historique h ON h.series_id = s.id
GROUP BY
  s.id
ORDER BY
  nb_vues DESC
LIMIT
  6

SELECT s.id, COUNT(h.id) as nb_vues
            FROM series s
            LEFT JOIN historique h ON h.series_id = s.id
            GROUP BY s.id
            ORDER BY nb_vues DESC
            LIMIT 6
        ;