Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

3.64 ms Query time

1 Invalid entities

886 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.31 ms
(35.88%)

SELECT t0.id AS id_1, t0.nome_completo AS nome_completo_2, t0.nome_cracha AS nome_cracha_3, t0.data_nascimento AS data_nascimento_4, t0.email AS email_5, t0.cpf AS cpf_6, t0.pagante_nome AS pagante_nome_7, t0.pagante_cpf AS pagante_cpf_8, t0.whatsapp AS whatsapp_9, t0.nome_contato_emergencia AS nome_contato_emergencia_10, t0.telefone_contato_emergencia AS telefone_contato_emergencia_11, t0.cidade AS cidade_12, t0.estado AS estado_13, t0.restricao_alimentar AS restricao_alimentar_14, t0.alergia AS alergia_15, t0.aceite_lgpd AS aceite_lgpd_16, t0.aceite_imagem AS aceite_imagem_17, t0.status AS status_18, t0.created_at AS created_at_19, t0.presente AS presente_20, t0.data_hora_checkin AS data_hora_checkin_21, t0.inscricao_id AS inscricao_id_22, t0.tipo_inscricao_id AS tipo_inscricao_id_23, t0.credenciador_checkin_id AS credenciador_checkin_id_24 FROM inscrito t0 WHERE t0.tipo_inscricao_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nome_completo AS nome_completo_2,
  t0.nome_cracha AS nome_cracha_3,
  t0.data_nascimento AS data_nascimento_4,
  t0.email AS email_5,
  t0.cpf AS cpf_6,
  t0.pagante_nome AS pagante_nome_7,
  t0.pagante_cpf AS pagante_cpf_8,
  t0.whatsapp AS whatsapp_9,
  t0.nome_contato_emergencia AS nome_contato_emergencia_10,
  t0.telefone_contato_emergencia AS telefone_contato_emergencia_11,
  t0.cidade AS cidade_12,
  t0.estado AS estado_13,
  t0.restricao_alimentar AS restricao_alimentar_14,
  t0.alergia AS alergia_15,
  t0.aceite_lgpd AS aceite_lgpd_16,
  t0.aceite_imagem AS aceite_imagem_17,
  t0.status AS status_18,
  t0.created_at AS created_at_19,
  t0.presente AS presente_20,
  t0.data_hora_checkin AS data_hora_checkin_21,
  t0.inscricao_id AS inscricao_id_22,
  t0.tipo_inscricao_id AS tipo_inscricao_id_23,
  t0.credenciador_checkin_id AS credenciador_checkin_id_24
FROM
  inscrito t0
WHERE
  t0.tipo_inscricao_id = ?

SELECT t0.id AS id_1, t0.nome_completo AS nome_completo_2, t0.nome_cracha AS nome_cracha_3, t0.data_nascimento AS data_nascimento_4, t0.email AS email_5, t0.cpf AS cpf_6, t0.pagante_nome AS pagante_nome_7, t0.pagante_cpf AS pagante_cpf_8, t0.whatsapp AS whatsapp_9, t0.nome_contato_emergencia AS nome_contato_emergencia_10, t0.telefone_contato_emergencia AS telefone_contato_emergencia_11, t0.cidade AS cidade_12, t0.estado AS estado_13, t0.restricao_alimentar AS restricao_alimentar_14, t0.alergia AS alergia_15, t0.aceite_lgpd AS aceite_lgpd_16, t0.aceite_imagem AS aceite_imagem_17, t0.status AS status_18, t0.created_at AS created_at_19, t0.presente AS presente_20, t0.data_hora_checkin AS data_hora_checkin_21, t0.inscricao_id AS inscricao_id_22, t0.tipo_inscricao_id AS tipo_inscricao_id_23, t0.credenciador_checkin_id AS credenciador_checkin_id_24 FROM inscrito t0 WHERE t0.tipo_inscricao_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\Entity\TipoInscricao->getInscritosAtivos (line 124)
8	App\Entity\TipoInscricao->isEsgotado (line 86)
9	Twig\Extension\CoreExtension->getAttribute (line 1919)
10	__TwigTemplate_ad546543d4614c34b0ce97f970b21bb0::doDisplay (line 305)
11	Twig\Template->yield (line 402)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 373)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Extension\CoreExtension->include (line 1526)
16	__TwigTemplate_ce24eb0ca9cffb92e8b702878436f168::block_content (line 237)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_bbfa1e14718d23cc4a40b81d7dbf3c82->doDisplay (line 229)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_ce24eb0ca9cffb92e8b702878436f168->doDisplay (line 54)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
29	App\Controller\pub\EventoPublicoController->show (line 45)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 208)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 5)

