Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT MIN(p0_.amount) AS sclr_0, MAX(p0_.amount) AS sclr_1, p0_.currency AS currency_2 FROM payment_product p0_ WHERE p0_.certificate_type = ? AND p0_.active = 1 GROUP BY p0_.currency

[
  "verbrauchsausweis"
]

SELECT
  MIN(p0_.amount) AS sclr_0,
  MAX(p0_.amount) AS sclr_1,
  p0_.currency AS currency_2
FROM
  payment_product p0_
WHERE
  p0_.certificate_type = ?
  AND p0_.active = 1
GROUP BY
  p0_.currency

SELECT MIN(p0_.amount) AS sclr_0, MAX(p0_.amount) AS sclr_1, p0_.currency AS currency_2 FROM payment_product p0_ WHERE p0_.certificate_type = 'verbrauchsausweis' AND p0_.active = 1 GROUP BY p0_.currency;

SELECT MIN(p0_.amount) AS sclr_0, MAX(p0_.amount) AS sclr_1, p0_.currency AS currency_2 FROM payment_product p0_ WHERE p0_.certificate_type = ? AND p0_.active = 1 GROUP BY p0_.currency

[
  "bedarfsausweis"
]

SELECT
  MIN(p0_.amount) AS sclr_0,
  MAX(p0_.amount) AS sclr_1,
  p0_.currency AS currency_2
FROM
  payment_product p0_
WHERE
  p0_.certificate_type = ?
  AND p0_.active = 1
GROUP BY
  p0_.currency

SELECT MIN(p0_.amount) AS sclr_0, MAX(p0_.amount) AS sclr_1, p0_.currency AS currency_2 FROM payment_product p0_ WHERE p0_.certificate_type = 'bedarfsausweis' AND p0_.active = 1 GROUP BY p0_.currency;

SELECT o0_.id AS id_0, o0_.warmmiete AS warmmiete_1, o0_.nebenkosten AS nebenkosten_2, o0_.heizkosten AS heizkosten_3, o0_.wohnflaeche AS wohnflaeche_4, o0_.grundstuecksflaeche AS grundstuecksflaeche_5, o0_.anzahl_zimmer AS anzahl_zimmer_6, o0_.anzahl_schlafzimmer AS anzahl_schlafzimmer_7, o0_.anzahl_badezimmer AS anzahl_badezimmer_8, o0_.endenergiebedarf AS endenergiebedarf_9, o0_.energieverbrauchskennwert AS energieverbrauchskennwert_10, o0_.objekttitel AS objekttitel_11, o0_.objektbeschreibung AS objektbeschreibung_12, o0_.lage AS lage_13, o0_.ausstatt_beschr AS ausstatt_beschr_14, o0_.sonstige_angaben AS sonstige_angaben_15, o0_.kaufpreis AS kaufpreis_16, o0_.mietpreis AS mietpreis_17, o0_.nettokaltmiete AS nettokaltmiete_18, o0_.kaltmiete AS kaltmiete_19, o0_.waehrung AS waehrung_20, o0_.aussen_courtage AS aussen_courtage_21, o0_.strasse AS strasse_22, o0_.hausnummer AS hausnummer_23, o0_.plz AS plz_24, o0_.ort AS ort_25, o0_.bundesland AS bundesland_26, o0_.land AS land_27, o0_.breitengrad AS breitengrad_28, o0_.laengengrad AS laengengrad_29, o0_.vermarktungsart AS vermarktungsart_30, o0_.nutzungsart AS nutzungsart_31, o0_.objektart AS objektart_32, o0_.objekttyp AS objekttyp_33, o0_.zustand AS zustand_34, o0_.baujahr AS baujahr_35, o0_.is_active AS is_active_36, o0_.is_sold AS is_sold_37, o0_.is_reserved AS is_reserved_38, o0_.is_published AS is_published_39, o0_.energieausweistyp AS energieausweistyp_40, o0_.energy_class AS energy_class_41, o0_.energieausweis_baujahr AS energieausweis_baujahr_42, o0_.seo_slug AS seo_slug_43, o0_.stadt_slug AS stadt_slug_44, o0_.erstellt_am AS erstellt_am_45, o0_.geaendert_am AS geaendert_am_46, o0_.created_at AS created_at_47, o0_.updated_at AS updated_at_48 FROM onoffice_estate o0_ WHERE o0_.is_active = ? AND o0_.is_published = ? AND o0_.is_sold = ? AND o0_.is_reserved = ? ORDER BY o0_.created_at DESC

[
  1
  1
  0
  0
]

