Query Metrics
203
Database Queries
20
Different statements
323.25 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
234.97 ms (72.69%) |
179 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address_id AS address_id_3 FROM address_variation t0 WHERE t0.address_id = ?
Parameters:
[
"750033"
]
|
|
31.59 ms (9.77%) |
2 |
SELECT t0.id AS id_1, t0.name1 AS name1_2, t0.name2 AS name2_3, t0.street1 AS street1_4, t0.street2 AS street2_5, t0.country AS country_6, t0.zip AS zip_7, t0.town AS town_8, t0.tel AS tel_9, t0.fax AS fax_10, t0.email AS email_11, t0.quick_hash AS quick_hash_12, t0.fixed AS fixed_13, t0.note AS note_14, t0.variations AS variations_15, t0.isocountry AS isocountry_16, t0.mobile AS mobile_17, t0.tel2 AS tel2_18, t0.fax2 AS fax2_19, t0.email2 AS email2_20, t0.mobile2 AS mobile2_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25 FROM address t0 WHERE t0.quick_hash IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "at1220wiensestadstrase10" "at3352strasepeterinderauanderbahn3" "at4021linzschachermayerstrase2a" "at6830rankweillangase1" "at7411marktalhauhartbergerstrase23" "at8055grazgradnerstrase60" "at8160weizklamstrase24" "at9063mariasallogistikpark1" "be2830wilebroekbrielen1" "be3980tesenderlokanalweg12" "be9000gentlangerbrugestrat104" "be9700oudenardewestering17" "cz25724prahalibussazavalogparkhalab" "cz561 66techoníntechonin1" "de01099dresdenfischaustrase17" "de01099dresdenkoenigsbrueckerstrase124" "de01156dresdenamerlengrund13" "de01159dresdentarandterstrase38" "de01189dresdenstutgarterstrase7" "de01237dresdenseidnizerweg10" "de01458otendorfokrilaegerstrase57" "de01458otendorfokrilageldroperstrase51" "de01458otendorfokrilaschuterwaelderstrase224" "de02694groádubrauhermanschomburgstrase6" "de02733cunewaldeneudorfstrase13" "de02736opachmitelweg6" "de02763zitaugerharthauptmanstrase15" "de02827grlizpaulmuehsamstrase1" "de03130sprembergtuchmacherale6" "de03222luebenaugrosradenerhaupstrase16" "de04103leipzigaltemese2" "de04103leipzigegebrechstrase1" "de04109leipziggrimaischestrase10" "de04177leipzigcotaweg7" "de04178leipzigmiltizerstrase13" "de04229leipzignaumburgerstrase162" "de04347leipzigamazonstrase1" "de04356leipzighandelstrase10" "de04416marklebergstaedtelnerstrase" "de04416marklebergstaedtelnerstrase54" "de04420markranstaedtamglaeschen1" "de04509wiedemarhansgradestrase4" "de04720dbelnhermanotoschmidtstras" "de04720doebelnhermanotoschmidtstras" "de06112haledieselstrase19" "de06179angersdorfanderlauchstaedterstrase7" "de06179teuschentalanderlauchstaedterstrase7" "de06184kabelsketalorionstrase4" "de06184kabelsketalorionstrase6" "de06188landsbergdelizscherstrase6" "de06217merseburgkolenbeyerweg2d" "de06667leislingammarktwege2" "de06667weisenfelsammarktwege2" "de06869coswigambrenickel2" "de07338leutenbergameichbergflauer1" "de07616serbahintermteiche1" "de07819triptisimbreselsholze14" "de07819triptisimkaelbertale1u" "de08248klingentalauerbacherstrase282" "de08412werdaumuehlenstrase6" "de09111chemnizinereklosterstrase13" "de09114chemnizbornaerstrase205" "de09212limbachoberfrohnajohaneschestrase30" "de09232hartmansdorfkomsaale1" "de09322penigratendorferstrase" "de09390bahnhofstrase18" "de09399niederwürschnizfabrikweg8" "de09526olbernhaufreibergerstrase308" "de09648mitweidaaltenburgerstrase38" "de10249berlinhermanblankensteinstrase4" "de10365berlingotlindestrase93" "de10365berlinherzbergstrase123" "de10365berlinjoseforlopstrase5" "de10553berlinreuchlinstrase101" "de10559berlinelenepsteinstrase2" "de10719berlinkurfuerstendam1" "de10789berlintauenzienstrase9" "de10961berlinmehringdam13" "de12349berlinbuckowerdam79" "de12357berlinkanalstrase17" "de12357berlinkoepenickerstrase424" "de12489berlinamstudio1" "de12526berlinalexandermeisnerstrase848" "de12526berlinalexandermeisnerstrase8486" "de12526berlinalexandermeisnerstrase868" "de12681berlinmeranerstrase19" "de12681berlinwolfenerstrase3234" "de13127berlinarkenbergerdam1" "de13357berlinpankstrase3239" "de13439berlinquickbornerstrase40" "de13507berlinamborsigturm2" "de13509berlinjacobsenweg41" "de13627berlinschwanenfeldstrase1" "de14478posdamambuchorstrase40" "de14554sedinerseamfuchsbau2" "de14612falkenseleibnizstrase7a" "de14656brieselanggartenstrase1" "de14656brieselanghavelandstrase6" "de14772brandenburgfriedrichshafenerstrase1" "de14772brandenburgjasminweg4" "de14772brandenburgupstalstrase13" "de14929treuenbriezenschmoegelsdorferringstrase15" "de14947nuteurstromtalloewendorferstrase12" "de14974ludwigsfeldealfredkuehnestrase1" "de14974ludwigsfeldeambirkengrund12" "de14979grosberenhaupstrase14" "de14979grosberenosdorferring5" "de15745wildaugewerbepark1" "de15749mitenwaldezuelowstrase7" "de15834rangsdorfmaulberstrase13b" "de15834rangsdorfmitenwalderstrase8" "de15834rangsdorfreihersteg34" "de15913straupizbahnhofstrase35a" "de15926luckauzumwinkel2" "de16303schwedtlandgrabenpark1" "de16515oranienburglehnizstrase7098" "de16567mühlenbeckkastanienale36" "de16727oberkrmerhaupstrase10" "de16816neurupinmartinebelstrase4" "de17109deminwoldeforsterstrase5" "de18196kavelstorfsildermor7" "de20097hamburgbankstrase28" "de20457hamburghermanblohmstrase3" "de20539hamburgmuehlenhagen85" "de21031hamburghavighorsterweg6" "de21079hamburg1hafenstrase10" "de21079hamburggrosmorbogen5" "de21079hamburgmorburgerbogen12" "de21107hamburgreiherstieghauptdeich3947" "de21109hamburgbeimschroederschenhof7" "de21129hamburgaltenwerderhaupstrase5" "de21147hamburgheykenaukamp20" "de21218sevetalbeckedorferbogen7" "de21218sevetalpostweg215" "de21266jesteburgbrueckenstrase10" "de21279wenzendorfwalterblohmstrase2" "de21337lueneburgfriedrichpenselerstrase28" "de21337lüneburgfriedrichpenselerstrase28" "de21357bardowickdaimlerstrase8" "de21397vastorfgewerbegebiet1" "de21465reinbeksenefelderring14" "de21465wentorfimenberg1" "de21493elmenhorstleinewebering15" "de21629neuwulmstorfamholz2a" "de21723holerntwielenfletholernstrase159" "de22113hamburgbredowstrase17" "de22113hamburggrusonstrase40" "de22113hamburgliebigstrase103" "de22143hamburgvictoriale1" "de22145brakbrakerbogen24" "de22145brakbrokstrase15" "de22177hamburgfabriciustrase105a" "de22335hamburgobenhaupstrase1" "de22359hamburgeulenkrugstrase190" "de22525hamburgmelanchtonstrase27" "de22525hamburgwinsbergring12" "de22529hamburglokstedtersteindam3" "de22769hamburghaferweg24" "de22844norderstedtmuehlenweg14" "de22885barsbuetelrahlstedterstrase1a" "de22885barsbütelaltesfeld14" "de22962siekjacobsrade321" "de23556lübeckgrapengieserstrase20" "de23556lübeckherenholz1" "de23556lübecksteinbrueckerstrase24" "de23569lübeckdaenischburgerlandstrase85" "de23730neustadtindustrieweg13" "de23795badsegebergefeustrase19" "de23795badsegebergjaguaring7" "de23795badsegebergziegelstrase1" "de23843badoldesloeroegen52" "de23843badoldesloesandkamp14a" "de24145kielborsigstrase19" "de24220flintbekkonradzusering5" "de24223schwentinentalgutenbergstrase4850" "de24376grdersbyambahnhof6" "de24537neumnsterrendsburgerstrase8486" "de24537neumuensterneuenbrok6" "de24558henstedtulzburggutenbergstrase9a" "de24558henstedtulzburgrudolfdieselstrase1214" "de24568kaltenkirchenaufdemberge1" "de24568kaltenkirchenhansstockmarstrase8" "de24649beverloh2" "de24782buedelsdorfamfriedrichsbrunen2" "de24837heinrichherzstrase16" "de24837schleswigflensburgerstrase63" "de24866busdorftorshamer12" "de24941flensburgschleswigerstrase101" "de24941flensburgschleswigerstrase130" "de24941flensburgwesterale153" "de24941flensburgwitenbergerweg14" "de24976handewitwedingheidelandostrase8" "de24983handewitambahnhof20" "de24983handewitheidelandostrase8" "de25469halstenbekgewerbering913" "de25497prisdorfpeinerhag6" "de26135oldenburganderschmiede4" "de26135oldenburgaugustwilhelmkuehnholzstrase" "de26135oldenburgaugustwilhelmkuehnholzstrase8" "de26209hatenmuehlenweg57" "de26215wiefelstedescholpad1" "de26388wilhelmshavenatlantik1" "de26388wilhelmshavenpreusenstrase14ac" "de26389wilhelmshavenheuweg2" "de26441jeverlinumweg18" "de26605aurichkorbweidenstrase19a" "de26789lerindustriestrase3a" "de26810westoverledingen" "de26892hedegrenenergypark3" "de26901rastdorfgewerbering1" "de27404elsdorfaufderbroke1" "de27404heslingenimdorf5" "de27419sitensenhansestrase14" "de27419sitensenhansestrase17" "de27612loxstedtdorfstrase41" "de27755delmenhorstsestrase7" "de28197bremenerichkuehlmanstrase4" "de28207bremenstresemanstrase13" "de28217bremeneduardsulingstrase17" "de28217bremenhafenstrase1" "de28259bremenbauerland4" "de28307bremenwaltergerdesstrase14" "de28307bremenwaltergerdesstrase7" "de28816stuhrdiepholzerstrase97" "de28816stuhrimmer2" "de28816stuhrwulfhoperstrase15" "de28832achimindenelern27" "de28832achimmaxnaumanstrase1" "de28844weyhemitelwendung27" "de28870otersbergpostausen1" "de28876oytenmargaretesteifstrase12" "de29525uelzenimneuenfelde60" "de29690bucholzanderautobahn35" "de29690schwarmstedtwerkstrase4" "de30179hanovermaxmuelerstrase" "de30855erdingerstrase1" "de30855langenhagenmuenchnerstrase4" "de30900wedemarkamkraehenberg3" "de30916isernhagenopelstrase9" "de30926selzecarolineherschelstrase7" "de31157sarstedtkarlschilerstrase246" "de31180giesenkampstrase14" "de31515wunstorfadolfoesterheldstrase28" "de31603diepenausiemensweg1" "de32105badsalzuflenwerlerstrase60" "de32120hidenhausenherforderstrase240" "de32257buendebahnhofstrase81" "de32351stemwedeopenweherstrase68" "de32427mindenringstrase9" "de32584lhnezuraltenwere7" "de32584löhneloehnerstrase202" "de32602vlotomoelbergerstrase20" "de32657lemgomasbrucherweg25" "de32758detmoldamoberenfeld3" "de32758detmoldwindmeierweg12" "de32791lagedaimlerstrase42" "de32791lageimselenkamp12" "de33014baddriburgindustriestrase21" "de33106paderbornpamplonastrase2" "de33106paderbornstetinerstrase34" "de33333gueterslohreinhardmohnstrase2" "de33428harsewinkelgotliebdaimlerstrase1" "de33689bielefeldindustriestrase7" "de33719bielefeldludwigerhardale3" "de33719bielefeldludwigerhardale40" "de33729bielefeldremusweg8" "de34123kaselheinrichherzstrase47" "de34123kaselheinrichherzstrase54" "de34123kasellilientalstrase25" "de34123kaselotohahnstrase20" "de34134kaselknorstrase28a" "de34225baunatalfehrenbergerstrase2" "de34253lohfeldenotohahnstrase16" "de34277fuldabrueckalberteinsteinstrase4" "de34277fuldabrueckostring424" "de34323malsfeldamhebelbach2" "de34355staufenbergvorderhecke13" "de34379caldenoberweg21" "de34497korbachraifeisenstrase" "de34537badwildungenilbruckstrase1" "de34560frizlarberlinerstrase1" "de35039marburgafoelerstrase98" "de35108alendorfviesmanstrase1" "de35260stadtalendorfamplausdorfertor13" "de35394giesenstolzenmorgen15" "de35415pohlheimampfahlgraben410" "de35440lindenphilipreisstrase23" "de35440lindenrobertboschstrase21" "de35440lindensiemenstrase8" "de35447reiskirchengartenweg23" "de35452heuchelheimludwigrinstrase49" "de35510buzbachammagnapark35" "de35576wezlardilfeld2" "de35576wezlardilfeld21" "de35576wezlarhermansteinerstrase404" "de35630ehringshausendaubhaeuserstrase17" "de35708haigerdaimlerstrase8" "de35708haigerhansastrase10" "de35708haigerhohleichenrain6" "de35708haigersechsheldenerstrase12" "de35719angelburginderwer1" "de35745herbornaufdemstuezelberg" "de35745herbornschoenbacherhaupstrase16" "de36110schlizameichberg1" "de36124eichenzelbuergermeisterschlagstrase1014" "de36179bebrainderlache8" "de36214nentershausenmaxrain2ecketueringer" "de36251badhersfeldindengiesen21" "de36251badhersfeldwipershainerstrase41" "de36282hauneckblaueliede14" "de36329romrodzelerstrase28" "de37081goetingengronersiekanger3" "de37124rosdorfaufderfeldscheide2" "de37170uslarbleichstrase63" "de37318uderuntereaue8" "de37351dingelstdtwachstedterstrase13" "de37671hoxterpfenigbreite4" "de38539muedenhandelsweg5" "de38723sesenjohanisweg25" "de39171sülzetallangegoehren7b" "de39171sülzetalueberderdingelstele" "de39326hermsdorfamknuehl1" "de40233dueseldorferkraterstrase173" "de40629dueseldorfludenbergerstrase1" "de40699erkratmaxplanckstrase30" "de40721hildenelerstrase101" "de40721hildenforstrase1a" "de40721hildenimhuelsenfeld10" "de40721hildenimhuelsenfeld17" "de40721hildenimhuelsenfeld17fbaabholung" "de40721hildenwestring17" "de40721hildenwestring9" "de40764langenfeldcarlleverkusstrase1517" "de40789monheimamknipraterbusch1" "de40789monheimrobertboschstrase1" "de40878ratingenamsandbach28" "de40885ratingenandendieken94" "de41061moenchengladbacherzbergerstrase6175" "de41063mönchengladbachmiclogistikgmbh" "de41065moenchengladbachlueriperstrase123" "de41066mãnchengladbach" "de41066moenchengladbachkrefelderstrase845" "de41066moenchengladbachmiclogistikgmbh" "de41179mnchengladbachhamburgring1" "de41179moenchengladbachhamburgring1" "de41179mönchengladbachhamburgring1" "de41199moenchengladbachhansmartinschleyerstrase" "de41199moenchengladbachhansmartinschleyerstrase21" "de41363polostrase1" "de41516grevenbroichanderglashuete1" "de41540dormagenhamburgerstrase32" "de41542dormagenotoschotstrase1" "de41564karstdaimlerstrase27" "de41564karstgirmeskreuzstrase5" "de41748viersenkraenkelsweg2" "de41812erkelenzgewerbestrasesued10" "de41836hückelhovenwankelstrase9" "de41836hueckelhovenamlandabsaz6" "de41849wasenberggrafgerhardstrase38" "de42109wupertaluelendahlerstrase479" "de42279wupertaleichenhoferweg71" "de42285wupertalschwesternstrase58c" "de42327wupertalesenerstrase60" "de42551velbertfriedrichstrase5" "de42551velbertsiemenstrase21" "de42859remscheidberghauserstrase40" "de42897remscheidjaegerwald2830" "de42897remscheidkarlstrase8b" "de42929wermelskirchenalberteinsteinstrase79" "de44143dortmundaltestrase59" "de44145dortmundweisenburgerstrase73" "de44147dortmundkanalstrase80" "de44147dortmundwestfaliastrase191" "de44149dortmundberatgerstrase36olivanderein" "de44149dortmundhoefkerstrase30" "de44149dortmundwulfshofstrase202" "de44149wulfshofstrase14" "de44319dortmundhildebrandstrase19" "de44357dortmundbreisenbachstrase102" "de44379dortmundgermaniastrasegaragenr2682" "de44575castroprauxelamfoerderturm1012" "de44575castroprauxelbladenhorsterstrase14" "de44581castroprauxelamrapensweg171" "de44791bochumkarllangestrase49" "de44793bochumcarolinenglueckstrase3" "de44793bochumesenerstrase20" "de44793bochumesenerstrase24" "de44866bochumhansastrase12124" "de44866bochummaerkischestrase8" "de44894bochumhaupstrase63" "de45127esenx" "de45133esenteodoraltofstrase2" "de45136esenmaxkeitstrase6" "de45139esenaufderdonau15" "de45143esenhaedenkampstrase1" "de45279esenkleineruhrau20" "de45329esennordsternstrase25" "de45478muelheimweselerstrase46" "de45478muelheimwisolstrase543" "de45525hatingenruhrale5" "de45699hertenfriedrichbergiusstrase26" "de45739oererkenschwickholtgarde30" "de45881gelsenkirchenscheutensolarstrase2" "de45888gelsenkircheneuropastrase14" "de45891gelsenkirchenemscherstrase56" "de46145oberhausenrevierstrase9a" "de46149oberhausenhagelkreuzstrase13" "de46149oberhausenmaxeytstrase2" "de46242botropamrheinhernekanal5" "de46242botropoberhausenerstrase20" "de46325borkengelsenkirchenerstrase1" "de46395bocholtdingdenerstrase19" "de46395bocholtharderhok19" "de46395bocholtliebauweg32" "de46395bocholtschlavenhorstrase72" "de46395bocholtuphof5" "de46397bocholthindenburgstrase19" "de46399bocholtferdinandbraunstrase19" "de46414rhedebaumanweg1" "de46414rhedehoewel3" "de46446emerichstadtweide13" "de46446emerichwernerheisenbergstrase2325" "de46485weselemelsumerstrase218" "de46499haminkelniãhorstrase1" "de46535dinslakentysenstrase93" "de46562voerdeamindustriepark2" "de46569huenxewernerheisenbergstrase2" "de46569hünxeambekenstrang5" "de46569hünxewernerheisenbergstrase2" "de47053duisburgfehrbelinstrase50" "de47059duisburgruhrorterstrase16f" "de47198duisburgeisenbahnstrase70" "de47228duisburghochstrase197213" "de47229duisburgantwerpenerstrase10" "de47229duisburgkuehneundnagelplaz1" "de47475kamplintfortcarlfriedrichgausstrase1" "de47475kamplintfortnordeuschlandstrase1" "de47495rheinbergamazonstrase1" "de47495rheinberganderrheinbergerheide5" "de47495rheinbergeichenweg14" "de47495rheinberghubertunderbergale1" "de47533klevehuisenerstrase79" "de47533klevemedlinestrase13" "de47533klevesteinstrase45" "de47559kranenburgimhamereisen57" "de47608geldernkanalweg18" "de47608geldernliebigstrase30" "de47623kevelaerwezerstrase84" "de47652wezealteherstrase64" "de47800krefeldelbestrase2" "de47800krefeldsalestrase12b" "de47800krefeldsalestrase3" "de47803krefeldhuelserstrase386" "de47803krefeldmevisenstrase45" "de47803krefeldniedieckstrase7" "de47807krefeldfichtenhainnirostastrase3" "de47807krefeldhansguentersohlstrase2" "de47807krefeldhansguentersohlstrase4a" "de47807krefeldnirostastrase3" "de47809krefeldkreuzweg60" "de47809krefeldmaerkischestrase10" "de47877wilichhalskestrase9a" "de47877wilichhansmartinschleyerstrase19" "de47877wilichjakobkaiserstrase12" "de47877wilichschlesierstrase7" "de47918toenisvorstmaysweg1" "de48151münstersperlichstrase63" "de48268grevencarlbenzstrase2535" "de48268grevenotolilientalstrase38" "de48268grevenreckenfelderstrase60" "de48268grevenrobertboschstrase13" "de48282emsdetenholefeldstrase41" "de48301notulnmuensterstrase70" "de48455badbenteimstockholmerstrase26" "de48485neuenkirchencartierpucioasasat161" "de48485neuenkirchendieselstrase15" "de48607ochtrupkreuzweg58" "de48607ochtrupweinerpark16" "de48629metelenheinrichschlickstrase2" "de48653coesfelddieselstrase1012" "de48653coesfelddieselstrase20" "de48683ahausindustriestrase12" "de48691vredenlisemeitnerstrase13" "de48712gescherage31651093253l829" "de48712gescherwernervonsiemensstrase15" "de49143bisendorfrudolfrungestrase3" "de49377vechtarudolfdieselstrase68" "de49406eydelstedtmolkereistrase7" "de49479ibenbuerendornierstrase2" "de49479ibenbuerenfugerstrase6" "de49492westerkapelnvelpeamvelpermuehlenbach8" "de49586merzenschwertofstrase4" "de49692capelnhaupstrase31" "de49824emlicheimostersand21" "de50126bergheimfriedrichbeselstraáe20" "de50126bergheimfriedrichbeselstrase20" "de50126bergheimwaltergropiusstrase12a" "de50169kerpengeigerstrase9" "de50170kerpenhuetenstrase10102" "de50170kerpenwankelstrase17" ] |
|
12.56 ms (3.88%) |
1 |
select quick_hash from address where quick_hash is not null group by quick_hash having count(*)>1 order by quick_hash
Parameters:
[] |
|
11.37 ms (3.52%) |
2 |
"COMMIT"
Parameters:
[] |
|
5.45 ms (1.69%) |
1 |
SELECT t0.id AS id_1, t0.name1 AS name1_2, t0.name2 AS name2_3, t0.street1 AS street1_4, t0.street2 AS street2_5, t0.country AS country_6, t0.zip AS zip_7, t0.town AS town_8, t0.tel AS tel_9, t0.fax AS fax_10, t0.email AS email_11, t0.quick_hash AS quick_hash_12, t0.fixed AS fixed_13, t0.note AS note_14, t0.variations AS variations_15, t0.isocountry AS isocountry_16, t0.mobile AS mobile_17, t0.tel2 AS tel2_18, t0.fax2 AS fax2_19, t0.email2 AS email2_20, t0.mobile2 AS mobile2_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25 FROM address t0 WHERE t0.quick_hash IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "de91717wasertrüdingenindustriestrase3" "de91717wasertruedingenindustriestrase3" "de91757treuchtlingenmarktberolzheimerstrase6" "de92318neumarktdaimlerstrase46" "de92318neumarktdaimlerstrase6" "de92348bergludwigerhardring30" "de92637weidenlasch5a" "de92637weidenparksteinerstrase49" "de93053regensburgjohanhoeslstrase5" "de93102pfaterdorfstrase1" "de93128regenstaufgutenbergstrase15" "de93326abensbergziegeleistrase9" "de93346ihrlersteinziegeltalstrase2" "de93413chamkamerdorferstrase16" "de94139breitenbergpasauerstrase20" "de94239ruhmansfeldenbuehlfelderweg12" "de94315straubingeuroparing20" "de94315straubingeuroparing37" "de94342straskirchenpasauerstrase5" "de94405landauklegartenstrase53" "de94419reisbachdingolfingerstrase254" "de94469degendorfgroswalding10" "de94474vilshofenoskarvonmilerstrase2" "de95100selbchrhoeferring54" "de95111rehauzehstrase2" "de95485warmensteinachvordergeiersberg28a" "de95643tirschenreutmiterweg1" "de95652waldsasenandertongrube3" "de96052bambergrheinstrase16" "de96132schlüselfeldrudolfdaslerstrase1" "de96148baunachhasbergstrase45" "de96215lichtenfelseichenweg2" "de96237ebersdorfehrlicherstrase20" "de96277schneckenlohebahnhofstrase1" "de96328kpskaulache4" "de96450coburgglenderstrase5" "de96450coburgmuehleite21" "de96515sonebergmitleremoschstrase9" "de97070wuerzburglindahlstrase4" "de97076wuerzburgwernervonsiemensstrase18" "de97084wrzburgmaxmengeringhausenstrase1" "de97084wuerzburgmaxmengeringhausenstrase1" "de97084würzburgmaxmengeringhausenstrase1" "de97228rotendorfschieshaustrase10" "de97258golhofenindustriestrase2" "de97259greusenheimambiotop6" "de97285roetingenindustriestrase1" "de97337detelbachmainfrankenpark15" "de97355abswindwiesenteiderstrase4" "de97359schwarzachgewerberingnord1" "de97424schweinfurtkarlgoezstrase5" "de97424schweinfurtwirsingstrase18" "de97450arnsteinfrankenstrase1" "de97505geldersheimgeltariring51" "de97520roetleinamezberg20" "de97616salzludwigelsbetstrase8" "de97638melrichstadtimenweg1" "de97828markteidenfelddilberg3" "de97877werteimhafenstrase16" "de97944boxbergsehoeferstrase45" "de97990weikersheimfriedrichwolfartstrase6" "de98646hildburghausenamtrockenbach2" "de98694ilmenauindustriering9" "de99334wolfknipenbergstrase2a" "de99428oesterholzstrase1" "de99752wiperdorfsonderhaeuserstrase1" "de99820hoerselbergindustriestrase6" "de99837berkawildeckerstrase2" "de99842ruhlaaue20" "deneuwied" "dk2640hedehusenehovedgaden630" "fr14540soliers4ruedesaucrais" "fr31000toulouseruelabouche8" "fr38300bourgoinjalieu5rueclemenceau" "fr60480ourcelmaisonparcactivitesdelabeleas" "fr60480ourselmaisonparcactivitesdelabeleas" "fr67470selzzaduniederwald" "fr67580merzwilerruelouispasteur" "fr69970chaponay415ruemariusberliet" "fr72140siléleguilaumezoneindustrielezi" "fr74650chavanodparcaltais" "fr77181courtryruedelaregale32" "fr85120lachataigneraiezonedactivitedufieftardy" "fr95310straseouenlaumone13ruedelagarene" "it27010sizianoviadelbenesere4" "it36024nantoviacasilvestre52" "it48121ravena" "it61122pesaroviadelvalo1" "nl5944arcenverlengderobekweg8" "nl7041 gdsherenbergindustriestrat5" "nl7041 kjsherenbergdistributiestrat5" "nl7041sherenbergindustriestrat5" "pl05-870bloniepas21d" "pl55-040bielanywroclawskieulczekoladowa1" "pl64-700czarnkàwulwielenska2a" "pl64-700czarnkówulwielenska2a" "pl69-100slubiceszkolna10akunowice" "pl80-180kowaleulmagnacka15" "pl80180kowaleulmagnacka15" "pl93-428lódzgraniczna46" "se291 32kristianstadbarbackagatan2se29132kris" "se291 32kristianstadbarbackagatan2se29132kristians" "se29132kristianstadbarbackagatan2se29132kris" "se570 15holsbybrunvetlandavaegen14" "sk900 55lozornologistickyarealp3parkbrati" "sk90055lozornologistickyarealp3parkbrati" ] |
|
3.76 ms (1.16%) |
1 |
delete from job_history where job_id=3 and resultcode=4 and id <7168196
Parameters:
[] |
|
3.35 ms (1.04%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
3.12 ms (0.97%) |
2 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_dev AS is_dev_5, t0.all_depot AS all_depot_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.title AS title_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.right_level_id AS right_level_id_13, t0.standard_depot_id AS standard_depot_id_14, t0.state_id AS state_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
-1
]
|
|
2.96 ms (0.92%) |
1 |
select min(id) from (select jh.id from job_history jh where jh.job_id=3 order by jh.id desc limit 100) x
Parameters:
[] |
|
2.49 ms (0.77%) |
2 |
SELECT t0.id AS id_1, t0.state AS state_2, t0.step_kind AS step_kind_3, t0.description AS description_4, t0.state_message_ftp AS state_message_ftp_5, t0.state_message_fax AS state_message_fax_6, t0.state_message_mail AS state_message_mail_7, t0.state_message_sms AS state_message_sms_8, t0.state_message_api AS state_message_api_9, t0.changing_sending AS changing_sending_10, t0.state_group AS state_group_11, t0.avis_try AS avis_try_12, t0.show_hist AS show_hist_13, t0.bookable AS bookable_14, t0.export_state_id AS export_state_id_15, t0.sgroup_id AS sgroup_id_16 FROM type_sending_state t0
Parameters:
[] |
|
1.40 ms (0.43%) |
1 |
select min(id) from (select jh.id from job_history jh where jh.job_id=3 and resultcode=4 order by jh.id desc limit 20) x
Parameters:
[] |
|
1.38 ms (0.43%) |
1 |
SELECT a0_.id AS id_0, a0_.name1 AS name1_1, a0_.name2 AS name2_2, a0_.street1 AS street1_3, a0_.street2 AS street2_4, a0_.country AS country_5, a0_.zip AS zip_6, a0_.town AS town_7, a0_.tel AS tel_8, a0_.fax AS fax_9, a0_.email AS email_10, a0_.quick_hash AS quick_hash_11, a0_.fixed AS fixed_12, a0_.note AS note_13, a0_.variations AS variations_14, a0_.isocountry AS isocountry_15, a0_.mobile AS mobile_16, a0_.tel2 AS tel2_17, a0_.fax2 AS fax2_18, a0_.email2 AS email2_19, a0_.mobile2 AS mobile2_20, a0_.created_at AS created_at_21, a0_.updated_at AS updated_at_22, a0_.created_by_id AS created_by_id_23, a0_.updated_by_id AS updated_by_id_24 FROM address a0_ WHERE a0_.quick_hash IS NULL AND a0_.isocountry IS NOT NULL LIMIT 2000
Parameters:
[] |
|
1.19 ms (0.37%) |
1 |
UPDATE job_history SET end = ?, resultcode = ?, resulttext = ? WHERE id = ?
Parameters:
[ "2025-04-05 02:24:11" 4 "2663 addresses with duplicate hash found, " 7168350 ] |
|
1.17 ms (0.36%) |
1 |
UPDATE job SET hash = ?, updated_at = ? WHERE id = ?
Parameters:
[ null "2025-04-05 02:24:11" 3 ] |
|
1.15 ms (0.36%) |
1 |
UPDATE job SET last_run = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2025-04-05 02:24:10" "2025-04-05 02:24:10" 3 ] |
|
1.14 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.last_run AS last_run_4, t0.last_state AS last_state_5, t0.hash AS hash_6, t0.enabled AS enabled_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM job t0
Parameters:
[] |
|
1.13 ms (0.35%) |
1 |
INSERT INTO job_history (start, end, resultcode, resulttext, job_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2025-04-05 02:24:10" null 1 "" 3 ] |
|
1.07 ms (0.33%) |
1 |
delete from job_history where job_id=3 and id <7168196
Parameters:
[] |
|
1.03 ms (0.32%) |
1 |
Start Transaction;update address set name2=null, quick_hash=null where binary name1= binary name2 and name1 is not null;update address set fixed=1 where id in (select address_id from client union select address_id from depot union select address_id from cooperation union select address_id from rules_automatic_sender_address union select address_id from rules_automatic_recipient_address union select address_id from address_list_address) and fixed=0;update address set fixed=0 where id not in (select address_id from client union select address_id from depot union select address_id from cooperation union select address_id from rules_automatic_sender_address union select address_id from rules_automatic_recipient_address union select address_id from address_list_address) and fixed=1;COMMIT;
Parameters:
[] |
|
0.97 ms (0.30%) |
1 |
Start Transaction; update address set quick_hash=lower(quick_hash) where binary quick_hash <> binary lower(quick_hash); COMMIT;
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\TypeSendingState | No errors. |
| App\Entity\TypeExportState | No errors. |
| App\Entity\TypeSendingStateGroup | No errors. |
| App\Entity\Message | No errors. |
| App\Entity\StatSending |
|
| App\Entity\Job | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CronTimeEntry | No errors. |
| App\Entity\JobHistory | No errors. |
| App\Entity\TypeRightlevel | No errors. |
| App\Entity\Depot |
|
| App\Entity\TypeState | No errors. |
| App\Entity\UserSetting | No errors. |
| App\Entity\Sending | No errors. |
| App\Entity\DepotGroup | No errors. |
| App\Entity\AssignDepot | No errors. |
| App\Entity\StatSc |
|
| App\Entity\UserLogin | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\AddressList | No errors. |
| App\Entity\AddressVariation | No errors. |