22/09/2023 02:52:52.8555 70369 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 22/09/2023 02:54:05.8132 18621 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 72 ms.) 22/09/2023 02:55:05.8974 14770 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 108 ms.) 22/09/2023 02:55:49.7697 13714 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 55 ms.) 22/09/2023 02:56:10.7927 7847 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' (WAIT TIME 69 ms.) 22/09/2023 02:57:11.9996 9786 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) (WAIT TIME 286 ms.) 22/09/2023 02:57:37.7178 10571 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 22/09/2023 02:57:37.7208 10576 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 22/09/2023 02:57:45.5966 7139 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 78 ms.) 22/09/2023 08:06:49.5413 515 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-09-22 08:06:48' where traUID = 5763821257836780 and traStatus='V' and traEnabled=1 22/09/2023 10:26:30.0335 609 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-09-22 10:26:29','V',5519505173147830,2023,'2023-09-22 10:26:28','451893676100327005012999',2,2,2,'O','',0,'2023-09-22 10:26:29',1,'','',0) 22/09/2023 10:27:04.4298 781 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-09-22 10:27:03','V',5040812226029240,2023,'2023-09-22 10:27:02','451893212200327005012999',2,2,2,'O','',0,'2023-09-22 10:27:03',1,'','',0) 22/09/2023 10:56:15.2235 656 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2023-09-22 10:56:14' where payTraUID = 5327134239075620 and payStatus='V' and payEnabled=1 22/09/2023 13:15:53.9461 515 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5743312638239300,5722970316216080,2023,'2023-09-22 13:15:53',' Data: 9/22/2023 1:14:16 PM Codice: 451894207500327005012999 Ingresso: 9/22/2023 11:41:15 AM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2300606238 ',0) 22/09/2023 16:43:16.7074 609 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-09-22 16:43:16',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N';