https://daiteke.aplicaciones.debamatika.com/comun/proyecto/221

Query Metrics

23 Database Queries
18 Different statements
31.16 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
]
8 0.77 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
9 0.33 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
10 0.09 ms
SELECT DATABASE()
Parameters:
[]
11 0.53 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'daitekecrm' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
12 0.09 ms
SELECT DATABASE()
Parameters:
[]
13 4.08 ms
SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!50116 , c.UPDATE_RULE, c.DELETE_RULE */ FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /*!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'daitekecrm' /*!50116 AND c.CONSTRAINT_SCHEMA = 'daitekecrm' */ORDER BY k.ORDINAL_POSITION
Parameters:
[]
14 0.08 ms
SELECT DATABASE()
Parameters:
[]
15 0.16 ms
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'daitekecrm' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
16 0.42 ms
SELECT t.ENGINE,
       t.AUTO_INCREMENT,
       t.TABLE_COMMENT,
       t.CREATE_OPTIONS,
       t.TABLE_COLLATION,
       ccsa.CHARACTER_SET_NAME
FROM information_schema.TABLES t
    INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa
        ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
17 0.12 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
18 0.11 ms
SELECT DATABASE()
Parameters:
[]
19 0.18 ms
SELECT t0.id AS id_1, t0.cif AS cif_2, t0.razon_social AS razon_social_3, t0.direccion AS direccion_4, t0.telefono AS telefono_5, t0.email AS email_6, t0.habilitado AS habilitado_7, t0.tamano AS tamano_8, t0.tipo_cliente_id AS tipo_cliente_id_9, t0.localidad_id AS localidad_id_10, t0.sector_id AS sector_id_11 FROM cliente t0 WHERE t0.id = ?
Parameters:
[
  31
]
20 0.20 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.email AS email_3, t0.telefono AS telefono_4, t0.habilitado AS habilitado_5, t0.rango_salarial_id AS rango_salarial_id_6, t7.id AS id_8, t7.email AS email_9, t7.roles AS roles_10, t7.password AS password_11, t7.is_verified AS is_verified_12, t7.nombre AS nombre_13, t7.habilitado AS habilitado_14, t7.empleada_id AS empleada_id_15, t7.contacto_id AS contacto_id_16, t7.contacto_proveedor_id AS contacto_proveedor_id_17 FROM empleada t0 LEFT JOIN usuario t7 ON t7.empleada_id = t0.id WHERE t0.id = ?
Parameters:
[
  9
]
21 0.17 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.padre_id = ?
Parameters:
[
  221
]
22 0.15 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2 FROM area t0 WHERE t0.id = ?
Parameters:
[
  2
]
23 0.12 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.habilitado AS habilitado_3, t0.area_id AS area_id_4 FROM servicio t0 WHERE t0.id = ?
Parameters:
[
  10
]

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.
App\Entity\Admin\RangoSalarial No errors.
App\Entity\Comun\FichajeDiario No errors.
App\Entity\Accion\Reunion No errors.
App\Entity\Comun\Festivo No errors.
App\Entity\Admin\Proveedor No errors.
App\Entity\Admin\TipoCliente No errors.
App\Entity\Admin\Localidad No errors.
App\Entity\Admin\Sector No errors.
App\Entity\Adjunto\AdjuntoJustificacion No errors.
App\Entity\Adjunto\AdjuntoConvenio No errors.
App\Entity\Adjunto\AdjuntoGasto No errors.