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