19/04/2024 02:08:37.5861 1265 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 19/04/2024 02:08:37.5861 1328 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 19/04/2024 10:44:07.3573 578 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-04-19 10:44:06',3,42101,0,50,-1,-50,1,'O','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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-04-19 10:44:06',3,42101,0,100,-1,-100,1,'O','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'; 19/04/2024 12:30:41.5769 546 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-04-19 12:30:40' where traUID = 5340548591437200 and traStatus='V' and traEnabled=1 19/04/2024 13:13:51.7947 578 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5580324014515900,4865323696098740,2024,'2024-04-19 13:13:51',' Date: 4/19/2024 1:13:51 PM Code: 453993958800327001012999 Entry Date: 4/19/2024 10:59:48 AM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400717251 ',0) 19/04/2024 13:19:43.3417 593 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-04-19 13:19:42' where traUID = 4866990954620180 and traStatus='V' and traEnabled=1 19/04/2024 14:06:10.3583 531 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 (WAIT TIME 46 ms.) 19/04/2024 14:14:32.4140 578 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-04-19 14:14:31',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'; 19/04/2024 17:21:52.0123 546 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-04-19 17:21:51' where traUID = 5116238008241960 and traStatus='V' and traEnabled=1 19/04/2024 18:22:54.0686 609 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-04-19 18:22:53' where traUID = 4741701924565050 and traStatus='V' and traEnabled=1 19/04/2024 20:06:22.4655 531 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-04-19 20:06:21','V',4807253693491900,2024,'2024-04-19 20:06:21','453997238100327005012999',1,2,16,'I','',1,0,1,'','',4) 19/04/2024 20:30:07.5316 546 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-04-19 20:30:06' where payTraUID = 4953539315316670 and payStatus='V' and payEnabled=1