Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.56 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.79 ms
(50.29%)

SELECT t0.id AS id_1, t0.navision_id AS navision_id_2, t0.nombre AS nombre_3, t0.estado AS estado_4, t0.email AS email_5, t0.telefono AS telefono_6, t0.movil AS movil_7, t0.logo AS logo_8, t0.descripcion AS descripcion_9, t0.dir_envio AS dir_envio_10, t0.comercial AS comercial_11, t0.acepta_citas AS acepta_citas_12, t0.red_id AS red_id_13, t0.direccion_id AS direccion_id_14 FROM taller t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  338395
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.navision_id AS navision_id_2,
  t0.nombre AS nombre_3,
  t0.estado AS estado_4,
  t0.email AS email_5,
  t0.telefono AS telefono_6,
  t0.movil AS movil_7,
  t0.logo AS logo_8,
  t0.descripcion AS descripcion_9,
  t0.dir_envio AS dir_envio_10,
  t0.comercial AS comercial_11,
  t0.acepta_citas AS acepta_citas_12,
  t0.red_id AS red_id_13,
  t0.direccion_id AS direccion_id_14
FROM
  taller t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.navision_id AS navision_id_2, t0.nombre AS nombre_3, t0.estado AS estado_4, t0.email AS email_5, t0.telefono AS telefono_6, t0.movil AS movil_7, t0.logo AS logo_8, t0.descripcion AS descripcion_9, t0.dir_envio AS dir_envio_10, t0.comercial AS comercial_11, t0.acepta_citas AS acepta_citas_12, t0.red_id AS red_id_13, t0.direccion_id AS direccion_id_14 FROM taller t0 WHERE t0.id = 338395 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 127)
5	App\Controller\Api\ClientesFinalesNpsController->getValuedNpsVotes (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.78 ms
(49.71%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellidos AS apellidos_3, t0.email AS email_4, t0.valoracion AS valoracion_5, t0.fecha_valoracion AS fecha_valoracion_6, t0.estado AS estado_7, t0.fecha_creacion AS fecha_creacion_8, t0.taller_id AS taller_id_9 FROM clientes_finales_nps t0 WHERE t0.taller_id = ?

Parameters:

[
  338395
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.apellidos AS apellidos_3,
  t0.email AS email_4,
  t0.valoracion AS valoracion_5,
  t0.fecha_valoracion AS fecha_valoracion_6,
  t0.estado AS estado_7,
  t0.fecha_creacion AS fecha_creacion_8,
  t0.taller_id AS taller_id_9
FROM
  clientes_finales_nps t0
WHERE
  t0.taller_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellidos AS apellidos_3, t0.email AS email_4, t0.valoracion AS valoracion_5, t0.fecha_valoracion AS fecha_valoracion_6, t0.estado AS estado_7, t0.fecha_creacion AS fecha_creacion_8, t0.taller_id AS taller_id_9 FROM clientes_finales_nps t0 WHERE t0.taller_id = 338395;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 138)
8	App\Controller\Api\ClientesFinalesNpsController->getValuedNpsVotes (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 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Taller	1
App\Entity\Red	1
App\Entity\Direccion	1

Entities Mapping

Class	Mapping errors
App\Entity\Taller	No errors.
App\Entity\Red	No errors.
App\Entity\Direccion	No errors.
App\Entity\Servicio	No errors.
App\Entity\Vehiculo	No errors.
App\Entity\Slot	No errors.
App\Entity\Cita	No errors.
App\Entity\ClientesFinalesNps	No errors.
App\Entity\Imagen	No errors.

Symfony Profiler

GET https://talleres-api.nex-desarrollodigital.com/api/clientes-finales-nps/338395/show-by-taller/valued

Configuration Settings

Theme

Page Width