Query Metrics

3 Database Queries
3 Different statements
23.35 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
18.41 ms
(78.82%)
1
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"
]
4.14 ms
(17.74%)
1
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"
]
0.80 ms
(3.44%)
1
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"
]

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.