Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

5.30 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

3.92 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.legal_name AS legal_name_2, a0_.business_type AS business_type_3, a0_.nin AS nin_4, a0_.first_name AS first_name_5, a0_.last_name AS last_name_6, a0_.domain AS domain_7, a0_.email AS email_8, a0_.website AS website_9, a0_.facebook_page AS facebook_page_10, a0_.instagram_username AS instagram_username_11, a0_.xcorp_username AS xcorp_username_12, a0_.youtube_handle AS youtube_handle_13, a0_.cslug AS cslug_14, a0_.street AS street_15, a0_.postal_code AS postal_code_16, a0_.phone_number AS phone_number_17, a0_.username AS username_18, a0_.password AS password_19, a0_.client_status AS client_status_20, a0_.server_status AS server_status_21, a0_.phone_status AS phone_status_22, a0_.lat AS lat_23, a0_.lng AS lng_24, a0_.roles AS roles_25, a0_.views AS views_26, a0_.created_at AS created_at_27, a0_.updated_at AS updated_at_28, a0_.language_id AS language_id_29, a0_.locality_id AS locality_id_30 FROM ax_company a0_ WHERE a0_.business_type = ? AND a0_.client_status = ? AND a0_.server_status = ? ORDER BY a0_.name ASC LIMIT 10

Parameters:

[
  "developer"
  "active"
  "ok"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.legal_name AS legal_name_2,
  a0_.business_type AS business_type_3,
  a0_.nin AS nin_4,
  a0_.first_name AS first_name_5,
  a0_.last_name AS last_name_6,
  a0_.domain AS domain_7,
  a0_.email AS email_8,
  a0_.website AS website_9,
  a0_.facebook_page AS facebook_page_10,
  a0_.instagram_username AS instagram_username_11,
  a0_.xcorp_username AS xcorp_username_12,
  a0_.youtube_handle AS youtube_handle_13,
  a0_.cslug AS cslug_14,
  a0_.street AS street_15,
  a0_.postal_code AS postal_code_16,
  a0_.phone_number AS phone_number_17,
  a0_.username AS username_18,
  a0_.password AS password_19,
  a0_.client_status AS client_status_20,
  a0_.server_status AS server_status_21,
  a0_.phone_status AS phone_status_22,
  a0_.lat AS lat_23,
  a0_.lng AS lng_24,
  a0_.roles AS roles_25,
  a0_.views AS views_26,
  a0_.created_at AS created_at_27,
  a0_.updated_at AS updated_at_28,
  a0_.language_id AS language_id_29,
  a0_.locality_id AS locality_id_30
FROM
  ax_company a0_
WHERE
  a0_.business_type = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?
ORDER BY
  a0_.name ASC
LIMIT
  10

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.legal_name AS legal_name_2, a0_.business_type AS business_type_3, a0_.nin AS nin_4, a0_.first_name AS first_name_5, a0_.last_name AS last_name_6, a0_.domain AS domain_7, a0_.email AS email_8, a0_.website AS website_9, a0_.facebook_page AS facebook_page_10, a0_.instagram_username AS instagram_username_11, a0_.xcorp_username AS xcorp_username_12, a0_.youtube_handle AS youtube_handle_13, a0_.cslug AS cslug_14, a0_.street AS street_15, a0_.postal_code AS postal_code_16, a0_.phone_number AS phone_number_17, a0_.username AS username_18, a0_.password AS password_19, a0_.client_status AS client_status_20, a0_.server_status AS server_status_21, a0_.phone_status AS phone_status_22, a0_.lat AS lat_23, a0_.lng AS lng_24, a0_.roles AS roles_25, a0_.views AS views_26, a0_.created_at AS created_at_27, a0_.updated_at AS updated_at_28, a0_.language_id AS language_id_29, a0_.locality_id AS locality_id_30 FROM ax_company a0_ WHERE a0_.business_type = 'developer' 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->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 151)
7	App\Pagination\Paginator->paginate (line 56)
8	App\Repository\CompanyRepository->findAllByBusinessType (line 40)
9	App\Controller\DeveloperController->listDevelopers (line 45)
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.27 ms

SELECT count(*) AS sclr_0 FROM ax_company a0_ WHERE a0_.business_type = ? AND a0_.client_status = ? AND a0_.server_status = ?

Parameters:

[
  "developer"
  "active"
  "ok"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  ax_company a0_
WHERE
  a0_.business_type = ?
  AND a0_.client_status = ?
  AND a0_.server_status = ?

SELECT count(*) AS sclr_0 FROM ax_company a0_ WHERE a0_.business_type = 'developer' 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\CompanyRepository->findAllByBusinessType (line 40)
9	App\Controller\DeveloperController->listDevelopers (line 45)
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.13 ms

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

Parameters:

[
  "developer"
  "active"
  "ok"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(a0_.id) AS sclr_0 FROM ax_company a0_ WHERE a0_.business_type = 'developer' 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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\CompanyRepository->countAllByBusinessType (line 56)
8	App\Controller\DeveloperController->listDevelopers (line 48)
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)

0.98 ms

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 454)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
23	App\Controller\DeveloperController->listDevelopers (line 47)
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\Company	No errors.
App\Entity\Language	No errors.
App\Entity\Locality	No errors.
App\Entity\CompanyDescription	No errors.
App\Entity\ResidentialComplex	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://imobiliare.n46.net/en/real-estate-developers

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping