1.22 ms (10.02%)
|
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;
|
0.91 ms (7.50%)
|
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 INNER JOIN thematique t2_ ON s1_.thematique_id = t2_.id WHERE t2_.libelle LIKE ? ORDER BY a0_.created_at DESC
Parameters: [
"Aménagement%"
]
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 INNER JOIN thematique t2_ ON s1_.thematique_id = t2_.id WHERE t2_.libelle LIKE 'Aménagement%' ORDER BY a0_.created_at DESC;
|
0.74 ms (6.07%)
|
3 |
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 WHERE t0.thematique_id = ? ORDER BY t0.created_at DESC LIMIT 3
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 WHERE t0.thematique_id = 1 ORDER BY t0.created_at DESC LIMIT 3;
|