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_promocion_edit', 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=g004ir3h6g1c0km4rjonnsuam2\"],\"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\\/71\\/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\":[\"83.54.202.5\"],\"host\":[\"perseo.comerziawatches.com\"],\"x-php-ob-level\":[\"1\"]}', '[]', '[]', 'https://perseo.comerziawatches.com/es/admin/app/operacion/71/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', '83.54.202.5', NULL, '2026-04-18 12:05:53', '2026-04-18 12:05:53');

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.idperseo AS idperseo_2,
  t0.tipo AS tipo_3,
  t0.fecha_listo AS fecha_listo_4,
  t0.fecha_promocion AS fecha_promocion_5,
  t0.fecha_anuncio AS fecha_anuncio_6,
  t0.fecha_venta AS fecha_venta_7,
  t0.precio AS precio_8,
  t0.precio_chrono24 AS precio_chrono24_9,
  t0.margen_bruto_esperado AS margen_bruto_esperado_10,
  t0.margen_neto_esperado AS margen_neto_esperado_11,
  t0.tiempo AS tiempo_12,
  t0.comentario_publico AS comentario_publico_13,
  t0.comentario_privado AS comentario_privado_14,
  t0.descripcion AS descripcion_15,
  t0.ubicacion_actual AS ubicacion_actual_16,
  t0.fecha_ubicacion_actual AS fecha_ubicacion_actual_17,
  t0.estado_actual AS estado_actual_18,
  t0.fecha_estado_actual AS fecha_estado_actual_19,
  t0.costes AS costes_20,
  t0.reloj_foto AS reloj_foto_21,
  t0.reloj_foto_valoracion AS reloj_foto_valoracion_22,
  t0.reloj_foto_set AS reloj_foto_set_23,
  t0.reloj_foto_crono AS reloj_foto_crono_24,
  t0.reloj_video AS reloj_video_25,
  t0.recompra AS recompra_26,
  t0.garantia AS garantia_27,
  t0.active AS active_28,
  t0.deleted_at AS deleted_at_29,
  t0.updated_at AS updated_at_30,
  t0.created_at AS created_at_31,
  t0.reloj_id AS reloj_id_32
FROM
  promocion t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.idperseo AS idperseo_2, t0.tipo AS tipo_3, t0.fecha_listo AS fecha_listo_4, t0.fecha_promocion AS fecha_promocion_5, t0.fecha_anuncio AS fecha_anuncio_6, t0.fecha_venta AS fecha_venta_7, t0.precio AS precio_8, t0.precio_chrono24 AS precio_chrono24_9, t0.margen_bruto_esperado AS margen_bruto_esperado_10, t0.margen_neto_esperado AS margen_neto_esperado_11, t0.tiempo AS tiempo_12, t0.comentario_publico AS comentario_publico_13, t0.comentario_privado AS comentario_privado_14, t0.descripcion AS descripcion_15, t0.ubicacion_actual AS ubicacion_actual_16, t0.fecha_ubicacion_actual AS fecha_ubicacion_actual_17, t0.estado_actual AS estado_actual_18, t0.fecha_estado_actual AS fecha_estado_actual_19, t0.costes AS costes_20, t0.reloj_foto AS reloj_foto_21, t0.reloj_foto_valoracion AS reloj_foto_valoracion_22, t0.reloj_foto_set AS reloj_foto_set_23, t0.reloj_foto_crono AS reloj_foto_crono_24, t0.reloj_video AS reloj_video_25, t0.recompra AS recompra_26, t0.garantia AS garantia_27, t0.active AS active_28, t0.deleted_at AS deleted_at_29, t0.updated_at AS updated_at_30, t0.created_at AS created_at_31, t0.reloj_id AS reloj_id_32 FROM promocion t0 WHERE t0.id = '98' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.codigo AS codigo_2,
  t0.id_perseo AS id_perseo_3,
  t0.regimen AS regimen_4,
  t0.foto AS foto_5,
  t0.foto_valoracion AS foto_valoracion_6,
  t0.foto_set AS foto_set_7,
  t0.foto_crono AS foto_crono_8,
  t0.video AS video_9,
  t0.modelo1 AS modelo1_10,
  t0.modelo2 AS modelo2_11,
  t0.ref1 AS ref1_12,
  t0.ref2 AS ref2_13,
  t0.serie AS serie_14,
  t0.peso AS peso_15,
  t0.fecha AS fecha_16,
  t0.caja AS caja_17,
  t0.papeles AS papeles_18,
  t0.otros AS otros_19,
  t0.itp AS itp_20,
  t0.fecha_valoracion AS fecha_valoracion_21,
  t0.comision AS comision_22,
  t0.precio_coste AS precio_coste_23,
  t0.precio_coste_total AS precio_coste_total_24,
  t0.genero AS genero_25,
  t0.estado_caja AS estado_caja_26,
  t0.estado_cristal AS estado_cristal_27,
  t0.estado_dial AS estado_dial_28,
  t0.estado_agujas AS estado_agujas_29,
  t0.estado_tapa AS estado_tapa_30,
  t0.estado_correa AS estado_correa_31,
  t0.esfera_indice AS esfera_indice_32,
  t0.esfera_color AS esfera_color_33,
  t0.esfera_joyas AS esfera_joyas_34,
  t0.caja_reloj_diametro AS caja_reloj_diametro_35,
  t0.caja_reloj_grosor AS caja_reloj_grosor_36,
  t0.caja_reloj_resistencia_agua AS caja_reloj_resistencia_agua_37,
  t0.caja_reloj_cristal AS caja_reloj_cristal_38,
  t0.pulsera_color AS pulsera_color_39,
  t0.pulsera_cierre AS pulsera_cierre_40,
  t0.pulsera_ancho_caja AS pulsera_ancho_caja_41,
  t0.pulsera_ancho_cierre AS pulsera_ancho_cierre_42,
  t0.pulsera_medida_munieca AS pulsera_medida_munieca_43,
  t0.calibre AS calibre_44,
  t0.calibre_avanzado AS calibre_avanzado_45,
  t0.calibre_basico AS calibre_basico_46,
  t0.calibre_reserva_marcha AS calibre_reserva_marcha_47,
  t0.calibre_numero_joyas AS calibre_numero_joyas_48,
  t0.calibre_oscilacion AS calibre_oscilacion_49,
  t0.calibre_amplitud AS calibre_amplitud_50,
  t0.calibre_marcha AS calibre_marcha_51,
  t0.piezas_repuesto AS piezas_repuesto_52,
  t0.piezas_repuesto_observaciones AS piezas_repuesto_observaciones_53,
  t0.servicio_mantenimiento AS servicio_mantenimiento_54,
  t0.calibre_caracteristicas AS calibre_caracteristicas_55,
  t0.calibre_funciones AS calibre_funciones_56,
  t0.precio_min_venta AS precio_min_venta_57,
  t0.precio_promocion AS precio_promocion_58,
  t0.fecha_promocion AS fecha_promocion_59,
  t0.precio_oferta AS precio_oferta_60,
  t0.chrono24 AS chrono24_61,
  t0.precio_pagar AS precio_pagar_62,
  t0.compra_directa AS compra_directa_63,
  t0.precio_compra AS precio_compra_64,
  t0.fecha_compra AS fecha_compra_65,
  t0.precio_venta AS precio_venta_66,
  t0.fecha_venta AS fecha_venta_67,
  t0.precio_venta_total AS precio_venta_total_68,
  t0.margen_minimo AS margen_minimo_69,
  t0.margen_deseado AS margen_deseado_70,
  t0.recompra AS recompra_71,
  t0.garantia AS garantia_72,
  t0.descripcion AS descripcion_73,
  t0.descripcion_detallada AS descripcion_detallada_74,
  t0.condiciones AS condiciones_75,
  t0.anuncio_es AS anuncio_es_76,
  t0.anuncio_en AS anuncio_en_77,
  t0.tiempo_en_venta AS tiempo_en_venta_78,
  t0.tiempo_en_stock AS tiempo_en_stock_79,
  t0.fecha_recepcion AS fecha_recepcion_80,
  t0.margen_promocion AS margen_promocion_81,
  t0.margen_bruto AS margen_bruto_82,
  t0.margen_neto AS margen_neto_83,
  t0.stock AS stock_84,
  t0.custodia AS custodia_85,
  t0.tiempo_venta AS tiempo_venta_86,
  t0.fecha_anuncio AS fecha_anuncio_87,
  t0.comentario AS comentario_88,
  t0.token_access AS token_access_89,
  t0.en_promocion AS en_promocion_90,
  t0.en_servicio AS en_servicio_91,
  t0.sin_anunciar AS sin_anunciar_92,
  t0.en_venta AS en_venta_93,
  t0.tipo_bloqueo AS tipo_bloqueo_94,
  t0.exportacion AS exportacion_95,
  t0.deleted_at AS deleted_at_96,
  t0.updated_at AS updated_at_97,
  t0.created_at AS created_at_98,
  t99.id AS id_100,
  t99.id_perseo AS id_perseo_101,
  t99.id_registro_policial AS id_registro_policial_102,
  t99.fecha_comunicacion AS fecha_comunicacion_103,
  t99.deleted_at AS deleted_at_104,
  t99.updated_at AS updated_at_105,
  t99.created_at AS created_at_106,
  t99.reloj_id AS reloj_id_107,
  t108.id AS id_109,
  t108.idperseo AS idperseo_110,
  t108.tipo AS tipo_111,
  t108.fecha_listo AS fecha_listo_112,
  t108.fecha_promocion AS fecha_promocion_113,
  t108.fecha_anuncio AS fecha_anuncio_114,
  t108.fecha_venta AS fecha_venta_115,
  t108.precio AS precio_116,
  t108.precio_chrono24 AS precio_chrono24_117,
  t108.margen_bruto_esperado AS margen_bruto_esperado_118,
  t108.margen_neto_esperado AS margen_neto_esperado_119,
  t108.tiempo AS tiempo_120,
  t108.comentario_publico AS comentario_publico_121,
  t108.comentario_privado AS comentario_privado_122,
  t108.descripcion AS descripcion_123,
  t108.ubicacion_actual AS ubicacion_actual_124,
  t108.fecha_ubicacion_actual AS fecha_ubicacion_actual_125,
  t108.estado_actual AS estado_actual_126,
  t108.fecha_estado_actual AS fecha_estado_actual_127,
  t108.costes AS costes_128,
  t108.reloj_foto AS reloj_foto_129,
  t108.reloj_foto_valoracion AS reloj_foto_valoracion_130,
  t108.reloj_foto_set AS reloj_foto_set_131,
  t108.reloj_foto_crono AS reloj_foto_crono_132,
  t108.reloj_video AS reloj_video_133,
  t108.recompra AS recompra_134,
  t108.garantia AS garantia_135,
  t108.active AS active_136,
  t108.deleted_at AS deleted_at_137,
  t108.updated_at AS updated_at_138,
  t108.created_at AS created_at_139,
  t108.reloj_id AS reloj_id_140,
  t0.estado_reloj_id AS estado_reloj_id_141,
  t0.marca_id AS marca_id_142,
  t0.estado_aspecto_id AS estado_aspecto_id_143,
  t0.estado_check_id AS estado_check_id_144,
  t0.operacion_gestion_id AS operacion_gestion_id_145,
  t0.operacion_venta_id AS operacion_venta_id_146,
  t0.operacion_compra_id AS operacion_compra_id_147,
  t0.valoracion_id AS valoracion_id_148,
  t0.empresa_id AS empresa_id_149,
  t0.caja_reloj_material_id AS caja_reloj_material_id_150,
  t0.caja_reloj_bisel_material_id AS caja_reloj_bisel_material_id_151,
  t0.pulsera_material_id AS pulsera_material_id_152,
  t0.pulsera_material_cierre_id AS pulsera_material_cierre_id_153,
  t0.reloj_base_id AS reloj_base_id_154
