Symfony Profiler

Query Metrics

26 Database Queries

25 Different statements

67.04 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.21 ms
(9.26%)

SELECT t0.id AS id_1, t0.quantidade AS quantidade_2, t0.valor_item AS valor_item_3, t0.prazo_entrega AS prazo_entrega_4, t0.data_entrega AS data_entrega_5, t0.observacoes AS observacoes_6, t0.created_at AS created_at_7, t0.ativo AS ativo_8, t0.vlr_venda AS vlr_venda_9, t0.vlr_custo AS vlr_custo_10, t0.produto_id AS produto_id_11, t0.item_proposta_final_id AS item_proposta_final_id_12, t0.pedido_id AS pedido_id_13 FROM item_pedido t0 WHERE t0.pedido_id = ?

Parameters:

[
  332
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantidade AS quantidade_2,
  t0.valor_item AS valor_item_3,
  t0.prazo_entrega AS prazo_entrega_4,
  t0.data_entrega AS data_entrega_5,
  t0.observacoes AS observacoes_6,
  t0.created_at AS created_at_7,
  t0.ativo AS ativo_8,
  t0.vlr_venda AS vlr_venda_9,
  t0.vlr_custo AS vlr_custo_10,
  t0.produto_id AS produto_id_11,
  t0.item_proposta_final_id AS item_proposta_final_id_12,
  t0.pedido_id AS pedido_id_13
FROM
  item_pedido t0
WHERE
  t0.pedido_id = ?

SELECT t0.id AS id_1, t0.quantidade AS quantidade_2, t0.valor_item AS valor_item_3, t0.prazo_entrega AS prazo_entrega_4, t0.data_entrega AS data_entrega_5, t0.observacoes AS observacoes_6, t0.created_at AS created_at_7, t0.ativo AS ativo_8, t0.vlr_venda AS vlr_venda_9, t0.vlr_custo AS vlr_custo_10, t0.produto_id AS produto_id_11, t0.item_proposta_final_id AS item_proposta_final_id_12, t0.pedido_id AS pedido_id_13 FROM item_pedido t0 WHERE t0.pedido_id = 332;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 384)
8	App\Entity\Operacional\Vendas\Proposta\ItemPropostaFinal->getSolicitado (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 87)
10	__TwigTemplate_baa70cbc7e18cabae3fbc35725f038a5->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1493)
15	Twig\Extension\CoreExtension::include (line 287)
16	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->block_content (line 432)
17	Twig\Template->yieldBlock (line 144)
18	__TwigTemplate_a711e81f273bebcbaadcdbdaa48b5830->doDisplay (line 388)
19	Twig\Template->yield (line 56)
20	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->doDisplay (line 388)
21	Twig\Template->yield (line 344)
22	Twig\Template->display (line 359)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 334)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
29	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 7)

4.51 ms
(6.73%)

SELECT t0.id AS id_12, t0.created_at AS created_at_13, t0.tipo_etapa, t1.validade AS validade_14, t1.condicoes_entrega AS condicoes_entrega_15, t1.prazo_entrega AS prazo_entrega_16, t1.local_entrega AS local_entrega_17, t1.garantia AS garantia_18, t1.informacoes_gerais AS informacoes_gerais_19, t1.status AS status_20, t1.data AS data_21, t1.prazo_pagamento AS prazo_pagamento_22, t1.conta_bancaria_id AS conta_bancaria_id_23, t2.dt_disputa AS dt_disputa_24, t2.dt_fechamento AS dt_fechamento_25, t2.status AS status_26, t2.vlr_fechado AS vlr_fechado_27, t2.observacoes AS observacoes_28, t2.em_espera AS em_espera_29, t5.tipo_contratacao AS tipo_contratacao_30, t5.contrato AS contrato_31, t5.vigencia AS vigencia_32, t5.data_assinatura AS data_assinatura_33, t5.numero_contrato AS numero_contrato_34, t5.prazo_inicial AS prazo_inicial_35, t5.prazo_final AS prazo_final_36, t5.valor_inicial AS valor_inicial_37, t5.valor_final AS valor_final_38, t5.status AS status_39, t5.obs_finalizacao AS obs_finalizacao_40, t5.motivo_finalizacao AS motivo_finalizacao_41, t5.arquivo_finalizacao AS arquivo_finalizacao_42, t5.data_finalizacao AS data_finalizacao_43, t5.tipo_contrato AS tipo_contrato_44, t5.edital_id AS edital_id_45, t5.responsavel_id AS responsavel_id_46, t5.ata_registro_id AS ata_registro_id_47, t5.contratada_id AS contratada_id_48, t5.ata_contrato_id AS ata_contrato_id_49, t11.validade AS validade_50, t11.condicoes_entrega AS condicoes_entrega_51, t11.prazo_entrega AS prazo_entrega_52, t11.local_entrega AS local_entrega_53, t11.garantia AS garantia_54, t11.informacoes_gerais AS informacoes_gerais_55, t11.status AS status_56, t11.data AS data_57, t11.prazo_pagamento AS prazo_pagamento_58, t11.situacao AS situacao_59, t11.edital_id AS edital_id_60, t11.conta_bancaria_id AS conta_bancaria_id_61 FROM etapa_processo t0 LEFT JOIN etapa_acolhimento_propostas t1 ON t0.id = t1.id LEFT JOIN etapa_disputa t2 ON t0.id = t2.id LEFT JOIN etapa_habilitacao t3 ON t0.id = t3.id LEFT JOIN etapa_registro_preco t4 ON t0.id = t4.id LEFT JOIN etapa_contrato t5 ON t0.id = t5.id LEFT JOIN etapa_autorizacao_fornecimento t6 ON t0.id = t6.id LEFT JOIN etapa_entrega_produto t7 ON t0.id = t7.id LEFT JOIN etapa_emissao_nf t8 ON t0.id = t8.id LEFT JOIN etapa_faturamento t9 ON t0.id = t9.id LEFT JOIN etapa_atestado_tecnico t10 ON t0.id = t10.id LEFT JOIN proposta_final t11 ON t0.id = t11.id WHERE t0.id = ?

Parameters:

[
  1888
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_12,
  t0.created_at AS created_at_13,
  t0.tipo_etapa,
  t1.validade AS validade_14,
  t1.condicoes_entrega AS condicoes_entrega_15,
  t1.prazo_entrega AS prazo_entrega_16,
  t1.local_entrega AS local_entrega_17,
  t1.garantia AS garantia_18,
  t1.informacoes_gerais AS informacoes_gerais_19,
  t1.status AS status_20,
  t1.data AS data_21,
  t1.prazo_pagamento AS prazo_pagamento_22,
  t1.conta_bancaria_id AS conta_bancaria_id_23,
  t2.dt_disputa AS dt_disputa_24,
  t2.dt_fechamento AS dt_fechamento_25,
  t2.status AS status_26,
  t2.vlr_fechado AS vlr_fechado_27,
  t2.observacoes AS observacoes_28,
  t2.em_espera AS em_espera_29,
  t5.tipo_contratacao AS tipo_contratacao_30,
  t5.contrato AS contrato_31,
  t5.vigencia AS vigencia_32,
  t5.data_assinatura AS data_assinatura_33,
  t5.numero_contrato AS numero_contrato_34,
  t5.prazo_inicial AS prazo_inicial_35,
  t5.prazo_final AS prazo_final_36,
  t5.valor_inicial AS valor_inicial_37,
  t5.valor_final AS valor_final_38,
  t5.status AS status_39,
  t5.obs_finalizacao AS obs_finalizacao_40,
  t5.motivo_finalizacao AS motivo_finalizacao_41,
  t5.arquivo_finalizacao AS arquivo_finalizacao_42,
  t5.data_finalizacao AS data_finalizacao_43,
  t5.tipo_contrato AS tipo_contrato_44,
  t5.edital_id AS edital_id_45,
  t5.responsavel_id AS responsavel_id_46,
  t5.ata_registro_id AS ata_registro_id_47,
  t5.contratada_id AS contratada_id_48,
  t5.ata_contrato_id AS ata_contrato_id_49,
  t11.validade AS validade_50,
  t11.condicoes_entrega AS condicoes_entrega_51,
  t11.prazo_entrega AS prazo_entrega_52,
  t11.local_entrega AS local_entrega_53,
  t11.garantia AS garantia_54,
  t11.informacoes_gerais AS informacoes_gerais_55,
  t11.status AS status_56,
  t11.data AS data_57,
  t11.prazo_pagamento AS prazo_pagamento_58,
  t11.situacao AS situacao_59,
  t11.edital_id AS edital_id_60,
  t11.conta_bancaria_id AS conta_bancaria_id_61
FROM
  etapa_processo t0
  LEFT JOIN etapa_acolhimento_propostas t1 ON t0.id = t1.id
  LEFT JOIN etapa_disputa t2 ON t0.id = t2.id
  LEFT JOIN etapa_habilitacao t3 ON t0.id = t3.id
  LEFT JOIN etapa_registro_preco t4 ON t0.id = t4.id
  LEFT JOIN etapa_contrato t5 ON t0.id = t5.id
  LEFT JOIN etapa_autorizacao_fornecimento t6 ON t0.id = t6.id
  LEFT JOIN etapa_entrega_produto t7 ON t0.id = t7.id
  LEFT JOIN etapa_emissao_nf t8 ON t0.id = t8.id
  LEFT JOIN etapa_faturamento t9 ON t0.id = t9.id
  LEFT JOIN etapa_atestado_tecnico t10 ON t0.id = t10.id
  LEFT JOIN proposta_final t11 ON t0.id = t11.id
WHERE
  t0.id = ?

SELECT t0.id AS id_12, t0.created_at AS created_at_13, t0.tipo_etapa, t1.validade AS validade_14, t1.condicoes_entrega AS condicoes_entrega_15, t1.prazo_entrega AS prazo_entrega_16, t1.local_entrega AS local_entrega_17, t1.garantia AS garantia_18, t1.informacoes_gerais AS informacoes_gerais_19, t1.status AS status_20, t1.data AS data_21, t1.prazo_pagamento AS prazo_pagamento_22, t1.conta_bancaria_id AS conta_bancaria_id_23, t2.dt_disputa AS dt_disputa_24, t2.dt_fechamento AS dt_fechamento_25, t2.status AS status_26, t2.vlr_fechado AS vlr_fechado_27, t2.observacoes AS observacoes_28, t2.em_espera AS em_espera_29, t5.tipo_contratacao AS tipo_contratacao_30, t5.contrato AS contrato_31, t5.vigencia AS vigencia_32, t5.data_assinatura AS data_assinatura_33, t5.numero_contrato AS numero_contrato_34, t5.prazo_inicial AS prazo_inicial_35, t5.prazo_final AS prazo_final_36, t5.valor_inicial AS valor_inicial_37, t5.valor_final AS valor_final_38, t5.status AS status_39, t5.obs_finalizacao AS obs_finalizacao_40, t5.motivo_finalizacao AS motivo_finalizacao_41, t5.arquivo_finalizacao AS arquivo_finalizacao_42, t5.data_finalizacao AS data_finalizacao_43, t5.tipo_contrato AS tipo_contrato_44, t5.edital_id AS edital_id_45, t5.responsavel_id AS responsavel_id_46, t5.ata_registro_id AS ata_registro_id_47, t5.contratada_id AS contratada_id_48, t5.ata_contrato_id AS ata_contrato_id_49, t11.validade AS validade_50, t11.condicoes_entrega AS condicoes_entrega_51, t11.prazo_entrega AS prazo_entrega_52, t11.local_entrega AS local_entrega_53, t11.garantia AS garantia_54, t11.informacoes_gerais AS informacoes_gerais_55, t11.status AS status_56, t11.data AS data_57, t11.prazo_pagamento AS prazo_pagamento_58, t11.situacao AS situacao_59, t11.edital_id AS edital_id_60, t11.conta_bancaria_id AS conta_bancaria_id_61 FROM etapa_processo t0 LEFT JOIN etapa_acolhimento_propostas t1 ON t0.id = t1.id LEFT JOIN etapa_disputa t2 ON t0.id = t2.id LEFT JOIN etapa_habilitacao t3 ON t0.id = t3.id LEFT JOIN etapa_registro_preco t4 ON t0.id = t4.id LEFT JOIN etapa_contrato t5 ON t0.id = t5.id LEFT JOIN etapa_autorizacao_fornecimento t6 ON t0.id = t6.id LEFT JOIN etapa_entrega_produto t7 ON t0.id = t7.id LEFT JOIN etapa_emissao_nf t8 ON t0.id = t8.id LEFT JOIN etapa_faturamento t9 ON t0.id = t9.id LEFT JOIN etapa_atestado_tecnico t10 ON t0.id = t10.id LEFT JOIN proposta_final t11 ON t0.id = t11.id WHERE t0.id = 1888;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 780)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2514)
4	Doctrine\ORM\UnitOfWork->createEntity (line 176)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 60)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 168)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 744)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
10	Doctrine\ORM\EntityManager->find (line 86)
11	Doctrine\ORM\EntityRepository->find (line 61)
12	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
13	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
14	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
15	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
16	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
17	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 7)

