07/10/2024 07:59:11.5996  1168 ms.     EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-10-07 06:59:10') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-10-07 07:59:10' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-10-07 07:59:10' and (resAreId = 1 or resAreId <= 0) nr: 0
07/10/2024 08:01:54.9657  4791 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
07/10/2024 09:50:21.5589   522 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4983443885841930,5228037832423220,2024,'2024-10-07 09:50:21','----------------------------------
%The Mall P0006032390             


          End of payment          
----------------------------------

POF 

Entry : 10/7/2024 9:21:55 AM

Date : 10/7/2024 9:50:19 AM
Code : 455703371500327005012999

Total           : 50.00 KES

VAT 16%         : 6.90 KES
----------------------------------
   Paid            : 50.00 KES
   Coin changed    : 0.00 KES
   Note changed    : 0.00 KES',0)
07/10/2024 11:10:15.9799   573 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-10-07 11:10:15' where traUID = 5224727449082240 and traStatus='V' and traEnabled=1
07/10/2024 13:08:53.7304  4735 ms.           OPEN: select * from movtransit where tracode=@TRACODE and trastatus='V' and traenabled=1 order by traDateTime desc limit 1
07/10/2024 13:08:58.3935  4652 ms.           EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-10-07 13:08:53' where subId = 108
07/10/2024 13:09:16.2004 17738 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,payVatPercent,payVatAmount) VALUES ('2024-10-07 13:08:58',0,'V',5474888457736640,5086656466660810,2024,'2024-10-07 13:08:58',2,1,0,-1,'2024-10-07 14:08:58','S','KES',0,0,0,'','','',3,0,0)
07/10/2024 13:25:27.5239  1598 ms.           OPEN: select * from tabarea where areStatus='V' and areId = 1
07/10/2024 13:25:37.0283  4603 ms.           EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1
07/10/2024 13:25:37.6617   630 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-10-07 13:25:37' where payTraUID = 5184042405590250 and payStatus='V' and payEnabled=1
07/10/2024 13:25:39.5760   505 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
07/10/2024 15:44:44.5689   579 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-07 15:44:43','V',5555884534086280,2024,'2024-10-07 15:44:43','455705372500327005012999',2,2,2,'O','',0,'2024-10-07 15:44:43',1,'','',0)
07/10/2024 18:47:33.7497  2676 ms.     EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 8 ms.)
07/10/2024 18:49:37.3503  4673 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
07/10/2024 18:55:43.9669  4680 ms.           OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V'
07/10/2024 19:43:36.1254   876 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1