Query Metrics
3
Database Queries
3
Different statements
23.35 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.80 ms |
SELECT t0.username AS username_1, t0.roles AS roles_2, t0.password AS password_3, t0.codigo AS codigo_4, t0.nombre AS nombre_5, t0.apellido1 AS apellido1_6, t0.apellido2 AS apellido2_7, t0.cp AS cp_8, t0.observaciones AS observaciones_9, t0.nif AS nif_10, t0.is_activo AS is_activo_11, t0.descripcion AS descripcion_12, t0.tipo AS tipo_13, t0.nombre_representante AS nombre_representante_14, t0.email_representante AS email_representante_15, t0.telefono_representante AS telefono_representante_16, t0.nif_representante AS nif_representante_17, t0.cargo_representante AS cargo_representante_18, t0.seguimiento AS seguimiento_19, t0.uuid AS uuid_20, t0.id AS id_21, t0.empresa_id AS empresa_id_22, t0.grupo_empresa_id AS grupo_empresa_id_23 FROM `user` t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
"ATRUTER"
]
|
| 2 | 4.14 ms |
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sesiones_valores s0_ INNER JOIN empresa e1_ ON s0_.empresa_id = e1_.id AND (e1_.id = ?) INNER JOIN sesion s2_ ON s0_.sesion_id = s2_.id INNER JOIN muestra m3_ ON s0_.muestra_id = m3_.id INNER JOIN `user` u4_ ON s0_.evaluador_id = u4_.id INNER JOIN producto_parametros p5_ ON s0_.producto_parametro_id = p5_.id WHERE s0_.id IN (SELECT s6_.id FROM sesiones_valores s6_ INNER JOIN empresa e7_ ON s6_.empresa_id = e7_.id AND (e7_.id = ?) INNER JOIN sesion s8_ ON s6_.sesion_id = s8_.id INNER JOIN muestra m9_ ON s6_.muestra_id = m9_.id WHERE s8_.uuid = ? AND m9_.uuid = ?)
Parameters:
[ 17 17 "a8fadbbb-1d78-4c84-9c5f-96f28474bf82" "b3dd3ce4-8229-464f-8b8e-e09012789095" ] |
| 3 | 18.41 ms |
SELECT s0_.valor AS valor_0, s0_.is_evaluado AS is_evaluado_1, s0_.is_cumple AS is_cumple_2, s0_.parametros AS parametros_3, s0_.uuid AS uuid_4, s0_.id AS id_5, e1_.nombre AS nombre_6, e1_.cif AS cif_7, e1_.is_activo AS is_activo_8, e1_.codigo AS codigo_9, e1_.params_calculos AS params_calculos_10, e1_.params_informes AS params_informes_11, e1_.logo_name AS logo_name_12, e1_.uuid AS uuid_13, e1_.id AS id_14, e1_.created AS created_15, e1_.updated AS updated_16, s2_.nombre AS nombre_17, s2_.descripcion AS descripcion_18, s2_.codigo AS codigo_19, s2_.temperatura AS temperatura_20, s2_.fecha AS fecha_21, s2_.estado AS estado_22, s2_.control AS control_23, s2_.organizacion AS organizacion_24, s2_.parametros_muestra AS parametros_muestra_25, s2_.hora_fin AS hora_fin_26, s2_.created AS created_27, s2_.updated AS updated_28, s2_.uuid AS uuid_29, s2_.id AS id_30, m3_.codigo AS codigo_31, m3_.cod_id AS cod_id_32, m3_.nombre AS nombre_33, m3_.productor AS productor_34, m3_.tipo_producto AS tipo_producto_35, m3_.n_informe AS n_informe_36, m3_.fecha AS fecha_37, m3_.is_resuelto AS is_resuelto_38, m3_.fases AS fases_39, m3_.definicion AS definicion_40, m3_.marca AS marca_41, m3_.repetida AS repetida_42, m3_.reproducida AS reproducida_43, m3_.original AS original_44, m3_.codigo_auditor AS codigo_auditor_45, m3_.fecha_toma AS fecha_toma_46, m3_.contraetiqueta_precinta AS contraetiqueta_precinta_47, m3_.created AS created_48, m3_.updated AS updated_49, m3_.uuid AS uuid_50, m3_.id AS id_51, u4_.username AS username_52, u4_.roles AS roles_53, u4_.password AS password_54, u4_.codigo AS codigo_55, u4_.nombre AS nombre_56, u4_.apellido1 AS apellido1_57, u4_.apellido2 AS apellido2_58, u4_.cp AS cp_59, u4_.observaciones AS observaciones_60, u4_.nif AS nif_61, u4_.is_activo AS is_activo_62, u4_.descripcion AS descripcion_63, u4_.tipo AS tipo_64, u4_.nombre_representante AS nombre_representante_65, u4_.email_representante AS email_representante_66, u4_.telefono_representante AS telefono_representante_67, u4_.nif_representante AS nif_representante_68, u4_.cargo_representante AS cargo_representante_69, u4_.seguimiento AS seguimiento_70, u4_.uuid AS uuid_71, u4_.id AS id_72, p5_.val_min AS val_min_73, p5_.val_max AS val_max_74, p5_.peso AS peso_75, p5_.is_defecto AS is_defecto_76, p5_.is_discriminante AS is_discriminante_77, p5_.is_mod_escala AS is_mod_escala_78, p5_.escala AS escala_79, p5_.is_activo AS is_activo_80, p5_.orden_fase AS orden_fase_81, p5_.orden_parametro AS orden_parametro_82, p5_.hook AS hook_83, p5_.uuid AS uuid_84, p5_.id AS id_85, s0_.empresa_id AS empresa_id_86, s0_.evaluador_id AS evaluador_id_87, s0_.muestra_id AS muestra_id_88, s0_.producto_parametro_id AS producto_parametro_id_89, s0_.sesion_id AS sesion_id_90, e1_.grupo_empresa_id AS grupo_empresa_id_91, s2_.empresa_id AS empresa_id_92, s2_.created_by AS created_by_93, s2_.updated_by AS updated_by_94, m3_.producto_id AS producto_id_95, m3_.empresa_id AS empresa_id_96, m3_.parent_id AS parent_id_97, m3_.sesion_id AS sesion_id_98, m3_.created_by AS created_by_99, m3_.updated_by AS updated_by_100, u4_.empresa_id AS empresa_id_101, u4_.grupo_empresa_id AS grupo_empresa_id_102, p5_.empresa_id AS empresa_id_103, p5_.fase_id AS fase_id_104, p5_.producto_id AS producto_id_105, p5_.parametro_id AS parametro_id_106 FROM sesiones_valores s0_ INNER JOIN empresa e1_ ON s0_.empresa_id = e1_.id AND (e1_.id = ?) INNER JOIN sesion s2_ ON s0_.sesion_id = s2_.id INNER JOIN muestra m3_ ON s0_.muestra_id = m3_.id INNER JOIN `user` u4_ ON s0_.evaluador_id = u4_.id INNER JOIN producto_parametros p5_ ON s0_.producto_parametro_id = p5_.id WHERE s0_.id IN (SELECT s6_.id FROM sesiones_valores s6_ INNER JOIN empresa e7_ ON s6_.empresa_id = e7_.id AND (e7_.id = ?) INNER JOIN sesion s8_ ON s6_.sesion_id = s8_.id INNER JOIN muestra m9_ ON s6_.muestra_id = m9_.id WHERE s8_.uuid = ? AND m9_.uuid = ?) ORDER BY s0_.id ASC LIMIT 3000
Parameters:
[ 17 17 "a8fadbbb-1d78-4c84-9c5f-96f28474bf82" "b3dd3ce4-8229-464f-8b8e-e09012789095" ] |
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\SesionesValores | No errors. |
| App\Entity\Empresa | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Muestra | No errors. |
| App\Entity\ProductoParametros | No errors. |
| App\Entity\Sesion | No errors. |
| App\Entity\GrupoEmpresa | No errors. |
| App\Entity\Email | No errors. |
| App\Entity\Telefono | No errors. |
| App\Entity\Direccion | No errors. |
| App\Entity\Notificacion | No errors. |
| App\Entity\Producto | No errors. |
| App\Entity\Fase | No errors. |
| App\Entity\Parametro | No errors. |
| App\Entity\Evento | No errors. |