11/07/2023 02:44:34.5381   514 ms.           OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1
11/07/2023 13:14:37.7836   645 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-11 13:14:37','V',5179774569636910,2023,'2023-07-11 13:14:37','451164767700327005012999',1,2,16,'I','',1,0,1,'','',4)
11/07/2023 13:17:03.9690   565 ms.           EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-07-11 13:17:03',0,0,'V',4792675406419260,5668874217873000,2023,'2023-07-11 13:17:03',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-11 13:17:03',0,0,'V',4792675406419260,5668874217873000,2023,'2023-07-11 13:17:03',3,'KES',-1,100,-100,'N','');

11/07/2023 13:47:12.2476   513 ms.           EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2023-07-11 13:47:11',9999,'open','Send command to entry/exit units: Command OPEN on Device Entry 2 ','')
11/07/2023 13:55:44.6989   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,'2023-07-11 13:55:44','V',5450400904406880,2023,'2023-07-11 13:55:43','451165014300327005012999',1,2,16,'I','',1,0,1,'','',4)
11/07/2023 14:18:39.5937   541 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-07-11 14:18:38',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';

11/07/2023 14:25:01.2786  1194 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-11 14:25:00','V',4847874313830110,2023,'2023-07-11 14:24:59','451165189900327005012999',1,2,16,'I','',1,0,1,'','',4)
11/07/2023 15:00:57.4640   678 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
11/07/2023 15:04:31.9281   549 ms.           EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-07-11 15:04:31',3,42101,0,500,1,500,1,'I','N');
update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 500 and curType = 'N';

11/07/2023 15:42:51.8188   600 ms.           EXEC: insert into payPayment (payCreation,payUseId,payStatus,payUID,payTraUID,payYear,payDateTime,payIdTerminal,payEnabled,payDisableTime,payTarId,payTimeLimit,payType,payCurrency,payAmount,payPayed,payChange,payCardType,payPAN,paySTAN,payIdEvent,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2023-07-12 03:42:35',6,'V',5500284920033760,5347526934887510,2023,'2023-07-12 03:42:35',4,1,0,4,'2023-07-12 03:57:35','P','KES',50,50,0,'','','',1,50,0,0,'',0,0)
11/07/2023 16:15:59.3739   547 ms.           EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-07-11 16:15:58' where payTraUID = 4735805688306970 and payStatus='V' and payEnabled=1
11/07/2023 16:37:10.2053   691 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-07-11 16:37:09' where traUID = 5595827507214360 and traStatus='V' and traEnabled=1
11/07/2023 18:16:32.4006   565 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-11 18:16:31','V',5032894183637370,2023,'2023-07-11 18:16:31','451165887700327001012999',2,2,2,'O','',0,'2023-07-11 18:16:31',1,'','',0)
11/07/2023 20:54:53.3218   550 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-11 20:54:52','V',4995744684876550,2023,'2023-07-11 20:54:51','451167259300327005012999',2,2,2,'O','',0,'2023-07-11 20:54:52',1,'','',0)
11/07/2023 22:49:41.4915   684 ms.           EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-07-11 22:49:40' where traUID = 4996424885434870 and traStatus='V' and traEnabled=1