12/03/2023 08:49:39.6220   704 ms.     EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1
12/03/2023 08:49:39.7551   937 ms.           OPEN: show columns from tabParameters where Field = 'parUseCulture'
12/03/2023 08:49:42.2413  1654 ms.     EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0
12/03/2023 08:49:42.9009  2097 ms.           OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '449953170100327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1
12/03/2023 08:49:43.9919  1398 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
12/03/2023 08:49:44.7799   637 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);
12/03/2023 08:49:44.8459   699 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,'2023-03-12 08:49:44','V',5305804290112760,2023,'2023-03-12 08:48:21','449953170100327005031999',1,2,16,'I','',1,0,1,'','',4)
12/03/2023 08:49:45.5283   671 ms.           EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage)
12/03/2023 08:50:05.3338  2760 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 = '449953034400327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P'))
12/03/2023 09:17:18.2837   583 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
12/03/2023 09:36:19.6027   938 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
12/03/2023 13:31:59.3304   647 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,'2023-03-12 13:31:58','V',5516017655362450,2023,'2023-03-12 13:31:58','449954682300327005012999',2,2,2,'O','',0,'2023-03-12 13:31:58',1,'','',0)
12/03/2023 13:38:48.9658  1514 ms.           OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 6 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType
12/03/2023 13:50:15.4088   582 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5563400410013230,4693020086590080,2023,'2023-03-12 13:50:14','
Date:     3/12/2023 1:50:14 PM

Code:  449954868800327005012999
Entry Date:  3/12/2023 1:31:28 PM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 2
______________________________
Total:               50.00 KES
______________________________
Paid:                50.00 KES
                    __________
Change:               0.00 KES

Type:                     Cash
Dispozitiv:              MPESA


# 2300712101
',0)
12/03/2023 14:33:57.6717   505 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5122952434038160,4646187602395150,2023,'2023-03-12 14:33:57','
Date:     3/12/2023 2:33:57 PM

Code:  449954611700327005012999
Entry Date:  3/12/2023 12:48:37 PM
Plate:                        
Class:                    Cars
Park:                 The Mall
Gate:                  Entry 2
______________________________
Total:              100.00 KES
______________________________
Paid:               100.00 KES
                    __________
Change:               0.00 KES

Type:                     Cash
Dispozitiv:              MPESA


# 2300712118
',0)
12/03/2023 16:42:15.7854   502 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5228706156647730,5448499139438640,2023,'2023-03-12 16:42:15','
Date:     3/12/2023 4:41:24 PM

Code:  449955809900327005012999
Entry Date:  3/12/2023 4:08:19 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


# 2300404933
',0)