[
"sql" => "SELECT t0.id AS id_1, t0.warmmiete AS warmmiete_2, t0.nebenkosten AS nebenkosten_3, t0.heizkosten AS heizkosten_4, t0.wohnflaeche AS wohnflaeche_5, t0.grundstuecksflaeche AS grundstuecksflaeche_6, t0.anzahl_zimmer AS anzahl_zimmer_7, t0.anzahl_schlafzimmer AS anzahl_schlafzimmer_8, t0.anzahl_badezimmer AS anzahl_badezimmer_9, t0.endenergiebedarf AS endenergiebedarf_10, t0.energieverbrauchskennwert AS energieverbrauchskennwert_11, t0.objekttitel AS objekttitel_12, t0.objektbeschreibung AS objektbeschreibung_13, t0.lage AS lage_14, t0.ausstatt_beschr AS ausstatt_beschr_15, t0.sonstige_angaben AS sonstige_angaben_16, t0.kaufpreis AS kaufpreis_17, t0.mietpreis AS mietpreis_18, t0.nettokaltmiete AS nettokaltmiete_19, t0.kaltmiete AS kaltmiete_20, t0.waehrung AS waehrung_21, t0.aussen_courtage AS aussen_courtage_22, t0.strasse AS strasse_23, t0.hausnummer AS hausnummer_24, t0.plz AS plz_25, t0.ort AS ort_26, t0.bundesland AS bundesland_27, t0.land AS land_28, t0.breitengrad AS breitengrad_29, t0.laengengrad AS laengengrad_30, t0.vermarktungsart AS vermarktungsart_31, t0.nutzungsart AS nutzungsart_32, t0.objektart AS objektart_33, t0.objekttyp AS objekttyp_34, t0.zustand AS zustand_35, t0.baujahr AS baujahr_36, t0.is_active AS is_active_37, t0.is_sold AS is_sold_38, t0.is_reserved AS is_reserved_39, t0.is_published AS is_published_40, t0.energieausweistyp AS energieausweistyp_41, t0.energy_class AS energy_class_42, t0.energieausweis_baujahr AS energieausweis_baujahr_43, t0.seo_slug AS seo_slug_44, t0.stadt_slug AS stadt_slug_45, t0.erstellt_am AS erstellt_am_46, t0.geaendert_am AS geaendert_am_47, t0.created_at AS created_at_48, t0.updated_at AS updated_at_49 FROM onoffice_estate t0 WHERE t0.seo_slug = ? LIMIT 1"
"params" => [
1 => "unbekannt/burkardroth-waldfenster/vermietetes-wohnhaus-mit-3-wohneinheiten-2053"
]
"types" => [
1 => Doctrine\DBAL\ParameterType {#1500
+name: "STRING"
}
]
]