| 1 |
22.49 ms |
SELECT t0.id AS id_1, t0.archivo AS archivo_2, t0.tipo AS tipo_3, t0.tipoimportacion AS tipoimportacion_4, t0.cantidad AS cantidad_5, t0.descripcion AS descripcion_6, t0.fechacontabilizacion AS fechacontabilizacion_7, t0.usuario AS usuario_8, t0.fechahora AS fechahora_9, t0.importetotal AS importetotal_10, t0.estado AS estado_11, t0.observaciones AS observaciones_12, t0.fecha AS fecha_13 FROM mp_importados t0 WHERE t0.archivo = ? AND t0.tipo = ? AND t0.estado = ?
Parameters: [
"PN_ColMartillerosDolores_20261026.txt"
"BAPRO"
"PROCESADO"
]
SELECT t0.id AS id_1, t0.archivo AS archivo_2, t0.tipo AS tipo_3, t0.tipoimportacion AS tipoimportacion_4, t0.cantidad AS cantidad_5, t0.descripcion AS descripcion_6, t0.fechacontabilizacion AS fechacontabilizacion_7, t0.usuario AS usuario_8, t0.fechahora AS fechahora_9, t0.importetotal AS importetotal_10, t0.estado AS estado_11, t0.observaciones AS observaciones_12, t0.fecha AS fecha_13 FROM mp_importados t0 WHERE t0.archivo = 'PN_ColMartillerosDolores_20261026.txt' AND t0.tipo = 'BAPRO' AND t0.estado = 'PROCESADO';
|
| 2 |
0.74 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 3 |
3.39 ms |
INSERT INTO mp_importados (archivo, tipo, tipoimportacion, cantidad, descripcion, fechacontabilizacion, usuario, fechahora, importetotal, estado, observaciones, fecha) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
"PN_ColMartillerosDolores_20261026.txt"
"BAPRO"
"EXTRACT"
"1"
null
null
"ADMIN"
"2026-11-03 09:57:09.457993"
"60000"
"PROVISORIO"
null
null
]
INSERT INTO mp_importados (archivo, tipo, tipoimportacion, cantidad, descripcion, fechacontabilizacion, usuario, fechahora, importetotal, estado, observaciones, fecha) VALUES ('PN_ColMartillerosDolores_20261026.txt', 'BAPRO', 'EXTRACT', '1', NULL, NULL, 'ADMIN', '2026-11-03 09:57:09.457993', '60000', 'PROVISORIO', NULL, NULL);
|
| 4 |
1.33 ms |
"COMMIT"
|
| 5 |
0.52 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 6 |
15.57 ms |
INSERT INTO mp_importados_detalle (id_cabeza, id_deuda, id_concepto, id_usuario, importe, fechapago, discrecional, id_cliente, id_ctacte, observaciones, codigo, apyn, leyenda, saldo_ant, saldo_act, observado) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
3250
null
null
null
60000.0
"2026-10-23 00:00:00.000000"
null
1573
435366
null
null
null
null
null
null
null
]
INSERT INTO mp_importados_detalle (id_cabeza, id_deuda, id_concepto, id_usuario, importe, fechapago, discrecional, id_cliente, id_ctacte, observaciones, codigo, apyn, leyenda, saldo_ant, saldo_act, observado) VALUES (3250, NULL, NULL, NULL, 60000, '2026-10-23 00:00:00.000000', NULL, 1573, 435366, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
|
| 7 |
1.29 ms |
"COMMIT"
|
| 8 |
16.25 ms |
SELECT t0.id AS id_1, t0.id_boton AS id_boton_2, t0.activo AS activo_3, t0.tipo AS tipo_4, t0.procedimiento AS procedimiento_5 FROM mp_procedimientos t0 WHERE t0.id_boton = ? AND t0.tipo = ? AND t0.activo = ?
Parameters: [
2
"PREIMPORTACION"
1
]
SELECT t0.id AS id_1, t0.id_boton AS id_boton_2, t0.activo AS activo_3, t0.tipo AS tipo_4, t0.procedimiento AS procedimiento_5 FROM mp_procedimientos t0 WHERE t0.id_boton = 2 AND t0.tipo = 'PREIMPORTACION' AND t0.activo = 1;
|
| 9 |
64.14 ms |
EXEC [UP_UPD_MP_IMPORTADOS_DETALLE_BAPRO] @idCabeza = ?
EXEC [UP_UPD_MP_IMPORTADOS_DETALLE_BAPRO] @idCabeza = 3250;
|
| 10 |
2.20 ms |
SELECT t0.id AS id_1, t0.id_cabeza AS id_cabeza_2, t0.id_deuda AS id_deuda_3, t0.id_concepto AS id_concepto_4, t0.id_usuario AS id_usuario_5, t0.importe AS importe_6, t0.fechapago AS fechapago_7, t0.discrecional AS discrecional_8, t0.id_cliente AS id_cliente_9, t0.id_ctacte AS id_ctacte_10, t0.observaciones AS observaciones_11, t0.codigo AS codigo_12, t0.apyn AS apyn_13, t0.leyenda AS leyenda_14, t0.saldo_ant AS saldo_ant_15, t0.saldo_act AS saldo_act_16, t0.observado AS observado_17 FROM mp_importados_detalle t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.id_cabeza AS id_cabeza_2, t0.id_deuda AS id_deuda_3, t0.id_concepto AS id_concepto_4, t0.id_usuario AS id_usuario_5, t0.importe AS importe_6, t0.fechapago AS fechapago_7, t0.discrecional AS discrecional_8, t0.id_cliente AS id_cliente_9, t0.id_ctacte AS id_ctacte_10, t0.observaciones AS observaciones_11, t0.codigo AS codigo_12, t0.apyn AS apyn_13, t0.leyenda AS leyenda_14, t0.saldo_ant AS saldo_ant_15, t0.saldo_act AS saldo_act_16, t0.observado AS observado_17 FROM mp_importados_detalle t0 WHERE t0.id = 17800;
|