Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.75 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.38 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.cupom AS cupom_6, t0.cidade AS cidade_7, t0.estado AS estado_8, t0.bairro AS bairro_9, t0.numero AS numero_10, t0.pix AS pix_11, t0.cpf AS cpf_12, t0.nome AS nome_13, t0.rua AS rua_14, t0.elo AS elo_15, t0.valor_venda AS valor_venda_16, t0.last_up AS last_up_17, t0.quantidade_uso AS quantidade_uso_18, t0.valor_fechado AS valor_fechado_19, t0.game_level AS game_level_20, t0.instagram AS instagram_21 FROM user t0 WHERE t0.id = ?

Parameters:

[
  309
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.cupom AS cupom_6,
  t0.cidade AS cidade_7,
  t0.estado AS estado_8,
  t0.bairro AS bairro_9,
  t0.numero AS numero_10,
  t0.pix AS pix_11,
  t0.cpf AS cpf_12,
  t0.nome AS nome_13,
  t0.rua AS rua_14,
  t0.elo AS elo_15,
  t0.valor_venda AS valor_venda_16,
  t0.last_up AS last_up_17,
  t0.quantidade_uso AS quantidade_uso_18,
  t0.valor_fechado AS valor_fechado_19,
  t0.game_level AS game_level_20,
  t0.instagram AS instagram_21
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.cupom AS cupom_6, t0.cidade AS cidade_7, t0.estado AS estado_8, t0.bairro AS bairro_9, t0.numero AS numero_10, t0.pix AS pix_11, t0.cpf AS cpf_12, t0.nome AS nome_13, t0.rua AS rua_14, t0.elo AS elo_15, t0.valor_venda AS valor_venda_16, t0.last_up AS last_up_17, t0.quantidade_uso AS quantidade_uso_18, t0.valor_fechado AS valor_fechado_19, t0.game_level AS game_level_20, t0.instagram AS instagram_21 FROM user t0 WHERE t0.id = 309;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 73)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.22 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.cupom AS cupom_6, t0.cidade AS cidade_7, t0.estado AS estado_8, t0.bairro AS bairro_9, t0.numero AS numero_10, t0.pix AS pix_11, t0.cpf AS cpf_12, t0.nome AS nome_13, t0.rua AS rua_14, t0.elo AS elo_15, t0.valor_venda AS valor_venda_16, t0.last_up AS last_up_17, t0.quantidade_uso AS quantidade_uso_18, t0.valor_fechado AS valor_fechado_19, t0.game_level AS game_level_20, t0.instagram AS instagram_21 FROM user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "euingrifitness@hotmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.cupom AS cupom_6,
  t0.cidade AS cidade_7,
  t0.estado AS estado_8,
  t0.bairro AS bairro_9,
  t0.numero AS numero_10,
  t0.pix AS pix_11,
  t0.cpf AS cpf_12,
  t0.nome AS nome_13,
  t0.rua AS rua_14,
  t0.elo AS elo_15,
  t0.valor_venda AS valor_venda_16,
  t0.last_up AS last_up_17,
  t0.quantidade_uso AS quantidade_uso_18,
  t0.valor_fechado AS valor_fechado_19,
  t0.game_level AS game_level_20,
  t0.instagram AS instagram_21
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.cupom AS cupom_6, t0.cidade AS cidade_7, t0.estado AS estado_8, t0.bairro AS bairro_9, t0.numero AS numero_10, t0.pix AS pix_11, t0.cpf AS cpf_12, t0.nome AS nome_13, t0.rua AS rua_14, t0.elo AS elo_15, t0.valor_venda AS valor_venda_16, t0.last_up AS last_up_17, t0.quantidade_uso AS quantidade_uso_18, t0.valor_fechado AS valor_fechado_19, t0.game_level AS game_level_20, t0.instagram AS instagram_21 FROM user t0 WHERE t0.email = 'euingrifitness@hotmail.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 929)
4	App\Controller\Admin\DashboardController->configureMenuItems (line 155)
5	EasyCorp\Bundle\EasyAdminBundle\Context\AdminContext->getMainMenu (line 1637)
6	twig_get_attribute (line 108)
7	__TwigTemplate_9a74849eeb0db2e4fa6850987b434a4d->block_main_menu (line 171)
8	Twig\Template->displayBlock (line 58)
9	__TwigTemplate_9a74849eeb0db2e4fa6850987b434a4d->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 379)
12	Twig\Template->render (line 40)
13	Twig\TemplateWrapper->render (line 1349)
14	twig_include (line 1157)
15	__TwigTemplate_00c202a75450fbcec378e846807fd95c->block_main_menu_wrapper (line 171)
16	Twig\Template->displayBlock (line 1051)
17	__TwigTemplate_00c202a75450fbcec378e846807fd95c->block_sidebar (line 171)
18	Twig\Template->displayBlock (line 897)
19	__TwigTemplate_00c202a75450fbcec378e846807fd95c->block_wrapper (line 171)
20	Twig\Template->displayBlock (line 740)
21	__TwigTemplate_00c202a75450fbcec378e846807fd95c->block_wrapper_wrapper (line 171)
22	Twig\Template->displayBlock (line 414)
23	__TwigTemplate_00c202a75450fbcec378e846807fd95c->block_body (line 171)
24	Twig\Template->displayBlock (line 157)
25	__TwigTemplate_00c202a75450fbcec378e846807fd95c->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 54)
28	__TwigTemplate_ff9651789cff154ccdccd38a4b8b1d2c->doDisplay (line 394)
29	Twig\Template->displayWithErrorHandling (line 367)
30	Twig\Template->display (line 51)
31	__TwigTemplate_ce54a9b17aeb5947251909e5bfa614b6->doDisplay (line 394)
32	Twig\Template->displayWithErrorHandling (line 367)
33	Twig\Template->display (line 379)
34	Twig\Template->render (line 40)
35	Twig\TemplateWrapper->render (line 280)
36	Twig\Environment->render (line 243)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 212)
39	App\Controller\Admin\DashboardController->mySalesHistory (line 166)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	require_once (line 5)

