Query Metrics
89
Database Queries
26
Different statements
412.22 ms
Query time
0
Invalid entities
Queries
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.