31/01/2024 10:00:30.0081 843 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-01-31 10:00:29','V',5142879844211270,2024,'2024-01-31 10:00:28','453203602800327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2024 10:00:31.4201 1405 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2024 15:34:47.4196 671 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-01-31 15:34:46',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 31/01/2024 15:55:13.5710 502 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-01-31 15:55:13','V',5635150952667900,2024,'2024-01-31 15:55:12','453205731200327005012999',1,2,16,'I','',1,0,1,'','',4) 31/01/2024 16:45:02.5316 884 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 31/01/2024 16:45:02.6011 880 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 (WAIT TIME 91 ms.) 31/01/2024 16:45:02.6011 894 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' (WAIT TIME 89 ms.) 31/01/2024 16:45:04.3289 532 ms. OPEN: select * from tabTicketType where ticStatus='V' and ticOption='S' order by ticType,ticId 31/01/2024 16:45:08.7534 2907 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191338' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 31/01/2024 16:45:08.7534 3984 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0347899481429' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 31/01/2024 16:45:08.8167 5846 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '535253' and traDirection='I' order by traId DESC LIMIT 1 31/01/2024 16:45:11.1792 754 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and carId = 44 31/01/2024 16:45:12.3805 1197 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,'2024-01-31 16:45:11','V',5165034386141940,2024,'2024-01-31 16:40:48','453205887200327005029999',2,2,16,'I','',1,0,1,'','0532370676842',44,0) 31/01/2024 16:45:12.4425 2021 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,'2024-01-31 16:45:10','V',4732080835368160,2024,'2024-01-31 16:44:12','453205887200327002029999',2,1,2,'O','',1,0,1,'','1882553278805',97,0) 31/01/2024 16:45:14.1732 1725 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2024 16:45:14.1732 1782 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 31/01/2024 16:45:14.8538 2237 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '453205375400327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 31/01/2024 16:45:16.6285 11983 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 31/01/2024 16:45:18.4051 3550 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 = '453205375400327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 31/01/2024 16:45:19.8901 3058 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 31/01/2024 16:45:20.1463 604 ms. OPEN: SELECT SUM(vTot) as vTot,payTimeLimit FROM (SELECT SUM(payPayed)-SUM(payChange) AS vTot,MAX(payTimeLimit) AS payTimeLimit FROM payPayment INNER JOIN movtransit ON movtransit.traUID=payPayment.payTraUID WHERE traCode = '453205375400327005012999' AND traStatus='V' AND payStatus='V' AND payIdEvent<90 GROUP BY payId ORDER BY payEnabled DESC, payTimeLimit DESC) as v1 31/01/2024 16:45:22.6780 2786 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); 31/01/2024 16:45:43.7752 720 ms. OPEN: select * from tabTariff left join tabtlkTariff on tlkTarId = tarId where (tarValidFrom <= '2024-01-31' and tarValidTo >= '2024-01-31' 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 31/01/2024 16:45:43.8803 1154 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-01-31 16:45:42',4,1,'2024-01-31 16:45:42','453205623700327005012999','Payed (Cash ) Ticket ') 31/01/2024 16:45:46.6804 2485 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5637904621973080,5478867217122270,2024,'2024-01-31 16:45:44',' Date: 1/31/2024 4:41:15 PM Code: 453205623700327005012999 Entry Date: 1/31/2024 3:37:17 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) 31/01/2024 16:59:14.3814 959 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 41 order by traDateTime desc,traId desc 31/01/2024 17:01:44.9978 1402 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 31/01/2024 17:02:33.3588 898 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 8 order by traDateTime desc,traId desc 31/01/2024 17:03:32.0696 697 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 31/01/2024 17:10:11.9159 652 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 28 order by traDateTime desc,traId desc 31/01/2024 17:11:06.6612 588 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 2 order by traDateTime desc,traId desc 31/01/2024 17:12:01.7639 526 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 11 order by traDateTime desc,traId desc 31/01/2024 17:18:45.7590 4739 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 31/01/2024 17:18:55.2513 3329 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 31/01/2024 17:39:53.0308 1310 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 31/01/2024 18:09:18.9634 621 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 31/01/2024 19:06:48.2194 5041 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 31/01/2024 20:08:20.0028 580 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-01-31 20:08:19',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';