17/05/2023 16:09:53.9343   643 ms.     EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1
17/05/2023 16:09:53.9623  3563 ms.           OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces'
17/05/2023 16:09:57.3789  1907 ms.           OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191294' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1
17/05/2023 16:09:57.4049  2294 ms.           OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0347899454317' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 (WAIT TIME 26 ms.)
17/05/2023 16:09:57.6841  2603 ms.     EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0
17/05/2023 16:09:58.4636   581 ms.           OPEN: show columns from abbCards where Field = 'carUHFCode'
17/05/2023 16:09:59.5204  1495 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
17/05/2023 16:10:00.0277  1208 ms.           EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2023-05-17 16:09:58','V',5204223388205760,2023,'2023-05-17 16:00:00','450615730700327005029999',2,2,16,'I','',1,0,1,'','0532370676798',36,0)
17/05/2023 16:10:00.8363  1376 ms.           EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2023-05-17 16:09:58','V',4752284917114960,2023,'2023-05-17 16:06:54','450615730700327002029999',2,1,2,'O','',1,0,1,'','0532370676798',36,0) (WAIT TIME 808 ms.)
17/05/2023 16:10:00.9253  1404 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);
17/05/2023 16:10:01.9280  1185 ms.     EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 4 and payDateTime = '2023-05-17 15:57:38' nr: 0
17/05/2023 16:10:02.1061  1255 ms.           EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage)
17/05/2023 16:10:02.1061  1263 ms.           EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage)
17/05/2023 16:10:04.2227  1861 ms.           EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2023-05-17 16:10:02',4,12,'2023-05-17 16:10:02','450615708800327005012999','Payed  (Credit Card ) Ticket ')
17/05/2023 16:10:07.4068  1276 ms.           EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 133931 else acvFstPayId end),acvLstPayId = 133931 where acvSftId = 547 and acvCodeId = 3
17/05/2023 16:10:09.9956  2197 ms.           EXEC: update tabTerminalReceipt set trcProgressive = 9623, trcLastPrinted = '2300409623', trcLastDate = '2023-05-17 16:10:07' where trcStatus='V' and trcTerId = 4
17/05/2023 16:10:12.3141  1906 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4844876623707920,5662109178290460,2023,'2023-05-17 16:10:10','
Date:     5/17/2023 3:57:38 PM

Code:  450615708800327005012999
Entry Date:  5/17/2023 3:51:28 PM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 2
______________________________
Total:               50.00 KES
______________________________
Paid:                50.00 KES
                    __________
Change:               0.00 KES

Type:              Credit Card
Dispozitiv:   Manual Cashier 1


# 2300409623
',0)
17/05/2023 16:10:13.1947   787 ms.           EXEC: update payReceipt set recCreation = '2023-05-17 16:10:12',recModify = '2023-05-17 16:10:12',recUseId=0,recStatus='V' where recId = 114896
17/05/2023 16:10:17.3446   709 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4725831412856490,5032261959717590,2023,'2023-05-17 16:10:16','
Date:     5/17/2023 4:00:50 PM

Code:  450615359200327005012999
Entry Date:  5/17/2023 2:53:12 PM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 2
______________________________
Total:                0.00 KES
______________________________
Paid:                 0.00 KES
                    __________
Change:               0.00 KES

Type:                     Cash
Dispozitiv:   Manual Cashier 1
',1)
17/05/2023 16:10:21.9939   578 ms.           EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 133934 else acvFstPayId end),acvLstPayId = 133934 where acvSftId = 547 and acvCodeId = 3
17/05/2023 16:21:32.4090   983 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc
17/05/2023 16:24:32.2720   815 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc