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