1
0.53 ms
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
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 ;
Copy
2
0.60 ms
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
3
0.38 ms
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 :
[
"Aménagement du territoire "
]
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 = 'Aménagement du territoire' ORDER BY s0_ . libelle ASC ;
Copy
4
6.71 ms
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 :
[
"Environnement "
]
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 = 'Environnement' ORDER BY s0_ . libelle ASC ;
Copy
5
0.36 ms
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 :
[
"Institution "
]
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 = 'Institution' ORDER BY s0_ . libelle ASC ;
Copy
6
0.43 ms
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . created_at AS created_at_3 FROM thematique t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . created_at AS created_at_3 FROM thematique t0 WHERE t0 . id = 1 ;
Copy
7
1.15 ms
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . created_at AS created_at_3 FROM thematique t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . created_at AS created_at_3 FROM thematique t0 WHERE t0 . id = 3 ;
Copy
8
0.24 ms
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . created_at AS created_at_3 FROM thematique t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . libelle AS libelle_2 , t0 . created_at AS created_at_3 FROM thematique t0 WHERE t0 . id = 2 ;
Copy
9
2.31 ms
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . last_seen_at > = ?
Parameters :
[
"2026-11-17 18:52:02 "
]
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . last_seen_at > = '2026-11-17 18:52:02' ;
Copy
10
3.68 ms
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
11
2.55 ms
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . first_seen_at > = ?
Parameters :
[
"2026-11-01 00:00:00 "
]
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . first_seen_at > = '2026-11-01 00:00:00' ;
Copy
12
2.54 ms
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . first_seen_at > = ?
Parameters :
[
"2026-01-01 00:00:00 "
]
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ WHERE v0_ . first_seen_at > = '2026-01-01 00:00:00' ;
Copy
13
3.34 ms
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_
SELECT COUNT (v0_ . id ) AS sclr_0 FROM visiteur v0_ ;
Copy