4.35 ms
(6.48%)

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.cpf AS cpf_3, t0.rg AS rg_4, t0.telefone AS telefone_5, t0.celular AS celular_6, t0.email AS email_7, t0.created_at AS created_at_8, t0.data_admissao AS data_admissao_9, t0.data_demissao AS data_demissao_10, t0.ativo AS ativo_11, t0.situacao AS situacao_12, t0.password AS password_13, t0.role AS role_14, t0.endereco_id AS endereco_id_15, t0.cargo_id AS cargo_id_16, t0.empresa_registro_id AS empresa_registro_id_17, t0.tipo_cadastro FROM colaborador t0 WHERE t0.id = ?

Parameters:

[
  23
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.cpf AS cpf_3,
  t0.rg AS rg_4,
  t0.telefone AS telefone_5,
  t0.celular AS celular_6,
  t0.email AS email_7,
  t0.created_at AS created_at_8,
  t0.data_admissao AS data_admissao_9,
  t0.data_demissao AS data_demissao_10,
  t0.ativo AS ativo_11,
  t0.situacao AS situacao_12,
  t0.password AS password_13,
  t0.role AS role_14,
  t0.endereco_id AS endereco_id_15,
  t0.cargo_id AS cargo_id_16,
  t0.empresa_registro_id AS empresa_registro_id_17,
  t0.tipo_cadastro
FROM
  colaborador t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.cpf AS cpf_3, t0.rg AS rg_4, t0.telefone AS telefone_5, t0.celular AS celular_6, t0.email AS email_7, t0.created_at AS created_at_8, t0.data_admissao AS data_admissao_9, t0.data_demissao AS data_demissao_10, t0.ativo AS ativo_11, t0.situacao AS situacao_12, t0.password AS password_13, t0.role AS role_14, t0.endereco_id AS endereco_id_15, t0.cargo_id AS cargo_id_16, t0.empresa_registro_id AS empresa_registro_id_17, t0.tipo_cadastro FROM colaborador t0 WHERE t0.id = 23;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 7)

3.47 ms
(5.18%)

SELECT t0.id AS id_1, t0.quantidade AS quantidade_2, t0.valor_unitario AS valor_unitario_3, t0.valor_fechado AS valor_fechado_4, t0.item_descricao AS item_descricao_5, t0.created_at AS created_at_6, t0.margem AS margem_7, t0.numero_item AS numero_item_8, t0.valor_instalacao AS valor_instalacao_9, t0.individual_lote AS individual_lote_10, t0.numero_lote AS numero_lote_11, t0.is_substituido AS is_substituido_12, t0.ativo AS ativo_13, t0.proposta_id AS proposta_id_14, t0.produto_id AS produto_id_15 FROM item_proposta_final t0 WHERE t0.proposta_id = ?

Parameters:

[
  1888
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantidade AS quantidade_2,
  t0.valor_unitario AS valor_unitario_3,
  t0.valor_fechado AS valor_fechado_4,
  t0.item_descricao AS item_descricao_5,
  t0.created_at AS created_at_6,
  t0.margem AS margem_7,
  t0.numero_item AS numero_item_8,
  t0.valor_instalacao AS valor_instalacao_9,
  t0.individual_lote AS individual_lote_10,
  t0.numero_lote AS numero_lote_11,
  t0.is_substituido AS is_substituido_12,
  t0.ativo AS ativo_13,
  t0.proposta_id AS proposta_id_14,
  t0.produto_id AS produto_id_15
FROM
  item_proposta_final t0
WHERE
  t0.proposta_id = ?

SELECT t0.id AS id_1, t0.quantidade AS quantidade_2, t0.valor_unitario AS valor_unitario_3, t0.valor_fechado AS valor_fechado_4, t0.item_descricao AS item_descricao_5, t0.created_at AS created_at_6, t0.margem AS margem_7, t0.numero_item AS numero_item_8, t0.valor_instalacao AS valor_instalacao_9, t0.individual_lote AS individual_lote_10, t0.numero_lote AS numero_lote_11, t0.is_substituido AS is_substituido_12, t0.ativo AS ativo_13, t0.proposta_id AS proposta_id_14, t0.produto_id AS produto_id_15 FROM item_proposta_final t0 WHERE t0.proposta_id = 1888;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 50)
8	App\Services\ConstrutorPropostasLoteSvc->construirPropostaFinal (line 377)
9	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 7)

3.29 ms
(4.91%)

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pedido p0_ WHERE p0_.edital_id = ?

Parameters:

[
  1500
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  pedido p0_
WHERE
  p0_.edital_id = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pedido p0_ WHERE p0_.edital_id = 1500;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerZAtxlZm\PaginatorProxyBa079e5->paginate (line 383)
16	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 7)

2.82 ms
(4.20%)

SELECT t1.id AS id_2, t1.valor AS valor_3, t1.data_vencimento AS data_vencimento_4, t1.pago AS pago_5, t1.created_at AS created_at_6, t1.beneficiario AS beneficiario_7, t1.arquivo AS arquivo_8, t1.ativo AS ativo_9, t1.descricao AS descricao_10, t1.vista_prazo AS vista_prazo_11, t1.num_parcela AS num_parcela_12, t1.qtd_parcelas AS qtd_parcelas_13, t1.observacoes AS observacoes_14, t1.recorrencia AS recorrencia_15, t0.nf AS nf_16, t0.status AS status_17, t1.tipo_movimentacao_id AS tipo_movimentacao_id_18, t1.saida_caixa_id AS saida_caixa_id_19, t1.incluido_por_id AS incluido_por_id_20, t1.empresa_id AS empresa_id_21, t1.parcela_de_conta_id AS parcela_de_conta_id_22, t0.ref_pedido_id AS ref_pedido_id_23, t0.fornecedor_id AS fornecedor_id_24, t1.tipo_fatura FROM conta_pagar_pedido t0 INNER JOIN conta_pagar t1 ON t0.id = t1.id WHERE t0.ref_pedido_id = ?

Parameters:

[
  332
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.valor AS valor_3,
  t1.data_vencimento AS data_vencimento_4,
  t1.pago AS pago_5,
  t1.created_at AS created_at_6,
  t1.beneficiario AS beneficiario_7,
  t1.arquivo AS arquivo_8,
  t1.ativo AS ativo_9,
  t1.descricao AS descricao_10,
  t1.vista_prazo AS vista_prazo_11,
  t1.num_parcela AS num_parcela_12,
  t1.qtd_parcelas AS qtd_parcelas_13,
  t1.observacoes AS observacoes_14,
  t1.recorrencia AS recorrencia_15,
  t0.nf AS nf_16,
  t0.status AS status_17,
  t1.tipo_movimentacao_id AS tipo_movimentacao_id_18,
  t1.saida_caixa_id AS saida_caixa_id_19,
  t1.incluido_por_id AS incluido_por_id_20,
  t1.empresa_id AS empresa_id_21,
  t1.parcela_de_conta_id AS parcela_de_conta_id_22,
  t0.ref_pedido_id AS ref_pedido_id_23,
  t0.fornecedor_id AS fornecedor_id_24,
  t1.tipo_fatura
FROM
  conta_pagar_pedido t0
  INNER JOIN conta_pagar t1 ON t0.id = t1.id
WHERE
  t0.ref_pedido_id = ?

SELECT t1.id AS id_2, t1.valor AS valor_3, t1.data_vencimento AS data_vencimento_4, t1.pago AS pago_5, t1.created_at AS created_at_6, t1.beneficiario AS beneficiario_7, t1.arquivo AS arquivo_8, t1.ativo AS ativo_9, t1.descricao AS descricao_10, t1.vista_prazo AS vista_prazo_11, t1.num_parcela AS num_parcela_12, t1.qtd_parcelas AS qtd_parcelas_13, t1.observacoes AS observacoes_14, t1.recorrencia AS recorrencia_15, t0.nf AS nf_16, t0.status AS status_17, t1.tipo_movimentacao_id AS tipo_movimentacao_id_18, t1.saida_caixa_id AS saida_caixa_id_19, t1.incluido_por_id AS incluido_por_id_20, t1.empresa_id AS empresa_id_21, t1.parcela_de_conta_id AS parcela_de_conta_id_22, t0.ref_pedido_id AS ref_pedido_id_23, t0.fornecedor_id AS fornecedor_id_24, t1.tipo_fatura FROM conta_pagar_pedido t0 INNER JOIN conta_pagar t1 ON t0.id = t1.id WHERE t0.ref_pedido_id = 332;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1241)
9	Twig\Extension\CoreExtension::length (line 75)
10	__TwigTemplate_7923ae2a01200cb4185d97c35eee10e5->block_content (line 432)
11	Twig\Template->yieldBlock (line 49)
12	__TwigTemplate_7923ae2a01200cb4185d97c35eee10e5->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 1493)
17	Twig\Extension\CoreExtension::include (line 573)
18	__TwigTemplate_0bcd3dc3669c1aa78699c98340e5c2c2->block_content (line 432)
19	Twig\Template->yieldBlock (line 53)
20	__TwigTemplate_0bcd3dc3669c1aa78699c98340e5c2c2->doDisplay (line 388)
21	Twig\Template->yield (line 344)
22	Twig\Template->display (line 359)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 1493)
25	Twig\Extension\CoreExtension::include (line 141)
26	__TwigTemplate_baa70cbc7e18cabae3fbc35725f038a5->doDisplay (line 388)
27	Twig\Template->yield (line 344)
28	Twig\Template->display (line 359)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 1493)
31	Twig\Extension\CoreExtension::include (line 287)
32	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->block_content (line 432)
33	Twig\Template->yieldBlock (line 144)
34	__TwigTemplate_a711e81f273bebcbaadcdbdaa48b5830->doDisplay (line 388)
35	Twig\Template->yield (line 56)
36	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->doDisplay (line 388)
37	Twig\Template->yield (line 344)
38	Twig\Template->display (line 359)
39	Twig\Template->render (line 51)
40	Twig\TemplateWrapper->render (line 334)
41	Twig\Environment->render (line 431)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
45	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
46	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
47	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
48	Symfony\Component\HttpKernel\Kernel->handle (line 35)
49	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
50	require_once (line 7)

