17/08/2023 09:01:50.1558 2956 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/08/2023 09:04:02.5752 533 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-08-17 09:04:01',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 17/08/2023 09:04:06.1686 3536 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2023-08-17 09:04:02',0,0,'V',4748376318466510,5374701174510600,2023,'2023-08-17 09:04:02',3,'KES',-1,100,-100,'N',''); 17/08/2023 09:04:06.3107 3623 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 17/08/2023 09:04:10.9208 4494 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='451532795800327005012999' 17/08/2023 09:04:20.4403 2715 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 17/08/2023 09:04:29.9217 3079 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 17/08/2023 09:04:34.6909 4684 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 17/08/2023 09:05:37.1383 4737 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 17/08/2023 09:06:35.4793 814 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 17/08/2023 09:06:49.8499 4783 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/08/2023 09:07:40.2613 4840 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/08/2023 09:08:04.6068 4641 ms. EXECSCALAR: select claId from tabClass where claPosition = 2 and claStatus='V' nr: 2 17/08/2023 09:08:09.3570 9390 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 17/08/2023 09:08:14.1082 4425 ms. OPEN: select * from tabUserMessage where useMesDescr = 'err_ticketgracetime' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 17/08/2023 09:08:18.8584 4560 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5538288382170890,4680670859412310,2023,'2023-08-17 09:08:14','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 8/17/2023 8:43:45 AM Date : 8/17/2023 9:08:12 AM Code : 451533142500327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 17/08/2023 09:08:18.8644 4607 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 17/08/2023 09:10:02.1350 4588 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 17/08/2023 09:10:21.1407 4625 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-08-17 09:10:16','V',5681563052063760,2023,'2023-08-17 09:10:11','451533301100327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 6 ms.) 17/08/2023 09:10:35.3863 4571 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 17/08/2023 09:10:59.1832 4240 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-08-17 09:10:54','V',5393094285849220,2023,'2023-08-17 09:10:25','451533302500327005031999',1,2,16,'I','',1,0,1,'','',4) 17/08/2023 09:10:59.1902 4189 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '451533258400327001012999' and traDirection='I' order by traId desc limit 1 17/08/2023 09:12:18.1353 1188 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 17/08/2023 09:12:18.1894 1240 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 17/08/2023 09:12:18.1894 1241 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 17/08/2023 09:15:18.6593 4557 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 48 ms.) 17/08/2023 09:15:28.1602 4532 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 31 ms.) 17/08/2023 09:15:32.9406 4515 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 81 ms.) 17/08/2023 09:15:37.6921 4519 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2023-08-17 08:15:33') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2023-08-17 09:15:32' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2023-08-17 09:15:32' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 77 ms.) 17/08/2023 09:15:50.7756 3418 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 56 ms.) 17/08/2023 09:16:16.0269 4542 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2023-08-17 09:16:11','V',4924027264849820,2023,'2023-08-17 09:16:06','451533336600327005012999',1,2,16,'I','',1,0,1,'','0230003942254',18,0) 17/08/2023 09:16:20.7794 4603 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 17/08/2023 09:16:39.7862 18962 ms. OPEN: select * from abbAreaGroup left join abbGroupSlots on grsArgId = argId where argStatus='V' and argAbgId = 99999 and (grsDate='1970-01-01' or (grsDate = '2023-08-17' and grsRecurrency=0) or (month(grsDate) = 8 and day(grsDate)=17 and grsRecurrency=1)) order by grsDOW,grsRecurrency,grsDate,grsTimeFrom 17/08/2023 09:16:44.5806 4494 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 17/08/2023 09:16:44.7197 4606 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 17/08/2023 09:16:44.8298 9631 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 90 ms.) 17/08/2023 09:16:44.9629 4658 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 190 ms.) 17/08/2023 09:16:54.1716 4144 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' (WAIT TIME 113 ms.) 17/08/2023 09:18:13.1670 3923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/08/2023 09:20:51.4528 2479 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/08/2023 09:24:30.4439 4632 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/08/2023 09:24:30.4439 4667 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-08-17 09:24:25','V',5714378405887240,2023,'2023-08-17 09:24:21','451533386100327005012999',1,2,16,'I','',1,0,1,'','',4) 17/08/2023 09:24:35.1943 4648 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/08/2023 09:24:39.9498 4652 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/08/2023 09:24:39.9968 4701 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 17/08/2023 09:24:40.0498 4752 ms. OPEN: select * from tabParameters where parStatus='V' order by parId desc limit 1 17/08/2023 09:24:40.0598 4767 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 17/08/2023 09:26:40.7475 4469 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 17/08/2023 09:26:50.3454 4674 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/08/2023 09:27:14.0014 4702 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 17/08/2023 09:28:01.8388 4330 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '451487432100327005012999') and traDirection='I' order by traId desc limit 1 17/08/2023 09:28:37.8923 4707 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-08-17 09:28:32','V',4844915075711050,2023,'2023-08-17 09:28:28','451533410800327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 217 ms.) 17/08/2023 09:29:56.8976 5958 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 17/08/2023 11:43:08.8431 574 ms. EXEC: update payReceipt set recCreation = '2023-08-17 11:43:08',recModify = '2023-08-17 11:43:08',recUseId=0,recStatus='V' where recId = 153576 17/08/2023 11:53:05.6800 1283 ms. EXECSCALAR: select count(traId) as Tot from movTransit where traStatus='V' and traEnabled=1 and traCarId=0 and traAreId = 1 and traUID not in (select payTraUID from paypayment where payStatus='V') nr: 10874 17/08/2023 11:53:38.3852 536 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 17/08/2023 12:06:30.8876 660 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-08-17 12:06:30' where traUID = 4913056152672620 and traStatus='V' and traEnabled=1 17/08/2023 13:58:25.4501 507 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-08-17 13:58:24','V',4732643301191730,2023,'2023-08-17 13:58:23','451534730300327005012999',2,2,2,'O','',0,'2023-08-17 13:58:24',1,'','',0) 17/08/2023 14:36:17.2985 586 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-08-17 14:36:16',3,42101,0,50,1,50,1,'I','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'; 17/08/2023 15:52:36.9466 533 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2023-08-17 15:52:36',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'; 17/08/2023 17:15:21.7659 573 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2023-08-17 17:15:21' where traUID = 4803718531323560 and traStatus='V' and traEnabled=1 17/08/2023 18:28:42.2238 1552 ms. OPEN: SELECT COUNT(traId) as Total,terId,terDescription FROM movTransit INNER JOIN tabterminal on traIdTerminal = terId AND terType IN (1,3,19,4) LEFT JOIN payPayment on payTrauid = traUID WHERE traCreation>'2022-08-24 13:51:00' AND traStatus='V' and traDirection='I' AND payTraUID IS NULL GROUP BY traIdTerminal 17/08/2023 22:10:16.3420 703 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2023-08-17 22:10:15',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N';