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