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