FROM
  reloj t0
  LEFT JOIN registro_policial t99 ON t99.reloj_id = t0.id
  AND (
    (t99.deleted_at IS NULL)
  )
  LEFT JOIN promocion t108 ON t108.reloj_id = t0.id
  AND (
    (t108.deleted_at IS NULL)
  )
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.id_perseo AS id_perseo_3, t0.regimen AS regimen_4, t0.foto AS foto_5, t0.foto_valoracion AS foto_valoracion_6, t0.foto_set AS foto_set_7, t0.foto_crono AS foto_crono_8, t0.video AS video_9, t0.modelo1 AS modelo1_10, t0.modelo2 AS modelo2_11, t0.ref1 AS ref1_12, t0.ref2 AS ref2_13, t0.serie AS serie_14, t0.peso AS peso_15, t0.fecha AS fecha_16, t0.caja AS caja_17, t0.papeles AS papeles_18, t0.otros AS otros_19, t0.itp AS itp_20, t0.fecha_valoracion AS fecha_valoracion_21, t0.comision AS comision_22, t0.precio_coste AS precio_coste_23, t0.precio_coste_total AS precio_coste_total_24, t0.genero AS genero_25, t0.estado_caja AS estado_caja_26, t0.estado_cristal AS estado_cristal_27, t0.estado_dial AS estado_dial_28, t0.estado_agujas AS estado_agujas_29, t0.estado_tapa AS estado_tapa_30, t0.estado_correa AS estado_correa_31, t0.esfera_indice AS esfera_indice_32, t0.esfera_color AS esfera_color_33, t0.esfera_joyas AS esfera_joyas_34, t0.caja_reloj_diametro AS caja_reloj_diametro_35, t0.caja_reloj_grosor AS caja_reloj_grosor_36, t0.caja_reloj_resistencia_agua AS caja_reloj_resistencia_agua_37, t0.caja_reloj_cristal AS caja_reloj_cristal_38, t0.pulsera_color AS pulsera_color_39, t0.pulsera_cierre AS pulsera_cierre_40, t0.pulsera_ancho_caja AS pulsera_ancho_caja_41, t0.pulsera_ancho_cierre AS pulsera_ancho_cierre_42, t0.pulsera_medida_munieca AS pulsera_medida_munieca_43, t0.calibre AS calibre_44, t0.calibre_avanzado AS calibre_avanzado_45, t0.calibre_basico AS calibre_basico_46, t0.calibre_reserva_marcha AS calibre_reserva_marcha_47, t0.calibre_numero_joyas AS calibre_numero_joyas_48, t0.calibre_oscilacion AS calibre_oscilacion_49, t0.calibre_amplitud AS calibre_amplitud_50, t0.calibre_marcha AS calibre_marcha_51, t0.piezas_repuesto AS piezas_repuesto_52, t0.piezas_repuesto_observaciones AS piezas_repuesto_observaciones_53, t0.servicio_mantenimiento AS servicio_mantenimiento_54, t0.calibre_caracteristicas AS calibre_caracteristicas_55, t0.calibre_funciones AS calibre_funciones_56, t0.precio_min_venta AS precio_min_venta_57, t0.precio_promocion AS precio_promocion_58, t0.fecha_promocion AS fecha_promocion_59, t0.precio_oferta AS precio_oferta_60, t0.chrono24 AS chrono24_61, t0.precio_pagar AS precio_pagar_62, t0.compra_directa AS compra_directa_63, t0.precio_compra AS precio_compra_64, t0.fecha_compra AS fecha_compra_65, t0.precio_venta AS precio_venta_66, t0.fecha_venta AS fecha_venta_67, t0.precio_venta_total AS precio_venta_total_68, t0.margen_minimo AS margen_minimo_69, t0.margen_deseado AS margen_deseado_70, t0.recompra AS recompra_71, t0.garantia AS garantia_72, t0.descripcion AS descripcion_73, t0.descripcion_detallada AS descripcion_detallada_74, t0.condiciones AS condiciones_75, t0.anuncio_es AS anuncio_es_76, t0.anuncio_en AS anuncio_en_77, t0.tiempo_en_venta AS tiempo_en_venta_78, t0.tiempo_en_stock AS tiempo_en_stock_79, t0.fecha_recepcion AS fecha_recepcion_80, t0.margen_promocion AS margen_promocion_81, t0.margen_bruto AS margen_bruto_82, t0.margen_neto AS margen_neto_83, t0.stock AS stock_84, t0.custodia AS custodia_85, t0.tiempo_venta AS tiempo_venta_86, t0.fecha_anuncio AS fecha_anuncio_87, t0.comentario AS comentario_88, t0.token_access AS token_access_89, t0.en_promocion AS en_promocion_90, t0.en_servicio AS en_servicio_91, t0.sin_anunciar AS sin_anunciar_92, t0.en_venta AS en_venta_93, t0.tipo_bloqueo AS tipo_bloqueo_94, t0.exportacion AS exportacion_95, t0.deleted_at AS deleted_at_96, t0.updated_at AS updated_at_97, t0.created_at AS created_at_98, t99.id AS id_100, t99.id_perseo AS id_perseo_101, t99.id_registro_policial AS id_registro_policial_102, t99.fecha_comunicacion AS fecha_comunicacion_103, t99.deleted_at AS deleted_at_104, t99.updated_at AS updated_at_105, t99.created_at AS created_at_106, t99.reloj_id AS reloj_id_107, t108.id AS id_109, t108.idperseo AS idperseo_110, t108.tipo AS tipo_111, t108.fecha_listo AS fecha_listo_112, t108.fecha_promocion AS fecha_promocion_113, t108.fecha_anuncio AS fecha_anuncio_114, t108.fecha_venta AS fecha_venta_115, t108.precio AS precio_116, t108.precio_chrono24 AS precio_chrono24_117, t108.margen_bruto_esperado AS margen_bruto_esperado_118, t108.margen_neto_esperado AS margen_neto_esperado_119, t108.tiempo AS tiempo_120, t108.comentario_publico AS comentario_publico_121, t108.comentario_privado AS comentario_privado_122, t108.descripcion AS descripcion_123, t108.ubicacion_actual AS ubicacion_actual_124, t108.fecha_ubicacion_actual AS fecha_ubicacion_actual_125, t108.estado_actual AS estado_actual_126, t108.fecha_estado_actual AS fecha_estado_actual_127, t108.costes AS costes_128, t108.reloj_foto AS reloj_foto_129, t108.reloj_foto_valoracion AS reloj_foto_valoracion_130, t108.reloj_foto_set AS reloj_foto_set_131, t108.reloj_foto_crono AS reloj_foto_crono_132, t108.reloj_video AS reloj_video_133, t108.recompra AS recompra_134, t108.garantia AS garantia_135, t108.active AS active_136, t108.deleted_at AS deleted_at_137, t108.updated_at AS updated_at_138, t108.created_at AS created_at_139, t108.reloj_id AS reloj_id_140, t0.estado_reloj_id AS estado_reloj_id_141, t0.marca_id AS marca_id_142, t0.estado_aspecto_id AS estado_aspecto_id_143, t0.estado_check_id AS estado_check_id_144, t0.operacion_gestion_id AS operacion_gestion_id_145, t0.operacion_venta_id AS operacion_venta_id_146, t0.operacion_compra_id AS operacion_compra_id_147, t0.valoracion_id AS valoracion_id_148, t0.empresa_id AS empresa_id_149, t0.caja_reloj_material_id AS caja_reloj_material_id_150, t0.caja_reloj_bisel_material_id AS caja_reloj_bisel_material_id_151, t0.pulsera_material_id AS pulsera_material_id_152, t0.pulsera_material_cierre_id AS pulsera_material_cierre_id_153, t0.reloj_base_id AS reloj_base_id_154 FROM reloj t0 LEFT JOIN registro_policial t99 ON t99.reloj_id = t0.id AND ((t99.deleted_at IS NULL)) LEFT JOIN promocion t108 ON t108.reloj_id = t0.id AND ((t108.deleted_at IS NULL)) WHERE t0.id = '102' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.id_perseo AS id_perseo_2,
  t0.info_valoracion_compra AS info_valoracion_compra_3,
  t0.is_precio_chrono24 AS is_precio_chrono24_4,
  t0.deleted_at AS deleted_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_at AS created_at_7,
  t0.reloj_idperseo AS reloj_idperseo_8,
  t0.reloj_foto AS reloj_foto_9,
  t0.reloj_modelo1 AS reloj_modelo1_10,
  t0.reloj_ref1 AS reloj_ref1_11,
  t0.reloj_fecha AS reloj_fecha_12,
  t0.reloj_caja AS reloj_caja_13,
  t0.reloj_papeles AS reloj_papeles_14,
  t0.itp AS itp_15,
  t0.comision AS comision_16,
  t0.precio_coste AS precio_coste_17,
  t0.precio_coste_total AS precio_coste_total_18,
  t0.precio_min_venta AS precio_min_venta_19,
  t0.precio_promocion AS precio_promocion_20,
  t0.precio_oferta AS precio_oferta_21,
  t0.precio_referencia AS precio_referencia_22,
  t0.precio_pagar AS precio_pagar_23,
  t0.margen_minimo AS margen_minimo_24,
  t0.margen_deseado AS margen_deseado_25,
  t0.margen_promocion AS margen_promocion_26,
  t0.costes_total AS costes_total_27,
  t0.valoracion_id AS valoracion_id_28,
  t0.reloj_id AS reloj_id_29,
  t0.clone_id AS clone_id_30,
  t0.reloj_inventario_id AS reloj_inventario_id_31,
  t0.reloj_marca_id AS reloj_marca_id_32,
  t0.reloj_aspecto_id AS reloj_aspecto_id_33,
  t0.reloj_base_id AS reloj_base_id_34,
  t0.type
FROM
  valoraciones_relojes t0
WHERE
  t0.reloj_inventario_id = ?
  AND t0.type IN ('sinstock')
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.reloj_idperseo AS reloj_idperseo_8, t0.reloj_foto AS reloj_foto_9, t0.reloj_modelo1 AS reloj_modelo1_10, t0.reloj_ref1 AS reloj_ref1_11, t0.reloj_fecha AS reloj_fecha_12, t0.reloj_caja AS reloj_caja_13, t0.reloj_papeles AS reloj_papeles_14, t0.itp AS itp_15, t0.comision AS comision_16, t0.precio_coste AS precio_coste_17, t0.precio_coste_total AS precio_coste_total_18, t0.precio_min_venta AS precio_min_venta_19, t0.precio_promocion AS precio_promocion_20, t0.precio_oferta AS precio_oferta_21, t0.precio_referencia AS precio_referencia_22, t0.precio_pagar AS precio_pagar_23, t0.margen_minimo AS margen_minimo_24, t0.margen_deseado AS margen_deseado_25, t0.margen_promocion AS margen_promocion_26, t0.costes_total AS costes_total_27, t0.valoracion_id AS valoracion_id_28, t0.reloj_id AS reloj_id_29, t0.clone_id AS clone_id_30, t0.reloj_inventario_id AS reloj_inventario_id_31, t0.reloj_marca_id AS reloj_marca_id_32, t0.reloj_aspecto_id AS reloj_aspecto_id_33, t0.reloj_base_id AS reloj_base_id_34, t0.type FROM valoraciones_relojes t0 WHERE t0.reloj_inventario_id = '102' AND t0.type IN ('sinstock') 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 = '2098' AND t0.type IN ('compra') AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.tipo AS tipo_2,
  t0.idioma AS idioma_3,
  t0.idperseo AS idperseo_4,
  t0.fecha AS fecha_5,
  t0.exportacion AS exportacion_6,
  t0.regimen AS regimen_7,
  t0.tipo_cliente AS tipo_cliente_8,
  t0.cliente_idioma AS cliente_idioma_9,
  t0.cliente_razon_social AS cliente_razon_social_10,
  t0.cliente_identificacion_tipo AS cliente_identificacion_tipo_11,
  t0.cliente_identificacion AS cliente_identificacion_12,
  t0.cliente_direccion AS cliente_direccion_13,
  t0.cliente_cp AS cliente_cp_14,
  t0.cliente_region AS cliente_region_15,
  t0.cliente_ciudad AS cliente_ciudad_16,
  t0.cliente_provincia AS cliente_provincia_17,
  t0.cliente_ccaa AS cliente_ccaa_18,
  t0.cliente_pais AS cliente_pais_19,
  t0.cliente_identificacion_frontal AS cliente_identificacion_frontal_20,
  t0.cliente_identificacion_trasera AS cliente_identificacion_trasera_21,
  t0.cliente_entidad_bancaria AS cliente_entidad_bancaria_22,
  t0.cliente_swift AS cliente_swift_23,
  t0.cliente_iban AS cliente_iban_24,
  t0.cliente_telefono AS cliente_telefono_25,
  t0.cliente_email AS cliente_email_26,
  t0.cliente_observaciones AS cliente_observaciones_27,
  t0.reloj_foto AS reloj_foto_28,
  t0.reloj_marca AS reloj_marca_29,
  t0.reloj_modelo AS reloj_modelo_30,
  t0.reloj_modelo2 AS reloj_modelo2_31,
  t0.reloj_ref AS reloj_ref_32,
  t0.reloj_ref2 AS reloj_ref2_33,
  t0.reloj_serie AS reloj_serie_34,
  t0.reloj_fecha AS reloj_fecha_35,
  t0.reloj_caja AS reloj_caja_36,
  t0.reloj_papeles AS reloj_papeles_37,
  t0.fecha_pendiente AS fecha_pendiente_38,
  t0.fecha_asentada AS fecha_asentada_39,
  t0.fecha_confirmada AS fecha_confirmada_40,
  t0.fecha_facturada AS fecha_facturada_41,
  t0.fecha_cancelada AS fecha_cancelada_42,
  t0.fecha_anulada AS fecha_anulada_43,
  t0.fecha_abonada AS fecha_abonada_44,
  t0.fecha_factura AS fecha_factura_45,
  t0.numero_factura AS numero_factura_46,
  t0.precio_coste_total AS precio_coste_total_47,
  t0.deleted_at AS deleted_at_48,
  t0.updated_at AS updated_at_49,
  t0.created_at AS created_at_50,
  t0.fecha_compra AS fecha_compra_51,
  t0.precio_coste AS precio_coste_52,
  t0.precio_costes_compra AS precio_costes_compra_53,
  t0.detalle_operacion_id AS detalle_operacion_id_54,
  t0.cliente_id AS cliente_id_55,
  t0.reloj_marca_id AS reloj_marca_id_56,
  t0.reloj_estado_id AS reloj_estado_id_57,
  t0.unidad_negocio_id AS unidad_negocio_id_58,
  t0.usuario_id AS usuario_id_59,
  t0.canal_id AS canal_id_60,
  t0.estado_id AS estado_id_61,
  t0.type,
  t0.reloj_compra_id AS reloj_compra_id_62,
  t0.fecha_venta AS fecha_venta_63,
  t0.precio_costes_venta AS precio_costes_venta_64,
  t0.precio_venta AS precio_venta_65,
  t0.margen_bruto AS margen_bruto_66,
  t0.beneficio_bruto AS beneficio_bruto_67,
  t0.base_imponible AS base_imponible_68,
  t0.iva AS iva_69,
  t0.tipo_iva AS tipo_iva_70,
  t0.forma_pago AS forma_pago_71,
  t0.reloj_venta_id AS reloj_venta_id_72
FROM
  actividad t0
WHERE
  t0.detalle_operacion_id = ?
  AND t0.type IN ('compra', 'venta')
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.idioma AS idioma_3, t0.idperseo AS idperseo_4, t0.fecha AS fecha_5, t0.exportacion AS exportacion_6, t0.regimen AS regimen_7, t0.tipo_cliente AS tipo_cliente_8, t0.cliente_idioma AS cliente_idioma_9, t0.cliente_razon_social AS cliente_razon_social_10, t0.cliente_identificacion_tipo AS cliente_identificacion_tipo_11, t0.cliente_identificacion AS cliente_identificacion_12, t0.cliente_direccion AS cliente_direccion_13, t0.cliente_cp AS cliente_cp_14, t0.cliente_region AS cliente_region_15, t0.cliente_ciudad AS cliente_ciudad_16, t0.cliente_provincia AS cliente_provincia_17, t0.cliente_ccaa AS cliente_ccaa_18, t0.cliente_pais AS cliente_pais_19, t0.cliente_identificacion_frontal AS cliente_identificacion_frontal_20, t0.cliente_identificacion_trasera AS cliente_identificacion_trasera_21, t0.cliente_entidad_bancaria AS cliente_entidad_bancaria_22, t0.cliente_swift AS cliente_swift_23, t0.cliente_iban AS cliente_iban_24, t0.cliente_telefono AS cliente_telefono_25, t0.cliente_email AS cliente_email_26, t0.cliente_observaciones AS cliente_observaciones_27, t0.reloj_foto AS reloj_foto_28, t0.reloj_marca AS reloj_marca_29, t0.reloj_modelo AS reloj_modelo_30, t0.reloj_modelo2 AS reloj_modelo2_31, t0.reloj_ref AS reloj_ref_32, t0.reloj_ref2 AS reloj_ref2_33, t0.reloj_serie AS reloj_serie_34, t0.reloj_fecha AS reloj_fecha_35, t0.reloj_caja AS reloj_caja_36, t0.reloj_papeles AS reloj_papeles_37, t0.fecha_pendiente AS fecha_pendiente_38, t0.fecha_asentada AS fecha_asentada_39, t0.fecha_confirmada AS fecha_confirmada_40, t0.fecha_facturada AS fecha_facturada_41, t0.fecha_cancelada AS fecha_cancelada_42, t0.fecha_anulada AS fecha_anulada_43, t0.fecha_abonada AS fecha_abonada_44, t0.fecha_factura AS fecha_factura_45, t0.numero_factura AS numero_factura_46, t0.precio_coste_total AS precio_coste_total_47, t0.deleted_at AS deleted_at_48, t0.updated_at AS updated_at_49, t0.created_at AS created_at_50, t0.fecha_compra AS fecha_compra_51, t0.precio_coste AS precio_coste_52, t0.precio_costes_compra AS precio_costes_compra_53, t0.detalle_operacion_id AS detalle_operacion_id_54, t0.cliente_id AS cliente_id_55, t0.reloj_marca_id AS reloj_marca_id_56, t0.reloj_estado_id AS reloj_estado_id_57, t0.unidad_negocio_id AS unidad_negocio_id_58, t0.usuario_id AS usuario_id_59, t0.canal_id AS canal_id_60, t0.estado_id AS estado_id_61, t0.type, t0.reloj_compra_id AS reloj_compra_id_62, t0.fecha_venta AS fecha_venta_63, t0.precio_costes_venta AS precio_costes_venta_64, t0.precio_venta AS precio_venta_65, t0.margen_bruto AS margen_bruto_66, t0.beneficio_bruto AS beneficio_bruto_67, t0.base_imponible AS base_imponible_68, t0.iva AS iva_69, t0.tipo_iva AS tipo_iva_70, t0.forma_pago AS forma_pago_71, t0.reloj_venta_id AS reloj_venta_id_72 FROM actividad t0 WHERE t0.detalle_operacion_id = '131' AND t0.type IN ('compra', 'venta') AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.tipo AS tipo_2,
  t0.idioma AS idioma_3,
  t0.idperseo AS idperseo_4,
  t0.fecha AS fecha_5,
  t0.exportacion AS exportacion_6,
  t0.regimen AS regimen_7,
  t0.tipo_cliente AS tipo_cliente_8,
  t0.cliente_idioma AS cliente_idioma_9,
  t0.cliente_razon_social AS cliente_razon_social_10,
  t0.cliente_identificacion_tipo AS cliente_identificacion_tipo_11,
  t0.cliente_identificacion AS cliente_identificacion_12,
  t0.cliente_direccion AS cliente_direccion_13,
  t0.cliente_cp AS cliente_cp_14,
  t0.cliente_region AS cliente_region_15,
  t0.cliente_ciudad AS cliente_ciudad_16,
  t0.cliente_provincia AS cliente_provincia_17,
  t0.cliente_ccaa AS cliente_ccaa_18,
  t0.cliente_pais AS cliente_pais_19,
  t0.cliente_identificacion_frontal AS cliente_identificacion_frontal_20,
  t0.cliente_identificacion_trasera AS cliente_identificacion_trasera_21,
  t0.cliente_entidad_bancaria AS cliente_entidad_bancaria_22,
  t0.cliente_swift AS cliente_swift_23,
  t0.cliente_iban AS cliente_iban_24,
  t0.cliente_telefono AS cliente_telefono_25,
  t0.cliente_email AS cliente_email_26,
  t0.cliente_observaciones AS cliente_observaciones_27,
  t0.reloj_foto AS reloj_foto_28,
  t0.reloj_marca AS reloj_marca_29,
  t0.reloj_modelo AS reloj_modelo_30,
  t0.reloj_modelo2 AS reloj_modelo2_31,
  t0.reloj_ref AS reloj_ref_32,
  t0.reloj_ref2 AS reloj_ref2_33,
  t0.reloj_serie AS reloj_serie_34,
  t0.reloj_fecha AS reloj_fecha_35,
  t0.reloj_caja AS reloj_caja_36,
  t0.reloj_papeles AS reloj_papeles_37,
  t0.fecha_pendiente AS fecha_pendiente_38,
  t0.fecha_asentada AS fecha_asentada_39,
  t0.fecha_confirmada AS fecha_confirmada_40,
  t0.fecha_facturada AS fecha_facturada_41,
  t0.fecha_cancelada AS fecha_cancelada_42,
  t0.fecha_anulada AS fecha_anulada_43,
  t0.fecha_abonada AS fecha_abonada_44,
  t0.fecha_factura AS fecha_factura_45,
  t0.numero_factura AS numero_factura_46,
  t0.precio_coste_total AS precio_coste_total_47,
  t0.deleted_at AS deleted_at_48,
  t0.updated_at AS updated_at_49,
  t0.created_at AS created_at_50,
  t0.fecha_compra AS fecha_compra_51,
  t0.precio_coste AS precio_coste_52,
  t0.precio_costes_compra AS precio_costes_compra_53,
  t0.detalle_operacion_id AS detalle_operacion_id_54,
  t0.cliente_id AS cliente_id_55,
  t0.reloj_marca_id AS reloj_marca_id_56,
  t0.reloj_estado_id AS reloj_estado_id_57,
  t0.unidad_negocio_id AS unidad_negocio_id_58,
  t0.usuario_id AS usuario_id_59,
  t0.canal_id AS canal_id_60,
  t0.estado_id AS estado_id_61,
  t0.reloj_compra_id AS reloj_compra_id_62,
  t0.type
FROM
  actividad t0
WHERE
  t0.reloj_compra_id = ?
  AND t0.type IN ('compra')
  AND (
    (t0.deleted_at IS NULL)
  )