Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.33 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.45 ms

SELECT DISTINCT m0_.id AS id_0, m0_.envio AS envio_1 FROM mensaje m0_ ORDER BY m0_.envio ASC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.envio AS envio_1
FROM
  mensaje m0_
ORDER BY
  m0_.envio ASC
LIMIT
  20

SELECT DISTINCT m0_.id AS id_0, m0_.envio AS envio_1 FROM mensaje m0_ ORDER BY m0_.envio ASC LIMIT 20;

#	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 70)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.53 ms

SELECT m0_.id AS id_0, m0_.turno_id AS turno_id_1, m0_.medico AS medico_2, m0_.fecha AS fecha_3, m0_.hora AS hora_4, m0_.paciente AS paciente_5, m0_.link AS link_6, m0_.modelo AS modelo_7, m0_.telefono AS telefono_8, m0_.envio AS envio_9, m0_.codigo AS codigo_10, m0_.cancelado AS cancelado_11, m0_.estado AS estado_12, m0_.create_at AS create_at_13, m0_.update_at AS update_at_14, m0_.db_id AS db_id_15, m0_.create_by_id AS create_by_id_16, m0_.update_by_id AS update_by_id_17 FROM mensaje m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.envio ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.turno_id AS turno_id_1,
  m0_.medico AS medico_2,
  m0_.fecha AS fecha_3,
  m0_.hora AS hora_4,
  m0_.paciente AS paciente_5,
  m0_.link AS link_6,
  m0_.modelo AS modelo_7,
  m0_.telefono AS telefono_8,
  m0_.envio AS envio_9,
  m0_.codigo AS codigo_10,
  m0_.cancelado AS cancelado_11,
  m0_.estado AS estado_12,
  m0_.create_at AS create_at_13,
  m0_.update_at AS update_at_14,
  m0_.db_id AS db_id_15,
  m0_.create_by_id AS create_by_id_16,
  m0_.update_by_id AS update_by_id_17
FROM
  mensaje m0_
WHERE
  m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  m0_.envio ASC

SELECT m0_.id AS id_0, m0_.turno_id AS turno_id_1, m0_.medico AS medico_2, m0_.fecha AS fecha_3, m0_.hora AS hora_4, m0_.paciente AS paciente_5, m0_.link AS link_6, m0_.modelo AS modelo_7, m0_.telefono AS telefono_8, m0_.envio AS envio_9, m0_.codigo AS codigo_10, m0_.cancelado AS cancelado_11, m0_.estado AS estado_12, m0_.create_at AS create_at_13, m0_.update_at AS update_at_14, m0_.db_id AS db_id_15, m0_.create_by_id AS create_by_id_16, m0_.update_by_id AS update_by_id_17 FROM mensaje m0_ WHERE m0_.id IN (5, 9, 15, 2, 3, 4, 6, 7, 8) ORDER BY m0_.envio ASC;

#	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 70)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.35 ms

SELECT count(*) AS sclr_0 FROM mensaje m0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  mensaje m0_

SELECT count(*) AS sclr_0 FROM mensaje m0_;

#	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 71)
8	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 132)
10	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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\Mensaje	The association App\Entity\Mensaje#respuestas refers to the owning side field App\Entity\Respuesta#mensaje which does not exist.
App\Entity\Database	No errors.
App\Entity\Usuario	No errors.
App\Entity\Respuesta	No errors.

Symfony Profiler

GET http://whatsapp.jizen.com.ar/mensaje

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping