24/02/2024 10:20:19.2923 525 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/02/2024 10:42:52.2943 543 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 24/02/2024 10:50:42.1598 598 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-02-24 10:50:41' where traUID = 5146995428291220 and traStatus='V' and traEnabled=1 24/02/2024 10:51:49.5739 530 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-02-24 10:51:49','V',4817999295052040,2024,'2024-02-24 10:51:48','453443773000327005012999',2,2,2,'O','',0,'2024-02-24 10:51:49',1,'','',0) 24/02/2024 10:54:15.8186 2437 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 24/02/2024 11:24:45.4570 861 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 24/02/2024 11:25:13.0808 724 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-02-24 11:25:12',0,2,'2024-02-24 11:25:12','','Unauthorized Transit Exit 1') 24/02/2024 11:28:43.9282 517 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/02/2024 11:31:49.1682 584 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-02-24 11:31:48',3,42101,0,100,1,100,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+100,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 100 and curType = 'N'; 24/02/2024 11:34:52.1808 1034 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 24/02/2024 11:38:20.8859 1009 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 7 order by traDateTime desc,traId desc 24/02/2024 12:09:55.3311 796 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 24/02/2024 12:12:18.7008 541 ms. EXEC: update tabTerminalReceipt set trcProgressive = 2899, trcLastPrinted = '2400402899', trcLastDate = '2024-02-24 12:12:18' where trcStatus='V' and trcTerId = 4 24/02/2024 13:14:03.2445 526 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 24/02/2024 13:32:13.5754 648 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 24/02/2024 14:51:40.5144 525 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-02-24 14:51:39' where traUID = 4909482371396500 and traStatus='V' and traEnabled=1 24/02/2024 16:16:39.7399 909 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 24/02/2024 16:16:40.3691 627 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/02/2024 17:01:22.6503 557 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-02-24 17:01:22' where traUID = 4636931992351630 and traStatus='V' and traEnabled=1 24/02/2024 17:27:13.3659 559 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4996120253178740,5144640520734710,2024,'2024-02-24 17:27:12',' Date: 2/24/2024 5:22:36 PM Code: 453446234500327005012999 Entry Date: 2/24/2024 5:19:05 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 # 2400402929 ',0) 24/02/2024 17:39:59.9852 591 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-02-24 17:39:59',3,42101,0,50,1,50,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 50 and curType = 'N'; 24/02/2024 18:22:04.1189 894 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 24/02/2024 20:34:35.9570 590 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-02-24 20:34:35' where traUID = 4888980398768430 and traStatus='V' and traEnabled=1