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