1
0.34 ms
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 WHERE t0 . id = ?
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 WHERE t0 . id = 2 ;
Copy
2
0.45 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.30 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
0.24 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.21 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.28 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . titre_en AS titre_en_3 , t0 . mot_cle AS mot_cle_4 , t0 . mot_cle_en AS mot_cle_en_5 , t0 . reference AS reference_6 , t0 . image1 AS image1_7 , t0 . image2 AS image2_8 , t0 . legende AS legende_9 , t0 . legende_en AS legende_en_10 , t0 . created_at AS created_at_11 , t0 . contenu AS contenu_12 , t0 . contenu_en AS contenu_en_13 , t0 . ala_une AS ala_une_14 , t0 . redacteur_id AS redacteur_id_15 , t0 . sous_thematique_id AS sous_thematique_id_16 , t0 . dossier_redaction_id AS dossier_redaction_id_17 FROM actualite t0 WHERE t0 . dossier_redaction_id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . titre_en AS titre_en_3 , t0 . mot_cle AS mot_cle_4 , t0 . mot_cle_en AS mot_cle_en_5 , t0 . reference AS reference_6 , t0 . image1 AS image1_7 , t0 . image2 AS image2_8 , t0 . legende AS legende_9 , t0 . legende_en AS legende_en_10 , t0 . created_at AS created_at_11 , t0 . contenu AS contenu_12 , t0 . contenu_en AS contenu_en_13 , t0 . ala_une AS ala_une_14 , t0 . redacteur_id AS redacteur_id_15 , t0 . sous_thematique_id AS sous_thematique_id_16 , t0 . dossier_redaction_id AS dossier_redaction_id_17 FROM actualite t0 WHERE t0 . dossier_redaction_id = 2 ;
Copy