Symfony Profiler

Query Metrics

33 Database Queries

10 Different statements

4.79 ms Query time

0 Invalid entities

109 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.11 ms
(23.16%)

SELECT t0.id AS id_1, t0.lat AS lat_2, t0.lng AS lng_3, t0.formatted_address AS formatted_address_4, t0.created_at AS created_at_5, t0.residential_complex_id AS residential_complex_id_6 FROM ax_residential_complex_image t0 WHERE t0.residential_complex_id = ? ORDER BY t0.created_at ASC

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lat AS lat_2,
  t0.lng AS lng_3,
  t0.formatted_address AS formatted_address_4,
  t0.created_at AS created_at_5,
  t0.residential_complex_id AS residential_complex_id_6
FROM
  ax_residential_complex_image t0
WHERE
  t0.residential_complex_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.lat AS lat_2, t0.lng AS lng_3, t0.formatted_address AS formatted_address_4, t0.created_at AS created_at_5, t0.residential_complex_id AS residential_complex_id_6 FROM ax_residential_complex_image t0 WHERE t0.residential_complex_id = 6 ORDER BY t0.created_at 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 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	count (line 184)
9	App\Controller\ResidentialComplexController::getPointFeatureCollection (line 184)
10	App\Controller\ResidentialComplexController->listResidentialComplexesByDistrict (line 114)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