2.72 ms
(4.06%)

SELECT t1.id AS id_2, t1.razao_social AS razao_social_3, t1.nome_fantasia AS nome_fantasia_4, t1.cnpj AS cnpj_5, t1.inscricao_estadual AS inscricao_estadual_6, t1.ie_isento AS ie_isento_7, t1.telefone AS telefone_8, t1.celular AS celular_9, t1.nome_contato AS nome_contato_10, t1.site AS site_11, t1.email AS email_12, t1.cargo_contato AS cargo_contato_13, t1.created_at AS created_at_14, t1.ativo AS ativo_15, t0.inscricao_municipal AS inscricao_municipal_16, t0.template AS template_17, t0.logitpo_empresa AS logitpo_empresa_18, t0.assinatura_diretor AS assinatura_diretor_19, t0.data_abertura AS data_abertura_20, t0.regime_tributario AS regime_tributario_21, t0.info_adicional_nf AS info_adicional_nf_22, t0.cpf_proprietario AS cpf_proprietario_23, t0.token_focus AS token_focus_24, t0.token_focus_homologacao AS token_focus_homologacao_25, t0.prazo_pagamento_emissao_nf AS prazo_pagamento_emissao_nf_26, t1.endereco_id AS endereco_id_27, t1.tipo_cadastro FROM empresa t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = ?

Parameters:

[
  115
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.razao_social AS razao_social_3,
  t1.nome_fantasia AS nome_fantasia_4,
  t1.cnpj AS cnpj_5,
  t1.inscricao_estadual AS inscricao_estadual_6,
  t1.ie_isento AS ie_isento_7,
  t1.telefone AS telefone_8,
  t1.celular AS celular_9,
  t1.nome_contato AS nome_contato_10,
  t1.site AS site_11,
  t1.email AS email_12,
  t1.cargo_contato AS cargo_contato_13,
  t1.created_at AS created_at_14,
  t1.ativo AS ativo_15,
  t0.inscricao_municipal AS inscricao_municipal_16,
  t0.template AS template_17,
  t0.logitpo_empresa AS logitpo_empresa_18,
  t0.assinatura_diretor AS assinatura_diretor_19,
  t0.data_abertura AS data_abertura_20,
  t0.regime_tributario AS regime_tributario_21,
  t0.info_adicional_nf AS info_adicional_nf_22,
  t0.cpf_proprietario AS cpf_proprietario_23,
  t0.token_focus AS token_focus_24,
  t0.token_focus_homologacao AS token_focus_homologacao_25,
  t0.prazo_pagamento_emissao_nf AS prazo_pagamento_emissao_nf_26,
  t1.endereco_id AS endereco_id_27,
  t1.tipo_cadastro
FROM
  empresa t0
  INNER JOIN dados_juridica t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.razao_social AS razao_social_3, t1.nome_fantasia AS nome_fantasia_4, t1.cnpj AS cnpj_5, t1.inscricao_estadual AS inscricao_estadual_6, t1.ie_isento AS ie_isento_7, t1.telefone AS telefone_8, t1.celular AS celular_9, t1.nome_contato AS nome_contato_10, t1.site AS site_11, t1.email AS email_12, t1.cargo_contato AS cargo_contato_13, t1.created_at AS created_at_14, t1.ativo AS ativo_15, t0.inscricao_municipal AS inscricao_municipal_16, t0.template AS template_17, t0.logitpo_empresa AS logitpo_empresa_18, t0.assinatura_diretor AS assinatura_diretor_19, t0.data_abertura AS data_abertura_20, t0.regime_tributario AS regime_tributario_21, t0.info_adicional_nf AS info_adicional_nf_22, t0.cpf_proprietario AS cpf_proprietario_23, t0.token_focus AS token_focus_24, t0.token_focus_homologacao AS token_focus_homologacao_25, t0.prazo_pagamento_emissao_nf AS prazo_pagamento_emissao_nf_26, t1.endereco_id AS endereco_id_27, t1.tipo_cadastro FROM empresa t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = 115;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Empresas\Empresa::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Empresas\Empresa->__get (line 93)
8	App\Entity\Empresas\DadosJuridica->getRazaoSocial (line 157)
9	App\Entity\Empresas\Empresa->__toString (line 126)
10	Twig\Runtime\EscaperRuntime->escape (line 89)
11	__TwigTemplate_9a69586a859a750291033d7e2ed324cc->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 1493)
16	Twig\Extension\CoreExtension::include (line 269)
17	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->block_content (line 432)
18	Twig\Template->yieldBlock (line 144)
19	__TwigTemplate_a711e81f273bebcbaadcdbdaa48b5830->doDisplay (line 388)
20	Twig\Template->yield (line 56)
21	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
30	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 7)

2.69 ms
(4.02%)

SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.pdf_edital AS pdf_edital_3, t0.pdf_termo_referencia AS pdf_termo_referencia_4, t0.data_publicacao AS data_publicacao_5, t0.data_cadastro AS data_cadastro_6, t0.data_etapa_acolhimento AS data_etapa_acolhimento_7, t0.data_etapa_disputa AS data_etapa_disputa_8, t0.datat_etapa_habilitacao AS datat_etapa_habilitacao_9, t0.registro_preco AS registro_preco_10, t0.data_etapa_contrato AS data_etapa_contrato_11, t0.data_etapa_autorizacao_fornecimento AS data_etapa_autorizacao_fornecimento_12, t0.data_etapa_entrega_produto AS data_etapa_entrega_produto_13, t0.data_etapa_emissao_nf AS data_etapa_emissao_nf_14, t0.data_etapa_faturamento AS data_etapa_faturamento_15, t0.data_etapa_att AS data_etapa_att_16, t0.status AS status_17, t0.cod_etapa_atual AS cod_etapa_atual_18, t0.numero AS numero_19, t0.id_plataforma AS id_plataforma_20, t0.updated_at AS updated_at_21, t0.motivo_finalizacao AS motivo_finalizacao_22, t0.obs_finalizacao AS obs_finalizacao_23, t0.arquivo_finalizacao AS arquivo_finalizacao_24, t0.created_at AS created_at_25, t0.ativo AS ativo_26, t0.numero_ata AS numero_ata_27, t0.nome_do_cliente AS nome_do_cliente_28, t0.modelo_disputa AS modelo_disputa_29, t0.observacoes AS observacoes_30, t0.comissao_empresa AS comissao_empresa_31, t0.tipo_proposta AS tipo_proposta_32, t0.registrado_compras AS registrado_compras_33, t0.uasg_orgao AS uasg_orgao_34, t0.cliente_id AS cliente_id_35, t0.responsavel_id AS responsavel_id_36, t0.responsavel_comissionado_id AS responsavel_comissionado_id_37, t0.empresa_id AS empresa_id_38, t0.etapa_atual_id AS etapa_atual_id_39, t0.etapa_acolhimento_proposta_id AS etapa_acolhimento_proposta_id_40, t0.etapa_disputa_id AS etapa_disputa_id_41, t0.etapa_habilitacao_id AS etapa_habilitacao_id_42, t0.etapa_autorizacao_fornecimento_id AS etapa_autorizacao_fornecimento_id_43, t0.etapa_entrega_produto_id AS etapa_entrega_produto_id_44, t0.etapa_emissao_nf_id AS etapa_emissao_nf_id_45, t0.etapa_faturamento_id AS etapa_faturamento_id_46, t0.etapa_atestado_tecnico_id AS etapa_atestado_tecnico_id_47, t0.plataforma_id AS plataforma_id_48, t0.estado_id AS estado_id_49 FROM edital t0 WHERE t0.id = ?

Parameters:

[
  "1500"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.descricao AS descricao_2,
  t0.pdf_edital AS pdf_edital_3,
  t0.pdf_termo_referencia AS pdf_termo_referencia_4,
  t0.data_publicacao AS data_publicacao_5,
  t0.data_cadastro AS data_cadastro_6,
  t0.data_etapa_acolhimento AS data_etapa_acolhimento_7,
  t0.data_etapa_disputa AS data_etapa_disputa_8,
  t0.datat_etapa_habilitacao AS datat_etapa_habilitacao_9,
  t0.registro_preco AS registro_preco_10,
  t0.data_etapa_contrato AS data_etapa_contrato_11,
  t0.data_etapa_autorizacao_fornecimento AS data_etapa_autorizacao_fornecimento_12,
  t0.data_etapa_entrega_produto AS data_etapa_entrega_produto_13,
  t0.data_etapa_emissao_nf AS data_etapa_emissao_nf_14,
  t0.data_etapa_faturamento AS data_etapa_faturamento_15,
  t0.data_etapa_att AS data_etapa_att_16,
  t0.status AS status_17,
  t0.cod_etapa_atual AS cod_etapa_atual_18,
  t0.numero AS numero_19,
  t0.id_plataforma AS id_plataforma_20,
  t0.updated_at AS updated_at_21,
  t0.motivo_finalizacao AS motivo_finalizacao_22,
  t0.obs_finalizacao AS obs_finalizacao_23,
  t0.arquivo_finalizacao AS arquivo_finalizacao_24,
  t0.created_at AS created_at_25,
  t0.ativo AS ativo_26,
  t0.numero_ata AS numero_ata_27,
  t0.nome_do_cliente AS nome_do_cliente_28,
  t0.modelo_disputa AS modelo_disputa_29,
  t0.observacoes AS observacoes_30,
  t0.comissao_empresa AS comissao_empresa_31,
  t0.tipo_proposta AS tipo_proposta_32,
  t0.registrado_compras AS registrado_compras_33,
  t0.uasg_orgao AS uasg_orgao_34,
  t0.cliente_id AS cliente_id_35,
  t0.responsavel_id AS responsavel_id_36,
  t0.responsavel_comissionado_id AS responsavel_comissionado_id_37,
  t0.empresa_id AS empresa_id_38,
  t0.etapa_atual_id AS etapa_atual_id_39,
  t0.etapa_acolhimento_proposta_id AS etapa_acolhimento_proposta_id_40,
  t0.etapa_disputa_id AS etapa_disputa_id_41,
  t0.etapa_habilitacao_id AS etapa_habilitacao_id_42,
  t0.etapa_autorizacao_fornecimento_id AS etapa_autorizacao_fornecimento_id_43,
  t0.etapa_entrega_produto_id AS etapa_entrega_produto_id_44,
  t0.etapa_emissao_nf_id AS etapa_emissao_nf_id_45,
  t0.etapa_faturamento_id AS etapa_faturamento_id_46,
  t0.etapa_atestado_tecnico_id AS etapa_atestado_tecnico_id_47,
  t0.plataforma_id AS plataforma_id_48,
  t0.estado_id AS estado_id_49
FROM
  edital t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.pdf_edital AS pdf_edital_3, t0.pdf_termo_referencia AS pdf_termo_referencia_4, t0.data_publicacao AS data_publicacao_5, t0.data_cadastro AS data_cadastro_6, t0.data_etapa_acolhimento AS data_etapa_acolhimento_7, t0.data_etapa_disputa AS data_etapa_disputa_8, t0.datat_etapa_habilitacao AS datat_etapa_habilitacao_9, t0.registro_preco AS registro_preco_10, t0.data_etapa_contrato AS data_etapa_contrato_11, t0.data_etapa_autorizacao_fornecimento AS data_etapa_autorizacao_fornecimento_12, t0.data_etapa_entrega_produto AS data_etapa_entrega_produto_13, t0.data_etapa_emissao_nf AS data_etapa_emissao_nf_14, t0.data_etapa_faturamento AS data_etapa_faturamento_15, t0.data_etapa_att AS data_etapa_att_16, t0.status AS status_17, t0.cod_etapa_atual AS cod_etapa_atual_18, t0.numero AS numero_19, t0.id_plataforma AS id_plataforma_20, t0.updated_at AS updated_at_21, t0.motivo_finalizacao AS motivo_finalizacao_22, t0.obs_finalizacao AS obs_finalizacao_23, t0.arquivo_finalizacao AS arquivo_finalizacao_24, t0.created_at AS created_at_25, t0.ativo AS ativo_26, t0.numero_ata AS numero_ata_27, t0.nome_do_cliente AS nome_do_cliente_28, t0.modelo_disputa AS modelo_disputa_29, t0.observacoes AS observacoes_30, t0.comissao_empresa AS comissao_empresa_31, t0.tipo_proposta AS tipo_proposta_32, t0.registrado_compras AS registrado_compras_33, t0.uasg_orgao AS uasg_orgao_34, t0.cliente_id AS cliente_id_35, t0.responsavel_id AS responsavel_id_36, t0.responsavel_comissionado_id AS responsavel_comissionado_id_37, t0.empresa_id AS empresa_id_38, t0.etapa_atual_id AS etapa_atual_id_39, t0.etapa_acolhimento_proposta_id AS etapa_acolhimento_proposta_id_40, t0.etapa_disputa_id AS etapa_disputa_id_41, t0.etapa_habilitacao_id AS etapa_habilitacao_id_42, t0.etapa_autorizacao_fornecimento_id AS etapa_autorizacao_fornecimento_id_43, t0.etapa_entrega_produto_id AS etapa_entrega_produto_id_44, t0.etapa_emissao_nf_id AS etapa_emissao_nf_id_45, t0.etapa_faturamento_id AS etapa_faturamento_id_46, t0.etapa_atestado_tecnico_id AS etapa_atestado_tecnico_id_47, t0.plataforma_id AS plataforma_id_48, t0.estado_id AS estado_id_49 FROM edital t0 WHERE t0.id = '1500';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 7)

