Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

12.77 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.83 ms
(45.62%)

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 = ?

Parameters:

[
  "338008"
]

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 = ?

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 = '338008';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
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 339)
7	App\Controller\Api\TallerController->tallerShow (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.27 ms
(9.90%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3 FROM vehiculo t0 INNER JOIN taller_vehiculo ON t0.id = taller_vehiculo.vehiculo_id WHERE taller_vehiculo.taller_id = ?

Parameters:

[
  338008
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.codigo AS codigo_3
FROM
  vehiculo t0
  INNER JOIN taller_vehiculo ON t0.id = taller_vehiculo.vehiculo_id
WHERE
  taller_vehiculo.taller_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3 FROM vehiculo t0 INNER JOIN taller_vehiculo ON t0.id = taller_vehiculo.vehiculo_id WHERE taller_vehiculo.taller_id = 338008;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2717)
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 62)
8	App\Repository\TallerRepository->formatTallerArray (line 353)
9	App\Controller\Api\TallerController->tallerShow (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 5)

1.23 ms
(9.64%)

SELECT t0.id AS id_1, t0.calle AS calle_2, t0.cp AS cp_3, t0.ciudad AS ciudad_4, t0.latitud AS latitud_5, t0.longitud AS longitud_6, t0.provincia_id AS provincia_id_7, t8.id AS id_9, t8.navision_id AS navision_id_10, t8.nombre AS nombre_11, t8.estado AS estado_12, t8.email AS email_13, t8.telefono AS telefono_14, t8.movil AS movil_15, t8.logo AS logo_16, t8.descripcion AS descripcion_17, t8.dir_envio AS dir_envio_18, t8.comercial AS comercial_19, t8.acepta_citas AS acepta_citas_20, t8.red_id AS red_id_21, t8.direccion_id AS direccion_id_22 FROM direccion t0 LEFT JOIN taller t8 ON t8.direccion_id = t0.id WHERE t0.id = ?

Parameters:

[
  338008
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.calle AS calle_2,
  t0.cp AS cp_3,
  t0.ciudad AS ciudad_4,
  t0.latitud AS latitud_5,
  t0.longitud AS longitud_6,
  t0.provincia_id AS provincia_id_7,
  t8.id AS id_9,
  t8.navision_id AS navision_id_10,
  t8.nombre AS nombre_11,
  t8.estado AS estado_12,
  t8.email AS email_13,
  t8.telefono AS telefono_14,
  t8.movil AS movil_15,
  t8.logo AS logo_16,
  t8.descripcion AS descripcion_17,
  t8.dir_envio AS dir_envio_18,
  t8.comercial AS comercial_19,
  t8.acepta_citas AS acepta_citas_20,
  t8.red_id AS red_id_21,
  t8.direccion_id AS direccion_id_22
FROM
  direccion t0
  LEFT JOIN taller t8 ON t8.direccion_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.calle AS calle_2, t0.cp AS cp_3, t0.ciudad AS ciudad_4, t0.latitud AS latitud_5, t0.longitud AS longitud_6, t0.provincia_id AS provincia_id_7, t8.id AS id_9, t8.navision_id AS navision_id_10, t8.nombre AS nombre_11, t8.estado AS estado_12, t8.email AS email_13, t8.telefono AS telefono_14, t8.movil AS movil_15, t8.logo AS logo_16, t8.descripcion AS descripcion_17, t8.dir_envio AS dir_envio_18, t8.comercial AS comercial_19, t8.acepta_citas AS acepta_citas_20, t8.red_id AS red_id_21, t8.direccion_id AS direccion_id_22 FROM direccion t0 LEFT JOIN taller t8 ON t8.direccion_id = t0.id WHERE t0.id = 338008;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 270)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 348)
5	Proxies\__CG__\App\Entity\Direccion::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Direccion->__get (line 58)
8	App\Entity\Direccion->getCalle (line 39)
9	App\Repository\DireccionRepository->formatDireccionArray (line 67)
10	App\Repository\TallerRepository->formatTallerArray (line 353)
11	App\Controller\Api\TallerController->tallerShow (line 183)
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 5)

1.06 ms
(8.32%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.descripcion AS descripcion_4 FROM servicio t0 INNER JOIN taller_servicio ON t0.id = taller_servicio.servicio_id WHERE taller_servicio.taller_id = ?

Parameters:

[
  338008
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.codigo AS codigo_3,
  t0.descripcion AS descripcion_4
FROM
  servicio t0
  INNER JOIN taller_servicio ON t0.id = taller_servicio.servicio_id
WHERE
  taller_servicio.taller_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.descripcion AS descripcion_4 FROM servicio t0 INNER JOIN taller_servicio ON t0.id = taller_servicio.servicio_id WHERE taller_servicio.taller_id = 338008;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2717)
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 57)
8	App\Repository\TallerRepository->formatTallerArray (line 353)
9	App\Controller\Api\TallerController->tallerShow (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 5)

0.81 ms
(6.30%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3 FROM red t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.codigo AS codigo_3
FROM
  red t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3 FROM red t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 270)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 348)