0.93 ms
(19.50%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.business_type AS business_type_4, t0.nin AS nin_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.domain AS domain_8, t0.email AS email_9, t0.website AS website_10, t0.facebook_page AS facebook_page_11, t0.instagram_username AS instagram_username_12, t0.xcorp_username AS xcorp_username_13, t0.youtube_handle AS youtube_handle_14, t0.cslug AS cslug_15, t0.street AS street_16, t0.postal_code AS postal_code_17, t0.phone_number AS phone_number_18, t0.username AS username_19, t0.password AS password_20, t0.client_status AS client_status_21, t0.server_status AS server_status_22, t0.phone_status AS phone_status_23, t0.lat AS lat_24, t0.lng AS lng_25, t0.roles AS roles_26, t0.views AS views_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.language_id AS language_id_30, t0.locality_id AS locality_id_31 FROM ax_company t0 WHERE t0.id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.legal_name AS legal_name_3,
  t0.business_type AS business_type_4,
  t0.nin AS nin_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.domain AS domain_8,
  t0.email AS email_9,
  t0.website AS website_10,
  t0.facebook_page AS facebook_page_11,
  t0.instagram_username AS instagram_username_12,
  t0.xcorp_username AS xcorp_username_13,
  t0.youtube_handle AS youtube_handle_14,
  t0.cslug AS cslug_15,
  t0.street AS street_16,
  t0.postal_code AS postal_code_17,
  t0.phone_number AS phone_number_18,
  t0.username AS username_19,
  t0.password AS password_20,
  t0.client_status AS client_status_21,
  t0.server_status AS server_status_22,
  t0.phone_status AS phone_status_23,
  t0.lat AS lat_24,
  t0.lng AS lng_25,
  t0.roles AS roles_26,
  t0.views AS views_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.language_id AS language_id_30,
  t0.locality_id AS locality_id_31
FROM
  ax_company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.business_type AS business_type_4, t0.nin AS nin_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.domain AS domain_8, t0.email AS email_9, t0.website AS website_10, t0.facebook_page AS facebook_page_11, t0.instagram_username AS instagram_username_12, t0.xcorp_username AS xcorp_username_13, t0.youtube_handle AS youtube_handle_14, t0.cslug AS cslug_15, t0.street AS street_16, t0.postal_code AS postal_code_17, t0.phone_number AS phone_number_18, t0.username AS username_19, t0.password AS password_20, t0.client_status AS client_status_21, t0.server_status AS server_status_22, t0.phone_status AS phone_status_23, t0.lat AS lat_24, t0.lng AS lng_25, t0.roles AS roles_26, t0.views AS views_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.language_id AS language_id_30, t0.locality_id AS locality_id_31 FROM ax_company t0 WHERE t0.id = 10;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Company::getCslug (line 403)
5	App\Controller\ResidentialComplexController->getPointFeatureCollection (line 190)
6	App\Controller\ResidentialComplexController->listResidentialComplexesByDistrict (line 114)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.91 ms
(18.91%)

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_ INNER JOIN ax_locality a1_ ON a0_.locality_id = a1_.id INNER JOIN ax_district a2_ ON a1_.district_id = a2_.id WHERE a0_.locality_id = a1_.id AND a1_.district_id = ? AND a0_.client_status = ? AND a0_.server_status = ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.name ASC

Parameters:

[
  "01"
  "active"
  "ok"
  6
  5
  8
  2
  3
  11
  9
  10
  7
  1
]

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_
  INNER JOIN ax_locality a1_ ON a0_.locality_id = a1_.id
  INNER JOIN ax_district a2_ ON a1_.district_id = a2_.id
WHERE
  a0_.locality_id = a1_.id
  AND a1_.district_id = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?
  AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.name ASC

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_ INNER JOIN ax_locality a1_ ON a0_.locality_id = a1_.id INNER JOIN ax_district a2_ ON a1_.district_id = a2_.id WHERE a0_.locality_id = a1_.id AND a1_.district_id = '01' AND a0_.client_status = 'active' AND a0_.server_status = 'ok' AND a0_.id IN (6, 5, 8, 2, 3, 11, 9, 10, 7, 1) ORDER BY a0_.name 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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	App\Pagination\Paginator->paginate (line 56)
8	App\Repository\ResidentialComplexRepository->findByDistrict (line 84)
9	App\Controller\ResidentialComplexController->listResidentialComplexesByDistrict (line 97)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.71 ms
(14.77%)

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_ INNER JOIN ax_locality a1_ ON a0_.locality_id = a1_.id INNER JOIN ax_district a2_ ON a1_.district_id = a2_.id WHERE a0_.locality_id = a1_.id AND a1_.district_id = ? AND a0_.client_status = ? AND a0_.server_status = ? ORDER BY a0_.name ASC

Parameters:

[
  "01"
  "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_
  INNER JOIN ax_locality a1_ ON a0_.locality_id = a1_.id
  INNER JOIN ax_district a2_ ON a1_.district_id = a2_.id
WHERE
  a0_.locality_id = a1_.id
  AND a1_.district_id = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?
ORDER BY
  a0_.name ASC

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_ INNER JOIN ax_locality a1_ ON a0_.locality_id = a1_.id INNER JOIN ax_district a2_ ON a1_.district_id = a2_.id WHERE a0_.locality_id = a1_.id AND a1_.district_id = '01' AND a0_.client_status = 'active' AND a0_.server_status = 'ok' ORDER BY a0_.name 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\ResidentialComplexRepository->findByDistrict (line 81)
7	App\Controller\ResidentialComplexController->listResidentialComplexesByDistrict (line 107)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.37 ms
(7.76%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.district_id AS district_id_4 FROM ax_locality t0 WHERE t0.id = ?

Parameters:

[
  "0100"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.district_id AS district_id_4
FROM
  ax_locality t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.district_id AS district_id_4 FROM ax_locality t0 WHERE t0.id = '0100';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	ReflectionProperty::isInitialized (line 29)
5	Doctrine\ORM\Mapping\PropertyAccessors\ReadonlyAccessor->setValue (line 29)
6	Doctrine\ORM\Proxy\ProxyFactory->getProxy (line 233)
7	Doctrine\ORM\UnitOfWork->createEntity (line 2540)
8	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
9	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
12	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
13	Doctrine\ORM\AbstractQuery->execute (line 886)
14	Doctrine\ORM\AbstractQuery->getResult (line 688)
15	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
16	App\Pagination\Paginator->paginate (line 56)
17	App\Repository\ResidentialComplexRepository->findByDistrict (line 84)
18	App\Controller\ResidentialComplexController->listResidentialComplexesByDistrict (line 97)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.29 ms
(6.14%)

SELECT DISTINCT a0_.id AS id_0, a0_.name AS name_1 FROM ax_residential_complex a0_ INNER JOIN ax_locality a1_ ON a0_.locality_id = a1_.id INNER JOIN ax_district a2_ ON a1_.district_id = a2_.id WHERE a0_.locality_id = a1_.id AND a1_.district_id = ? AND a0_.client_status = ? AND a0_.server_status = ? ORDER BY a0_.name ASC LIMIT 10

Parameters:

[
  "01"
  "active"
  "ok"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.name AS name_1
FROM
  ax_residential_complex a0_
  INNER JOIN ax_locality a1_ ON a0_.locality_id = a1_.id
  INNER JOIN ax_district a2_ ON a1_.district_id = a2_.id
WHERE
  a0_.locality_id = a1_.id
  AND a1_.district_id = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?
ORDER BY
  a0_.name ASC
LIMIT
  10

SELECT DISTINCT a0_.id AS id_0, a0_.name AS name_1 FROM ax_residential_complex a0_ INNER JOIN ax_locality a1_ ON a0_.locality_id = a1_.id INNER JOIN ax_district a2_ ON a1_.district_id = a2_.id WHERE a0_.locality_id = a1_.id AND a1_.district_id = '01' AND 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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	App\Pagination\Paginator->paginate (line 56)
8	App\Repository\ResidentialComplexRepository->findByDistrict (line 84)
9	App\Controller\ResidentialComplexController->listResidentialComplexesByDistrict (line 97)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.18 ms
(3.76%)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM ax_residential_complex a0_ INNER JOIN ax_locality a1_ ON a0_.locality_id = a1_.id INNER JOIN ax_district a2_ ON a1_.district_id = a2_.id WHERE a0_.locality_id = a1_.id AND a1_.district_id = ? AND a0_.client_status = ? AND a0_.server_status = ?

Parameters:

[
  "01"
  "active"
  "ok"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  ax_residential_complex a0_
  INNER JOIN ax_locality a1_ ON a0_.locality_id = a1_.id
  INNER JOIN ax_district a2_ ON a1_.district_id = a2_.id
WHERE
  a0_.locality_id = a1_.id
  AND a1_.district_id = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM ax_residential_complex a0_ INNER JOIN ax_locality a1_ ON a0_.locality_id = a1_.id INNER JOIN ax_district a2_ ON a1_.district_id = a2_.id WHERE a0_.locality_id = a1_.id AND a1_.district_id = '01' AND 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->findByDistrict (line 84)
9	App\Controller\ResidentialComplexController->listResidentialComplexesByDistrict (line 97)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.15 ms
(3.09%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM ax_district t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "mun-chisinau"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3
FROM
  ax_district t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM ax_district t0 WHERE t0.slug = 'mun-chisinau' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
4	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
6	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.07 ms
(1.50%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3 FROM ax_language t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3
FROM
  ax_language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3 FROM ax_language t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	ReflectionProperty::isInitialized (line 29)
5	Doctrine\ORM\Mapping\PropertyAccessors\ReadonlyAccessor->setValue (line 29)
6	Doctrine\ORM\Proxy\ProxyFactory->getProxy (line 233)
7	Doctrine\ORM\UnitOfWork->createEntity (line 2540)
8	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 176)
9	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 60)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
11	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
13	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
14	App\Entity\Company::getCslug (line 403)
15	App\Controller\ResidentialComplexController->getPointFeatureCollection (line 190)
16	App\Controller\ResidentialComplexController->listResidentialComplexesByDistrict (line 114)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.07 ms
(1.42%)

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 35)
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 455)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\ResidentialComplexController->listResidentialComplexesByDistrict (line 109)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
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
App\Entity\District	41
App\Entity\ResidentialComplexImage	41
App\Entity\ResidentialComplex	12
App\Entity\Company	9
App\Entity\Locality	5
App\Entity\Language	1

Entities Mapping

Class	Mapping errors
App\Entity\District	No errors.
App\Entity\Locality	No errors.
App\Entity\ResidentialComplex	No errors.
App\Entity\Company	No errors.
App\Entity\ResidentialComplexDescription	No errors.
App\Entity\ResidentialComplexImage	No errors.
App\Entity\Property	No errors.
App\Entity\Language	No errors.
App\Entity\CompanyDescription	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://land.n46.net/ro/harta/ansambluri-rezidentiale/mun-chisinau

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping