Query Metrics

7 Database Queries
6 Different statements
23.55 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.04 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.nombre AS nombre_6, t0.habilitado AS habilitado_7, t0.empleada_id AS empleada_id_8, t0.contacto_id AS contacto_id_9, t0.contacto_proveedor_id AS contacto_proveedor_id_10 FROM usuario t0 WHERE t0.id = ?
Parameters:
[
  4
]
2 0.29 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.fecha_inicio AS fecha_inicio_3, t0.financiacion AS financiacion_4, t0.multiple AS multiple_5, t0.estado AS estado_6, t0.fecha_fin AS fecha_fin_7, t0.cliente_id AS cliente_id_8, t0.area_id AS area_id_9, t0.servicio_id AS servicio_id_10, t0.responsable_id AS responsable_id_11, t0.padre_id AS padre_id_12 FROM proyecto t0 WHERE t0.id = ?
Parameters:
[
  "221"
]
3 0.29 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.fecha_inicio AS fecha_inicio_3, t0.fecha_fin AS fecha_fin_4, t0.estado AS estado_5, t0.proyecto_id AS proyecto_id_6, t0.padre_id AS padre_id_7 FROM tarea t0 WHERE t0.proyecto_id = ?
Parameters:
[
  221
]
4 6.87 ms
SELECT n0_.id AS id_0, n0_.fecha AS fecha_1, n0_.textoes AS textoes_2, n0_.textoeus AS textoeus_3, n0_.leido AS leido_4, n0_.objeto AS objeto_5, n0_.destinatario_id AS destinatario_id_6, n0_.tipo_id AS tipo_id_7 FROM notificacion n0_ WHERE n0_.leido = ? AND n0_.destinatario_id = ? ORDER BY n0_.fecha DESC LIMIT 5
Parameters:
[
  0
  4
]
5 14.46 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.textoes AS textoes_3, t0.textoeus AS textoeus_4, t0.leido AS leido_5, t0.objeto AS objeto_6, t0.destinatario_id AS destinatario_id_7, t0.tipo_id AS tipo_id_8 FROM notificacion t0 WHERE t0.destinatario_id = ? AND t0.leido = ? ORDER BY t0.fecha DESC
Parameters:
[
  4
  0
]
6 0.41 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.20 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM tipo_notificacion t0 WHERE t0.id = ?
Parameters:
[
  3
]

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\Accesos\Usuario No errors.
App\Entity\Admin\Empleada No errors.
App\Entity\Admin\Contacto No errors.
App\Entity\Admin\ContactoProveedor No errors.
App\Entity\Comun\Proyecto No errors.
App\Entity\Admin\Cliente No errors.
App\Entity\Admin\Area No errors.
App\Entity\Admin\Servicio No errors.
App\Entity\Comun\Tarea No errors.
App\Entity\Accesos\Tercero
  • The association App\Entity\Accesos\Tercero#usuario refers to the inverse side field App\Entity\Accesos\Usuario#terceros which does not exist.
App\Entity\Comun\Justificacion No errors.
App\Entity\Comun\Convenio No errors.
App\Entity\Comun\Gasto No errors.
App\Entity\Comun\Fichaje No errors.
App\Entity\Accion\ProyectoReunion No errors.
App\Entity\Comun\ProyectoEmpleada No errors.
App\Entity\Comun\TareaEmpleada No errors.
App\Entity\Adjunto\AdjuntoTarea No errors.
App\Entity\Accion\Llamada No errors.
App\Entity\Accion\Email No errors.
App\Entity\Comun\Notificacion No errors.
App\Entity\Comun\TipoNotificacion No errors.