GET https://stage.vr-energie-immo.de/

Query Metrics

11 Database Queries
4 Different statements
6.73 ms Query time
0 Invalid entities
106 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.23 ms
(62.86%)
8
SELECT t0.id AS id_1, t0.onoffice_id AS onoffice_id_2, t0.content_hash AS content_hash_3, t0.url AS url_4, t0.thumbnail_url AS thumbnail_url_5, t0.title AS title_6, t0.description AS description_7, t0.type AS type_8, t0.sort_order AS sort_order_9, t0.width AS width_10, t0.height AS height_11, t0.original_name AS original_name_12, t0.modified_at AS modified_at_13, t0.estate_onoffice_id AS estate_onoffice_id_14 FROM onoffice_estate_image t0 WHERE t0.estate_onoffice_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  2159
]
1.11 ms
(16.41%)
1
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
Parameters:
[
  1
  1
  0
  0
]
0.77 ms
(11.51%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.bottom_description AS bottom_description_5, t0.sort_order AS sort_order_6, t0.access_counter AS access_counter_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.seo_title AS seo_title_10, t0.seo_description AS seo_description_11, t0.seo_keywords AS seo_keywords_12, t0.parent_id AS parent_id_13 FROM bytes_commerce_blog_category t0 INNER JOIN bytes_commerce_blog_post_category ON t0.id = bytes_commerce_blog_post_category.category_id WHERE bytes_commerce_blog_post_category.post_id = ?
Parameters:
[
  5
]
0.62 ms
(9.22%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.content AS content_4, t0.image AS image_5, t0.excerpt AS excerpt_6, t0.credits AS credits_7, t0.access_counter AS access_counter_8, t0.status AS status_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.seo_title AS seo_title_12, t0.seo_description AS seo_description_13, t0.seo_keywords AS seo_keywords_14 FROM bytes_commerce_blog_post t0 WHERE t0.status = ? ORDER BY t0.created_at DESC LIMIT 3
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\OnOffice\EstateImage 78
App\Entity\OnOffice\Estate 26
BytesCommerce\EasyBlog\Entity\Post 1
BytesCommerce\EasyBlog\Entity\Category 1