0.79 ms
(21.70%)

SELECT t0.id AS id_1, t0.nome_cadastrante AS nome_cadastrante_2, t0.created_at AS created_at_3, t0.status AS status_4, t0.excluido AS excluido_5, t0.pix_code AS pix_code_6, t0.evento_id AS evento_id_7 FROM inscricao t0 WHERE t0.evento_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nome_cadastrante AS nome_cadastrante_2,
  t0.created_at AS created_at_3,
  t0.status AS status_4,
  t0.excluido AS excluido_5,
  t0.pix_code AS pix_code_6,
  t0.evento_id AS evento_id_7
FROM
  inscricao t0
WHERE
  t0.evento_id = ?

SELECT t0.id AS id_1, t0.nome_cadastrante AS nome_cadastrante_2, t0.created_at AS created_at_3, t0.status AS status_4, t0.excluido AS excluido_5, t0.pix_code AS pix_code_6, t0.evento_id AS evento_id_7 FROM inscricao t0 WHERE t0.evento_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Evento->temInscritos (line 206)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_ad546543d4614c34b0ce97f970b21bb0::doDisplay (line 115)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1526)
15	__TwigTemplate_ce24eb0ca9cffb92e8b702878436f168::block_content (line 237)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_bbfa1e14718d23cc4a40b81d7dbf3c82->doDisplay (line 229)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_ce24eb0ca9cffb92e8b702878436f168->doDisplay (line 54)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
28	App\Controller\pub\EventoPublicoController->show (line 45)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 208)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

0.77 ms
(21.04%)

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.descricao AS descricao_3, t0.chave_pix AS chave_pix_4, t0.beneficiario_pix AS beneficiario_pix_5, t0.cidade_pix AS cidade_pix_6, t0.pix_prefix AS pix_prefix_7, t0.mensagem_sucesso AS mensagem_sucesso_8, t0.banner_name AS banner_name_9, t0.logo_name AS logo_name_10, t0.data_inicio AS data_inicio_11, t0.data_fim AS data_fim_12, t0.status AS status_13, t0.token AS token_14, t0.cor_background AS cor_background_15, t0.cor_texto AS cor_texto_16, t0.cor_texto_secundario AS cor_texto_secundario_17, t0.cor_botao_primario AS cor_botao_primario_18, t0.cor_botao_secundario AS cor_botao_secundario_19, t0.updated_at AS updated_at_20, t0.aviso AS aviso_21 FROM evento t0 WHERE t0.token = ? LIMIT 1

Parameters:

