[
"sql" => "SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.slug AS slug_2, c0_.resume AS resume_3, c0_.ordre AS ordre_4, c0_.statut AS statut_5, c0_.nombre_lectures AS nombre_lectures_6, c0_.contenu_recherche AS contenu_recherche_7, c0_.date_creation AS date_creation_8, c0_.date_maj AS date_maj_9, c0_.supprime_le AS supprime_le_10, m1_.id AS id_11, m1_.nom AS nom_12, m1_.langue AS langue_13, m1_.ordre AS ordre_14, s2_.id AS id_15, s2_.nom AS nom_16, s2_.ordre AS ordre_17, n3_.id AS id_18, n3_.code AS code_19, n3_.ordre AS ordre_20, f4_.id AS id_21, f4_.nom AS nom_22, f4_.ordre AS ordre_23, c0_.module_id AS module_id_24, m1_.semestre_id AS semestre_id_25, s2_.niveau_id AS niveau_id_26, s2_.filiere_id AS filiere_id_27, f4_.niveau_id AS niveau_id_28 FROM cours c0_ INNER JOIN module m1_ ON c0_.module_id = m1_.id INNER JOIN semestre s2_ ON m1_.semestre_id = s2_.id INNER JOIN niveau n3_ ON s2_.niveau_id = n3_.id LEFT JOIN filiere f4_ ON s2_.filiere_id = f4_.id WHERE (c0_.statut = ? AND n3_.id = ?) AND (c0_.supprime_le IS NULL) ORDER BY n3_.ordre ASC, s2_.ordre ASC, m1_.ordre ASC, c0_.ordre ASC, c0_.titre ASC"
"params" => [
1 => "publie"
2 => 5
]
"types" => [
1 => Doctrine\DBAL\ParameterType {#1030
+name: "STRING"
}
2 => Doctrine\DBAL\ParameterType {#950
+name: "INTEGER"
}
]
]