Symfony Profiler

SELECT
  m0_.codigo AS codigo_0,
  m0_.cod_id AS cod_id_1,
  m0_.nombre AS nombre_2,
  m0_.productor AS productor_3,
  m0_.tipo_producto AS tipo_producto_4,
  m0_.n_informe AS n_informe_5,
  m0_.fecha AS fecha_6,
  m0_.is_resuelto AS is_resuelto_7,
  m0_.fases AS fases_8,
  m0_.definicion AS definicion_9,
  m0_.marca AS marca_10,
  m0_.repetida AS repetida_11,
  m0_.reproducida AS reproducida_12,
  m0_.original AS original_13,
  m0_.codigo_auditor AS codigo_auditor_14,
  m0_.fecha_toma AS fecha_toma_15,
  m0_.contraetiqueta_precinta AS contraetiqueta_precinta_16,
  m0_.created AS created_17,
  m0_.updated AS updated_18,
  m0_.uuid AS uuid_19,
  m0_.id AS id_20,
  e1_.nombre AS nombre_21,
  e1_.cif AS cif_22,
  e1_.is_activo AS is_activo_23,
  e1_.codigo AS codigo_24,
  e1_.params_calculos AS params_calculos_25,
  e1_.params_informes AS params_informes_26,
  e1_.logo_name AS logo_name_27,
  e1_.uuid AS uuid_28,
  e1_.id AS id_29,
  e1_.created AS created_30,
  e1_.updated AS updated_31,
  p2_.is_activo AS is_activo_32,
  p2_.codigo AS codigo_33,
  p2_.nombre AS nombre_34,
  p2_.definicion_muestra AS definicion_muestra_35,
  p2_.fases AS fases_36,
  p2_.modelo AS modelo_37,
  p2_.created AS created_38,
  p2_.updated AS updated_39,
  p2_.uuid AS uuid_40,
  p2_.id AS id_41,
  p3_.val_min AS val_min_42,
  p3_.val_max AS val_max_43,
  p3_.peso AS peso_44,
  p3_.is_defecto AS is_defecto_45,
  p3_.is_discriminante AS is_discriminante_46,
  p3_.is_mod_escala AS is_mod_escala_47,
  p3_.escala AS escala_48,
  p3_.is_activo AS is_activo_49,
  p3_.orden_fase AS orden_fase_50,
  p3_.orden_parametro AS orden_parametro_51,
  p3_.hook AS hook_52,
  p3_.uuid AS uuid_53,
  p3_.id AS id_54,
  c4_.codigo AS codigo_55,
  c4_.nombre AS nombre_56,
  c4_.orden AS orden_57,
  c4_.color AS color_58,
  c4_.core AS core_59,
  c4_.created AS created_60,
  c4_.updated AS updated_61,
  c4_.uuid AS uuid_62,
  c4_.id AS id_63,
  m5_.codigo AS codigo_64,
  m5_.cod_id AS cod_id_65,
  m5_.nombre AS nombre_66,
  m5_.productor AS productor_67,
  m5_.tipo_producto AS tipo_producto_68,
  m5_.n_informe AS n_informe_69,
  m5_.fecha AS fecha_70,
  m5_.is_resuelto AS is_resuelto_71,
  m5_.fases AS fases_72,
  m5_.definicion AS definicion_73,
  m5_.marca AS marca_74,
  m5_.repetida AS repetida_75,
  m5_.reproducida AS reproducida_76,
  m5_.original AS original_77,
  m5_.codigo_auditor AS codigo_auditor_78,
  m5_.fecha_toma AS fecha_toma_79,
  m5_.contraetiqueta_precinta AS contraetiqueta_precinta_80,
  m5_.created AS created_81,
  m5_.updated AS updated_82,
  m5_.uuid AS uuid_83,
  m5_.id AS id_84,
  s6_.nombre AS nombre_85,
  s6_.descripcion AS descripcion_86,
  s6_.codigo AS codigo_87,
  s6_.temperatura AS temperatura_88,
  s6_.fecha AS fecha_89,
  s6_.estado AS estado_90,
  s6_.control AS control_91,
  s6_.organizacion AS organizacion_92,
  s6_.parametros_muestra AS parametros_muestra_93,
  s6_.hora_fin AS hora_fin_94,
  s6_.created AS created_95,
  s6_.updated AS updated_96,
  s6_.uuid AS uuid_97,
  s6_.id AS id_98,
  m0_.producto_id AS producto_id_99,
  m0_.empresa_id AS empresa_id_100,
  m0_.parent_id AS parent_id_101,
  m0_.sesion_id AS sesion_id_102,
  m0_.created_by AS created_by_103,
  m0_.updated_by AS updated_by_104,
  e1_.grupo_empresa_id AS grupo_empresa_id_105,
  p2_.empresa_id AS empresa_id_106,
  p2_.categoria_id AS categoria_id_107,
  p2_.created_by AS created_by_108,
  p2_.updated_by AS updated_by_109,
  p3_.empresa_id AS empresa_id_110,
  p3_.fase_id AS fase_id_111,
  p3_.producto_id AS producto_id_112,
  p3_.parametro_id AS parametro_id_113,
  c4_.empresa_id AS empresa_id_114,
  c4_.created_by AS created_by_115,
  c4_.updated_by AS updated_by_116,
  m5_.producto_id AS producto_id_117,
  m5_.empresa_id AS empresa_id_118,
  m5_.parent_id AS parent_id_119,
  m5_.sesion_id AS sesion_id_120,
  m5_.created_by AS created_by_121,
  m5_.updated_by AS updated_by_122,
  s6_.empresa_id AS empresa_id_123,
  s6_.created_by AS created_by_124,
  s6_.updated_by AS updated_by_125
FROM
  muestra m0_
  INNER JOIN empresa e1_ ON m0_.empresa_id = e1_.id
  AND (e1_.id = ?)
  INNER JOIN producto p2_ ON m0_.producto_id = p2_.id
  LEFT JOIN producto_parametros p3_ ON p2_.id = p3_.producto_id
  LEFT JOIN categoria c4_ ON p2_.categoria_id = c4_.id
  LEFT JOIN muestra m5_ ON m0_.parent_id = m5_.id
  LEFT JOIN sesion s6_ ON m0_.sesion_id = s6_.id
WHERE
  m0_.id IN (
    SELECT
      m7_.id
    FROM
      muestra m7_
      INNER JOIN empresa e8_ ON m7_.empresa_id = e8_.id
      AND (e8_.id = ?)
    WHERE
      m7_.sesion_id IS NULL
  )
ORDER BY
  m0_.id ASC

SELECT m0_.codigo AS codigo_0, m0_.cod_id AS cod_id_1, m0_.nombre AS nombre_2, m0_.productor AS productor_3, m0_.tipo_producto AS tipo_producto_4, m0_.n_informe AS n_informe_5, m0_.fecha AS fecha_6, m0_.is_resuelto AS is_resuelto_7, m0_.fases AS fases_8, m0_.definicion AS definicion_9, m0_.marca AS marca_10, m0_.repetida AS repetida_11, m0_.reproducida AS reproducida_12, m0_.original AS original_13, m0_.codigo_auditor AS codigo_auditor_14, m0_.fecha_toma AS fecha_toma_15, m0_.contraetiqueta_precinta AS contraetiqueta_precinta_16, m0_.created AS created_17, m0_.updated AS updated_18, m0_.uuid AS uuid_19, m0_.id AS id_20, e1_.nombre AS nombre_21, e1_.cif AS cif_22, e1_.is_activo AS is_activo_23, e1_.codigo AS codigo_24, e1_.params_calculos AS params_calculos_25, e1_.params_informes AS params_informes_26, e1_.logo_name AS logo_name_27, e1_.uuid AS uuid_28, e1_.id AS id_29, e1_.created AS created_30, e1_.updated AS updated_31, p2_.is_activo AS is_activo_32, p2_.codigo AS codigo_33, p2_.nombre AS nombre_34, p2_.definicion_muestra AS definicion_muestra_35, p2_.fases AS fases_36, p2_.modelo AS modelo_37, p2_.created AS created_38, p2_.updated AS updated_39, p2_.uuid AS uuid_40, p2_.id AS id_41, p3_.val_min AS val_min_42, p3_.val_max AS val_max_43, p3_.peso AS peso_44, p3_.is_defecto AS is_defecto_45, p3_.is_discriminante AS is_discriminante_46, p3_.is_mod_escala AS is_mod_escala_47, p3_.escala AS escala_48, p3_.is_activo AS is_activo_49, p3_.orden_fase AS orden_fase_50, p3_.orden_parametro AS orden_parametro_51, p3_.hook AS hook_52, p3_.uuid AS uuid_53, p3_.id AS id_54, c4_.codigo AS codigo_55, c4_.nombre AS nombre_56, c4_.orden AS orden_57, c4_.color AS color_58, c4_.core AS core_59, c4_.created AS created_60, c4_.updated AS updated_61, c4_.uuid AS uuid_62, c4_.id AS id_63, m5_.codigo AS codigo_64, m5_.cod_id AS cod_id_65, m5_.nombre AS nombre_66, m5_.productor AS productor_67, m5_.tipo_producto AS tipo_producto_68, m5_.n_informe AS n_informe_69, m5_.fecha AS fecha_70, m5_.is_resuelto AS is_resuelto_71, m5_.fases AS fases_72, m5_.definicion AS definicion_73, m5_.marca AS marca_74, m5_.repetida AS repetida_75, m5_.reproducida AS reproducida_76, m5_.original AS original_77, m5_.codigo_auditor AS codigo_auditor_78, m5_.fecha_toma AS fecha_toma_79, m5_.contraetiqueta_precinta AS contraetiqueta_precinta_80, m5_.created AS created_81, m5_.updated AS updated_82, m5_.uuid AS uuid_83, m5_.id AS id_84, s6_.nombre AS nombre_85, s6_.descripcion AS descripcion_86, s6_.codigo AS codigo_87, s6_.temperatura AS temperatura_88, s6_.fecha AS fecha_89, s6_.estado AS estado_90, s6_.control AS control_91, s6_.organizacion AS organizacion_92, s6_.parametros_muestra AS parametros_muestra_93, s6_.hora_fin AS hora_fin_94, s6_.created AS created_95, s6_.updated AS updated_96, s6_.uuid AS uuid_97, s6_.id AS id_98, m0_.producto_id AS producto_id_99, m0_.empresa_id AS empresa_id_100, m0_.parent_id AS parent_id_101, m0_.sesion_id AS sesion_id_102, m0_.created_by AS created_by_103, m0_.updated_by AS updated_by_104, e1_.grupo_empresa_id AS grupo_empresa_id_105, p2_.empresa_id AS empresa_id_106, p2_.categoria_id AS categoria_id_107, p2_.created_by AS created_by_108, p2_.updated_by AS updated_by_109, p3_.empresa_id AS empresa_id_110, p3_.fase_id AS fase_id_111, p3_.producto_id AS producto_id_112, p3_.parametro_id AS parametro_id_113, c4_.empresa_id AS empresa_id_114, c4_.created_by AS created_by_115, c4_.updated_by AS updated_by_116, m5_.producto_id AS producto_id_117, m5_.empresa_id AS empresa_id_118, m5_.parent_id AS parent_id_119, m5_.sesion_id AS sesion_id_120, m5_.created_by AS created_by_121, m5_.updated_by AS updated_by_122, s6_.empresa_id AS empresa_id_123, s6_.created_by AS created_by_124, s6_.updated_by AS updated_by_125 FROM muestra m0_ INNER JOIN empresa e1_ ON m0_.empresa_id = e1_.id AND (e1_.id = 17) INNER JOIN producto p2_ ON m0_.producto_id = p2_.id LEFT JOIN producto_parametros p3_ ON p2_.id = p3_.producto_id LEFT JOIN categoria c4_ ON p2_.categoria_id = c4_.id LEFT JOIN muestra m5_ ON m0_.parent_id = m5_.id LEFT JOIN sesion s6_ ON m0_.sesion_id = s6_.id WHERE m0_.id IN (SELECT m7_.id FROM muestra m7_ INNER JOIN empresa e8_ ON m7_.empresa_id = e8_.id AND (e8_.id = 17) WHERE m7_.sesion_id IS NULL) ORDER BY m0_.id ASC;

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

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 = 'ATRUTER' LIMIT 1;

