Query Metrics
109
Database Queries
25
Different statements
408.77 ms
Query time
0
Invalid entities
Queries
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.