Query Metrics
2
Database Queries
2
Different statements
2.65 ms
Query time
0
Invalid entities
26
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.48 ms (55.99%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.imagen AS imagen_6, t0.activo AS activo_7, t0.verified AS verified_8, t0.conformidad AS conformidad_9, t10.id AS id_11, t10.email_personal AS email_personal_12, t10.telefono AS telefono_13, t10.movil AS movil_14, t10.direccion AS direccion_15, t10.poblacion AS poblacion_16, t10.codigo_postal AS codigo_postal_17, t10.provincia AS provincia_18, t10.apellidos AS apellidos_19, t10.fecha_antiguedad AS fecha_antiguedad_20, t10.fecha_baja AS fecha_baja_21, t10.fecha_nacimiento AS fecha_nacimiento_22, t10.horas_contrato AS horas_contrato_23, t10.nacionalidad AS nacionalidad_24, t10.nif AS nif_25, t10.nivel_formativo AS nivel_formativo_26, t10.n_hijos AS n_hijos_27, t10.seguridad_social AS seguridad_social_28, t10.sexo AS sexo_29, t10.vehiculo AS vehiculo_30, t10.tipo_contrato AS tipo_contrato_31, t10.carnet AS carnet_32, t10.zona_trabajo AS zona_trabajo_33, t10.dni_delantero AS dni_delantero_34, t10.dni_trasero AS dni_trasero_35, t10.nombre_contacto AS nombre_contacto_36, t10.telefono_contacto AS telefono_contacto_37, t10.complemento_salarial AS complemento_salarial_38, t10.fecha_contratacion_inicial AS fecha_contratacion_inicial_39, t10.porcentaje_jornada AS porcentaje_jornada_40, t10.sustituye_nombre AS sustituye_nombre_41, t10.sustituye_dni AS sustituye_dni_42, t10.conciliacion_horaria AS conciliacion_horaria_43, t10.observaciones AS observaciones_44, t10.movilidad_geografica AS movilidad_geografica_45, t10.user_id AS user_id_46, t10.informacion_bancaria_id AS informacion_bancaria_id_47, t10.estado_empleado_id AS estado_empleado_id_48, t0.modalidad_ausencia_id AS modalidad_ausencia_id_49, t50.id AS id_51, t50.titulacion AS titulacion_52, t50.documento_titulacion AS documento_titulacion_53, t50.especialidad AS especialidad_54, t50.manipulador_alimentos AS manipulador_alimentos_55, t50.certificado_prl AS certificado_prl_56, t50.documento_prl AS documento_prl_57, t50.fecha_prl AS fecha_prl_58, t50.fecha_creacion AS fecha_creacion_59, t50.usuario_id AS usuario_id_60 FROM `user` t0 LEFT JOIN user_datos_contacto t10 ON t10.user_id = t0.id LEFT JOIN formacion_empleado t50 ON t50.usuario_id = t0.id WHERE t0.id = ?
Parameters:
[
542
]
|
||||||||||||||||||||||||
|
1.16 ms (44.01%) |
1 |
SELECT t0.id AS id_1, t0.fecha_entrada AS fecha_entrada_2, t0.fecha_salida AS fecha_salida_3, t0.aceptada AS aceptada_4, t0.comentarios AS comentarios_5, t0.latitud_entrada AS latitud_entrada_6, t0.longitud_entrada AS longitud_entrada_7, t0.latitud_salida AS latitud_salida_8, t0.longitud_salida AS longitud_salida_9, t0.user_id AS user_id_10 FROM jornada t0 WHERE t0.user_id = ?
Parameters:
[
542
]
|
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\Jornada | 25 |
| App\Entity\User | 1 |