[
  "69cb32f5c20114.9136429269cb32f5c223e8.64977248"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.descricao AS descricao_3,
  t0.chave_pix AS chave_pix_4,
  t0.beneficiario_pix AS beneficiario_pix_5,
  t0.cidade_pix AS cidade_pix_6,
  t0.pix_prefix AS pix_prefix_7,
  t0.mensagem_sucesso AS mensagem_sucesso_8,
  t0.banner_name AS banner_name_9,
  t0.logo_name AS logo_name_10,
  t0.data_inicio AS data_inicio_11,
  t0.data_fim AS data_fim_12,
  t0.status AS status_13,
  t0.token AS token_14,
  t0.cor_background AS cor_background_15,
  t0.cor_texto AS cor_texto_16,
  t0.cor_texto_secundario AS cor_texto_secundario_17,
  t0.cor_botao_primario AS cor_botao_primario_18,
  t0.cor_botao_secundario AS cor_botao_secundario_19,
  t0.updated_at AS updated_at_20,
  t0.aviso AS aviso_21
FROM
  evento t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.descricao AS descricao_3, t0.chave_pix AS chave_pix_4, t0.beneficiario_pix AS beneficiario_pix_5, t0.cidade_pix AS cidade_pix_6, t0.pix_prefix AS pix_prefix_7, t0.mensagem_sucesso AS mensagem_sucesso_8, t0.banner_name AS banner_name_9, t0.logo_name AS logo_name_10, t0.data_inicio AS data_inicio_11, t0.data_fim AS data_fim_12, t0.status AS status_13, t0.token AS token_14, t0.cor_background AS cor_background_15, t0.cor_texto AS cor_texto_16, t0.cor_texto_secundario AS cor_texto_secundario_17, t0.cor_botao_primario AS cor_botao_primario_18, t0.cor_botao_secundario AS cor_botao_secundario_19, t0.updated_at AS updated_at_20, t0.aviso AS aviso_21 FROM evento t0 WHERE t0.token = '69cb32f5c20114.9136429269cb32f5c223e8.64977248' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\pub\EventoPublicoController->show (line 32)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.43 ms
(11.96%)

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.valor_base AS valor_base_3, t0.status AS status_4, t0.limite_inscricoes AS limite_inscricoes_5, t0.lista_espera_ativa AS lista_espera_ativa_6, t0.cor_pulseira AS cor_pulseira_7, t0.instrucao_kit AS instrucao_kit_8, t0.evento_id AS evento_id_9 FROM tipo_inscricao t0 WHERE t0.evento_id = ? AND t0.status = ?

Parameters:

[
  1
  "ativo"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.valor_base AS valor_base_3,
  t0.status AS status_4,
  t0.limite_inscricoes AS limite_inscricoes_5,
  t0.lista_espera_ativa AS lista_espera_ativa_6,
  t0.cor_pulseira AS cor_pulseira_7,
  t0.instrucao_kit AS instrucao_kit_8,
  t0.evento_id AS evento_id_9
FROM
  tipo_inscricao t0
WHERE
  t0.evento_id = ?
  AND t0.status = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.valor_base AS valor_base_3, t0.status AS status_4, t0.limite_inscricoes AS limite_inscricoes_5, t0.lista_espera_ativa AS lista_espera_ativa_6, t0.cor_pulseira AS cor_pulseira_7, t0.instrucao_kit AS instrucao_kit_8, t0.evento_id AS evento_id_9 FROM tipo_inscricao t0 WHERE t0.evento_id = 1 AND t0.status = 'ativo';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Controller\pub\EventoPublicoController->show (line 40)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.34 ms
(9.43%)

SELECT t0.id AS id_1, t0.nome_completo AS nome_completo_2, t0.nome_cracha AS nome_cracha_3, t0.data_nascimento AS data_nascimento_4, t0.email AS email_5, t0.cpf AS cpf_6, t0.pagante_nome AS pagante_nome_7, t0.pagante_cpf AS pagante_cpf_8, t0.whatsapp AS whatsapp_9, t0.nome_contato_emergencia AS nome_contato_emergencia_10, t0.telefone_contato_emergencia AS telefone_contato_emergencia_11, t0.cidade AS cidade_12, t0.estado AS estado_13, t0.restricao_alimentar AS restricao_alimentar_14, t0.alergia AS alergia_15, t0.aceite_lgpd AS aceite_lgpd_16, t0.aceite_imagem AS aceite_imagem_17, t0.status AS status_18, t0.created_at AS created_at_19, t0.presente AS presente_20, t0.data_hora_checkin AS data_hora_checkin_21, t0.inscricao_id AS inscricao_id_22, t0.tipo_inscricao_id AS tipo_inscricao_id_23, t0.credenciador_checkin_id AS credenciador_checkin_id_24 FROM inscrito t0 WHERE t0.inscricao_id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nome_completo AS nome_completo_2,
  t0.nome_cracha AS nome_cracha_3,
  t0.data_nascimento AS data_nascimento_4,
  t0.email AS email_5,
  t0.cpf AS cpf_6,
  t0.pagante_nome AS pagante_nome_7,
  t0.pagante_cpf AS pagante_cpf_8,
  t0.whatsapp AS whatsapp_9,
  t0.nome_contato_emergencia AS nome_contato_emergencia_10,
  t0.telefone_contato_emergencia AS telefone_contato_emergencia_11,
  t0.cidade AS cidade_12,
  t0.estado AS estado_13,
  t0.restricao_alimentar AS restricao_alimentar_14,
  t0.alergia AS alergia_15,
  t0.aceite_lgpd AS aceite_lgpd_16,
  t0.aceite_imagem AS aceite_imagem_17,
  t0.status AS status_18,
  t0.created_at AS created_at_19,
  t0.presente AS presente_20,
  t0.data_hora_checkin AS data_hora_checkin_21,
  t0.inscricao_id AS inscricao_id_22,
  t0.tipo_inscricao_id AS tipo_inscricao_id_23,
  t0.credenciador_checkin_id AS credenciador_checkin_id_24
FROM
  inscrito t0
WHERE
  t0.inscricao_id = ?

SELECT t0.id AS id_1, t0.nome_completo AS nome_completo_2, t0.nome_cracha AS nome_cracha_3, t0.data_nascimento AS data_nascimento_4, t0.email AS email_5, t0.cpf AS cpf_6, t0.pagante_nome AS pagante_nome_7, t0.pagante_cpf AS pagante_cpf_8, t0.whatsapp AS whatsapp_9, t0.nome_contato_emergencia AS nome_contato_emergencia_10, t0.telefone_contato_emergencia AS telefone_contato_emergencia_11, t0.cidade AS cidade_12, t0.estado AS estado_13, t0.restricao_alimentar AS restricao_alimentar_14, t0.alergia AS alergia_15, t0.aceite_lgpd AS aceite_lgpd_16, t0.aceite_imagem AS aceite_imagem_17, t0.status AS status_18, t0.created_at AS created_at_19, t0.presente AS presente_20, t0.data_hora_checkin AS data_hora_checkin_21, t0.inscricao_id AS inscricao_id_22, t0.tipo_inscricao_id AS tipo_inscricao_id_23, t0.credenciador_checkin_id AS credenciador_checkin_id_24 FROM inscrito t0 WHERE t0.inscricao_id = 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->isEmpty (line 535)
9	App\Entity\Evento->temInscritos (line 207)
10	Twig\Extension\CoreExtension->getAttribute (line 1919)
11	__TwigTemplate_ad546543d4614c34b0ce97f970b21bb0::doDisplay (line 115)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Extension\CoreExtension->include (line 1526)
17	__TwigTemplate_ce24eb0ca9cffb92e8b702878436f168::block_content (line 237)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_bbfa1e14718d23cc4a40b81d7dbf3c82->doDisplay (line 229)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_ce24eb0ca9cffb92e8b702878436f168->doDisplay (line 54)
22	Twig\Template->yield (line 402)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
30	App\Controller\pub\EventoPublicoController->show (line 45)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 208)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	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\Inscrito	495
App\Entity\Inscricao	388
App\Entity\TipoInscricao	2
App\Entity\Evento	1

Entities Mapping

Class	Mapping errors
App\Entity\Evento	No errors.
App\Entity\CampoAdicional	The field App\Entity\CampoAdicional#respostas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\RespostaCampoAdicional#campo does not contain the required 'inversedBy="respostas"' attribute.
App\Entity\TipoInscricao	No errors.
App\Entity\Inscricao	No errors.
App\Entity\InscricaoListaEspera	No errors.
App\Entity\ItemAdicional	No errors.
App\Entity\Inscrito	No errors.
App\Entity\User	No errors.
App\Entity\InscritoItemAdicional	No errors.
App\Entity\RespostaCampoAdicional	No errors.

Symfony Profiler

GET https://inscricao.nepebrasil.org/e/69cb32f5c20114.9136429269cb32f5c223e8.64977248

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping