https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/bubbles?_=1736640000000&nearbySearchId=1169&nearbySearchLat=47.41868&nearbySearchLong=13.68829&randSeed=683

Method
GET
HTTP Status
200
IP
66.249.76.195
Profiled on
Token
73c16b

Query Metrics

81 Database Queries
29 Different statements
538.67 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
2.18 ms
(0.41%) 		9 
SELECT name FROM classes WHERE id = ?
Parameters: 
[
  "SiteConfig"
]
View formatted query    View runnable query    Explain query
0.99 ms
(0.18%) 		2 
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
]
View formatted query    View runnable query    Explain query
0.85 ms
(0.16%) 		2 
SELECT * FROM documents_editables WHERE documentId = ?
Parameters: 
[
  7159
]
View formatted query    View runnable query    Explain query
0.78 ms
(0.15%) 		2 
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
]
View formatted query    View runnable query    Explain query
0.78 ms
(0.14%) 		1 
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/bubbles"
  "sourcePathQuery" => "/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/bubbles?randSeed=683&nearbySearchId=1169&nearbySearchLat=47.41868&nearbySearchLong=13.68829&_=1736640000000"
  "sourceEntireUri" => "https://stage.steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/bubbles?_=1736640000000&nearbySearchId=1169&nearbySearchLat=47.41868&nearbySearchLong=13.68829&randSeed=683"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
View formatted query    View runnable query    Explain query
0.28 ms
(0.05%) 		2 
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters: 
[
  "key" => "bubbles"
  "path" => "/steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/"
]
View formatted query    View runnable query    Explain query
0.17 ms
(0.03%) 		1 
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/bubbles"
]
View formatted query    View runnable query    Explain query
0.17 ms
(0.03%) 		2 
SELECT * FROM website_settings WHERE id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.16 ms
(0.03%) 		1 
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.13 ms
(0.02%) 		1 
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters: 
[
  "id" => "reports"
  "scope" => "pimcore"
]
View formatted query    View runnable query    Explain query
0.11 ms
(0.02%) 		1 
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters: 
[
  "prettyUrl" => "/steiermark.com/de/Schladming-Dachstein/Urlaub-planen/Unterkuenfte/bubbles"
]
View formatted query    View runnable query    Explain query

demi_vacancies connection

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

             group by dest_id
Parameters: 
[]
View formatted query    View runnable query    Explain query
13.70 ms
(2.54%) 		1 
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(683)
Parameters: 
[]
View formatted query    View runnable query    Explain query
6.28 ms
(1.17%) 		1 
SELECT  dest_id,  count(src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11190, 11409, 11191, 11196, 11194, 11197, 11195)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)

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

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.