04/07/2023 14:19:34.5711 638 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-04 14:19:33',0,0,'V',4874642852989350,5069804751114900,2023,'2023-07-04 14:19:33',3,'KES',1,50,50,'N',''); (WAIT TIME 43 ms.) 04/07/2023 14:47:22.2704 643 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-07-04 14:47:21',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'; 04/07/2023 14:54:54.3457 543 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 44 order by traDateTime desc,traId desc 04/07/2023 14:55:51.8721 1078 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 04/07/2023 15:19:22.3486 608 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-07-04 15:19:21' where traUID = 5300707428544600 and traStatus='V' and traEnabled=1 04/07/2023 15:52:08.3714 525 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-07-04 15:52:07',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'; 04/07/2023 19:05:33.9939 501 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-04 19:05:33','V',5002104717252540,2023,'2023-07-04 19:05:33','451096873300327005012999',1,2,16,'I','',1,0,1,'','',4) 04/07/2023 19:40:42.1157 807 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 04/07/2023 20:22:14.8221 632 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-07-04 20:22:14' where traUID = 5364901596731480 and traStatus='V' and traEnabled=1 04/07/2023 20:29:42.9172 507 ms. EXEC: update payReceipt set recCreation = '2023-07-04 20:29:42',recModify = '2023-07-04 20:29:42',recUseId=0,recStatus='V' where recId = 135928