1.65 ms (15.77%)
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.43 ms (13.66%)
3
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . first_seen_at > = ?
Parameters :
[
"2026-10-24 00:00:00 "
]
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . first_seen_at > = '2026-10-24 00:00:00' ;
Copy
1.17 ms (11.15%)
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
0.90 ms (8.53%)
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.82 ms (7.78%)
3
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 FROM actualite a0_ WHERE a0_ . id IN (? , ? , ? , ? ) ORDER BY a0_ . created_at DESC
Parameters :
[
72
71
66
65
]
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 FROM actualite a0_ WHERE a0_ . id IN (72 , 71 , 66 , 65 ) ORDER BY a0_ . created_at DESC ;
Copy
0.67 ms (6.42%)
1
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ ;
Copy
0.55 ms (5.26%)
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 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 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.52 ms (4.92%)
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 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 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.50 ms (4.73%)
1
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . last_seen_at > = ?
Parameters :
[
"2026-10-24 10:33:27 "
]
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . last_seen_at > = '2026-10-24 10:33:27' ;
Copy
0.39 ms (3.68%)
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 FROM actualite a0_ WHERE a0_ . ala_une = 1 AND a0_ . id < > ? ORDER BY a0_ . created_at DESC LIMIT 10
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 FROM actualite a0_ WHERE a0_ . ala_une = 1 AND a0_ . id < > 71 ORDER BY a0_ . created_at DESC LIMIT 10 ;
Copy
0.33 ms (3.14%)
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 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 FROM actualite a0_ WHERE a0_ . ala_une = 1 ORDER BY a0_ . id DESC LIMIT 1 ;
Copy
0.32 ms (3.03%)
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 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 "
71
]
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 FROM actualite a0_ INNER JOIN sous_thematique s1_ ON a0_ . sous_thematique_id = s1_ . id WHERE s1_ . libelle = 'Sport' AND a0_ . id < > 71 ORDER BY a0_ . created_at DESC LIMIT 4 ;
Copy
0.29 ms (2.75%)
1
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . first_seen_at AS first_seen_at_3 , t0 . last_seen_at AS last_seen_at_4 FROM visiteur t0 WHERE t0 . session_id = ? LIMIT 1
Parameters :
[
"sjff1rk095bhubqq6uhir7f0f8 "
]
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . first_seen_at AS first_seen_at_3 , t0 . last_seen_at AS last_seen_at_4 FROM visiteur t0 WHERE t0 . session_id = 'sjff1rk095bhubqq6uhir7f0f8' LIMIT 1 ;
Copy
0.24 ms (2.26%)
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 FROM actualite a0_ WHERE a0_ . id IN (? , ? ) ORDER BY a0_ . created_at DESC
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 FROM actualite a0_ WHERE a0_ . id IN (64 , 61 ) ORDER BY a0_ . created_at DESC ;
Copy
0.22 ms (2.08%)
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 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 FROM actualite a0_ WHERE a0_ . titre = 'CAN féminine 2026 : Les Lionnes Indomptables championnes d’Afrique' LIMIT 1 ;
Copy
0.21 ms (2.00%)
1
INSERT INTO visiteur (session_id , first_seen_at , last_seen_at ) VALUES (? , ? , ? )
Parameters :
[
"sjff1rk095bhubqq6uhir7f0f8 "
"2026-10-24 10:38:27 "
"2026-10-24 10:38:27 "
]
INSERT INTO visiteur (session_id , first_seen_at , last_seen_at ) VALUES ('sjff1rk095bhubqq6uhir7f0f8' , '2026-10-24 10:38:27' , '2026-10-24 10:38:27' );
Copy
0.15 ms (1.46%)
1
"START TRANSACTION"
"START TRANSACTION" ;
Copy
0.15 ms (1.39%)
1
"COMMIT"