Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.nombre AS nombre_6,
  t0.primer_apellido AS primer_apellido_7,
  t0.segundo_apellido AS segundo_apellido_8,
  t0.tipo_genero_id AS tipo_genero_id_9,
  t0.direccion AS direccion_10,
  t0.cp AS cp_11,
  t0.region AS region_12,
  t0.ciudad AS ciudad_13,
  t0.telefono AS telefono_14,
  t0.deleted_at AS deleted_at_15,
  t0.updated_at AS updated_at_16,
  t0.created_at AS created_at_17,
  t0.pais AS pais_18,
  t0.ccaa_id AS ccaa_id_19,
  t0.provincia_id AS provincia_id_20,
  t0.cliente_id AS cliente_id_21,
  t0.usuario_id AS usuario_id_22
FROM
  user t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.nombre AS nombre_6, t0.primer_apellido AS primer_apellido_7, t0.segundo_apellido AS segundo_apellido_8, t0.tipo_genero_id AS tipo_genero_id_9, t0.direccion AS direccion_10, t0.cp AS cp_11, t0.region AS region_12, t0.ciudad AS ciudad_13, t0.telefono AS telefono_14, t0.deleted_at AS deleted_at_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.pais AS pais_18, t0.ccaa_id AS ccaa_id_19, t0.provincia_id AS provincia_id_20, t0.cliente_id AS cliente_id_21, t0.usuario_id AS usuario_id_22 FROM user t0 WHERE t0.id = '3' AND ((t0.deleted_at IS NULL));

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO perseo.log (
  user, roles, webservice, uri, method,
  headers, request, query, referer,
  user_agent, server_name, server_addr,
  remote_addr, deleted_at, updated_at,
  created_at
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO perseo.log (user, roles, webservice, uri, method, headers, request, query, referer, user_agent, server_name, server_addr, remote_addr, deleted_at, updated_at, created_at) VALUES ('ivan', '[\"ROLE_ADMIN\",\"ROLE_USER\"]', 'admin_app_valoracion_list', NULL, 'GET', '{\"cookie\":[\"sf_redirect=%7B%22token%22%3A%228be73d%22%2C%22route%22%3A%22admin_app_valoracion_edit%22%2C%22method%22%3A%22POST%22%2C%22controller%22%3A%7B%22class%22%3A%22App%5C%5CController%5C%5CAdmin%5C%5CValoracionAdminController%22%2C%22method%22%3A%22editAction%22%2C%22file%22%3A%22%5C%2Fvar%5C%2Fwww%5C%2Fvhosts%5C%2Fperseo.comerziawatches.com%5C%2Fhttpdocs%5C%2Fperseo%5C%2Fhttpdocs%5C%2Fsrc%5C%2FController%5C%2FAdmin%5C%2FValoracionAdminController.php%22%2C%22line%22%3A125%7D%2C%22status_code%22%3A302%2C%22status_text%22%3A%22Found%22%7D; PHPSESSID=v31phe1ap0pighbchs8qj60ma5; _ga_9WW1MLN4N6=GS2.1.s1774896854$o66$g0$t1774896854$j60$l0$h0; _ga_QMD3ZTG7ZP=GS2.1.s1774896854$o66$g0$t1774896854$j60$l0$h0; _ga=GA1.1.417558243.1759838203; sbjs_current=typ%3Dtypein%7C%7C%7Csrc%3D%28direct%29%7C%7C%7Cmdm%3D%28none%29%7C%7C%7Ccmp%3D%28none%29%7C%7C%7Ccnt%3D%28none%29%7C%7C%7Ctrm%3D%28none%29%7C%7C%7Cid%3D%28none%29%7C%7C%7Cplt%3D%28none%29%7C%7C%7Cfmt%3D%28none%29%7C%7C%7Ctct%3D%28none%29; sbjs_udata=vst%3D44%7C%7C%7Cuip%3D%28none%29%7C%7C%7Cuag%3DMozilla%2F5.0%20%28Macintosh%3B%20Intel%20Mac%20OS%20X%2010_15_7%29%20AppleWebKit%2F605.1.15%20%28KHTML%2C%20like%20Gecko%29%20Version%2F26.3.1%20Safari%2F605.1.15; sbjs_current_add=fd%3D2025-09-30%2016%3A35%3A07%7C%7C%7Cep%3Dhttps%3A%2F%2Fwww.comerziawatches.com%2F%7C%7C%7Crf%3D%28none%29; sbjs_first=typ%3Dtypein%7C%7C%7Csrc%3D%28direct%29%7C%7C%7Cmdm%3D%28none%29%7C%7C%7Ccmp%3D%28none%29%7C%7C%7Ccnt%3D%28none%29%7C%7C%7Ctrm%3D%28none%29%7C%7C%7Cid%3D%28none%29%7C%7C%7Cplt%3D%28none%29%7C%7C%7Cfmt%3D%28none%29%7C%7C%7Ctct%3D%28none%29; sbjs_first_add=fd%3D2025-09-30%2016%3A35%3A07%7C%7C%7Cep%3Dhttps%3A%2F%2Fwww.comerziawatches.com%2F%7C%7C%7Crf%3D%28none%29; sbjs_migrations=1418474375998%3D1\"],\"accept-encoding\":[\"gzip, deflate, br, zstd\"],\"referer\":[\"https:\\/\\/perseo.comerziawatches.com\\/es\\/admin\\/app\\/valoracion\\/1887\\/edit?uniqid=s69d37d45ce749\"],\"sec-fetch-dest\":[\"document\"],\"accept-language\":[\"es-ES,es;q=0.9\"],\"user-agent\":[\"Mozilla\\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\\/605.1.15 (KHTML, like Gecko) Version\\/26.3.1 Safari\\/605.1.15\"],\"sec-fetch-mode\":[\"navigate\"],\"priority\":[\"u=0, i\"],\"sec-fetch-site\":[\"same-origin\"],\"accept\":[\"text\\/html,application\\/xhtml+xml,application\\/xml;q=0.9,*\\/*;q=0.8\"],\"connection\":[\"close\"],\"x-accel-internal\":[\"\\/internal-nginx-static-location\"],\"x-real-ip\":[\"148.3.201.36\"],\"host\":[\"perseo.comerziawatches.com\"],\"x-php-ob-level\":[\"1\"]}', '[]', '{\"filter\":{\"_page\":\"1\",\"_per_page\":\"50\",\"usuario\":{\"type\":\"1\",\"value\":\"0\"},\"estado\":{\"type\":\"1\",\"value\":[\"ABIERTA\",\"EN_ESPERA\",\"ACEPTADA\"]}}}', 'https://perseo.comerziawatches.com/es/admin/app/valoracion/1887/edit?uniqid=s69d37d45ce749', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3.1 Safari/605.1.15', 'perseo.comerziawatches.com', '82.223.107.15', '148.3.201.36', NULL, '2026-04-06 13:08:09', '2026-04-06 13:08:09');

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.id_perseo AS id_perseo_2,
  t0.avatar AS avatar_3,
  t0.deleted_at AS deleted_at_4,
  t0.updated_at AS updated_at_5,
  t0.created_at AS created_at_6,
  t7.id AS id_8,
  t7.username AS username_9,
  t7.email AS email_10,
  t7.roles AS roles_11,
  t7.password AS password_12,
  t7.nombre AS nombre_13,
  t7.primer_apellido AS primer_apellido_14,
  t7.segundo_apellido AS segundo_apellido_15,
  t7.tipo_genero_id AS tipo_genero_id_16,
  t7.direccion AS direccion_17,
  t7.cp AS cp_18,
  t7.region AS region_19,
  t7.ciudad AS ciudad_20,
  t7.telefono AS telefono_21,
  t7.deleted_at AS deleted_at_22,
  t7.updated_at AS updated_at_23,
  t7.created_at AS created_at_24,
  t7.pais AS pais_25,
  t7.ccaa_id AS ccaa_id_26,
  t7.provincia_id AS provincia_id_27,
  t7.cliente_id AS cliente_id_28,
  t7.usuario_id AS usuario_id_29,
  t30.id AS id_31,
  t30.nombre AS nombre_32,
  t30.descripcion AS descripcion_33,
  t30.color AS color_34,
  t30.active AS active_35,
  t30.deleted_at AS deleted_at_36,
  t30.updated_at AS updated_at_37,
  t30.created_at AS created_at_38,
  t30.empresa_id AS empresa_id_39,
  t30.responsable_usuario_id AS responsable_usuario_id_40,
  t0.unidad_negocio_id AS unidad_negocio_id_41
FROM
  usuario t0
  LEFT JOIN user t7 ON t7.usuario_id = t0.id
  AND (
    (t7.deleted_at IS NULL)
  )
  LEFT JOIN unidad_negocio t30 ON t30.responsable_usuario_id = t0.id
  AND (
    (t30.deleted_at IS NULL)
  )
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.avatar AS avatar_3, t0.deleted_at AS deleted_at_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t7.id AS id_8, t7.username AS username_9, t7.email AS email_10, t7.roles AS roles_11, t7.password AS password_12, t7.nombre AS nombre_13, t7.primer_apellido AS primer_apellido_14, t7.segundo_apellido AS segundo_apellido_15, t7.tipo_genero_id AS tipo_genero_id_16, t7.direccion AS direccion_17, t7.cp AS cp_18, t7.region AS region_19, t7.ciudad AS ciudad_20, t7.telefono AS telefono_21, t7.deleted_at AS deleted_at_22, t7.updated_at AS updated_at_23, t7.created_at AS created_at_24, t7.pais AS pais_25, t7.ccaa_id AS ccaa_id_26, t7.provincia_id AS provincia_id_27, t7.cliente_id AS cliente_id_28, t7.usuario_id AS usuario_id_29, t30.id AS id_31, t30.nombre AS nombre_32, t30.descripcion AS descripcion_33, t30.color AS color_34, t30.active AS active_35, t30.deleted_at AS deleted_at_36, t30.updated_at AS updated_at_37, t30.created_at AS created_at_38, t30.empresa_id AS empresa_id_39, t30.responsable_usuario_id AS responsable_usuario_id_40, t0.unidad_negocio_id AS unidad_negocio_id_41 FROM usuario t0 LEFT JOIN user t7 ON t7.usuario_id = t0.id AND ((t7.deleted_at IS NULL)) LEFT JOIN unidad_negocio t30 ON t30.responsable_usuario_id = t0.id AND ((t30.deleted_at IS NULL)) WHERE t0.id = '2' AND ((t0.deleted_at IS NULL));

SELECT
  u0_.id AS id_0,
  u0_.id_perseo AS id_perseo_1,
  u0_.avatar AS avatar_2,
  u0_.deleted_at AS deleted_at_3,
  u0_.updated_at AS updated_at_4,
  u0_.created_at AS created_at_5,
  u0_.unidad_negocio_id AS unidad_negocio_id_6
FROM
  usuario u0_
WHERE
  (u0_.unidad_negocio_id = ?)
  AND (u0_.deleted_at IS NULL)

SELECT u0_.id AS id_0, u0_.id_perseo AS id_perseo_1, u0_.avatar AS avatar_2, u0_.deleted_at AS deleted_at_3, u0_.updated_at AS updated_at_4, u0_.created_at AS created_at_5, u0_.unidad_negocio_id AS unidad_negocio_id_6 FROM usuario u0_ WHERE (u0_.unidad_negocio_id = '1') AND (u0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.nombre AS nombre_6,
  t0.primer_apellido AS primer_apellido_7,
  t0.segundo_apellido AS segundo_apellido_8,
  t0.tipo_genero_id AS tipo_genero_id_9,
  t0.direccion AS direccion_10,
  t0.cp AS cp_11,
  t0.region AS region_12,
  t0.ciudad AS ciudad_13,
  t0.telefono AS telefono_14,
  t0.deleted_at AS deleted_at_15,
  t0.updated_at AS updated_at_16,
  t0.created_at AS created_at_17,
  t0.pais AS pais_18,
  t0.ccaa_id AS ccaa_id_19,
  t0.provincia_id AS provincia_id_20,
  t0.cliente_id AS cliente_id_21,
  t0.usuario_id AS usuario_id_22
FROM
  user t0
WHERE
  t0.usuario_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.nombre AS nombre_6, t0.primer_apellido AS primer_apellido_7, t0.segundo_apellido AS segundo_apellido_8, t0.tipo_genero_id AS tipo_genero_id_9, t0.direccion AS direccion_10, t0.cp AS cp_11, t0.region AS region_12, t0.ciudad AS ciudad_13, t0.telefono AS telefono_14, t0.deleted_at AS deleted_at_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.pais AS pais_18, t0.ccaa_id AS ccaa_id_19, t0.provincia_id AS provincia_id_20, t0.cliente_id AS cliente_id_21, t0.usuario_id AS usuario_id_22 FROM user t0 WHERE t0.usuario_id = '1' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.color AS color_4,
  t0.active AS active_5,
  t0.deleted_at AS deleted_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_at AS created_at_8,
  t0.empresa_id AS empresa_id_9,
  t0.responsable_usuario_id AS responsable_usuario_id_10
FROM
  unidad_negocio t0
WHERE
  t0.responsable_usuario_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.color AS color_4, t0.active AS active_5, t0.deleted_at AS deleted_at_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.empresa_id AS empresa_id_9, t0.responsable_usuario_id AS responsable_usuario_id_10 FROM unidad_negocio t0 WHERE t0.responsable_usuario_id = '1' AND ((t0.deleted_at IS NULL));

SELECT
  count(DISTINCT v0_.id) AS sclr_0
FROM
  valoraciones_relojes v0_
  INNER JOIN valoracion v1_ ON v0_.valoracion_id = v1_.id
  AND (v1_.deleted_at IS NULL)
  LEFT JOIN valoraciones_relojes v2_ ON (v0_.id = v2_.id)
  AND v2_.type IN ('sinstock')
  AND (v2_.deleted_at IS NULL)
WHERE
  (
    (
      v0_.type IN (?)
      AND (
        (
          v1_.fecha_enviada IS NULL
          AND v1_.fecha_aceptacion IS NULL
          AND v1_.fecha_rechazo IS NULL
          AND v1_.fecha_tramitacion IS NULL
          AND v1_.fecha_tramitada IS NULL
        )
        OR (
          v1_.fecha_enviada IS NOT NULL
          AND v1_.fecha_aceptacion IS NULL
          AND v1_.fecha_rechazo IS NULL
        )
        OR (
          v1_.fecha_aceptacion IS NOT NULL
          AND v1_.fecha_tramitacion IS NULL
          AND v1_.fecha_rechazo IS NULL
        )
      )
    )
    AND (v0_.deleted_at IS NULL)
  )
  AND v0_.type IN ('stock', 'sinstock')

SELECT count(DISTINCT v0_.id) AS sclr_0 FROM valoraciones_relojes v0_ INNER JOIN valoracion v1_ ON v0_.valoracion_id = v1_.id AND (v1_.deleted_at IS NULL) LEFT JOIN valoraciones_relojes v2_ ON (v0_.id = v2_.id) AND v2_.type IN ('sinstock') AND (v2_.deleted_at IS NULL) WHERE ((v0_.type IN ('sinstock') AND ((v1_.fecha_enviada IS NULL AND v1_.fecha_aceptacion IS NULL AND v1_.fecha_rechazo IS NULL AND v1_.fecha_tramitacion IS NULL AND v1_.fecha_tramitada IS NULL) OR (v1_.fecha_enviada IS NOT NULL AND v1_.fecha_aceptacion IS NULL AND v1_.fecha_rechazo IS NULL) OR (v1_.fecha_aceptacion IS NOT NULL AND v1_.fecha_tramitacion IS NULL AND v1_.fecha_rechazo IS NULL))) AND (v0_.deleted_at IS NULL)) AND v0_.type IN ('stock', 'sinstock');

SELECT
  DISTINCT v0_.id AS id_0,
  GREATEST(
    COALESCE(v1_.fecha_rechazo, '1981-05-16'),
    COALESCE(
      v1_.fecha_tramitada, '1981-05-16'
    ),
    COALESCE(
      v1_.fecha_tramitacion, '1981-05-16'
    ),
    COALESCE(
      v1_.fecha_aceptacion, '1981-05-16'
    ),
    COALESCE(v1_.fecha_enviada, '1981-05-16')
  ) AS sclr_1,
  v0_.id AS id_2
FROM
  valoraciones_relojes v0_
  INNER JOIN valoracion v1_ ON v0_.valoracion_id = v1_.id
  AND (v1_.deleted_at IS NULL)
  LEFT JOIN valoraciones_relojes v2_ ON (v0_.id = v2_.id)
  AND v2_.type IN ('sinstock')
  AND (v2_.deleted_at IS NULL)
WHERE
  (
    (
      v0_.type IN (?)
      AND (
        (
          v1_.fecha_enviada IS NULL
          AND v1_.fecha_aceptacion IS NULL
          AND v1_.fecha_rechazo IS NULL
          AND v1_.fecha_tramitacion IS NULL
          AND v1_.fecha_tramitada IS NULL
        )
        OR (
          v1_.fecha_enviada IS NOT NULL
          AND v1_.fecha_aceptacion IS NULL
          AND v1_.fecha_rechazo IS NULL
        )
        OR (
          v1_.fecha_aceptacion IS NOT NULL
          AND v1_.fecha_tramitacion IS NULL
          AND v1_.fecha_rechazo IS NULL
        )
      )
    )
    AND (v0_.deleted_at IS NULL)
  )
  AND v0_.type IN ('stock', 'sinstock')
ORDER BY
  sclr_1 DESC,
  v0_.id ASC
LIMIT
  50

SELECT DISTINCT v0_.id AS id_0, GREATEST(COALESCE(v1_.fecha_rechazo, '1981-05-16'), COALESCE(v1_.fecha_tramitada, '1981-05-16'), COALESCE(v1_.fecha_tramitacion, '1981-05-16'), COALESCE(v1_.fecha_aceptacion, '1981-05-16'), COALESCE(v1_.fecha_enviada, '1981-05-16')) AS sclr_1, v0_.id AS id_2 FROM valoraciones_relojes v0_ INNER JOIN valoracion v1_ ON v0_.valoracion_id = v1_.id AND (v1_.deleted_at IS NULL) LEFT JOIN valoraciones_relojes v2_ ON (v0_.id = v2_.id) AND v2_.type IN ('sinstock') AND (v2_.deleted_at IS NULL) WHERE ((v0_.type IN ('sinstock') AND ((v1_.fecha_enviada IS NULL AND v1_.fecha_aceptacion IS NULL AND v1_.fecha_rechazo IS NULL AND v1_.fecha_tramitacion IS NULL AND v1_.fecha_tramitada IS NULL) OR (v1_.fecha_enviada IS NOT NULL AND v1_.fecha_aceptacion IS NULL AND v1_.fecha_rechazo IS NULL) OR (v1_.fecha_aceptacion IS NOT NULL AND v1_.fecha_tramitacion IS NULL AND v1_.fecha_rechazo IS NULL))) AND (v0_.deleted_at IS NULL)) AND v0_.type IN ('stock', 'sinstock') ORDER BY sclr_1 DESC, v0_.id ASC LIMIT 50;

SELECT
  v0_.id AS id_0,
  v0_.id_perseo AS id_perseo_1,
  v0_.info_valoracion_compra AS info_valoracion_compra_2,
  v0_.is_precio_chrono24 AS is_precio_chrono24_3,
  v0_.deleted_at AS deleted_at_4,
  v0_.updated_at AS updated_at_5,
  v0_.created_at AS created_at_6,
  v0_.precio_promocion AS precio_promocion_7,
  v0_.descuento AS descuento_8,
  v0_.reloj_idperseo AS reloj_idperseo_9,
  v0_.reloj_foto AS reloj_foto_10,
  v0_.reloj_modelo1 AS reloj_modelo1_11,
  v0_.reloj_ref1 AS reloj_ref1_12,
  v0_.reloj_fecha AS reloj_fecha_13,
  v0_.reloj_caja AS reloj_caja_14,
  v0_.reloj_papeles AS reloj_papeles_15,
  v0_.itp AS itp_16,
  v0_.comision AS comision_17,
  v0_.precio_coste AS precio_coste_18,
  v0_.precio_coste_total AS precio_coste_total_19,
  v0_.precio_min_venta AS precio_min_venta_20,
  v0_.precio_promocion AS precio_promocion_21,
  v0_.precio_oferta AS precio_oferta_22,
  v0_.precio_referencia AS precio_referencia_23,
  v0_.precio_pagar AS precio_pagar_24,
  v0_.margen_minimo AS margen_minimo_25,
  v0_.margen_deseado AS margen_deseado_26,
  v0_.margen_promocion AS margen_promocion_27,
  v0_.costes_total AS costes_total_28,
  GREATEST(
    COALESCE(v1_.fecha_rechazo, '1981-05-16'),
    COALESCE(
      v1_.fecha_tramitada, '1981-05-16'
    ),
    COALESCE(
      v1_.fecha_tramitacion, '1981-05-16'
    ),
    COALESCE(
      v1_.fecha_aceptacion, '1981-05-16'
    ),
    COALESCE(v1_.fecha_enviada, '1981-05-16')
  ) AS sclr_29,
  v0_.type AS type_30,
  v0_.valoracion_id AS valoracion_id_31,
  v0_.reloj_id AS reloj_id_32,
  v0_.clone_id AS clone_id_33,
  v0_.plataforma_promocion_id AS plataforma_promocion_id_34,
  v0_.reloj_inventario_id AS reloj_inventario_id_35,
  v0_.reloj_marca_id AS reloj_marca_id_36,
  v0_.reloj_aspecto_id AS reloj_aspecto_id_37,
  v0_.reloj_base_id AS reloj_base_id_38
FROM
  valoraciones_relojes v0_
  INNER JOIN valoracion v1_ ON v0_.valoracion_id = v1_.id
  AND (v1_.deleted_at IS NULL)
  LEFT JOIN valoraciones_relojes v2_ ON (v0_.id = v2_.id)
  AND v2_.type IN ('sinstock')
  AND (v2_.deleted_at IS NULL)
WHERE
  (
    (
      v0_.type IN (?)
      AND (
        (
          v1_.fecha_enviada IS NULL
          AND v1_.fecha_aceptacion IS NULL
          AND v1_.fecha_rechazo IS NULL
          AND v1_.fecha_tramitacion IS NULL
          AND v1_.fecha_tramitada IS NULL
        )
        OR (
          v1_.fecha_enviada IS NOT NULL
          AND v1_.fecha_aceptacion IS NULL
          AND v1_.fecha_rechazo IS NULL
        )
        OR (
          v1_.fecha_aceptacion IS NOT NULL
          AND v1_.fecha_tramitacion IS NULL
          AND v1_.fecha_rechazo IS NULL
        )
      )
      AND v0_.id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?
      )
    )
    AND (v0_.deleted_at IS NULL)
  )
  AND v0_.type IN ('stock', 'sinstock')
ORDER BY
  sclr_29 DESC,
  v0_.id ASC

SELECT v0_.id AS id_0, v0_.id_perseo AS id_perseo_1, v0_.info_valoracion_compra AS info_valoracion_compra_2, v0_.is_precio_chrono24 AS is_precio_chrono24_3, v0_.deleted_at AS deleted_at_4, v0_.updated_at AS updated_at_5, v0_.created_at AS created_at_6, v0_.precio_promocion AS precio_promocion_7, v0_.descuento AS descuento_8, v0_.reloj_idperseo AS reloj_idperseo_9, v0_.reloj_foto AS reloj_foto_10, v0_.reloj_modelo1 AS reloj_modelo1_11, v0_.reloj_ref1 AS reloj_ref1_12, v0_.reloj_fecha AS reloj_fecha_13, v0_.reloj_caja AS reloj_caja_14, v0_.reloj_papeles AS reloj_papeles_15, v0_.itp AS itp_16, v0_.comision AS comision_17, v0_.precio_coste AS precio_coste_18, v0_.precio_coste_total AS precio_coste_total_19, v0_.precio_min_venta AS precio_min_venta_20, v0_.precio_promocion AS precio_promocion_21, v0_.precio_oferta AS precio_oferta_22, v0_.precio_referencia AS precio_referencia_23, v0_.precio_pagar AS precio_pagar_24, v0_.margen_minimo AS margen_minimo_25, v0_.margen_deseado AS margen_deseado_26, v0_.margen_promocion AS margen_promocion_27, v0_.costes_total AS costes_total_28, GREATEST(COALESCE(v1_.fecha_rechazo, '1981-05-16'), COALESCE(v1_.fecha_tramitada, '1981-05-16'), COALESCE(v1_.fecha_tramitacion, '1981-05-16'), COALESCE(v1_.fecha_aceptacion, '1981-05-16'), COALESCE(v1_.fecha_enviada, '1981-05-16')) AS sclr_29, v0_.type AS type_30, v0_.valoracion_id AS valoracion_id_31, v0_.reloj_id AS reloj_id_32, v0_.clone_id AS clone_id_33, v0_.plataforma_promocion_id AS plataforma_promocion_id_34, v0_.reloj_inventario_id AS reloj_inventario_id_35, v0_.reloj_marca_id AS reloj_marca_id_36, v0_.reloj_aspecto_id AS reloj_aspecto_id_37, v0_.reloj_base_id AS reloj_base_id_38 FROM valoraciones_relojes v0_ INNER JOIN valoracion v1_ ON v0_.valoracion_id = v1_.id AND (v1_.deleted_at IS NULL) LEFT JOIN valoraciones_relojes v2_ ON (v0_.id = v2_.id) AND v2_.type IN ('sinstock') AND (v2_.deleted_at IS NULL) WHERE ((v0_.type IN ('sinstock') AND ((v1_.fecha_enviada IS NULL AND v1_.fecha_aceptacion IS NULL AND v1_.fecha_rechazo IS NULL AND v1_.fecha_tramitacion IS NULL AND v1_.fecha_tramitada IS NULL) OR (v1_.fecha_enviada IS NOT NULL AND v1_.fecha_aceptacion IS NULL AND v1_.fecha_rechazo IS NULL) OR (v1_.fecha_aceptacion IS NOT NULL AND v1_.fecha_tramitacion IS NULL AND v1_.fecha_rechazo IS NULL)) AND v0_.id IN ('4078', '4071', '4072', '4073', '4074', '4025', '2194', '1429', '1415', '1398', '1394', '1395', '1382', '1323', '1328', '1329', '2217', '1311', '1318', '1207', '1171', '1166', '1172', '1153', '1143', '1135', '1136', '1137', '1138', '1139', '1140', '1141', '1142', '1131', '1078', '1068', '1072', '1073', '1098', '1059', '1060', '1025', '1028', '1021', '1015', '1016', '1017', '1012', '985', '955')) AND (v0_.deleted_at IS NULL)) AND v0_.type IN ('stock', 'sinstock') ORDER BY sclr_29 DESC, v0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.precio_coste AS precio_coste_2,
  t0.precio_promocion AS precio_promocion_3,
  t0.reloj_foto AS reloj_foto_4,
  t0.reloj_modelo1 AS reloj_modelo1_5,
  t0.reloj_modelo2 AS reloj_modelo2_6,
  t0.reloj_ref1 AS reloj_ref1_7,
  t0.reloj_ref2 AS reloj_ref2_8,
  t0.reloj_serie AS reloj_serie_9,
  t0.reloj_fecha AS reloj_fecha_10,
  t0.reloj_caja AS reloj_caja_11,
  t0.reloj_papeles AS reloj_papeles_12,
  t0.reloj_regimen AS reloj_regimen_13,
  t0.comentario AS comentario_14,
  t0.deleted_at AS deleted_at_15,
  t0.updated_at AS updated_at_16,
  t0.created_at AS created_at_17,
  t0.precio_pagar AS precio_pagar_18,
  t0.coste_importacion_iva AS coste_importacion_iva_19,
  t0.coste_importacion_otros AS coste_importacion_otros_20,
  t0.fecha_verificacion AS fecha_verificacion_21,
  t0.fecha_cancelacion AS fecha_cancelacion_22,
  t0.reloj_aspecto_id AS reloj_aspecto_id_23,
  t0.reloj_marca_id AS reloj_marca_id_24,
  t0.compra_id AS compra_id_25,
  t0.reloj_compra_id AS reloj_compra_id_26,
  t0.reloj_base_id AS reloj_base_id_27,
  t0.valoracion_reloj_id AS valoracion_reloj_id_28,
  t0.type
FROM
  detalle_operacion t0
WHERE
  t0.valoracion_reloj_id = ?
  AND t0.type IN ('compra')
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.precio_coste AS precio_coste_2, t0.precio_promocion AS precio_promocion_3, t0.reloj_foto AS reloj_foto_4, t0.reloj_modelo1 AS reloj_modelo1_5, t0.reloj_modelo2 AS reloj_modelo2_6, t0.reloj_ref1 AS reloj_ref1_7, t0.reloj_ref2 AS reloj_ref2_8, t0.reloj_serie AS reloj_serie_9, t0.reloj_fecha AS reloj_fecha_10, t0.reloj_caja AS reloj_caja_11, t0.reloj_papeles AS reloj_papeles_12, t0.reloj_regimen AS reloj_regimen_13, t0.comentario AS comentario_14, t0.deleted_at AS deleted_at_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.precio_pagar AS precio_pagar_18, t0.coste_importacion_iva AS coste_importacion_iva_19, t0.coste_importacion_otros AS coste_importacion_otros_20, t0.fecha_verificacion AS fecha_verificacion_21, t0.fecha_cancelacion AS fecha_cancelacion_22, t0.reloj_aspecto_id AS reloj_aspecto_id_23, t0.reloj_marca_id AS reloj_marca_id_24, t0.compra_id AS compra_id_25, t0.reloj_compra_id AS reloj_compra_id_26, t0.reloj_base_id AS reloj_base_id_27, t0.valoracion_reloj_id AS valoracion_reloj_id_28, t0.type FROM detalle_operacion t0 WHERE t0.valoracion_reloj_id = '4078' AND t0.type IN ('compra') AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.precio_coste AS precio_coste_2,
  t0.precio_promocion AS precio_promocion_3,
  t0.reloj_foto AS reloj_foto_4,
  t0.reloj_modelo1 AS reloj_modelo1_5,
  t0.reloj_modelo2 AS reloj_modelo2_6,
  t0.reloj_ref1 AS reloj_ref1_7,
  t0.reloj_ref2 AS reloj_ref2_8,
  t0.reloj_serie AS reloj_serie_9,
  t0.reloj_fecha AS reloj_fecha_10,
  t0.reloj_caja AS reloj_caja_11,
  t0.reloj_papeles AS reloj_papeles_12,
  t0.reloj_regimen AS reloj_regimen_13,
  t0.comentario AS comentario_14,
  t0.deleted_at AS deleted_at_15,
  t0.updated_at AS updated_at_16,
  t0.created_at AS created_at_17,
  t0.precio_pagar AS precio_pagar_18,
  t0.coste_importacion_iva AS coste_importacion_iva_19,
  t0.coste_importacion_otros AS coste_importacion_otros_20,
  t0.fecha_verificacion AS fecha_verificacion_21,
  t0.fecha_cancelacion AS fecha_cancelacion_22,
  t0.reloj_aspecto_id AS reloj_aspecto_id_23,
  t0.reloj_marca_id AS reloj_marca_id_24,
  t0.compra_id AS compra_id_25,
  t0.reloj_compra_id AS reloj_compra_id_26,
  t0.reloj_base_id AS reloj_base_id_27,
  t0.valoracion_reloj_id AS valoracion_reloj_id_28,
  t0.type
FROM
  detalle_operacion t0
WHERE
  t0.valoracion_reloj_id = ?
  AND t0.type IN ('compra')
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.precio_coste AS precio_coste_2, t0.precio_promocion AS precio_promocion_3, t0.reloj_foto AS reloj_foto_4, t0.reloj_modelo1 AS reloj_modelo1_5, t0.reloj_modelo2 AS reloj_modelo2_6, t0.reloj_ref1 AS reloj_ref1_7, t0.reloj_ref2 AS reloj_ref2_8, t0.reloj_serie AS reloj_serie_9, t0.reloj_fecha AS reloj_fecha_10, t0.reloj_caja AS reloj_caja_11, t0.reloj_papeles AS reloj_papeles_12, t0.reloj_regimen AS reloj_regimen_13, t0.comentario AS comentario_14, t0.deleted_at AS deleted_at_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.precio_pagar AS precio_pagar_18, t0.coste_importacion_iva AS coste_importacion_iva_19, t0.coste_importacion_otros AS coste_importacion_otros_20, t0.fecha_verificacion AS fecha_verificacion_21, t0.fecha_cancelacion AS fecha_cancelacion_22, t0.reloj_aspecto_id AS reloj_aspecto_id_23, t0.reloj_marca_id AS reloj_marca_id_24, t0.compra_id AS compra_id_25, t0.reloj_compra_id AS reloj_compra_id_26, t0.reloj_base_id AS reloj_base_id_27, t0.valoracion_reloj_id AS valoracion_reloj_id_28, t0.type FROM detalle_operacion t0 WHERE t0.valoracion_reloj_id = '4071' AND t0.type IN ('compra') AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.precio_coste AS precio_coste_2,
  t0.precio_promocion AS precio_promocion_3,
  t0.reloj_foto AS reloj_foto_4,
  t0.reloj_modelo1 AS reloj_modelo1_5,
  t0.reloj_modelo2 AS reloj_modelo2_6,
  t0.reloj_ref1 AS reloj_ref1_7,
  t0.reloj_ref2 AS reloj_ref2_8,
  t0.reloj_serie AS reloj_serie_9,
  t0.reloj_fecha AS reloj_fecha_10,
  t0.reloj_caja AS reloj_caja_11,
  t0.reloj_papeles AS reloj_papeles_12,
  t0.reloj_regimen AS reloj_regimen_13,
  t0.comentario AS comentario_14,
  t0.deleted_at AS deleted_at_15,
  t0.updated_at AS updated_at_16,
  t0.created_at AS created_at_17,
  t0.precio_pagar AS precio_pagar_18,
  t0.coste_importacion_iva AS coste_importacion_iva_19,
  t0.coste_importacion_otros AS coste_importacion_otros_20,
  t0.fecha_verificacion AS fecha_verificacion_21,
  t0.fecha_cancelacion AS fecha_cancelacion_22,
  t0.reloj_aspecto_id AS reloj_aspecto_id_23,
  t0.reloj_marca_id AS reloj_marca_id_24,
  t0.compra_id AS compra_id_25,
  t0.reloj_compra_id AS reloj_compra_id_26,
  t0.reloj_base_id AS reloj_base_id_27,
  t0.valoracion_reloj_id AS valoracion_reloj_id_28,
  t0.type
FROM
  detalle_operacion t0
WHERE
  t0.valoracion_reloj_id = ?
  AND t0.type IN ('compra')
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.precio_coste AS precio_coste_2, t0.precio_promocion AS precio_promocion_3, t0.reloj_foto AS reloj_foto_4, t0.reloj_modelo1 AS reloj_modelo1_5, t0.reloj_modelo2 AS reloj_modelo2_6, t0.reloj_ref1 AS reloj_ref1_7, t0.reloj_ref2 AS reloj_ref2_8, t0.reloj_serie AS reloj_serie_9, t0.reloj_fecha AS reloj_fecha_10, t0.reloj_caja AS reloj_caja_11, t0.reloj_papeles AS reloj_papeles_12, t0.reloj_regimen AS reloj_regimen_13, t0.comentario AS comentario_14, t0.deleted_at AS deleted_at_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.precio_pagar AS precio_pagar_18, t0.coste_importacion_iva AS coste_importacion_iva_19, t0.coste_importacion_otros AS coste_importacion_otros_20, t0.fecha_verificacion AS fecha_verificacion_21, t0.fecha_cancelacion AS fecha_cancelacion_22, t0.reloj_aspecto_id AS reloj_aspecto_id_23, t0.reloj_marca_id AS reloj_marca_id_24, t0.compra_id AS compra_id_25, t0.reloj_compra_id AS reloj_compra_id_26, t0.reloj_base_id AS reloj_base_id_27, t0.valoracion_reloj_id AS valoracion_reloj_id_28, t0.type FROM detalle_operacion t0 WHERE t0.valoracion_reloj_id = '4072' AND t0.type IN ('compra') AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.precio_coste AS precio_coste_2,
  t0.precio_promocion AS precio_promocion_3,
  t0.reloj_foto AS reloj_foto_4,
  t0.reloj_modelo1 AS reloj_modelo1_5,
  t0.reloj_modelo2 AS reloj_modelo2_6,
  t0.reloj_ref1 AS reloj_ref1_7,
  t0.reloj_ref2 AS reloj_ref2_8,
  t0.reloj_serie AS reloj_serie_9,
  t0.reloj_fecha AS reloj_fecha_10,
  t0.reloj_caja AS reloj_caja_11,
  t0.reloj_papeles AS reloj_papeles_12,
  t0.reloj_regimen AS reloj_regimen_13,
  t0.comentario AS comentario_14,
  t0.deleted_at AS deleted_at_15,
  t0.updated_at AS updated_at_16,
  t0.created_at AS created_at_17,
  t0.precio_pagar AS precio_pagar_18,
  t0.coste_importacion_iva AS coste_importacion_iva_19,
  t0.coste_importacion_otros AS coste_importacion_otros_20,
  t0.fecha_verificacion AS fecha_verificacion_21,
  t0.fecha_cancelacion AS fecha_cancelacion_22,
  t0.reloj_aspecto_id AS reloj_aspecto_id_23,
  t0.reloj_marca_id AS reloj_marca_id_24,
  t0.compra_id AS compra_id_25,
  t0.reloj_compra_id AS reloj_compra_id_26,
  t0.reloj_base_id AS reloj_base_id_27,
  t0.valoracion_reloj_id AS valoracion_reloj_id_28,
  t0.type
FROM
  detalle_operacion t0
WHERE
  t0.valoracion_reloj_id = ?
  AND t0.type IN ('compra')
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.precio_coste AS precio_coste_2, t0.precio_promocion AS precio_promocion_3, t0.reloj_foto AS reloj_foto_4, t0.reloj_modelo1 AS reloj_modelo1_5, t0.reloj_modelo2 AS reloj_modelo2_6, t0.reloj_ref1 AS reloj_ref1_7, t0.reloj_ref2 AS reloj_ref2_8, t0.reloj_serie AS reloj_serie_9, t0.reloj_fecha AS reloj_fecha_10, t0.reloj_caja AS reloj_caja_11, t0.reloj_papeles AS reloj_papeles_12, t0.reloj_regimen AS reloj_regimen_13, t0.comentario AS comentario_14, t0.deleted_at AS deleted_at_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.precio_pagar AS precio_pagar_18, t0.coste_importacion_iva AS coste_importacion_iva_19, t0.coste_importacion_otros AS coste_importacion_otros_20, t0.fecha_verificacion AS fecha_verificacion_21, t0.fecha_cancelacion AS fecha_cancelacion_22, t0.reloj_aspecto_id AS reloj_aspecto_id_23, t0.reloj_marca_id AS reloj_marca_id_24, t0.compra_id AS compra_id_25, t0.reloj_compra_id AS reloj_compra_id_26, t0.reloj_base_id AS reloj_base_id_27, t0.valoracion_reloj_id AS valoracion_reloj_id_28, t0.type FROM detalle_operacion t0 WHERE t0.valoracion_reloj_id = '4073' AND t0.type IN ('compra') AND ((t0.deleted_at IS NULL));