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
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 ;
Copy
2
0.14 ms
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 ;
Copy
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
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 ;
Copy
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
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 ;
Copy
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
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 ;
Copy
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
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
;
Copy
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
]
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 (56 , 51 , 53 , 54 );
Copy
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
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
;
Copy
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
]
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 (2 , 7 , 8 , 4 , 3 , 10 );
Copy
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 "
]
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-05-25 15:52:36' AND (a0_ . date_expiration IS NULL OR a0_ . date_expiration > '2026-05-25 15:52:36' ) ORDER BY a0_ . ordre ASC LIMIT 10 ;
Copy
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 = ?
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 = 8 ;
Copy
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
]
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 = 'Lass' AND t0_ . prenom = 'Lass' AND t0_ . id < > 8 ;
Copy
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 = ?
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 = 6 ;
Copy
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
]
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 = 'Badial' AND t0_ . prenom = 'Badial' AND t0_ . id < > 6 ;
Copy
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 = ?
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 = 7 ;
Copy
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
]
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 = 'Coulibaly' AND t0_ . prenom = 'Coulibaly' AND t0_ . id < > 7 ;
Copy
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 = ?
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 = 1 ;
Copy
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
]
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 = 'CAMARA' AND t0_ . prenom = 'Papa' AND t0_ . id < > 1 ;
Copy