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