10/04/2025 08:10:41.3687 2239 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 10/04/2025 09:15:30.9478 875 ms. EXEC: insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-10 09.15.24',5,3,42101,0,50,-76,-3800,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-10 09.15.24',5,3,42101,0,100,-114,-11400,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-10 09.15.24',5,3,42101,0,200,-19,-3800,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-10 09.15.24',5,3,42101,0,500,-9,-4500,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-10 09.15.24',5,3,42101,0,1000,-1,-1000,2,'O','N'); insert into payInventory (invCreation,invUseId,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-10 09.15.24',5,3,42101,1,0,0,0,2,'O',''); update payCurInventory set curQuantity=0,curAmount=0 where curQuantity<0; 10/04/2025 09:24:33.8044 4734 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 10/04/2025 09:24:38.5786 4740 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,'2025-04-10 09.24.33','V',4977069128187470,2025,'2025-04-10 09.24.20','457553386000327005012999',1,2,16,'I','',1,0,1,'','0230003957444',26,0) 10/04/2025 09:24:43.2477 4665 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/04/2025 09:24:47.9989 4690 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/04/2025 09:24:52.7490 4668 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/04/2025 09:24:57.5242 4697 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,'2025-04-10 09.24.52','V',5392172803595870,2025,'2025-04-10 09.24.35','457553320000327005029999',2,2,16,'I','',1,0,1,'','0532370690756',26,0) (WAIT TIME 26 ms.) 10/04/2025 09:26:28.5007 4537 ms. OPEN: select * from tabUserMessage where useMesDescr = 'msg_operator' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 10/04/2025 10:36:45.8604 4741 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/04/2025 10:36:45.8654 4748 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 10/04/2025 10:36:45.8724 4753 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/04/2025 10:37:15.4701 5736 ms. EXECSCALAR: select count(parId) from tabParameters where parFiscalPrinter <> 0 and parStatus='V' nr: 0 10/04/2025 11:23:45.7284 551 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,'2025-04-10 11.23.45','V',5198334633632080,2025,'2025-04-10 11.23.44','457554102400327005012999',1,2,16,'I','',1,0,1,'','',4) 10/04/2025 11:25:53.9083 649 ms. EXEC: insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType) VALUES ('2025-04-10 11.25.53',3,42101,0,500,1,500,2,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+500,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 2 and curValue = 500 and curType = 'N'; 10/04/2025 12:03:57.3027 547 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,'2025-04-10 12.03.56','V',4992895857935440,2025,'2025-04-10 12.03.56','457554130900327005012999',2,2,2,'O','',0,'2025-04-10 12.03.56',1,'','',0) 10/04/2025 13:58:36.9277 679 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 ('2025-04-10 13.58.35',0,'V',5543508096328980,5518295920861590,2025,'2025-04-10 13.58.35',3,1,0,4,'2025-04-10 14.13.35','C','KES',100,100,0,'',' ',' ',1,100,0,0,'',0,0) 10/04/2025 14:13:50.5159 1580 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 10/04/2025 14:13:51.4697 944 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 10/04/2025 14:23:21.9999 1463 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 10/04/2025 14:47:56.9965 1209 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 12 order by traDateTime desc,traId desc 10/04/2025 15:22:50.1337 805 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 10/04/2025 15:36:18.5505 1090 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/04/2025 15:36:44.9533 4700 ms. EXECSCALAR: select count(parId) from tabParameters where parFiscalPrinter <> 0 and parStatus='V' nr: 0 10/04/2025 15:36:49.7015 4693 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/04/2025 15:41:09.2041 576 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/04/2025 15:50:11.5893 1436 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 44 order by traDateTime desc,traId desc 10/04/2025 15:52:41.2502 4699 ms. OPEN: select * from tabArea where areId = 1 10/04/2025 15:57:16.7200 4253 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 2 and terStatus='V' 10/04/2025 16:10:41.3330 515 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 ('2025-04-10 16.10.39',12,'V',4724715201649660,4817051679795730,2025,'2025-04-10 16.10.39',4,1,0,4,'2025-04-10 16.25.39','P','KES',100,100,0,'','','',1,100,0,0,'',0,0) 10/04/2025 16:12:04.2115 518 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 10/04/2025 16:34:24.7991 686 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 21 order by traDateTime desc,traId desc 10/04/2025 17:07:45.2690 4618 ms. OPEN: select * from tabCustomer inner join abbSubscriptions on subCusId = cusId left join tabAbbGroups on cusAbgId = abgId where subId = 156 and cusStatus='V' (WAIT TIME 1 ms.) 10/04/2025 17:07:50.0512 4406 ms. EXEC: update movAnomaly set anmPayed = 1 where anmStatus='V' and anmPayed=0 and anmTrauid in (5583593175522140,5266881910321810,4644925142058870,4777582436031120,5490309871368300,4912362353898240,4788190195218230,5653809407117690,5725476956533320,4966605117555130,5537139579872660,5390599385091540,4661810766936170,5473722764246350,5201514860198920,5276873845449020,5700500494914070,5047109179542190,4762351865296380,5131750575422520,5382802535298670,4960531199968920,4751951663831190,5447854933852560,5000056721874960,4861609804158840,5157959240521430,5493887175937680,5017004472140400,5556464381157270,4616427684949770,4927581898771660,5565804750677970,5243109616852860,4781959171720560,4728118073720800,5336099947524510,4880505106575410,5704555555261490,5684356536933390,5308030258017120,5358391254710490,5525804047195980,4976189743359420,5505470123213110,5749193742992630,5663709129104180,4828976081315570,4836582077355660,5338397567407900,5090902358024030,5283852645455070,5352787851061040,4847528104445890,5729534964296170,5694389389854880,5498214395158540,5501701800141430,5493326848119090,5235045917840410,5593713572681070,5461741724331090,4717533955385870,5030727623414830,5642393826737360,5000994408465610,5637843189008550,5077283243381770,5236121748121030,4688808993296890,5656971889445280,5342698485338420,4683286238649190,5704947433240870,5650207100538080,4769791869796400,4906170637840620,5460440428582610,4807429935642210,5166388692194480,5057675916792440,4636780017258950,5618296825429890,4928055917549660,5522110861265510,5140506905130750,4809236051199230,5385841026562600,5693517886296570,4628076048955310,5639279448527600,4802646163778850,5296571876251760,5184687148635470,5647359048368410,5082485241161810,5290638527440840,5161056770070710,4979524248750390,5761076102524310,5061035880509960,5008093568624400,4726692274529640,4957456826850610,5350813866593660,5322828876317090,5610335517528290,5143236231627430,5463584944005360,5022924310777660,4862071251463620,4801187309562150,5034310290969930,4745186255009760,5201441400090250,4619898505490930,5677042644498110,4710009149140100,4951906427225970,5409615207152460,5706756752088560,5222222693869410,5286923621635040,4743717198928760,5556698257054680,4629360961838460,5282861654420550,5589851091270930,5140885810874550,5398506941323150,4910139361566950,5721495646704630,5030259403135100,5737787649204910,5182250637339780,4838295563106860,4891415725849890,5355331437751490,4931600729505050,5650335692263670,5404842006156540,5237838798056620,4872030991450560,4734161694978230,5325813307268110,5332695910564870,4750139557873030,5196942730039080,5684234989326520,4917457820329320,5367516043157830,5046994935441400,4918261685081390,4710281376051700,5039195723748940,5259055276514620,4916426416828640,4749926011453970,5065976973554840,4975641573130120,4619269380508130,4689030250812810,5316330078100900,5659461634377450,5740296919984690,4817296792323090,5651052057436410,4845985977311610,5146300844258260,5264565486440050,4785524497529360,5174171324496670,5282263222693060,4769057420052160,5071747339225770,5260068476835630,4693649425497670,5055250931481910,5445859730580010,5631176366145680,5759200191475300,4896714835778590,5078316983891830,5365561822214160,5267274780672850,4626042760760060,5047480027592540,4620232008982000,5698425330292810,5343770251617890,4686139930708500,5101427326165130,4695562870332430,5231880948725180,5042038969589170,5424300031287200,5378605305636760,5475666922134070,5169532314254250,5667565813890100,5252493626129690,5720307785783660,5624297077867190,4927258480900970,5381859130673020,4744326350085660,5647683365886440,5289601815061390,5515704287888030,5535637422807980,5456443456895470,5617148513318810,5225187221563770,5098620898748620,5700459771869060,4687677467094810,5432083635012360,5333929199453770,5648041449667940,4965893599114530,4967891386604210,5089111783470730,5364374418062140,4709440917689170,5245827161366150,5202567480242940,5015966130134290,4795139027727770,4897929374785480,5203426235776890,4766237904003910,5388067223677290,5029599594144520,5317061773039650,4698906964016060,4905681194038950,5362513118212820,5724772583687310,4893390051890430,5433920768591540,5334884753844390,4710260217092640,4616739903465170,5563273633128250,4999694194398370,5228656642142930,4740221975804730,5174849338149010,5465223358665890,5395276301570290,4945398707407890,5623495593866040,4671533566561880,4619928994395720,5594900648392430,4654654229552800,5718473442690120,5716702261056070,5275562626763450,4964982293317810,5731295752387540,4779716160887060,5571049303212800,4643430454676020,5688804555023970,4733294968326800,5263778111129700,5413958636916670,5309159918878810,4935298484671670,4648598978701390,4794637104572700,4790075168948220,5595993207980800,4909759389404300,5016878384295440,5063094072876140,5053871114325120,4945782699587460,4729798422576870,5300458874655880,5720869510715570,5203541017890810,5625622510355470,5298567245386300,5586555543237460,5191724907890300,5295861929721600,5453353537058890,4703699512300850,5133861859599510,4783373132903030,4879652613814590,5037882090248680,4927352868200100,5001532519944070,5740143382816820,4970363128941080,4721839757558970,4620267500881080,5665729288914110,5567135883739780,4723393992061140,5056824873974240,5682781458491920,4676573119464710,4760735715318910,5550208072840890,5619100227699650,5650171224613880,5375581558971300,5215859967222720,4828826802619990,5462669886155970,5544649311528490,5400542659839860,5682602394992010,5046369359903970,4630110304837600,5470043108897160,4635424203641870,4855873149175080,4613677313042410,4908783527253580,4631883596285110,5602836945930220,5242171511841150,5039760652007020,5299861791727430,5186386827248330,4675080668772480,4708629823275370,5085123331729410,4641584959613160,5602170686797960,5334475829485660,4826103747534000,5057361547169560,5132641609039840,5156706191281980,4994859239314240,5635523335922030,5665946675965420,5689215630098010,4790676333950150,5214446550182530,4837309257094050,5183694423509780,5708398743221270,5523485792734590,5498802972863100,4646986900842500,4950168463157880,5108535574204660,4938071209911190,5489469082517180,4903872251014530,4890897309949460,5325270495654510,5190350611899550,4703294656418220,5010431196396990,5152067145784490,4799223655053440,5054101280490660,5277537847935270,4935483846578060,5719449452377770,4759566628184960,5229830988793330,4890607119306450,5669423133075610,5328582795178600,4792515852193090,5341250513202270,4865084772953020,5192383995671260,5098531211823300,5181649759246970,4946232466440940,5561605542843930,5373774106488520,5541127864984950,5526438892313080,5046363711909510,4912581428670760,4962502174296140,4768849180694190,4894459251069030,5591243667754150,5048033793679160,5507996510151170,5560088840038890,5612114621231350,4916345229290830,5031305944710790,5696069499890970,4859326067257960,4848037371456150,5644919857550220,5099982325733420,5401256184579790,5402026451792040,5515855841979820,4775952943780650,4943398997571610,5025124364340080,5576202261846690,4796177633858330,5497469747329090,5231603228912060,5514332952841370,4744737438083860,4677336960592720,5419554582135220,5312025177737720,5566245640425880,5394942625691100,5210582910615580,5124755043417620,5673400100541040,4809733670886680,4801532574720490,5092337739579120,5730419031415090,4849190703448720,5440703094348370,5250675325444880,5426965205220750,5358798559724660,4745477308030830,4826522379024500,5032953886637130,5088147543542060,4977700081542060,5185465471911090,5286527657929780,5407855624790710,4692814829115560,4728042996677300,5119091437276930,5031211484159140,4692835682942080,5589490559495040,4823703951257080,4671960014079530,4968459602047210,5313015757665750,4803251267064710,4750031613374140,5602570942563020,5045461125438740,5445924816644740,4958067781453000,5188836812012600,5607644662650770,5573820051996720,4622409615423880,5414024307033950,5554002632350420,5359334006659460,5387843579604730,4925110488226710,5731240102973940,5660977974827740,5541481174384440,4996975309908510,4693306210989730,5010218969690960,4738883586429890,4963012255794840,4670548624458660,5582448384265550,5629149411032560,5324737410865790,4949206731161350,5754263335135040,5011838268935150,4612517516056530,4650242833171050,4905767559786560,4970213264955690,5387340623004160,5262064655551300,4867229744184600,5081491934428940,5428942885405590,5420333220551990,5326939399345160,4644003386389680,4613243609665540,4734232916717430,5324681893598190,5001730441566820,5506959075520410,5083757844010110,5281510634670620,5028602988799250,5215204406540250,5047571315389700,4680365893261610,5436467571748250,4768451923026590,5238223604092800,5484076649630680,5143634736643430,5355031639715500,5621184027147420,5008880063473420,4952834430228310,5001399269879540,4676763255718540,5652943773350410,4948730742652270,4655915463952840,4788132406360710,5309685906545230,4883574488529460,5382827699582240,4878588552191610,4637903256628940,5707351571531730,5038003452922470,5666807370094460,5126964348627150,5488293852443680,5056060345226750,5126855882280690,5199057121783540,5242037555846290,4887940353783020,5649982247163090,5192080351640210,5070618937135940,4805784946234390,5470948021858570,4629154647652140,5578438158495640,5653897476252480,5730352378251200,4843464388716190,5461136355643510,5454381437942660,5058799653557010,4672485225739680,5207165977515190,5013626282362320,4945227799246740,5654745534496600,5008180833268060,5166850328688330,4984478482489050,4792885108886110,4930128877643600,4741419012420430,4621918198146260,4724274283513500,5698728489154080,4827119476098330,5257567680956010,5161571508883750,5625704667275490,5599000686462870,4912426804978400,5347396362684710,5433958834684660,5347738845008010,5504527170098480,4681979120940350,5434277412906460,5118955504354600,4712194846025000,5239726037718090,5076956936724710,5145897196172680,4894512203635540,5308473307945210,4729110148749310,4669503701094440,5513750928216090,5698745068841700,5509451058670140,5759006980744750,5681480202943080,4831116837017580,5211897106219290,4653735165298420,4711141097936590,5672466401922540,4916132791827420,5622096059755890,4933297098444050,5593219128542390,5063908643474200,5499243336853570,4827480033136460,5721099748972880,4928736416623600,5314782505775970,5039938750182820,5040219849898730,5461284013739410,5721755051583880,4746818076857120,5170481053925610,4775568579027560,5313503763890520,4928008361421720,4813753965700870,4670341500612500,5167477339743780,5472331467094610,5116695828960910,5095039788470740,5671412037309310,5133363380134590,5273545973089520,5398980397962570,5213673388564640,5246322303180170,5726602370986070,5580710065933430,5210051357521290,5248408259775620,5564705189100450,4851304425124700,5400188818771290,5675850543225380,5364373546784930,5148650483516260,5650293173644460,4628154354691710,5377479362753180,5393456394611940,5585883811484520,5587194558915620,5688682405843140,4797557913953570,5627977853703220,5479060009510560,5683931411291850,5251367119907690,4628372934561240,4741915983400150,5202060269889880,4627420120388750,5223550877321380,5448688765932000,5089011891655110,5758810195880900,4806436067326550,5458461925002760,5437183928734670,4782225541293870,5332938582016110,5083141523869220,4884383360111920,5058281732088490,4836034976967010,5109430415539670,5550898379327990,5132848650688870,5214647748752360,4949384356843150,5183760532360860,5466105573201270,4892084772554700,5528392040034250,5020193721579030,5528873984002480,5540210770285710,5292308583824950,5532561567880820,4636408958482480,5756424572398560,5095838046005170,4792122468359240,5139557317883300,5187237993687160,5287296725533230,5008671278366890,5314143384641310,5118247541845430,4818719232374720,5705640249312590,5073326143944150,5479163244668330,4636200737845860,5429824042426020,5026391202243290,4883950955543580,5609012475172630,5023201071897700,5266832910687460,5452432074839580,5714684490299720,5564433359671200,5240771730415150,5033818850734320,4846051785098560,4762937805478510,4868333554392980,5454125608951660,4815501053888540,5156972398814550,4828029146000350,5381866042128490) 10/04/2025 17:08:15.9715 5228 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 10/04/2025 17:08:20.7216 4693 ms. EXEC: update abbSubscriptions set subCredit = round(subCredit-0,5),subLastDebit = '2025-04-10 17.08.16' where subId = 200 10/04/2025 17:08:27.8474 6961 ms. OPEN: select * from movtransit where traUID = 5230015619082650 and traStatus='V' 10/04/2025 17:08:53.9738 4631 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/04/2025 17:08:53.9938 4652 ms. OPEN: select * from movTransit where traStatus='V' and traEnabled = 1 and traCarId = 185 10/04/2025 17:09:08.2223 4635 ms. EXEC: update abbCards set carLastDate = '2025-04-10 17.09.03',carLastDirection='O' where carStatus='V' and carId = 185 10/04/2025 17:09:27.2340 4734 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,'2025-04-10 17.09.22','V',5219690373555790,2025,'2025-04-10 17.08.23','457555979500327002029999',2,1,2,'O','',1,0,1,'','1301662587622',185,0) 10/04/2025 17:09:31.9711 4733 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/04/2025 17:09:31.9901 9437 ms. EXECSCALAR: select claId from tabClass where claPosition = 2 and claStatus='V' nr: 2 10/04/2025 17:09:36.7223 4567 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/04/2025 17:10:11.1633 20137 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,'2025-04-10 17.09.51','V',4955317249348650,2025,'2025-04-10 17.09.30','457556177000327005031999',1,2,16,'I','',1,0,1,'','',4) 10/04/2025 17:10:11.1703 19970 ms. OPEN: select ticId from tabTicketType where ticStatus='V' and ticType = 1 10/04/2025 17:10:16.0365 4869 ms. EXEC: INSERT INTO movTransitPlates (trpTraId,trpPlate,trpConfidence,trpImage) VALUES (@trpId,@trpPlate,@trpConfidence,@trpImage) 10/04/2025 17:10:20.6616 4513 ms. OPEN: SELECT * FROM movLinks INNER JOIN movTransit on traUID = mliTraUID WHERE mliRFIDCode = '457556177000327005031999' AND mliStatus='V' ORDER BY mliId DESC LIMIT 1 10/04/2025 17:10:39.6743 14085 ms. OPEN: select * from tabParameters order by parId desc limit 1 10/04/2025 17:10:44.4314 4601 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 10/04/2025 17:12:13.8781 4682 ms. OPEN: select * from movtransit where tracode=@TRACODE and trastatus='V' and traenabled=1 order by traDateTime desc limit 1 10/04/2025 17:12:23.3804 4633 ms. EXECSCALAR: select terAddress from tabTerminal where terId = 1 nr: 1 10/04/2025 17:12:28.1286 4695 ms. EXEC: update payReceipt set recCreation = '2025-04-10 17.12.23',recModify = '2025-04-10 17.12.23',recUseId=0,recStatus='V' where recId = 369477 10/04/2025 17:12:28.2787 4791 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/04/2025 17:12:32.8777 4587 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-10 17.12.28',3,42101,0,200,1,200,1,'I','N'); update payCurInventory set curQuantity=round(curQuantity+1,5),curAmount=round(curAmount+200,5) where curTerId = 3 and curDevCode = 42101 and curChannelId = 1 and curValue = 200 and curType = 'N'; 10/04/2025 17:12:42.3791 4629 ms. OPEN: select * from tabParameters where parStatus='V' order by parId desc 10/04/2025 17:12:52.0145 18944 ms. EXEC: insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-10 17.12.33',0,0,'V',5074238212515380,5483348761922330,2025,'2025-04-10 17.12.33',3,'KES',-1,50,-50,'N',''); insert into paycash (casCreation,casModify,casUseId,casStatus,casUID,casTraUID,casYear,casDateTime,casIdTerminal,casCurrency,casNumber,casSingleAmount,casTotAmount,casType,casDescription) VALUES ('2025-04-10 17.12.33',0,0,'V',5074238212515380,5483348761922330,2025,'2025-04-10 17.12.33',3,'KES',-1,100,-100,'N',''); 10/04/2025 17:12:56.8797 4722 ms. EXEC: Insert into payinventory (invCreation,invTerId,invDevice,invCode,invValue,invQuantity,invAmount,invChannel,invDirection,invType)VALUES ('2025-04-10 17.12.33',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 ('2025-04-10 17.12.33',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'; 10/04/2025 17:13:11.1252 14217 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' 10/04/2025 17:14:17.3784 4523 ms. OPEN: select * from tabcustomer inner join abbsubscriptions on subCusId = cusId inner join abbcards on subId = carSubId where carId = 0 10/04/2025 17:14:31.6289 4528 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/04/2025 17:14:36.3791 4526 ms. OPEN: select * from tabUserMessage where useMesDescr = 'msg_welcome' and (useLanCode = 'en-US' or mid(useLanCode,1,2) = 'en') 10/04/2025 17:14:36.4541 4624 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/04/2025 17:14:41.1292 4681 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,'2025-04-10 17.14.36','V',5595808202596900,2025,'2025-04-10 17.14.22','457556206200327005012999',1,2,16,'I','',1,0,1,'','0230003944059',13,0) 10/04/2025 17:14:45.8784 4655 ms. EXEC: update abbCards set carLastDate = '2025-04-10 17.14.41',carLastDirection='I' where carStatus='V' and carId = 13 10/04/2025 17:14:50.6326 4748 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 10/04/2025 17:14:55.5999 9566 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/04/2025 17:15:04.9561 4761 ms. OPEN: select parVatRate,parVatName,parVatMethod,parVatRound,parVatDiscount from tabParameters where parStatus='V' order by parId desc limit 1 10/04/2025 17:15:09.6282 4572 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/04/2025 17:15:14.3784 9324 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/04/2025 17:15:19.1286 4624 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/04/2025 17:15:46.3327 65016 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 76 ms.) 10/04/2025 17:22:31.2544 4017 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 10/04/2025 17:22:36.0086 4059 ms. EXEC: update abbCards set carLastDate = '2025-04-10 17.22.31',carLastDirection='I' where carStatus='V' and carId = 44 10/04/2025 17:22:45.5379 4182 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/04/2025 17:22:59.7904 4577 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,'2025-04-10 17.22.55','V',5302995101175810,2025,'2025-04-10 17.22.49','457555392000327001012999',2,2,2,'O','',0,'2025-04-10 17.22.55',1,'','',0) 10/04/2025 17:22:59.8535 4614 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/04/2025 17:23:47.0980 4041 ms. OPEN: SELECT * FROM tabuser WHERE useBadId<>'' AND (useBadId = '300142' OR useBadId = '300142') 10/04/2025 17:24:06.0986 4434 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 1 OR lnsTerId=1) 10/04/2025 17:24:44.8785 5334 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/04/2025 17:25:32.3802 4628 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-10 17.25.27',1,2,'2025-04-10 17.25.27','','Send command to entry/exit units: Command OPEN on Device Exit 1 ') 10/04/2025 17:25:41.8805 3155 ms. EXEC: INSERT INTO movOperator (opeCreation,opeUseId,opeTerId,opeDateTime,opeCode,opeDescription) VALUES ('2025-04-10 17.25.38',0,2,'2025-04-10 17.25.38','','Unauthorized Transit Exit 1') 10/04/2025 17:25:51.4269 8550 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 (WAIT TIME 31 ms.) 10/04/2025 17:26:01.0193 4782 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 2 OR lnsTerId=2) 10/04/2025 17:26:15.2677 4212 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-10 17.26.10' where traUID = 4867837077424850 and traStatus='V' and traEnabled=1 10/04/2025 17:31:14.1793 3608 ms. OPEN: select * from movtransit t where traCode = '457556070600327005012999' and t.traStatus='V' and t.traDirection='I' and (t.traAreId = 1 OR t.traAreid = 0) order by t.traId desc limit 1 10/04/2025 17:31:24.8635 5855 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,'2025-04-10 17.31.19','V',5424261775327220,2025,'2025-04-10 17.31.10','457556070600327005012999',2,2,2,'O','',0,'2025-04-10 17.31.19',1,'','',0) 10/04/2025 17:32:03.8174 2035 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/04/2025 17:34:03.2220 3597 ms. OPEN: SELECT * FROM movTransit WHERE traStatus=@traStatus AND traCode=@traCode AND traDirection=@traDirection ORDER BY traDateTime,traId 10/04/2025 17:38:36.8816 556 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 19 order by traDateTime desc,traId desc 10/04/2025 18:18:27.1949 4741 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 3 10/04/2025 18:24:57.4386 564 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 10/04/2025 18:39:00.7842 562 ms. OPEN: select traId,traDateTime,traEnabled,traDisableTime,traCode,traBadge,traCarId,traAreId,traIdTerminal from movtransit where traStatus='V' and traDirection = 'I' and traCarId = 14 order by traDateTime desc,traId desc 10/04/2025 18:48:11.6550 5241 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 = 9 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 10/04/2025 21:08:41.9585 1765 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 10/04/2025 21:09:05.7355 1733 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/04/2025 21:19:44.1336 4039 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 10/04/2025 21:19:59.1798 676 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 10/04/2025 21:20:08.6802 607 ms. OPEN: select * from tabArea where areStatus='V' and areEnabled = 1 AND areId = 1 10/04/2025 21:21:24.2429 988 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 10/04/2025 21:21:24.2439 987 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 10/04/2025 21:21:33.4830 7240 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/04/2025 21:21:36.2338 2126 ms. OPEN: SELECT * FROM tabLanes INNER JOIN tabLanesSlaves ON lneId = lnsLneId WHERE lneStatus='V' AND lnsStatus='V' AND (lneTerId = 16 OR lnsTerId=16) 10/04/2025 21:22:14.8136 691 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 6 10/04/2025 21:31:29.9827 4744 ms. OPEN: select terSendConfig from tabTerminal where terAddress = 5 and terStatus='V' 10/04/2025 21:31:34.7369 4755 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 ('2025-04-10 21.31.21',0,'V',5047544808904530,5535539302402940,2025,'2025-04-10 21.31.21',3,1,0,4,'2025-04-10 21.46.21','C','KES',50,100,50,'',' ',' ',1,50,0,0,'',0,0) 10/04/2025 21:32:52.9019 9121 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); 10/04/2025 21:32:53.9346 767 ms. EXEC: update movTransit set traEnabled=0, traDisableTime = '2025-04-10 21.32.53' where traUID = 5535539302402940 and traStatus='V' and traEnabled=1 10/04/2025 21:33:02.8577 570 ms. OPEN: select sum(crc32(terDescription)) as vCheck from tabTerminal 10/04/2025 21:33:05.8997 3042 ms. OPEN: select sum(crc32(devDescription)) as vCheck from tabDevice 10/04/2025 21:33:14.9258 766 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 5 10/04/2025 21:33:19.0185 3683 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 1 (WAIT TIME 1080 ms.) 10/04/2025 21:33:19.0315 3014 ms. OPEN: select * from tabarea where areStatus='V' and areId = 1 (WAIT TIME 1091 ms.) 10/04/2025 21:34:19.9646 1540 ms. OPEN: select sum(casTotAmount) as vTot from movTransit inner join payCash on payCash.casTraUID = movTransit.traUID inner join tabTerminal on terId = casIdTerminal where traCode = '457557653400327005012999' and traStatus='V' and casStatus='V' and terType=3 and casTotAmount>0 10/04/2025 21:49:22.7175 4730 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0 10/04/2025 21:49:32.2208 2571 ms. OPEN: select * from tabterminal where terStatus = 'V' and terEnabled=1 and terAddress = 7 10/04/2025 22:05:49.7703 4854 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,'2025-04-10 22.05.44','V',5200787994242330,2025,'2025-04-10 22.05.40','457557954000327005012999',1,2,16,'I','',1,0,1,'','',4) 10/04/2025 22:05:55.5212 5516 ms. OPEN: SELECT * FROM tabTerminalExtraMem WHERE extStatus=@extStatus AND extTerId = @extTerId 10/04/2025 22:06:19.3170 2665 ms. OPEN: select * from tabDevice where devId = 2 and devStatus = 'V' 10/04/2025 22:42:44.6670 1277 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 10/04/2025 22:51:04.1013 4802 ms. EXECSCALAR: select count(0) as vTot from tabParameters where parPlateReading<>0 nr: 0