5	Proxies\__CG__\App\Entity\Red::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Red->__get (line 64)
8	App\Entity\Red->getNombre (line 35)
9	App\Repository\RedRepository->formatRedArray (line 66)
10	App\Repository\TallerRepository->formatTallerArray (line 353)
11	App\Controller\Api\TallerController->tallerShow (line 183)
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 5)

0.71 ms
(5.57%)

SELECT t0.id AS id_1, t0.status AS status_2, t0.inicio AS inicio_3, t0.fin AS fin_4, t0.taller_id AS taller_id_5, t6.id AS id_7, t6.observacion AS observacion_8, t6.tipo AS tipo_9, t6.hash AS hash_10, t6.taller_id AS taller_id_11, t6.slot_id AS slot_id_12, t6.contactocliente_id AS contactocliente_id_13 FROM slot t0 LEFT JOIN cita t6 ON t6.slot_id = t0.id WHERE t0.taller_id = ?

Parameters:

[
  338008
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.inicio AS inicio_3,
  t0.fin AS fin_4,
  t0.taller_id AS taller_id_5,
  t6.id AS id_7,
  t6.observacion AS observacion_8,
  t6.tipo AS tipo_9,
  t6.hash AS hash_10,
  t6.taller_id AS taller_id_11,
  t6.slot_id AS slot_id_12,
  t6.contactocliente_id AS contactocliente_id_13
FROM
  slot t0
  LEFT JOIN cita t6 ON t6.slot_id = t0.id
WHERE
  t0.taller_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.inicio AS inicio_3, t0.fin AS fin_4, t0.taller_id AS taller_id_5, t6.id AS id_7, t6.observacion AS observacion_8, t6.tipo AS tipo_9, t6.hash AS hash_10, t6.taller_id AS taller_id_11, t6.slot_id AS slot_id_12, t6.contactocliente_id AS contactocliente_id_13 FROM slot t0 LEFT JOIN cita t6 ON t6.slot_id = t0.id WHERE t0.taller_id = 338008;

#	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 69)
8	App\Repository\TallerRepository->formatTallerArray (line 353)
9	App\Controller\Api\TallerController->tallerShow (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 5)

0.71 ms
(5.56%)

SELECT t0.id AS id_1, t0.imagen AS imagen_2, t0.taller_id AS taller_id_3 FROM imagen t0 WHERE t0.taller_id = ?

Parameters:

[
  338008
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.imagen AS imagen_2,
  t0.taller_id AS taller_id_3
FROM
  imagen t0
WHERE
  t0.taller_id = ?

SELECT t0.id AS id_1, t0.imagen AS imagen_2, t0.taller_id AS taller_id_3 FROM imagen t0 WHERE t0.taller_id = 338008;

#	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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 81)
8	App\Repository\TallerRepository->formatTallerArray (line 353)
9	App\Controller\Api\TallerController->tallerShow (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 5)

0.63 ms
(4.96%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM provincia t0 WHERE t0.id = ?

Parameters:

[
  46
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2
FROM
  provincia t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM provincia t0 WHERE t0.id = 46;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 270)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 348)
5	Proxies\__CG__\App\Entity\Provincia::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Provincia->__get (line 26)
8	App\Entity\Provincia->getNombre (line 37)
9	App\Repository\ProvinciaRepository->formatProvinciaArray (line 44)
10	App\Repository\DireccionRepository->formatDireccionArray (line 67)
11	App\Repository\TallerRepository->formatTallerArray (line 353)
12	App\Controller\Api\TallerController->tallerShow (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.53 ms
(4.13%)

SELECT t0.id AS id_1, t0.observacion AS observacion_2, t0.tipo AS tipo_3, t0.hash AS hash_4, t0.taller_id AS taller_id_5, t0.slot_id AS slot_id_6, t0.contactocliente_id AS contactocliente_id_7 FROM cita t0 WHERE t0.taller_id = ?

Parameters:

[
  338008
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.observacion AS observacion_2,
  t0.tipo AS tipo_3,
  t0.hash AS hash_4,
  t0.taller_id AS taller_id_5,
  t0.slot_id AS slot_id_6,
  t0.contactocliente_id AS contactocliente_id_7
FROM
  cita t0
WHERE
  t0.taller_id = ?

SELECT t0.id AS id_1, t0.observacion AS observacion_2, t0.tipo AS tipo_3, t0.hash AS hash_4, t0.taller_id AS taller_id_5, t0.slot_id AS slot_id_6, t0.contactocliente_id AS contactocliente_id_7 FROM cita t0 WHERE t0.taller_id = 338008;

#	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 86)
8	App\Repository\TallerRepository->formatTallerArray (line 353)
9	App\Controller\Api\TallerController->tallerShow (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 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\Vehiculo	4
App\Entity\Servicio	2
App\Entity\Taller	1
App\Entity\Red	1
App\Entity\Direccion	1
App\Entity\Provincia	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.
App\Entity\Marca	No errors.
App\Entity\Promocion	No errors.
App\Entity\Slide	No errors.
App\Entity\Provincia	No errors.
App\Entity\ContactoCliente	No errors.

Symfony Profiler

GET https://talleres-api.nex-desarrollodigital.com/api/taller/338008/show

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping