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 = '2' 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 ('moises', '[\"ROLE_SUPER_ADMIN\",\"ROLE_USER\"]', 'admin_app_operacion_list', NULL, 'GET', '{\"cookie\":[\"sbjs_migrations=1418474375998%3D1; sbjs_first_add=fd%3D2025-06-20%2014%3A56%3A16%7C%7C%7Cep%3Dhttps%3A%2F%2Fwww.comerziawatches.com%2Frelojes%2F%7C%7C%7Crf%3Dhttps%3A%2F%2Fwww.comerziawatches.com%2Frelojes%2Fpage%2F3%2F; 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_current_add=fd%3D2025-11-27%2009%3A06%3A20%7C%7C%7Cep%3Dhttps%3A%2F%2Fwww.comerziawatches.com%2Frelojes%2F%7C%7C%7Crf%3Dhttps%3A%2F%2Fwww.google.com%2F; sbjs_current=typ%3Dorganic%7C%7C%7Csrc%3Dgoogle%7C%7C%7Cmdm%3Dorganic%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%3D22%7C%7C%7Cuip%3D%28none%29%7C%7C%7Cuag%3DMozilla%2F5.0%20%28Windows%20NT%2010.0%3B%20Win64%3B%20x64%29%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%29%20Chrome%2F147.0.0.0%20Safari%2F537.36; _ga=GA1.1.90127083.1769782445; _ga_QMD3ZTG7ZP=GS2.1.s1776369527$o26$g1$t1776369535$j52$l0$h0; _ga_9WW1MLN4N6=GS2.1.s1776369527$o26$g1$t1776369535$j52$l0$h0; PHPSESSID=9pjoovla5rsou5m2oa3slnichc\"],\"priority\":[\"u=0, i\"],\"accept-language\":[\"es-ES,es;q=0.9\"],\"accept-encoding\":[\"gzip, deflate, br, zstd\"],\"referer\":[\"https:\\/\\/perseo.comerziawatches.com\\/es\\/admin\\/app\\/operacion\\/662\\/edit\"],\"sec-fetch-dest\":[\"document\"],\"sec-fetch-user\":[\"?1\"],\"sec-fetch-mode\":[\"navigate\"],\"sec-fetch-site\":[\"same-origin\"],\"accept\":[\"text\\/html,application\\/xhtml+xml,application\\/xml;q=0.9,image\\/avif,image\\/webp,image\\/apng,*\\/*;q=0.8,application\\/signed-exchange;v=b3;q=0.7\"],\"user-agent\":[\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/147.0.0.0 Safari\\/537.36\"],\"upgrade-insecure-requests\":[\"1\"],\"sec-ch-ua-platform\":[\"\\\"Windows\\\"\"],\"sec-ch-ua-mobile\":[\"?0\"],\"sec-ch-ua\":[\"\\\"Google Chrome\\\";v=\\\"147\\\", \\\"Not.A\\/Brand\\\";v=\\\"8\\\", \\\"Chromium\\\";v=\\\"147\\\"\"],\"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\"]}', '[]', '{\"id\":\"662\"}', 'https://perseo.comerziawatches.com/es/admin/app/operacion/662/edit', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'perseo.comerziawatches.com', '82.223.107.15', '148.3.201.36', NULL, '2026-04-19 11:40:15', '2026-04-19 11:40:15');

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.tipo AS tipo_2,
  t0.id_perseo AS id_perseo_3,
  t0.fecha AS fecha_4,
  t0.tipo_cliente AS tipo_cliente_5,
  t0.exportacion AS exportacion_6,
  t0.idioma AS idioma_7,
  t0.fecha_tramitacion AS fecha_tramitacion_8,
  t0.fecha_tramitada AS fecha_tramitada_9,
  t0.fecha_confirmada AS fecha_confirmada_10,
  t0.fecha_asentada AS fecha_asentada_11,
  t0.fecha_finalizada AS fecha_finalizada_12,
  t0.fecha_cancelada AS fecha_cancelada_13,
  t0.forma_pago AS forma_pago_14,
  t0.precio_pagar AS precio_pagar_15,
  t0.comentario_contrato AS comentario_contrato_16,
  t0.comentario AS comentario_17,
  t0.contract_signed AS contract_signed_18,
  t0.can_deleted AS can_deleted_19,
  t0.deleted_at AS deleted_at_20,
  t0.updated_at AS updated_at_21,
  t0.created_at AS created_at_22,
  t0.compra_id AS compra_id_23,
  t0.venta_id AS venta_id_24,
  t0.valoracion_id AS valoracion_id_25,
  t0.canal_id AS canal_id_26,
  t0.cliente_id AS cliente_id_27,
  t0.estado_id AS estado_id_28,
  t0.banco_id AS banco_id_29,
  t0.firmante_id AS firmante_id_30,
  t0.intercambio_id AS intercambio_id_31,
  t0.unidad_negocio_id AS unidad_negocio_id_32,
  t0.usuario_id AS usuario_id_33
