29/07/2023 00:19:35.2633 1641 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 125 ms.) 29/07/2023 02:04:31.0622 563 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-07-29 02:04:30',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'; 29/07/2023 10:42:25.2826 566 ms. EXEC: update paycash set casCreation = '2023-07-29 10:42:24',casModify = '2023-07-29 10:42:24',casUseId=0,casStatus='V' where casId = 98408 29/07/2023 12:00:12.2663 595 ms. EXEC: update payInventory set invCreation = '2023-07-29 12:00:11',invModify = '2023-07-29 12:00:11',invUseId=0,invStatus='V' where invId = 109529 29/07/2023 12:39:50.4971 503 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-07-29 12:39:49','V',5503133272568060,2023,'2023-07-29 12:39:49','451344446800327005012999',2,2,2,'O','',0,'2023-07-29 12:39:49',1,'','',0) 29/07/2023 13:36:29.6762 545 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-07-29 13:36:29' where traUID = 5763513457428050 and traStatus='V' and traEnabled=1 29/07/2023 13:39:57.3925 716 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-07-29 13:39:56',3,42101,0,500,1,500,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 500 and curType = 'N'; 29/07/2023 13:48:29.1311 798 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-29 13:48:28',0,0,'V',4876735110315830,5207296892650270,2023,'2023-07-29 13:48:28',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-29 13:48:28',0,0,'V',4876735110315830,5207296892650270,2023,'2023-07-29 13:48:28',3,'KES',-3,100,-300,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-29 13:48:28',0,0,'V',4876735110315830,5207296892650270,2023,'2023-07-29 13:48:28',3,'KES',-3,200,-600,'N',''); 29/07/2023 14:07:42.7989 540 ms. EXEC: update paycash set casCreation = '2023-07-29 14:07:42',casModify = '2023-07-29 14:07:42',casUseId=0,casStatus='V' where casId = 98543 29/07/2023 16:33:08.3144 526 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-29 16:33:07',0,0,'V',5275254303826280,5257001729240700,2023,'2023-07-29 16:33:07',3,'KES',-1,50,-50,'N',''); 29/07/2023 18:20:06.7740 518 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1