2.60 ms
(3.88%)

SELECT t1.id AS id_2, t1.natureza_operacao AS natureza_operacao_3, t1.data_emissao AS data_emissao_4, t1.data_entrada_saida AS data_entrada_saida_5, t1.tipo_documento AS tipo_documento_6, t1.finalidade_emissao AS finalidade_emissao_7, t1.valor_frete AS valor_frete_8, t1.valor_seguro AS valor_seguro_9, t1.valor_total AS valor_total_10, t1.valor_produtos AS valor_produtos_11, t1.modalidade_frete AS modalidade_frete_12, t1.cfop AS cfop_13, t1.observacao AS observacao_14, t1.situacao AS situacao_15, t1.consumidor_final AS consumidor_final_16, t1.presenca_comprador AS presenca_comprador_17, t1.local_destino AS local_destino_18, t1.nf_referencia AS nf_referencia_19, t1.nf_status AS nf_status_20, t1.nf_status_sefaz AS nf_status_sefaz_21, t1.nf_mensagem_sefaz AS nf_mensagem_sefaz_22, t1.nf_chave_nfe AS nf_chave_nfe_23, t1.nf_numero AS nf_numero_24, t1.nf_serie AS nf_serie_25, t1.nf_caminho_xml_nota_fiscal AS nf_caminho_xml_nota_fiscal_26, t1.nf_caminho_danfe AS nf_caminho_danfe_27, t1.ativo AS ativo_28, t1.codigo_erro AS codigo_erro_29, t1.mensagem_erro AS mensagem_erro_30, t1.veiculo_placa AS veiculo_placa_31, t1.nf_caminho_danfe_aws AS nf_caminho_danfe_aws_32, t1.referencia AS referencia_33, t1.nf_caminho_xml_cancelada AS nf_caminho_xml_cancelada_34, t1.nf_caminho_danfe_cancelada AS nf_caminho_danfe_cancelada_35, t1.justificativa_cancelamento AS justificativa_cancelamento_36, t1.gerar_conta_receber AS gerar_conta_receber_37, t1.clonado_de AS clonado_de_38, t1.empresa_id AS empresa_id_39, t1.cliente_id AS cliente_id_40, t1.transportadora_id AS transportadora_id_41, t1.criado_por_id AS criado_por_id_42, t0.pedido_id AS pedido_id_43, t1.tipo_fatura FROM nota_fiscal_eletronica_pedido t0 INNER JOIN nota_fiscal_eletronica t1 ON t0.id = t1.id WHERE t0.pedido_id = ?

Parameters:

[
  332
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.natureza_operacao AS natureza_operacao_3,
  t1.data_emissao AS data_emissao_4,
  t1.data_entrada_saida AS data_entrada_saida_5,
  t1.tipo_documento AS tipo_documento_6,
  t1.finalidade_emissao AS finalidade_emissao_7,
  t1.valor_frete AS valor_frete_8,
  t1.valor_seguro AS valor_seguro_9,
  t1.valor_total AS valor_total_10,
  t1.valor_produtos AS valor_produtos_11,
  t1.modalidade_frete AS modalidade_frete_12,
  t1.cfop AS cfop_13,
  t1.observacao AS observacao_14,
  t1.situacao AS situacao_15,
  t1.consumidor_final AS consumidor_final_16,
  t1.presenca_comprador AS presenca_comprador_17,
  t1.local_destino AS local_destino_18,
  t1.nf_referencia AS nf_referencia_19,
  t1.nf_status AS nf_status_20,
  t1.nf_status_sefaz AS nf_status_sefaz_21,
  t1.nf_mensagem_sefaz AS nf_mensagem_sefaz_22,
  t1.nf_chave_nfe AS nf_chave_nfe_23,
  t1.nf_numero AS nf_numero_24,
  t1.nf_serie AS nf_serie_25,
  t1.nf_caminho_xml_nota_fiscal AS nf_caminho_xml_nota_fiscal_26,
  t1.nf_caminho_danfe AS nf_caminho_danfe_27,
  t1.ativo AS ativo_28,
  t1.codigo_erro AS codigo_erro_29,
  t1.mensagem_erro AS mensagem_erro_30,
  t1.veiculo_placa AS veiculo_placa_31,
  t1.nf_caminho_danfe_aws AS nf_caminho_danfe_aws_32,
  t1.referencia AS referencia_33,
  t1.nf_caminho_xml_cancelada AS nf_caminho_xml_cancelada_34,
  t1.nf_caminho_danfe_cancelada AS nf_caminho_danfe_cancelada_35,
  t1.justificativa_cancelamento AS justificativa_cancelamento_36,
  t1.gerar_conta_receber AS gerar_conta_receber_37,
  t1.clonado_de AS clonado_de_38,
  t1.empresa_id AS empresa_id_39,
  t1.cliente_id AS cliente_id_40,
  t1.transportadora_id AS transportadora_id_41,
  t1.criado_por_id AS criado_por_id_42,
  t0.pedido_id AS pedido_id_43,
  t1.tipo_fatura
FROM
  nota_fiscal_eletronica_pedido t0
  INNER JOIN nota_fiscal_eletronica t1 ON t0.id = t1.id
WHERE
  t0.pedido_id = ?

SELECT t1.id AS id_2, t1.natureza_operacao AS natureza_operacao_3, t1.data_emissao AS data_emissao_4, t1.data_entrada_saida AS data_entrada_saida_5, t1.tipo_documento AS tipo_documento_6, t1.finalidade_emissao AS finalidade_emissao_7, t1.valor_frete AS valor_frete_8, t1.valor_seguro AS valor_seguro_9, t1.valor_total AS valor_total_10, t1.valor_produtos AS valor_produtos_11, t1.modalidade_frete AS modalidade_frete_12, t1.cfop AS cfop_13, t1.observacao AS observacao_14, t1.situacao AS situacao_15, t1.consumidor_final AS consumidor_final_16, t1.presenca_comprador AS presenca_comprador_17, t1.local_destino AS local_destino_18, t1.nf_referencia AS nf_referencia_19, t1.nf_status AS nf_status_20, t1.nf_status_sefaz AS nf_status_sefaz_21, t1.nf_mensagem_sefaz AS nf_mensagem_sefaz_22, t1.nf_chave_nfe AS nf_chave_nfe_23, t1.nf_numero AS nf_numero_24, t1.nf_serie AS nf_serie_25, t1.nf_caminho_xml_nota_fiscal AS nf_caminho_xml_nota_fiscal_26, t1.nf_caminho_danfe AS nf_caminho_danfe_27, t1.ativo AS ativo_28, t1.codigo_erro AS codigo_erro_29, t1.mensagem_erro AS mensagem_erro_30, t1.veiculo_placa AS veiculo_placa_31, t1.nf_caminho_danfe_aws AS nf_caminho_danfe_aws_32, t1.referencia AS referencia_33, t1.nf_caminho_xml_cancelada AS nf_caminho_xml_cancelada_34, t1.nf_caminho_danfe_cancelada AS nf_caminho_danfe_cancelada_35, t1.justificativa_cancelamento AS justificativa_cancelamento_36, t1.gerar_conta_receber AS gerar_conta_receber_37, t1.clonado_de AS clonado_de_38, t1.empresa_id AS empresa_id_39, t1.cliente_id AS cliente_id_40, t1.transportadora_id AS transportadora_id_41, t1.criado_por_id AS criado_por_id_42, t0.pedido_id AS pedido_id_43, t1.tipo_fatura FROM nota_fiscal_eletronica_pedido t0 INNER JOIN nota_fiscal_eletronica t1 ON t0.id = t1.id WHERE t0.pedido_id = 332;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1241)
9	Twig\Extension\CoreExtension::length (line 70)
10	__TwigTemplate_331e03cda4d71e206dccf6cd1a59b5f3->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1493)
15	Twig\Extension\CoreExtension::include (line 56)
16	__TwigTemplate_90ecb54ac847dd04796fa9bf5eae6127->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1493)
21	Twig\Extension\CoreExtension::include (line 275)
22	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->block_content (line 432)
23	Twig\Template->yieldBlock (line 144)
24	__TwigTemplate_a711e81f273bebcbaadcdbdaa48b5830->doDisplay (line 388)
25	Twig\Template->yield (line 56)
26	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->doDisplay (line 388)
27	Twig\Template->yield (line 344)
28	Twig\Template->display (line 359)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 334)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
35	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 7)

2.43 ms
(3.62%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.observacoes AS observacoes_4, t0.ativo AS ativo_5, t0.solicitado_por_id AS solicitado_por_id_6, t0.cotacao_selecionada_id AS cotacao_selecionada_id_7, t0.pedido_id AS pedido_id_8 FROM solicitacao_aprovacao_produto t0 WHERE t0.pedido_id = ?

Parameters:

[
  332
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.status AS status_3,
  t0.observacoes AS observacoes_4,
  t0.ativo AS ativo_5,
  t0.solicitado_por_id AS solicitado_por_id_6,
  t0.cotacao_selecionada_id AS cotacao_selecionada_id_7,
  t0.pedido_id AS pedido_id_8
FROM
  solicitacao_aprovacao_produto t0
WHERE
  t0.pedido_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.observacoes AS observacoes_4, t0.ativo AS ativo_5, t0.solicitado_por_id AS solicitado_por_id_6, t0.cotacao_selecionada_id AS cotacao_selecionada_id_7, t0.pedido_id AS pedido_id_8 FROM solicitacao_aprovacao_produto t0 WHERE t0.pedido_id = 332;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 145)
12	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
13	iterator_to_array (line 45)
14	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
19	Knp\Component\Pager\Paginator->paginate (line 25)
20	ContainerZAtxlZm\PaginatorProxyBa079e5->paginate (line 383)
21	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 7)

2.42 ms
(3.60%)

SELECT t1.id AS id_2, t1.razao_social AS razao_social_3, t1.nome_fantasia AS nome_fantasia_4, t1.cnpj AS cnpj_5, t1.inscricao_estadual AS inscricao_estadual_6, t1.ie_isento AS ie_isento_7, t1.telefone AS telefone_8, t1.celular AS celular_9, t1.nome_contato AS nome_contato_10, t1.site AS site_11, t1.email AS email_12, t1.cargo_contato AS cargo_contato_13, t1.created_at AS created_at_14, t1.ativo AS ativo_15, t0.inscricao_municipal AS inscricao_municipal_16, t1.endereco_id AS endereco_id_17, t1.tipo_cadastro FROM cliente t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = ?

Parameters:

[
  406
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.razao_social AS razao_social_3,
  t1.nome_fantasia AS nome_fantasia_4,
  t1.cnpj AS cnpj_5,
  t1.inscricao_estadual AS inscricao_estadual_6,
  t1.ie_isento AS ie_isento_7,
  t1.telefone AS telefone_8,
  t1.celular AS celular_9,
  t1.nome_contato AS nome_contato_10,
  t1.site AS site_11,
  t1.email AS email_12,
  t1.cargo_contato AS cargo_contato_13,
  t1.created_at AS created_at_14,
  t1.ativo AS ativo_15,
  t0.inscricao_municipal AS inscricao_municipal_16,
  t1.endereco_id AS endereco_id_17,
  t1.tipo_cadastro
FROM
  cliente t0
  INNER JOIN dados_juridica t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.razao_social AS razao_social_3, t1.nome_fantasia AS nome_fantasia_4, t1.cnpj AS cnpj_5, t1.inscricao_estadual AS inscricao_estadual_6, t1.ie_isento AS ie_isento_7, t1.telefone AS telefone_8, t1.celular AS celular_9, t1.nome_contato AS nome_contato_10, t1.site AS site_11, t1.email AS email_12, t1.cargo_contato AS cargo_contato_13, t1.created_at AS created_at_14, t1.ativo AS ativo_15, t0.inscricao_municipal AS inscricao_municipal_16, t1.endereco_id AS endereco_id_17, t1.tipo_cadastro FROM cliente t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = 406;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Operacional\Vendas\Cliente::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Operacional\Vendas\Cliente->__get (line 93)
8	App\Entity\Empresas\DadosJuridica->getRazaoSocial (line 42)
9	App\Entity\Operacional\Vendas\Cliente->__toString (line 126)
10	Twig\Runtime\EscaperRuntime->escape (line 96)
11	__TwigTemplate_9a69586a859a750291033d7e2ed324cc->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 1493)
16	Twig\Extension\CoreExtension::include (line 269)
17	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->block_content (line 432)
18	Twig\Template->yieldBlock (line 144)
19	__TwigTemplate_a711e81f273bebcbaadcdbdaa48b5830->doDisplay (line 388)
20	Twig\Template->yield (line 56)
21	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
30	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 7)

2.27 ms
(3.39%)

SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.created_at AS created_at_3, t0.ativo AS ativo_4 FROM marca t0 WHERE t0.id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.descricao AS descricao_2,
  t0.created_at AS created_at_3,
  t0.ativo AS ativo_4
FROM
  marca t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.created_at AS created_at_3, t0.ativo AS ativo_4 FROM marca t0 WHERE t0.id = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Operacional\Produtos\Marca::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Operacional\Produtos\Marca->__get (line 51)
8	App\Entity\Operacional\Produtos\Marca->getDescricao (line 93)
9	App\Entity\Operacional\Produtos\Marca->__toString (line 179)
10	App\Entity\Operacional\Produtos\Produto->getNomeComposto (line 1882)
11	Twig\Extension\CoreExtension::getAttribute (line 117)
12	__TwigTemplate_aa3889af3af29b83976a87b230cc1fea->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 1493)
17	Twig\Extension\CoreExtension::include (line 126)
18	__TwigTemplate_a4f80f262d440c9defa7058a4ae61c5b->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 1493)
23	Twig\Extension\CoreExtension::include (line 281)
24	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->block_content (line 432)
25	Twig\Template->yieldBlock (line 144)
26	__TwigTemplate_a711e81f273bebcbaadcdbdaa48b5830->doDisplay (line 388)
27	Twig\Template->yield (line 56)
28	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->doDisplay (line 388)
29	Twig\Template->yield (line 344)
30	Twig\Template->display (line 359)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 334)
33	Twig\Environment->render (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
37	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 7)

2.26 ms
(3.38%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.observacoes AS observacoes_4, t0.ativo AS ativo_5, t0.pedido_id AS pedido_id_6, t0.solicitado_por_id AS solicitado_por_id_7, t0.cotacao_selecionada_id AS cotacao_selecionada_id_8 FROM solicitacao_aprovacao_frete t0 WHERE t0.pedido_id = ?

Parameters:

[
  332
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.status AS status_3,
  t0.observacoes AS observacoes_4,
  t0.ativo AS ativo_5,
  t0.pedido_id AS pedido_id_6,
  t0.solicitado_por_id AS solicitado_por_id_7,
  t0.cotacao_selecionada_id AS cotacao_selecionada_id_8
FROM
  solicitacao_aprovacao_frete t0
WHERE
  t0.pedido_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.observacoes AS observacoes_4, t0.ativo AS ativo_5, t0.pedido_id AS pedido_id_6, t0.solicitado_por_id AS solicitado_por_id_7, t0.cotacao_selecionada_id AS cotacao_selecionada_id_8 FROM solicitacao_aprovacao_frete t0 WHERE t0.pedido_id = 332;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 145)
12	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
13	iterator_to_array (line 45)
14	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
19	Knp\Component\Pager\Paginator->paginate (line 25)
20	ContainerZAtxlZm\PaginatorProxyBa079e5->paginate (line 383)
21	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 7)

2.24 ms
(3.35%)

SELECT t1.id AS id_2, t1.data_cotacao AS data_cotacao_3, t1.observacoes AS observacoes_4, t1.anexo AS anexo_5, t1.numero_orcamento AS numero_orcamento_6, t1.endereco AS endereco_7, t1.tipo_frete AS tipo_frete_8, t1.condicoes_pgto AS condicoes_pgto_9, t1.prazo_entrega AS prazo_entrega_10, t1.validade_proposta AS validade_proposta_11, t1.valor_frete AS valor_frete_12, t1.status AS status_13, t1.orcamento_aprovado AS orcamento_aprovado_14, t1.ativo AS ativo_15, t1.fornecedor_id AS fornecedor_id_16, t0.edital_id AS edital_id_17, t0.pedido_id AS pedido_id_18, t1.origem_cotacao FROM cotacao_edital t0 INNER JOIN cotacao_produto t1 ON t0.id = t1.id WHERE t0.pedido_id = ?

Parameters:

[
  332
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.data_cotacao AS data_cotacao_3,
  t1.observacoes AS observacoes_4,
  t1.anexo AS anexo_5,
  t1.numero_orcamento AS numero_orcamento_6,
  t1.endereco AS endereco_7,
  t1.tipo_frete AS tipo_frete_8,
  t1.condicoes_pgto AS condicoes_pgto_9,
  t1.prazo_entrega AS prazo_entrega_10,
  t1.validade_proposta AS validade_proposta_11,
  t1.valor_frete AS valor_frete_12,
  t1.status AS status_13,
  t1.orcamento_aprovado AS orcamento_aprovado_14,
  t1.ativo AS ativo_15,
  t1.fornecedor_id AS fornecedor_id_16,
  t0.edital_id AS edital_id_17,
  t0.pedido_id AS pedido_id_18,
  t1.origem_cotacao
FROM
  cotacao_edital t0
  INNER JOIN cotacao_produto t1 ON t0.id = t1.id
WHERE
  t0.pedido_id = ?

SELECT t1.id AS id_2, t1.data_cotacao AS data_cotacao_3, t1.observacoes AS observacoes_4, t1.anexo AS anexo_5, t1.numero_orcamento AS numero_orcamento_6, t1.endereco AS endereco_7, t1.tipo_frete AS tipo_frete_8, t1.condicoes_pgto AS condicoes_pgto_9, t1.prazo_entrega AS prazo_entrega_10, t1.validade_proposta AS validade_proposta_11, t1.valor_frete AS valor_frete_12, t1.status AS status_13, t1.orcamento_aprovado AS orcamento_aprovado_14, t1.ativo AS ativo_15, t1.fornecedor_id AS fornecedor_id_16, t0.edital_id AS edital_id_17, t0.pedido_id AS pedido_id_18, t1.origem_cotacao FROM cotacao_edital t0 INNER JOIN cotacao_produto t1 ON t0.id = t1.id WHERE t0.pedido_id = 332;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 105)
9	__TwigTemplate_331e03cda4d71e206dccf6cd1a59b5f3->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 1493)
14	Twig\Extension\CoreExtension::include (line 56)
15	__TwigTemplate_90ecb54ac847dd04796fa9bf5eae6127->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 1493)
20	Twig\Extension\CoreExtension::include (line 275)
21	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->block_content (line 432)
22	Twig\Template->yieldBlock (line 144)
23	__TwigTemplate_a711e81f273bebcbaadcdbdaa48b5830->doDisplay (line 388)
24	Twig\Template->yield (line 56)
25	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->doDisplay (line 388)
26	Twig\Template->yield (line 344)
27	Twig\Template->display (line 359)
28	Twig\Template->render (line 51)
29	Twig\TemplateWrapper->render (line 334)
30	Twig\Environment->render (line 431)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
34	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 7)

2.22 ms
(3.31%)

SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.created_at AS created_at_3, t0.login AS login_4, t0.senha AS senha_5, t0.link AS link_6, t0.ativo AS ativo_7, t0.empresa_id AS empresa_id_8 FROM plataforma_pregao t0 WHERE t0.id = ?

Parameters:

[
  47
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.descricao AS descricao_2,
  t0.created_at AS created_at_3,
  t0.login AS login_4,
  t0.senha AS senha_5,
  t0.link AS link_6,
  t0.ativo AS ativo_7,
  t0.empresa_id AS empresa_id_8
FROM
  plataforma_pregao t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.created_at AS created_at_3, t0.login AS login_4, t0.senha AS senha_5, t0.link AS link_6, t0.ativo AS ativo_7, t0.empresa_id AS empresa_id_8 FROM plataforma_pregao t0 WHERE t0.id = 47;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Operacional\Vendas\Edital\PlataformaPregao::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Operacional\Vendas\Edital\PlataformaPregao->__get (line 67)
8	App\Entity\Operacional\Vendas\Edital\PlataformaPregao->__toString (line 126)
9	Twig\Runtime\EscaperRuntime->escape (line 65)
10	__TwigTemplate_9a69586a859a750291033d7e2ed324cc->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1493)
15	Twig\Extension\CoreExtension::include (line 269)
16	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->block_content (line 432)
17	Twig\Template->yieldBlock (line 144)
18	__TwigTemplate_a711e81f273bebcbaadcdbdaa48b5830->doDisplay (line 388)
19	Twig\Template->yield (line 56)
20	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->doDisplay (line 388)
21	Twig\Template->yield (line 344)
22	Twig\Template->display (line 359)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 334)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
29	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 7)

2.18 ms
(3.25%)

SELECT t0.id AS id_1, t0.tipo_contratacao AS tipo_contratacao_2, t0.pdf AS pdf_3, t0.vigencia AS vigencia_4, t0.data_assinatura AS data_assinatura_5, t0.numero AS numero_6, t0.data_inicial AS data_inicial_7, t0.data_final AS data_final_8, t0.created_at AS created_at_9, t0.ativo AS ativo_10, t0.status AS status_11, t0.observacoes AS observacoes_12, t0.edital_id AS edital_id_13 FROM ata_contrato t0 WHERE t0.edital_id = ?

Parameters:

[
  1500
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.tipo_contratacao AS tipo_contratacao_2,
  t0.pdf AS pdf_3,
  t0.vigencia AS vigencia_4,
  t0.data_assinatura AS data_assinatura_5,
  t0.numero AS numero_6,
  t0.data_inicial AS data_inicial_7,
  t0.data_final AS data_final_8,
  t0.created_at AS created_at_9,
  t0.ativo AS ativo_10,
  t0.status AS status_11,
  t0.observacoes AS observacoes_12,
  t0.edital_id AS edital_id_13
FROM
  ata_contrato t0
WHERE
  t0.edital_id = ?

SELECT t0.id AS id_1, t0.tipo_contratacao AS tipo_contratacao_2, t0.pdf AS pdf_3, t0.vigencia AS vigencia_4, t0.data_assinatura AS data_assinatura_5, t0.numero AS numero_6, t0.data_inicial AS data_inicial_7, t0.data_final AS data_final_8, t0.created_at AS created_at_9, t0.ativo AS ativo_10, t0.status AS status_11, t0.observacoes AS observacoes_12, t0.edital_id AS edital_id_13 FROM ata_contrato t0 WHERE t0.edital_id = 1500;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 358)
8	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 7)

2.16 ms
(3.22%)

SELECT t0.id AS id_1, t0.saldo AS saldo_2, t0.empresa_id AS empresa_id_3 FROM caixa_empresa t0 WHERE t0.empresa_id = ?

Parameters:

[
  115
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.saldo AS saldo_2,
  t0.empresa_id AS empresa_id_3
FROM
  caixa_empresa t0
WHERE
  t0.empresa_id = ?

SELECT t0.id AS id_1, t0.saldo AS saldo_2, t0.empresa_id AS empresa_id_3 FROM caixa_empresa t0 WHERE t0.empresa_id = 115;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 176)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 60)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 168)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 744)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
10	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
11	Proxies\__CG__\App\Entity\Empresas\Empresa::Doctrine\ORM\Proxy\{closure} (line 59)
12	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
13	Proxies\__CG__\App\Entity\Empresas\Empresa->__get (line 93)
14	App\Entity\Empresas\DadosJuridica->getRazaoSocial (line 157)
15	App\Entity\Empresas\Empresa->__toString (line 126)
16	Twig\Runtime\EscaperRuntime->escape (line 89)
17	__TwigTemplate_9a69586a859a750291033d7e2ed324cc->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 1493)
22	Twig\Extension\CoreExtension::include (line 269)
23	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->block_content (line 432)
24	Twig\Template->yieldBlock (line 144)
25	__TwigTemplate_a711e81f273bebcbaadcdbdaa48b5830->doDisplay (line 388)
26	Twig\Template->yield (line 56)
27	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->doDisplay (line 388)
28	Twig\Template->yield (line 344)
29	Twig\Template->display (line 359)
30	Twig\Template->render (line 51)
31	Twig\TemplateWrapper->render (line 334)
32	Twig\Environment->render (line 431)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
36	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 7)

2.15 ms
(3.21%)

SELECT t0.id AS id_1, t0.data_coleta AS data_coleta_2, t0.periodo AS periodo_3, t0.arquivo AS arquivo_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.ativo AS ativo_7, t0.previsao_entrega AS previsao_entrega_8, t0.pedido_id AS pedido_id_9 FROM coleta_pedido t0 WHERE t0.pedido_id = ?

Parameters:

[
  332
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.data_coleta AS data_coleta_2,
  t0.periodo AS periodo_3,
  t0.arquivo AS arquivo_4,
  t0.status AS status_5,
  t0.created_at AS created_at_6,
  t0.ativo AS ativo_7,
  t0.previsao_entrega AS previsao_entrega_8,
  t0.pedido_id AS pedido_id_9
FROM
  coleta_pedido t0
WHERE
  t0.pedido_id = ?

SELECT t0.id AS id_1, t0.data_coleta AS data_coleta_2, t0.periodo AS periodo_3, t0.arquivo AS arquivo_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.ativo AS ativo_7, t0.previsao_entrega AS previsao_entrega_8, t0.pedido_id AS pedido_id_9 FROM coleta_pedido t0 WHERE t0.pedido_id = 332;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 145)
12	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
13	iterator_to_array (line 45)
14	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
19	Knp\Component\Pager\Paginator->paginate (line 25)
20	ContainerZAtxlZm\PaginatorProxyBa079e5->paginate (line 383)
21	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 7)

2.13 ms
(3.18%)

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.created_at AS created_at_3, t0.ativo AS ativo_4, t0.ncm AS ncm_5, t0.cest AS cest_6, t0.estoque AS estoque_7, t0.preco_medio AS preco_medio_8, t0.unidade_referencia AS unidade_referencia_9, t0.ncm_descricao AS ncm_descricao_10, t0.situacao AS situacao_11, t0.marca_id AS marca_id_12, t0.modelo_id AS modelo_id_13 FROM produto t0 WHERE t0.id = ?

Parameters:

[
  268
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.created_at AS created_at_3,
  t0.ativo AS ativo_4,
  t0.ncm AS ncm_5,
  t0.cest AS cest_6,
  t0.estoque AS estoque_7,
  t0.preco_medio AS preco_medio_8,
  t0.unidade_referencia AS unidade_referencia_9,
  t0.ncm_descricao AS ncm_descricao_10,
  t0.situacao AS situacao_11,
  t0.marca_id AS marca_id_12,
  t0.modelo_id AS modelo_id_13
FROM
  produto t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.created_at AS created_at_3, t0.ativo AS ativo_4, t0.ncm AS ncm_5, t0.cest AS cest_6, t0.estoque AS estoque_7, t0.preco_medio AS preco_medio_8, t0.unidade_referencia AS unidade_referencia_9, t0.ncm_descricao AS ncm_descricao_10, t0.situacao AS situacao_11, t0.marca_id AS marca_id_12, t0.modelo_id AS modelo_id_13 FROM produto t0 WHERE t0.id = 268;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Operacional\Produtos\Produto::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Operacional\Produtos\Produto->__get (line 179)
8	App\Entity\Operacional\Produtos\Produto->getNomeComposto (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 117)
10	__TwigTemplate_aa3889af3af29b83976a87b230cc1fea->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1493)
15	Twig\Extension\CoreExtension::include (line 126)
16	__TwigTemplate_a4f80f262d440c9defa7058a4ae61c5b->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1493)
21	Twig\Extension\CoreExtension::include (line 281)
22	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->block_content (line 432)
23	Twig\Template->yieldBlock (line 144)
24	__TwigTemplate_a711e81f273bebcbaadcdbdaa48b5830->doDisplay (line 388)
25	Twig\Template->yield (line 56)
26	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->doDisplay (line 388)
27	Twig\Template->yield (line 344)
28	Twig\Template->display (line 359)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 334)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
35	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 7)

2.13 ms
(3.17%)

SELECT t0.id AS id_1, t0.data_pedido AS data_pedido_2, t0.prazo AS prazo_3, t0.status AS status_4, t0.numero_pedido AS numero_pedido_5, t0.data_entrega AS data_entrega_6, t0.local_entrega AS local_entrega_7, t0.observacoes AS observacoes_8, t0.arquivo AS arquivo_9, t0.created_at AS created_at_10, t0.ativo AS ativo_11, t0.fatura_gerada AS fatura_gerada_12, t0.valor_frete AS valor_frete_13, t0.modalidade_frete AS modalidade_frete_14, t0.dados_pagamento AS dados_pagamento_15, t0.status_faturamento AS status_faturamento_16, t0.numero_empenho AS numero_empenho_17, t0.data_empenho AS data_empenho_18, t0.anexo_empenho AS anexo_empenho_19, t0.bloqueado_edicao AS bloqueado_edicao_20, t0.cobranca_id AS cobranca_id_21, t0.solicitado_por_id AS solicitado_por_id_22, t23.id AS id_24, t23.data_coleta AS data_coleta_25, t23.periodo AS periodo_26, t23.arquivo AS arquivo_27, t23.status AS status_28, t23.created_at AS created_at_29, t23.ativo AS ativo_30, t23.previsao_entrega AS previsao_entrega_31, t23.pedido_id AS pedido_id_32, t0.edital_id AS edital_id_33, t34.id AS id_35, t34.created_at AS created_at_36, t34.status AS status_37, t34.observacoes AS observacoes_38, t34.ativo AS ativo_39, t34.solicitado_por_id AS solicitado_por_id_40, t34.cotacao_selecionada_id AS cotacao_selecionada_id_41, t34.pedido_id AS pedido_id_42, t43.id AS id_44, t43.created_at AS created_at_45, t43.status AS status_46, t43.observacoes AS observacoes_47, t43.ativo AS ativo_48, t43.pedido_id AS pedido_id_49, t43.solicitado_por_id AS solicitado_por_id_50, t43.cotacao_selecionada_id AS cotacao_selecionada_id_51, t0.responsavel_id AS responsavel_id_52 FROM pedido t0 LEFT JOIN coleta_pedido t23 ON t23.pedido_id = t0.id LEFT JOIN solicitacao_aprovacao_produto t34 ON t34.pedido_id = t0.id LEFT JOIN solicitacao_aprovacao_frete t43 ON t43.pedido_id = t0.id WHERE t0.edital_id = ?

Parameters:

