Symfony Profiler

Query Metrics

146 Database Queries

5 Different statements

100.19 ms Query time

0 Invalid entities

88 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

50.94 ms
(50.85%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.sku AS sku_4, t0.barcode AS barcode_5, t0.qrcode AS qrcode_6, t0.thumb AS thumb_7, t0.description AS description_8, t0.type AS type_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.active AS active_12 FROM product t0 INNER JOIN pdv_products ON t0.id = pdv_products.product_id WHERE pdv_products.pdv_id = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.sku AS sku_4,
  t0.barcode AS barcode_5,
  t0.qrcode AS qrcode_6,
  t0.thumb AS thumb_7,
  t0.description AS description_8,
  t0.type AS type_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.active AS active_12
FROM
  product t0
  INNER JOIN pdv_products ON t0.id = pdv_products.product_id
WHERE
  pdv_products.pdv_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.sku AS sku_4, t0.barcode AS barcode_5, t0.qrcode AS qrcode_6, t0.thumb AS thumb_7, t0.description AS description_8, t0.type AS type_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.active AS active_12 FROM product t0 INNER JOIN pdv_products ON t0.id = pdv_products.product_id WHERE pdv_products.pdv_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
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	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_d8ab5bc7ecdb26dbf9da14a681dbf010::block_body (line 158)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_6f131861d482b4a632abb63bece87fe8->doDisplay (line 146)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d8ab5bc7ecdb26dbf9da14a681dbf010->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\Admin\PdvController->index (line 27)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

44.05 ms
(43.97%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.description AS description_4, t0.type AS type_5, t0.answer_type AS answer_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.required_id AS required_id_9, t0.required AS required_10, t0.replicable AS replicable_11, t0.active AS active_12 FROM pdv_indicator t0 INNER JOIN pdv_indicators ON t0.id = pdv_indicators.pdv_indicator_id WHERE pdv_indicators.pdv_id = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.text AS text_3,
  t0.description AS description_4,
  t0.type AS type_5,
  t0.answer_type AS answer_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.required_id AS required_id_9,
  t0.required AS required_10,
  t0.replicable AS replicable_11,
  t0.active AS active_12
FROM
  pdv_indicator t0
  INNER JOIN pdv_indicators ON t0.id = pdv_indicators.pdv_indicator_id
WHERE
  pdv_indicators.pdv_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.description AS description_4, t0.type AS type_5, t0.answer_type AS answer_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.required_id AS required_id_9, t0.required AS required_10, t0.replicable AS replicable_11, t0.active AS active_12 FROM pdv_indicator t0 INNER JOIN pdv_indicators ON t0.id = pdv_indicators.pdv_indicator_id WHERE pdv_indicators.pdv_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
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	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_d8ab5bc7ecdb26dbf9da14a681dbf010::block_body (line 154)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_6f131861d482b4a632abb63bece87fe8->doDisplay (line 146)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d8ab5bc7ecdb26dbf9da14a681dbf010->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\Admin\PdvController->index (line 27)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

2.25 ms
(2.24%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.retail AS retail_4, t0.distributor AS distributor_5, t0.cnpj AS cnpj_6, t0.static_map AS static_map_7, t0.address AS address_8, t0.number AS number_9, t0.zip_code AS zip_code_10, t0.neighborhood AS neighborhood_11, t0.city AS city_12, t0.state AS state_13, t0.country AS country_14, t0.lat AS lat_15, t0.lng AS lng_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.active AS active_19, t0.client_id AS client_id_20 FROM pdv t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.retail AS retail_4,
  t0.distributor AS distributor_5,
  t0.cnpj AS cnpj_6,
  t0.static_map AS static_map_7,
  t0.address AS address_8,
  t0.number AS number_9,
  t0.zip_code AS zip_code_10,
  t0.neighborhood AS neighborhood_11,
  t0.city AS city_12,
  t0.state AS state_13,
  t0.country AS country_14,
  t0.lat AS lat_15,
  t0.lng AS lng_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.active AS active_19,
  t0.client_id AS client_id_20
FROM
  pdv t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.retail AS retail_4, t0.distributor AS distributor_5, t0.cnpj AS cnpj_6, t0.static_map AS static_map_7, t0.address AS address_8, t0.number AS number_9, t0.zip_code AS zip_code_10, t0.neighborhood AS neighborhood_11, t0.city AS city_12, t0.state AS state_13, t0.country AS country_14, t0.lat AS lat_15, t0.lng AS lng_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.active AS active_19, t0.client_id AS client_id_20 FROM pdv t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\Admin\PdvController->index (line 28)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

2.13 ms
(2.13%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.cpf AS cpf_4, t0.avatar AS avatar_5, t0.token AS token_6, t0.firebase_token AS firebase_token_7, t0.os AS os_8, t0.initial AS initial_9, t0.active AS active_10, t0.can_register AS can_register_11, t0.did_register AS did_register_12, t0.salt_pass AS salt_pass_13, t0.salt_pass_expires_at AS salt_pass_expires_at_14, t0.token_expire_at AS token_expire_at_15, t0.firebase_expire_at AS firebase_expire_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.last_login AS last_login_19, t0.roles AS roles_20, t0.password AS password_21 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.cpf AS cpf_4,
  t0.avatar AS avatar_5,
  t0.token AS token_6,
  t0.firebase_token AS firebase_token_7,
  t0.os AS os_8,
  t0.initial AS initial_9,
  t0.active AS active_10,
  t0.can_register AS can_register_11,
  t0.did_register AS did_register_12,
  t0.salt_pass AS salt_pass_13,
  t0.salt_pass_expires_at AS salt_pass_expires_at_14,
  t0.token_expire_at AS token_expire_at_15,
  t0.firebase_expire_at AS firebase_expire_at_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.last_login AS last_login_19,
  t0.roles AS roles_20,
  t0.password AS password_21
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.cpf AS cpf_4, t0.avatar AS avatar_5, t0.token AS token_6, t0.firebase_token AS firebase_token_7, t0.os AS os_8, t0.initial AS initial_9, t0.active AS active_10, t0.can_register AS can_register_11, t0.did_register AS did_register_12, t0.salt_pass AS salt_pass_13, t0.salt_pass_expires_at AS salt_pass_expires_at_14, t0.token_expire_at AS token_expire_at_15, t0.firebase_expire_at AS firebase_expire_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.last_login AS last_login_19, t0.roles AS roles_20, t0.password AS password_21 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 74)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
13	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 45)
14	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 64)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
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 29)
24	require_once (line 5)

