https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations/map-poi-json?amp%3B_locale=en&amp%3BnearbySearchLat=47.05186&amp%3BnearbySearchLong=14.53082&amp%3Bsorting=nearbySearchAsc&nearbySearchId=324470

Method
GET
HTTP Status
200
IP
95.108.213.156
Profiled on
Token
f68f9c

Query Metrics

23 Database Queries
13 Different statements
439.46 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
0.79 ms
(0.18%) 		2 
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters: 
[
  "defaultSiteConfig"
  null
  null
]
View formatted query    View runnable query    Explain query
0.50 ms
(0.11%) 		6 
SELECT name FROM classes WHERE id = ?
Parameters: 
[
  "SiteConfig"
]
View formatted query    View runnable query    Explain query
0.45 ms
(0.10%) 		1 
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters: 
[
  "sourcePath" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations/map-poi-json"
  "sourcePathQuery" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations/map-poi-json?nearbySearchId=324470&nearbySearchLat=47.05186&nearbySearchLong=14.53082&sorting=nearbySearchAsc&_locale=en&"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations/map-poi-json?amp;_locale=en&nearbySearchLat=47.05186&nearbySearchLong=14.53082&sorting=nearbySearchAsc&nearbySearchId=324470"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
View formatted query    View runnable query    Explain query
0.39 ms
(0.09%) 		2 
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
Parameters: 
[
  11189
]
View formatted query    View runnable query    Explain query
0.32 ms
(0.07%) 		2 
SELECT * FROM documents_editables WHERE documentId = ?
Parameters: 
[
  7930
]
View formatted query    View runnable query    Explain query
0.18 ms
(0.04%) 		2 
SELECT * FROM website_settings WHERE id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.16 ms
(0.04%) 		2 
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters: 
[
  "key" => "map-poi-json"
  "path" => "/steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations/"
]
View formatted query    View runnable query    Explain query
0.15 ms
(0.04%) 		1 
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.12 ms
(0.03%) 		1 
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters: 
[
  "/steiermark.com/%"
  "/en/Schladming-Dachstein/Vacation-planning/Accommodations/map-poi-json"
]
View formatted query    View runnable query    Explain query
0.11 ms
(0.02%) 		1 
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters: 
[
  "id" => "reports"
  "scope" => "pimcore"
]
View formatted query    View runnable query    Explain query
0.07 ms
(0.02%) 		1 
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters: 
[
  "prettyUrl" => "/steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations/map-poi-json"
]
View formatted query    View runnable query    Explain query

demi_vacancies connection

Time▼ Count Info
368.49 ms
(83.85%) 		1 
SELECT pt.acco_id, pt.product_id, bp.price as minPrice, pt.rule type, pt.nights nights
              FROM    `steiermark_vacancies`.price_template pt
                   INNER JOIN
                      `steiermark_vacancies`.price_template_base_prices bp
                   ON bp.price_template_id = pt.id
             WHERE     pt.acco_id IN (84439,149098,208109,383826,209859,178500,193372,210612,218293,221136,138736,168676,204528,263186,250829,74347,22892603,208674,171085,172317,7678621,146183,119029,210522,159735,95945,150349,197250,91479,157359,254246,143950,175232,77223,171224,1173892,78857,107333,189166,145409,200435,192523,98180,87409,84906,219645,193721,149155,187757,46236871,175792,74880,221382,243839,79030,129031,17275737,90081,107859,158481,168606,121533,98021,80548,188242,163958,90325,156120,241209,203394,95043,198187,91582,145352,108052,192120,141562,242072,201319,7599929,89549,41024653,181569,126983,193204,383286,221173,108780,259830,94373,83429,33072200,213063,91812,98451,217376,208378,245352,244648,173923,185598,44404593,117646,132156,173474,157109,211866,108881,264448,98143,114251,81346,42105593,159064,207573,21308116,120959,136036,265468,95652,86434,27808352,197565,152590,265255,190383,38621717,124829,27199439,134831,195347,4061766,89972,139875,252832,179201,199934,135012,189123,144248,26648317,256553,167903,181736,90672,120883,167765,156680,129501,77600,96354,18323640,87856,261973,106770,121033,4442214,113462,1904411,228125,229095,260613,171978,128141,109374,225374,221512,194471,171116,228081,203636,100061,9887645,136526,227647,111604,31215812,248735,262376,244956,96059,21161019,144556,131839,100682,143448,128612,85808,87340,96266,212320,179813,171549,188477,126485,212470,195136,177240,138939,149216,2977929,254825,187883,89886,48897409,145614,96500,37667633,402843,110467,156882,13979961,114017,150874,142725,41634802,181966,122307,205800,77676,268304,219686,4580718,257010,106287,185045,36566491,139671,198592,177157,186795,202479,94222,176111,115223,219012,172618,205629,9395965,223466,76900,115604,265066,139730,111341,131085,75853,176975,5160343,87899,3224898,74473,179767,179886,111071,227190,192306,1173603,193837,162257,119718,209921,14669428,110779,241752,26684056,252035,229397,111370,4061656,212689,217510,178337,141272,31514436,113160,204827,149455,263240,164042,250658,102266,186138,20708505,142948,155984,106657,91383,262837,176296,1173161,167986,114455,124237,131790,251478,244970,125739,220914,127120,197379,145685,108989,164436,33072197,22452518,219157,34037741,263716,185961,139639,218375,73318,89745,107364,135125,82308,165965,114505,227134,206198,113626,141808,82521,135685,99548,265878,228197,208902,227270,160203,111233,221593,188200,101167,255713,34636746,168114,110254,7217358,94738,150701,263475,74534,203485,147969,169612,261823,173602,220170,177255,9700325,8722785,223355,128526,27128134,23106643,266691,179735,144028,73900,190061,197713,246756,242703,165005,196032,94129,84542,177852,262206,226395,166413,13723644,206964,247180,198307,3379718,39225141,29649833,8388408,73135,101403,83605,229144,189617,257732,205363,92184,150008,218076,118332,191428,171964,269473,155492,125266,220403,154051,212066,73343,23106697,255957,265965,220483,191815,156556,168651,74030,106445,18810400,81753,268279,115545,87219,171586,191407,49169351,108003,50388225,259576,257470,189271,176007,169799,98639,79610,174737,212715,8870626,206894,221211,241513,244042,213537,95383,187810,162361,3118747,174798,89709,115353,197310,90830,140059,113392,146572,27808188,118621,89261,192497,22892606,202896,73764,121323,12371222,9700358,149642,96619,200283,266243,81720,160247,164670,175147,240436,156464,266061,261338,161875,260943,183531,214160,87124,268018,140362,37366700,269658,260555,383118,175902,204855,7967625,79701,1173121,269401,245659,101873,162656,147033,23220930,7599407,383578,204651,18355899,84306,239438,31077769,162146,191516,174091,181884,122718,166529,240156,96781,254574,103317,194884,162891,1173353,191937,49539259,1173542,207780,75414,132704,155681,191047,174035,133017,183075,253165,92398,139196,209807,122139,9282725,151676,166027,263121,268827,122580,51216654,146983,139824,202441,189670,267851,73556,226499,93789,207109,100829,36278962,39558144,102697,200906,199572,186921,226049,249413,84693,223733,111521,180504,90455,5315084,18810410,88849,80940,182335,158905,121638,129897,75680,145003,20972969,173849,225114,197746,75959,105369,79926,168470,170902,100524,268424,94870,223652,109732,106347,96544,86586,130026,262579,2566227,143351,201425,249148,171766,41796413,206854,193693,204745,38300874,175319,384102,149059,85437,144517,172344,81094,207942,115484,383006,119054,253709,130955,16306657,186869,112984,151587,76033,76562,193068,23945599,5315068,4791485,77798,147869,97583,132768,190819,156310,4791488,177439,198814,91679,85117,178544,156617,267700,183196,205493,78111,242919,200595,117438,180007,245926,198994,87314,148376,168744,135519,14557855,176244,180106,142776,42358761,383672,158547,176068,15050850,154226,182728,219804,202588,154608,81984,4442181,97116,192660,154459,113819,114734,146288,3411816,161142,228314,220755,261224,81527,186109,150752,114609,242964,27808178,124000,218042,191455,156724,7186183,134322,136066,183391,92309,181441,190874,144860,9517217,136200,243765,213283,86746,254732,176897,131135,38622028,138609,163153,49539249,21273299,164573,256818,145258,248414,107594,97625,133887,201789,135829,74297,130267,124337,80881,115132,6771978,146703,15243082,255407,148602,162100,200126,87970,17058949,151568,91843,159538,100623,142573,213326,141037,143038,189874,193149,251865,79343,222491,20512295,30765443,261585,13400949,233730,26244429,229040,9290160,240646,147191,15668814,256266,1173491,155598,220948,117802,260733,238918,185698,109827,134094,131018,23455826,177391,228288,267915,7599993,148211,219299,98121,203147,208516,72528,223333,221442,139070,101260,87518,154873,47202201,222458,3379819,72285,3176489,171431,266341,147915,194960,14623690,122101,134210,154180,4442187,147152,150639,5160340,218829,142897,190634,177510,145830,263995,229470,199831,202332,163692,31789631,220531,89073,220877,194917,244711,102508,26898515,35700277,170725,146150,124113,151636,141880,142318,213925,206641,171164,256958,266360,252258,204161,141729,220693,115150,383027,227403,151031,87380,46904829,165805,164309,98352,195314,201732,118392,245060,173273,117916,38723937,170382,123820,20627345,267186,211256,264308,147531,209589,90363,148899,114041,96112,187408,250060,1173742,200867,199850,108195,153833,267678,164627,189988,251539,122780,250696,158731,156225,160845,138331,174941,3224895,154301,218867,135252,139974,211759,170704,4061812,214424,210718,148562,212576,141472,160801,190150,149400,90791,105477,199700,222898,213843,187073,6797421,174181,157224,7941416,8591193,176992,260788,5315087,203617,97423,213132,211808,239049,124694,144374,267023,10261747,128777,165937,114925,160120,74757,210887,89456,99114,139146,143596,108105,225305,154821,115902,76427,23184951,163235,382743,46461361,185864,118221,182314,168086,241860,4061468,250245,74091,151257,194713,101745,148779,144833,235840,260687,260387,124606,103592,203882,162948,129250,266549,149007,9517247,160168,129206,131179,207463,5957902,259743,219765,174583,4061616,176200,1173124,27807955,22840856,249659,225195,139042,222748,251064,195537,131774,138273,10039806,218032,205199,9700322,139584,194565,110374,142256,90285,196171,186236,143537,104583,227046,223960,241670,228572,106040,6771981,166311,227604,75600,186088,269023,113751,265584,7016779,2367452,218521,17877742,202690,181278,75190,97982,189598,205753,39355239,134439,201802,111651,213047,32979456,150724,84734,109291,175610,111003,263799,32742951,78602,21211748,199742,73395,268951,228246,265378,75009,77403,210768,205724,222266,9700388,245508,180460,148079,187180,250174,9129444,177333,135205,266112,110842,269445,220546,124869,142376,30148041,102868,43349109,223447,22568743,240971,259918,249871,244552,80315,3379737,2470567,165025,208283,109234,5957896,178215,155523,120483,143202,209213,162820,91521,111742,93903,154116,161664,85536,220348,91777,384050,79763,110338,170491,180306,193952,125661,190401,8566620,172512,181329,117486,188894,199275,220238,119097,155228,262167,187735,223044,186176,88121,156918,1845849,122810,190546,27808362,196083,13377190,227765,187460,119873,79494,21237158,261487,223395,105748,164128,178677,138703,77069,140833,265826,191266,95803,96924,107057,178072,194307,209054,41680612,6775934,4061851,98382,188297,107672,260291,142528,382826,147332,127946,81316,41214843,192284,266814,82604,156762,125397,382988,135953,170790,220655,104153,221094,9290146,8618578,267580,269773,116102,35522295,219501,244217,261158,223285,254301,31665450,9700382,203308,199538,225007,228944,128888,256504,245836,135345,170518,130049,227558,245886,122838,265768,81639,85349,88890,89565,261884,73689,224773,163837,255495,86366,37868894,208831,199364,247473,146259,83176,241967,150070,176457,174338,75482,210439,87071,209445,212394,246469,31419712,186209,383021,126702,267623,132606,268917,11367104,266888,33664677,105761,4791491,257803,207763,110677,171353,34719290,242260,151300,87467,79212,102814,194023,252859,187530,157283,91149,18332685,104513,136181,214433,209194,209483,200772,101549,4442184,4149175,212020,80083,73645,170037,116231,201863,160274,158648,88601,141656,104781,46237639,140245,109501,100207,87012,169525,154758,179118,114786,263334,164198,37038521,129096,4061962,132556,81217,107023,77357,108664,78233,256865,38670305,164234,212729,122527,192391,120314,118447,34219679,180717,82419,178599,157428,228789,192003,199099,116132,180136,208746,103499,129814,263626,13818591,75898,174987,261005,82805,185888,130799,202554,246306,250387,39599857,229314,383360,383256,7780777,76091,130455,181045,7715980,78778,80509,169666,76116,147609,255905,146129,234239,198534,222689,226215,120394,223613,195225,193028,7541413,113408,127993,134714,44224029,266661,251348,186259,176678,242085,106094,2655510,33267404,47158244,191155,136555,241089,173082,77540,138437,97550,384128,247088,268647,8695139,168884,182129,260508,211891,107555,101813,257550,231694,102372,84203,166611,195918,147221,135730,77134,150197,83126,120627,227732,192804,164711,157061,141995,51503593,149700,188963,27486615,213869,202800,242815,98441,227892,208002,8388337,148975,171662,247897,129533,45539296,27224568,1173693,130741,253939,29311567,126658,75643,170765,91180,240404,37868209,125055,211155,145494,128992,146397,119809,115416,245591,103051,169035,163032,203577,136417,218423,6614248,210751,227481,256037,78974,240120,157466,242014,243209,155356,203901,88688,262617,261943,192842,222990,204776,105712,229645,202099,160345,223510,74427,113085,383375,208932,143260,203131,179242,240534,220200,225267,172217,243999,1173653,182482,128254,159639,89349,41752708,179171,192033,72611,38050667,133247,195022,249733,185065,170874,189226,103833,187911,255823,189797,39995931,204204,205836,264897,259359,132963,108551,108520,12253627,26970115,193518,94404,267314,20059276,11213840,267530,268989,241333,114320,250318,204973,75106,173543,150268,261287,135403,242786,101798,157521,128052,162295,98483,83792,197648,169959,10655859,2853495,140325,147399,166123,210702,47294199,139252,183290,91914,384186,207430,178433,190920,105395,162969,31719532,5957905,246876,1173251,226977,198498,245784,246836,180387,252403,213358,259974,267501,105154,245240,226339,156053,383494,143682,190504,198380,80793,151492,8722782,185208,172278,195752,224600,144062,98309,209351,99228,136496,383139,199295,190210,91299,48897791,195558,3029831,125952,218149,111091,80345,227572,103365,204342,225967,88291,174544,124718,43751656,97332,72244,99678,418173,268711,170268,178962,384041,102976,262446,240386,15659243,199975,214015,224332,143736,22882595,90162,101590,157541,102558,146486,195113,17594470,268384,157149,176727,179680,28138429,196249,4061779,134133,128321,161406,265930,43581664,224446,103348,209292,224525,188163,117877,218235,72773,166076,35241603,205897,212164,182441,103526,88772,185439,121463,97682,212929,157401,195386,27076239,175690,144112,247967,265305,1173158,185795,143785,110435,176637,178916,128649,203729,23185284,243243,161033,145447,162327,174680,79424,260577,194797,228856,251659,9872791,86879,38008495,84605,210638,99420,262061,383292,132281,261090,115753,243956,202202,95872,266442,211686,151225,101969,241827,191210,1173254,383497,130324,206591,101229,44869050,197835,160614,173880,268162,74121,106889)
                  
                   AND pt.stdOccupancy BETWEEN bp.occupancyFrom AND bp.occupancyTo
                   AND price > 0 and (select active from `steiermark`.object_6 product where product.o_id = pt.product_id)
                   order by minPrice
Parameters: 
[]
View formatted query    View runnable query    Explain query
67.71 ms
(15.41%) 		1 
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id, dacco.position__longitude as lng, dacco.position__latitude as lat, stars.starsNumbers as starNr, stars.isSuperior as starSup, addressColl.addressLine1, addressColl.addressLine2, addressColl.zipCode, addressColl.town, addressColl.city, addressColl.country, dacco.ratingAverageDirect as ratingAverage, dacco.ratingCountDirect as ratingCount, dacco.name as accoName  FROM `steiermark`.object_8 dacco INNER JOIN `steiermark`.object_relations_8 facrel ON facrel.src_id = dacco.oo_id  LEFT JOIN `steiermark`.object_collection_demiAddress_8 addressColl ON addressColl.o_id = dacco.oo_id AND addressColl.fieldname = 'addresses' AND addressColl.addressType = 'Object'  LEFT JOIN `steiermark`.object_68 stars ON dacco.stars__id = stars.oo_id WHERE  dacco.o_published = 1  AND (dacco.town__id IN (11195, 11196, 11191, 11194, 11190, 3192509, 11197, 11409))  GROUP BY dacco.oo_id  ORDER BY  RAND(95)
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection
demi_vacancies doctrine.dbal.demi_vacancies_connection

Entity Managers

Name Service
portal_engine doctrine.orm.portal_engine_entity_manager
pimcore_direct_edit doctrine.orm.pimcore_direct_edit_entity_manager
statistics_explorer doctrine.orm.statistics_explorer_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.