1.17 ms (10.28%)
|
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.28 ms (2.44%)
|
1 |
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 = 3;
|
0.22 ms (1.95%)
|
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 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 = 3;
|
0.22 ms (1.94%)
|
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom_utilisateur AS nom_utilisateur_5, t0.type AS type_6, t0.etat AS etat_7, t0.created_at AS created_at_8 FROM utilisateur t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom_utilisateur AS nom_utilisateur_5, t0.type AS type_6, t0.etat AS etat_7, t0.created_at AS created_at_8 FROM utilisateur t0 WHERE t0.id = 1;
|