Query Metrics
16
Database Queries
12
Different statements
9.50 ms
Query time
10
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.20 ms (12.67%) |
4 |
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"
]
|
|
1.15 ms (12.10%) |
1 |
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))
Parameters:
[
"380"
]
|
|
0.96 ms (10.08%) |
1 |
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:
[
"621"
]
|
|
0.92 ms (9.74%) |
1 |
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:
[ "anonymous" null "app_api_relojapi_getpreciopromocion" null "GET" "{"accept-encoding":["gzip,deflate"],"user-agent":["Mozilla\/5.0 AppleWebKit\/537.36 (KHTML, like Gecko; compatible; Amazonbot\/0.1; +https:\/\/developer.amazon.com\/support\/amazonbot) Chrome\/119.0.6045.214 Safari\/537.36"],"connection":["close"],"x-accel-internal":["\/internal-nginx-static-location"],"x-real-ip":["52.7.33.248"],"host":["perseo.comerziawatches.com"],"x-php-ob-level":["1"]}" "[]" "{"id":"380","plataforma":""}" null "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; Amazonbot/0.1; +https://developer.amazon.com/support/amazonbot) Chrome/119.0.6045.214 Safari/537.36" "perseo.comerziawatches.com" "82.223.107.15" "52.7.33.248" null "2026-05-02 15:13:37" "2026-05-02 15:13:37" ] |
|
0.85 ms (8.98%) |
2 |
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"
]
|
|
0.84 ms (8.85%) |
1 |
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:
[
"367"
]
|
|
0.77 ms (8.15%) |
1 |
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:
[
"380"
]
|
|
0.69 ms (7.31%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.69 ms (7.23%) |
1 |
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:
[
"3443"
]
|
|
0.67 ms (7.06%) |
1 |
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:
[
"380"
]
|
|
0.58 ms (6.14%) |
1 |
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:
[
"380"
]
|
|
0.16 ms (1.70%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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\Log | No errors. |
| App\Entity\Reloj |
|
| App\Entity\ValoracionesRelojes | No errors. |
| App\Entity\ValoracionesRelojesSinStock |
|
| App\Entity\RegistroPolicial | No errors. |
| App\Entity\Promocion | 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\Compra | No errors. |
| App\Entity\Cliente | No errors. |
| App\Entity\UnidadNegocio | No errors. |
| App\Entity\Usuario | No errors. |
| App\Entity\Canal | No errors. |
| App\Entity\EstadoActividad | No errors. |
| App\Entity\Referencia |
|
| App\Entity\Coste |
|
| App\Entity\DetalleVenta |
|
| App\Entity\Gasto | No errors. |
| App\Entity\Trazabilidad | No errors. |
| App\Entity\AccionAbstract | 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. |