Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.71 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.88 ms
(51.40%)

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

Parameters:

[
  "unbekannt/niederwerrn/neue-moderne-penthouse-wohnung-am-stadtrand-von-schweinfurt-niederwerrn-2111"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 'unbekannt/niederwerrn/neue-moderne-penthouse-wohnung-am-stadtrand-von-schweinfurt-niederwerrn-2111' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Repository\OnOffice\EstateRepository->findOneBySeoSlug (line 25)
5	App\Controller\WebsiteController->estateDetail (line 149)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 180)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.83 ms
(48.60%)

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:

[
  2111
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 2111 ORDER BY t0.sort_order ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\OnOffice\Estate->getTitleImage (line 241)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_4f75db11b92b833acef36cac9f994f9b::block_og_image (line 162)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_c8c08342c2ca98f8ccd5732cf4c39c6b->doDisplay (line 114)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_4f75db11b92b833acef36cac9f994f9b->doDisplay (line 66)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 458)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 277)
22	App\Controller\WebsiteController->estateDetail (line 167)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 180)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

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\Estate	1
App\Entity\OnOffice\EstateImage	1

Entities Mapping

Class	Mapping errors
App\Entity\OnOffice\Estate	No errors.
App\Entity\OnOffice\EstateImage	No errors.

Symfony Profiler

GET https://stage.vr-energie-immo.de/immobilien/unbekannt/niederwerrn/neue-moderne-penthouse-wohnung-am-stadtrand-von-schweinfurt-niederwerrn-2111

Configuration Settings

Theme

Page Width