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