13/12/2024 08:01:04.9423 758 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-13 08:00:48',5,3,42101,0,50,-10,-500,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-13 08:00:48',5,3,42101,0,50,10,500,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-13 08:00:48',5,3,42101,0,100,-29,-2900,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-13 08:00:48',5,3,42101,0,100,29,2900,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-13 08:00:48',5,3,42101,0,200,-2,-400,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-13 08:00:48',5,3,42101,0,200,2,400,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-13 08:00:48',5,3,42101,0,500,-4,-2000,1,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-13 08:00:48',5,3,42101,0,500,4,2000,2,'I','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-13 08:00:48',5,3,42101,1,0,0,0,1,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 13/12/2024 09:09:28.0327 1238 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 13/12/2024 09:15:22.0135 915 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 13 order by traDateTime desc,traId desc 13/12/2024 10:01:13.5626 1629 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 15 order by traDateTime desc,traId desc 13/12/2024 10:06:37.3306 1981 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 10 order by traDateTime desc,traId desc 13/12/2024 10:08:28.9648 1240 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 13/12/2024 11:03:36.9936 5208 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 12 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 13/12/2024 11:41:08.3542 522 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-13 11:41:07' where payTraUID = 4643538892363760 and payStatus='V' and payEnabled=1 13/12/2024 11:53:13.3992 713 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/12/2024 12:01:50.5265 517 ms. EXEC: update opeActivities set acvFstPayId = (case acvFstPayId when 0 then 382080 else acvFstPayId end),acvLstPayId = 382080 where acvSftId = 836 and acvCodeId = 3 13/12/2024 12:03:10.8464 715 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-13 12:03:10',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'; 13/12/2024 12:41:48.3374 931 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 13/12/2024 12:41:49.1873 847 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/12/2024 15:29:53.3235 1001 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/12/2024 15:29:55.1149 1757 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 13/12/2024 15:29:55.1410 1023 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,'2024-12-13 15:29:54','V',4672080871957300,2024,'2024-12-13 15:29:53','456375149700327005012999',2,2,2,'O','',0,'2024-12-13 15:29:54',1,'','',0) 13/12/2024 17:20:10.6680 597 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5342049793139980,5269031451616350,2024,'2024-12-13 17:20:10',' Date: 12/13/2024 5:16:52 PM Code: 456376222100327001012999 Entry Date: 12/13/2024 5:17:01 PM Plate: Class: Cars Park: The Mall Gate: Entry 1 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400417737 ',0) 13/12/2024 18:19:46.5025 581 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,payVatPercent,payVatAmount) VALUES ('2024-12-13 18:19:45',0,'V',5578193205968100,5128953711660680,2024,'2024-12-13 18:19:45',2,1,0,-1,'2024-12-13 19:19:45','S','KES',0,0,0,'','','',3,0,0) 13/12/2024 18:27:26.3554 514 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-12-13 18:27:25',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'; 13/12/2024 18:48:42.0495 1686 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 1 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 13/12/2024 19:12:08.4655 3607 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/12/2024 19:12:24.8533 1682 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/12/2024 19:12:43.8608 3320 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/12/2024 19:12:53.3641 2688 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 13/12/2024 19:13:07.6486 4630 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,'2024-12-13 19:13:02','V',5580412229939610,2024,'2024-12-13 19:12:58','456376917800327005012999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 32 ms.) 13/12/2024 19:13:12.3857 4597 ms. OPEN: select * from tabTicketType where ticId = 1 13/12/2024 19:13:21.8840 9439 ms. EXEC: update tabArea set areFreePark = areTotalPark where areStatus='V' and areTotalPark > 0 and areFreePark>areTotalPark 13/12/2024 19:13:21.9361 9525 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-13 19:13:12',1,2,'2024-12-13 19:13:12','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 13/12/2024 19:13:31.4574 4473 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 4 OR lnsTerId=4) 13/12/2024 19:13:36.3897 4566 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/12/2024 19:13:56.3253 5728 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/12/2024 19:13:59.0282 2702 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/12/2024 19:14:29.7385 44025 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = @extTerId nr: 1 13/12/2024 19:14:30.7766 1051 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2024-12-13 19:14:29',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 13/12/2024 19:14:40.3059 4267 ms. OPEN: select * from movtransit t where traCode = '456375339500327005012999' and t.traStatus='V' and t.traDirection='I' and (t.traAreId = 1 OR t.traAreid = 0) order by t.traId desc limit 1 13/12/2024 20:52:03.5285 748 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/12/2024 20:52:17.2185 2008 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/12/2024 21:37:50.3842 5882 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/12/2024 21:38:18.7146 4801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/12/2024 21:43:24.3040 3133 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/12/2024 21:43:46.2081 3227 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 13/12/2024 21:44:01.7794 903 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/12/2024 21:44:20.7684 4672 ms. OPEN: select * from movTransit where traStatus='V' and traCode = '456375412700327005012999' and traDirection='I' order by traId desc limit 1 13/12/2024 21:44:25.5945 13093 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/12/2024 21:44:30.3274 2727 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/12/2024 21:45:22.4052 1193 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 13/12/2024 21:45:23.5914 1776 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 13/12/2024 21:45:23.7085 1302 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/12/2024 22:00:43.1184 4628 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '456377878300327005012999') and traDirection='I' order by traId desc limit 1 13/12/2024 22:00:57.4496 4770 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '456377845700327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 13/12/2024 22:01:35.7411 1118 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/12/2024 22:02:57.3576 3761 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,payVatPercent,payVatAmount) VALUES ('2024-12-13 22:02:53',0,'V',5353341171506410,4914872813195760,2024,'2024-12-13 22:02:53',2,1,0,-1,'2024-12-13 23:02:53','S','KES',0,0,0,'','','',3,0,0) 13/12/2024 22:03:02.1100 4252 ms. EXEC: insert into movOperator (opeCreation,opeTerId,opeUseId,opeDateTime,opeCode,opeDescription) VALUES ('2024-12-13 22:02:57',17,1,'2024-12-13 22:02:57','456377878300327005012999','Pagato (Contanti ) Biglietto ') 13/12/2024 22:03:06.8624 4645 ms. EXEC: update tabTerminalReceipt set trcProgressive = 8038, trcLastPrinted = '2400608038', trcLastDate = '2024-12-13 22:03:02' where trcStatus='V' and trcTerId = 17 13/12/2024 22:03:11.7690 4819 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4768158317198490,5719942050139910,2024,'2024-12-13 22:03:06',' Data: 12/13/2024 10:00:20 PM Codice: 456377878300327005012999 Ingresso: 12/13/2024 9:53:03 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 50.00 KES ______________________________ Pagato: 50.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2400608038 ',0) 13/12/2024 22:03:16.3912 4461 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5230180314820290,5703995299016500,2024,'2024-12-13 22:03:11','---------------------------------- %The Mall P0006032390 End of payment ---------------------------------- POF Entry : 12/13/2024 9:47:37 PM Date : 12/13/2024 10:03:01 PM Code : 456377845700327005012999 Total : 50.00 KES VAT 16% : 6.90 KES ---------------------------------- Paid : 50.00 KES Coin changed : 0.00 KES Note changed : 0.00 KES',0) 13/12/2024 22:03:25.8699 4676 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,'2024-12-13 22:03:21','V',4678280063494290,2024,'2024-12-13 22:03:20','456377940000327005012999',1,2,16,'I','',1,0,1,'','',4) 13/12/2024 22:03:25.8920 8464 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/12/2024 22:04:03.8881 4698 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,'2024-12-13 22:03:59','V',5550068071584360,2024,'2024-12-13 22:03:54','456377943400327005012999',1,2,16,'I','',1,0,1,'','',4) 13/12/2024 22:04:08.6434 4672 ms. EXECSCALAR: SELECT traId FROM movTransit WHERE traStatus='V' AND traCode = @traCode nr: 800347 13/12/2024 22:04:18.1482 4412 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4768158317198490,5620588406497720,2024,'2024-12-13 22:04:13',' Date: 12/13/2024 10:04:13 PM Code: 456377878300327005012999 Entry Date: 12/13/2024 9:53:03 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2400753344 ',0) 13/12/2024 22:05:24.6797 4719 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,'2024-12-13 22:05:19','V',4923824133366040,2024,'2024-12-13 22:04:13','456377878300327005012999',2,2,2,'O','',0,'2024-12-13 22:05:19',1,'','',0) 13/12/2024 22:05:24.6867 9458 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 13/12/2024 22:05:29.4301 4622 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 13/12/2024 22:05:29.5112 4743 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,'2024-12-13 22:05:10','V',5075973335665220,2024,'2024-12-13 22:04:13','456377945300327005031999',1,2,16,'I','',1,0,1,'','',4) 13/12/2024 22:05:29.5272 4778 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-13 22:05:24' where payTraUID = 4768158317198490 and payStatus='V' and payEnabled=1 13/12/2024 22:05:43.7853 3991 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/12/2024 22:06:00.5033 1510 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/12/2024 22:06:14.7074 9520 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 13/12/2024 22:06:15.7756 1068 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/12/2024 22:06:20.5170 4616 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/12/2024 22:06:25.2794 4759 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 13/12/2024 22:06:32.3694 11825 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 13/12/2024 22:06:32.3865 7081 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 13/12/2024 22:26:45.6490 913 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 13/12/2024 23:44:26.3357 3206 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 13/12/2024 23:44:31.0886 797 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1