Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.06 ms Query time

1 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.35 ms
(82.52%)

SELECT t0.id AS id_1, t0.cadastral_id AS cadastral_id_2, ST_AsText(t0.multipolygon_moldref) AS multipolygon_moldref_3, ST_AsText(t0.multipolygon) AS multipolygon_4, ST_AsText(t0.centroid) AS centroid_5, t0.land_area AS land_area_6, t0.name AS name_7, t0.rcslug AS rcslug_8, t0.address AS address_9, t0.instagram_reel_id AS instagram_reel_id_10, t0.price_per_square_meter AS price_per_square_meter_11, t0.completion_date AS completion_date_12, t0.is_sold_out AS is_sold_out_13, t0.client_status AS client_status_14, t0.server_status AS server_status_15, t0.views AS views_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19, t0.locality_id AS locality_id_20 FROM ax_residential_complex t0 WHERE t0.client_status = ? AND t0.server_status = ? ORDER BY t0.name ASC

Parameters:

[
  "active"
  "ok"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cadastral_id AS cadastral_id_2,
  ST_AsText(t0.multipolygon_moldref) AS multipolygon_moldref_3,
  ST_AsText(t0.multipolygon) AS multipolygon_4,
  ST_AsText(t0.centroid) AS centroid_5,
  t0.land_area AS land_area_6,
  t0.name AS name_7,
  t0.rcslug AS rcslug_8,
  t0.address AS address_9,
  t0.instagram_reel_id AS instagram_reel_id_10,
  t0.price_per_square_meter AS price_per_square_meter_11,
  t0.completion_date AS completion_date_12,
  t0.is_sold_out AS is_sold_out_13,
  t0.client_status AS client_status_14,
  t0.server_status AS server_status_15,
  t0.views AS views_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.company_id AS company_id_19,
  t0.locality_id AS locality_id_20
FROM
  ax_residential_complex t0
WHERE
  t0.client_status = ?
  AND t0.server_status = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.cadastral_id AS cadastral_id_2, ST_AsText(t0.multipolygon_moldref) AS multipolygon_moldref_3, ST_AsText(t0.multipolygon) AS multipolygon_4, ST_AsText(t0.centroid) AS centroid_5, t0.land_area AS land_area_6, t0.name AS name_7, t0.rcslug AS rcslug_8, t0.address AS address_9, t0.instagram_reel_id AS instagram_reel_id_10, t0.price_per_square_meter AS price_per_square_meter_11, t0.completion_date AS completion_date_12, t0.is_sold_out AS is_sold_out_13, t0.client_status AS client_status_14, t0.server_status AS server_status_15, t0.views AS views_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19, t0.locality_id AS locality_id_20 FROM ax_residential_complex t0 WHERE t0.client_status = 'active' AND t0.server_status = 'ok' ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\ResidentialComplexController->listResidentialComplexesOnMap (line 41)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.56 ms
(13.76%)

SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2 FROM ax_district a0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.slug AS slug_1,
  a0_.name AS name_2
FROM
  ax_district a0_

SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2 FROM ax_district a0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 454)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
23	App\Controller\ResidentialComplexController->listResidentialComplexesOnMap (line 43)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 191)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.15 ms
(3.72%)

SELECT COUNT(a0_.id) AS sclr_0 FROM ax_residential_complex a0_ WHERE a0_.client_status = ? AND a0_.server_status = ?

Parameters:

[
  "active"
  "ok"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  ax_residential_complex a0_
WHERE
  a0_.client_status = ?
  AND a0_.server_status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM ax_residential_complex a0_ WHERE a0_.client_status = 'active' AND a0_.server_status = 'ok';

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\ResidentialComplexRepository->countActiveResidentialComplexes (line 213)
8	App\Controller\ResidentialComplexController->listResidentialComplexesOnMap (line 44)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	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

Entities Mapping

Class	Mapping errors
App\Entity\District	No errors.
App\Entity\ResidentialComplex	The association App\Entity\ResidentialComplex#properties refers to the owning side field App\Entity\Property#residentialComplex which does not exist. The association App\Entity\ResidentialComplex#properties is ordered by a foreign field cadastralId that is not a field on the target entity App\Entity\Property.
App\Entity\Company	No errors.
App\Entity\Locality	No errors.

Symfony Profiler

GET https://imobiliare.n46.net/en/residential-complexes-on-map

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping