Symfony Profiler

Query Metrics

723 Database Queries

4 Different statements

327.59 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

310.10 ms
(94.66%)

712

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.conteiner AS conteiner_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.qtd AS qtd_6, t0.qtd1 AS qtd1_7, t0.updated_at AS updated_at_8, t0.assunto AS assunto_9, t0.data_documento AS data_documento_10, t0.vencimento_documento AS vencimento_documento_11, t0.extra_fields AS extra_fields_12, t0.keywords AS keywords_13, t0.index_at AS index_at_14, t0.user_index AS user_index_15, t0.situacao AS situacao_16, t0.user_id AS user_id_17, t0.cliente_id AS cliente_id_18, t0.caixa_id AS caixa_id_19, t0.classificacao_id AS classificacao_id_20, t0.tipo_id AS tipo_id_21, t0.etapa_id AS etapa_id_22 FROM documento t0 WHERE t0.caixa_id = ?

Parameters:

[
  153768
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nome AS nome_2,
  t0.conteiner AS conteiner_3,
  t0.image AS image_4,
  t0.created_at AS created_at_5,
  t0.qtd AS qtd_6,
  t0.qtd1 AS qtd1_7,
  t0.updated_at AS updated_at_8,
  t0.assunto AS assunto_9,
  t0.data_documento AS data_documento_10,
  t0.vencimento_documento AS vencimento_documento_11,
  t0.extra_fields AS extra_fields_12,
  t0.keywords AS keywords_13,
  t0.index_at AS index_at_14,
  t0.user_index AS user_index_15,
  t0.situacao AS situacao_16,
  t0.user_id AS user_id_17,
  t0.cliente_id AS cliente_id_18,
  t0.caixa_id AS caixa_id_19,
  t0.classificacao_id AS classificacao_id_20,
  t0.tipo_id AS tipo_id_21,
  t0.etapa_id AS etapa_id_22
FROM
  documento t0
WHERE
  t0.caixa_id = ?

SELECT t0.id AS id_1, t0.nome AS nome_2, t0.conteiner AS conteiner_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.qtd AS qtd_6, t0.qtd1 AS qtd1_7, t0.updated_at AS updated_at_8, t0.assunto AS assunto_9, t0.data_documento AS data_documento_10, t0.vencimento_documento AS vencimento_documento_11, t0.extra_fields AS extra_fields_12, t0.keywords AS keywords_13, t0.index_at AS index_at_14, t0.user_index AS user_index_15, t0.situacao AS situacao_16, t0.user_id AS user_id_17, t0.cliente_id AS cliente_id_18, t0.caixa_id AS caixa_id_19, t0.classificacao_id AS classificacao_id_20, t0.tipo_id AS tipo_id_21, t0.etapa_id AS etapa_id_22 FROM documento t0 WHERE t0.caixa_id = 153768;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3298)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 5018)
8	App\Controller\Admin\DashboardController->metas (line 163)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

11.60 ms
(3.54%)

SELECT f0_.id AS id_0, f0_.nome AS nome_1, f0_.created_at AS created_at_2, f0_.obs AS obs_3, u1_.id AS id_4, u1_.email AS email_5, u1_.roles AS roles_6, u1_.password AS password_7, u1_.nome AS nome_8, u1_.tipo_acesso AS tipo_acesso_9, u1_.enabled AS enabled_10, c2_.id AS id_11, c2_.nome AS nome_12, c2_.extra_fields AS extra_fields_13, e3_.id AS id_14, e3_.nome AS nome_15, e3_.prazo AS prazo_16, e3_.updated_at AS updated_at_17, e3_.ordem AS ordem_18, e3_.obs AS obs_19, c4_.id AS id_20, c4_.nome AS nome_21, c4_.created_at AS created_at_22, c4_.data AS data_23, c4_.assunto AS assunto_24, c4_.higieniza_at AS higieniza_at_25, f0_.user_id AS user_id_26, f0_.cliente_id AS cliente_id_27, c2_.cliente_all_id AS cliente_all_id_28, e3_.user_id AS user_id_29, e3_.documento_id AS documento_id_30, e3_.fluxo_id AS fluxo_id_31, e3_.registro_id AS registro_id_32, c4_.fluxo_id AS fluxo_id_33, c4_.cx_id AS cx_id_34, c4_.etapa_id AS etapa_id_35 FROM fluxo f0_ LEFT JOIN user u1_ ON f0_.user_id = u1_.id LEFT JOIN cliente c2_ ON f0_.cliente_id = c2_.id LEFT JOIN etapa e3_ ON f0_.id = e3_.fluxo_id LEFT JOIN caixa c4_ ON f0_.id = c4_.fluxo_id WHERE f0_.created_at BETWEEN ? AND ?

Parameters:

[
  "2026-02-01 00:00:00"
  "2026-02-28 23:59:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.nome AS nome_1,
  f0_.created_at AS created_at_2,
  f0_.obs AS obs_3,
  u1_.id AS id_4,
  u1_.email AS email_5,
  u1_.roles AS roles_6,
  u1_.password AS password_7,
  u1_.nome AS nome_8,
  u1_.tipo_acesso AS tipo_acesso_9,
  u1_.enabled AS enabled_10,
  c2_.id AS id_11,
  c2_.nome AS nome_12,
  c2_.extra_fields AS extra_fields_13,
  e3_.id AS id_14,
  e3_.nome AS nome_15,
  e3_.prazo AS prazo_16,
  e3_.updated_at AS updated_at_17,
  e3_.ordem AS ordem_18,
  e3_.obs AS obs_19,
  c4_.id AS id_20,
  c4_.nome AS nome_21,
  c4_.created_at AS created_at_22,
  c4_.data AS data_23,
  c4_.assunto AS assunto_24,
  c4_.higieniza_at AS higieniza_at_25,
  f0_.user_id AS user_id_26,
  f0_.cliente_id AS cliente_id_27,
  c2_.cliente_all_id AS cliente_all_id_28,
  e3_.user_id AS user_id_29,
  e3_.documento_id AS documento_id_30,
  e3_.fluxo_id AS fluxo_id_31,
  e3_.registro_id AS registro_id_32,
  c4_.fluxo_id AS fluxo_id_33,
  c4_.cx_id AS cx_id_34,
  c4_.etapa_id AS etapa_id_35
FROM
  fluxo f0_
  LEFT JOIN user u1_ ON f0_.user_id = u1_.id
  LEFT JOIN cliente c2_ ON f0_.cliente_id = c2_.id
  LEFT JOIN etapa e3_ ON f0_.id = e3_.fluxo_id
  LEFT JOIN caixa c4_ ON f0_.id = c4_.fluxo_id
WHERE
  f0_.created_at BETWEEN ?
  AND ?

SELECT f0_.id AS id_0, f0_.nome AS nome_1, f0_.created_at AS created_at_2, f0_.obs AS obs_3, u1_.id AS id_4, u1_.email AS email_5, u1_.roles AS roles_6, u1_.password AS password_7, u1_.nome AS nome_8, u1_.tipo_acesso AS tipo_acesso_9, u1_.enabled AS enabled_10, c2_.id AS id_11, c2_.nome AS nome_12, c2_.extra_fields AS extra_fields_13, e3_.id AS id_14, e3_.nome AS nome_15, e3_.prazo AS prazo_16, e3_.updated_at AS updated_at_17, e3_.ordem AS ordem_18, e3_.obs AS obs_19, c4_.id AS id_20, c4_.nome AS nome_21, c4_.created_at AS created_at_22, c4_.data AS data_23, c4_.assunto AS assunto_24, c4_.higieniza_at AS higieniza_at_25, f0_.user_id AS user_id_26, f0_.cliente_id AS cliente_id_27, c2_.cliente_all_id AS cliente_all_id_28, e3_.user_id AS user_id_29, e3_.documento_id AS documento_id_30, e3_.fluxo_id AS fluxo_id_31, e3_.registro_id AS registro_id_32, c4_.fluxo_id AS fluxo_id_33, c4_.cx_id AS cx_id_34, c4_.etapa_id AS etapa_id_35 FROM fluxo f0_ LEFT JOIN user u1_ ON f0_.user_id = u1_.id LEFT JOIN cliente c2_ ON f0_.cliente_id = c2_.id LEFT JOIN etapa e3_ ON f0_.id = e3_.fluxo_id LEFT JOIN caixa c4_ ON f0_.id = c4_.fluxo_id WHERE f0_.created_at BETWEEN '2026-02-01 00:00:00' AND '2026-02-28 23:59:59';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 70)
7	App\Repository\FluxoRepository->findMes (line 4997)
8	App\Controller\Admin\DashboardController->metas (line 163)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

4.68 ms
(1.43%)

SELECT f0_.id AS id_0, f0_.nome AS nome_1, f0_.created_at AS created_at_2, f0_.obs AS obs_3, MAX(e1_.prazo) AS sclr_4, f0_.user_id AS user_id_5, f0_.cliente_id AS cliente_id_6 FROM fluxo f0_ INNER JOIN etapa e1_ ON f0_.id = e1_.fluxo_id INNER JOIN cliente c2_ ON f0_.cliente_id = c2_.id WHERE e1_.updated_at IS NULL GROUP BY f0_.id ORDER BY sclr_4 ASC, c2_.nome ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.nome AS nome_1,
  f0_.created_at AS created_at_2,
  f0_.obs AS obs_3,
  MAX(e1_.prazo) AS sclr_4,
  f0_.user_id AS user_id_5,
  f0_.cliente_id AS cliente_id_6
FROM
  fluxo f0_
  INNER JOIN etapa e1_ ON f0_.id = e1_.fluxo_id
  INNER JOIN cliente c2_ ON f0_.cliente_id = c2_.id
WHERE
  e1_.updated_at IS NULL
GROUP BY
  f0_.id
ORDER BY
  sclr_4 ASC,
  c2_.nome ASC

SELECT f0_.id AS id_0, f0_.nome AS nome_1, f0_.created_at AS created_at_2, f0_.obs AS obs_3, MAX(e1_.prazo) AS sclr_4, f0_.user_id AS user_id_5, f0_.cliente_id AS cliente_id_6 FROM fluxo f0_ INNER JOIN etapa e1_ ON f0_.id = e1_.fluxo_id INNER JOIN cliente c2_ ON f0_.cliente_id = c2_.id WHERE e1_.updated_at IS NULL GROUP BY f0_.id ORDER BY sclr_4 ASC, c2_.nome ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 49)
7	App\Repository\FluxoRepository->fluxosAbertosComMaiorPrazo (line 4993)
8	App\Controller\Admin\DashboardController->metas (line 163)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.20 ms
(0.37%)

SELECT c0_.id AS id_0, c0_.nome AS nome_1, c0_.extra_fields AS extra_fields_2, c0_.cliente_all_id AS cliente_all_id_3 FROM cliente c0_ WHERE c0_.id = ?

Parameters:

[
  116
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nome AS nome_1,
  c0_.extra_fields AS extra_fields_2,
  c0_.cliente_all_id AS cliente_all_id_3
FROM
  cliente c0_
WHERE
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.nome AS nome_1, c0_.extra_fields AS extra_fields_2, c0_.cliente_all_id AS cliente_all_id_3 FROM cliente c0_ WHERE c0_.id = 116;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 5061)
7	App\Controller\Admin\DashboardController->metas (line 163)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Fluxo	No errors.
App\Entity\Etapa	No errors.
App\Entity\Cliente	The field App\Entity\Cliente#users is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#clientes does not contain the required 'mappedBy="users"' attribute.
App\Entity\User	The field App\Entity\User#clientes is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Cliente#users does not contain the required 'mappedBy="clientes"' attribute.
App\Entity\Caixa	No errors.
App\Entity\ClienteAll	No errors.
App\Entity\Documento	No errors.
App\Entity\Registro	No errors.
App\Entity\Cx	No errors.
App\Entity\Classificacao	No errors.
App\Entity\Tipo	No errors.

Symfony Profiler

GET https://index.arquivosdoc.com.br/metas

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping