Query Metrics

81 Database Queries
25 Different statements
380.58 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
42.63 ms
(11.20%)
1
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
1.45 ms
(0.38%)
28
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
1.15 ms
(0.30%)
7
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
1.14 ms
(0.30%)
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.88 ms
(0.23%)
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.75 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.72 ms
(0.19%)
3
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  7930
]
0.65 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.59 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" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations"
  "sourcePathQuery" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations?page=29&randSeed=60"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?page=29&randSeed=60"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
0.45 ms
(0.12%)
5
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations"
]
0.33 ms
(0.09%)
4
SELECT id FROM sites
Parameters:
[]
0.30 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.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
  7930
  7930
]
0.21 ms
(0.06%)
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.19 ms
(0.05%)
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.19 ms
(0.05%)
2
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
0.14 ms
(0.04%)
1
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
0.14 ms
(0.04%)
1
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  7930
]
0.13 ms
(0.03%)
1
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 1524019
]
0.10 ms
(0.03%)
1
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  5882755
  "datepickerInfoTexts"
]
0.09 ms
(0.02%)
1
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.08 ms
(0.02%)
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.06 ms
(0.02%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]

demi_vacancies connection

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