01/11/2024 06:45:33.9966 628 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 164 order by traDateTime desc,traId desc 01/11/2024 09:16:17.2388 650 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-01 09:16:16',3,42101,0,50,-1,-50,1,'O','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'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-01 09:16:16',3,42101,0,100,-1,-100,1,'O','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'; 01/11/2024 09:22:25.0673 1776 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 01/11/2024 09:25:48.4852 1475 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 99 order by traDateTime desc,traId desc 01/11/2024 09:43:09.2239 1055 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 66 order by traDateTime desc,traId desc 01/11/2024 10:16:03.0032 2258 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 25 order by traDateTime desc,traId desc 01/11/2024 10:17:32.6740 1048 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 01/11/2024 10:59:05.5795 543 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-01 10:59:04' where traUID = 4956095445340950 and traStatus='V' and traEnabled=1 01/11/2024 11:32:26.0247 2901 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 01/11/2024 11:32:50.7282 618 ms. OPEN: select 1 as Tot,payUID,payPayed,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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 01/11/2024 11:55:26.1645 597 ms. EXEC: update payInventory set invCreation = '2024-11-01 11:55:25',invModify = '2024-11-01 11:55:25',invUseId=0,invStatus='V' where invId = 216646 01/11/2024 12:24:59.9257 1430 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 01/11/2024 12:59:47.8571 585 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-01 12:59:47',0,0,'V',5230857055827690,5281580045588490,2024,'2024-11-01 12:59:47',3,'KES',1,100,100,'N',''); 01/11/2024 12:59:48.4906 575 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-01 12:59:47',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'; 01/11/2024 14:32:46.4105 4593 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 01/11/2024 14:33:00.6664 3903 ms. OPEN: select * from tabArea where areId = 1 and areStatus='V' and areEnabled = 1 01/11/2024 14:33:01.2378 571 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/11/2024 14:33:24.4177 4466 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-11-01 14:33:19' where traUID = 4642338858864000 and traStatus='V' and traEnabled=1 01/11/2024 14:33:46.1747 1621 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 01/11/2024 14:33:49.3598 2261 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 01/11/2024 14:33:57.6615 8067 ms. OPEN: select last_insert_id() as vLast 01/11/2024 14:35:04.4649 4256 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-11-01 14:35:00','V',4973019936799690,2024,'2024-11-01 14:33:52','455955243200327005031999',1,2,16,'I','',1,0,1,'','',4) 01/11/2024 14:35:05.0923 581 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/11/2024 14:35:16.6633 5930 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/11/2024 14:36:59.9678 4499 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '455954049600327001012999') and traDirection='I' order by traId desc limit 1 01/11/2024 14:37:05.9459 1271 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/11/2024 14:37:20.1987 3450 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 01/11/2024 14:37:54.6374 4678 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 01/11/2024 14:38:50.6099 5917 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 (WAIT TIME 64 ms.) 01/11/2024 14:42:16.2370 620 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-01 14:42:15',3,42101,0,200,-2,-400,1,'O','N'); update payCurInventory set curQuantity=round(curQuantity+-2,5),curAmount=round(curAmount+-400,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2024-11-01 14:42:15',3,42101,0,500,-1,-500,1,'O','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'; 01/11/2024 15:16:14.3140 536 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-01 15:16:13' where payTraUID = 5050962933173880 and payStatus='V' and payEnabled=1 01/11/2024 15:41:49.8374 631 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 01/11/2024 16:00:39.9527 537 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-11-01 16:00:39' where payTraUID = 5410198951171180 and payStatus='V' and payEnabled=1 01/11/2024 16:05:34.8642 699 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 01/11/2024 16:34:13.6518 4739 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-11-01 16:34:08','V',4802161395008100,2024,'2024-11-01 16:34:03','455955964300327005012999',1,2,16,'I','',1,0,1,'','',4) 01/11/2024 16:34:18.4150 4758 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/11/2024 16:34:18.7402 9780 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/11/2024 16:34:23.2433 4524 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 01/11/2024 16:34:23.2503 4510 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 01/11/2024 16:34:37.4138 4498 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 01/11/2024 16:34:37.4698 4523 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 01/11/2024 16:34:42.1590 4473 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/11/2024 16:34:42.2030 4505 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 01/11/2024 16:34:42.2401 4506 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 4 and terStatus='V' 01/11/2024 16:34:42.2661 4536 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 20 ms.) 01/11/2024 16:34:46.9152 4441 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 01/11/2024 16:34:46.9232 4456 ms. OPEN: select * from tabParameters order by parId desc limit 1 01/11/2024 16:34:51.6854 3895 ms. OPEN: select * from tabClass where claPosition = 2 01/11/2024 16:34:51.6934 3896 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/11/2024 16:34:51.6944 3897 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' 01/11/2024 16:34:51.6974 3889 ms. EXECSCALAR: select claId from tabClass where claPosition = 2 and claStatus='V' nr: 2 01/11/2024 16:34:56.4206 3937 ms. OPEN: select * from tabParameters where parStatus='V' order by parId desc 01/11/2024 16:34:56.4536 3953 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 6 and terStatus='V' 01/11/2024 16:34:56.4667 3959 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 01/11/2024 16:35:01.1728 3919 ms. OPEN: select traCode from movTransit where traCode ='455955967500327005012999' 01/11/2024 16:35:01.2018 3955 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 01/11/2024 16:35:01.2079 3942 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 16 nr: 1 01/11/2024 16:35:01.2229 3951 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 01/11/2024 16:35:10.7563 4023 ms. OPEN: select * from tabTicketType where ticId = 1 01/11/2024 16:35:29.6540 4664 ms. EXEC: update tabTerminalExtraMem SET extLoop1 = 0, extPlate = '', extPlateAccuracy=0, extPlateReadDate='1970-01-01', extPlateWaitOperator=0,extTrpId=0, extTag = '', extCode = '' where extStatus='V' and extTerId = 16 01/11/2024 16:35:39.2245 18987 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 01/11/2024 16:35:43.9036 4696 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-11-01 16:35:39' where subId = 178 01/11/2024 16:35:48.6538 4649 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,'2024-11-01 16:35:44','V',4676116105302720,2024,'2024-11-01 16:35:26','455954455100327001012999',2,2,2,'O','',0,'2024-11-01 16:35:44',1,'','0230003939927',164,0) 01/11/2024 16:35:48.7029 9463 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 01/11/2024 16:35:53.4891 4781 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 01/11/2024 16:35:58.1763 9430 ms. EXECSCALAR: select claId from tabClass where claPosition = 2 and claStatus='V' nr: 2 01/11/2024 16:36:02.9225 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-11-01 16:35:58','V',5565885150160450,2024,'2024-11-01 16:35:28','455955972800327005012999',1,2,16,'I','',1,0,1,'','',4) 01/11/2024 16:36:07.7257 4800 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 01/11/2024 16:36:31.4527 23705 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 = '455955972800327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 01/11/2024 16:36:48.0389 7115 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 01/11/2024 16:36:51.5953 3556 ms. OPEN: select * from tabParameters where parStatus='V' order by parId desc 01/11/2024 16:36:51.7084 3581 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' (WAIT TIME 87 ms.) 01/11/2024 16:40:38.9203 3809 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 1 and terStatus='V' 01/11/2024 16:42:16.9040 4761 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 90 ms.) 01/11/2024 16:57:17.6598 579 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-11-01 16:57:17','V',5465136271746240,2024,'2024-11-01 16:57:16','455956037700327005012999',2,2,2,'O','',0,'2024-11-01 16:57:17',1,'','',0) 01/11/2024 17:03:18.0548 579 ms. EXEC: update tabTerminalReceipt set trcProgressive = 15404, trcLastPrinted = '2400415404', trcLastDate = '2024-11-01 17:03:17' where trcStatus='V' and trcTerId = 4 01/11/2024 17:03:18.1549 633 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-11-01 17:03:17',0,0,'V',4885095200084800,5342457595836620,2024,'2024-11-01 17:03:17',3,'KES',-1,50,-50,'N',''); 01/11/2024 17:09:44.0244 3056 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 01/11/2024 17:11:14.2304 4735 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 01/11/2024 17:11:15.6674 1413 ms. OPEN: show columns from tabParameters where Field = 'parPlatePercentCustomers' 01/11/2024 17:11:36.7819 20558 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 01/11/2024 17:11:43.7387 6955 ms. OPEN: show columns from tabArea where Field = 'areType' 01/11/2024 17:11:44.0769 105770 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-11-01 17:09:58','V',5042203439432640,2024,'2024-11-01 17:09:51','455956128400327005012999',2,2,2,'O','',0,'2024-11-01 17:09:58',1,'','',0) 01/11/2024 18:24:35.3501 1517 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 01/11/2024 18:35:00.8316 3758 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 01/11/2024 18:35:38.7860 9408 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 01/11/2024 18:35:43.5352 4673 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 01/11/2024 18:37:09.0626 3895 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 01/11/2024 18:37:28.0867 3052 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/11/2024 18:37:32.8240 2788 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/11/2024 18:37:43.4894 1199 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/11/2024 18:37:49.9469 1717 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 01/11/2024 18:37:52.9980 2647 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 01/11/2024 18:38:07.2719 4623 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4861820621900870,5621227303447910,2024,'2024-11-01 18:38:02',' Date: 11/1/2024 6:35:29 PM Code: 455956613100327005012999 Entry Date: 11/1/2024 6:22:11 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 50.00 KES ______________________________ Paid: 50.00 KES __________ Change: 0.00 KES Type: Credit Card Dispozitiv: Manual Cashier 1 # 2400415415 ',0) 01/11/2024 18:38:11.9782 4478 ms. EXECSCALAR: select count(parId) from tabParameters where parFiscalPrinter <> 0 and parStatus='V' nr: 0 01/11/2024 18:38:12.0572 4558 ms. OPEN: select trauid from movtransit where traStatus='V' and traDirection='I' and traCode='455956613100327005012999' 01/11/2024 18:38:16.7825 4745 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/11/2024 18:39:50.6306 3089 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 01/11/2024 18:39:50.6366 7196 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 01/11/2024 18:39:50.6676 13165 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 01/11/2024 18:39:53.2504 2238 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/11/2024 18:40:00.0401 6799 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 01/11/2024 18:40:01.7973 7738 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/11/2024 18:40:01.7973 1755 ms. EXEC: update payCurInventory set curType='C' where curType<>'C' and curValue = 10 and curDevCode in (41003,41002,41001,41101,41102,41103); 01/11/2024 18:40:01.8043 577 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 01/11/2024 18:40:01.8133 5767 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 01/11/2024 18:40:01.8153 105032 ms. EXEC: update abbAreaGroup set argNrInside = argNrInside - 1 where argStatus='V' and argAreId = 1 and argAbgId = 99999 01/11/2024 18:40:03.0522 1238 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 01/11/2024 18:42:41.5421 4731 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 01/11/2024 18:42:55.7750 4656 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 18 OR lnsTerId=18) 01/11/2024 19:30:00.7564 918 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 01/11/2024 19:30:01.8431 506 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 01/11/2024 22:10:25.7992 1444 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 01/11/2024 22:21:03.4025 2285 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