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