[
  1500
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.data_pedido AS data_pedido_2,
  t0.prazo AS prazo_3,
  t0.status AS status_4,
  t0.numero_pedido AS numero_pedido_5,
  t0.data_entrega AS data_entrega_6,
  t0.local_entrega AS local_entrega_7,
  t0.observacoes AS observacoes_8,
  t0.arquivo AS arquivo_9,
  t0.created_at AS created_at_10,
  t0.ativo AS ativo_11,
  t0.fatura_gerada AS fatura_gerada_12,
  t0.valor_frete AS valor_frete_13,
  t0.modalidade_frete AS modalidade_frete_14,
  t0.dados_pagamento AS dados_pagamento_15,
  t0.status_faturamento AS status_faturamento_16,
  t0.numero_empenho AS numero_empenho_17,
  t0.data_empenho AS data_empenho_18,
  t0.anexo_empenho AS anexo_empenho_19,
  t0.bloqueado_edicao AS bloqueado_edicao_20,
  t0.cobranca_id AS cobranca_id_21,
  t0.solicitado_por_id AS solicitado_por_id_22,
  t23.id AS id_24,
  t23.data_coleta AS data_coleta_25,
  t23.periodo AS periodo_26,
  t23.arquivo AS arquivo_27,
  t23.status AS status_28,
  t23.created_at AS created_at_29,
  t23.ativo AS ativo_30,
  t23.previsao_entrega AS previsao_entrega_31,
  t23.pedido_id AS pedido_id_32,
  t0.edital_id AS edital_id_33,
  t34.id AS id_35,
  t34.created_at AS created_at_36,
  t34.status AS status_37,
  t34.observacoes AS observacoes_38,
  t34.ativo AS ativo_39,
  t34.solicitado_por_id AS solicitado_por_id_40,
  t34.cotacao_selecionada_id AS cotacao_selecionada_id_41,
  t34.pedido_id AS pedido_id_42,
  t43.id AS id_44,
  t43.created_at AS created_at_45,
  t43.status AS status_46,
  t43.observacoes AS observacoes_47,
  t43.ativo AS ativo_48,
  t43.pedido_id AS pedido_id_49,
  t43.solicitado_por_id AS solicitado_por_id_50,
  t43.cotacao_selecionada_id AS cotacao_selecionada_id_51,
  t0.responsavel_id AS responsavel_id_52
FROM
  pedido t0
  LEFT JOIN coleta_pedido t23 ON t23.pedido_id = t0.id
  LEFT JOIN solicitacao_aprovacao_produto t34 ON t34.pedido_id = t0.id
  LEFT JOIN solicitacao_aprovacao_frete t43 ON t43.pedido_id = t0.id
WHERE
  t0.edital_id = ?

SELECT t0.id AS id_1, t0.data_pedido AS data_pedido_2, t0.prazo AS prazo_3, t0.status AS status_4, t0.numero_pedido AS numero_pedido_5, t0.data_entrega AS data_entrega_6, t0.local_entrega AS local_entrega_7, t0.observacoes AS observacoes_8, t0.arquivo AS arquivo_9, t0.created_at AS created_at_10, t0.ativo AS ativo_11, t0.fatura_gerada AS fatura_gerada_12, t0.valor_frete AS valor_frete_13, t0.modalidade_frete AS modalidade_frete_14, t0.dados_pagamento AS dados_pagamento_15, t0.status_faturamento AS status_faturamento_16, t0.numero_empenho AS numero_empenho_17, t0.data_empenho AS data_empenho_18, t0.anexo_empenho AS anexo_empenho_19, t0.bloqueado_edicao AS bloqueado_edicao_20, t0.cobranca_id AS cobranca_id_21, t0.solicitado_por_id AS solicitado_por_id_22, t23.id AS id_24, t23.data_coleta AS data_coleta_25, t23.periodo AS periodo_26, t23.arquivo AS arquivo_27, t23.status AS status_28, t23.created_at AS created_at_29, t23.ativo AS ativo_30, t23.previsao_entrega AS previsao_entrega_31, t23.pedido_id AS pedido_id_32, t0.edital_id AS edital_id_33, t34.id AS id_35, t34.created_at AS created_at_36, t34.status AS status_37, t34.observacoes AS observacoes_38, t34.ativo AS ativo_39, t34.solicitado_por_id AS solicitado_por_id_40, t34.cotacao_selecionada_id AS cotacao_selecionada_id_41, t34.pedido_id AS pedido_id_42, t43.id AS id_44, t43.created_at AS created_at_45, t43.status AS status_46, t43.observacoes AS observacoes_47, t43.ativo AS ativo_48, t43.pedido_id AS pedido_id_49, t43.solicitado_por_id AS solicitado_por_id_50, t43.cotacao_selecionada_id AS cotacao_selecionada_id_51, t0.responsavel_id AS responsavel_id_52 FROM pedido t0 LEFT JOIN coleta_pedido t23 ON t23.pedido_id = t0.id LEFT JOIN solicitacao_aprovacao_produto t34 ON t34.pedido_id = t0.id LEFT JOIN solicitacao_aprovacao_frete t43 ON t43.pedido_id = t0.id WHERE t0.edital_id = 1500;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1241)
9	Twig\Extension\CoreExtension::length (line 199)
10	__TwigTemplate_9a69586a859a750291033d7e2ed324cc->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1493)
15	Twig\Extension\CoreExtension::include (line 269)
16	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->block_content (line 432)
17	Twig\Template->yieldBlock (line 144)
18	__TwigTemplate_a711e81f273bebcbaadcdbdaa48b5830->doDisplay (line 388)
19	Twig\Template->yield (line 56)
20	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->doDisplay (line 388)
21	Twig\Template->yield (line 344)
22	Twig\Template->display (line 359)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 334)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
29	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 7)

2.10 ms
(3.14%)

SELECT DISTINCT p0_.id AS id_0 FROM pedido p0_ WHERE p0_.edital_id = ? LIMIT 10

Parameters:

[
  1500
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0
FROM
  pedido p0_
WHERE
  p0_.edital_id = ?
LIMIT
  10

SELECT DISTINCT p0_.id AS id_0 FROM pedido p0_ WHERE p0_.edital_id = 1500 LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerZAtxlZm\PaginatorProxyBa079e5->paginate (line 383)
16	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 7)

2.03 ms
(3.03%)

SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.created_at AS created_at_3, t0.ativo AS ativo_4, t0.marca_id AS marca_id_5 FROM modelo t0 WHERE t0.id = ?

Parameters:

[
  314
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.descricao AS descricao_2,
  t0.created_at AS created_at_3,
  t0.ativo AS ativo_4,
  t0.marca_id AS marca_id_5
FROM
  modelo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.created_at AS created_at_3, t0.ativo AS ativo_4, t0.marca_id AS marca_id_5 FROM modelo t0 WHERE t0.id = 314;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Operacional\Produtos\Modelo::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Operacional\Produtos\Modelo->__get (line 85)
8	App\Entity\Operacional\Produtos\Modelo->__toString (line 179)
9	App\Entity\Operacional\Produtos\Produto->getNomeComposto (line 1882)
10	Twig\Extension\CoreExtension::getAttribute (line 117)
11	__TwigTemplate_aa3889af3af29b83976a87b230cc1fea->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 1493)
16	Twig\Extension\CoreExtension::include (line 126)
17	__TwigTemplate_a4f80f262d440c9defa7058a4ae61c5b->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 1493)
22	Twig\Extension\CoreExtension::include (line 281)
23	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->block_content (line 432)
24	Twig\Template->yieldBlock (line 144)
25	__TwigTemplate_a711e81f273bebcbaadcdbdaa48b5830->doDisplay (line 388)
26	Twig\Template->yield (line 56)
27	__TwigTemplate_15223fc70a68f0d2a87e64993fae108b->doDisplay (line 388)
28	Twig\Template->yield (line 344)
29	Twig\Template->display (line 359)
30	Twig\Template->render (line 51)
31	Twig\TemplateWrapper->render (line 334)
32	Twig\Environment->render (line 431)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 396)
36	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 7)

2.02 ms
(3.02%)

SELECT p0_.id AS id_0, p0_.data_pedido AS data_pedido_1, p0_.prazo AS prazo_2, p0_.status AS status_3, p0_.numero_pedido AS numero_pedido_4, p0_.data_entrega AS data_entrega_5, p0_.local_entrega AS local_entrega_6, p0_.observacoes AS observacoes_7, p0_.arquivo AS arquivo_8, p0_.created_at AS created_at_9, p0_.ativo AS ativo_10, p0_.fatura_gerada AS fatura_gerada_11, p0_.valor_frete AS valor_frete_12, p0_.modalidade_frete AS modalidade_frete_13, p0_.dados_pagamento AS dados_pagamento_14, p0_.status_faturamento AS status_faturamento_15, p0_.numero_empenho AS numero_empenho_16, p0_.data_empenho AS data_empenho_17, p0_.anexo_empenho AS anexo_empenho_18, p0_.bloqueado_edicao AS bloqueado_edicao_19, p0_.cobranca_id AS cobranca_id_20, p0_.solicitado_por_id AS solicitado_por_id_21, p0_.edital_id AS edital_id_22, p0_.responsavel_id AS responsavel_id_23 FROM pedido p0_ WHERE p0_.edital_id = ? AND p0_.id IN (?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.data_pedido AS data_pedido_1,
  p0_.prazo AS prazo_2,
  p0_.status AS status_3,
  p0_.numero_pedido AS numero_pedido_4,
  p0_.data_entrega AS data_entrega_5,
  p0_.local_entrega AS local_entrega_6,
  p0_.observacoes AS observacoes_7,
  p0_.arquivo AS arquivo_8,
  p0_.created_at AS created_at_9,
  p0_.ativo AS ativo_10,
  p0_.fatura_gerada AS fatura_gerada_11,
  p0_.valor_frete AS valor_frete_12,
  p0_.modalidade_frete AS modalidade_frete_13,
  p0_.dados_pagamento AS dados_pagamento_14,
  p0_.status_faturamento AS status_faturamento_15,
  p0_.numero_empenho AS numero_empenho_16,
  p0_.data_empenho AS data_empenho_17,
  p0_.anexo_empenho AS anexo_empenho_18,
  p0_.bloqueado_edicao AS bloqueado_edicao_19,
  p0_.cobranca_id AS cobranca_id_20,
  p0_.solicitado_por_id AS solicitado_por_id_21,
  p0_.edital_id AS edital_id_22,
  p0_.responsavel_id AS responsavel_id_23
FROM
  pedido p0_
WHERE
  p0_.edital_id = ?
  AND p0_.id IN (?)

SELECT p0_.id AS id_0, p0_.data_pedido AS data_pedido_1, p0_.prazo AS prazo_2, p0_.status AS status_3, p0_.numero_pedido AS numero_pedido_4, p0_.data_entrega AS data_entrega_5, p0_.local_entrega AS local_entrega_6, p0_.observacoes AS observacoes_7, p0_.arquivo AS arquivo_8, p0_.created_at AS created_at_9, p0_.ativo AS ativo_10, p0_.fatura_gerada AS fatura_gerada_11, p0_.valor_frete AS valor_frete_12, p0_.modalidade_frete AS modalidade_frete_13, p0_.dados_pagamento AS dados_pagamento_14, p0_.status_faturamento AS status_faturamento_15, p0_.numero_empenho AS numero_empenho_16, p0_.data_empenho AS data_empenho_17, p0_.anexo_empenho AS anexo_empenho_18, p0_.bloqueado_edicao AS bloqueado_edicao_19, p0_.cobranca_id AS cobranca_id_20, p0_.solicitado_por_id AS solicitado_por_id_21, p0_.edital_id AS edital_id_22, p0_.responsavel_id AS responsavel_id_23 FROM pedido p0_ WHERE p0_.edital_id = 1500 AND p0_.id IN (332);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerZAtxlZm\PaginatorProxyBa079e5->paginate (line 383)
16	App\Controller\Operacional\Compras\ComprasController->gerenciarPregao (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 7)

1.94 ms
(2.89%)

SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.tipo_contratacao AS tipo_contratacao_4, t0.contrato AS contrato_5, t0.vigencia AS vigencia_6, t0.data_assinatura AS data_assinatura_7, t0.numero_contrato AS numero_contrato_8, t0.prazo_inicial AS prazo_inicial_9, t0.prazo_final AS prazo_final_10, t0.valor_inicial AS valor_inicial_11, t0.valor_final AS valor_final_12, t0.status AS status_13, t0.obs_finalizacao AS obs_finalizacao_14, t0.motivo_finalizacao AS motivo_finalizacao_15, t0.arquivo_finalizacao AS arquivo_finalizacao_16, t0.data_finalizacao AS data_finalizacao_17, t0.tipo_contrato AS tipo_contrato_18, t0.edital_id AS edital_id_19, t0.responsavel_id AS responsavel_id_20, t0.ata_registro_id AS ata_registro_id_21, t0.contratada_id AS contratada_id_22, t0.ata_contrato_id AS ata_contrato_id_23, t1.tipo_etapa FROM etapa_contrato t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?

Parameters:

[
  1500
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.created_at AS created_at_3,
  t0.tipo_contratacao AS tipo_contratacao_4,
  t0.contrato AS contrato_5,
  t0.vigencia AS vigencia_6,
  t0.data_assinatura AS data_assinatura_7,
  t0.numero_contrato AS numero_contrato_8,
  t0.prazo_inicial AS prazo_inicial_9,
  t0.prazo_final AS prazo_final_10,
  t0.valor_inicial AS valor_inicial_11,
  t0.valor_final AS valor_final_12,
  t0.status AS status_13,
  t0.obs_finalizacao AS obs_finalizacao_14,
  t0.motivo_finalizacao AS motivo_finalizacao_15,
  t0.arquivo_finalizacao AS arquivo_finalizacao_16,
  t0.data_finalizacao AS data_finalizacao_17,
  t0.tipo_contrato AS tipo_contrato_18,
  t0.edital_id AS edital_id_19,
  t0.responsavel_id AS responsavel_id_20,
  t0.ata_registro_id AS ata_registro_id_21,
  t0.contratada_id AS contratada_id_22,
  t0.ata_contrato_id AS ata_contrato_id_23,
  t1.tipo_etapa
FROM
  etapa_contrato t0
  INNER JOIN etapa_processo t1 ON t0.id = t1.id
WHERE
  t0.edital_id = ?

SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.tipo_contratacao AS tipo_contratacao_4, t0.contrato AS contrato_5, t0.vigencia AS vigencia_6, t0.data_assinatura AS data_assinatura_7, t0.numero_contrato AS numero_contrato_8, t0.prazo_inicial AS prazo_inicial_9, t0.prazo_final AS prazo_final_10, t0.valor_inicial AS valor_inicial_11, t0.valor_final AS valor_final_12, t0.status AS status_13, t0.obs_finalizacao AS obs_finalizacao_14, t0.motivo_finalizacao AS motivo_finalizacao_15, t0.arquivo_finalizacao AS arquivo_finalizacao_16, t0.data_finalizacao AS data_finalizacao_17, t0.tipo_contrato AS tipo_contrato_18, t0.edital_id AS edital_id_19, t0.responsavel_id AS responsavel_id_20, t0.ata_registro_id AS ata_registro_id_21, t0.contratada_id AS contratada_id_22, t0.ata_contrato_id AS ata_contrato_id_23, t1.tipo_etapa FROM etapa_contrato t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = 1500;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 176)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 60)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 168)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 744)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
10	Doctrine\ORM\EntityManager->find (line 86)
11	Doctrine\ORM\EntityRepository->find (line 61)
12	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
13	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
14	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
15	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
16	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
17	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 7)