0.81 ms

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_send_3 FROM (SELECT s0_.id AS id_0, s0_.cupom_note AS cupom_note_1, s0_.note AS note_2, s0_.date_send AS date_send_3, s0_.nome AS nome_4, s0_.metodo_pagamento AS metodo_pagamento_5, s0_.valor AS valor_6, s0_.pago AS pago_7, s0_.descontado AS descontado_8 FROM send_note s0_ WHERE s0_.cupom_note = ?) dctrn_result_inner ORDER BY date_send_3 DESC) dctrn_result LIMIT 6

Parameters:

[
  "Tenorio"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      date_send_3
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.cupom_note AS cupom_note_1,
          s0_.note AS note_2,
          s0_.date_send AS date_send_3,
          s0_.nome AS nome_4,
          s0_.metodo_pagamento AS metodo_pagamento_5,
          s0_.valor AS valor_6,
          s0_.pago AS pago_7,
          s0_.descontado AS descontado_8
        FROM
          send_note s0_
        WHERE
          s0_.cupom_note = ?
      ) dctrn_result_inner
    ORDER BY
      date_send_3 DESC
  ) dctrn_result
LIMIT
  6

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_send_3 FROM (SELECT s0_.id AS id_0, s0_.cupom_note AS cupom_note_1, s0_.note AS note_2, s0_.date_send AS date_send_3, s0_.nome AS nome_4, s0_.metodo_pagamento AS metodo_pagamento_5, s0_.valor AS valor_6, s0_.pago AS pago_7, s0_.descontado AS descontado_8 FROM send_note s0_ WHERE s0_.cupom_note = 'Tenorio') dctrn_result_inner ORDER BY date_send_3 DESC) dctrn_result LIMIT 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1211)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1165)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 151)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 57)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 252)
9	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 238)
10	Pagerfanta\Pagerfanta->getCurrentPageResults (line 407)
11	Pagerfanta\Pagerfanta->getIterator (line 147)
12	__TwigTemplate_ce54a9b17aeb5947251909e5bfa614b6->block_main (line 171)
13	Twig\Template->displayBlock (line 1578)
14	__TwigTemplate_00c202a75450fbcec378e846807fd95c->block_content (line 171)
15	Twig\Template->displayBlock (line 921)
16	__TwigTemplate_00c202a75450fbcec378e846807fd95c->block_wrapper (line 171)
17	Twig\Template->displayBlock (line 740)
18	__TwigTemplate_00c202a75450fbcec378e846807fd95c->block_wrapper_wrapper (line 171)
19	Twig\Template->displayBlock (line 414)
20	__TwigTemplate_00c202a75450fbcec378e846807fd95c->block_body (line 171)
21	Twig\Template->displayBlock (line 157)
22	__TwigTemplate_00c202a75450fbcec378e846807fd95c->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 54)
25	__TwigTemplate_ff9651789cff154ccdccd38a4b8b1d2c->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 51)
28	__TwigTemplate_ce54a9b17aeb5947251909e5bfa614b6->doDisplay (line 394)
29	Twig\Template->displayWithErrorHandling (line 367)
30	Twig\Template->display (line 379)
31	Twig\Template->render (line 40)
32	Twig\TemplateWrapper->render (line 280)
33	Twig\Environment->render (line 243)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 212)
36	App\Controller\Admin\DashboardController->mySalesHistory (line 166)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