SELECT
  o0_.id AS id_0,
  o0_.warmmiete AS warmmiete_1,
  o0_.nebenkosten AS nebenkosten_2,
  o0_.heizkosten AS heizkosten_3,
  o0_.wohnflaeche AS wohnflaeche_4,
  o0_.grundstuecksflaeche AS grundstuecksflaeche_5,
  o0_.anzahl_zimmer AS anzahl_zimmer_6,
  o0_.anzahl_schlafzimmer AS anzahl_schlafzimmer_7,
  o0_.anzahl_badezimmer AS anzahl_badezimmer_8,
  o0_.endenergiebedarf AS endenergiebedarf_9,
  o0_.energieverbrauchskennwert AS energieverbrauchskennwert_10,
  o0_.objekttitel AS objekttitel_11,
  o0_.objektbeschreibung AS objektbeschreibung_12,
  o0_.lage AS lage_13,
  o0_.ausstatt_beschr AS ausstatt_beschr_14,
  o0_.sonstige_angaben AS sonstige_angaben_15,
  o0_.kaufpreis AS kaufpreis_16,
  o0_.mietpreis AS mietpreis_17,
  o0_.nettokaltmiete AS nettokaltmiete_18,
  o0_.kaltmiete AS kaltmiete_19,
  o0_.waehrung AS waehrung_20,
  o0_.aussen_courtage AS aussen_courtage_21,
  o0_.strasse AS strasse_22,
  o0_.hausnummer AS hausnummer_23,
  o0_.plz AS plz_24,
  o0_.ort AS ort_25,
  o0_.bundesland AS bundesland_26,
  o0_.land AS land_27,
  o0_.breitengrad AS breitengrad_28,
  o0_.laengengrad AS laengengrad_29,
  o0_.vermarktungsart AS vermarktungsart_30,
  o0_.nutzungsart AS nutzungsart_31,
  o0_.objektart AS objektart_32,
  o0_.objekttyp AS objekttyp_33,
  o0_.zustand AS zustand_34,
  o0_.baujahr AS baujahr_35,
  o0_.is_active AS is_active_36,
  o0_.is_sold AS is_sold_37,
  o0_.is_reserved AS is_reserved_38,
  o0_.is_published AS is_published_39,
  o0_.energieausweistyp AS energieausweistyp_40,
  o0_.energy_class AS energy_class_41,
  o0_.energieausweis_baujahr AS energieausweis_baujahr_42,
  o0_.seo_slug AS seo_slug_43,
  o0_.stadt_slug AS stadt_slug_44,
  o0_.erstellt_am AS erstellt_am_45,
  o0_.geaendert_am AS geaendert_am_46,
  o0_.created_at AS created_at_47,
  o0_.updated_at AS updated_at_48
FROM
  onoffice_estate o0_
WHERE
  o0_.is_active = ?
  AND o0_.is_published = ?
  AND o0_.is_sold = ?
  AND o0_.is_reserved = ?
ORDER BY
  o0_.created_at DESC

SELECT o0_.id AS id_0, o0_.warmmiete AS warmmiete_1, o0_.nebenkosten AS nebenkosten_2, o0_.heizkosten AS heizkosten_3, o0_.wohnflaeche AS wohnflaeche_4, o0_.grundstuecksflaeche AS grundstuecksflaeche_5, o0_.anzahl_zimmer AS anzahl_zimmer_6, o0_.anzahl_schlafzimmer AS anzahl_schlafzimmer_7, o0_.anzahl_badezimmer AS anzahl_badezimmer_8, o0_.endenergiebedarf AS endenergiebedarf_9, o0_.energieverbrauchskennwert AS energieverbrauchskennwert_10, o0_.objekttitel AS objekttitel_11, o0_.objektbeschreibung AS objektbeschreibung_12, o0_.lage AS lage_13, o0_.ausstatt_beschr AS ausstatt_beschr_14, o0_.sonstige_angaben AS sonstige_angaben_15, o0_.kaufpreis AS kaufpreis_16, o0_.mietpreis AS mietpreis_17, o0_.nettokaltmiete AS nettokaltmiete_18, o0_.kaltmiete AS kaltmiete_19, o0_.waehrung AS waehrung_20, o0_.aussen_courtage AS aussen_courtage_21, o0_.strasse AS strasse_22, o0_.hausnummer AS hausnummer_23, o0_.plz AS plz_24, o0_.ort AS ort_25, o0_.bundesland AS bundesland_26, o0_.land AS land_27, o0_.breitengrad AS breitengrad_28, o0_.laengengrad AS laengengrad_29, o0_.vermarktungsart AS vermarktungsart_30, o0_.nutzungsart AS nutzungsart_31, o0_.objektart AS objektart_32, o0_.objekttyp AS objekttyp_33, o0_.zustand AS zustand_34, o0_.baujahr AS baujahr_35, o0_.is_active AS is_active_36, o0_.is_sold AS is_sold_37, o0_.is_reserved AS is_reserved_38, o0_.is_published AS is_published_39, o0_.energieausweistyp AS energieausweistyp_40, o0_.energy_class AS energy_class_41, o0_.energieausweis_baujahr AS energieausweis_baujahr_42, o0_.seo_slug AS seo_slug_43, o0_.stadt_slug AS stadt_slug_44, o0_.erstellt_am AS erstellt_am_45, o0_.geaendert_am AS geaendert_am_46, o0_.created_at AS created_at_47, o0_.updated_at AS updated_at_48 FROM onoffice_estate o0_ WHERE o0_.is_active = 1 AND o0_.is_published = 1 AND o0_.is_sold = 0 AND o0_.is_reserved = 0 ORDER BY o0_.created_at DESC;