SELECT
  t0.nombre AS nombre_1,
  t0.descripcion AS descripcion_2,
  t0.codigo AS codigo_3,
  t0.temperatura AS temperatura_4,
  t0.fecha AS fecha_5,
  t0.estado AS estado_6,
  t0.control AS control_7,
  t0.organizacion AS organizacion_8,
  t0.parametros_muestra AS parametros_muestra_9,
  t0.hora_fin AS hora_fin_10,
  t0.created AS created_11,
  t0.updated AS updated_12,
  t0.uuid AS uuid_13,
  t0.id AS id_14,
  t0.empresa_id AS empresa_id_15,
  t0.created_by AS created_by_16,
  t0.updated_by AS updated_by_17
FROM
  sesion t0
WHERE
  t0.id = ?

SELECT t0.nombre AS nombre_1, t0.descripcion AS descripcion_2, t0.codigo AS codigo_3, t0.temperatura AS temperatura_4, t0.fecha AS fecha_5, t0.estado AS estado_6, t0.control AS control_7, t0.organizacion AS organizacion_8, t0.parametros_muestra AS parametros_muestra_9, t0.hora_fin AS hora_fin_10, t0.created AS created_11, t0.updated AS updated_12, t0.uuid AS uuid_13, t0.id AS id_14, t0.empresa_id AS empresa_id_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM sesion t0 WHERE t0.id = 203;