Symfony Profiler

Query Metrics

30 Database Queries

5 Different statements

17.39 ms Query time

0 Invalid entities

351 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.74 ms
(73.24%)

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
]

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 = 2159 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_02454cfb7afa9e98cd9a58f066903f36::doDisplay (line 108)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_14c356b508d8d83fbbe1bbef2aa87f23->block_body (line 557)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_c8c08342c2ca98f8ccd5732cf4c39c6b->doDisplay (line 304)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_14c356b508d8d83fbbe1bbef2aa87f23->doDisplay (line 66)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 458)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 463)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 277)
24	App\Controller\WebsiteController->immobilien (line 81)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 180)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

1.82 ms
(10.49%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\OnOffice\EstateRepository->findByFilters (line 125)
7	App\Controller\WebsiteController->immobilien (line 75)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 180)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.09 ms
(6.25%)

SELECT DISTINCT o0_.objektart AS objektart_0 FROM onoffice_estate o0_ WHERE o0_.objektart IS NOT NULL AND o0_.objektart <> ? AND o0_.is_published = ? AND o0_.is_sold = ? AND o0_.is_reserved = ? ORDER BY o0_.objektart ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.objektart AS objektart_0
FROM
  onoffice_estate o0_
WHERE
  o0_.objektart IS NOT NULL
  AND o0_.objektart <> ?
  AND o0_.is_published = ?
  AND o0_.is_sold = ?
  AND o0_.is_reserved = ?
ORDER BY
  o0_.objektart ASC

SELECT DISTINCT o0_.objektart AS objektart_0 FROM onoffice_estate o0_ WHERE o0_.objektart IS NOT NULL AND o0_.objektart <> '' AND o0_.is_published = 1 AND o0_.is_sold = 0 AND o0_.is_reserved = 0 ORDER BY o0_.objektart ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\OnOffice\EstateRepository->findDistinctObjektArten (line 142)
7	App\Controller\WebsiteController->immobilien (line 77)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 180)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.92 ms
(5.26%)

SELECT DISTINCT o0_.ort AS ort_0 FROM onoffice_estate o0_ WHERE o0_.ort IS NOT NULL AND o0_.ort <> ? AND o0_.is_published = ? AND o0_.is_sold = ? AND o0_.is_reserved = ? ORDER BY o0_.ort ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.ort AS ort_0
FROM
  onoffice_estate o0_
WHERE
  o0_.ort IS NOT NULL
  AND o0_.ort <> ?
  AND o0_.is_published = ?
  AND o0_.is_sold = ?
  AND o0_.is_reserved = ?
ORDER BY
  o0_.ort ASC

SELECT DISTINCT o0_.ort AS ort_0 FROM onoffice_estate o0_ WHERE o0_.ort IS NOT NULL AND o0_.ort <> '' AND o0_.is_published = 1 AND o0_.is_sold = 0 AND o0_.is_reserved = 0 ORDER BY o0_.ort ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\OnOffice\EstateRepository->findDistinctOrte (line 161)
7	App\Controller\WebsiteController->immobilien (line 78)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 180)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.83 ms
(4.76%)

SELECT DISTINCT o0_.vermarktungsart AS vermarktungsart_0 FROM onoffice_estate o0_ WHERE o0_.vermarktungsart IS NOT NULL AND o0_.vermarktungsart <> ? AND o0_.is_published = ? AND o0_.is_sold = ? AND o0_.is_reserved = ? ORDER BY o0_.vermarktungsart ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.vermarktungsart AS vermarktungsart_0
FROM
  onoffice_estate o0_
WHERE
  o0_.vermarktungsart IS NOT NULL
  AND o0_.vermarktungsart <> ?
  AND o0_.is_published = ?
  AND o0_.is_sold = ?
  AND o0_.is_reserved = ?
ORDER BY
  o0_.vermarktungsart ASC

SELECT DISTINCT o0_.vermarktungsart AS vermarktungsart_0 FROM onoffice_estate o0_ WHERE o0_.vermarktungsart IS NOT NULL AND o0_.vermarktungsart <> '' AND o0_.is_published = 1 AND o0_.is_sold = 0 AND o0_.is_reserved = 0 ORDER BY o0_.vermarktungsart ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\OnOffice\EstateRepository->findDistinctVermarktungsarten (line 191)
7	App\Controller\WebsiteController->immobilien (line 79)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 180)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	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\EstateImage	325
App\Entity\OnOffice\Estate	26

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping