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

Method
GET
HTTP Status
200
IP
213.180.203.154
Profiled on
Token
2d0dcc

Query Metrics

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

Grouped Statements

Show all queries

default connection

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