GET https://www.accueil.cybersono.com/public/accueil

Query Metrics

18 Database Queries
12 Different statements
1.97 ms Query time
0 Invalid entities
28 Managed entities

Queries

Group similar statements

# Time Info
1 0.25 ms
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
Parameters:
[]
2 0.14 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.dateajout AS dateajout_3 FROM categorie t0
Parameters:
[]
3 0.09 ms
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
Parameters:
[]
4 0.16 ms
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 6
Parameters:
[]
5 0.07 ms
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
Parameters:
[]
6 0.06 ms
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 6
Parameters:
[]
7 0.09 ms
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 (?, ?, ?, ?)
Parameters:
[
  56
  51
  53
  54
]
8 0.05 ms
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
Parameters:
[]
9 0.07 ms
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 (?, ?, ?, ?, ?, ?)
Parameters:
[
  2
  7
  8
  4
  3
  10
]
10 0.40 ms
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
Parameters:
[
  "2026-05-25 15:52:36"
  "2026-05-25 15:52:36"
]
11 0.10 ms
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 FROM traducteur t0 WHERE t0.id = ?
Parameters:
[
  8
]
12 0.08 ms
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 FROM traducteur t0_ WHERE t0_.nom = ? AND t0_.prenom = ? AND t0_.id <> ?
Parameters:
[
  "Lass"
  "Lass"
  8
]
13 0.09 ms
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 FROM traducteur t0 WHERE t0.id = ?
Parameters:
[
  6
]
14 0.07 ms
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 FROM traducteur t0_ WHERE t0_.nom = ? AND t0_.prenom = ? AND t0_.id <> ?
Parameters:
[
  "Badial"
  "Badial"
  6
]
15 0.06 ms
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 FROM traducteur t0 WHERE t0.id = ?
Parameters:
[
  7
]
16 0.06 ms
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 FROM traducteur t0_ WHERE t0_.nom = ? AND t0_.prenom = ? AND t0_.id <> ?
Parameters:
[
  "Coulibaly"
  "Coulibaly"
  7
]
17 0.08 ms
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 FROM traducteur t0 WHERE t0.id = ?
Parameters:
[
  1
]
18 0.07 ms
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 FROM traducteur t0_ WHERE t0_.nom = ? AND t0_.prenom = ? AND t0_.id <> ?
Parameters:
[
  "CAMARA"
  "Papa"
  1
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Series 12
App\Entity\Categorie 6
App\Entity\Traducteur 5
App\Entity\Video 4
App\Entity\AlaUne 1

Entities Mapping

Class Mapping errors
App\Entity\Video No errors.
App\Entity\Categorie No errors.
App\Entity\Traducteur No errors.
App\Entity\Series No errors.
App\Entity\Episodes No errors.
App\Entity\AlaUne No errors.
App\Entity\LikeTraducteur No errors.
App\Entity\CommentaireTraducteur No errors.
App\Entity\NoteTraducteur No errors.