0.82 ms
(0.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.trade_name AS trade_name_3, t0.cnpj AS cnpj_4, t0.avatar AS avatar_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM client t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.trade_name AS trade_name_3,
  t0.cnpj AS cnpj_4,
  t0.avatar AS avatar_5,
  t0.active AS active_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.trade_name AS trade_name_3, t0.cnpj AS cnpj_4, t0.avatar AS avatar_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM client t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Client::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Client->__get (line 153)
7	App\Entity\Client->getName (line 59)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_d8ab5bc7ecdb26dbf9da14a681dbf010::block_body (line 142)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_6f131861d482b4a632abb63bece87fe8->doDisplay (line 146)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d8ab5bc7ecdb26dbf9da14a681dbf010->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\Admin\PdvController->index (line 27)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	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\Pdv	71
App\Entity\PdvIndicator	9
App\Entity\Product	5
App\Entity\Client	2
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Pdv	No errors.
App\Entity\Client	No errors.
App\Entity\Product	No errors.
App\Entity\PdvIndicator	No errors.
App\Entity\Survey	No errors.
App\Entity\PdvIndicatorAnswer	No errors.
App\Entity\ProductDirecCompetition	No errors.
App\Entity\ProductIndicator	No errors.
App\Entity\ProductMix	No errors.

Symfony Profiler

GET https://audit.northco.cc/admin/pdv

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping