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