6.76 ms (34.77%)
3
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . first_seen_at > = ?
Parameters :
[
"2026-11-17 00:00:00 "
]
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . first_seen_at > = '2026-11-17 00:00:00' ;
Copy
2.07 ms (10.67%)
1
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ ;
Copy
1.82 ms (9.35%)
5
SELECT id FROM (
SELECT a . id , a . created_at ,
ROW_NUMBER () OVER (
PARTITION BY a . sous_thematique_id
ORDER BY a . created_at DESC
) AS rn
FROM actualite a
INNER JOIN sous_thematique st ON st . id = a . sous_thematique_id
WHERE st . thematique_id = ?
) ranked
WHERE rn < = ?
ORDER BY created_at DESC
LIMIT ?
SELECT id FROM (
SELECT a . id , a . created_at ,
ROW_NUMBER () OVER (
PARTITION BY a . sous_thematique_id
ORDER BY a . created_at DESC
) AS rn
FROM actualite a
INNER JOIN sous_thematique st ON st . id = a . sous_thematique_id
WHERE st . thematique_id = 1
) ranked
WHERE rn < = 2
ORDER BY created_at DESC
LIMIT 4
;
Copy
1.73 ms (8.92%)
1
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . last_seen_at > = ?
Parameters :
[
"2026-11-16 23:56:17 "
]
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . last_seen_at > = '2026-11-16 23:56:17' ;
Copy
1.12 ms (5.76%)
4
SELECT s0_ . id AS id_0 , s0_ . libelle AS libelle_1 , s0_ . created_at AS created_at_2 , s0_ . thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_ . thematique_id = t1_ . id WHERE t1_ . libelle = ? ORDER BY s0_ . libelle ASC
Parameters :
[
"Urbanisme "
]
SELECT s0_ . id AS id_0 , s0_ . libelle AS libelle_1 , s0_ . created_at AS created_at_2 , s0_ . thematique_id AS thematique_id_3 FROM sous_thematique s0_ INNER JOIN thematique t1_ ON s0_ . thematique_id = t1_ . id WHERE t1_ . libelle = 'Urbanisme' ORDER BY s0_ . libelle ASC ;
Copy
1.06 ms (5.43%)
4
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_ . id IN (? , ? , ? , ? ) ORDER BY a0_ . created_at DESC
Parameters :
[
117
115
111
109
]
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_ . id IN (117 , 115 , 111 , 109 ) ORDER BY a0_ . created_at DESC ;
Copy
0.88 ms (4.55%)
5
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . created_at AS created_at_3 FROM thematique t0 WHERE t0 . libelle = ? LIMIT 1
Parameters :
[
"Urbanisme "
]
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . created_at AS created_at_3 FROM thematique t0 WHERE t0 . libelle = 'Urbanisme' LIMIT 1 ;
Copy
0.65 ms (3.35%)
2
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_ . sous_thematique_id = s1_ . id WHERE s1_ . libelle = ? ORDER BY a0_ . created_at DESC LIMIT 10
Parameters :
[
"Numérique "
]
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_ . sous_thematique_id = s1_ . id WHERE s1_ . libelle = 'Numérique' ORDER BY a0_ . created_at DESC LIMIT 10 ;
Copy
0.56 ms (2.90%)
2
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_ . sous_thematique_id = s1_ . id WHERE s1_ . libelle = ? ORDER BY a0_ . id DESC LIMIT 2 OFFSET 1
Parameters :
[
"Economie "
]
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_ . sous_thematique_id = s1_ . id WHERE s1_ . libelle = 'Economie' ORDER BY a0_ . id DESC LIMIT 2 OFFSET 1 ;
Copy
0.48 ms (2.47%)
1
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_ . sous_thematique_id = s1_ . id WHERE s1_ . libelle = ? AND a0_ . id < > ? ORDER BY a0_ . created_at DESC LIMIT 4
Parameters :
[
"Sport "
117
]
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_ . sous_thematique_id = s1_ . id WHERE s1_ . libelle = 'Sport' AND a0_ . id < > 117 ORDER BY a0_ . created_at DESC LIMIT 4 ;
Copy
0.48 ms (2.47%)
2
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_ . sous_thematique_id = s1_ . id WHERE s1_ . libelle = ? ORDER BY a0_ . id DESC LIMIT 1
Parameters :
[
"Economie "
]
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_ . sous_thematique_id = s1_ . id WHERE s1_ . libelle = 'Economie' ORDER BY a0_ . id DESC LIMIT 1 ;
Copy
0.45 ms (2.30%)
1
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_ . ala_une = 1 AND a0_ . id < > ? ORDER BY a0_ . created_at DESC LIMIT 14
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_ . ala_une = 1 AND a0_ . id < > 117 ORDER BY a0_ . created_at DESC LIMIT 14 ;
Copy
0.38 ms (1.94%)
1
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_ . ala_une = 1 ORDER BY a0_ . id DESC LIMIT 1
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_ . ala_une = 1 ORDER BY a0_ . id DESC LIMIT 1 ;
Copy
0.27 ms (1.39%)
1
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . titre_en AS titre_en_3 , t0 . contenu AS contenu_4 , t0 . contenu_en AS contenu_en_5 , t0 . image AS image_6 , t0 . legende AS legende_7 , t0 . legende_en AS legende_en_8 , t0 . created_at AS created_at_9 , t0 . thematique_id AS thematique_id_10 FROM problemes t0 ORDER BY t0 . created_at DESC LIMIT 10
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . titre_en AS titre_en_3 , t0 . contenu AS contenu_4 , t0 . contenu_en AS contenu_en_5 , t0 . image AS image_6 , t0 . legende AS legende_7 , t0 . legende_en AS legende_en_8 , t0 . created_at AS created_at_9 , t0 . thematique_id AS thematique_id_10 FROM problemes t0 ORDER BY t0 . created_at DESC LIMIT 10 ;
Copy
0.27 ms (1.37%)
1
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_ . titre = ? LIMIT 1
Parameters :
[
"CAN féminine 2026 : Les Lionnes Indomptables championnes d’Afrique "
]
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_ . titre = 'CAN féminine 2026 : Les Lionnes Indomptables championnes d’Afrique' LIMIT 1 ;
Copy
0.23 ms (1.19%)
1
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_ . id IN (? , ? , ? ) ORDER BY a0_ . created_at DESC
Parameters :
[
100
99
62
]
SELECT a0_ . id AS id_0 , a0_ . titre AS titre_1 , a0_ . titre_en AS titre_en_2 , a0_ . mot_cle AS mot_cle_3 , a0_ . mot_cle_en AS mot_cle_en_4 , a0_ . reference AS reference_5 , a0_ . image1 AS image1_6 , a0_ . image2 AS image2_7 , a0_ . legende AS legende_8 , a0_ . legende_en AS legende_en_9 , a0_ . created_at AS created_at_10 , a0_ . contenu AS contenu_11 , a0_ . contenu_en AS contenu_en_12 , a0_ . ala_une AS ala_une_13 , a0_ . redacteur_id AS redacteur_id_14 , a0_ . sous_thematique_id AS sous_thematique_id_15 , a0_ . dossier_redaction_id AS dossier_redaction_id_16 FROM actualite a0_ WHERE a0_ . id IN (100 , 99 , 62 ) ORDER BY a0_ . created_at DESC ;
Copy
0.22 ms (1.14%)
1
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . image AS image_3 , t0 . description AS description_4 , t0 . created_at AS created_at_5 FROM dossier_redaction t0 ORDER BY t0 . id DESC LIMIT 4
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . image AS image_3 , t0 . description AS description_4 , t0 . created_at AS created_at_5 FROM dossier_redaction t0 ORDER BY t0 . id DESC LIMIT 4 ;
Copy