1.69 ms
(2.53%)

SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.validade AS validade_4, t0.condicoes_entrega AS condicoes_entrega_5, t0.prazo_entrega AS prazo_entrega_6, t0.local_entrega AS local_entrega_7, t0.garantia AS garantia_8, t0.informacoes_gerais AS informacoes_gerais_9, t0.status AS status_10, t0.data AS data_11, t0.prazo_pagamento AS prazo_pagamento_12, t0.situacao AS situacao_13, t0.edital_id AS edital_id_14, t0.conta_bancaria_id AS conta_bancaria_id_15, t1.tipo_etapa FROM proposta_final t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?

Parameters:

[
  1500
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.created_at AS created_at_3,
  t0.validade AS validade_4,
  t0.condicoes_entrega AS condicoes_entrega_5,
  t0.prazo_entrega AS prazo_entrega_6,
  t0.local_entrega AS local_entrega_7,
  t0.garantia AS garantia_8,
  t0.informacoes_gerais AS informacoes_gerais_9,
  t0.status AS status_10,
  t0.data AS data_11,
  t0.prazo_pagamento AS prazo_pagamento_12,
  t0.situacao AS situacao_13,
  t0.edital_id AS edital_id_14,
  t0.conta_bancaria_id AS conta_bancaria_id_15,
  t1.tipo_etapa
FROM
  proposta_final t0
  INNER JOIN etapa_processo t1 ON t0.id = t1.id
WHERE
  t0.edital_id = ?

SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.validade AS validade_4, t0.condicoes_entrega AS condicoes_entrega_5, t0.prazo_entrega AS prazo_entrega_6, t0.local_entrega AS local_entrega_7, t0.garantia AS garantia_8, t0.informacoes_gerais AS informacoes_gerais_9, t0.status AS status_10, t0.data AS data_11, t0.prazo_pagamento AS prazo_pagamento_12, t0.situacao AS situacao_13, t0.edital_id AS edital_id_14, t0.conta_bancaria_id AS conta_bancaria_id_15, t1.tipo_etapa FROM proposta_final t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = 1500;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 176)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 60)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 168)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 744)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
10	Doctrine\ORM\EntityManager->find (line 86)
11	Doctrine\ORM\EntityRepository->find (line 61)
12	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
13	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
14	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
15	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
16	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
17	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 7)

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\RecursosHumanos\Colaborador	No errors.
App\Entity\Comum\Endereco	No errors.
App\Entity\RecursosHumanos\Cargo	No errors.
App\Entity\Empresas\DadosJuridica	No errors.
App\Entity\Empresas\Empresa	No errors.
App\Entity\Operacional\Vendas\Edital\Edital	The association App\Entity\Operacional\Vendas\Edital\Edital#estado refers to the inverse side field App\Entity\Comum\Estado#edital which does not exist.
App\Entity\RecursosHumanos\ContasBancariasColaborador	No errors.
App\Entity\Comum\Arquivo	No errors.
App\Entity\RecursosHumanos\ArquivoColaborador	No errors.
App\Entity\RecursosHumanos\ContaEmail	No errors.
App\Entity\Operacional\Compras\Solicitacao	No errors.
App\Entity\Operacional\Vendas\Cliente	No errors.
App\Entity\Operacional\Vendas\Edital\EtapaProcesso	No errors.
App\Entity\Operacional\Vendas\Edital\EtapaAcolhimentoPropostas	No errors.
App\Entity\Operacional\Vendas\Edital\EtapaDisputa	No errors.
App\Entity\Operacional\Vendas\Edital\EtapaHabilitacao	No errors.
App\Entity\Operacional\Vendas\Edital\EtapaAutorizacaoFornecimento	No errors.
App\Entity\Operacional\Vendas\Edital\EtapaEntregaProduto	No errors.
App\Entity\Operacional\Vendas\Edital\EtapaEmissaoNF	No errors.
App\Entity\Operacional\Vendas\Edital\EtapaFaturamento	No errors.
App\Entity\Operacional\Vendas\Edital\EtapaAtestadoTecnico	No errors.
App\Entity\Operacional\Vendas\Edital\PlataformaPregao	No errors.
App\Entity\Operacional\Vendas\Edital\EtapaContrato	No errors.
App\Entity\Operacional\Vendas\Proposta\PropostaFinal	No errors.
App\Entity\Comum\Estado	No errors.
App\Entity\Operacional\Produtos\Produto	No errors.
App\Entity\Operacional\Vendas\Edital\EtapaRegistroPreco	No errors.
App\Entity\Empresas\ContaBancaria	No errors.
App\Entity\Operacional\Compras\AtaContrato	No errors.
App\Entity\Operacional\Vendas\Proposta\ItemPropostaFinal	No errors.
App\Entity\Empresas\ArquivoEmpresa	No errors.
App\Entity\Operacional\Vendas\Edital\AtestadoTecnico	No errors.
App\Entity\Operacional\Vendas\Edital\ItemEdital	No errors.
App\Entity\Operacional\Compras\CotacaoProduto	No errors.
App\Entity\Operacional\Compras\CotacaoEdital	No errors.
App\Entity\Operacional\Compras\CotacaoFrete	No errors.
App\Entity\Operacional\Compras\CotacaoFreteEdital	No errors.
App\Entity\Operacional\Compras\Pedido	The mappings App\Entity\Operacional\Compras\Pedido#historicoStatus and App\Entity\Operacional\Compras\HistoricoStatusPedido#pedido are inconsistent with each other.
App\Entity\Operacional\Vendas\Proposta\TrocaItemProposta	No errors.
App\Entity\Operacional\Compras\ItemPedido	No errors.
App\Entity\Operacional\Compras\EntregaPedido	No errors.
App\Entity\Operacional\Compras\HistoricoStatusPedido	No errors.
App\Entity\Financeiro\ContaPagar	No errors.
App\Entity\Financeiro\ContaPagarPedido	No errors.
App\Entity\Operacional\Compras\FretePedido	No errors.
App\Entity\Operacional\Compras\ColetaPedido	No errors.
App\Entity\Financeiro\NFE\NotaFiscalEletronica	No errors.
App\Entity\Financeiro\NFE\NotaFiscalEletronicaPedido	No errors.
App\Entity\Financeiro\ContaReceber	No errors.
App\Entity\Financeiro\ContaReceberPedido	No errors.
App\Entity\Financeiro\ComprovantePagamento	No errors.
App\Entity\Operacional\Compras\CustoPedido	No errors.
App\Entity\Operacional\Compras\SolicitacaoAprovacaoProduto	No errors.
App\Entity\Operacional\Compras\SolicitacaoAprovacaoFrete	No errors.
App\Entity\Operacional\Compras\OrcamentoFrete	No errors.
App\Entity\Operacional\Produtos\Estoque\Saida	No errors.
App\Entity\Empresas\AtividadeComercial	No errors.
App\Entity\Empresas\Departamento	No errors.
App\Entity\Financeiro\CaixaEmpresa	No errors.
App\Entity\Financeiro\SaidaCaixa	No errors.
App\Entity\Financeiro\EntradaCaixa	No errors.
App\Entity\Financeiro\ExtratoBancario	No errors.
App\Entity\Comum\Tarefa	No errors.
App\Entity\Juridico\Notificacao	No errors.
App\Entity\Operacional\Logistica\Transportadora	No errors.
App\Entity\Operacional\Produtos\Fornecedor	No errors.
App\Entity\Operacional\Produtos\Marca	No errors.
App\Entity\Operacional\Produtos\Modelo	No errors.
App\Entity\Operacional\Produtos\Volume	No errors.
App\Entity\Operacional\Vendas\Proposta\ItemProposta	No errors.
App\Entity\Operacional\Compras\ItemCotacaoProduto	No errors.
App\Entity\Operacional\Compras\ItemCotacaoFrete	No errors.
App\Entity\Financeiro\TipoSaida	No errors.
App\Entity\Financeiro\SaidaCaixaConta	No errors.

Symfony Profiler

GET https://licita360.com.br/erp/comum/compras/contratacao/gerenciar/1500

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping