30/04/2025 12:45:50.0322   531 ms.           EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1
30/04/2025 13:05:23.9996   515 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5290402919588580,5019796135838550,2025,'2025-04-30 13:05:23','
Date:     4/30/2025 1:05:23 PM

Code:  457754574000327005012999
Entry Date:  4/30/2025 12:42:20 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


# 2500717140
',0)
30/04/2025 13:29:58.4688  7836 ms.           OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces'
30/04/2025 13:29:58.6419 28920 ms.           OPEN: select parcurrency,parcurrencySymbol from tabParameters where parStatus='V' order by parId desc limit 1 (WAIT TIME 169 ms.)
30/04/2025 13:29:58.6419  7841 ms.           OPEN: select * from tablanguages where lanStatus='V' order by lannumber limit 1 (WAIT TIME 169 ms.)
30/04/2025 13:29:58.6549  7329 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4
30/04/2025 13:29:58.6549  6594 ms.           OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4
30/04/2025 13:29:59.6969   502 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16)
30/04/2025 13:29:59.7009   511 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16)
30/04/2025 13:29:59.7039   511 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3)
30/04/2025 13:30:00.5915   694 ms.     EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 4 nr: 0
30/04/2025 13:30:00.5915  1404 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2)
30/04/2025 13:30:00.7256  1006 ms.           OPEN: show columns from abbCards where Field = 'carUHFCode'
30/04/2025 13:30:01.3019   576 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
30/04/2025 13:30:06.6339  7391 ms.           OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457753792800327005012999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1
30/04/2025 13:30:06.6379  3527 ms.           OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457754847700327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1
30/04/2025 13:30:07.4014  6195 ms.     EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0
30/04/2025 13:30:09.3537  1533 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,'2025-04-30 13:30:07','V',4947292410286080,2025,'2025-04-30 13:27:57','457754847700327005031999',1,2,16,'I','',1,0,1,'','',4)
30/04/2025 13:30:10.6696  1305 ms.           EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage)
30/04/2025 13:30:10.9668  4096 ms.     EXECSCALAR: select count(payId) from paypayment where payStatus='V' and payIdTerminal = 17 and payDateTime = '2025-04-30 13:25:21' nr: 0
30/04/2025 13:30:12.0825  4524 ms.           EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40);
30/04/2025 13:30:12.3557   622 ms.           OPEN: select * from tabTariff left join tabtlkTariff on tlkTarId = tarId where (tarValidFrom <= '2025-04-30' and tarValidTo >= '2025-04-30' and tarStatus='V' and tlkAreId = 1 and tlkStatus='V') and (((tarIdClass = 6 or tarIdClass <=0) and tarEnabled <> 0) or tarDefault<>0) order by tarModify desc,tarId desc
30/04/2025 13:30:12.4387   853 ms.           EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-30 13:30:11',17,12,'2025-04-30 13:30:11','457753792800327005012999','Pagato  (Contanti ) Biglietto ')
30/04/2025 13:30:14.3490  2266 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);
30/04/2025 13:30:16.2353  1585 ms.           OPEN: select * from payreceipt where recPayUID = 5164318474747810 and recStatus='V'
30/04/2025 13:30:16.3023  1586 ms.           EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5119368186911210,5164318474747810,2025,'2025-04-30 13:30:14','
Data:     4/30/2025 1:25:21 PM

Codice:  457753792800327005012999
Ingresso:  4/30/2025 10:32:08 AM
Targa:                        
Categoria:                Cars
Area:                 The Mall
Varco:                 Entry 2
______________________________
Da Pagare:            0.00 KES
______________________________
Pagato:               0.00 KES
                    __________
Resto:                0.00 KES

Tipo:                 Contanti
Pagato su:    Manual Cashier 2
',1)
30/04/2025 13:30:19.1615   611 ms.     EXECSCALAR: SELECT payId FROM payPayment INNER JOIN movTransit on payTrauid = traUID WHERE payTraUID>0 AND traCode=@traCode ORDER BY payID DESC LIMIT 1 nr: 432802
30/04/2025 13:35:00.6143   700 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 164 order by traDateTime desc,traId desc
30/04/2025 13:42:02.4129  2043 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc
30/04/2025 14:06:36.6706   610 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-30 14:06:35',3,42101,0,100,1,100,1,'I','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/04/2025 14:06:51.3997  3220 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
30/04/2025 14:14:36.3280  1530 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
30/04/2025 14:17:20.5988   633 ms.           OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 103 order by traDateTime desc,traId desc
30/04/2025 15:01:07.4592   550 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-30 15:01:06' where traUID = 5376496374356100 and traStatus='V' and traEnabled=1
30/04/2025 15:03:05.7127  1545 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
30/04/2025 16:07:28.6909   516 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2025-04-30 16:07:28' where payTraUID = 5685313822607240 and payStatus='V' and payEnabled=1
30/04/2025 17:32:01.1113   566 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-30 17:32:00' where traUID = 5259825601982900 and traStatus='V' and traEnabled=1
30/04/2025 17:37:53.7839   562 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
30/04/2025 17:50:07.9729 11652 ms.           OPEN: select 1 as Tot,payUID,payPayed,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 = 1 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType
30/04/2025 18:44:09.2464  1845 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 = 12 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
30/04/2025 18:44:50.8828  1043 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 = 9 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
30/04/2025 19:13:18.3425   514 ms.           OPEN: select terSendConfig from tabTerminal where terAddress = 6 and terStatus='V'
30/04/2025 19:13:18.3435   520 ms.           OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16)