Query Metrics
45
Database Queries
32
Different statements
26.73 ms
Query time
11
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.09 ms |
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))
Parameters:
[
"3"
]
|
| 2 | 0.31 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 0.95 ms |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "ivan" "["ROLE_ADMIN","ROLE_USER"]" "admin_app_promocion_edit" null "GET" "{"cookie":["PHPSESSID=ieejnr0ofej5lvvrdmu8qtten8; _ga_9WW1MLN4N6=GS2.1.s1786438093$o205$g1$t1786438095$j58$l0$h0; _ga_QMD3ZTG7ZP=GS2.1.s1786438093$o205$g1$t1786438095$j58$l0$h0; _ga=GA1.1.417558243.1759838203; sbjs_udata=vst%3D168%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.5%20Safari%2F605.1.15; sbjs_current_add=fd%3D2026-08-07%2019%3A31%3A53%7C%7C%7Cep%3Dhttps%3A%2F%2Fwww.comerziawatches.com%2Fen%2Fwho-we-are%2Fwhat-our-clients-think-2%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_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"],"priority":["u=0, i"],"accept-language":["es-ES,es;q=0.9"],"sec-fetch-mode":["navigate"],"sec-fetch-site":["same-origin"],"referer":["https:\/\/perseo.comerziawatches.com\/es\/admin\/app\/promocion\/list?filter%5Bbusqueda%5D%5Btype%5D=&filter%5Bbusqueda%5D%5Bvalue%5D=&filter%5BrelojTipo%5D%5Btype%5D=&filter%5BrelojEstado%5D%5Btype%5D=&filter%5BrelojEstado%5D%5Bvalue%5D%5B%5D=SIN_ANUNCIAR&filter%5BrelojServicio%5D%5Btype%5D=&filter%5BrelojEstado%5D%5Bvalue%5D%5B%5D=SIN_ANUNCIAR&filter%5B_page%5D=1"],"accept":["text\/html,application\/xhtml+xml,application\/xml;q=0.9,*\/*;q=0.8"],"user-agent":["Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/605.1.15 (KHTML, like Gecko) Version\/26.5 Safari\/605.1.15"],"sec-fetch-dest":["document"],"x-accel-internal":["\/internal-nginx-static-location"],"x-real-ip":["47.62.200.72"],"host":["perseo.comerziawatches.com"],"x-php-ob-level":["1"]}" "[]" "[]" "https://perseo.comerziawatches.com/es/admin/app/promocion/list?filter%5Bbusqueda%5D%5Btype%5D=&filter%5Bbusqueda%5D%5Bvalue%5D=&filter%5BrelojTipo%5D%5Btype%5D=&filter%5BrelojEstado%5D%5Btype%5D=&filter%5BrelojEstado%5D%5Bvalue%5D%5B%5D=SIN_ANUNCIAR&filter%5BrelojServicio%5D%5Btype%5D=&filter%5BrelojEstado%5D%5Bvalue%5D%5B%5D=SIN_ANUNCIAR&filter%5B_page%5D=1" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.5 Safari/605.1.15" "perseo.comerziawatches.com" "82.223.107.15" "47.62.200.72" null "2026-08-12 12:50:59" "2026-08-12 12:50:59" ] |
| 4 | 0.70 ms |
"COMMIT"
Parameters:
[] |
| 5 | 0.83 ms |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.login_at AS login_at_3, u0_.logout_at AS logout_at_4, u0_.last_activity_at AS last_activity_at_5, u0_.duration AS duration_6, u0_.ip_address AS ip_address_7, u0_.user_agent AS user_agent_8, u0_.logout_type AS logout_type_9, u0_.session_id AS session_id_10, u0_.deleted_at AS deleted_at_11, u0_.updated_at AS updated_at_12, u0_.created_at AS created_at_13, u0_.user_id AS user_id_14 FROM user_session_log u0_ WHERE u0_.session_id = ? AND u0_.logout_at IS NULL
Parameters:
[
"ieejnr0ofej5lvvrdmu8qtten8"
]
|
| 6 | 0.24 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 0.46 ms |
UPDATE user_session_log SET last_activity_at = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-08-12 12:50:59" "2026-08-12 12:50:59" "1237" ] |
| 8 | 0.67 ms |
"COMMIT"
Parameters:
[] |
| 9 | 0.65 ms |
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))
Parameters:
[
"686"
]
|
| 10 | 1.52 ms |
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.fecha_baja AS fecha_baja_69, t0.margen_minimo AS margen_minimo_70, t0.margen_deseado AS margen_deseado_71, t0.recompra AS recompra_72, t0.garantia AS garantia_73, t0.descripcion AS descripcion_74, t0.descripcion_detallada AS descripcion_detallada_75, t0.condiciones AS condiciones_76, t0.anuncio_es AS anuncio_es_77, t0.anuncio_en AS anuncio_en_78, t0.tiempo_en_venta AS tiempo_en_venta_79, t0.tiempo_en_stock AS tiempo_en_stock_80, t0.fecha_recepcion AS fecha_recepcion_81, t0.margen_promocion AS margen_promocion_82, t0.margen_bruto AS margen_bruto_83, t0.margen_neto AS margen_neto_84, t0.stock AS stock_85, t0.custodia AS custodia_86, t0.tiempo_venta AS tiempo_venta_87, t0.fecha_anuncio AS fecha_anuncio_88, t0.comentario AS comentario_89, t0.token_access AS token_access_90, t0.en_promocion AS en_promocion_91, t0.en_servicio AS en_servicio_92, t0.sin_anunciar AS sin_anunciar_93, t0.en_venta AS en_venta_94, t0.tipo_bloqueo AS tipo_bloqueo_95, t0.exportacion AS exportacion_96, t0.deleted_at AS deleted_at_97, t0.updated_at AS updated_at_98, t0.created_at AS created_at_99, t100.id AS id_101, t100.id_perseo AS id_perseo_102, t100.id_registro_policial AS id_registro_policial_103, t100.fecha_comunicacion AS fecha_comunicacion_104, t100.deleted_at AS deleted_at_105, t100.updated_at AS updated_at_106, t100.created_at AS created_at_107, t100.reloj_id AS reloj_id_108, t109.id AS id_110, t109.idperseo AS idperseo_111, t109.tipo AS tipo_112, t109.fecha_listo AS fecha_listo_113, t109.fecha_promocion AS fecha_promocion_114, t109.fecha_anuncio AS fecha_anuncio_115, t109.fecha_venta AS fecha_venta_116, t109.precio AS precio_117, t109.precio_chrono24 AS precio_chrono24_118, t109.margen_bruto_esperado AS margen_bruto_esperado_119, t109.margen_neto_esperado AS margen_neto_esperado_120, t109.tiempo AS tiempo_121, t109.comentario_publico AS comentario_publico_122, t109.comentario_privado AS comentario_privado_123, t109.descripcion AS descripcion_124, t109.ubicacion_actual AS ubicacion_actual_125, t109.fecha_ubicacion_actual AS fecha_ubicacion_actual_126, t109.estado_actual AS estado_actual_127, t109.fecha_estado_actual AS fecha_estado_actual_128, t109.costes AS costes_129, t109.reloj_foto AS reloj_foto_130, t109.reloj_foto_valoracion AS reloj_foto_valoracion_131, t109.reloj_foto_set AS reloj_foto_set_132, t109.reloj_foto_crono AS reloj_foto_crono_133, t109.reloj_video AS reloj_video_134, t109.recompra AS recompra_135, t109.garantia AS garantia_136, t109.active AS active_137, t109.deleted_at AS deleted_at_138, t109.updated_at AS updated_at_139, t109.created_at AS created_at_140, t109.reloj_id AS reloj_id_141, t0.estado_reloj_id AS estado_reloj_id_142, t0.marca_id AS marca_id_143, t0.estado_aspecto_id AS estado_aspecto_id_144, t0.estado_check_id AS estado_check_id_145, t0.operacion_gestion_id AS operacion_gestion_id_146, t0.operacion_venta_id AS operacion_venta_id_147, t0.operacion_compra_id AS operacion_compra_id_148, t0.valoracion_id AS valoracion_id_149, t0.empresa_id AS empresa_id_150, t0.caja_reloj_material_id AS caja_reloj_material_id_151, t0.caja_reloj_bisel_material_id AS caja_reloj_bisel_material_id_152, t0.pulsera_material_id AS pulsera_material_id_153, t0.pulsera_material_cierre_id AS pulsera_material_cierre_id_154, t0.reloj_base_id AS reloj_base_id_155 FROM reloj t0 LEFT JOIN registro_policial t100 ON t100.reloj_id = t0.id AND ((t100.deleted_at IS NULL)) LEFT JOIN promocion t109 ON t109.reloj_id = t0.id AND ((t109.deleted_at IS NULL)) WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"719"
]
|
| 11 | 0.89 ms |
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))
Parameters:
[
"719"
]
|
| 12 | 0.72 ms |
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.valoracion_id AS valoracion_id_8, t0.reloj_id AS reloj_id_9, t0.clone_id AS clone_id_10, t0.type, t0.precio_promocion AS precio_promocion_11, t0.descuento AS descuento_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.reloj_idperseo AS reloj_idperseo_14, t0.reloj_foto AS reloj_foto_15, t0.reloj_modelo1 AS reloj_modelo1_16, t0.reloj_ref1 AS reloj_ref1_17, t0.reloj_fecha AS reloj_fecha_18, t0.reloj_caja AS reloj_caja_19, t0.reloj_papeles AS reloj_papeles_20, t0.itp AS itp_21, t0.comision AS comision_22, t0.precio_coste AS precio_coste_23, t0.precio_coste_total AS precio_coste_total_24, t0.precio_min_venta AS precio_min_venta_25, t0.precio_promocion AS precio_promocion_26, t0.precio_oferta AS precio_oferta_27, t0.precio_referencia AS precio_referencia_28, t0.precio_pagar AS precio_pagar_29, t0.margen_minimo AS margen_minimo_30, t0.margen_deseado AS margen_deseado_31, t0.margen_promocion AS margen_promocion_32, t0.costes_total AS costes_total_33, t0.reloj_inventario_id AS reloj_inventario_id_34, t0.reloj_marca_id AS reloj_marca_id_35, t0.reloj_aspecto_id AS reloj_aspecto_id_36, t0.reloj_base_id AS reloj_base_id_37 FROM valoraciones_relojes t0 WHERE t0.id = ? AND t0.type IN ('stock', 'sinstock') AND ((t0.deleted_at IS NULL))
Parameters:
[
"4457"
]
|
| 13 | 0.60 ms |
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.valoracion_id AS valoracion_id_8, t0.reloj_id AS reloj_id_9, t0.clone_id AS clone_id_10, t0.type, t0.precio_promocion AS precio_promocion_11, t0.descuento AS descuento_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.reloj_idperseo AS reloj_idperseo_14, t0.reloj_foto AS reloj_foto_15, t0.reloj_modelo1 AS reloj_modelo1_16, t0.reloj_ref1 AS reloj_ref1_17, t0.reloj_fecha AS reloj_fecha_18, t0.reloj_caja AS reloj_caja_19, t0.reloj_papeles AS reloj_papeles_20, t0.itp AS itp_21, t0.comision AS comision_22, t0.precio_coste AS precio_coste_23, t0.precio_coste_total AS precio_coste_total_24, t0.precio_min_venta AS precio_min_venta_25, t0.precio_promocion AS precio_promocion_26, t0.precio_oferta AS precio_oferta_27, t0.precio_referencia AS precio_referencia_28, t0.precio_pagar AS precio_pagar_29, t0.margen_minimo AS margen_minimo_30, t0.margen_deseado AS margen_deseado_31, t0.margen_promocion AS margen_promocion_32, t0.costes_total AS costes_total_33, t0.reloj_inventario_id AS reloj_inventario_id_34, t0.reloj_marca_id AS reloj_marca_id_35, t0.reloj_aspecto_id AS reloj_aspecto_id_36, t0.reloj_base_id AS reloj_base_id_37 FROM valoraciones_relojes t0 WHERE t0.id = ? AND t0.type IN ('stock', 'sinstock') AND ((t0.deleted_at IS NULL))
Parameters:
[
"4422"
]
|
| 14 | 0.69 ms |
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.valoracion_id AS valoracion_id_8, t0.reloj_id AS reloj_id_9, t0.clone_id AS clone_id_10, t0.type, t0.precio_promocion AS precio_promocion_11, t0.descuento AS descuento_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.reloj_idperseo AS reloj_idperseo_14, t0.reloj_foto AS reloj_foto_15, t0.reloj_modelo1 AS reloj_modelo1_16, t0.reloj_ref1 AS reloj_ref1_17, t0.reloj_fecha AS reloj_fecha_18, t0.reloj_caja AS reloj_caja_19, t0.reloj_papeles AS reloj_papeles_20, t0.itp AS itp_21, t0.comision AS comision_22, t0.precio_coste AS precio_coste_23, t0.precio_coste_total AS precio_coste_total_24, t0.precio_min_venta AS precio_min_venta_25, t0.precio_promocion AS precio_promocion_26, t0.precio_oferta AS precio_oferta_27, t0.precio_referencia AS precio_referencia_28, t0.precio_pagar AS precio_pagar_29, t0.margen_minimo AS margen_minimo_30, t0.margen_deseado AS margen_deseado_31, t0.margen_promocion AS margen_promocion_32, t0.costes_total AS costes_total_33, t0.reloj_inventario_id AS reloj_inventario_id_34, t0.reloj_marca_id AS reloj_marca_id_35, t0.reloj_aspecto_id AS reloj_aspecto_id_36, t0.reloj_base_id AS reloj_base_id_37 FROM valoraciones_relojes t0 WHERE t0.id = ? AND t0.type IN ('stock', 'sinstock') AND ((t0.deleted_at IS NULL))
Parameters:
[
"4420"
]
|
| 15 | 0.61 ms |
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.valoracion_id AS valoracion_id_8, t0.reloj_id AS reloj_id_9, t0.clone_id AS clone_id_10, t0.type, t0.precio_promocion AS precio_promocion_11, t0.descuento AS descuento_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.reloj_idperseo AS reloj_idperseo_14, t0.reloj_foto AS reloj_foto_15, t0.reloj_modelo1 AS reloj_modelo1_16, t0.reloj_ref1 AS reloj_ref1_17, t0.reloj_fecha AS reloj_fecha_18, t0.reloj_caja AS reloj_caja_19, t0.reloj_papeles AS reloj_papeles_20, t0.itp AS itp_21, t0.comision AS comision_22, t0.precio_coste AS precio_coste_23, t0.precio_coste_total AS precio_coste_total_24, t0.precio_min_venta AS precio_min_venta_25, t0.precio_promocion AS precio_promocion_26, t0.precio_oferta AS precio_oferta_27, t0.precio_referencia AS precio_referencia_28, t0.precio_pagar AS precio_pagar_29, t0.margen_minimo AS margen_minimo_30, t0.margen_deseado AS margen_deseado_31, t0.margen_promocion AS margen_promocion_32, t0.costes_total AS costes_total_33, t0.reloj_inventario_id AS reloj_inventario_id_34, t0.reloj_marca_id AS reloj_marca_id_35, t0.reloj_aspecto_id AS reloj_aspecto_id_36, t0.reloj_base_id AS reloj_base_id_37 FROM valoraciones_relojes t0 WHERE t0.id = ? AND t0.type IN ('stock', 'sinstock') AND ((t0.deleted_at IS NULL))
Parameters:
[
"4404"
]
|
| 16 | 0.56 ms |
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.valoracion_id AS valoracion_id_8, t0.reloj_id AS reloj_id_9, t0.clone_id AS clone_id_10, t0.type, t0.precio_promocion AS precio_promocion_11, t0.descuento AS descuento_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.reloj_idperseo AS reloj_idperseo_14, t0.reloj_foto AS reloj_foto_15, t0.reloj_modelo1 AS reloj_modelo1_16, t0.reloj_ref1 AS reloj_ref1_17, t0.reloj_fecha AS reloj_fecha_18, t0.reloj_caja AS reloj_caja_19, t0.reloj_papeles AS reloj_papeles_20, t0.itp AS itp_21, t0.comision AS comision_22, t0.precio_coste AS precio_coste_23, t0.precio_coste_total AS precio_coste_total_24, t0.precio_min_venta AS precio_min_venta_25, t0.precio_promocion AS precio_promocion_26, t0.precio_oferta AS precio_oferta_27, t0.precio_referencia AS precio_referencia_28, t0.precio_pagar AS precio_pagar_29, t0.margen_minimo AS margen_minimo_30, t0.margen_deseado AS margen_deseado_31, t0.margen_promocion AS margen_promocion_32, t0.costes_total AS costes_total_33, t0.reloj_inventario_id AS reloj_inventario_id_34, t0.reloj_marca_id AS reloj_marca_id_35, t0.reloj_aspecto_id AS reloj_aspecto_id_36, t0.reloj_base_id AS reloj_base_id_37 FROM valoraciones_relojes t0 WHERE t0.id = ? AND t0.type IN ('stock', 'sinstock') AND ((t0.deleted_at IS NULL))
Parameters:
[
"4378"
]
|
| 17 | 0.67 ms |
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))
Parameters:
[
"4378"
]
|
| 18 | 0.77 ms |
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))
Parameters:
[
"4404"
]
|
| 19 | 0.44 ms |
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))
Parameters:
[
"4420"
]
|
| 20 | 0.49 ms |
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))
Parameters:
[
"4422"
]
|
| 21 | 1.04 ms |
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))
Parameters:
[
"1293"
]
|
| 22 | 0.57 ms |
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))
Parameters:
[
"4457"
]
|
| 23 | 0.48 ms |
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))
Parameters:
[
"4459"
]
|
| 24 | 0.73 ms |
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))
Parameters:
[
"1331"
]
|
| 25 | 0.91 ms |
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))
Parameters:
[
"719"
]
|
| 26 | 0.66 ms |
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.fecha_venta AS fecha_venta_54, t0.precio_costes_venta AS precio_costes_venta_55, t0.precio_venta AS precio_venta_56, t0.margen_bruto AS margen_bruto_57, t0.beneficio_bruto AS beneficio_bruto_58, t0.base_imponible AS base_imponible_59, t0.iva AS iva_60, t0.tipo_iva AS tipo_iva_61, t0.forma_pago AS forma_pago_62, t0.detalle_operacion_id AS detalle_operacion_id_63, t0.cliente_id AS cliente_id_64, t0.reloj_marca_id AS reloj_marca_id_65, t0.reloj_estado_id AS reloj_estado_id_66, t0.unidad_negocio_id AS unidad_negocio_id_67, t0.usuario_id AS usuario_id_68, t0.canal_id AS canal_id_69, t0.estado_id AS estado_id_70, t0.reloj_venta_id AS reloj_venta_id_71, t0.type FROM actividad t0 WHERE t0.reloj_venta_id = ? AND t0.type IN ('venta') AND ((t0.deleted_at IS NULL))
Parameters:
[
"719"
]
|
| 27 | 0.76 ms |
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.descripcion_detallada AS descripcion_detallada_3, t0.fecha AS fecha_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.promocion_id AS promocion_id_8, t0.type, t0.precio AS precio_9, t0.coste AS coste_10, t0.estado_reloj_id AS estado_reloj_id_11, t0.ubicacion_actual_id AS ubicacion_actual_id_12, t0.ubicacion_anterior_id AS ubicacion_anterior_id_13, t0.coste AS coste_14, t0.tipo_cargo_id AS tipo_cargo_id_15, t0.precio AS precio_16, t0.canal_id AS canal_id_17, t0.competencia_id AS competencia_id_18, t0.coste AS coste_19, t0.tipo_cargo_id AS tipo_cargo_id_20, t0.estado_check_id AS estado_check_id_21, t0.precio AS precio_22, t0.despublicar AS despublicar_23, t0.canal_id AS canal_id_24, t0.coste AS coste_25, t0.tipo_cargo_id AS tipo_cargo_id_26 FROM accion_abstract t0 WHERE t0.promocion_id = ? AND t0.type IN ('estado', 'ubicacion', 'mejora', 'competencia', 'servicio', 'check', 'anuncio', 'venta') AND ((t0.deleted_at IS NULL))
Parameters:
[
"686"
]
|
| 28 | 0.50 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.deleted_at AS deleted_at_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.type FROM ubicacion t0 WHERE t0.id = ? AND t0.type IN ('general', 'proveedor') AND ((t0.deleted_at IS NULL))
Parameters:
[
"4"
]
|
| 29 | 0.66 ms |
SELECT t0.id AS id_1, t0.key_estado AS key_estado_2, t0.nombre AS nombre_3, t0.icono AS icono_4, t0.color AS color_5, t0.orden AS orden_6, t0.deleted_at AS deleted_at_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.type FROM estado t0 WHERE t0.id = ? AND t0.type IN ('reloj') AND ((t0.deleted_at IS NULL))
Parameters:
[
"35"
]
|
| 30 | 0.37 ms |
SELECT t0.id AS id_1, t0.key_estado AS key_estado_2, t0.nombre AS nombre_3, t0.icono AS icono_4, t0.color AS color_5, t0.orden AS orden_6, t0.deleted_at AS deleted_at_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.type FROM estado t0 WHERE t0.id = ? AND t0.type IN ('reloj') AND ((t0.deleted_at IS NULL))
Parameters:
[
"24"
]
|
| 31 | 0.62 ms |
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_coste_total AS precio_coste_total_18, t0.precio_venta AS precio_venta_19, t0.margen_beneficio AS margen_beneficio_20, t0.descuento AS descuento_21, t0.fecha_envio AS fecha_envio_22, t0.recompra AS recompra_23, t0.garantia AS garantia_24, t0.reloj_aspecto_id AS reloj_aspecto_id_25, t0.reloj_marca_id AS reloj_marca_id_26, t0.venta_id AS venta_id_27, t0.reloj_venta_id AS reloj_venta_id_28, t0.type FROM detalle_operacion t0 WHERE t0.reloj_venta_id = ? AND t0.type IN ('venta') AND ((t0.deleted_at IS NULL))
Parameters:
[
"719"
]
|
| 32 | 0.54 ms |
SELECT t0.id AS id_1, t0.key_estado AS key_estado_2, t0.nombre AS nombre_3, t0.icono AS icono_4, t0.color AS color_5, t0.orden AS orden_6, t0.deleted_at AS deleted_at_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.type FROM estado t0 WHERE t0.id = ? AND t0.type IN ('aspecto') AND ((t0.deleted_at IS NULL))
Parameters:
[
"8"
]
|
| 33 | 0.45 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.logo AS logo_3, t0.deleted_at AS deleted_at_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6 FROM marca t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"31"
]
|
| 34 | 0.64 ms |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.logo AS logo_2, m0_.deleted_at AS deleted_at_3, m0_.updated_at AS updated_at_4, m0_.created_at AS created_at_5 FROM marca m0_ WHERE (m0_.deleted_at IS NULL)
Parameters:
[] |
| 35 | 0.53 ms |
SELECT e0_.id AS id_0, e0_.key_estado AS key_estado_1, e0_.nombre AS nombre_2, e0_.icono AS icono_3, e0_.color AS color_4, e0_.orden AS orden_5, e0_.deleted_at AS deleted_at_6, e0_.updated_at AS updated_at_7, e0_.created_at AS created_at_8, e0_.type AS type_9 FROM estado e0_ WHERE ((e0_.deleted_at IS NULL)) AND e0_.type IN ('aspecto') ORDER BY e0_.orden DESC
Parameters:
[] |
| 36 | 0.31 ms |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.comision AS comision_2, c0_.descripcion AS descripcion_3, c0_.deleted_at AS deleted_at_4, c0_.updated_at AS updated_at_5, c0_.created_at AS created_at_6 FROM canal c0_ WHERE (c0_.deleted_at IS NULL)
Parameters:
[] |
| 37 | 0.31 ms |
SELECT u0_.id AS id_0, u0_.nombre AS nombre_1, u0_.descripcion AS descripcion_2, u0_.deleted_at AS deleted_at_3, u0_.updated_at AS updated_at_4, u0_.created_at AS created_at_5, u0_.type AS type_6 FROM ubicacion u0_ WHERE ((u0_.deleted_at IS NULL)) AND u0_.type IN ('general', 'proveedor')
Parameters:
[] |
| 38 | 0.29 ms |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2, t0_.deleted_at AS deleted_at_3, t0_.updated_at AS updated_at_4, t0_.created_at AS created_at_5, t0_.type AS type_6 FROM tipo_cargo t0_ WHERE ((t0_.deleted_at IS NULL)) AND t0_.type IN ('servicio')
Parameters:
[] |
| 39 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2, t0_.deleted_at AS deleted_at_3, t0_.updated_at AS updated_at_4, t0_.created_at AS created_at_5, t0_.type AS type_6 FROM tipo_cargo t0_ WHERE ((t0_.deleted_at IS NULL)) AND t0_.type IN ('mejora')
Parameters:
[] |
| 40 | 0.30 ms |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2, t0_.deleted_at AS deleted_at_3, t0_.updated_at AS updated_at_4, t0_.created_at AS created_at_5, t0_.type AS type_6 FROM tipo_cargo t0_ WHERE ((t0_.deleted_at IS NULL)) AND t0_.type IN ('venta')
Parameters:
[] |
| 41 | 0.27 ms |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.descripcion AS descripcion_2, c0_.orden AS orden_3, c0_.deleted_at AS deleted_at_4, c0_.updated_at AS updated_at_5, c0_.created_at AS created_at_6 FROM competencia c0_ WHERE (c0_.deleted_at IS NULL)
Parameters:
[] |
| 42 | 0.29 ms |
SELECT e0_.id AS id_0, e0_.key_estado AS key_estado_1, e0_.nombre AS nombre_2, e0_.icono AS icono_3, e0_.color AS color_4, e0_.orden AS orden_5, e0_.deleted_at AS deleted_at_6, e0_.updated_at AS updated_at_7, e0_.created_at AS created_at_8, e0_.type AS type_9 FROM estado e0_ WHERE ((e0_.deleted_at IS NULL)) AND e0_.type IN ('check')
Parameters:
[] |
| 43 | 0.33 ms |
SELECT e0_.id AS id_0, e0_.key_estado AS key_estado_1, e0_.nombre AS nombre_2, e0_.icono AS icono_3, e0_.color AS color_4, e0_.orden AS orden_5, e0_.deleted_at AS deleted_at_6, e0_.updated_at AS updated_at_7, e0_.created_at AS created_at_8, e0_.type AS type_9 FROM estado e0_ WHERE ((e0_.deleted_at IS NULL)) AND e0_.type IN ('aspecto')
Parameters:
[] |
| 44 | 0.25 ms |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.descripcion AS descripcion_2, m0_.deleted_at AS deleted_at_3, m0_.updated_at AS updated_at_4, m0_.created_at AS created_at_5 FROM material m0_ WHERE (m0_.deleted_at IS NULL)
Parameters:
[] |
| 45 | 0.76 ms |
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))
Parameters:
[
"912"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\CCAA | No errors. |
| App\Entity\Provincia | No errors. |
| App\Entity\Cliente | No errors. |
| App\Entity\Usuario | No errors. |
| App\Entity\Log | No errors. |
| App\Entity\UserSessionLog | No errors. |
| App\Entity\Promocion | No errors. |
| App\Entity\Reloj |
|
| App\Entity\AccionAbstract | No errors. |
| App\Entity\ValoracionesRelojes | No errors. |
| App\Entity\ValoracionesRelojesSinStock |
|
| App\Entity\RegistroPolicial | No errors. |
| App\Entity\EstadoAbstract | No errors. |
| App\Entity\EstadoReloj | No errors. |
| App\Entity\Marca |
|
| App\Entity\EstadoAspecto |
|
| App\Entity\EstadoCheck | No errors. |
| App\Entity\Operacion | No errors. |
| App\Entity\Valoracion |
|
| App\Entity\Empresa | No errors. |
| App\Entity\Material | No errors. |
| App\Entity\ActividadAbstract | No errors. |
| App\Entity\ActividadCompra | No errors. |
| App\Entity\ActividadVenta | No errors. |
| App\Entity\DetalleOperacion |
|
| App\Entity\DetalleCompra |
|
| App\Entity\ValoracionesRelojesStock | No errors. |
| App\Entity\Canal | No errors. |
| App\Entity\Compra | No errors. |
| App\Entity\Referencia |
|
| App\Entity\Coste |
|
| App\Entity\UnidadNegocio | No errors. |
| App\Entity\EstadoActividad | No errors. |
| App\Entity\DetalleVenta |
|
| App\Entity\Gasto | No errors. |
| App\Entity\Trazabilidad | No errors. |
| App\Entity\AccionEstado | No errors. |
| App\Entity\AccionUbicacion | No errors. |
| App\Entity\UbicacionAbstract | No errors. |
| App\Entity\AccionMejora | No errors. |
| App\Entity\TipoCargoAbstract | No errors. |
| App\Entity\TipoCargoMejora | No errors. |
| App\Entity\AccionCompetencia | No errors. |
| App\Entity\Competencia | No errors. |
| App\Entity\AccionServicio | No errors. |
| App\Entity\TipoCargoServicio | No errors. |
| App\Entity\AccionCheck | No errors. |
| App\Entity\AccionAnuncio | No errors. |
| App\Entity\AccionVenta | No errors. |
| App\Entity\TipoCargoVenta | No errors. |
| App\Entity\UbicacionGeneral | No errors. |
| App\Entity\UbicacionProveedor | No errors. |
| App\Entity\Venta |
|
| App\Entity\CosteVenta | No errors. |
| App\Entity\EstadoOperacion | No errors. |
| App\Entity\Banco | No errors. |
| App\Entity\Firmante | No errors. |
| App\Entity\Intercambio | No errors. |