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