Query Metrics

109 Database Queries
25 Different statements
408.77 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.37 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.09 ms
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  1
]
3 0.12 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SiteConfig"
]
4 0.22 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.09 ms
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  8
]
6 0.08 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "BlogPortal"
]
7 0.51 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" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"
  "sourcePathQuery" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=853504&nearbySearchLat=47.38492&nearbySearchLong=13.86611&sorting=nearbySearchAsc"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte?nearbySearchId=853504&nearbySearchLat=47.38492&nearbySearchLong=13.86611&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.17 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte"
  "path" => "/steiermark.com/de/Schladming-Dachstein/Urlaub-planen/"
]
10 0.20 ms
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:
[]
11 0.15 ms
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
12 0.13 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "21"
]
13 0.26 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  7159
]
14 0.09 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "31"
]
15 0.06 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "59"
]
16 30.12 ms
select o_id,contentScore,priority,bookable  from object_8 where o_published = 1
Parameters:
[]
17 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:
[
  11189
]
18 0.07 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "72"
]
19 0.12 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
]
20 37.91 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:
[]
21 0.13 ms
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:
[]
22 0.11 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
23 0.09 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "Region"
]
24 0.12 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  8955
]
25 0.19 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 1816863
]
26 0.10 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 452066
]
27 0.16 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  9026
]
28 0.10 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 1816864
]
29 0.11 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 2404654
]
30 0.09 ms
SELECT id FROM sites
Parameters:
[]
31 0.13 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  7159
]
32 0.16 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  7159
  7159
  7159
]
33 0.14 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  7930
  7930
]
34 0.11 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte"
  "path" => "/de/Schladming-Dachstein/Urlaub-planen/"
]
35 0.09 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"
]
36 0.08 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Unterkuenfte"
  "path" => "/de/Schladming-Dachstein/Urlaub-planen/"
]
37 0.08 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"
]
38 0.14 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/%"
  "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte"
]
39 0.08 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Urlaub-planen"
  "path" => "/de/Schladming-Dachstein/"
]
40 0.07 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Schladming-Dachstein/Urlaub-planen"
]
41 0.12 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/%"
  "/de/Schladming-Dachstein/Urlaub-planen"
]
42 0.08 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "Schladming-Dachstein"
  "path" => "/de/"
]
43 0.07 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de/Schladming-Dachstein"
]
44 0.12 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/%"
  "/de/Schladming-Dachstein"
]
45 0.08 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "de"
  "path" => "/"
]
46 0.07 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/de"
]
47 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/%"
  "/de"
]
48 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/%"
  ""
]
49 0.08 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => ""
  "path" => "/"
]
50 0.10 ms
SELECT * FROM object_url_slugs WHERE slug = '/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
51 0.09 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
52 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "1"
  "scope" => "pimcore_staticroutes"
]
53 0.07 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "2"
  "scope" => "pimcore_staticroutes"
]
54 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "3"
  "scope" => "pimcore_staticroutes"
]
55 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "4"
  "scope" => "pimcore_staticroutes"
]
56 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "5"
  "scope" => "pimcore_staticroutes"
]
57 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "6"
  "scope" => "pimcore_staticroutes"
]
58 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "7"
  "scope" => "pimcore_staticroutes"
]
59 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "8"
  "scope" => "pimcore_staticroutes"
]
60 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "9"
  "scope" => "pimcore_staticroutes"
]
61 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "10"
  "scope" => "pimcore_staticroutes"
]
62 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "11"
  "scope" => "pimcore_staticroutes"
]
63 0.07 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "12"
  "scope" => "pimcore_staticroutes"
]
64 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "13"
  "scope" => "pimcore_staticroutes"
]
65 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "15"
  "scope" => "pimcore_staticroutes"
]
66 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "16"
  "scope" => "pimcore_staticroutes"
]
67 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "17"
  "scope" => "pimcore_staticroutes"
]
68 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "18"
  "scope" => "pimcore_staticroutes"
]
69 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "19"
  "scope" => "pimcore_staticroutes"
]
70 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "20"
  "scope" => "pimcore_staticroutes"
]
71 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "21"
  "scope" => "pimcore_staticroutes"
]
72 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "22"
  "scope" => "pimcore_staticroutes"
]
73 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "23"
  "scope" => "pimcore_staticroutes"
]
74 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "24"
  "scope" => "pimcore_staticroutes"
]
75 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "25"
  "scope" => "pimcore_staticroutes"
]
76 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "26"
  "scope" => "pimcore_staticroutes"
]
77 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "27"
  "scope" => "pimcore_staticroutes"
]
78 0.06 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "28"
  "scope" => "pimcore_staticroutes"
]
79 0.16 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  9029
]
80 0.13 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  27400
]
81 0.11 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "img-teaser-square"
  "scope" => "pimcore_image_thumbnails"
]
82 0.12 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3337646
]
83 0.12 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  1519
]
84 0.15 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  9043
]
85 0.23 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 486927
]
86 0.16 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  9044
]
87 0.17 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 541989
]
88 0.16 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  9046
]
89 0.18 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 472126
]
90 0.16 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  9045
]
91 0.16 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 1816842
]
92 0.15 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  9048
]
93 0.20 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3337643
]
94 0.17 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  27402
]
95 0.15 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 397334
]
96 0.16 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  9049
]
97 0.16 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 556954
]
98 0.19 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  9042
]
99 0.15 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 541208
]
100 0.15 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  9052
]
101 0.15 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 920613
]
102 0.11 ms
SELECT id FROM sites
Parameters:
[]
103 0.26 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 1524019
]
104 0.20 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  8957
]
105 0.13 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  8131
]
106 0.14 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "content-teaser--square"
  "scope" => "pimcore_image_thumbnails"
]
107 0.14 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 3337906
]

demi_vacancies connection

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