0.34 ms

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.cupom_note AS cupom_note_1, s0_.note AS note_2, s0_.date_send AS date_send_3, s0_.nome AS nome_4, s0_.metodo_pagamento AS metodo_pagamento_5, s0_.valor AS valor_6, s0_.pago AS pago_7, s0_.descontado AS descontado_8 FROM send_note s0_ WHERE s0_.cupom_note = ? ORDER BY s0_.date_send DESC) dctrn_result) dctrn_table

Parameters:

[
  "Tenorio"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.cupom_note AS cupom_note_1,
          s0_.note AS note_2,
          s0_.date_send AS date_send_3,
          s0_.nome AS nome_4,
          s0_.metodo_pagamento AS metodo_pagamento_5,
          s0_.valor AS valor_6,
          s0_.pago AS pago_7,
          s0_.descontado AS descontado_8
        FROM
          send_note s0_
        WHERE
          s0_.cupom_note = ?
        ORDER BY
          s0_.date_send DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.cupom_note AS cupom_note_1, s0_.note AS note_2, s0_.date_send AS date_send_3, s0_.nome AS nome_4, s0_.metodo_pagamento AS metodo_pagamento_5, s0_.valor AS valor_6, s0_.pago AS pago_7, s0_.descontado AS descontado_8 FROM send_note s0_ WHERE s0_.cupom_note = 'Tenorio' ORDER BY s0_.date_send DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1211)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1165)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 118)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 42)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getNbResults (line 285)
9	Pagerfanta\Pagerfanta->getNbResults (line 314)
10	Pagerfanta\Pagerfanta->calculateNbPages (line 296)
11	Pagerfanta\Pagerfanta->getNbPages (line 43)
12	Pagerfanta\View\View->initializePagerfanta (line 37)
13	Pagerfanta\Twig\View\TwigView->render (line 35)
14	Pagerfanta\Twig\Extension\PagerfantaRuntime->renderPagerfanta (line 233)
15	__TwigTemplate_ce54a9b17aeb5947251909e5bfa614b6->block_main (line 171)
16	Twig\Template->displayBlock (line 1578)
17	__TwigTemplate_00c202a75450fbcec378e846807fd95c->block_content (line 171)
18	Twig\Template->displayBlock (line 921)
19	__TwigTemplate_00c202a75450fbcec378e846807fd95c->block_wrapper (line 171)
20	Twig\Template->displayBlock (line 740)
21	__TwigTemplate_00c202a75450fbcec378e846807fd95c->block_wrapper_wrapper (line 171)
22	Twig\Template->displayBlock (line 414)
23	__TwigTemplate_00c202a75450fbcec378e846807fd95c->block_body (line 171)
24	Twig\Template->displayBlock (line 157)
25	__TwigTemplate_00c202a75450fbcec378e846807fd95c->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 54)
28	__TwigTemplate_ff9651789cff154ccdccd38a4b8b1d2c->doDisplay (line 394)
29	Twig\Template->displayWithErrorHandling (line 367)
30	Twig\Template->display (line 51)
31	__TwigTemplate_ce54a9b17aeb5947251909e5bfa614b6->doDisplay (line 394)
32	Twig\Template->displayWithErrorHandling (line 367)
33	Twig\Template->display (line 379)
34	Twig\Template->render (line 40)
35	Twig\TemplateWrapper->render (line 280)
36	Twig\Environment->render (line 243)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 212)
39	App\Controller\Admin\DashboardController->mySalesHistory (line 166)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\SendNote	No errors.

Symfony Profiler

GET https://influetesaguaazul.com.br/admin?routeName=mySalesHistory

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping