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