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