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