FROM
  operacion t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.id_perseo AS id_perseo_3, t0.fecha AS fecha_4, t0.tipo_cliente AS tipo_cliente_5, t0.exportacion AS exportacion_6, t0.idioma AS idioma_7, t0.fecha_tramitacion AS fecha_tramitacion_8, t0.fecha_tramitada AS fecha_tramitada_9, t0.fecha_confirmada AS fecha_confirmada_10, t0.fecha_asentada AS fecha_asentada_11, t0.fecha_finalizada AS fecha_finalizada_12, t0.fecha_cancelada AS fecha_cancelada_13, t0.forma_pago AS forma_pago_14, t0.precio_pagar AS precio_pagar_15, t0.comentario_contrato AS comentario_contrato_16, t0.comentario AS comentario_17, t0.contract_signed AS contract_signed_18, t0.can_deleted AS can_deleted_19, t0.deleted_at AS deleted_at_20, t0.updated_at AS updated_at_21, t0.created_at AS created_at_22, t0.compra_id AS compra_id_23, t0.venta_id AS venta_id_24, t0.valoracion_id AS valoracion_id_25, t0.canal_id AS canal_id_26, t0.cliente_id AS cliente_id_27, t0.estado_id AS estado_id_28, t0.banco_id AS banco_id_29, t0.firmante_id AS firmante_id_30, t0.intercambio_id AS intercambio_id_31, t0.unidad_negocio_id AS unidad_negocio_id_32, t0.usuario_id AS usuario_id_33 FROM operacion t0 WHERE t0.id = '662' 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.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.deleted_at IS NULL));

SELECT
  count(o0_.id) AS sclr_0
FROM
  operacion_detalle o0_
WHERE
  o0_.id IS NOT NULL
  AND o0_.deleted_at IS NULL
  AND (
    LOWER(o0_.IDperseo) LIKE ?
    OR LOWER(o0_.tipo) LIKE ?
    OR LOWER(o0_.valoracion_IDperseo) LIKE ?
    OR LOWER(o0_.estado_key) LIKE ?
    OR LOWER(o0_.estado_nombre) LIKE ?
    OR LOWER(o0_.cliente_razon_social) LIKE ?
    OR LOWER(o0_.canal_nombre) LIKE ?
    OR LOWER(o0_.fecha_tramitacion) LIKE ?
    OR LOWER(o0_.fecha_tramitada) LIKE ?
    OR LOWER(o0_.fecha_confirmada) LIKE ?
    OR LOWER(o0_.detalle_reloj_IDperseo) LIKE ?
    OR LOWER(o0_.detalle_reloj_codigo) LIKE ?
    OR LOWER(o0_.detalle_reloj_marca_nombre) LIKE ?
    OR LOWER(o0_.detalle_reloj_modelo1) LIKE ?
    OR LOWER(o0_.detalle_reloj_modelo2) LIKE ?
    OR LOWER(o0_.detalle_reloj_ref1) LIKE ?
    OR LOWER(o0_.detalle_reloj_ref2) LIKE ?
    OR LOWER(o0_.detalle_reloj_serie) LIKE ?
    OR LOWER(o0_.detalle_precio_coste) LIKE ?
    OR LOWER(o0_.detalle_precio_venta) LIKE ?
    OR LOWER(o0_.usuario_IDperseo) LIKE ?
    OR LOWER(o0_.user_username) LIKE ?
    OR LOWER(o0_.user_email) LIKE ?
    OR LOWER(o0_.user_nombre) LIKE ?
    OR LOWER(o0_.user_primer_apellido) LIKE ?
    OR LOWER(o0_.user_segundo_apellido) LIKE ?
  )
  AND (
    o0_.estado_key = ?
    OR o0_.estado_key = ?
    OR o0_.estado_key = ?
  )

SELECT count(o0_.id) AS sclr_0 FROM operacion_detalle o0_ WHERE o0_.id IS NOT NULL AND o0_.deleted_at IS NULL AND (LOWER(o0_.IDperseo) LIKE '%78357976%' OR LOWER(o0_.tipo) LIKE '%78357976%' OR LOWER(o0_.valoracion_IDperseo) LIKE '%78357976%' OR LOWER(o0_.estado_key) LIKE '%78357976%' OR LOWER(o0_.estado_nombre) LIKE '%78357976%' OR LOWER(o0_.cliente_razon_social) LIKE '%78357976%' OR LOWER(o0_.canal_nombre) LIKE '%78357976%' OR LOWER(o0_.fecha_tramitacion) LIKE '%78357976%' OR LOWER(o0_.fecha_tramitada) LIKE '%78357976%' OR LOWER(o0_.fecha_confirmada) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_IDperseo) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_codigo) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_marca_nombre) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_modelo1) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_modelo2) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_ref1) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_ref2) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_serie) LIKE '%78357976%' OR LOWER(o0_.detalle_precio_coste) LIKE '%78357976%' OR LOWER(o0_.detalle_precio_venta) LIKE '%78357976%' OR LOWER(o0_.usuario_IDperseo) LIKE '%78357976%' OR LOWER(o0_.user_username) LIKE '%78357976%' OR LOWER(o0_.user_email) LIKE '%78357976%' OR LOWER(o0_.user_nombre) LIKE '%78357976%' OR LOWER(o0_.user_primer_apellido) LIKE '%78357976%' OR LOWER(o0_.user_segundo_apellido) LIKE '%78357976%') AND (o0_.estado_key = 'EN_TRAMITACION' OR o0_.estado_key = 'TRAMITADA' OR o0_.estado_key = 'CONFIRMADA');

SELECT
  o0_.id AS id_0,
  o0_.operacion_id AS operacion_id_1,
  o0_.tipo AS tipo_2,
  o0_.IDperseo AS IDperseo_3,
  o0_.fecha AS fecha_4,
  o0_.valoracion_id AS valoracion_id_5,
  o0_.valoracion_IDperseo AS valoracion_IDperseo_6,
  o0_.estado_id AS estado_id_7,
  o0_.estado_key AS estado_key_8,
  o0_.estado_nombre AS estado_nombre_9,
  o0_.estado_fecha AS estado_fecha_10,
  o0_.cliente_id AS cliente_id_11,
  o0_.cliente_razon_social AS cliente_razon_social_12,
  o0_.canal_id AS canal_id_13,
  o0_.canal_nombre AS canal_nombre_14,
  o0_.usuario_id AS usuario_id_15,
  o0_.usuario_IDperseo AS usuario_IDperseo_16,
  o0_.user_id AS user_id_17,
  o0_.user_username AS user_username_18,
  o0_.user_email AS user_email_19,
  o0_.user_nombre AS user_nombre_20,
  o0_.user_primer_apellido AS user_primer_apellido_21,
  o0_.user_segundo_apellido AS user_segundo_apellido_22,
  o0_.fecha_tramitacion AS fecha_tramitacion_23,
  o0_.fecha_tramitada AS fecha_tramitada_24,
  o0_.fecha_confirmada AS fecha_confirmada_25,
  o0_.fecha_cancelada AS fecha_cancelada_26,
  o0_.fecha_asentada AS fecha_asentada_27,
  o0_.fecha_finalizada AS fecha_finalizada_28,
  o0_.detalle_id AS detalle_id_29,
  o0_.detalle_reloj_id AS detalle_reloj_id_30,
  o0_.detalle_reloj_IDperseo AS detalle_reloj_IDperseo_31,
  o0_.detalle_reloj_codigo AS detalle_reloj_codigo_32,
  o0_.detalle_reloj_marca_id AS detalle_reloj_marca_id_33,
  o0_.detalle_reloj_marca_nombre AS detalle_reloj_marca_nombre_34,
  o0_.detalle_reloj_modelo1 AS detalle_reloj_modelo1_35,
  o0_.detalle_reloj_modelo2 AS detalle_reloj_modelo2_36,
  o0_.detalle_reloj_ref1 AS detalle_reloj_ref1_37,
  o0_.detalle_reloj_ref2 AS detalle_reloj_ref2_38,
  o0_.detalle_reloj_serie AS detalle_reloj_serie_39,
  o0_.detalle_precio_coste AS detalle_precio_coste_40,
  o0_.detalle_precio_venta AS detalle_precio_venta_41,
  o0_.deleted_at AS deleted_at_42
FROM
  operacion_detalle o0_
WHERE
  o0_.id IS NOT NULL
  AND o0_.deleted_at IS NULL
  AND (
    LOWER(o0_.IDperseo) LIKE ?
    OR LOWER(o0_.tipo) LIKE ?
    OR LOWER(o0_.valoracion_IDperseo) LIKE ?
    OR LOWER(o0_.estado_key) LIKE ?
    OR LOWER(o0_.estado_nombre) LIKE ?
    OR LOWER(o0_.cliente_razon_social) LIKE ?
    OR LOWER(o0_.canal_nombre) LIKE ?
    OR LOWER(o0_.fecha_tramitacion) LIKE ?
    OR LOWER(o0_.fecha_tramitada) LIKE ?
    OR LOWER(o0_.fecha_confirmada) LIKE ?
    OR LOWER(o0_.detalle_reloj_IDperseo) LIKE ?
    OR LOWER(o0_.detalle_reloj_codigo) LIKE ?
    OR LOWER(o0_.detalle_reloj_marca_nombre) LIKE ?
    OR LOWER(o0_.detalle_reloj_modelo1) LIKE ?
    OR LOWER(o0_.detalle_reloj_modelo2) LIKE ?
    OR LOWER(o0_.detalle_reloj_ref1) LIKE ?
    OR LOWER(o0_.detalle_reloj_ref2) LIKE ?
    OR LOWER(o0_.detalle_reloj_serie) LIKE ?
    OR LOWER(o0_.detalle_precio_coste) LIKE ?
    OR LOWER(o0_.detalle_precio_venta) LIKE ?
    OR LOWER(o0_.usuario_IDperseo) LIKE ?
    OR LOWER(o0_.user_username) LIKE ?
    OR LOWER(o0_.user_email) LIKE ?
    OR LOWER(o0_.user_nombre) LIKE ?
    OR LOWER(o0_.user_primer_apellido) LIKE ?
    OR LOWER(o0_.user_segundo_apellido) LIKE ?
  )
  AND (
    o0_.estado_key = ?
    OR o0_.estado_key = ?
    OR o0_.estado_key = ?
  )
ORDER BY
  o0_.estado_fecha DESC,
  o0_.id ASC
LIMIT
  50

SELECT o0_.id AS id_0, o0_.operacion_id AS operacion_id_1, o0_.tipo AS tipo_2, o0_.IDperseo AS IDperseo_3, o0_.fecha AS fecha_4, o0_.valoracion_id AS valoracion_id_5, o0_.valoracion_IDperseo AS valoracion_IDperseo_6, o0_.estado_id AS estado_id_7, o0_.estado_key AS estado_key_8, o0_.estado_nombre AS estado_nombre_9, o0_.estado_fecha AS estado_fecha_10, o0_.cliente_id AS cliente_id_11, o0_.cliente_razon_social AS cliente_razon_social_12, o0_.canal_id AS canal_id_13, o0_.canal_nombre AS canal_nombre_14, o0_.usuario_id AS usuario_id_15, o0_.usuario_IDperseo AS usuario_IDperseo_16, o0_.user_id AS user_id_17, o0_.user_username AS user_username_18, o0_.user_email AS user_email_19, o0_.user_nombre AS user_nombre_20, o0_.user_primer_apellido AS user_primer_apellido_21, o0_.user_segundo_apellido AS user_segundo_apellido_22, o0_.fecha_tramitacion AS fecha_tramitacion_23, o0_.fecha_tramitada AS fecha_tramitada_24, o0_.fecha_confirmada AS fecha_confirmada_25, o0_.fecha_cancelada AS fecha_cancelada_26, o0_.fecha_asentada AS fecha_asentada_27, o0_.fecha_finalizada AS fecha_finalizada_28, o0_.detalle_id AS detalle_id_29, o0_.detalle_reloj_id AS detalle_reloj_id_30, o0_.detalle_reloj_IDperseo AS detalle_reloj_IDperseo_31, o0_.detalle_reloj_codigo AS detalle_reloj_codigo_32, o0_.detalle_reloj_marca_id AS detalle_reloj_marca_id_33, o0_.detalle_reloj_marca_nombre AS detalle_reloj_marca_nombre_34, o0_.detalle_reloj_modelo1 AS detalle_reloj_modelo1_35, o0_.detalle_reloj_modelo2 AS detalle_reloj_modelo2_36, o0_.detalle_reloj_ref1 AS detalle_reloj_ref1_37, o0_.detalle_reloj_ref2 AS detalle_reloj_ref2_38, o0_.detalle_reloj_serie AS detalle_reloj_serie_39, o0_.detalle_precio_coste AS detalle_precio_coste_40, o0_.detalle_precio_venta AS detalle_precio_venta_41, o0_.deleted_at AS deleted_at_42 FROM operacion_detalle o0_ WHERE o0_.id IS NOT NULL AND o0_.deleted_at IS NULL AND (LOWER(o0_.IDperseo) LIKE '%78357976%' OR LOWER(o0_.tipo) LIKE '%78357976%' OR LOWER(o0_.valoracion_IDperseo) LIKE '%78357976%' OR LOWER(o0_.estado_key) LIKE '%78357976%' OR LOWER(o0_.estado_nombre) LIKE '%78357976%' OR LOWER(o0_.cliente_razon_social) LIKE '%78357976%' OR LOWER(o0_.canal_nombre) LIKE '%78357976%' OR LOWER(o0_.fecha_tramitacion) LIKE '%78357976%' OR LOWER(o0_.fecha_tramitada) LIKE '%78357976%' OR LOWER(o0_.fecha_confirmada) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_IDperseo) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_codigo) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_marca_nombre) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_modelo1) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_modelo2) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_ref1) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_ref2) LIKE '%78357976%' OR LOWER(o0_.detalle_reloj_serie) LIKE '%78357976%' OR LOWER(o0_.detalle_precio_coste) LIKE '%78357976%' OR LOWER(o0_.detalle_precio_venta) LIKE '%78357976%' OR LOWER(o0_.usuario_IDperseo) LIKE '%78357976%' OR LOWER(o0_.user_username) LIKE '%78357976%' OR LOWER(o0_.user_email) LIKE '%78357976%' OR LOWER(o0_.user_nombre) LIKE '%78357976%' OR LOWER(o0_.user_primer_apellido) LIKE '%78357976%' OR LOWER(o0_.user_segundo_apellido) LIKE '%78357976%') AND (o0_.estado_key = 'EN_TRAMITACION' OR o0_.estado_key = 'TRAMITADA' OR o0_.estado_key = 'CONFIRMADA') ORDER BY o0_.estado_fecha DESC, o0_.id ASC LIMIT 50;