07/10/2023 09:23:26.2451 593 ms. EXEC: update payInventory set invCreation = '2023-10-07 09:23:25',invModify = '2023-10-07 09:23:25',invUseId=0,invStatus='V' where invId = 130578 07/10/2023 11:33:59.1057 656 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/10/2023 11:34:03.6855 1671 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-10-07 11:34:01','V',5492415463989490,2023,'2023-10-07 11:34:00','452044164000327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 62 ms.) 07/10/2023 11:34:03.7011 812 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 31 ms.) 07/10/2023 11:44:20.6483 546 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-10-07 11:44:19',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'; 07/10/2023 12:07:13.3167 546 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-10-07 12:07:12','V',5758697217646360,2023,'2023-10-07 12:07:12','452044363200327005012999',1,2,16,'I','',1,0,1,'','',4) 07/10/2023 12:47:17.6474 562 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/10/2023 12:53:58.4099 671 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-10-07 12:53:57','V',5242670255696050,2023,'2023-10-07 12:53:56','452044426100327005012999',2,2,2,'O','',0,'2023-10-07 12:53:57',1,'','',0) 07/10/2023 13:28:17.0915 531 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2023-10-07 13:28:16',0,1,'2023-10-07 13:28:16','','Unauthorized Transit Entry 1') 07/10/2023 15:37:02.1104 609 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-10-07 15:37:01',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'; 07/10/2023 17:39:23.3165 546 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-10-07 17:39:22' where traUID = 4746661714930870 and traStatus='V' and traEnabled=1 07/10/2023 17:44:51.0198 515 ms. EXEC: update abbCards set carLastDate = '2023-10-07 17:44:50',carLastDirection='I' where carStatus='V' and carId = 44 07/10/2023 18:17:22.6072 625 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 07/10/2023 19:58:32.4418 812 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-10-07 19:58:31',0,0,'V',5095831180258180,4990964765622080,2023,'2023-10-07 19:58:31',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-10-07 19:58:31',0,0,'V',5095831180258180,4990964765622080,2023,'2023-10-07 19:58:31',3,'KES',-2,200,-400,'N',''); 07/10/2023 20:02:08.9924 593 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-10-07 20:02:08',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'; 07/10/2023 21:50:45.2832 531 ms. EXEC: update payReceipt set recCreation = '2023-10-07 21:50:44',recModify = '2023-10-07 21:50:44',recUseId=0,recStatus='V' where recId = 176098 (WAIT TIME 15 ms.)