22/01/2025 10:45:55.3568  1585 ms.           OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces'
22/01/2025 15:45:37.2587   754 ms.           OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces'
22/01/2025 15:45:38.5546   541 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
22/01/2025 15:47:20.3978   691 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-01-22 15:47:19' where payTraUID = 4909346729809950 and payStatus='V' and payEnabled=1
22/01/2025 15:47:25.5492   768 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 ('2025-01-22 15:47:24',0,'V',5186694872441340,4899709046034970,2025,'2025-01-22 15:47:24',18,1,0,4,'2025-01-22 16:02:24','C','KES',100,100,0,'','','',1,100,0,0,'',0,0)
22/01/2025 15:47:26.1976   549 ms.           EXEC: update tabTerminalReceipt set trcProgressive = 3146, trcLastPrinted = '2500703146', trcLastDate = '2025-01-22 15:47:25' where trcStatus='V' and trcTerId = 18
22/01/2025 15:48:28.6815   779 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/01/2025 15:48:33.9380  5149 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
22/01/2025 19:44:20.3094  1199 ms.           OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1
22/01/2025 19:44:20.3614  2106 ms.           OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 61 ms.)
22/01/2025 19:44:20.3624  2120 ms.           OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 56 ms.)
22/01/2025 19:44:20.3664 17306 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 26 ms.)
22/01/2025 19:44:20.3694  8421 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 29 ms.)
22/01/2025 19:44:20.3694 19503 ms.           OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 3 ms.)
22/01/2025 19:44:21.5621   682 ms.           OPEN: SELECT * FROM abbsubscriptions INNER JOIN abbcards ON carSubId=subId INNER JOIN tabcustomer ON subCusId=cusId WHERE carStatus='V' AND subStatus='V' AND (carCode<>'' OR carUHFCode<>'') AND subAbbType NOT IN (6,-1) ORDER BY carCode
22/01/2025 19:44:32.3933 10506 ms.     EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0
22/01/2025 19:44:35.5913  3087 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
22/01/2025 19:44:38.9823  3391 ms.           EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103);
22/01/2025 19:55:00.4610  2025 ms.           OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191894' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1
22/01/2025 19:56:00.2319   735 ms.           OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '456777175800327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P'))
22/01/2025 20:49:02.3763   630 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 112 order by traDateTime desc,traId desc
22/01/2025 20:49:23.9178   899 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 111 order by traDateTime desc,traId desc
22/01/2025 20:52:31.5706  3016 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc
22/01/2025 21:14:31.0891  2952 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc
22/01/2025 21:20:24.4611  1167 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc