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