05/12/2024 01:53:21.1775 1070 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 01:53:26.6862 811 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 05:52:12.1491 684 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/12/2024 05:55:42.9163 528 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 06:31:55.0924 1126 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 06:44:01.2572 617 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 07:31:45.3647 927 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 08:41:47.6585 585 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 09:00:51.5971 638 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/12/2024 09:25:51.9093 1137 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 05/12/2024 10:26:00.6759 527 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 10:44:42.3019 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 11:08:26.5489 679 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/12/2024 11:08:28.9315 631 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/12/2024 11:21:20.6906 598 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-05 11:21:20' where payTraUID = 5683082790385820 and payStatus='V' and payEnabled=1 05/12/2024 11:31:00.8269 620 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/12/2024 11:51:03.8270 644 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/12/2024 12:00:34.5957 506 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 12:06:16.1766 622 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 12:23:54.2892 578 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-05 12:23:53','V',5129417506143900,2024,'2024-12-05 12:23:53','456293902200327005012999',2,2,2,'O','',0,'2024-12-05 12:23:53',1,'','',0) 05/12/2024 12:23:55.5621 635 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-05 12:23:54' where traUID = 5633240684661530 and traStatus='V' and traEnabled=1 05/12/2024 12:33:36.0141 510 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/12/2024 12:34:56.2249 529 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'O' and traCarId = 44 order by traDateTime desc,traId desc 05/12/2024 12:37:15.6208 672 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 12:41:45.7339 549 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2024-12-05 12:41:45' where subId = 179 05/12/2024 12:50:56.7040 545 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 12:51:07.5733 596 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/12/2024 13:13:55.3787 512 ms. EXEC: update payInventory set invCreation = '2024-12-05 13:13:54',invModify = '2024-12-05 13:13:54',invUseId=0,invStatus='V' where invId = 223247 05/12/2024 13:38:38.5162 722 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 13:51:07.9317 572 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 14:39:45.9214 698 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2024-12-05 14:39:45',0,0,'V',5064032778750170,4891764637515320,2024,'2024-12-05 14:39:45',3,'KES',2,50,100,'N',''); (WAIT TIME 11 ms.) 05/12/2024 14:40:26.7437 722 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-05 14:40:26','V',5404535794528480,2024,'2024-12-05 14:40:25','456295282500327005012999',1,2,16,'I','',1,0,1,'','',4) 05/12/2024 14:41:03.7173 866 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/12/2024 14:41:04.3408 505 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 (WAIT TIME 91 ms.) 05/12/2024 16:23:57.9173 608 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 16:30:18.3913 529 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/12/2024 16:57:45.0220 924 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-05 16:57:44' where payTraUID = 5130367253428790 and payStatus='V' and payEnabled=1 05/12/2024 17:01:35.0048 586 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 17:01:46.6206 626 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-12-05 17:01:45','V',5610514505636260,2024,'2024-12-05 17:01:44','456295992900327005012999',2,2,2,'O','',0,'2024-12-05 17:01:45',1,'','0560008304916',190,0) 05/12/2024 17:05:20.7890 504 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 17:49:03.7929 890 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 17:49:05.4440 1274 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 17:49:06.4036 603 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 17:49:08.2259 1718 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 17:49:20.0247 7824 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/12/2024 17:49:38.5341 837 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 17:50:02.1519 2816 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/12/2024 17:52:49.2068 923 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/12/2024 17:53:12.9596 4469 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-05 17:53:08',0,'V',5053269964556150,5425604098513920,2024,'2024-12-05 17:53:08',2,1,0,-1,'2024-12-05 18:53:08','S','KES',0,0,0,'','','',3,0,0) 05/12/2024 17:53:12.9937 4504 ms. EXEC: DELETE FROM tmppay WHERE tmpCode = '456296081800327005012999' 05/12/2024 17:55:02.7137 638 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2024-12-05 17:55:02',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-12-05 17:55:02',3,42101,0,50,1,50,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+50,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 50 and curType = 'N'; 05/12/2024 18:07:13.3525 1253 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:11:32.0907 6538 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:11:34.1071 1915 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:11:37.4954 3287 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:11:42.4737 4267 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:11:43.1532 578 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:11:54.4698 10091 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:11:57.0155 932 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:12:05.2871 5946 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/12/2024 18:12:15.8972 3393 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/12/2024 18:12:37.9551 7860 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 05/12/2024 18:12:38.6066 651 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 05/12/2024 18:12:46.3348 33788 ms. OPEN: select * from tabTicketType where ticId = 2 05/12/2024 18:12:46.3618 30307 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/12/2024 18:14:11.3138 7984 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:14:13.7134 859 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:14:20.9172 4801 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 05/12/2024 18:14:25.8445 2372 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/12/2024 18:14:27.5306 588 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 05/12/2024 18:14:32.7741 5242 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 05/12/2024 18:14:33.4245 650 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/12/2024 18:15:04.5173 2014 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:15:06.2805 1256 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:15:11.9292 33877 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 05/12/2024 18:15:11.9512 4920 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:15:17.7992 3970 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/12/2024 18:15:17.7992 11774 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/12/2024 18:15:37.3052 3972 ms. EXECSCALAR: select count(resId) as Tot from movReservation where resStatus = 'V' and resTypeRes = 'B' AND ((resConfirmed IN (0,2,3) AND resCreation>'2024-12-05 17:15:33') OR resConfirmed IN (4,5)) and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) <= '2024-12-05 18:15:33' and DATE_ADD(resDateFrom, INTERVAL 0 MINUTE) >= '2024-12-05 18:15:33' and (resAreId = 1 or resAreId <= 0) nr: 0 (WAIT TIME 16 ms.) 05/12/2024 18:22:11.2297 4297 ms. EXEC: update movAnomaly set anmPayed = 1 where anmStatus='V' and anmPayed=0 and anmTrauid in (5640673711538530,5287848985934640,4901708225067160,4797329101283410,4999362962899430,5193519899538550,4706223777933760,5452279246661000,5739356199663310,5253991129457700,5236888099651880,5454031567543040,5597612440095750,5365153246431300,4716258923114630,5347384264540860,4735548057710820,5684801515873530,5407846296543550,4833433580326930,4900646282807080,5656879880558170,5318187086310160,5364122424951210,5165021754936310,4998477409717330,5028048192326090,4648236200156350,5683519093712300,5229228299586500,4935689054738770,5591132012295800,5116812772660550,5477281097154090,4694121770987870,5484722388935150,4760114657541120,5254621161380750,5474881741820230,5207139820560820,5471980806702460,5108610883166870,5047089543244430,5566495644600490,5741637135368670,4982768727619020,5107808016040970,5427492454479270,4940896578386730,5258083853265850,5661244645570080,5339436877857640,5566014095906240,5198682196904420,4914109861961800,4778776862563270,5422702516544320,5443607942738210,5660976071431140,4793426351025550,4624434389094370,5697280128547500,5108907327010910,5152725150119740,5119407545548580,5556898477107800,4838975750563980,4666104820366830,4865351937457480,5355551507363290,5090574893906670,4928913050740710,5420396842397470,5652022127747800,5161661495494690,5662933741367410,5600959843113010,5683436179906360,5234862452999120,5418641288651530,5199261626701560,4790316588853910,4894603847638940,5585250169566950,5297457686331460,5701200582521610,5276050120078380,5185789245486270,5380332156322360,5242837095048370,5220021736910890,4810611442471650,5638754352051650,5686277165461020,5504321562538950,5187143624548290,5059393715419530,5276422456603090,5141732401435070,5564179391840800,5758037812196280,5213679061432640,5103771763682310,4618560737059860,5713469473442060,4626781865668010,5513274904995610,5308117316790360,4779206440704050,5395387865174590,5686813627481640,5406332470708950,4849637572074410,4760833735175180,4638806676583940,5228727280916380,5519182242874190,5103652065407570,5348276168021670,5061405210267910,4882662890720360,5456068075365560,4809357223489620,5167317320282360,4731346662503790,4719584828686210,4812745950557230,5517845626340130,4624392918066780,5497157081915930,5357601886957330,5169302705782400,5647349836904300,4836246593309240,5071815076348780,5445256549492230,5522629197962290,5478342863475710,4805569214633120,4649635518719640,5063989781438770,5491651414326930,4986627311889190,4925927218806410,5519244241937320,5734978736644020,4859274792277830,5083201691802190,4925407525729910,5239869795673010,5540611718751790,4984463102764190,5687990337108970,5367105233431950,5333432402727700,5245052047333510,5555932634349050,5094612026155530,5262586690096390,5420692972395760,5406297811562680,5558240373928380,5066574142815370,5300664533958720,5340903270724850,4762255896823600,5557810815920300,5411553855832210,5696820659533220,5669678639249110,5312299003568570,4990128735481240,5081036826955850,5072823773318690,5575474597958170,4857509115153380,4962235506270310,4683991177504030,4801864208245780,5485426467418130,4780246622078270,5370934485515740,5397960088322240,5093836745325750,5190669864205310,5481015771627000,5699994128515750,5748472589490110,4950056933680140,5096934261683270,4822677906336600,5066461505827420,5592984866358310,4688830475807620,5707721634092340,5174955379265610,5426625017847140,5258852546454880,5447246859293660,5608442554261510,4904269048738080,4875472836168290,5601256328632150,4788145062211260,5475628939892620,4931019120522810,5684971354023420,5213472944322420,5524575325751880,5078026862314740,5340345083072770,4997743836261310,5408228471066810,4642345471413130,5024320305523200,5692802882333080,5467823216580070,4731959641949540,4902966733613420,4939237692117450,5641076877292510,5509222225656670,5615758429435260,4972203987971160,5499131088474590,5068484222792190,5688364593215920,5359533764941270,5177228918982380,4721554708266800,5361231134156520,5452733744032000,4868536404436230,4812145829264890,5007596490383490,5589585918013170,4688089072931610,5597033964415060,5702294515851620,5155872694039970,4970372543567370,4757021667009100,5063548296541490,5057304299513030,4971798819901800,5639787542873680,4915997887316170,4780355264414410,5180315282159780,5133679261121970,5057211787268950,4717707854415030,4757230291474140,5123635781377730,4949990037579110,5485306648071460,5725374503220140,5559995927732750,4701872367855990,4852993166912600,4730336362675560,5075587413139940,5762475382276620,5293679843160280,5227216239047110,5618176795143050,5288864180075800,5261922955848260,4992239800256690,4809157974171700,5167522011481960,4795684362167110,4813362089373060,5428461143657130,4636438315662430,4703812888809140,5408287293640400,5210358120659530,4847644795174990,4951313066517920,5490832639570820,5403278187837500,4855155619000350,5029744542700310,4690031020274060,4713929431262350,5113349462730080,5365624642343010,5592393465945060,5169820969987510,5383171370353700,5715498866674250,4853459828730430,5344915815753850,4757891371033390,5108994297502810,5330419481132360,4617190767155430,4631204703723160,5220144748532590,5167525077948550,5732561399682290,4933763652408070,5338826401386170,4873072950922690,5747175610119110,5687652841958330,4928282626903330,5055927719357630,5647447788411850,4842821628916010,5748235099902200,4986715739572250,4777692906645520,5202772736885920,5403104753931430,5416639067088650,5020856521084540,5634233927304580,4906934841193870,4630310058993510,5583700913105370,5276917817547640,5114469626190820,5300821062019990,5095686682700400,4701922592818210,4850966073671830,4774038047871940,5408587915990270,5613437800134440,5009791882673550,4907199384018540,4850648400911710,5669921965160550,5703852068639790,5266899810661850,5135300291972570,5689779387199260,5647914697510290,4614981610671750,5115167855307370,5059335601896320,4644085896483910,5626745232164790,5348217891856110,5483797101879050,5459833993167340,5334911731301470,5568367476708360,5381037668585060,5424591800155330,5185067733688740,5587732674953480,5222269304311080,5135830300633100,5500608004451820,5274774344487430,5676448576528150,5695658618873420,5717191097035660,5416464300053820,5739058672760350,5009448421614470,4696466480381130,5218842884659760,5527379533066850,4930447873445080,4990773894489490,5247697226862020,5270178603604720,4683684817141170,5446529338720700,4617415774049860,5462096029959070,5267147603166490,5295084142968510,5755044859603090,4743203447620190,5026387826984980,4677387452323490,4804467358665900,5243439082945300,5032925470674040,5461284084811270,4651452609857380,4835474191649310,5110022896762590,5034147231640960,5407039415584140,4852308163001310,5623003265072850,5131512928592460,4875687978405630,5418887378543810,4659432253739670,5758596572786740,5261572502319560,5228722832512850,5176509798002150,5627263433128100,4808577303452840,5338888579203860,5517799380673340,4629923502811710,5287308974666500,5756017564146520,5571876389407120,5348149663408440,5476884656795410,5292130220609210,5075390904035930,4661393778803470,5092467739653040,4636673839370500,5246248608097850,5057176712074260,4886469578369600,5712845640066280,5496503577466240,5255020758389900,4706062874838160,5026411670594410,5624335595726720,5189084916460500,5187919906855580,4847655063076790,5238889840564290,5568797925870880,4652567394414550,4780865283835450,5761401453739780,5665412796250190,5685917770278010,4930986867663520,4823216790924530,5633123108348990,5547494454631040,5021826329031820,5104039360547700,5280611374699170,5601501363375030,5105244749887730,4971370322120800,5174771145753100,5429304009899380,5390459672757370,5574134960641580,5342532733542160,5635274764028570,4674472363801610,5179273354623490,5411946473984780,4919219939769220,5391446093002720,5175868750415170,5397521070643050,4805478341267590,4752648947550360,5271706597008390,4918440831455940,5184497132660220,4739567659519520,5702055379861060,5621269357740550,5436029927962200,5669788381452110,5304738635578120,4651223593337020,5317868022289300,5349296825302000,5590266809166310,5391689430838410,4996077285982100,5758003400568900,5157784726726050,5053143843273680,5749018621346080,5673852814483760,5332113235669160,5105735818125960,5715068017533070,4614090149206120,5358471432273640,4645862181545410,4651107080132650,4672078521109430,5151680772022820,4774089415545970,5726517808176550,5332673767210210,5484306261331880,5657935591957910,5455080585743520,5236111631801170,5689064256530500,5290871576649740,5568113778938050,5165648734742900,4674294695887340,4873675712837480,5495733290807990,5211538225918490,5389114638011720,5599077014925990,5671631598742730,5582514726571130,5151579668256730,4666768068100390,5141226821089220,5022796896715920,5742267370977110,5455714656141340,4630456053448130,5639605814316310,5010539661005170,5526503576248670,4615878730566670,4722450432457370,5123053459178250,5719962985306480,5128470835733440,5149465715512600,5669842596176500,5720611229868060,5451999322466350,4732200019438200,4840944286181890,5046807158908910,4824788352052990,5498322712687880,5685493252781480,5671366442662150,5041064585584250,5190791023239660,5275728665351370,5504516216902330,5092976599493000,4675501449221890,4927251904161990,5044821214821380,5241621999723370,5194201314746890,5697714435992530,5134787378548330,5232827215938170,5440235717527360,5482405173418470,4748968160072280,5744206842645900,4762959993289040,5217643036909470,5104217051403370,4856993838807070,5218909340429490,5096296840327510,5090288259053400,5160192096184540,5323913332867220,5287584252107680,5079416555652210,5748683518165030,5407283357509300,5295657317133940,5662167400054560,5469918422498860,4622485498206750,5673500131694840,4775809585297440,5126028031195950,5477327243033530,5417688765630310,4730289262366870,5319044232920450,5257387945625860,5329688044436700,4855456967295910,4923136837048900,5581141018398560,4803760924098630,5033902502662310,5075787878741310,4648856895903600,4875288244247030,4789338101572100,5428001652435580,4824657808704700,4860728553787870,5111783204267620,5709419305231610,5382357877478370,5067920467075950,5033636292422540,4697766327965190,5228063128542680,5086585298191010,5103580861620670,5658722534504530,5175344085637570,5721899832591080,5052211782922150,4719279835856130,5100232254732690,5661931019145960,5057523162704980,4799698331391080,4777003696682860,4768590597854410,5191935849719650,4929350628041510,5684762791540750,5718604236126340,5339713021849160,5427324389370510,5161193473514890,4752011892197800,5086345572453550,4868769221211170,5406699041481850,5668549757497220,5639419007822840,4847136194614070,5175709986826130,5375094539646450,5536543966506200,4694598643072860,5164612014842410,5649812186641420,5248095545868990,5706522721113310,5692518230007700,5020186200123600,5472834172641590,5689693199094300,5122611512945840,4656578277970730,5220867023729540,5592853919040790,5224332423722940,5128328538383860,4627913156496290,5313401486855370,5632388624722130,5182692480393520,5513236163056340,5630199499858710,4821287133326360,5347680651504600,4890114077839790,4890261679325660,4858420010579340,5151292156036210,5216702577318630,5298054283601330,5295273661572050,5180691404246910,4759252476621370,5359901541165720,5532967410304500,4814596979562480,5585717366953500,5665818383726210,5608847900415300,4737195150126730,5017034056665480,5195504458079510,5648397295072670,4704602746582960,5342541774617790,4763588964943950,4974669132230880,5230972207338060,4715129563695890,5505112300073270,5305099605472550,5626105222520170,4622156246056840,5710670229288620,4716110835486850,4834921550608090,5143821074564630,5296655598300990,5630601741028270,5142832534574720,5095934494844770,5602464412805060,5234984108646730,5169233926630170,5088623081425010,4672204772793490,5479295355209280,5288520382952780,5699842883662480,5573349776469140,5481168715783440,4954649186000890,5085835053789570,4740848888863360,4647868705032710,4980752501571630,5159328498846510,5364059324817910,5676249245406840,4683991553013470,5703940689681290,5323330138539600,5569899415003010,5602226048909310,5429292809408760,5587941590333920,5250835715077820,5692761935974580,5543813523319640,4982738997517270,5375933656243920,5365129653188850,5501677833900250,5218923394776460,5394430511358720,4683694708281900,5120456214949970,4906595250232260,5559245789212930,5421424689528310,5183358665700120,5334805364114340,4879386000399500,5137574825825500,5535869584333770,5207338039264760,4997216977079810,5088040844564670,4901555864745680,5666699895213710,4833400877310030,5389603748823800,5695563506868680,4924493395038730,5645592510685470,5221238529011110,5672623417517430,5303670316707910,5177588715847780,4850587842239890,5353567677145280,4806383884475310,5615889942225220,4921747816082120,4731360343839260,5407180301486130,4674605094018010,5256991033367640,5598974330778410,4843919546225380,4658671868340270,4627318960968110,5481248424155590,4909888195925360,5088388877089350,5025744947919170,5174465623856340,4638807702283350,5543448164300160,5738455055024560,5301768860995270,4810001678666720,5621960379503310,5430639439805520,5468138037225120,4936298077527480,4619753863825170,5076910477886260,5602105106977040,5327846277174810,5037087494231930,4685633675493060,5100287838114740,5425070338202510,5529883495881680,5600721625679620,4826341802139530,4724711136498990,5353666837921560,5210283691087830,5347380504840740,5603695457637150,5688943721400820,5447501846222820,5447953821378230,5649168495857340,5418568070765960,5163101313092770,5285654523836390,5747422076942240,5539084876235440,5629873338563850,5614128009143310,5610729411739970,5268929977215040,5711770454040240,5597667695216170,4730418097599160,5738586083902320,4840382758722910,4841528228432920,4750772656831800,4879256903608800,4924587616549410,5065206382956380,5318833835368020,5354490469190570,4735603447027700,4735313838711670,5100657598813770,5055468713249320,5598333256663520,5078715476553640,5216643684180150,4814843011308530,5399440322871190,5007896254110420,4757382698163980,5695681724520270,5168461455521530,5620337403266320,5268444798580610,5219368984371100,5017476174715690,4951471878075800,4987510983586780,4711541149083400,5602264500996330,5058984618253340,5295275973584450,4801970532650330,5176441258770410,5560742028776470,5341370180744440,5448431065019620,5540894198866700,4719088718781980,4831197124211580,5163872043033810,4839026592542810,5394011828280510,5762998728955870,5541999407063260,4859301227954860,5751325068371710,5490344436974390,4698568387882540,4660832725626180,5224114328758380,5035597533697000,5572959383470990,5106559556010870,5286383607813430,5614812975300000,5373179571900980,5570368774914530,4674827085265040,5476793891398890,4844725548861790,5307536793515390,5607153736993520,5430481427116060,4711440564579880,4729274241057380,4853874380181520,4843349710555860,5417860371513460,4906345104595020,4907089894439660,5145553522622030,5442073049702270,5486070712894960,5045363425974160,5738544750256430,5536412924456160,5429987577467640,4847217352986530,5510244338908170,5556607933045290,4862304500623850,5245117200491830,5159895664764980,4747075392700780,4683765586319510,5464247402074550,5565619134865740,5225098913497660,5660129991776650,5092105381054190,4752204250902750,4915085420981670,5166818867696990,5442269639177470,5027643329954750,4761452685981550,4781939955722390,4943233245248840,5032655144428500,5674557351889730,4825156465941840,5470587247797410,4723824054166360,5725944091545200,4637583933362140,5461504220580170,4722947525060850,5741464931304560,5731245851449390,5289623977425240,5278971157059720,5281545159209050,4818116017716730,5026540483606240,5658248065255340,4831172205965830,4681708570337960,4669681763878920,5175404521319510,5544231689975380,4810592556091910,5210307773818230,5343676102030220,5237472107981990,5291136665165120,4706846794403920,5204937115262810,5354803435692580,4627302191094130,5578048415056250,5316624669903300,5168691233625720,5158331208009420,5017994475064820,5352810115119180,4812204784079010,4754409719091820,5054836704968880,5202149562925620,5176369034956770,5602983184554270,5490001464724350,5279684844847270,4663088298992110,5753494042392980,5211084645732380,5121986125918810,5011388949296350,4867594338695930,4707983552687270,5123528645868900,5212759214761340,5433373922760770,5102240336712350,4882883374382770,5640599378558250,5215242732642280,4649590485209910,4932075507630790,5100302826115060,5464634206062070,5163362743576630,4770589497592340,4964389705643830,4914965842205590,5715756763301220,5735968066424680,4648172136130320,4819709519024610,5679084429166540,5013733055408350,4790801642008180,5525857977265830,5127926133667260,5100646380846830,5516146761486010,5694940273302210,5569890829776100,4828640985950470,5684107599177430,5638137373530050,5075174126155220,4853148115775250,5594689373310990,4867640636410970,4881284441416150,4786277339602300,5748155549018190,5577787396095260,5586887602687980,4641925323018120,5507973868377280,5041907416641290,5201719095298140,4825674623148550,4625799019883130,5449037594170910,5522313519460540,4864689604489960,5744309567305990,4942470266577160,5408998295833120,5396781720964770,4925457705183370,5376538581450450,5389629170348350,4709641643194040,5007456518347920,4784624243404440,5689749601097440,4987381203550820,5118137259660090,5649181136069450,5700958405972250,5557531251359010,4653957806806360,5234534557243500,4926294084868580,4653908721918390,4923513129978230,4929351254532020,4765151080688400,5046754192722190,5432065439265040,5361997430340620,5126666183568660,5346893648927130,5164861145530880,5286000277065040,5045984003091250,5349283903626920,4820383379423170,5521656593533540,5022551439683750,4836149825542970,5315851771029630,5679315692856570,4888953659963610,5699874002701970,5224597269467120,5592328630648820,5594240046200000,4837915727826370,4881816616895190,5439763467096710,5019537641160400,5260925298021060,5326360863090940,4770895690520990,5545034685126660,4762417466808420,5171453613613190,5294200695372990,4643207904089410,4748700062634340,5241308022546930,5647591780623980,5175426680602030,5571569512695700,5285701372402270,5622170533672710,5491859134246950,5522716279663220,5231262729704970,5486492007361240,4724281990204650,4690077344608290,5031000213373850,5638067468359180,4981004017801690,4801009762307740,5337559539455780,4993601785083440,5600702453539440,4764010686703820,5157079235067400,5032918055454510,5378109545535800,5755652418939000,5412465059709310,5698734768960450,5109953444701030,4663816463459370,4809470079588690,4862779305197420,5572540093300690,4713404644751350,5747940977287420,5624851481425810,5351742959288270,5532256281447160,4936196892220770,5338308060839410,5459788079550230,4757975948023450,5463806029965060,5336392008357340,5048491024722270,4963450349767570,4978560027466540,4948638891861310,5276371478360470,5144597298607760,4837142348781790,5403882358939480,5163681409581140,5532679089374570,5175721001016550,5251318506674310,5049533901516990,5619474394748570,4806563307711000,4619076885747160,4701304029601010,5605075853054390,4942997116988370,4672166924336630,5274871889403980,4907321609906470,4841268031241430,5392375849484420,5285526324504960,5296068534587360,4770530051552230,5626933508752050,5322099357325520,4749124429924880,5444633978634920,5005464522030160,4824344965582490,4752635694770750,5585403855512130,5565412217911470,5578031335834790,4783585193785810,4840403491572430,4959541059376810,4685082787081310,5217553720021350,4911773892063250,4843509691793680,5084192133057630,4784185052151140,5759713979273230,4670127650256120,5272666251302630,5712988171920170,5267608512925390,5639874240826160,4663487398750080,5201382984906240,5187432702581940,4693084058354980,5744046470502640,5564257868067070,4660364825312470,5629519807151740,5755485513941580,5723444330386160,5697959441841610,4875761002221010,5122989783154960,5166781230418280,5699246701587910,5353152490801050,5730074163472190,5284836533350380,4840748933619000,5286493147867560,5217719421740770,5458513470577740,5218805203239010,4705613304444120,5586233660306090,4684870195666220,5416374200509960,5606448357509730,4979326174051170,5556170960494820,5539603836404460,5034566596421370,5579850476417770,4808801085207810,4836266226964240,5495378570427350,5108144123190740,5050527665988920,5583885573858380,5515525039608030,5124366021496410,5003768561521400,5508163590472750,4878063129563030,5298362401245570,4755160616007580,5001129869337030,5036084772160240,5522693100270780,5100258769880800,5503430260733230,4927032404199630,5084006911751910,5230006244240920,4797974741103600,4982553829163000,5763186632283150,5316154504597110,4894081858846830,5061007107798410,5309309290197820,5450121191740480,5616048519714500,5094672827766340,5141448722681350,5615459001823550,4972101225407970,5611891948270480,5318041178626950,4841981508670820,5098741556384650,5711527831413340,5498890619510120,5731774513310190,4965774163781910,5216252277202410,4612536731255200,4751809381823140,5738040767833810,4962937473607150,5156235708699610,5314502574696480,4915445651631060,4667955420852630,5041881378800580,5025538729217060,5574597081766170,5274931469396110,5658690634247150,5539810488860890,4889229733896450,5723229160429140,5096107206870230,5387387865359950,4866385368490940,4829393454190630,4703352277523080,4949487009836030,4806719803898840,5507833698770120,4936863111380220,5622865452899310,5527219220485370,5732394694045080,5668524024223510,4943823862538850,5385034207701900,5031117085043910,5565129658231930,4987448648821090,5599009444127970,4862471529159450,5372046956503190,4685641169901750,5489286231991110,5253951082722880,5235906458628780,4712808801038540,5558664760589990,5640731030050890,5496005710938870,5622621846379610,5528103923463030,4738673512724850,5178329580309460,5540484455536490,5147284174321510,5446658033533090,4822556207609960,5453423673922010,5380247581942330,5163038499090690,5266779077348680,4964138480119610,4651056827339500,5204843090577780,5226496049291750,5681173283498980,4611711273168640,5744291156626300,5297593201361630,4845453797507520,5456437743198180,5167711190059880,4802947693278590,4879961447357670,5609641254084510,5431585402602480,5649418268795580,4869205670369850,5462508434644640,5039771827515610,5732768825312500,5188641144085500,4652010683118060,4888682194355760,5212937241134170,4883905292857520,5200975649841640,4880956743078530,5596699811236130,5696081518751280,5111896639793380,5300358536608010,5711978347881160,5256238653920790,5204948655156220,5636396682836140,4978072974781020,5761984423394580,5697989624032790,5034589553940520,5038113909478320,5269369744496700,5071614551176910,5226954423066630,5019420781400250,5453221211463490,5318428093707940,5518256259457230,5721720840173970,5151596243515070,5552068294776410,4670671531008650,4937374994210280,4750541870056080,4927894712885230,5269950328548000,5502876176867320,5146896296445520,5706219486874870,5595136112046460,5219611374671310,5063333107137550,4727192511226250,4731095003204570,5652792306274930,5370013446835490,4779108257012070,5245391087161130,5609365784072760,4892109222202660,5043201378251020,5054466996522180,5699147700096760,5034542583692430,5400039294365530,5212821040668170,4926557324597110,5304313708856070,5583240950800500,4765948314008430,5064529769407930,4867349327440350,5176747884363430,5727476506618050,5265061345186870,5207117307178520,5131907817949960,5739093554656010,5467517583632950,4945612173667450,5663161609697390,4900781068559370,4950264920283750,4723331155640910,5586883646279310,5119171530978410,5367529126841360,5120906098907970,4758292665539040,5566106178376420,4938228150090190,5450019841754310,4831133115845570,5502649123382670,5152108899837360,5347146035682270,5040104727680270,5508241029043530,5728120156785350,5521031905379120,5416704170962610,5683846186298120,5601685935818480,4940898997163450,5076547071919220,5731983293169100,4645102929042060,4848574180582890,5420900682221420,4945624794527720,4876955625073530,5206261079267350,4882763250942410,4888925109055950,4812380177227070,5616315887307620,4675680409821400,5636296837915760,5084431099724700,5356976820723910,5515861443249370,4692969725866210,5150171635712250,5017053563625450,5662404897704450,4985799534719420,4995681911963770,5640068211345380,4634976164463870,5151734620693880,5255021602370030,4737704603677600,5395397451787120,4998472221667450,4645703368818470,5031429162559260,5741260911133040,4961521840654220,5197453157047130,5050748172996270,4949102613220240,5590901384129150,5019977730492710,5002627792120230,5059831249151410,4946097082998720,4984187434081900,5575522762304450,5458546903912810,5593970848835960,5107321792099040,4671761461334490,4846765401854360,4967481326880920,4693017324394930,5678346442873310,5668798342692200,5092886613791170,5171383852495750,5170759535130260,5512779553035560,4942839999779240,5508587426041600,5609834225929870,5267518061038790,4744602994490280,5124780420981470,5266819831751030,4901080381488570,5485158246515830,5553179765872950,5083073846518030,4956383307273690,5178671596694020,5049335110305090,5423951064730660,5758002143422650,5165464709983360,5148508948229990,4652793148488680,4984675603210540,4950804918647180,5016768127512210,4891413965942340,4717009542139340,4650915129533010,4646617780808240,5396813664673840,4800039657734800,5485657324138270,5745175995974270,4729647981906200,5458844184252520,4615859287058550,5121561091031210,4964855926542940,5260843052526150,5048739191727080,5224732820954410,5042770932474110,5374224397848630,5625028120259870,5132162595776320,5491593292540900,5332988703349290,4932742080955160,4910499288142990,4864677422570740,5645191849076360,5349540129514520,4630173254394530,4854263656865680,5363917244105740,4684764911246920,4705890152338650,5033156208947200,4868347260369040,5603866138354710,5737546149897400,5420150665088390,5016511018924920,5553098282138120,5256658284848370,4763259506557450,5278609094237790,4697021483831310,4985950019443270,5202921404023560,5325794103843020,5077329313824030,5420100345086670,5331238323234030,4737598276515980,5643706531574330,4872607452444680,4834841770715660,5134087766791500,4886043269464250,5591056558290260,5759984441113640,4862615776937370,5739297287163290,5444226025832610,4870123584017120,4934347727918770,5528680768235490,4615726100738370,4658370978017190,4917581483247070,4858952812278340,4672600554931560,5669748262907990,4648245404481640,5076614415304210,5399642290817180,5161246018678840,5517255470458720,5587205333044430,5065074215246630,5760800245564500,5163994677433670,4987018283267070,4755668079475090,5285220902505480,5489857662288360,4984718595282830,4763533601567670,5683698320790090,4849746719421890,5546901128821470,5027986155583710,5628877905318500,5500441091047590,5335718756920510,5247667137457130,5316243349637500,5035544954215670,4674814361819390,4794381753831110,5515826864283060,5738962758953050,5278938437659830,5394438580792710,4929571325984470,5588801511589400,5712113231577750,5143461591938130,5054411268322570,5666661717019070,5127118250623800,4628930835622000,5209781894219310,4977008034919620,5042114211875790,5162705927065300,5030772437176120,5657100961019450,5339209123261180,5184389069921510,4841944326579900,4736863141209710,4737078719163460,5281373276753940,4703973019983080,5708434349628550,5684232613986330,5265857089924370,4780979735246810,5226596693925330,5658545766312390,5307640493243180,5272429110043150,5454339433276220,5148085543663070,4733987082588360,4936311733682830,4869600790086550,5231177801581120,4809424854652540,4756844817514210,4769526991270640,5688899391441080,4921917871195170,5724670071778810,4731224417383820,4798692061935040,5536219488804930,5099528024709420,5108599965363900,5577730569912020,5716010588837310,5287074742737140,5723220388782280,5277645613925330,4650138307228610,5660836854886390,5007408953019110,5668387652979030,4860803960728200,4749034098360330,4790714770260240,4769533725197820,5433028090994960,5698192227075480,5753661214350530,4884734758906500,5179158578033590,5360371990107710,5423954631292590,5506285874632580,5632559058384740,5437674171000950,5558765983947080,4661026467507230,4956537184967880,5639732102558850,4927780803149250,5640013560833630,4783294093536550,5383215562583830,4988077065796840,5059527389950200,5723180633216460,4798729838784190,5643672662064070,5444658085039560,5166197957960720,5617055649999970,5473253184836220,4969584219400750,4660419278490060,5744411043927430,5266108058378160,4702556118989360,5638615561730900,5107852970486590,5656874724328730,5162666889161370,5040715894969020,5548989408220000,4857760385873090,5732614925008940,4830450571522780,5121083276078510,4653844301319040,5233564116440740,4796584535660730,5332685107241610,5285786512424840,4906799367910910,5366714827554380,4806606290722070,5596773880586590,5490274157129810,4992984165449980,5763774962652380,5206393315681580,5678533741083910,5304199909894870,5302760709317740,4827211885447080,5035897649123820,5256786590102090,4789065312851480,4874455544363310,5022466083337050,4770733163153590,4863176485895500,4972261927778950,4738858370803120,5745210750525210,5438765412479220,4663515001540140,4677546151931680,5633999726495820,4618808291076160,5476340531819050,5010939054024820,5074532489006380,4906429711275270,5243586508053030,5016122894462210,5272490933943340,4669691093794190,5739051257188420,5744505270043730,4776306008856880,5243019092138140,5019433886797050,5353081474130500,4736410336027420,5193887618766180,4874237616308250,4997476002113790,5050212695445570,4820726922330820,5462796439947500,4839295308360420,4624338955160450,5044731692249480,4800077462533980,5379347535192910,5669458364623080,4830383433117910,5516811650973110,5291326892403860,4852218979705250,4943130819139550,5557927261861660,4772575184651430,4848638541011660,4795885490110010,5534539320591500,4710842457501730,5602974740775010,5477114988266090,5641111511820700,5758423020502750,4788790687239360,4720445953408680,4774868513146210,5671454174091420,5480794218127300,4981808614575760,5277220684516530,4901923406047840,5005510897502940,5167114779669940,4647635395091760,5308678172580830,5498928569316280,5078688873810510,5751929813400720,5296403017050560,5055337426824910,5518162811483600,4907602425647880,5154697905642410,5213944317733810,5098952198170600,5759640707321690,4635278043973750,5691153376555200,4622540668339850,5103304088218140,5711564128148870,4674040523607620,5596369631456630,5596482671099310) 05/12/2024 18:23:41.8935 2876 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/12/2024 18:23:46.6466 3056 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 18:59:56.9464 1457 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/12/2024 19:01:32.4376 1394 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 19:13:11.6780 508 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 19:13:20.5759 1423 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/12/2024 19:21:48.5610 2136 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 19:21:51.1667 2132 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 19:21:56.8795 5886 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/12/2024 19:21:59.8425 1200 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 19:22:03.6991 2104 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 19:24:27.3572 2361 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/12/2024 19:24:30.9887 1868 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 05/12/2024 19:52:18.8042 502 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 3 OR lnsTerId=3) 05/12/2024 19:52:24.8012 690 ms. EXEC: insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (16,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',1,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,1,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,2,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,3,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,4,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,5,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,6,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (17,7,'2023-02-16 00:00:00','2023-02-16 05:59:59',2,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (18,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',3,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (19,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',4,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (20,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',5,50,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (21,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',6,0,119,119,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (22,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',7,100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (23,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',8,0,59,59,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,1,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,2,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,3,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,4,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,5,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,6,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (24,7,'2023-02-16 06:00:00','2023-02-16 21:59:59',9,100,60,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (25,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',10,100,57,57,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,1,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,2,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,3,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,4,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,5,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,6,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (26,7,'2023-02-16 22:00:00','2023-02-16 23:57:59',11,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (27,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',12,-100,1,1,1,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,1,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,2,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,3,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,4,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,5,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,6,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); insert into temp_tariff (tarId,tarDay,tarHourFrom,tarHourTo,tarNumber,tarAmount,tarPeriod,tarPeriodLength,tarPeriodCount,tarDisabled,rulAmountPeriod,rulAmountPeriodDay) VALUES (28,7,'2023-02-16 23:58:00','2023-02-16 23:59:59',13,0,1,0,0,0,0,0); 05/12/2024 19:52:26.9516 798 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 19:52:28.1004 801 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 19:52:28.8599 558 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 05/12/2024 19:52:30.9964 627 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 20:03:18.7549 512 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 20:03:22.2473 1165 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 20:08:02.4791 4685 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-05 20:07:57','V',5576504093233320,2024,'2024-12-05 20:07:43','456297246300327005012999',1,2,16,'I','',1,0,1,'','',4) 05/12/2024 20:08:35.6862 4642 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 20:08:54.6879 4647 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-05 20:08:50','V',4665772378720920,2024,'2024-12-05 20:08:44','456297252400327005012999',1,2,16,'I','',1,0,1,'','',4) 05/12/2024 20:08:54.6919 4657 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/12/2024 20:09:06.3427 6902 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/12/2024 20:09:06.5248 11786 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 05/12/2024 20:09:56.1465 7781 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 20:09:56.1485 6589 ms. OPEN: select * from tabParameters order by parId desc limit 1 05/12/2024 20:10:03.1582 1072 ms. EXECSCALAR: select count(*) from tabTerminalExtraMem where extStatus='V' and extTerId = 2 nr: 1 05/12/2024 20:10:03.1582 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 20:10:03.2993 7027 ms. OPEN: select * from tabDevice where devId = 20001 and devStatus = 'V' 05/12/2024 20:10:11.5868 4483 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-05 20:10:07','V',5516820838576220,2024,'2024-12-05 20:09:49','456297175700327005012999',2,2,2,'O','',0,'2024-12-05 20:10:07',1,'','',0) 05/12/2024 20:10:16.3560 4575 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 20:10:16.3560 4700 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/12/2024 20:10:27.0221 10649 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-05 20:10:16' where payTraUID = 5611332680444540 and payStatus='V' and payEnabled=1 05/12/2024 20:10:31.7863 4762 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-05 20:10:16' where traUID = 5611332680444540 and traStatus='V' and traEnabled=1 05/12/2024 20:11:03.5415 9213 ms. OPEN: show columns from tabParameters where Field = 'parUseCulture' 05/12/2024 20:11:20.9261 34643 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/12/2024 20:16:16.2563 6400 ms. OPEN: select * from tabCustomer inner join abbSubscriptions on subCusId = cusId left join tabAbbGroups on cusAbgId = abgId where subId = 0 and cusStatus='V' 05/12/2024 20:16:45.5809 6482 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 05/12/2024 20:17:00.7721 15190 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 05/12/2024 20:17:01.6596 883 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/12/2024 20:17:13.2104 5322 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 05/12/2024 20:18:29.4194 2527 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 05/12/2024 20:18:55.5078 4637 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-05 20:18:50','V',4728150974571470,2024,'2024-12-05 20:18:47','456297312700327005012999',1,2,16,'I','',1,0,1,'','',4) 05/12/2024 20:19:00.2509 4620 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/12/2024 20:19:23.9998 4701 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-05 20:19:19','V',4805603878998910,2024,'2024-12-05 20:19:00','456297314000327005031999',1,2,16,'I','',1,0,1,'','',4) 05/12/2024 20:19:33.5072 4470 ms. OPEN: select * from tabClass where claPosition = 2 and claStatus='V' 05/12/2024 20:19:38.2513 3579 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 20:19:56.1453 1270 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 20:21:57.2644 1198 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/12/2024 20:50:16.4441 1799 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 05/12/2024 20:57:46.2987 645 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-05 20:57:45' where traUID = 5504754193702440 and traStatus='V' and traEnabled=1 05/12/2024 21:11:17.0958 645 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 21:20:14.2485 560 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 21:21:25.7074 1897 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/12/2024 21:24:54.9126 719 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 21:24:55.6261 557 ms. EXEC: UPDATE payInventory SET invType='N' WHERE invType<>'N' AND invValue IN (100,200,500) AND invDevice IN (42102,42101,42001); 05/12/2024 21:38:00.7963 830 ms. EXEC: update payPayment set payEnabled=0, payDisableTime = '2024-12-05 21:37:59' where payTraUID = 4662291290551180 and payStatus='V' and payEnabled=1 05/12/2024 21:41:22.1912 673 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 21:41:32.4231 656 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5175447899004870,5411815790685320,2024,'2024-12-05 21:41:31',' Date: 12/5/2024 9:38:21 PM Code: 456297522200327005012999 Entry Date: 12/5/2024 8:53:42 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 # 2400417227 ',0) 05/12/2024 22:04:57.7529 533 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 22:09:10.7825 882 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2024-12-05 22:09:09' where traUID = 5561018283074450 and traStatus='V' and traEnabled=1 05/12/2024 22:14:45.1263 928 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 22:16:23.7991 27629 ms. OPEN: show columns from tabParameters where Field = 'parAllowNegativePlaces' 05/12/2024 22:16:23.8131 2157 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 05/12/2024 22:16:24.0263 26089 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 05/12/2024 22:16:30.7358 6942 ms. EXECSCALAR: select count(*) from information_schema.tables where table_schema= 'wisepark_0327' and table_name= 'payInvoiceFtp' nr: 1 05/12/2024 22:17:13.1857 885 ms. OPEN: select * from tabParameters order by parId desc limit 1 05/12/2024 22:17:43.0277 528 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 2 05/12/2024 22:20:34.5548 833 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 22:23:17.5320 638 ms. EXEC: update payReceipt set recCreation = '2024-12-05 22:23:16',recModify = '2024-12-05 22:23:16',recUseId=0,recStatus='V' where recId = 329367 05/12/2024 22:25:01.5457 721 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 22:25:01.9790 723 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 22:29:41.5554 622 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 05/12/2024 22:31:30.7986 509 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 05/12/2024 22:32:17.5959 664 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 22:34:19.9159 519 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 22:58:34.3313 700 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 23:13:49.0874 743 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 23:14:09.8153 730 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 23:31:28.1491 764 ms. EXEC: update tabArea set areFreePark = areFreePark + 1 where areId = 1 05/12/2024 23:31:33.2255 1064 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 05/12/2024 23:33:11.0341 585 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1 05/12/2024 23:42:20.5548 524 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 05/12/2024 23:42:23.4638 561 ms. OPEN: SELECT * FROM payInvoiceFTP WHERE iftStatus NOT IN (@iftStatusSent,@iftStatusNoRetry) ORDER BY iftId LIMIT 1