Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.96 ms Query time

1 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.71 ms
(93.65%)

SELECT a0_.id AS id_0, a0_.cadastral_id AS cadastral_id_1, ST_AsText(a0_.multipolygon_moldref) AS multipolygon_moldref_2, ST_AsText(a0_.multipolygon) AS multipolygon_3, ST_AsText(a0_.centroid) AS centroid_4, a0_.land_area AS land_area_5, a0_.name AS name_6, a0_.rcslug AS rcslug_7, a0_.address AS address_8, a0_.instagram_reel_id AS instagram_reel_id_9, a0_.price_per_square_meter AS price_per_square_meter_10, a0_.completion_date AS completion_date_11, a0_.is_sold_out AS is_sold_out_12, a0_.client_status AS client_status_13, a0_.server_status AS server_status_14, a0_.views AS views_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.company_id AS company_id_18, a0_.locality_id AS locality_id_19 FROM ax_residential_complex a0_ WHERE a0_.client_status = ? AND a0_.server_status = ? ORDER BY a0_.name ASC LIMIT 10

Parameters:

[
  "active"
  "ok"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.cadastral_id AS cadastral_id_1,
  ST_AsText(a0_.multipolygon_moldref) AS multipolygon_moldref_2,
  ST_AsText(a0_.multipolygon) AS multipolygon_3,
  ST_AsText(a0_.centroid) AS centroid_4,
  a0_.land_area AS land_area_5,
  a0_.name AS name_6,
  a0_.rcslug AS rcslug_7,
  a0_.address AS address_8,
  a0_.instagram_reel_id AS instagram_reel_id_9,
  a0_.price_per_square_meter AS price_per_square_meter_10,
  a0_.completion_date AS completion_date_11,
  a0_.is_sold_out AS is_sold_out_12,
  a0_.client_status AS client_status_13,
  a0_.server_status AS server_status_14,
  a0_.views AS views_15,
  a0_.created_at AS created_at_16,
  a0_.updated_at AS updated_at_17,
  a0_.company_id AS company_id_18,
  a0_.locality_id AS locality_id_19
FROM
  ax_residential_complex a0_
WHERE
  a0_.client_status = ?
  AND a0_.server_status = ?
ORDER BY
  a0_.name ASC
LIMIT
  10

SELECT a0_.id AS id_0, a0_.cadastral_id AS cadastral_id_1, ST_AsText(a0_.multipolygon_moldref) AS multipolygon_moldref_2, ST_AsText(a0_.multipolygon) AS multipolygon_3, ST_AsText(a0_.centroid) AS centroid_4, a0_.land_area AS land_area_5, a0_.name AS name_6, a0_.rcslug AS rcslug_7, a0_.address AS address_8, a0_.instagram_reel_id AS instagram_reel_id_9, a0_.price_per_square_meter AS price_per_square_meter_10, a0_.completion_date AS completion_date_11, a0_.is_sold_out AS is_sold_out_12, a0_.client_status AS client_status_13, a0_.server_status AS server_status_14, a0_.views AS views_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.company_id AS company_id_18, a0_.locality_id AS locality_id_19 FROM ax_residential_complex a0_ WHERE a0_.client_status = 'active' AND a0_.server_status = 'ok' ORDER BY a0_.name ASC LIMIT 10;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 151)
7	App\Pagination\Paginator->paginate (line 56)
8	App\Repository\ResidentialComplexRepository->findAllOrderByName (line 61)
9	App\Controller\ResidentialComplexController->listResidentialComplexes (line 62)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.14 ms
(3.48%)

SELECT count(*) 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(*) AS sclr_0
FROM
  ax_residential_complex a0_
WHERE
  a0_.client_status = ?
  AND a0_.server_status = ?

SELECT count(*) 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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	App\Pagination\Paginator->paginate (line 57)
8	App\Repository\ResidentialComplexRepository->findAllOrderByName (line 61)
9	App\Controller\ResidentialComplexController->listResidentialComplexes (line 62)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.11 ms
(2.88%)

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->listResidentialComplexes (line 64)
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)

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/ro/ansambluri-rezidentiale

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping