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