Query Metrics

89 Database Queries
26 Different statements
412.22 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.42 ms
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
]
2 0.11 ms
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
3 0.14 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
4 0.20 ms
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:
[
  "mainBlogPortal"
  null
  null
]
5 0.11 ms
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  8
]
6 0.09 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "BlogPortal"
]
7 0.42 ms
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=1430454&nearbySearchLat=47.32735&nearbySearchLong=13.75936&sorting=nearbySearchAsc&page=4&randSeed=38"
  "sourceEntireUri" => "https://stage.steiermark.com/en/Schladming-Dachstein/Vacation-planning/Accommodations?nearbySearchId=1430454&nearbySearchLat=47.32735&nearbySearchLong=13.75936&page=4&randSeed=38&sorting=nearbySearchAsc"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
8 0.12 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
9 0.12 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Accommodations"
  "path" => "/steiermark.com/en/Schladming-Dachstein/Vacation-planning/"
]
10 0.16 ms
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:
[]
11 0.13 ms
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
12 0.23 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "21"
]
13 0.19 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  7930
]
14 0.13 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  7159
]
15 0.10 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "31"
]
16 0.08 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "59"
]
17 34.21 ms
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
18 0.26 ms
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
]
19 0.12 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "72"
]
20 0.21 ms
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:
[
  11408
]
21 37.78 ms
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:
[]
22 0.33 ms
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:
[]
23 0.30 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
24 0.21 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "Region"
]
25 0.16 ms
SELECT id FROM sites
Parameters:
[]
26 0.24 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  7930
]
27 0.20 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  7159
  7930
  7930
]
28 0.12 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  7930
  7930
]
29 0.12 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  7159
  7159
]
30 0.14 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Accommodations"
  "path" => "/en/Schladming-Dachstein/Vacation-planning/"
]
31 0.10 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations"
]
32 0.09 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Accommodations"
  "path" => "/en/Schladming-Dachstein/Vacation-planning/"
]
33 0.09 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning/Accommodations"
]
34 0.15 ms
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"
]
35 0.09 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Vacation-planning"
  "path" => "/en/Schladming-Dachstein/"
]
36 0.09 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Schladming-Dachstein/Vacation-planning"
]
37 0.11 ms
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"
]
38 0.08 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Schladming-Dachstein"
  "path" => "/en/"
]
39 0.08 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en/Schladming-Dachstein"
]
40 0.11 ms
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"
]
41 0.08 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "en"
  "path" => "/"
]
42 0.08 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/en"
]
43 0.11 ms
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"
]
44 0.11 ms
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/%"
  ""
]
45 0.09 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => ""
  "path" => "/"
]
46 0.11 ms
SELECT * FROM object_url_slugs WHERE slug = '/en/Schladming-Dachstein/Vacation-planning/Accommodations' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
47 0.09 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
48 0.10 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "1"
  "scope" => "pimcore_staticroutes"
]
49 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "2"
  "scope" => "pimcore_staticroutes"
]
50 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "3"
  "scope" => "pimcore_staticroutes"
]
51 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "4"
  "scope" => "pimcore_staticroutes"
]
52 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "5"
  "scope" => "pimcore_staticroutes"
]
53 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "6"
  "scope" => "pimcore_staticroutes"
]
54 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "7"
  "scope" => "pimcore_staticroutes"
]
55 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "8"
  "scope" => "pimcore_staticroutes"
]
56 0.09 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "9"
  "scope" => "pimcore_staticroutes"
]
57 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "10"
  "scope" => "pimcore_staticroutes"
]
58 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "11"
  "scope" => "pimcore_staticroutes"
]
59 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "12"
  "scope" => "pimcore_staticroutes"
]
60 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "13"
  "scope" => "pimcore_staticroutes"
]
61 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "15"
  "scope" => "pimcore_staticroutes"
]
62 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "16"
  "scope" => "pimcore_staticroutes"
]
63 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "17"
  "scope" => "pimcore_staticroutes"
]
64 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "18"
  "scope" => "pimcore_staticroutes"
]
65 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "19"
  "scope" => "pimcore_staticroutes"
]
66 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "20"
  "scope" => "pimcore_staticroutes"
]
67 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "21"
  "scope" => "pimcore_staticroutes"
]
68 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "22"
  "scope" => "pimcore_staticroutes"
]
69 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "23"
  "scope" => "pimcore_staticroutes"
]
70 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "24"
  "scope" => "pimcore_staticroutes"
]
71 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "25"
  "scope" => "pimcore_staticroutes"
]
72 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "26"
  "scope" => "pimcore_staticroutes"
]
73 0.09 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "27"
  "scope" => "pimcore_staticroutes"
]
74 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "28"
  "scope" => "pimcore_staticroutes"
]
75 0.11 ms
SELECT id FROM sites
Parameters:
[]
76 0.17 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 1524019
]
77 0.12 ms
SELECT id FROM sites
Parameters:
[]
78 0.19 ms
SELECT id FROM sites
Parameters:
[]
79 0.26 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  16088
]
80 0.16 ms
SELECT * FROM object_collection_demiDatePickerInfoText_21 WHERE o_id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  5882755
  "datepickerInfoTexts"
]
81 0.14 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "18"
]
82 0.37 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "AlpsteinTour"
]
83 0.18 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "8"
]
84 0.14 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "20"
]
85 0.13 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "51"
]
86 0.13 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "30"
]
87 0.12 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "68"
]

demi_vacancies connection

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

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.