30/10/2024 13:04:58.6656  4346 ms.           OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces'
30/10/2024 13:05:00.7661   579 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
30/10/2024 18:18:58.0573  4840 ms.           OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces'
30/10/2024 18:18:59.5945   682 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); (WAIT TIME 376 ms.)
30/10/2024 18:19:23.6954   581 ms.           EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2024-10-30 18:19:22',0,'V',5034179326905360,4651803154094830,2024,'2024-10-30 18:19:22',3,1,0,4,'2024-10-30 18:34:22','C','KES',100,200,100,'',' ',' ',1,100,0,0,'',0,0)
30/10/2024 18:19:26.4945  1764 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-30 18:19:24',3,42101,0,200,1,200,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N';

30/10/2024 18:19:27.1630   535 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-10-30 18:19:26',3,42101,0,100,-1,-100,1,'O','N');
update payCurInventory set curQuantity=round(curQuantity+-1,5),curAmount=round(curAmount+-100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 100 and curType = 'N';

30/10/2024 18:21:00.9920   814 ms.           EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2024-10-30 18:21:00','V',4793029150979180,2024,'2024-10-30 18:20:59','455936605900327005012999',1,2,16,'I','',1,0,1,'','',4)
30/10/2024 18:21:18.8853   556 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1