24/12/2022 00:37:35.4144 592 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-12-24 00:37:34',3,42101,0,1000,1,1000,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+1000,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 1000 and curType = 'N'; 24/12/2022 04:25:18.5591 3348 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2022 09:08:18.9940 554 ms. EXEC: update abbCards set carLastDate = '2022-12-24 09:08:18',carLastDirection='O' where carStatus='V' and carId = 12 24/12/2022 11:27:36.1600 565 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,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2022-12-24 11:27:35',0,'V',5525959407664070,5503397815385130,2022,'2022-12-24 11:27:35',3,1,0,4,'2022-12-24 11:42:35','C','KES',50,200,150,'',' ',' ',1,50,0,0,'',0,0) 24/12/2022 12:55:25.4275 501 ms. EXEC: update tabTerminalReceipt set trcProgressive = 5149, trcLastPrinted = '2200405149', trcLastDate = '2022-12-24 12:55:24' where trcStatus='V' and trcTerId = 4 24/12/2022 14:08:23.9965 555 ms. EXEC: update payInventory set invCreation = '2022-12-24 14:08:23',invModify = '2022-12-24 14:08:23',invUseId=0,invStatus='V' where invId = 39678 24/12/2022 15:39:33.0941 529 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2022-12-24 15:39:32' where payTraUID = 5082201692278030 and payStatus='V' and payEnabled=1 24/12/2022 16:04:23.3868 510 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2022-12-24 16:04:22' where traUID = 4615530470030900 and traStatus='V' and traEnabled=1 24/12/2022 16:18:37.0312 5858 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 24/12/2022 16:18:37.0523 5857 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 (WAIT TIME 30 ms.) 24/12/2022 16:18:37.0523 5857 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 (WAIT TIME 29 ms.) 24/12/2022 16:18:37.0533 5868 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 (WAIT TIME 23 ms.) 24/12/2022 16:18:37.1043 5940 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 24/12/2022 16:18:37.5366 6372 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 24/12/2022 16:18:37.8318 513 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 24/12/2022 16:18:37.8478 507 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 24/12/2022 16:18:38.2471 532 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 157 ms.) 24/12/2022 16:18:38.2571 764 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 (WAIT TIME 158 ms.) 24/12/2022 16:18:39.9942 3034 ms. EXECSCALAR: select sum(parAllowNegativePlaces) from tabParameters where parStatus='V' order by parId desc limit 1 nr: 0 24/12/2022 16:18:44.1340 4021 ms. EXECSCALAR: SELECT count(*) FROM payinventory WHERE invValue<>0 AND invType='' nr: 0 24/12/2022 16:18:44.1350 3726 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 24/12/2022 16:18:44.1820 3756 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 24/12/2022 16:18:47.3721 3140 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 24/12/2022 16:18:55.0593 7450 ms. EXEC: UPDATE payInventory SET invType='C' WHERE invType<>'C' AND invValue IN (5,10,20,40) AND invDevice IN (41003,41002,41001,41101,41102,41103); (WAIT TIME 234 ms.) 24/12/2022 16:18:55.2464 6563 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 122 ms.) 24/12/2022 16:18:55.6617 570 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 24/12/2022 16:19:01.3525 4728 ms. OPEN: SELECT traCode FROM movTransit WHERE traId = '124576' and traDirection='I' order by traId DESC LIMIT 1 (WAIT TIME 445 ms.) 24/12/2022 16:19:04.6557 3054 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 (WAIT TIME 324 ms.) 24/12/2022 16:19:04.6567 1067 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 316 ms.) 24/12/2022 16:19:06.1126 748 ms. OPEN: select * from tabUserMessage where useMesDescr = 'msg_endshift' and (useLanCode = 'it-IT' or mid(useLanCode,1,2) = 'it') (WAIT TIME 215 ms.) 24/12/2022 16:19:23.4502 2566 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 138 ms.) 24/12/2022 16:19:24.5419 772 ms. EXEC: INSERT INTO opeActivities (acvCreation,acvUseId,acvTerId,acvOpeUseId,acvSuperUseId,acvCodeId,acvTypeId,acvDateTime,acvSftId,acvCausal) VALUES (@ACVCREATION,@ACVUSEID,@ACVTERID,@ACVOPEUSEID,@ACVSUPERUSEID,@ACVCODEID,@ACVTYPEID,@ACVDATETIME,@ACVSFTID,@ACVCAUSAL) (WAIT TIME 25 ms.) 24/12/2022 16:19:28.1003 2941 ms. EXEC: create temporary table temp_tariff (tarId integer not null default 0,tarDay integer not null default 0,tarHourFrom datetime not null default 0,tarHourTo datetime not null default 0,tarNumber integer not null default 0,tarAmount double not null default 0,tarPeriod integer not null default 0,tarPeriodLength integer not null default 0,tarPeriodCount integer not null default 0,rulAmountPeriod double not null default 0,rulAmountPeriodDay double not null default 0,tarDisabled integer not null default 0) ENGINE = MEMORY 24/12/2022 16:19:38.7504 10547 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 = 6 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 24/12/2022 16:20:25.3645 575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2022 16:20:59.9385 1175 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '449174305600327005012999' 24/12/2022 16:21:08.2441 2392 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2022 16:21:16.5726 1198 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 24/12/2022 16:21:17.7084 8923 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2022 16:21:24.2577 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2022 16:21:27.0856 1871 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2022 16:21:32.1910 3790 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 24/12/2022 16:22:37.2614 2413 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '449175744600327005012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) 24/12/2022 16:22:42.0316 2457 ms. OPEN: select * from abbAreaGroup left join abbGroupSlots on grsArgId = argId where argStatus='V' and argAbgId = 99999 and (grsDate='1970-01-01' or (grsDate = '2022-12-24' and grsRecurrency=0) or (month(grsDate) = 12 and day(grsDate)=24 and grsRecurrency=1)) order by grsDOW,grsRecurrency,grsDate,grsTimeFrom (WAIT TIME 4727 ms.) 24/12/2022 16:22:51.5099 4272 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/12/2022 16:22:51.5149 4310 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/12/2022 16:24:09.3508 7995 ms. EXEC: update tabTerminalExtraMem SET extBarrier = 0 where extStatus='V' and extTerId = 16 AND extPlateWaitOperator=0 24/12/2022 16:25:06.3338 18951 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 (WAIT TIME 114 ms.) 24/12/2022 16:25:06.4699 18871 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,'2022-12-24 16:24:47','V',5489299064409980,2022,'2022-12-24 16:24:29','0098788191674',2,1,2,'O','',1,0,1,'','',0) (WAIT TIME 250 ms.) 24/12/2022 16:25:09.5279 566 ms. OPEN: show columns from abbPayment where Field = 'payCarId' 24/12/2022 16:25:10.6266 560 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,'2022-12-24 16:25:10','V',5618176795143050,2022,'2022-12-24 16:24:44','449173656200327005012999',2,2,2,'O','',0,'2022-12-24 16:25:10',1,'','0230003957463',25,0) 24/12/2022 16:25:13.7587 2802 ms. EXEC: update abbCards set carLastDate = '2022-12-24 16:25:10',carLastDirection='O' where carStatus='V' and carId = 25 (WAIT TIME 243 ms.) 24/12/2022 16:25:47.7004 2948 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 32 ms.) 24/12/2022 16:26:27.5990 4712 ms. OPEN: select * from tabUserMessage where useMesDescr = 'msg_operator' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 24/12/2022 16:26:37.0393 4673 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 4665 ms.) 24/12/2022 16:26:46.5246 4510 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) 24/12/2022 16:26:56.1210 4591 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,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2022-12-24 16:23:59',6,'V',4723207856100810,5570306767553550,2022,'2022-12-24 16:23:59',4,1,0,4,'2022-12-24 16:38:59','P','KES',50,50,0,'','','',1,50,0,0,'',0,0) (WAIT TIME 81 ms.) 24/12/2022 16:27:00.8851 4258 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 62 ms.) 24/12/2022 16:27:05.5262 4469 ms. EXEC: update payReceipt set recCreation = '2022-12-24 16:27:01',recModify = '2022-12-24 16:27:01',recUseId=0,recStatus='V' where recId = 48385 24/12/2022 16:27:05.6333 4688 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,payAmountCalc,payDiscountValue,payDiscount,payDiscountType,payVatPercent,payVatAmount) VALUES ('2022-12-24 16:25:23',12,'V',4946715656816310,4629731985580510,2022,'2022-12-24 16:25:23',17,1,0,4,'2022-12-24 16:40:23','C','KES',200,200,0,'','','',1,200,0,0,'',0,0) 24/12/2022 16:27:10.2804 4431 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4975, trcLastPrinted = '2200604975', trcLastDate = '2022-12-24 16:27:05' where trcStatus='V' and trcTerId = 17 24/12/2022 16:27:10.3505 4526 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 24/12/2022 16:28:02.5393 4376 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 24/12/2022 16:28:07.2774 4233 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2022-12-24 16:28:03' where subId = 16 24/12/2022 16:28:12.0766 3930 ms. EXEC: update abbCards set carLastDate = '2022-12-24 16:28:08',carLastDirection='O' where carStatus='V' and carId = 15 24/12/2022 16:28:12.0826 3946 ms. EXEC: update tabTerminalReceipt set trcProgressive = 4976, trcLastPrinted = '2200604976', trcLastDate = '2022-12-24 16:28:08' where trcStatus='V' and trcTerId = 17 24/12/2022 16:28:17.0339 4888 ms. EXEC: update payReceipt set recCreation = '2022-12-24 16:28:12',recModify = '2022-12-24 16:28:12',recUseId=0,recStatus='V' where recId = 48387 24/12/2022 16:28:17.1050 4913 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2022-12-24 16:28:12' where traUID = 5258488413274140 and traStatus='V' and traEnabled=1 24/12/2022 16:28:27.4719 1619 ms. OPEN: select * from movTransit where traStatus = 'V' and traBadge = '0532370677393' order by traId desc limit 1 24/12/2022 16:28:42.9132 4360 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,'2022-12-24 16:28:38','V',5663299201472910,2022,'2022-12-24 16:28:04','449175703900327002029999',2,1,2,'O','',1,0,1,'','0532370677393',15,0) 24/12/2022 16:29:06.9542 4849 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2022-12-24 16:29:02',0,2,'2022-12-24 16:29:02','','Unauthorized Transit Exit 1') 24/12/2022 16:29:06.9572 4783 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 24/12/2022 16:29:06.9632 9691 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 24/12/2022 16:29:16.1713 4529 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2022-12-24 16:29:11',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 24/12/2022 16:29:20.9075 4375 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/12/2022 16:30:06.0256 4077 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 24/12/2022 16:30:15.7130 4422 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 57 ms.) 24/12/2022 16:30:20.8094 4679 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 24/12/2022 16:31:05.4142 3855 ms. OPEN: select * from abbCards inner join abbSubscriptions on carSubId = subId inner join tabCustomer on cusId = subCusId left join tabAbbGroups on cusAbgId = abgId where carStatus='V' and subStatus='V' and cusStatus='V' and (carCode = '449174305600327005012999') 24/12/2022 16:31:10.2014 4088 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 39 ms.) 24/12/2022 16:31:10.2084 4116 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2022-12-24 16:31:06',1,2,'2022-12-24 16:31:06','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') (WAIT TIME 41 ms.) 24/12/2022 16:31:19.9118 4275 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,'2022-12-24 16:31:15','V',5013709103870130,2022,'2022-12-24 16:30:46','449175944600327005031999',1,2,16,'I','',1,0,1,'','',4) 24/12/2022 16:31:19.9268 4262 ms. OPEN: select * from tabParameters where parStatus='V' order by parId desc 24/12/2022 16:31:24.4729 4558 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/12/2022 16:31:29.2110 4131 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2022-12-24 16:31:25' where payTraUID = 5570306767553550 and payStatus='V' and payEnabled=1 24/12/2022 16:32:02.5763 18488 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 24/12/2022 16:32:16.6517 4183 ms. OPEN: select * from tabUserMessage where useMesDescr = 'msg_ticket' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 24/12/2022 16:32:21.4038 4162 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,'2022-12-24 16:32:17','V',4991275695383580,2022,'2022-12-24 16:32:10','449170001100327003229999',22,22,3,'I','',1,0,1,'','',2) 24/12/2022 16:32:21.4078 4182 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4959537198374930,5717892202821640,2022,'2022-12-24 16:32:17',' Date: 12/24/2022 4:29:24 PM Code: 449175656400327005012999 Entry Date: 12/24/2022 3:42:44 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 # 2200405164 ',0) 24/12/2022 16:32:39.2127 17301 ms. EXEC: insert into movBarrier (barUseId,barCreation,barTerId,barAction,barDescription,barPlate) VALUES (1,'2022-12-24 16:32:21',9999,'open','Send command to entry/exit units: Command OPEN on Device Exit 1 ','') 24/12/2022 16:32:53.5863 4375 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 59 ms.) 24/12/2022 16:33:22.0102 4252 ms. OPEN: select terDefaultClass from tabTerminal where terStatus='V' and terId = 3 (WAIT TIME 45 ms.) 24/12/2022 16:33:22.0633 4344 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 81 ms.) 24/12/2022 16:33:45.7801 4094 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,'2022-12-24 16:33:41','V',5197734749586840,2022,'2022-12-24 16:33:08','449170001200327003229999',22,22,3,'I','',1,0,1,'','',2) (WAIT TIME 66 ms.) 24/12/2022 16:33:45.7961 4144 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 77 ms.) 24/12/2022 16:33:50.5673 4346 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 59 ms.) 24/12/2022 16:34:09.4639 4526 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 4741 ms.) 24/12/2022 16:34:57.1547 4662 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,'2022-12-24 16:34:52','V',4853824029196760,2022,'2022-12-24 16:33:10','449175959000327005031999',1,2,16,'I','',1,0,1,'','',4) (WAIT TIME 192 ms.) 24/12/2022 16:35:11.2240 4563 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/12/2022 16:35:15.9622 4469 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 24/12/2022 16:35:39.9882 4327 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 17 OR lnsTerId=17) (WAIT TIME 238 ms.) 24/12/2022 16:35:49.5406 4519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 (WAIT TIME 83 ms.) 24/12/2022 16:35:53.9645 4462 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 24/12/2022 16:35:59.0609 4459 ms. EXEC: insert into abbPayment (payCreation,payCode,payAmount,payCredit,payPayUID,payCarId,payDateFrom,payDateTo) VALUES ('2022-12-24 16:35:54','0230003944059',0,0,5007659184122360,13,'0000-00-00 00:00:00','0000-00-00 00:00:00') (WAIT TIME 270 ms.) 24/12/2022 16:36:03.7421 4228 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 278 ms.) 24/12/2022 16:36:08.2140 4305 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 ('2022-12-24 16:35:59',0,'V',5007659184122360,5085532270748130,2022,'2022-12-24 16:35:59',2,1,0,-1,'2022-12-24 17:35:59','S','KES',0,0,0,'','','',3,0,0) 24/12/2022 16:36:13.0302 4356 ms. EXEC: update abbCards set carLastDate = '2022-12-24 16:36:08',carLastDirection='O' where carStatus='V' and carId = 13 24/12/2022 16:36:27.2427 4328 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/12/2022 16:36:32.1820 4812 ms. EXEC: update abbCards set carLastDate = '2022-12-24 16:36:27',carLastDirection='O' where carStatus='V' and carId = 13 (WAIT TIME 126 ms.) 24/12/2022 16:37:05.5983 4084 ms. EXEC: update abbCards set carLastDate = '2022-12-24 16:37:01',carLastDirection='O' where carStatus='V' and carId = 13 (WAIT TIME 366 ms.) 24/12/2022 16:37:05.6203 4075 ms. OPEN: select * from tabDevice where devId = 4 and devStatus = 'V' (WAIT TIME 370 ms.) 24/12/2022 16:37:33.8031 4554 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 69 ms.) 24/12/2022 16:38:07.0383 4028 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,'2022-12-24 16:38:02','V',4789093948529720,2022,'2022-12-24 16:37:42','449175783400327005029999',2,2,16,'I','',1,0,1,'','0532370677393',15,0) (WAIT TIME 70 ms.) 24/12/2022 16:38:16.5406 4111 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 75 ms.) 24/12/2022 16:38:21.2968 4468 ms. EXEC: update abbCards set carLastDate = '2022-12-24 16:38:16',carLastDirection='I' where carStatus='V' and carId = 15 (WAIT TIME 82 ms.) 24/12/2022 16:38:21.3158 4473 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 (WAIT TIME 86 ms.) 24/12/2022 16:38:26.0489 4133 ms. OPEN: SELECT * FROM movTransit WHERE traStatus=@traStatus AND traCode=@traCode AND traDirection=@traDirection ORDER BY traDateTime,traId (WAIT TIME 77 ms.) 24/12/2022 16:38:35.5182 4200 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 4 (WAIT TIME 48 ms.) 24/12/2022 16:38:40.2624 4431 ms. OPEN: select * from tabTicketType where ticId = 1 (WAIT TIME 41 ms.) 24/12/2022 16:38:49.8808 4220 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,'2022-12-24 16:38:45','V',5672471954355780,2022,'2022-12-24 16:35:22','449175783800327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) (WAIT TIME 78 ms.) 24/12/2022 16:38:49.8858 4186 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 79 ms.) 24/12/2022 16:38:59.2721 4413 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,'2022-12-24 16:38:54','V',4972394148519510,2022,'2022-12-24 16:36:31','449175656400327005012999',2,2,2,'O','',0,'2022-12-24 16:38:54',1,'','',0) (WAIT TIME 59 ms.) 24/12/2022 16:39:04.1723 4104 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 206 ms.) 24/12/2022 16:39:13.4835 4154 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 8 ms.) 24/12/2022 16:39:18.2167 4729 ms. EXEC: update abbCards set carLastDate = '2022-12-24 16:39:13',carLastDirection='O' where carStatus='V' and carId = 13 (WAIT TIME 3 ms.) 24/12/2022 16:39:23.2140 8995 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,'2022-12-24 16:39:09','V',5589157192262420,2022,'2022-12-24 16:37:42','449175784100327005029999',2,2,16,'I','',1,0,1,'','0532370677393',15,0) (WAIT TIME 4849 ms.) 24/12/2022 16:39:27.9742 4227 ms. OPEN: select * from movtransit where trastatus='V' and (traCode = '449174610500327005012999449174610500327005012999') and traDirection='I' order by traId desc limit 1 (WAIT TIME 261 ms.) 24/12/2022 16:39:37.4195 4037 ms. OPEN: select sum(payPayed) as vTot,sum(payChange) as vChange from movTransit inner join payPayment on payPayment.payTraUID = movTransit.traUID LEFT JOIN tabTerminal on terId = payIdTerminal WHERE traCode = '449175670300327001012999' AND traStatus='V' AND payStatus='V' and (terType IS NULL OR terType<>3 OR (terType=3 and payType='P')) (WAIT TIME 79 ms.) 24/12/2022 16:39:37.4275 4121 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 81 ms.) 24/12/2022 16:39:42.0956 4083 ms. EXEC: update abbCards set carLastDate = '2022-12-24 16:39:37',carLastDirection='I' where carStatus='V' and carId = 15 (WAIT TIME 125 ms.) 24/12/2022 16:39:46.8808 4005 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,'2022-12-24 16:39:42','V',5248623835710050,2022,'2022-12-24 16:35:22','449175784400327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) (WAIT TIME 39 ms.) 24/12/2022 16:39:51.5659 4312 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,'2022-12-24 16:39:46','V',5005899278532190,2022,'2022-12-24 16:37:42','449175784500327005029999',2,2,16,'I','',1,0,1,'','0532370677393',15,0) 24/12/2022 16:39:56.2170 4648 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 24/12/2022 16:40:00.9632 4366 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,'2022-12-24 16:39:56','V',5488843170127860,2022,'2022-12-24 16:35:22','449175784600327002029999',2,1,2,'O','',1,0,1,'','0532370677371',13,0) 24/12/2022 16:40:05.9445 4043 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 231 ms.) 24/12/2022 16:40:41.3371 4534 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,'2022-12-24 16:40:36','V',5202668411507890,2022,'2022-12-24 16:40:22','0098788191674',2,1,2,'O','',1,0,1,'','',0) 24/12/2022 16:40:41.3451 9265 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 24/12/2022 16:41:00.3528 4614 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 4714 ms.) 24/12/2022 16:41:05.0980 4616 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 4759 ms.) 24/12/2022 16:41:09.9732 4523 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 120 ms.) 24/12/2022 16:41:24.2497 4251 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191674' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 (WAIT TIME 145 ms.) 24/12/2022 16:41:38.4302 4063 ms. OPEN: select * from payCurInventory where curTerId = 4 and curQuantity>0 and curType in ('C','N') order by curDevCode,curChannelId,curValue (WAIT TIME 91 ms.) 24/12/2022 16:42:02.2411 4337 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,'2022-12-24 16:41:57','V',4775964293372740,2022,'2022-12-24 16:40:34','0098788191674',2,1,2,'O','',1,0,1,'','',0) (WAIT TIME 80 ms.) 24/12/2022 16:42:11.8044 4570 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 206 ms.) 24/12/2022 16:42:35.5803 4070 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) (WAIT TIME 220 ms.) 24/12/2022 16:42:40.1523 4217 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 56 ms.) 24/12/2022 16:42:54.4749 4546 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191674' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 (WAIT TIME 55 ms.) 24/12/2022 16:43:03.9542 4374 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 4842 ms.) 24/12/2022 16:43:13.4145 4015 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191674' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 (WAIT TIME 64 ms.) 24/12/2022 16:43:18.3808 3967 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) (WAIT TIME 291 ms.) 24/12/2022 16:43:22.9449 4040 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,'2022-12-24 16:43:18','V',5343427439209230,2022,'2022-12-24 16:40:22','0098788191674',2,1,2,'O','',1,0,1,'','',0) (WAIT TIME 105 ms.) 24/12/2022 16:43:27.6490 4631 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,'2022-12-24 16:43:18','V',5585597643582920,2022,'2022-12-24 16:41:07','0098788191674',2,1,2,'O','',1,0,1,'','',0) (WAIT TIME 62 ms.) 24/12/2022 16:43:41.9745 3968 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,'2022-12-24 16:43:37','V',5228758445765460,2022,'2022-12-24 16:40:27','449175785500327005029999',2,2,16,'I','',1,0,1,'','0532370676842',44,0) (WAIT TIME 135 ms.) 24/12/2022 16:43:42.0026 4020 ms. OPEN: select * from movtransit t where traCode = '449175746600327005012999' and t.traStatus='V' and t.traDirection='I' order by t.traId desc limit 1 (WAIT TIME 86 ms.) 24/12/2022 16:44:18.7130 4521 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,'2022-12-24 16:44:13','V',5040199335250760,2022,'2022-12-24 16:41:07','0098788191674',2,1,2,'O','',1,0,1,'','',0) (WAIT TIME 62 ms.) 24/12/2022 16:44:28.3975 4286 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,'2022-12-24 16:44:23','V',5605511832443850,2022,'2022-12-24 16:40:22','0098788191674',2,1,2,'O','',1,0,1,'','',0) (WAIT TIME 170 ms.) 24/12/2022 16:44:28.4035 4309 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,'2022-12-24 16:44:23','V',4646334440935190,2022,'2022-12-24 16:40:27','449175785600327005029999',2,2,16,'I','',1,0,1,'','0532370676842',44,0) (WAIT TIME 152 ms.) 24/12/2022 16:44:33.1256 4210 ms. EXEC: update abbCards set carLastDate = '2022-12-24 16:44:28',carLastDirection='I' where carStatus='V' and carId = 44 (WAIT TIME 223 ms.) 24/12/2022 16:44:33.1467 4190 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 (WAIT TIME 232 ms.) 24/12/2022 16:45:13.3815 4244 ms. OPEN: select last_insert_id() as vLast (WAIT TIME 99 ms.) 24/12/2022 16:45:18.1927 4388 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '0098788191338' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 (WAIT TIME 160 ms.) 24/12/2022 16:45:52.6457 24605 ms. EXEC: update abbCards set carLastDate = '2022-12-24 16:45:27',carLastDirection='I' where carStatus='V' and carId = 44 (WAIT TIME 173 ms.) 24/12/2022 16:46:26.0419 23376 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,'2022-12-24 16:45:57','V',5147803781028930,2022,'2022-12-24 16:41:57','0098788191674',2,1,2,'O','',1,0,1,'','',0) (WAIT TIME 256 ms.) 24/12/2022 16:46:52.0152 4386 ms. OPEN: select * from movTransit where traStatus = 'V' and traCode='0098788191674' order by traId desc limit 1 (WAIT TIME 166 ms.) 24/12/2022 16:46:59.1560 4119 ms. OPEN: select * from tabDevInstalled inner join tabTerminal on terId = insTerId inner join tabDevice on devId = insDevId where terId = 3 and devCode>40001 and devCode<49999 and devStatus='V' and insStatus='V' (WAIT TIME 2564 ms.) 24/12/2022 16:47:27.5619 4118 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 96 ms.) 24/12/2022 16:47:32.4012 3831 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 185 ms.) 24/12/2022 16:49:01.5646 4305 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' (WAIT TIME 243 ms.) 24/12/2022 16:49:12.3028 4388 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' (WAIT TIME 272 ms.) 24/12/2022 16:49:47.7394 4270 ms. OPEN: select * from tabTariff left join tabtlkTariff on tlkTarId = tarId where (tarValidFrom <= '2022-12-24' and tarValidTo >= '2022-12-24' and tarStatus='V' AND tarEnabled <> 0) AND (tarIdClass = 6 OR tarIdClass <=0) AND ((tlkAreId = 1 AND tlkStatus='V') OR (tarDefault<>0) OR (tlkAreId IS NULL AND tarIdType IN (SELECT ticId FROM tabTicketType WHERE ticStatus='V' AND ticType = 22))) ORDER BY tarModify DESC,tarId DESC (WAIT TIME 109 ms.) 24/12/2022 16:49:52.5406 4444 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,'2022-12-24 16:49:47','V',5395883184640620,2022,'2022-12-24 16:47:53','449170001600327003229999',22,22,3,'I','',1,0,1,'','',2) (WAIT TIME 115 ms.) 24/12/2022 16:50:36.5219 4403 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 3 and terStatus='V' (WAIT TIME 237 ms.) 24/12/2022 16:51:19.1954 4151 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 155 ms.) 24/12/2022 16:51:47.6874 27901 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,'2022-12-24 16:51:19','V',5689499774259120,2022,'2022-12-24 16:40:34','0098788191674',2,1,2,'O','',1,0,1,'','',0) (WAIT TIME 120 ms.) 24/12/2022 16:54:10.2904 4185 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 215 ms.) 24/12/2022 17:12:58.5142 578 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,'2022-12-24 17:12:57','V',5090737049051310,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/12/2022 17:20:17.0857 531 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,'2022-12-24 17:20:16','V',5289921960762410,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/12/2022 17:25:58.2613 657 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,'2022-12-24 17:25:57','V',5069345209612640,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/12/2022 18:09:50.3942 624 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2022-12-24 18:09:49',0,0,'V',4650404866453860,5621530940250520,2022,'2022-12-24 18:09:49',3,'KES',1,10,10,'C',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2022-12-24 18:09:49',0,0,'V',4650404866453860,5621530940250520,2022,'2022-12-24 18:09:49',3,'KES',1,20,20,'C',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2022-12-24 18:09:49',0,0,'V',4650404866453860,5621530940250520,2022,'2022-12-24 18:09:49',3,'KES',4,5,20,'C',''); 24/12/2022 18:11:11.5834 515 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,'2022-12-24 18:11:11','V',5332303618265870,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/12/2022 18:53:29.3195 640 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,'2022-12-24 18:53:28','V',4832493591935190,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/12/2022 19:08:37.2202 562 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,'2022-12-24 19:08:36','V',5699334802970770,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/12/2022 20:14:13.4758 562 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,'2022-12-24 20:14:12','V',5170338865624060,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/12/2022 20:16:52.4319 546 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,'2022-12-24 20:16:51','V',5125880487797990,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/12/2022 20:20:42.5910 562 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,'2022-12-24 20:20:42','V',4729519752553040,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/12/2022 20:22:43.7324 546 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,'2022-12-24 20:22:43','V',5703508235359730,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/12/2022 20:48:31.9031 515 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2022-12-24 20:48:31' where traUID = 5724839913487440 and traStatus='V' and traEnabled=1 24/12/2022 21:55:41.0972 515 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,'2022-12-24 21:55:40','V',5571463059358800,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/12/2022 21:56:58.4079 522 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,'2022-12-24 21:56:57','V',4865693531065210,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/12/2022 22:02:24.1076 625 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,'2022-12-24 22:02:23','V',5097644592348990,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0) 24/12/2022 22:45:09.7935 1093 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-12-24 22:45:08',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'; insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2022-12-24 22:45:08',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'; 24/12/2022 23:43:15.6363 719 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,'2022-12-24 23:43:14','V',5621049516417960,2022,'2022-12-24 16:52:56','449175786100327005029999',2,1,2,'O','',1,0,1,'','0532370676842',44,0)