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

Query Metrics

9 Database Queries
9 Different statements
12.77 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 5.83 ms
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"
]
2 1.06 ms
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
]
3 1.27 ms
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
]
4 0.81 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3 FROM red t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 1.23 ms
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
]
6 0.63 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM provincia t0 WHERE t0.id = ?
Parameters:
[
  46
]
7 0.71 ms
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
]
8 0.71 ms
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
]
9 0.53 ms
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
]

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.