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