Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

45 Database Queries

21 Different statements

170.56 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


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
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
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
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
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
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
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

#▲	Time	Info
1	0.33 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`] View formatted query View runnable query Explain query 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 SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.09 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SiteConfig"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SiteConfig';
4	0.16 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`] View formatted query View runnable query Explain query 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 SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.08 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BlogPortal"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BlogPortal';
7	0.38 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/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles" "sourcePathQuery" => "/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles?randSeed=474&nearbySearchId=47581501&nearbySearchLat=47.52833&nearbySearchLong=15.41605&_=1731456000000" "sourceEntireUri" => "https://stage.steiermark.com/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles?_=1731456000000&nearbySearchId=47581501&nearbySearchLat=47.52833&nearbySearchLong=15.41605&randSeed=474" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"] View formatted query View runnable query Explain query 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 SELECT * FROM redirects WHERE ( (source = '/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles?randSeed=474&nearbySearchId=47581501&nearbySearchLat=47.52833&nearbySearchLong=15.41605&_=1731456000000' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles?_=1731456000000&nearbySearchId=47581501&nearbySearchLat=47.52833&nearbySearchLong=15.41605&randSeed=474' AND `type` = 'entire_uri') ) 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;
8	0.12 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "reports" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
9	0.11 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "bubbles" "path" => "/steiermark.com/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/' AND `key` = BINARY 'bubbles';
10	0.10 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/steiermark.com/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/steiermark.com/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles';
11	0.14 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles';
12	0.10 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Unterkuenfte-suchen-und-buchen" "path" => "/steiermark.com/de/Suedsteiermark/Urlaub-planen/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/de/Suedsteiermark/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte-suchen-und-buchen';
13	0.12 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
14	0.17 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6515`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6515;
15	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"21"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '21';
16	0.15 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`10835`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 10835;
17	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"72"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '72';
18	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"68"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '68';
19	0.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"18"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '18';
20	0.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"51"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '51';
21	0.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"30"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '30';
22	0.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"59"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '59';
23	0.39 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: [`6938`] View formatted query View runnable query Explain query 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 SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

#▲	Time	Info
1	8.63 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 (6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947)) GROUP BY dacco.oo_id ORDER BY RAND(474) Parameters: [] View formatted query View runnable query Explain query 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 ( 6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947 ) ) GROUP BY dacco.oo_id ORDER BY RAND(474) 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 (6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947)) GROUP BY dacco.oo_id ORDER BY RAND(474) ;
2	72.91 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 (31474,18290,29829,1986509,18165472,26626,30101,29754,30724471,48905586,4791432,19158,20707,46529,2064618,20291,54523,17030,40768,1989224,55324,35341,4063160,35206874,52190,11365272,28278,2065098,18776204,40473,1993878,27740,46968,50584316,24971,47247,21622,1987680,21489,1989189,41879,46933,1994480,46284,19054,1986681,52801,39007,54118,2059447,48496,41546,25763,46874,2066111,52545,2058512,4525614,50189,53293,4061122,28587,30843,25667,26506,2064168,32550,2061355,47606,47710,1986219,39297,2062596,2058626,20643,35324,41198724,51357,46733,36492,53474,4761749,8142109,44782,36299,22003,49046532,54660,2058868,1990242,40425,42551,2065425,32147,31543,27807120,36935,33905,32305843,30764208,1985114,19725,12910729,1993946,50011,1994761,35666823,1988269,4061187,26851,20810,35666833,33519,9455693,16110362,1990091,28492,55395,46636,53159,52068,17115,14049003,34270,30756,30354,30731557,2065944,2062885,42753173,2063926,30359,2059767,51034,1433530,47131,28470795,25522,35330412,22953,37827,48663392,1993209,27298,6645142,28657,37942,52516,17418,10114007,28980,46316,1990469,30482936,1987585,21363,1984760,367391,20577,43155,34969921,35382,27294,27685,43125,2684053,29903,367184,46578,1986476,44781629,46206,41793,50194,8537205,47196,42237,53418,28876,44831,35989,38373,1993645,1985962,2060384,22213550,2059260,17227,51974,1988347,24793,4063051,29585,2063196,27471,43837572,47981,1991966,1343842,15843263,45923,1991623,51301,1986627,2059361,45756971,48675,38549,11367489,43472,35994,45548175,36664,7738640,42911,44050,24523,11436541,17904,1987339,4061075,2060738,1984997,37308,1833139,31259,2060516,33100,43065,43526,28867356,55242,1993438,38423,1987095,18680,2065496,16854,1987221,31422,9313566,7738339,48625745,1990911,27520,1990954,50593655,49910,1993811,26431,2193918,46250,48050342,1987463,7351637,55010,1989566,24448,29658071,1989012,37859,2064954,18560,27631,1989882,1992224,18152,24118,39687,59655,39377,1987293,1985246,1987973,1994800,40704,43433,10664738,20023418,46201539,30773134,50963,45797,31843325,47781,18042,30400,1995175,48625751,48017,39922,47257351,1986758,19754,5367353,11364731,32751,2062975,41935,2060465,30565,24985,9283115,2066133,18272,20782,24580,1989465,21585,42977,27868,36160,1995103,43384,1994732,5367477,18891,26570,43686,1988874,20840,54339,23991,4608272,41198698,32689,54763,2058557,49158,21821,2059571,35206879,30980,53913,38807,48863,2059088,35070,18943,1989419,17770,31960,34983,1988207,17120,18328480,19286,29109,24242,2063091,2062684,38904,16421480,29614,2059839,41366,1990504,45122,43641,2063458,25101,28091523,21427,35238,18746,27820,41494,17593634,50760,44587191,31953,1988816,32750792,48570,19208,36655,43804,21284,49387,1985474,31336,13440568,36100,36531210,37217,4061338,42350,43184382,47463,42753168,55108,43414,22775,1991492,25366,31203,17823,17670,27825,1985174,45582,35740,53010,4580754,20108,54695,1989075,1994502,1994374,19587,5949155,48928,36716325,1987706,1991534,1986795,21942,1993242,32582,34887538,50850,30751,32076506,48663426,367300,19812,1989698,12879307,39454,23720,1985415,18813,33077,44387,1994096,21859,2060888,35736,45756981,1986015,3263472,54166,36227,46597852,19244,28867353,52727,49497910,29836686,42655,18432,45082,27419533,1990037,19029556,21239,17676,32478,23077,19475,48365,38616,32802,14913865,1992394,49189,367148,48663405,1992182,49548929,33992180,32658,23055,15498539,25942,26717,34358,23920,1986946,4063277,54798,45252,39558266,25414206,47398,1995257,1989832,1987149,52476,1989306,50718,17811174,49502,47888734,41239,31625,17541,28124,36531205,25766745,1987270,50086,46152494,27384,26890,23435,1988731,2062410,35456,1994545,31117139,3263475,12879304,42841,43594,32353,25156,29619,19558,4061087,1994693,44222,31772,53347,27082,17001,4061211,1986433,42785,18230,1988766,17626,367295,39231,367388,1991413,1985660,21543,35666828,51833,25423486,36066,18375,29658091,29104,34180,1993711,37484,1989517,50135,34716,11185192,34831,44339,41198692,24173653,36095,36327,47487,1986865,19852,1988937,41710,54374,28508,1989124,33178,1994822,2853535,31755375,45319,16889,23500,21327,9484915,44781642,1988139,51151,19612,45143324,52662,28828,25806,23620,1984665,49229,47921,35566,12948653,43758,1990830,1988015,44660,22916,52769,29907,28923,37175,48905589,47830,24781077,1984904,1984959,45503,39083,17354,42581,48890,41615,1992841,45375,1146742,40556,24375268,35697,1985351,47614112,15375608,39198,16922,20203610,25766748,33331,29764,34013,35655,39575,16975,12910566,41649,19115,53817,21368,18520,17126,1993620,26721,53593,2064513,38480,22047,1986716,1987442,55167,20885,1986581,54243,1990539,29658076,18015,1985522,7951197,2063414,39998,20668,36427,1989922,1990285,48716,49790,4149206,25724,45054,21179,27568,37746,48625748,33768,2066268,1989734,31967,53743,1984508,33401,1987314,31291,45756976,22441,42114,1988385,9529160,20989,33031,53783,38583,53948,45198113,2853499,28920,22612,26337,1993788,12879310,21032,53239,22475,44172,1990181,25273,21659,2064808,37365,1146711,46450,50325,12279128,32108,1994889,20188,2063745,28867350,18462,32298578,41160,1989268,42428,27056,6945367,52980,14659516,26578533,2059991,25025,30852,1992261,29547,41842,33898,50692778,19857,32806,29658086,33451,40646,25500,1990403,32010,49548934,53131,49276,29671,2064720,36617,1986914,38060,17068,31340,35829,54464,30448600,43702020,46992771,4061295,25723022) 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 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 ( 31474, 18290, 29829, 1986509, 18165472, 26626, 30101, 29754, 30724471, 48905586, 4791432, 19158, 20707, 46529, 2064618, 20291, 54523, 17030, 40768, 1989224, 55324, 35341, 4063160, 35206874, 52190, 11365272, 28278, 2065098, 18776204, 40473, 1993878, 27740, 46968, 50584316, 24971, 47247, 21622, 1987680, 21489, 1989189, 41879, 46933, 1994480, 46284, 19054, 1986681, 52801, 39007, 54118, 2059447, 48496, 41546, 25763, 46874, 2066111, 52545, 2058512, 4525614, 50189, 53293, 4061122, 28587, 30843, 25667, 26506, 2064168, 32550, 2061355, 47606, 47710, 1986219, 39297, 2062596, 2058626, 20643, 35324, 41198724, 51357, 46733, 36492, 53474, 4761749, 8142109, 44782, 36299, 22003, 49046532, 54660, 2058868, 1990242, 40425, 42551, 2065425, 32147, 31543, 27807120, 36935, 33905, 32305843, 30764208, 1985114, 19725, 12910729, 1993946, 50011, 1994761, 35666823, 1988269, 4061187, 26851, 20810, 35666833, 33519, 9455693, 16110362, 1990091, 28492, 55395, 46636, 53159, 52068, 17115, 14049003, 34270, 30756, 30354, 30731557, 2065944, 2062885, 42753173, 2063926, 30359, 2059767, 51034, 1433530, 47131, 28470795, 25522, 35330412, 22953, 37827, 48663392, 1993209, 27298, 6645142, 28657, 37942, 52516, 17418, 10114007, 28980, 46316, 1990469, 30482936, 1987585, 21363, 1984760, 367391, 20577, 43155, 34969921, 35382, 27294, 27685, 43125, 2684053, 29903, 367184, 46578, 1986476, 44781629, 46206, 41793, 50194, 8537205, 47196, 42237, 53418, 28876, 44831, 35989, 38373, 1993645, 1985962, 2060384, 22213550, 2059260, 17227, 51974, 1988347, 24793, 4063051, 29585, 2063196, 27471, 43837572, 47981, 1991966, 1343842, 15843263, 45923, 1991623, 51301, 1986627, 2059361, 45756971, 48675, 38549, 11367489, 43472, 35994, 45548175, 36664, 7738640, 42911, 44050, 24523, 11436541, 17904, 1987339, 4061075, 2060738, 1984997, 37308, 1833139, 31259, 2060516, 33100, 43065, 43526, 28867356, 55242, 1993438, 38423, 1987095, 18680, 2065496, 16854, 1987221, 31422, 9313566, 7738339, 48625745, 1990911, 27520, 1990954, 50593655, 49910, 1993811, 26431, 2193918, 46250, 48050342, 1987463, 7351637, 55010, 1989566, 24448, 29658071, 1989012, 37859, 2064954, 18560, 27631, 1989882, 1992224, 18152, 24118, 39687, 59655, 39377, 1987293, 1985246, 1987973, 1994800, 40704, 43433, 10664738, 20023418, 46201539, 30773134, 50963, 45797, 31843325, 47781, 18042, 30400, 1995175, 48625751, 48017, 39922, 47257351, 1986758, 19754, 5367353, 11364731, 32751, 2062975, 41935, 2060465, 30565, 24985, 9283115, 2066133, 18272, 20782, 24580, 1989465, 21585, 42977, 27868, 36160, 1995103, 43384, 1994732, 5367477, 18891, 26570, 43686, 1988874, 20840, 54339, 23991, 4608272, 41198698, 32689, 54763, 2058557, 49158, 21821, 2059571, 35206879, 30980, 53913, 38807, 48863, 2059088, 35070, 18943, 1989419, 17770, 31960, 34983, 1988207, 17120, 18328480, 19286, 29109, 24242, 2063091, 2062684, 38904, 16421480, 29614, 2059839, 41366, 1990504, 45122, 43641, 2063458, 25101, 28091523, 21427, 35238, 18746, 27820, 41494, 17593634, 50760, 44587191, 31953, 1988816, 32750792, 48570, 19208, 36655, 43804, 21284, 49387, 1985474, 31336, 13440568, 36100, 36531210, 37217, 4061338, 42350, 43184382, 47463, 42753168, 55108, 43414, 22775, 1991492, 25366, 31203, 17823, 17670, 27825, 1985174, 45582, 35740, 53010, 4580754, 20108, 54695, 1989075, 1994502, 1994374, 19587, 5949155, 48928, 36716325, 1987706, 1991534, 1986795, 21942, 1993242, 32582, 34887538, 50850, 30751, 32076506, 48663426, 367300, 19812, 1989698, 12879307, 39454, 23720, 1985415, 18813, 33077, 44387, 1994096, 21859, 2060888, 35736, 45756981, 1986015, 3263472, 54166, 36227, 46597852, 19244, 28867353, 52727, 49497910, 29836686, 42655, 18432, 45082, 27419533, 1990037, 19029556, 21239, 17676, 32478, 23077, 19475, 48365, 38616, 32802, 14913865, 1992394, 49189, 367148, 48663405, 1992182, 49548929, 33992180, 32658, 23055, 15498539, 25942, 26717, 34358, 23920, 1986946, 4063277, 54798, 45252, 39558266, 25414206, 47398, 1995257, 1989832, 1987149, 52476, 1989306, 50718, 17811174, 49502, 47888734, 41239, 31625, 17541, 28124, 36531205, 25766745, 1987270, 50086, 46152494, 27384, 26890, 23435, 1988731, 2062410, 35456, 1994545, 31117139, 3263475, 12879304, 42841, 43594, 32353, 25156, 29619, 19558, 4061087, 1994693, 44222, 31772, 53347, 27082, 17001, 4061211, 1986433, 42785, 18230, 1988766, 17626, 367295, 39231, 367388, 1991413, 1985660, 21543, 35666828, 51833, 25423486, 36066, 18375, 29658091, 29104, 34180, 1993711, 37484, 1989517, 50135, 34716, 11185192, 34831, 44339, 41198692, 24173653, 36095, 36327, 47487, 1986865, 19852, 1988937, 41710, 54374, 28508, 1989124, 33178, 1994822, 2853535, 31755375, 45319, 16889, 23500, 21327, 9484915, 44781642, 1988139, 51151, 19612, 45143324, 52662, 28828, 25806, 23620, 1984665, 49229, 47921, 35566, 12948653, 43758, 1990830, 1988015, 44660, 22916, 52769, 29907, 28923, 37175, 48905589, 47830, 24781077, 1984904, 1984959, 45503, 39083, 17354, 42581, 48890, 41615, 1992841, 45375, 1146742, 40556, 24375268, 35697, 1985351, 47614112, 15375608, 39198, 16922, 20203610, 25766748, 33331, 29764, 34013, 35655, 39575, 16975, 12910566, 41649, 19115, 53817, 21368, 18520, 17126, 1993620, 26721, 53593, 2064513, 38480, 22047, 1986716, 1987442, 55167, 20885, 1986581, 54243, 1990539, 29658076, 18015, 1985522, 7951197, 2063414, 39998, 20668, 36427, 1989922, 1990285, 48716, 49790, 4149206, 25724, 45054, 21179, 27568, 37746, 48625748, 33768, 2066268, 1989734, 31967, 53743, 1984508, 33401, 1987314, 31291, 45756976, 22441, 42114, 1988385, 9529160, 20989, 33031, 53783, 38583, 53948, 45198113, 2853499, 28920, 22612, 26337, 1993788, 12879310, 21032, 53239, 22475, 44172, 1990181, 25273, 21659, 2064808, 37365, 1146711, 46450, 50325, 12279128, 32108, 1994889, 20188, 2063745, 28867350, 18462, 32298578, 41160, 1989268, 42428, 27056, 6945367, 52980, 14659516, 26578533, 2059991, 25025, 30852, 1992261, 29547, 41842, 33898, 50692778, 19857, 32806, 29658086, 33451, 40646, 25500, 1990403, 32010, 49548934, 53131, 49276, 29671, 2064720, 36617, 1986914, 38060, 17068, 31340, 35829, 54464, 30448600, 43702020, 46992771, 4061295, 25723022 ) 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 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 (31474,18290,29829,1986509,18165472,26626,30101,29754,30724471,48905586,4791432,19158,20707,46529,2064618,20291,54523,17030,40768,1989224,55324,35341,4063160,35206874,52190,11365272,28278,2065098,18776204,40473,1993878,27740,46968,50584316,24971,47247,21622,1987680,21489,1989189,41879,46933,1994480,46284,19054,1986681,52801,39007,54118,2059447,48496,41546,25763,46874,2066111,52545,2058512,4525614,50189,53293,4061122,28587,30843,25667,26506,2064168,32550,2061355,47606,47710,1986219,39297,2062596,2058626,20643,35324,41198724,51357,46733,36492,53474,4761749,8142109,44782,36299,22003,49046532,54660,2058868,1990242,40425,42551,2065425,32147,31543,27807120,36935,33905,32305843,30764208,1985114,19725,12910729,1993946,50011,1994761,35666823,1988269,4061187,26851,20810,35666833,33519,9455693,16110362,1990091,28492,55395,46636,53159,52068,17115,14049003,34270,30756,30354,30731557,2065944,2062885,42753173,2063926,30359,2059767,51034,1433530,47131,28470795,25522,35330412,22953,37827,48663392,1993209,27298,6645142,28657,37942,52516,17418,10114007,28980,46316,1990469,30482936,1987585,21363,1984760,367391,20577,43155,34969921,35382,27294,27685,43125,2684053,29903,367184,46578,1986476,44781629,46206,41793,50194,8537205,47196,42237,53418,28876,44831,35989,38373,1993645,1985962,2060384,22213550,2059260,17227,51974,1988347,24793,4063051,29585,2063196,27471,43837572,47981,1991966,1343842,15843263,45923,1991623,51301,1986627,2059361,45756971,48675,38549,11367489,43472,35994,45548175,36664,7738640,42911,44050,24523,11436541,17904,1987339,4061075,2060738,1984997,37308,1833139,31259,2060516,33100,43065,43526,28867356,55242,1993438,38423,1987095,18680,2065496,16854,1987221,31422,9313566,7738339,48625745,1990911,27520,1990954,50593655,49910,1993811,26431,2193918,46250,48050342,1987463,7351637,55010,1989566,24448,29658071,1989012,37859,2064954,18560,27631,1989882,1992224,18152,24118,39687,59655,39377,1987293,1985246,1987973,1994800,40704,43433,10664738,20023418,46201539,30773134,50963,45797,31843325,47781,18042,30400,1995175,48625751,48017,39922,47257351,1986758,19754,5367353,11364731,32751,2062975,41935,2060465,30565,24985,9283115,2066133,18272,20782,24580,1989465,21585,42977,27868,36160,1995103,43384,1994732,5367477,18891,26570,43686,1988874,20840,54339,23991,4608272,41198698,32689,54763,2058557,49158,21821,2059571,35206879,30980,53913,38807,48863,2059088,35070,18943,1989419,17770,31960,34983,1988207,17120,18328480,19286,29109,24242,2063091,2062684,38904,16421480,29614,2059839,41366,1990504,45122,43641,2063458,25101,28091523,21427,35238,18746,27820,41494,17593634,50760,44587191,31953,1988816,32750792,48570,19208,36655,43804,21284,49387,1985474,31336,13440568,36100,36531210,37217,4061338,42350,43184382,47463,42753168,55108,43414,22775,1991492,25366,31203,17823,17670,27825,1985174,45582,35740,53010,4580754,20108,54695,1989075,1994502,1994374,19587,5949155,48928,36716325,1987706,1991534,1986795,21942,1993242,32582,34887538,50850,30751,32076506,48663426,367300,19812,1989698,12879307,39454,23720,1985415,18813,33077,44387,1994096,21859,2060888,35736,45756981,1986015,3263472,54166,36227,46597852,19244,28867353,52727,49497910,29836686,42655,18432,45082,27419533,1990037,19029556,21239,17676,32478,23077,19475,48365,38616,32802,14913865,1992394,49189,367148,48663405,1992182,49548929,33992180,32658,23055,15498539,25942,26717,34358,23920,1986946,4063277,54798,45252,39558266,25414206,47398,1995257,1989832,1987149,52476,1989306,50718,17811174,49502,47888734,41239,31625,17541,28124,36531205,25766745,1987270,50086,46152494,27384,26890,23435,1988731,2062410,35456,1994545,31117139,3263475,12879304,42841,43594,32353,25156,29619,19558,4061087,1994693,44222,31772,53347,27082,17001,4061211,1986433,42785,18230,1988766,17626,367295,39231,367388,1991413,1985660,21543,35666828,51833,25423486,36066,18375,29658091,29104,34180,1993711,37484,1989517,50135,34716,11185192,34831,44339,41198692,24173653,36095,36327,47487,1986865,19852,1988937,41710,54374,28508,1989124,33178,1994822,2853535,31755375,45319,16889,23500,21327,9484915,44781642,1988139,51151,19612,45143324,52662,28828,25806,23620,1984665,49229,47921,35566,12948653,43758,1990830,1988015,44660,22916,52769,29907,28923,37175,48905589,47830,24781077,1984904,1984959,45503,39083,17354,42581,48890,41615,1992841,45375,1146742,40556,24375268,35697,1985351,47614112,15375608,39198,16922,20203610,25766748,33331,29764,34013,35655,39575,16975,12910566,41649,19115,53817,21368,18520,17126,1993620,26721,53593,2064513,38480,22047,1986716,1987442,55167,20885,1986581,54243,1990539,29658076,18015,1985522,7951197,2063414,39998,20668,36427,1989922,1990285,48716,49790,4149206,25724,45054,21179,27568,37746,48625748,33768,2066268,1989734,31967,53743,1984508,33401,1987314,31291,45756976,22441,42114,1988385,9529160,20989,33031,53783,38583,53948,45198113,2853499,28920,22612,26337,1993788,12879310,21032,53239,22475,44172,1990181,25273,21659,2064808,37365,1146711,46450,50325,12279128,32108,1994889,20188,2063745,28867350,18462,32298578,41160,1989268,42428,27056,6945367,52980,14659516,26578533,2059991,25025,30852,1992261,29547,41842,33898,50692778,19857,32806,29658086,33451,40646,25500,1990403,32010,49548934,53131,49276,29671,2064720,36617,1986914,38060,17068,31340,35829,54464,30448600,43702020,46992771,4061295,25723022) 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 ;
3	8.47 ms	SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (31474,18290,1986509,26626,30101,29754,30724471,19158,46529,2064618,20291,54523,17030,40768,1989224,55324,35341,4063160,35206874,52190,11365272,28278,2065098,18776204,40473,1993878,27740,46968,24971,47247,21622,1987680,21489,1989189,41879,46933,1994480,46284,19054,1986681,52801,39007,54118,2059447,48496,41546,25763,46874,2066111,52545,2058512,4525614,50189,53293,4061122,28587,25667,26506,2064168,32550,2061355,47606,47710,1986219,39297,2062596,2058626,20643,35324,51357,46733,36492,53474,4761749,8142109,44782,36299,22003,54660,2058868,1990242,40425,42551,2065425,32147,31543,27807120,36935,33905,32305843,30764208,1985114,19725,12910729,1993946,50011,1994761,35666823,1988269,4061187,26851,20810,35666833,33519,9455693,16110362,1990091,55395,46636,53159,52068,34270,30756,30731557,2065944,2062885,2063926,2059767,51034,1433530,47131,28470795,25522,35330412,22953,37827,1993209,27298,6645142,28657,37942,52516,17418,10114007,28980,46316,1990469,30482936,1987585,21363,1984760,20577,43155,35382,27294,27685,43125,2684053,46578,1986476,46206,41793,50194,8537205,47196,42237,53418,28876,44831,35989,38373,1993645,1985962,2060384,2059260,17227,51974,1988347,24793,4063051,29585,2063196,27471,43837572,47981,1991966,1343842,15843263,45923,1991623,51301,1986627,2059361,38549,11367489,43472,35994,36664,7738640,42911,44050,24523,11436541,17904,1987339,2060738,1984997,37308,1833139,2060516,33100,43065,43526,55242,1993438,38423,1987095,18680,2065496,16854,1987221,31422,9313566,7738339,1990911,27520,1990954,49910,1993811,46250,1987463,7351637,55010,1989566,24448,1989012,37859,2064954,18560,27631,1989882,1992224,18152,24118,39687,59655,39377,1987293,1985246,1987973,1994800,40704,43433,10664738,20023418,30773134,50963,45797,31843325,47781,18042,30400,1995175,48017,39922,1986758,19754,5367353,11364731,2062975,2060465,30565,24985,9283115,2066133,18272,20782,24580,1989465,21585,42977,27868,36160,1995103,43384,1994732,5367477,18891,26570,43686,1988874,20840,54339,23991,4608272,41198698,32689,54763,2058557,49158,21821,2059571,35206879,30980,53913,38807,2059088,35070,18943,1989419,17770,34983,1988207,18328480,19286,29109,24242,2063091,2062684,38904,2059839,41366,1990504,45122,43641,2063458,25101,28091523,21427,35238,18746,41494,17593634,50760,44587191,1988816,32750792,48570,19208,43804,21284,49387,1985474,31336,36100,36531210,37217,4061338,42350,43184382,42753168,55108,43414,22775,1991492,25366,31203,17823,27825,1985174,45582,35740,53010,4580754,20108,54695,1989075,1994502,1994374,19587,5949155,48928,1987706,1991534,1986795,21942,1993242,32582,34887538,50850,32076506,367300,19812,1989698,12879307,39454,23720,1985415,18813,33077,44387,1994096,21859,2060888,1986015,3263472,54166,36227,19244,28867353,52727,49497910,29836686,42655,18432,45082,27419533,1990037,19029556,21239,17676,32478,23077,19475,48365,38616,32802,14913865,1992394,49189,367148,1992182,32658,23055,15498539,25942,34358,23920,1986946,4063277,54798,45252,39558266,25414206,47398,1995257,1989832,1987149,52476,1989306,50718,17811174,49502,41239,31625,17541,28124,36531205,25766745,1987270,50086,46152494,27384,26890,23435,1988731,2062410,35456,1994545,31117139,3263475,12879304,42841,43594,25156,29619,19558,4061087,1994693,44222,31772,53347,27082,4061211,1986433,42785,18230,1988766,17626,39231,1991413,1985660,21543,35666828,51833,25423486,36066,18375,34180,1993711,37484,1989517,50135,34716,11185192,34831,44339,24173653,36095,36327,47487,1986865,19852,1988937,41710,54374,28508,1989124,1994822,2853535,31755375,45319,16889,23500,21327,9484915,44781642,1988139,51151,19612,45143324,52662,28828,25806,23620,1984665,49229,47921,35566,43758,1990830,1988015,44660,22916,52769,29907,28923,37175,48905589,47830,24781077,1984904,1984959,45503,39083,17354,42581,48890,41615,1992841,45375,1146742,40556,24375268,35697,1985351,15375608,39198,16922,20203610,25766748,33331,29764,34013,35655,39575,16975,12910566,41649,19115,53817,21368,18520,17126,26721,53593,2064513,38480,22047,1986716,1987442,55167,20885,1986581,54243,1990539,18015,1985522,7951197,2063414,39998,20668,1989922,1990285,48716,49790,4149206,25724,45054,21179,27568,37746,33768,2066268,1989734,31967,53743,1984508,33401,1987314,31291,22441,42114,1988385,9529160,20989,33031,53783,38583,53948,26337,1993788,21032,53239,22475,44172,1990181,25273,21659,2064808,37365,1146711,46450,50325,12279128,1994889,20188,2063745,18462,32298578,41160,1989268,42428,6945367,52980,14659516,2059991,25025,30852,1992261,29547,41842,33898,19857,32806,33451,40646,1990403,32010,49548934,53131,49276,29671,2064720,36617,1986914,38060,17068,31340,35829,54464,30448600,43702020,25723022,29829,18165472,48905586,4791432,20707,50584316,30843,41198724,49046532,28492,17115,14049003,30354,42753173,30359,48663392,367391,34969921,29903,367184,44781629,22213550,45756971,48675,45548175,4061075,31259,28867356,48625745,50593655,26431,2193918,48050342,29658071,46201539,48625751,47257351,32751,41935,48863,31960,17120,16421480,29614,27820,31953,36655,13440568,47463,17670,36716325,30751,48663426,35736,45756981,46597852,48663405,49548929,33992180,26717,47888734,32353,17001,367295,367388,29658091,29104,41198692,33178,12948653,47614112,1993620,29658076,36427,48625748,45756976,45198113,2853499,28920,22612,12879310,32108,28867350,27056,26578533,50692778,29658086,25500,46992771,4061295) AND dacco.o_published = 1 AND (dacco.town__id IN (6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947)) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) Parameters: [] View formatted query View runnable query Explain query SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN ( 31474, 18290, 1986509, 26626, 30101, 29754, 30724471, 19158, 46529, 2064618, 20291, 54523, 17030, 40768, 1989224, 55324, 35341, 4063160, 35206874, 52190, 11365272, 28278, 2065098, 18776204, 40473, 1993878, 27740, 46968, 24971, 47247, 21622, 1987680, 21489, 1989189, 41879, 46933, 1994480, 46284, 19054, 1986681, 52801, 39007, 54118, 2059447, 48496, 41546, 25763, 46874, 2066111, 52545, 2058512, 4525614, 50189, 53293, 4061122, 28587, 25667, 26506, 2064168, 32550, 2061355, 47606, 47710, 1986219, 39297, 2062596, 2058626, 20643, 35324, 51357, 46733, 36492, 53474, 4761749, 8142109, 44782, 36299, 22003, 54660, 2058868, 1990242, 40425, 42551, 2065425, 32147, 31543, 27807120, 36935, 33905, 32305843, 30764208, 1985114, 19725, 12910729, 1993946, 50011, 1994761, 35666823, 1988269, 4061187, 26851, 20810, 35666833, 33519, 9455693, 16110362, 1990091, 55395, 46636, 53159, 52068, 34270, 30756, 30731557, 2065944, 2062885, 2063926, 2059767, 51034, 1433530, 47131, 28470795, 25522, 35330412, 22953, 37827, 1993209, 27298, 6645142, 28657, 37942, 52516, 17418, 10114007, 28980, 46316, 1990469, 30482936, 1987585, 21363, 1984760, 20577, 43155, 35382, 27294, 27685, 43125, 2684053, 46578, 1986476, 46206, 41793, 50194, 8537205, 47196, 42237, 53418, 28876, 44831, 35989, 38373, 1993645, 1985962, 2060384, 2059260, 17227, 51974, 1988347, 24793, 4063051, 29585, 2063196, 27471, 43837572, 47981, 1991966, 1343842, 15843263, 45923, 1991623, 51301, 1986627, 2059361, 38549, 11367489, 43472, 35994, 36664, 7738640, 42911, 44050, 24523, 11436541, 17904, 1987339, 2060738, 1984997, 37308, 1833139, 2060516, 33100, 43065, 43526, 55242, 1993438, 38423, 1987095, 18680, 2065496, 16854, 1987221, 31422, 9313566, 7738339, 1990911, 27520, 1990954, 49910, 1993811, 46250, 1987463, 7351637, 55010, 1989566, 24448, 1989012, 37859, 2064954, 18560, 27631, 1989882, 1992224, 18152, 24118, 39687, 59655, 39377, 1987293, 1985246, 1987973, 1994800, 40704, 43433, 10664738, 20023418, 30773134, 50963, 45797, 31843325, 47781, 18042, 30400, 1995175, 48017, 39922, 1986758, 19754, 5367353, 11364731, 2062975, 2060465, 30565, 24985, 9283115, 2066133, 18272, 20782, 24580, 1989465, 21585, 42977, 27868, 36160, 1995103, 43384, 1994732, 5367477, 18891, 26570, 43686, 1988874, 20840, 54339, 23991, 4608272, 41198698, 32689, 54763, 2058557, 49158, 21821, 2059571, 35206879, 30980, 53913, 38807, 2059088, 35070, 18943, 1989419, 17770, 34983, 1988207, 18328480, 19286, 29109, 24242, 2063091, 2062684, 38904, 2059839, 41366, 1990504, 45122, 43641, 2063458, 25101, 28091523, 21427, 35238, 18746, 41494, 17593634, 50760, 44587191, 1988816, 32750792, 48570, 19208, 43804, 21284, 49387, 1985474, 31336, 36100, 36531210, 37217, 4061338, 42350, 43184382, 42753168, 55108, 43414, 22775, 1991492, 25366, 31203, 17823, 27825, 1985174, 45582, 35740, 53010, 4580754, 20108, 54695, 1989075, 1994502, 1994374, 19587, 5949155, 48928, 1987706, 1991534, 1986795, 21942, 1993242, 32582, 34887538, 50850, 32076506, 367300, 19812, 1989698, 12879307, 39454, 23720, 1985415, 18813, 33077, 44387, 1994096, 21859, 2060888, 1986015, 3263472, 54166, 36227, 19244, 28867353, 52727, 49497910, 29836686, 42655, 18432, 45082, 27419533, 1990037, 19029556, 21239, 17676, 32478, 23077, 19475, 48365, 38616, 32802, 14913865, 1992394, 49189, 367148, 1992182, 32658, 23055, 15498539, 25942, 34358, 23920, 1986946, 4063277, 54798, 45252, 39558266, 25414206, 47398, 1995257, 1989832, 1987149, 52476, 1989306, 50718, 17811174, 49502, 41239, 31625, 17541, 28124, 36531205, 25766745, 1987270, 50086, 46152494, 27384, 26890, 23435, 1988731, 2062410, 35456, 1994545, 31117139, 3263475, 12879304, 42841, 43594, 25156, 29619, 19558, 4061087, 1994693, 44222, 31772, 53347, 27082, 4061211, 1986433, 42785, 18230, 1988766, 17626, 39231, 1991413, 1985660, 21543, 35666828, 51833, 25423486, 36066, 18375, 34180, 1993711, 37484, 1989517, 50135, 34716, 11185192, 34831, 44339, 24173653, 36095, 36327, 47487, 1986865, 19852, 1988937, 41710, 54374, 28508, 1989124, 1994822, 2853535, 31755375, 45319, 16889, 23500, 21327, 9484915, 44781642, 1988139, 51151, 19612, 45143324, 52662, 28828, 25806, 23620, 1984665, 49229, 47921, 35566, 43758, 1990830, 1988015, 44660, 22916, 52769, 29907, 28923, 37175, 48905589, 47830, 24781077, 1984904, 1984959, 45503, 39083, 17354, 42581, 48890, 41615, 1992841, 45375, 1146742, 40556, 24375268, 35697, 1985351, 15375608, 39198, 16922, 20203610, 25766748, 33331, 29764, 34013, 35655, 39575, 16975, 12910566, 41649, 19115, 53817, 21368, 18520, 17126, 26721, 53593, 2064513, 38480, 22047, 1986716, 1987442, 55167, 20885, 1986581, 54243, 1990539, 18015, 1985522, 7951197, 2063414, 39998, 20668, 1989922, 1990285, 48716, 49790, 4149206, 25724, 45054, 21179, 27568, 37746, 33768, 2066268, 1989734, 31967, 53743, 1984508, 33401, 1987314, 31291, 22441, 42114, 1988385, 9529160, 20989, 33031, 53783, 38583, 53948, 26337, 1993788, 21032, 53239, 22475, 44172, 1990181, 25273, 21659, 2064808, 37365, 1146711, 46450, 50325, 12279128, 1994889, 20188, 2063745, 18462, 32298578, 41160, 1989268, 42428, 6945367, 52980, 14659516, 2059991, 25025, 30852, 1992261, 29547, 41842, 33898, 19857, 32806, 33451, 40646, 1990403, 32010, 49548934, 53131, 49276, 29671, 2064720, 36617, 1986914, 38060, 17068, 31340, 35829, 54464, 30448600, 43702020, 25723022, 29829, 18165472, 48905586, 4791432, 20707, 50584316, 30843, 41198724, 49046532, 28492, 17115, 14049003, 30354, 42753173, 30359, 48663392, 367391, 34969921, 29903, 367184, 44781629, 22213550, 45756971, 48675, 45548175, 4061075, 31259, 28867356, 48625745, 50593655, 26431, 2193918, 48050342, 29658071, 46201539, 48625751, 47257351, 32751, 41935, 48863, 31960, 17120, 16421480, 29614, 27820, 31953, 36655, 13440568, 47463, 17670, 36716325, 30751, 48663426, 35736, 45756981, 46597852, 48663405, 49548929, 33992180, 26717, 47888734, 32353, 17001, 367295, 367388, 29658091, 29104, 41198692, 33178, 12948653, 47614112, 1993620, 29658076, 36427, 48625748, 45756976, 45198113, 2853499, 28920, 22612, 12879310, 32108, 28867350, 27056, 26578533, 50692778, 29658086, 25500, 46992771, 4061295 ) AND dacco.o_published = 1 AND ( dacco.town__id IN ( 6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947 ) ) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (31474,18290,1986509,26626,30101,29754,30724471,19158,46529,2064618,20291,54523,17030,40768,1989224,55324,35341,4063160,35206874,52190,11365272,28278,2065098,18776204,40473,1993878,27740,46968,24971,47247,21622,1987680,21489,1989189,41879,46933,1994480,46284,19054,1986681,52801,39007,54118,2059447,48496,41546,25763,46874,2066111,52545,2058512,4525614,50189,53293,4061122,28587,25667,26506,2064168,32550,2061355,47606,47710,1986219,39297,2062596,2058626,20643,35324,51357,46733,36492,53474,4761749,8142109,44782,36299,22003,54660,2058868,1990242,40425,42551,2065425,32147,31543,27807120,36935,33905,32305843,30764208,1985114,19725,12910729,1993946,50011,1994761,35666823,1988269,4061187,26851,20810,35666833,33519,9455693,16110362,1990091,55395,46636,53159,52068,34270,30756,30731557,2065944,2062885,2063926,2059767,51034,1433530,47131,28470795,25522,35330412,22953,37827,1993209,27298,6645142,28657,37942,52516,17418,10114007,28980,46316,1990469,30482936,1987585,21363,1984760,20577,43155,35382,27294,27685,43125,2684053,46578,1986476,46206,41793,50194,8537205,47196,42237,53418,28876,44831,35989,38373,1993645,1985962,2060384,2059260,17227,51974,1988347,24793,4063051,29585,2063196,27471,43837572,47981,1991966,1343842,15843263,45923,1991623,51301,1986627,2059361,38549,11367489,43472,35994,36664,7738640,42911,44050,24523,11436541,17904,1987339,2060738,1984997,37308,1833139,2060516,33100,43065,43526,55242,1993438,38423,1987095,18680,2065496,16854,1987221,31422,9313566,7738339,1990911,27520,1990954,49910,1993811,46250,1987463,7351637,55010,1989566,24448,1989012,37859,2064954,18560,27631,1989882,1992224,18152,24118,39687,59655,39377,1987293,1985246,1987973,1994800,40704,43433,10664738,20023418,30773134,50963,45797,31843325,47781,18042,30400,1995175,48017,39922,1986758,19754,5367353,11364731,2062975,2060465,30565,24985,9283115,2066133,18272,20782,24580,1989465,21585,42977,27868,36160,1995103,43384,1994732,5367477,18891,26570,43686,1988874,20840,54339,23991,4608272,41198698,32689,54763,2058557,49158,21821,2059571,35206879,30980,53913,38807,2059088,35070,18943,1989419,17770,34983,1988207,18328480,19286,29109,24242,2063091,2062684,38904,2059839,41366,1990504,45122,43641,2063458,25101,28091523,21427,35238,18746,41494,17593634,50760,44587191,1988816,32750792,48570,19208,43804,21284,49387,1985474,31336,36100,36531210,37217,4061338,42350,43184382,42753168,55108,43414,22775,1991492,25366,31203,17823,27825,1985174,45582,35740,53010,4580754,20108,54695,1989075,1994502,1994374,19587,5949155,48928,1987706,1991534,1986795,21942,1993242,32582,34887538,50850,32076506,367300,19812,1989698,12879307,39454,23720,1985415,18813,33077,44387,1994096,21859,2060888,1986015,3263472,54166,36227,19244,28867353,52727,49497910,29836686,42655,18432,45082,27419533,1990037,19029556,21239,17676,32478,23077,19475,48365,38616,32802,14913865,1992394,49189,367148,1992182,32658,23055,15498539,25942,34358,23920,1986946,4063277,54798,45252,39558266,25414206,47398,1995257,1989832,1987149,52476,1989306,50718,17811174,49502,41239,31625,17541,28124,36531205,25766745,1987270,50086,46152494,27384,26890,23435,1988731,2062410,35456,1994545,31117139,3263475,12879304,42841,43594,25156,29619,19558,4061087,1994693,44222,31772,53347,27082,4061211,1986433,42785,18230,1988766,17626,39231,1991413,1985660,21543,35666828,51833,25423486,36066,18375,34180,1993711,37484,1989517,50135,34716,11185192,34831,44339,24173653,36095,36327,47487,1986865,19852,1988937,41710,54374,28508,1989124,1994822,2853535,31755375,45319,16889,23500,21327,9484915,44781642,1988139,51151,19612,45143324,52662,28828,25806,23620,1984665,49229,47921,35566,43758,1990830,1988015,44660,22916,52769,29907,28923,37175,48905589,47830,24781077,1984904,1984959,45503,39083,17354,42581,48890,41615,1992841,45375,1146742,40556,24375268,35697,1985351,15375608,39198,16922,20203610,25766748,33331,29764,34013,35655,39575,16975,12910566,41649,19115,53817,21368,18520,17126,26721,53593,2064513,38480,22047,1986716,1987442,55167,20885,1986581,54243,1990539,18015,1985522,7951197,2063414,39998,20668,1989922,1990285,48716,49790,4149206,25724,45054,21179,27568,37746,33768,2066268,1989734,31967,53743,1984508,33401,1987314,31291,22441,42114,1988385,9529160,20989,33031,53783,38583,53948,26337,1993788,21032,53239,22475,44172,1990181,25273,21659,2064808,37365,1146711,46450,50325,12279128,1994889,20188,2063745,18462,32298578,41160,1989268,42428,6945367,52980,14659516,2059991,25025,30852,1992261,29547,41842,33898,19857,32806,33451,40646,1990403,32010,49548934,53131,49276,29671,2064720,36617,1986914,38060,17068,31340,35829,54464,30448600,43702020,25723022,29829,18165472,48905586,4791432,20707,50584316,30843,41198724,49046532,28492,17115,14049003,30354,42753173,30359,48663392,367391,34969921,29903,367184,44781629,22213550,45756971,48675,45548175,4061075,31259,28867356,48625745,50593655,26431,2193918,48050342,29658071,46201539,48625751,47257351,32751,41935,48863,31960,17120,16421480,29614,27820,31953,36655,13440568,47463,17670,36716325,30751,48663426,35736,45756981,46597852,48663405,49548929,33992180,26717,47888734,32353,17001,367295,367388,29658091,29104,41198692,33178,12948653,47614112,1993620,29658076,36427,48625748,45756976,45198113,2853499,28920,22612,12879310,32108,28867350,27056,26578533,50692778,29658086,25500,46992771,4061295) AND dacco.o_published = 1 AND (dacco.town__id IN (6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947)) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) ;
4	0.12 ms	create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (1986795),(23435),(55167),(38423),(46316),(54339),(52545),(44050),(45797),(49790),(25942),(30756),(28876),(18813),(25423486),(2060888),(49276),(1986681),(20203610),(48365),(41793),(34013),(33519),(30773134),(25522),(14659516),(28470795),(43125),(50325),(1984508),(42911),(46206),(1988139),(15843263),(30101),(2060516),(17676),(4061338),(7351637),(35070),(20023418),(35206874),(53159),(1986865),(7738640),(1992394),(5367477),(27685),(44172),(46874),(45122),(31203),(44339),(1991966),(49387),(17823),(38060),(1993645),(1833139),(55324),(53239),(38807),(55395),(1986627),(42841),(36492),(9529160),(46636),(50850),(10664738),(19852),(52190),(32689),(45252),(29547),(41198698),(1994374),(46578),(48017),(39558266),(55242),(36935),(5949155),(30731557),(32298578),(51151),(2064618),(11364731),(1146742),(19158),(41649),(53593),(47487),(37175),(38904),(11436541),(43837572),(2064720),(7738339),(35666833),(48905589),(41366),(21368),(43641),(9283115),(1984959),(1990285),(36531210),(44587191),(54695),(11365272),(24448),(18290),(1985415),(39231),(47606),(39454),(44831),(46733),(41239),(10114007),(24242),(47921),(21859),(40768),(18165472),(16110362),(24781077),(43702020),(1995257),(21659),(59655),(39377),(18328480),(27868),(1988874),(31117139),(367300),(41879),(23077),(30980),(41615),(33905),(36531205),(48570),(2684053),(42753168),(25025),(46250),(45143324),(31340),(40646),(17418),(1988816),(34358),(1984760),(12910566),(2059839),(25273),(20707),(1985660),(1993946),(17904),(26570),(53347),(41160),(12910729),(38373),(53743),(27419533),(44781642),(42350),(38480),(33451),(2059991),(24793),(48496),(28091523),(1995103),(1985522),(26337),(4149206),(46152494),(32010),(1985174),(1994889),(2065944),(8537205),(32305843),(38616),(43184382),(39575),(42655),(1984904),(20840),(20291),(50189),(2063745),(28657),(27471),(34983),(1988207),(1433530),(54798),(28124),(37365),(17593634),(40473),(24971),(1989566),(34831),(2063458),(39083),(43526),(4061122),(26431),(44387),(1986716),(35330412),(23620),(43804),(31772),(20577),(1987706),(36664),(26721),(12879304),(1988937),(44660),(45582),(1988385),(36617),(43414),(46450),(1993711),(40556),(54523),(25766745),(1986946),(19857),(48890),(50086),(47398),(46968),(39687),(1994545),(45319),(37217),(35666828),(44781629),(1987463),(42428),(53948),(26851),(49502),(49548934),(1985474),(47247),(18746),(43758),(35666823),(22475),(20108),(1994732),(15498539),(4525614),(33768),(44222),(2064808),(23500),(52476),(1993242),(9455693),(1993811),(45375),(1993878),(17126),(2065496),(4061187),(28278),(30482936),(50194),(1990539),(18432),(39998),(32353),(6645142),(27631),(51034),(43155),(40425),(2061355),(37942),(45198113),(36327),(54166),(51833),(8142109),(2059260),(14913865),(19475),(35206879),(28867350),(22213550),(2062684),(15375608),(18462),(4761749),(1990954),(52801),(1993209),(2062410),(17811174),(18680),(28867356),(25763),(33100),(23991),(19115),(45054),(11367489),(35324),(31422),(21427),(18776204),(30565),(4061211),(43065),(31625),(47781),(9484915),(39297),(1992182),(1986015),(1991492),(1984997),(39007),(35382),(31843325),(31474),(1989306),(12279128),(1146711),(51357),(36160),(43433),(37746),(31543),(35655),(49497910),(42581),(34270),(9313566),(50011),(1987095),(28828),(23920),(25723022),(32750792),(47131),(42114),(1984665),(53474),(30764208),(1992261),(18042),(28587),(1989012),(1991623),(24375268),(42785),(1986433),(2059361),(54118),(4063051),(11185192),(19054),(1985351),(2064168),(1995175),(2058868),(4608272) Parameters: [] View formatted query View runnable query Explain query create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine = memory; insert into `steiermark`.accoIdsTowns (id) values (1986795), (23435), (55167), (38423), (46316), (54339), (52545), (44050), (45797), (49790), (25942), (30756), (28876), (18813), (25423486), (2060888), (49276), (1986681), (20203610), (48365), (41793), (34013), (33519), (30773134), (25522), (14659516), (28470795), (43125), (50325), (1984508), (42911), (46206), (1988139), (15843263), (30101), (2060516), (17676), (4061338), (7351637), (35070), (20023418), (35206874), (53159), (1986865), (7738640), (1992394), (5367477), (27685), (44172), (46874), (45122), (31203), (44339), (1991966), (49387), (17823), (38060), (1993645), (1833139), (55324), (53239), (38807), (55395), (1986627), (42841), (36492), (9529160), (46636), (50850), (10664738), (19852), (52190), (32689), (45252), (29547), (41198698), (1994374), (46578), (48017), (39558266), (55242), (36935), (5949155), (30731557), (32298578), (51151), (2064618), (11364731), (1146742), (19158), (41649), (53593), (47487), (37175), (38904), (11436541), (43837572), (2064720), (7738339), (35666833), (48905589), (41366), (21368), (43641), (9283115), (1984959), (1990285), (36531210), (44587191), (54695), (11365272), (24448), (18290), (1985415), (39231), (47606), (39454), (44831), (46733), (41239), (10114007), (24242), (47921), (21859), (40768), (18165472), (16110362), (24781077), (43702020), (1995257), (21659), (59655), (39377), (18328480), (27868), (1988874), (31117139), (367300), (41879), (23077), (30980), (41615), (33905), (36531205), (48570), (2684053), (42753168), (25025), (46250), (45143324), (31340), (40646), (17418), (1988816), (34358), (1984760), (12910566), (2059839), (25273), (20707), (1985660), (1993946), (17904), (26570), (53347), (41160), (12910729), (38373), (53743), (27419533), (44781642), (42350), (38480), (33451), (2059991), (24793), (48496), (28091523), (1995103), (1985522), (26337), (4149206), (46152494), (32010), (1985174), (1994889), (2065944), (8537205), (32305843), (38616), (43184382), (39575), (42655), (1984904), (20840), (20291), (50189), (2063745), (28657), (27471), (34983), (1988207), (1433530), (54798), (28124), (37365), (17593634), (40473), (24971), (1989566), (34831), (2063458), (39083), (43526), (4061122), (26431), (44387), (1986716), (35330412), (23620), (43804), (31772), (20577), (1987706), (36664), (26721), (12879304), (1988937), (44660), (45582), (1988385), (36617), (43414), (46450), (1993711), (40556), (54523), (25766745), (1986946), (19857), (48890), (50086), (47398), (46968), (39687), (1994545), (45319), (37217), (35666828), (44781629), (1987463), (42428), (53948), (26851), (49502), (49548934), (1985474), (47247), (18746), (43758), (35666823), (22475), (20108), (1994732), (15498539), (4525614), (33768), (44222), (2064808), (23500), (52476), (1993242), (9455693), (1993811), (45375), (1993878), (17126), (2065496), (4061187), (28278), (30482936), (50194), (1990539), (18432), (39998), (32353), (6645142), (27631), (51034), (43155), (40425), (2061355), (37942), (45198113), (36327), (54166), (51833), (8142109), (2059260), (14913865), (19475), (35206879), (28867350), (22213550), (2062684), (15375608), (18462), (4761749), (1990954), (52801), (1993209), (2062410), (17811174), (18680), (28867356), (25763), (33100), (23991), (19115), (45054), (11367489), (35324), (31422), (21427), (18776204), (30565), (4061211), (43065), (31625), (47781), (9484915), (39297), (1992182), (1986015), (1991492), (1984997), (39007), (35382), (31843325), (31474), (1989306), (12279128), (1146711), (51357), (36160), (43433), (37746), (31543), (35655), (49497910), (42581), (34270), (9313566), (50011), (1987095), (28828), (23920), (25723022), (32750792), (47131), (42114), (1984665), (53474), (30764208), (1992261), (18042), (28587), (1989012), (1991623), (24375268), (42785), (1986433), (2059361), (54118), (4063051), (11185192), (19054), (1985351), (2064168), (1995175), (2058868), (4608272) create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (1986795),(23435),(55167),(38423),(46316),(54339),(52545),(44050),(45797),(49790),(25942),(30756),(28876),(18813),(25423486),(2060888),(49276),(1986681),(20203610),(48365),(41793),(34013),(33519),(30773134),(25522),(14659516),(28470795),(43125),(50325),(1984508),(42911),(46206),(1988139),(15843263),(30101),(2060516),(17676),(4061338),(7351637),(35070),(20023418),(35206874),(53159),(1986865),(7738640),(1992394),(5367477),(27685),(44172),(46874),(45122),(31203),(44339),(1991966),(49387),(17823),(38060),(1993645),(1833139),(55324),(53239),(38807),(55395),(1986627),(42841),(36492),(9529160),(46636),(50850),(10664738),(19852),(52190),(32689),(45252),(29547),(41198698),(1994374),(46578),(48017),(39558266),(55242),(36935),(5949155),(30731557),(32298578),(51151),(2064618),(11364731),(1146742),(19158),(41649),(53593),(47487),(37175),(38904),(11436541),(43837572),(2064720),(7738339),(35666833),(48905589),(41366),(21368),(43641),(9283115),(1984959),(1990285),(36531210),(44587191),(54695),(11365272),(24448),(18290),(1985415),(39231),(47606),(39454),(44831),(46733),(41239),(10114007),(24242),(47921),(21859),(40768),(18165472),(16110362),(24781077),(43702020),(1995257),(21659),(59655),(39377),(18328480),(27868),(1988874),(31117139),(367300),(41879),(23077),(30980),(41615),(33905),(36531205),(48570),(2684053),(42753168),(25025),(46250),(45143324),(31340),(40646),(17418),(1988816),(34358),(1984760),(12910566),(2059839),(25273),(20707),(1985660),(1993946),(17904),(26570),(53347),(41160),(12910729),(38373),(53743),(27419533),(44781642),(42350),(38480),(33451),(2059991),(24793),(48496),(28091523),(1995103),(1985522),(26337),(4149206),(46152494),(32010),(1985174),(1994889),(2065944),(8537205),(32305843),(38616),(43184382),(39575),(42655),(1984904),(20840),(20291),(50189),(2063745),(28657),(27471),(34983),(1988207),(1433530),(54798),(28124),(37365),(17593634),(40473),(24971),(1989566),(34831),(2063458),(39083),(43526),(4061122),(26431),(44387),(1986716),(35330412),(23620),(43804),(31772),(20577),(1987706),(36664),(26721),(12879304),(1988937),(44660),(45582),(1988385),(36617),(43414),(46450),(1993711),(40556),(54523),(25766745),(1986946),(19857),(48890),(50086),(47398),(46968),(39687),(1994545),(45319),(37217),(35666828),(44781629),(1987463),(42428),(53948),(26851),(49502),(49548934),(1985474),(47247),(18746),(43758),(35666823),(22475),(20108),(1994732),(15498539),(4525614),(33768),(44222),(2064808),(23500),(52476),(1993242),(9455693),(1993811),(45375),(1993878),(17126),(2065496),(4061187),(28278),(30482936),(50194),(1990539),(18432),(39998),(32353),(6645142),(27631),(51034),(43155),(40425),(2061355),(37942),(45198113),(36327),(54166),(51833),(8142109),(2059260),(14913865),(19475),(35206879),(28867350),(22213550),(2062684),(15375608),(18462),(4761749),(1990954),(52801),(1993209),(2062410),(17811174),(18680),(28867356),(25763),(33100),(23991),(19115),(45054),(11367489),(35324),(31422),(21427),(18776204),(30565),(4061211),(43065),(31625),(47781),(9484915),(39297),(1992182),(1986015),(1991492),(1984997),(39007),(35382),(31843325),(31474),(1989306),(12279128),(1146711),(51357),(36160),(43433),(37746),(31543),(35655),(49497910),(42581),(34270),(9313566),(50011),(1987095),(28828),(23920),(25723022),(32750792),(47131),(42114),(1984665),(53474),(30764208),(1992261),(18042),(28587),(1989012),(1991623),(24375268),(42785),(1986433),(2059361),(54118),(4063051),(11185192),(19054),(1985351),(2064168),(1995175),(2058868),(4608272);
5	2.61 ms	SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (6971, 12312, 12321, 6973, 12320, 12309, 6957, 6963, 6969, 6966, 6968, 12305, 6958, 6959, 6970, 6974, 12342, 6946, 6964, 6967, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6960, 12311, 6947) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id Parameters: [] View formatted query View runnable query Explain query SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN ( 6971, 12312, 12321, 6973, 12320, 12309, 6957, 6963, 6969, 6966, 6968, 12305, 6958, 6959, 6970, 6974, 12342, 6946, 6964, 6967, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6960, 12311, 6947 ) AND src_id IN ( select id from `steiermark`.accoIdsTowns ) group by dest_id SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (6971, 12312, 12321, 6973, 12320, 12309, 6957, 6963, 6969, 6966, 6968, 12305, 6958, 6959, 6970, 6974, 12342, 6946, 6964, 6967, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6960, 12311, 6947) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id ;
6	0.06 ms	DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns; Parameters: [] View formatted query View runnable query Explain query DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns; DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;;
7	8.18 ms	SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (31474,18290,1986509,26626,30101,29754,30724471,19158,46529,2064618,20291,54523,17030,40768,1989224,55324,35341,4063160,35206874,52190,11365272,28278,2065098,18776204,40473,1993878,27740,46968,24971,47247,21622,1987680,21489,1989189,41879,46933,1994480,46284,19054,1986681,52801,39007,54118,2059447,48496,41546,25763,46874,2066111,52545,2058512,4525614,50189,53293,4061122,28587,25667,26506,2064168,32550,2061355,47606,47710,1986219,39297,2062596,2058626,20643,35324,51357,46733,36492,53474,4761749,8142109,44782,36299,22003,54660,2058868,1990242,40425,42551,2065425,32147,31543,27807120,36935,33905,32305843,30764208,1985114,19725,12910729,1993946,50011,1994761,35666823,1988269,4061187,26851,20810,35666833,33519,9455693,16110362,1990091,55395,46636,53159,52068,34270,30756,30731557,2065944,2062885,2063926,2059767,51034,1433530,47131,28470795,25522,35330412,22953,37827,1993209,27298,6645142,28657,37942,52516,17418,10114007,28980,46316,1990469,30482936,1987585,21363,1984760,20577,43155,35382,27294,27685,43125,2684053,46578,1986476,46206,41793,50194,8537205,47196,42237,53418,28876,44831,35989,38373,1993645,1985962,2060384,2059260,17227,51974,1988347,24793,4063051,29585,2063196,27471,43837572,47981,1991966,1343842,15843263,45923,1991623,51301,1986627,2059361,38549,11367489,43472,35994,36664,7738640,42911,44050,24523,11436541,17904,1987339,2060738,1984997,37308,1833139,2060516,33100,43065,43526,55242,1993438,38423,1987095,18680,2065496,16854,1987221,31422,9313566,7738339,1990911,27520,1990954,49910,1993811,46250,1987463,7351637,55010,1989566,24448,1989012,37859,2064954,18560,27631,1989882,1992224,18152,24118,39687,59655,39377,1987293,1985246,1987973,1994800,40704,43433,10664738,20023418,30773134,50963,45797,31843325,47781,18042,30400,1995175,48017,39922,1986758,19754,5367353,11364731,2062975,2060465,30565,24985,9283115,2066133,18272,20782,24580,1989465,21585,42977,27868,36160,1995103,43384,1994732,5367477,18891,26570,43686,1988874,20840,54339,23991,4608272,41198698,32689,54763,2058557,49158,21821,2059571,35206879,30980,53913,38807,2059088,35070,18943,1989419,17770,34983,1988207,18328480,19286,29109,24242,2063091,2062684,38904,2059839,41366,1990504,45122,43641,2063458,25101,28091523,21427,35238,18746,41494,17593634,50760,44587191,1988816,32750792,48570,19208,43804,21284,49387,1985474,31336,36100,36531210,37217,4061338,42350,43184382,42753168,55108,43414,22775,1991492,25366,31203,17823,27825,1985174,45582,35740,53010,4580754,20108,54695,1989075,1994502,1994374,19587,5949155,48928,1987706,1991534,1986795,21942,1993242,32582,34887538,50850,32076506,367300,19812,1989698,12879307,39454,23720,1985415,18813,33077,44387,1994096,21859,2060888,1986015,3263472,54166,36227,19244,28867353,52727,49497910,29836686,42655,18432,45082,27419533,1990037,19029556,21239,17676,32478,23077,19475,48365,38616,32802,14913865,1992394,49189,367148,1992182,32658,23055,15498539,25942,34358,23920,1986946,4063277,54798,45252,39558266,25414206,47398,1995257,1989832,1987149,52476,1989306,50718,17811174,49502,41239,31625,17541,28124,36531205,25766745,1987270,50086,46152494,27384,26890,23435,1988731,2062410,35456,1994545,31117139,3263475,12879304,42841,43594,25156,29619,19558,4061087,1994693,44222,31772,53347,27082,4061211,1986433,42785,18230,1988766,17626,39231,1991413,1985660,21543,35666828,51833,25423486,36066,18375,34180,1993711,37484,1989517,50135,34716,11185192,34831,44339,24173653,36095,36327,47487,1986865,19852,1988937,41710,54374,28508,1989124,1994822,2853535,31755375,45319,16889,23500,21327,9484915,44781642,1988139,51151,19612,45143324,52662,28828,25806,23620,1984665,49229,47921,35566,43758,1990830,1988015,44660,22916,52769,29907,28923,37175,48905589,47830,24781077,1984904,1984959,45503,39083,17354,42581,48890,41615,1992841,45375,1146742,40556,24375268,35697,1985351,15375608,39198,16922,20203610,25766748,33331,29764,34013,35655,39575,16975,12910566,41649,19115,53817,21368,18520,17126,26721,53593,2064513,38480,22047,1986716,1987442,55167,20885,1986581,54243,1990539,18015,1985522,7951197,2063414,39998,20668,1989922,1990285,48716,49790,4149206,25724,45054,21179,27568,37746,33768,2066268,1989734,31967,53743,1984508,33401,1987314,31291,22441,42114,1988385,9529160,20989,33031,53783,38583,53948,26337,1993788,21032,53239,22475,44172,1990181,25273,21659,2064808,37365,1146711,46450,50325,12279128,1994889,20188,2063745,18462,32298578,41160,1989268,42428,6945367,52980,14659516,2059991,25025,30852,1992261,29547,41842,33898,19857,32806,33451,40646,1990403,32010,49548934,53131,49276,29671,2064720,36617,1986914,38060,17068,31340,35829,54464,30448600,43702020,25723022,29829,18165472,48905586,4791432,20707,50584316,30843,41198724,49046532,28492,17115,14049003,30354,42753173,30359,48663392,367391,34969921,29903,367184,44781629,22213550,45756971,48675,45548175,4061075,31259,28867356,48625745,50593655,26431,2193918,48050342,29658071,46201539,48625751,47257351,32751,41935,48863,31960,17120,16421480,29614,27820,31953,36655,13440568,47463,17670,36716325,30751,48663426,35736,45756981,46597852,48663405,49548929,33992180,26717,47888734,32353,17001,367295,367388,29658091,29104,41198692,33178,12948653,47614112,1993620,29658076,36427,48625748,45756976,45198113,2853499,28920,22612,12879310,32108,28867350,27056,26578533,50692778,29658086,25500,46992771,4061295) AND dacco.o_published = 1 AND (dacco.town__id IN (6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947)) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) Parameters: [] View formatted query View runnable query Explain query SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN ( 31474, 18290, 1986509, 26626, 30101, 29754, 30724471, 19158, 46529, 2064618, 20291, 54523, 17030, 40768, 1989224, 55324, 35341, 4063160, 35206874, 52190, 11365272, 28278, 2065098, 18776204, 40473, 1993878, 27740, 46968, 24971, 47247, 21622, 1987680, 21489, 1989189, 41879, 46933, 1994480, 46284, 19054, 1986681, 52801, 39007, 54118, 2059447, 48496, 41546, 25763, 46874, 2066111, 52545, 2058512, 4525614, 50189, 53293, 4061122, 28587, 25667, 26506, 2064168, 32550, 2061355, 47606, 47710, 1986219, 39297, 2062596, 2058626, 20643, 35324, 51357, 46733, 36492, 53474, 4761749, 8142109, 44782, 36299, 22003, 54660, 2058868, 1990242, 40425, 42551, 2065425, 32147, 31543, 27807120, 36935, 33905, 32305843, 30764208, 1985114, 19725, 12910729, 1993946, 50011, 1994761, 35666823, 1988269, 4061187, 26851, 20810, 35666833, 33519, 9455693, 16110362, 1990091, 55395, 46636, 53159, 52068, 34270, 30756, 30731557, 2065944, 2062885, 2063926, 2059767, 51034, 1433530, 47131, 28470795, 25522, 35330412, 22953, 37827, 1993209, 27298, 6645142, 28657, 37942, 52516, 17418, 10114007, 28980, 46316, 1990469, 30482936, 1987585, 21363, 1984760, 20577, 43155, 35382, 27294, 27685, 43125, 2684053, 46578, 1986476, 46206, 41793, 50194, 8537205, 47196, 42237, 53418, 28876, 44831, 35989, 38373, 1993645, 1985962, 2060384, 2059260, 17227, 51974, 1988347, 24793, 4063051, 29585, 2063196, 27471, 43837572, 47981, 1991966, 1343842, 15843263, 45923, 1991623, 51301, 1986627, 2059361, 38549, 11367489, 43472, 35994, 36664, 7738640, 42911, 44050, 24523, 11436541, 17904, 1987339, 2060738, 1984997, 37308, 1833139, 2060516, 33100, 43065, 43526, 55242, 1993438, 38423, 1987095, 18680, 2065496, 16854, 1987221, 31422, 9313566, 7738339, 1990911, 27520, 1990954, 49910, 1993811, 46250, 1987463, 7351637, 55010, 1989566, 24448, 1989012, 37859, 2064954, 18560, 27631, 1989882, 1992224, 18152, 24118, 39687, 59655, 39377, 1987293, 1985246, 1987973, 1994800, 40704, 43433, 10664738, 20023418, 30773134, 50963, 45797, 31843325, 47781, 18042, 30400, 1995175, 48017, 39922, 1986758, 19754, 5367353, 11364731, 2062975, 2060465, 30565, 24985, 9283115, 2066133, 18272, 20782, 24580, 1989465, 21585, 42977, 27868, 36160, 1995103, 43384, 1994732, 5367477, 18891, 26570, 43686, 1988874, 20840, 54339, 23991, 4608272, 41198698, 32689, 54763, 2058557, 49158, 21821, 2059571, 35206879, 30980, 53913, 38807, 2059088, 35070, 18943, 1989419, 17770, 34983, 1988207, 18328480, 19286, 29109, 24242, 2063091, 2062684, 38904, 2059839, 41366, 1990504, 45122, 43641, 2063458, 25101, 28091523, 21427, 35238, 18746, 41494, 17593634, 50760, 44587191, 1988816, 32750792, 48570, 19208, 43804, 21284, 49387, 1985474, 31336, 36100, 36531210, 37217, 4061338, 42350, 43184382, 42753168, 55108, 43414, 22775, 1991492, 25366, 31203, 17823, 27825, 1985174, 45582, 35740, 53010, 4580754, 20108, 54695, 1989075, 1994502, 1994374, 19587, 5949155, 48928, 1987706, 1991534, 1986795, 21942, 1993242, 32582, 34887538, 50850, 32076506, 367300, 19812, 1989698, 12879307, 39454, 23720, 1985415, 18813, 33077, 44387, 1994096, 21859, 2060888, 1986015, 3263472, 54166, 36227, 19244, 28867353, 52727, 49497910, 29836686, 42655, 18432, 45082, 27419533, 1990037, 19029556, 21239, 17676, 32478, 23077, 19475, 48365, 38616, 32802, 14913865, 1992394, 49189, 367148, 1992182, 32658, 23055, 15498539, 25942, 34358, 23920, 1986946, 4063277, 54798, 45252, 39558266, 25414206, 47398, 1995257, 1989832, 1987149, 52476, 1989306, 50718, 17811174, 49502, 41239, 31625, 17541, 28124, 36531205, 25766745, 1987270, 50086, 46152494, 27384, 26890, 23435, 1988731, 2062410, 35456, 1994545, 31117139, 3263475, 12879304, 42841, 43594, 25156, 29619, 19558, 4061087, 1994693, 44222, 31772, 53347, 27082, 4061211, 1986433, 42785, 18230, 1988766, 17626, 39231, 1991413, 1985660, 21543, 35666828, 51833, 25423486, 36066, 18375, 34180, 1993711, 37484, 1989517, 50135, 34716, 11185192, 34831, 44339, 24173653, 36095, 36327, 47487, 1986865, 19852, 1988937, 41710, 54374, 28508, 1989124, 1994822, 2853535, 31755375, 45319, 16889, 23500, 21327, 9484915, 44781642, 1988139, 51151, 19612, 45143324, 52662, 28828, 25806, 23620, 1984665, 49229, 47921, 35566, 43758, 1990830, 1988015, 44660, 22916, 52769, 29907, 28923, 37175, 48905589, 47830, 24781077, 1984904, 1984959, 45503, 39083, 17354, 42581, 48890, 41615, 1992841, 45375, 1146742, 40556, 24375268, 35697, 1985351, 15375608, 39198, 16922, 20203610, 25766748, 33331, 29764, 34013, 35655, 39575, 16975, 12910566, 41649, 19115, 53817, 21368, 18520, 17126, 26721, 53593, 2064513, 38480, 22047, 1986716, 1987442, 55167, 20885, 1986581, 54243, 1990539, 18015, 1985522, 7951197, 2063414, 39998, 20668, 1989922, 1990285, 48716, 49790, 4149206, 25724, 45054, 21179, 27568, 37746, 33768, 2066268, 1989734, 31967, 53743, 1984508, 33401, 1987314, 31291, 22441, 42114, 1988385, 9529160, 20989, 33031, 53783, 38583, 53948, 26337, 1993788, 21032, 53239, 22475, 44172, 1990181, 25273, 21659, 2064808, 37365, 1146711, 46450, 50325, 12279128, 1994889, 20188, 2063745, 18462, 32298578, 41160, 1989268, 42428, 6945367, 52980, 14659516, 2059991, 25025, 30852, 1992261, 29547, 41842, 33898, 19857, 32806, 33451, 40646, 1990403, 32010, 49548934, 53131, 49276, 29671, 2064720, 36617, 1986914, 38060, 17068, 31340, 35829, 54464, 30448600, 43702020, 25723022, 29829, 18165472, 48905586, 4791432, 20707, 50584316, 30843, 41198724, 49046532, 28492, 17115, 14049003, 30354, 42753173, 30359, 48663392, 367391, 34969921, 29903, 367184, 44781629, 22213550, 45756971, 48675, 45548175, 4061075, 31259, 28867356, 48625745, 50593655, 26431, 2193918, 48050342, 29658071, 46201539, 48625751, 47257351, 32751, 41935, 48863, 31960, 17120, 16421480, 29614, 27820, 31953, 36655, 13440568, 47463, 17670, 36716325, 30751, 48663426, 35736, 45756981, 46597852, 48663405, 49548929, 33992180, 26717, 47888734, 32353, 17001, 367295, 367388, 29658091, 29104, 41198692, 33178, 12948653, 47614112, 1993620, 29658076, 36427, 48625748, 45756976, 45198113, 2853499, 28920, 22612, 12879310, 32108, 28867350, 27056, 26578533, 50692778, 29658086, 25500, 46992771, 4061295 ) AND dacco.o_published = 1 AND ( dacco.town__id IN ( 6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947 ) ) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (31474,18290,1986509,26626,30101,29754,30724471,19158,46529,2064618,20291,54523,17030,40768,1989224,55324,35341,4063160,35206874,52190,11365272,28278,2065098,18776204,40473,1993878,27740,46968,24971,47247,21622,1987680,21489,1989189,41879,46933,1994480,46284,19054,1986681,52801,39007,54118,2059447,48496,41546,25763,46874,2066111,52545,2058512,4525614,50189,53293,4061122,28587,25667,26506,2064168,32550,2061355,47606,47710,1986219,39297,2062596,2058626,20643,35324,51357,46733,36492,53474,4761749,8142109,44782,36299,22003,54660,2058868,1990242,40425,42551,2065425,32147,31543,27807120,36935,33905,32305843,30764208,1985114,19725,12910729,1993946,50011,1994761,35666823,1988269,4061187,26851,20810,35666833,33519,9455693,16110362,1990091,55395,46636,53159,52068,34270,30756,30731557,2065944,2062885,2063926,2059767,51034,1433530,47131,28470795,25522,35330412,22953,37827,1993209,27298,6645142,28657,37942,52516,17418,10114007,28980,46316,1990469,30482936,1987585,21363,1984760,20577,43155,35382,27294,27685,43125,2684053,46578,1986476,46206,41793,50194,8537205,47196,42237,53418,28876,44831,35989,38373,1993645,1985962,2060384,2059260,17227,51974,1988347,24793,4063051,29585,2063196,27471,43837572,47981,1991966,1343842,15843263,45923,1991623,51301,1986627,2059361,38549,11367489,43472,35994,36664,7738640,42911,44050,24523,11436541,17904,1987339,2060738,1984997,37308,1833139,2060516,33100,43065,43526,55242,1993438,38423,1987095,18680,2065496,16854,1987221,31422,9313566,7738339,1990911,27520,1990954,49910,1993811,46250,1987463,7351637,55010,1989566,24448,1989012,37859,2064954,18560,27631,1989882,1992224,18152,24118,39687,59655,39377,1987293,1985246,1987973,1994800,40704,43433,10664738,20023418,30773134,50963,45797,31843325,47781,18042,30400,1995175,48017,39922,1986758,19754,5367353,11364731,2062975,2060465,30565,24985,9283115,2066133,18272,20782,24580,1989465,21585,42977,27868,36160,1995103,43384,1994732,5367477,18891,26570,43686,1988874,20840,54339,23991,4608272,41198698,32689,54763,2058557,49158,21821,2059571,35206879,30980,53913,38807,2059088,35070,18943,1989419,17770,34983,1988207,18328480,19286,29109,24242,2063091,2062684,38904,2059839,41366,1990504,45122,43641,2063458,25101,28091523,21427,35238,18746,41494,17593634,50760,44587191,1988816,32750792,48570,19208,43804,21284,49387,1985474,31336,36100,36531210,37217,4061338,42350,43184382,42753168,55108,43414,22775,1991492,25366,31203,17823,27825,1985174,45582,35740,53010,4580754,20108,54695,1989075,1994502,1994374,19587,5949155,48928,1987706,1991534,1986795,21942,1993242,32582,34887538,50850,32076506,367300,19812,1989698,12879307,39454,23720,1985415,18813,33077,44387,1994096,21859,2060888,1986015,3263472,54166,36227,19244,28867353,52727,49497910,29836686,42655,18432,45082,27419533,1990037,19029556,21239,17676,32478,23077,19475,48365,38616,32802,14913865,1992394,49189,367148,1992182,32658,23055,15498539,25942,34358,23920,1986946,4063277,54798,45252,39558266,25414206,47398,1995257,1989832,1987149,52476,1989306,50718,17811174,49502,41239,31625,17541,28124,36531205,25766745,1987270,50086,46152494,27384,26890,23435,1988731,2062410,35456,1994545,31117139,3263475,12879304,42841,43594,25156,29619,19558,4061087,1994693,44222,31772,53347,27082,4061211,1986433,42785,18230,1988766,17626,39231,1991413,1985660,21543,35666828,51833,25423486,36066,18375,34180,1993711,37484,1989517,50135,34716,11185192,34831,44339,24173653,36095,36327,47487,1986865,19852,1988937,41710,54374,28508,1989124,1994822,2853535,31755375,45319,16889,23500,21327,9484915,44781642,1988139,51151,19612,45143324,52662,28828,25806,23620,1984665,49229,47921,35566,43758,1990830,1988015,44660,22916,52769,29907,28923,37175,48905589,47830,24781077,1984904,1984959,45503,39083,17354,42581,48890,41615,1992841,45375,1146742,40556,24375268,35697,1985351,15375608,39198,16922,20203610,25766748,33331,29764,34013,35655,39575,16975,12910566,41649,19115,53817,21368,18520,17126,26721,53593,2064513,38480,22047,1986716,1987442,55167,20885,1986581,54243,1990539,18015,1985522,7951197,2063414,39998,20668,1989922,1990285,48716,49790,4149206,25724,45054,21179,27568,37746,33768,2066268,1989734,31967,53743,1984508,33401,1987314,31291,22441,42114,1988385,9529160,20989,33031,53783,38583,53948,26337,1993788,21032,53239,22475,44172,1990181,25273,21659,2064808,37365,1146711,46450,50325,12279128,1994889,20188,2063745,18462,32298578,41160,1989268,42428,6945367,52980,14659516,2059991,25025,30852,1992261,29547,41842,33898,19857,32806,33451,40646,1990403,32010,49548934,53131,49276,29671,2064720,36617,1986914,38060,17068,31340,35829,54464,30448600,43702020,25723022,29829,18165472,48905586,4791432,20707,50584316,30843,41198724,49046532,28492,17115,14049003,30354,42753173,30359,48663392,367391,34969921,29903,367184,44781629,22213550,45756971,48675,45548175,4061075,31259,28867356,48625745,50593655,26431,2193918,48050342,29658071,46201539,48625751,47257351,32751,41935,48863,31960,17120,16421480,29614,27820,31953,36655,13440568,47463,17670,36716325,30751,48663426,35736,45756981,46597852,48663405,49548929,33992180,26717,47888734,32353,17001,367295,367388,29658091,29104,41198692,33178,12948653,47614112,1993620,29658076,36427,48625748,45756976,45198113,2853499,28920,22612,12879310,32108,28867350,27056,26578533,50692778,29658086,25500,46992771,4061295) AND dacco.o_published = 1 AND (dacco.town__id IN (6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947)) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) ;
8	0.11 ms	create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (1986795),(23435),(55167),(38423),(46316),(54339),(52545),(44050),(45797),(49790),(25942),(30756),(28876),(18813),(25423486),(2060888),(49276),(1986681),(20203610),(48365),(41793),(34013),(33519),(30773134),(25522),(14659516),(28470795),(43125),(50325),(1984508),(42911),(46206),(1988139),(15843263),(30101),(2060516),(17676),(4061338),(7351637),(35070),(20023418),(35206874),(53159),(1986865),(7738640),(1992394),(5367477),(27685),(44172),(46874),(45122),(31203),(44339),(1991966),(49387),(17823),(38060),(1993645),(1833139),(55324),(53239),(38807),(55395),(1986627),(42841),(36492),(9529160),(46636),(50850),(10664738),(19852),(52190),(32689),(45252),(29547),(41198698),(1994374),(46578),(48017),(39558266),(55242),(36935),(5949155),(30731557),(32298578),(51151),(2064618),(11364731),(1146742),(19158),(41649),(53593),(47487),(37175),(38904),(11436541),(43837572),(2064720),(7738339),(35666833),(48905589),(41366),(21368),(43641),(9283115),(1984959),(1990285),(36531210),(44587191),(54695),(11365272),(24448),(18290),(1985415),(39231),(47606),(39454),(44831),(46733),(41239),(10114007),(24242),(47921),(21859),(40768),(18165472),(16110362),(24781077),(43702020),(1995257),(21659),(59655),(39377),(18328480),(27868),(1988874),(31117139),(367300),(41879),(23077),(30980),(41615),(33905),(36531205),(48570),(2684053),(42753168),(25025),(46250),(45143324),(31340),(40646),(17418),(1988816),(34358),(1984760),(12910566),(2059839),(25273),(20707),(1985660),(1993946),(17904),(26570),(53347),(41160),(12910729),(38373),(53743),(27419533),(44781642),(42350),(38480),(33451),(2059991),(24793),(48496),(28091523),(1995103),(1985522),(26337),(4149206),(46152494),(32010),(1985174),(1994889),(2065944),(8537205),(32305843),(38616),(43184382),(39575),(42655),(1984904),(20840),(20291),(50189),(2063745),(28657),(27471),(34983),(1988207),(1433530),(54798),(28124),(37365),(17593634),(40473),(24971),(1989566),(34831),(2063458),(39083),(43526),(4061122),(26431),(44387),(1986716),(35330412),(23620),(43804),(31772),(20577),(1987706),(36664),(26721),(12879304),(1988937),(44660),(45582),(1988385),(36617),(43414),(46450),(1993711),(40556),(54523),(25766745),(1986946),(19857),(48890),(50086),(47398),(46968),(39687),(1994545),(45319),(37217),(35666828),(44781629),(1987463),(42428),(53948),(26851),(49502),(49548934),(1985474),(47247),(18746),(43758),(35666823),(22475),(20108),(1994732),(15498539),(4525614),(33768),(44222),(2064808),(23500),(52476),(1993242),(9455693),(1993811),(45375),(1993878),(17126),(2065496),(4061187),(28278),(30482936),(50194),(1990539),(18432),(39998),(32353),(6645142),(27631),(51034),(43155),(40425),(2061355),(37942),(45198113),(36327),(54166),(51833),(8142109),(2059260),(14913865),(19475),(35206879),(28867350),(22213550),(2062684),(15375608),(18462),(4761749),(1990954),(52801),(1993209),(2062410),(17811174),(18680),(28867356),(25763),(33100),(23991),(19115),(45054),(11367489),(35324),(31422),(21427),(18776204),(30565),(4061211),(43065),(31625),(47781),(9484915),(39297),(1992182),(1986015),(1991492),(1984997),(39007),(35382),(31843325),(31474),(1989306),(12279128),(1146711),(51357),(36160),(43433),(37746),(31543),(35655),(49497910),(42581),(34270),(9313566),(50011),(1987095),(28828),(23920),(25723022),(32750792),(47131),(42114),(1984665),(53474),(30764208),(1992261),(18042),(28587),(1989012),(1991623),(24375268),(42785),(1986433),(2059361),(54118),(4063051),(11185192),(19054),(1985351),(2064168),(1995175),(2058868),(4608272) Parameters: [] View formatted query View runnable query Explain query create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine = memory; insert into `steiermark`.accoIdsTowns (id) values (1986795), (23435), (55167), (38423), (46316), (54339), (52545), (44050), (45797), (49790), (25942), (30756), (28876), (18813), (25423486), (2060888), (49276), (1986681), (20203610), (48365), (41793), (34013), (33519), (30773134), (25522), (14659516), (28470795), (43125), (50325), (1984508), (42911), (46206), (1988139), (15843263), (30101), (2060516), (17676), (4061338), (7351637), (35070), (20023418), (35206874), (53159), (1986865), (7738640), (1992394), (5367477), (27685), (44172), (46874), (45122), (31203), (44339), (1991966), (49387), (17823), (38060), (1993645), (1833139), (55324), (53239), (38807), (55395), (1986627), (42841), (36492), (9529160), (46636), (50850), (10664738), (19852), (52190), (32689), (45252), (29547), (41198698), (1994374), (46578), (48017), (39558266), (55242), (36935), (5949155), (30731557), (32298578), (51151), (2064618), (11364731), (1146742), (19158), (41649), (53593), (47487), (37175), (38904), (11436541), (43837572), (2064720), (7738339), (35666833), (48905589), (41366), (21368), (43641), (9283115), (1984959), (1990285), (36531210), (44587191), (54695), (11365272), (24448), (18290), (1985415), (39231), (47606), (39454), (44831), (46733), (41239), (10114007), (24242), (47921), (21859), (40768), (18165472), (16110362), (24781077), (43702020), (1995257), (21659), (59655), (39377), (18328480), (27868), (1988874), (31117139), (367300), (41879), (23077), (30980), (41615), (33905), (36531205), (48570), (2684053), (42753168), (25025), (46250), (45143324), (31340), (40646), (17418), (1988816), (34358), (1984760), (12910566), (2059839), (25273), (20707), (1985660), (1993946), (17904), (26570), (53347), (41160), (12910729), (38373), (53743), (27419533), (44781642), (42350), (38480), (33451), (2059991), (24793), (48496), (28091523), (1995103), (1985522), (26337), (4149206), (46152494), (32010), (1985174), (1994889), (2065944), (8537205), (32305843), (38616), (43184382), (39575), (42655), (1984904), (20840), (20291), (50189), (2063745), (28657), (27471), (34983), (1988207), (1433530), (54798), (28124), (37365), (17593634), (40473), (24971), (1989566), (34831), (2063458), (39083), (43526), (4061122), (26431), (44387), (1986716), (35330412), (23620), (43804), (31772), (20577), (1987706), (36664), (26721), (12879304), (1988937), (44660), (45582), (1988385), (36617), (43414), (46450), (1993711), (40556), (54523), (25766745), (1986946), (19857), (48890), (50086), (47398), (46968), (39687), (1994545), (45319), (37217), (35666828), (44781629), (1987463), (42428), (53948), (26851), (49502), (49548934), (1985474), (47247), (18746), (43758), (35666823), (22475), (20108), (1994732), (15498539), (4525614), (33768), (44222), (2064808), (23500), (52476), (1993242), (9455693), (1993811), (45375), (1993878), (17126), (2065496), (4061187), (28278), (30482936), (50194), (1990539), (18432), (39998), (32353), (6645142), (27631), (51034), (43155), (40425), (2061355), (37942), (45198113), (36327), (54166), (51833), (8142109), (2059260), (14913865), (19475), (35206879), (28867350), (22213550), (2062684), (15375608), (18462), (4761749), (1990954), (52801), (1993209), (2062410), (17811174), (18680), (28867356), (25763), (33100), (23991), (19115), (45054), (11367489), (35324), (31422), (21427), (18776204), (30565), (4061211), (43065), (31625), (47781), (9484915), (39297), (1992182), (1986015), (1991492), (1984997), (39007), (35382), (31843325), (31474), (1989306), (12279128), (1146711), (51357), (36160), (43433), (37746), (31543), (35655), (49497910), (42581), (34270), (9313566), (50011), (1987095), (28828), (23920), (25723022), (32750792), (47131), (42114), (1984665), (53474), (30764208), (1992261), (18042), (28587), (1989012), (1991623), (24375268), (42785), (1986433), (2059361), (54118), (4063051), (11185192), (19054), (1985351), (2064168), (1995175), (2058868), (4608272) create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (1986795),(23435),(55167),(38423),(46316),(54339),(52545),(44050),(45797),(49790),(25942),(30756),(28876),(18813),(25423486),(2060888),(49276),(1986681),(20203610),(48365),(41793),(34013),(33519),(30773134),(25522),(14659516),(28470795),(43125),(50325),(1984508),(42911),(46206),(1988139),(15843263),(30101),(2060516),(17676),(4061338),(7351637),(35070),(20023418),(35206874),(53159),(1986865),(7738640),(1992394),(5367477),(27685),(44172),(46874),(45122),(31203),(44339),(1991966),(49387),(17823),(38060),(1993645),(1833139),(55324),(53239),(38807),(55395),(1986627),(42841),(36492),(9529160),(46636),(50850),(10664738),(19852),(52190),(32689),(45252),(29547),(41198698),(1994374),(46578),(48017),(39558266),(55242),(36935),(5949155),(30731557),(32298578),(51151),(2064618),(11364731),(1146742),(19158),(41649),(53593),(47487),(37175),(38904),(11436541),(43837572),(2064720),(7738339),(35666833),(48905589),(41366),(21368),(43641),(9283115),(1984959),(1990285),(36531210),(44587191),(54695),(11365272),(24448),(18290),(1985415),(39231),(47606),(39454),(44831),(46733),(41239),(10114007),(24242),(47921),(21859),(40768),(18165472),(16110362),(24781077),(43702020),(1995257),(21659),(59655),(39377),(18328480),(27868),(1988874),(31117139),(367300),(41879),(23077),(30980),(41615),(33905),(36531205),(48570),(2684053),(42753168),(25025),(46250),(45143324),(31340),(40646),(17418),(1988816),(34358),(1984760),(12910566),(2059839),(25273),(20707),(1985660),(1993946),(17904),(26570),(53347),(41160),(12910729),(38373),(53743),(27419533),(44781642),(42350),(38480),(33451),(2059991),(24793),(48496),(28091523),(1995103),(1985522),(26337),(4149206),(46152494),(32010),(1985174),(1994889),(2065944),(8537205),(32305843),(38616),(43184382),(39575),(42655),(1984904),(20840),(20291),(50189),(2063745),(28657),(27471),(34983),(1988207),(1433530),(54798),(28124),(37365),(17593634),(40473),(24971),(1989566),(34831),(2063458),(39083),(43526),(4061122),(26431),(44387),(1986716),(35330412),(23620),(43804),(31772),(20577),(1987706),(36664),(26721),(12879304),(1988937),(44660),(45582),(1988385),(36617),(43414),(46450),(1993711),(40556),(54523),(25766745),(1986946),(19857),(48890),(50086),(47398),(46968),(39687),(1994545),(45319),(37217),(35666828),(44781629),(1987463),(42428),(53948),(26851),(49502),(49548934),(1985474),(47247),(18746),(43758),(35666823),(22475),(20108),(1994732),(15498539),(4525614),(33768),(44222),(2064808),(23500),(52476),(1993242),(9455693),(1993811),(45375),(1993878),(17126),(2065496),(4061187),(28278),(30482936),(50194),(1990539),(18432),(39998),(32353),(6645142),(27631),(51034),(43155),(40425),(2061355),(37942),(45198113),(36327),(54166),(51833),(8142109),(2059260),(14913865),(19475),(35206879),(28867350),(22213550),(2062684),(15375608),(18462),(4761749),(1990954),(52801),(1993209),(2062410),(17811174),(18680),(28867356),(25763),(33100),(23991),(19115),(45054),(11367489),(35324),(31422),(21427),(18776204),(30565),(4061211),(43065),(31625),(47781),(9484915),(39297),(1992182),(1986015),(1991492),(1984997),(39007),(35382),(31843325),(31474),(1989306),(12279128),(1146711),(51357),(36160),(43433),(37746),(31543),(35655),(49497910),(42581),(34270),(9313566),(50011),(1987095),(28828),(23920),(25723022),(32750792),(47131),(42114),(1984665),(53474),(30764208),(1992261),(18042),(28587),(1989012),(1991623),(24375268),(42785),(1986433),(2059361),(54118),(4063051),(11185192),(19054),(1985351),(2064168),(1995175),(2058868),(4608272);
9	3.39 ms	SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (9947, 9944, 9948, 9943) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id Parameters: [] View formatted query View runnable query Explain query SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (9947, 9944, 9948, 9943) AND src_id IN ( select id from `steiermark`.accoIdsTowns ) group by dest_id SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (9947, 9944, 9948, 9943) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id ;
10	0.06 ms	DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns; Parameters: [] View formatted query View runnable query Explain query DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns; DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;;
11	8.07 ms	SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (31474,18290,1986509,26626,30101,29754,30724471,19158,46529,2064618,20291,54523,17030,40768,1989224,55324,35341,4063160,35206874,52190,11365272,28278,2065098,18776204,40473,1993878,27740,46968,24971,47247,21622,1987680,21489,1989189,41879,46933,1994480,46284,19054,1986681,52801,39007,54118,2059447,48496,41546,25763,46874,2066111,52545,2058512,4525614,50189,53293,4061122,28587,25667,26506,2064168,32550,2061355,47606,47710,1986219,39297,2062596,2058626,20643,35324,51357,46733,36492,53474,4761749,8142109,44782,36299,22003,54660,2058868,1990242,40425,42551,2065425,32147,31543,27807120,36935,33905,32305843,30764208,1985114,19725,12910729,1993946,50011,1994761,35666823,1988269,4061187,26851,20810,35666833,33519,9455693,16110362,1990091,55395,46636,53159,52068,34270,30756,30731557,2065944,2062885,2063926,2059767,51034,1433530,47131,28470795,25522,35330412,22953,37827,1993209,27298,6645142,28657,37942,52516,17418,10114007,28980,46316,1990469,30482936,1987585,21363,1984760,20577,43155,35382,27294,27685,43125,2684053,46578,1986476,46206,41793,50194,8537205,47196,42237,53418,28876,44831,35989,38373,1993645,1985962,2060384,2059260,17227,51974,1988347,24793,4063051,29585,2063196,27471,43837572,47981,1991966,1343842,15843263,45923,1991623,51301,1986627,2059361,38549,11367489,43472,35994,36664,7738640,42911,44050,24523,11436541,17904,1987339,2060738,1984997,37308,1833139,2060516,33100,43065,43526,55242,1993438,38423,1987095,18680,2065496,16854,1987221,31422,9313566,7738339,1990911,27520,1990954,49910,1993811,46250,1987463,7351637,55010,1989566,24448,1989012,37859,2064954,18560,27631,1989882,1992224,18152,24118,39687,59655,39377,1987293,1985246,1987973,1994800,40704,43433,10664738,20023418,30773134,50963,45797,31843325,47781,18042,30400,1995175,48017,39922,1986758,19754,5367353,11364731,2062975,2060465,30565,24985,9283115,2066133,18272,20782,24580,1989465,21585,42977,27868,36160,1995103,43384,1994732,5367477,18891,26570,43686,1988874,20840,54339,23991,4608272,41198698,32689,54763,2058557,49158,21821,2059571,35206879,30980,53913,38807,2059088,35070,18943,1989419,17770,34983,1988207,18328480,19286,29109,24242,2063091,2062684,38904,2059839,41366,1990504,45122,43641,2063458,25101,28091523,21427,35238,18746,41494,17593634,50760,44587191,1988816,32750792,48570,19208,43804,21284,49387,1985474,31336,36100,36531210,37217,4061338,42350,43184382,42753168,55108,43414,22775,1991492,25366,31203,17823,27825,1985174,45582,35740,53010,4580754,20108,54695,1989075,1994502,1994374,19587,5949155,48928,1987706,1991534,1986795,21942,1993242,32582,34887538,50850,32076506,367300,19812,1989698,12879307,39454,23720,1985415,18813,33077,44387,1994096,21859,2060888,1986015,3263472,54166,36227,19244,28867353,52727,49497910,29836686,42655,18432,45082,27419533,1990037,19029556,21239,17676,32478,23077,19475,48365,38616,32802,14913865,1992394,49189,367148,1992182,32658,23055,15498539,25942,34358,23920,1986946,4063277,54798,45252,39558266,25414206,47398,1995257,1989832,1987149,52476,1989306,50718,17811174,49502,41239,31625,17541,28124,36531205,25766745,1987270,50086,46152494,27384,26890,23435,1988731,2062410,35456,1994545,31117139,3263475,12879304,42841,43594,25156,29619,19558,4061087,1994693,44222,31772,53347,27082,4061211,1986433,42785,18230,1988766,17626,39231,1991413,1985660,21543,35666828,51833,25423486,36066,18375,34180,1993711,37484,1989517,50135,34716,11185192,34831,44339,24173653,36095,36327,47487,1986865,19852,1988937,41710,54374,28508,1989124,1994822,2853535,31755375,45319,16889,23500,21327,9484915,44781642,1988139,51151,19612,45143324,52662,28828,25806,23620,1984665,49229,47921,35566,43758,1990830,1988015,44660,22916,52769,29907,28923,37175,48905589,47830,24781077,1984904,1984959,45503,39083,17354,42581,48890,41615,1992841,45375,1146742,40556,24375268,35697,1985351,15375608,39198,16922,20203610,25766748,33331,29764,34013,35655,39575,16975,12910566,41649,19115,53817,21368,18520,17126,26721,53593,2064513,38480,22047,1986716,1987442,55167,20885,1986581,54243,1990539,18015,1985522,7951197,2063414,39998,20668,1989922,1990285,48716,49790,4149206,25724,45054,21179,27568,37746,33768,2066268,1989734,31967,53743,1984508,33401,1987314,31291,22441,42114,1988385,9529160,20989,33031,53783,38583,53948,26337,1993788,21032,53239,22475,44172,1990181,25273,21659,2064808,37365,1146711,46450,50325,12279128,1994889,20188,2063745,18462,32298578,41160,1989268,42428,6945367,52980,14659516,2059991,25025,30852,1992261,29547,41842,33898,19857,32806,33451,40646,1990403,32010,49548934,53131,49276,29671,2064720,36617,1986914,38060,17068,31340,35829,54464,30448600,43702020,25723022,29829,18165472,48905586,4791432,20707,50584316,30843,41198724,49046532,28492,17115,14049003,30354,42753173,30359,48663392,367391,34969921,29903,367184,44781629,22213550,45756971,48675,45548175,4061075,31259,28867356,48625745,50593655,26431,2193918,48050342,29658071,46201539,48625751,47257351,32751,41935,48863,31960,17120,16421480,29614,27820,31953,36655,13440568,47463,17670,36716325,30751,48663426,35736,45756981,46597852,48663405,49548929,33992180,26717,47888734,32353,17001,367295,367388,29658091,29104,41198692,33178,12948653,47614112,1993620,29658076,36427,48625748,45756976,45198113,2853499,28920,22612,12879310,32108,28867350,27056,26578533,50692778,29658086,25500,46992771,4061295) AND dacco.o_published = 1 AND (dacco.town__id IN (6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947)) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) Parameters: [] View formatted query View runnable query Explain query SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN ( 31474, 18290, 1986509, 26626, 30101, 29754, 30724471, 19158, 46529, 2064618, 20291, 54523, 17030, 40768, 1989224, 55324, 35341, 4063160, 35206874, 52190, 11365272, 28278, 2065098, 18776204, 40473, 1993878, 27740, 46968, 24971, 47247, 21622, 1987680, 21489, 1989189, 41879, 46933, 1994480, 46284, 19054, 1986681, 52801, 39007, 54118, 2059447, 48496, 41546, 25763, 46874, 2066111, 52545, 2058512, 4525614, 50189, 53293, 4061122, 28587, 25667, 26506, 2064168, 32550, 2061355, 47606, 47710, 1986219, 39297, 2062596, 2058626, 20643, 35324, 51357, 46733, 36492, 53474, 4761749, 8142109, 44782, 36299, 22003, 54660, 2058868, 1990242, 40425, 42551, 2065425, 32147, 31543, 27807120, 36935, 33905, 32305843, 30764208, 1985114, 19725, 12910729, 1993946, 50011, 1994761, 35666823, 1988269, 4061187, 26851, 20810, 35666833, 33519, 9455693, 16110362, 1990091, 55395, 46636, 53159, 52068, 34270, 30756, 30731557, 2065944, 2062885, 2063926, 2059767, 51034, 1433530, 47131, 28470795, 25522, 35330412, 22953, 37827, 1993209, 27298, 6645142, 28657, 37942, 52516, 17418, 10114007, 28980, 46316, 1990469, 30482936, 1987585, 21363, 1984760, 20577, 43155, 35382, 27294, 27685, 43125, 2684053, 46578, 1986476, 46206, 41793, 50194, 8537205, 47196, 42237, 53418, 28876, 44831, 35989, 38373, 1993645, 1985962, 2060384, 2059260, 17227, 51974, 1988347, 24793, 4063051, 29585, 2063196, 27471, 43837572, 47981, 1991966, 1343842, 15843263, 45923, 1991623, 51301, 1986627, 2059361, 38549, 11367489, 43472, 35994, 36664, 7738640, 42911, 44050, 24523, 11436541, 17904, 1987339, 2060738, 1984997, 37308, 1833139, 2060516, 33100, 43065, 43526, 55242, 1993438, 38423, 1987095, 18680, 2065496, 16854, 1987221, 31422, 9313566, 7738339, 1990911, 27520, 1990954, 49910, 1993811, 46250, 1987463, 7351637, 55010, 1989566, 24448, 1989012, 37859, 2064954, 18560, 27631, 1989882, 1992224, 18152, 24118, 39687, 59655, 39377, 1987293, 1985246, 1987973, 1994800, 40704, 43433, 10664738, 20023418, 30773134, 50963, 45797, 31843325, 47781, 18042, 30400, 1995175, 48017, 39922, 1986758, 19754, 5367353, 11364731, 2062975, 2060465, 30565, 24985, 9283115, 2066133, 18272, 20782, 24580, 1989465, 21585, 42977, 27868, 36160, 1995103, 43384, 1994732, 5367477, 18891, 26570, 43686, 1988874, 20840, 54339, 23991, 4608272, 41198698, 32689, 54763, 2058557, 49158, 21821, 2059571, 35206879, 30980, 53913, 38807, 2059088, 35070, 18943, 1989419, 17770, 34983, 1988207, 18328480, 19286, 29109, 24242, 2063091, 2062684, 38904, 2059839, 41366, 1990504, 45122, 43641, 2063458, 25101, 28091523, 21427, 35238, 18746, 41494, 17593634, 50760, 44587191, 1988816, 32750792, 48570, 19208, 43804, 21284, 49387, 1985474, 31336, 36100, 36531210, 37217, 4061338, 42350, 43184382, 42753168, 55108, 43414, 22775, 1991492, 25366, 31203, 17823, 27825, 1985174, 45582, 35740, 53010, 4580754, 20108, 54695, 1989075, 1994502, 1994374, 19587, 5949155, 48928, 1987706, 1991534, 1986795, 21942, 1993242, 32582, 34887538, 50850, 32076506, 367300, 19812, 1989698, 12879307, 39454, 23720, 1985415, 18813, 33077, 44387, 1994096, 21859, 2060888, 1986015, 3263472, 54166, 36227, 19244, 28867353, 52727, 49497910, 29836686, 42655, 18432, 45082, 27419533, 1990037, 19029556, 21239, 17676, 32478, 23077, 19475, 48365, 38616, 32802, 14913865, 1992394, 49189, 367148, 1992182, 32658, 23055, 15498539, 25942, 34358, 23920, 1986946, 4063277, 54798, 45252, 39558266, 25414206, 47398, 1995257, 1989832, 1987149, 52476, 1989306, 50718, 17811174, 49502, 41239, 31625, 17541, 28124, 36531205, 25766745, 1987270, 50086, 46152494, 27384, 26890, 23435, 1988731, 2062410, 35456, 1994545, 31117139, 3263475, 12879304, 42841, 43594, 25156, 29619, 19558, 4061087, 1994693, 44222, 31772, 53347, 27082, 4061211, 1986433, 42785, 18230, 1988766, 17626, 39231, 1991413, 1985660, 21543, 35666828, 51833, 25423486, 36066, 18375, 34180, 1993711, 37484, 1989517, 50135, 34716, 11185192, 34831, 44339, 24173653, 36095, 36327, 47487, 1986865, 19852, 1988937, 41710, 54374, 28508, 1989124, 1994822, 2853535, 31755375, 45319, 16889, 23500, 21327, 9484915, 44781642, 1988139, 51151, 19612, 45143324, 52662, 28828, 25806, 23620, 1984665, 49229, 47921, 35566, 43758, 1990830, 1988015, 44660, 22916, 52769, 29907, 28923, 37175, 48905589, 47830, 24781077, 1984904, 1984959, 45503, 39083, 17354, 42581, 48890, 41615, 1992841, 45375, 1146742, 40556, 24375268, 35697, 1985351, 15375608, 39198, 16922, 20203610, 25766748, 33331, 29764, 34013, 35655, 39575, 16975, 12910566, 41649, 19115, 53817, 21368, 18520, 17126, 26721, 53593, 2064513, 38480, 22047, 1986716, 1987442, 55167, 20885, 1986581, 54243, 1990539, 18015, 1985522, 7951197, 2063414, 39998, 20668, 1989922, 1990285, 48716, 49790, 4149206, 25724, 45054, 21179, 27568, 37746, 33768, 2066268, 1989734, 31967, 53743, 1984508, 33401, 1987314, 31291, 22441, 42114, 1988385, 9529160, 20989, 33031, 53783, 38583, 53948, 26337, 1993788, 21032, 53239, 22475, 44172, 1990181, 25273, 21659, 2064808, 37365, 1146711, 46450, 50325, 12279128, 1994889, 20188, 2063745, 18462, 32298578, 41160, 1989268, 42428, 6945367, 52980, 14659516, 2059991, 25025, 30852, 1992261, 29547, 41842, 33898, 19857, 32806, 33451, 40646, 1990403, 32010, 49548934, 53131, 49276, 29671, 2064720, 36617, 1986914, 38060, 17068, 31340, 35829, 54464, 30448600, 43702020, 25723022, 29829, 18165472, 48905586, 4791432, 20707, 50584316, 30843, 41198724, 49046532, 28492, 17115, 14049003, 30354, 42753173, 30359, 48663392, 367391, 34969921, 29903, 367184, 44781629, 22213550, 45756971, 48675, 45548175, 4061075, 31259, 28867356, 48625745, 50593655, 26431, 2193918, 48050342, 29658071, 46201539, 48625751, 47257351, 32751, 41935, 48863, 31960, 17120, 16421480, 29614, 27820, 31953, 36655, 13440568, 47463, 17670, 36716325, 30751, 48663426, 35736, 45756981, 46597852, 48663405, 49548929, 33992180, 26717, 47888734, 32353, 17001, 367295, 367388, 29658091, 29104, 41198692, 33178, 12948653, 47614112, 1993620, 29658076, 36427, 48625748, 45756976, 45198113, 2853499, 28920, 22612, 12879310, 32108, 28867350, 27056, 26578533, 50692778, 29658086, 25500, 46992771, 4061295 ) AND dacco.o_published = 1 AND ( dacco.town__id IN ( 6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947 ) ) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (31474,18290,1986509,26626,30101,29754,30724471,19158,46529,2064618,20291,54523,17030,40768,1989224,55324,35341,4063160,35206874,52190,11365272,28278,2065098,18776204,40473,1993878,27740,46968,24971,47247,21622,1987680,21489,1989189,41879,46933,1994480,46284,19054,1986681,52801,39007,54118,2059447,48496,41546,25763,46874,2066111,52545,2058512,4525614,50189,53293,4061122,28587,25667,26506,2064168,32550,2061355,47606,47710,1986219,39297,2062596,2058626,20643,35324,51357,46733,36492,53474,4761749,8142109,44782,36299,22003,54660,2058868,1990242,40425,42551,2065425,32147,31543,27807120,36935,33905,32305843,30764208,1985114,19725,12910729,1993946,50011,1994761,35666823,1988269,4061187,26851,20810,35666833,33519,9455693,16110362,1990091,55395,46636,53159,52068,34270,30756,30731557,2065944,2062885,2063926,2059767,51034,1433530,47131,28470795,25522,35330412,22953,37827,1993209,27298,6645142,28657,37942,52516,17418,10114007,28980,46316,1990469,30482936,1987585,21363,1984760,20577,43155,35382,27294,27685,43125,2684053,46578,1986476,46206,41793,50194,8537205,47196,42237,53418,28876,44831,35989,38373,1993645,1985962,2060384,2059260,17227,51974,1988347,24793,4063051,29585,2063196,27471,43837572,47981,1991966,1343842,15843263,45923,1991623,51301,1986627,2059361,38549,11367489,43472,35994,36664,7738640,42911,44050,24523,11436541,17904,1987339,2060738,1984997,37308,1833139,2060516,33100,43065,43526,55242,1993438,38423,1987095,18680,2065496,16854,1987221,31422,9313566,7738339,1990911,27520,1990954,49910,1993811,46250,1987463,7351637,55010,1989566,24448,1989012,37859,2064954,18560,27631,1989882,1992224,18152,24118,39687,59655,39377,1987293,1985246,1987973,1994800,40704,43433,10664738,20023418,30773134,50963,45797,31843325,47781,18042,30400,1995175,48017,39922,1986758,19754,5367353,11364731,2062975,2060465,30565,24985,9283115,2066133,18272,20782,24580,1989465,21585,42977,27868,36160,1995103,43384,1994732,5367477,18891,26570,43686,1988874,20840,54339,23991,4608272,41198698,32689,54763,2058557,49158,21821,2059571,35206879,30980,53913,38807,2059088,35070,18943,1989419,17770,34983,1988207,18328480,19286,29109,24242,2063091,2062684,38904,2059839,41366,1990504,45122,43641,2063458,25101,28091523,21427,35238,18746,41494,17593634,50760,44587191,1988816,32750792,48570,19208,43804,21284,49387,1985474,31336,36100,36531210,37217,4061338,42350,43184382,42753168,55108,43414,22775,1991492,25366,31203,17823,27825,1985174,45582,35740,53010,4580754,20108,54695,1989075,1994502,1994374,19587,5949155,48928,1987706,1991534,1986795,21942,1993242,32582,34887538,50850,32076506,367300,19812,1989698,12879307,39454,23720,1985415,18813,33077,44387,1994096,21859,2060888,1986015,3263472,54166,36227,19244,28867353,52727,49497910,29836686,42655,18432,45082,27419533,1990037,19029556,21239,17676,32478,23077,19475,48365,38616,32802,14913865,1992394,49189,367148,1992182,32658,23055,15498539,25942,34358,23920,1986946,4063277,54798,45252,39558266,25414206,47398,1995257,1989832,1987149,52476,1989306,50718,17811174,49502,41239,31625,17541,28124,36531205,25766745,1987270,50086,46152494,27384,26890,23435,1988731,2062410,35456,1994545,31117139,3263475,12879304,42841,43594,25156,29619,19558,4061087,1994693,44222,31772,53347,27082,4061211,1986433,42785,18230,1988766,17626,39231,1991413,1985660,21543,35666828,51833,25423486,36066,18375,34180,1993711,37484,1989517,50135,34716,11185192,34831,44339,24173653,36095,36327,47487,1986865,19852,1988937,41710,54374,28508,1989124,1994822,2853535,31755375,45319,16889,23500,21327,9484915,44781642,1988139,51151,19612,45143324,52662,28828,25806,23620,1984665,49229,47921,35566,43758,1990830,1988015,44660,22916,52769,29907,28923,37175,48905589,47830,24781077,1984904,1984959,45503,39083,17354,42581,48890,41615,1992841,45375,1146742,40556,24375268,35697,1985351,15375608,39198,16922,20203610,25766748,33331,29764,34013,35655,39575,16975,12910566,41649,19115,53817,21368,18520,17126,26721,53593,2064513,38480,22047,1986716,1987442,55167,20885,1986581,54243,1990539,18015,1985522,7951197,2063414,39998,20668,1989922,1990285,48716,49790,4149206,25724,45054,21179,27568,37746,33768,2066268,1989734,31967,53743,1984508,33401,1987314,31291,22441,42114,1988385,9529160,20989,33031,53783,38583,53948,26337,1993788,21032,53239,22475,44172,1990181,25273,21659,2064808,37365,1146711,46450,50325,12279128,1994889,20188,2063745,18462,32298578,41160,1989268,42428,6945367,52980,14659516,2059991,25025,30852,1992261,29547,41842,33898,19857,32806,33451,40646,1990403,32010,49548934,53131,49276,29671,2064720,36617,1986914,38060,17068,31340,35829,54464,30448600,43702020,25723022,29829,18165472,48905586,4791432,20707,50584316,30843,41198724,49046532,28492,17115,14049003,30354,42753173,30359,48663392,367391,34969921,29903,367184,44781629,22213550,45756971,48675,45548175,4061075,31259,28867356,48625745,50593655,26431,2193918,48050342,29658071,46201539,48625751,47257351,32751,41935,48863,31960,17120,16421480,29614,27820,31953,36655,13440568,47463,17670,36716325,30751,48663426,35736,45756981,46597852,48663405,49548929,33992180,26717,47888734,32353,17001,367295,367388,29658091,29104,41198692,33178,12948653,47614112,1993620,29658076,36427,48625748,45756976,45198113,2853499,28920,22612,12879310,32108,28867350,27056,26578533,50692778,29658086,25500,46992771,4061295) AND dacco.o_published = 1 AND (dacco.town__id IN (6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947)) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) ;
12	0.10 ms	create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (1986795),(23435),(55167),(38423),(46316),(54339),(52545),(44050),(45797),(49790),(25942),(30756),(28876),(18813),(25423486),(2060888),(49276),(1986681),(20203610),(48365),(41793),(34013),(33519),(30773134),(25522),(14659516),(28470795),(43125),(50325),(1984508),(42911),(46206),(1988139),(15843263),(30101),(2060516),(17676),(4061338),(7351637),(35070),(20023418),(35206874),(53159),(1986865),(7738640),(1992394),(5367477),(27685),(44172),(46874),(45122),(31203),(44339),(1991966),(49387),(17823),(38060),(1993645),(1833139),(55324),(53239),(38807),(55395),(1986627),(42841),(36492),(9529160),(46636),(50850),(10664738),(19852),(52190),(32689),(45252),(29547),(41198698),(1994374),(46578),(48017),(39558266),(55242),(36935),(5949155),(30731557),(32298578),(51151),(2064618),(11364731),(1146742),(19158),(41649),(53593),(47487),(37175),(38904),(11436541),(43837572),(2064720),(7738339),(35666833),(48905589),(41366),(21368),(43641),(9283115),(1984959),(1990285),(36531210),(44587191),(54695),(11365272),(24448),(18290),(1985415),(39231),(47606),(39454),(44831),(46733),(41239),(10114007),(24242),(47921),(21859),(40768),(18165472),(16110362),(24781077),(43702020),(1995257),(21659),(59655),(39377),(18328480),(27868),(1988874),(31117139),(367300),(41879),(23077),(30980),(41615),(33905),(36531205),(48570),(2684053),(42753168),(25025),(46250),(45143324),(31340),(40646),(17418),(1988816),(34358),(1984760),(12910566),(2059839),(25273),(20707),(1985660),(1993946),(17904),(26570),(53347),(41160),(12910729),(38373),(53743),(27419533),(44781642),(42350),(38480),(33451),(2059991),(24793),(48496),(28091523),(1995103),(1985522),(26337),(4149206),(46152494),(32010),(1985174),(1994889),(2065944),(8537205),(32305843),(38616),(43184382),(39575),(42655),(1984904),(20840),(20291),(50189),(2063745),(28657),(27471),(34983),(1988207),(1433530),(54798),(28124),(37365),(17593634),(40473),(24971),(1989566),(34831),(2063458),(39083),(43526),(4061122),(26431),(44387),(1986716),(35330412),(23620),(43804),(31772),(20577),(1987706),(36664),(26721),(12879304),(1988937),(44660),(45582),(1988385),(36617),(43414),(46450),(1993711),(40556),(54523),(25766745),(1986946),(19857),(48890),(50086),(47398),(46968),(39687),(1994545),(45319),(37217),(35666828),(44781629),(1987463),(42428),(53948),(26851),(49502),(49548934),(1985474),(47247),(18746),(43758),(35666823),(22475),(20108),(1994732),(15498539),(4525614),(33768),(44222),(2064808),(23500),(52476),(1993242),(9455693),(1993811),(45375),(1993878),(17126),(2065496),(4061187),(28278),(30482936),(50194),(1990539),(18432),(39998),(32353),(6645142),(27631),(51034),(43155),(40425),(2061355),(37942),(45198113),(36327),(54166),(51833),(8142109),(2059260),(14913865),(19475),(35206879),(28867350),(22213550),(2062684),(15375608),(18462),(4761749),(1990954),(52801),(1993209),(2062410),(17811174),(18680),(28867356),(25763),(33100),(23991),(19115),(45054),(11367489),(35324),(31422),(21427),(18776204),(30565),(4061211),(43065),(31625),(47781),(9484915),(39297),(1992182),(1986015),(1991492),(1984997),(39007),(35382),(31843325),(31474),(1989306),(12279128),(1146711),(51357),(36160),(43433),(37746),(31543),(35655),(49497910),(42581),(34270),(9313566),(50011),(1987095),(28828),(23920),(25723022),(32750792),(47131),(42114),(1984665),(53474),(30764208),(1992261),(18042),(28587),(1989012),(1991623),(24375268),(42785),(1986433),(2059361),(54118),(4063051),(11185192),(19054),(1985351),(2064168),(1995175),(2058868),(4608272) Parameters: [] View formatted query View runnable query Explain query create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine = memory; insert into `steiermark`.accoIdsTowns (id) values (1986795), (23435), (55167), (38423), (46316), (54339), (52545), (44050), (45797), (49790), (25942), (30756), (28876), (18813), (25423486), (2060888), (49276), (1986681), (20203610), (48365), (41793), (34013), (33519), (30773134), (25522), (14659516), (28470795), (43125), (50325), (1984508), (42911), (46206), (1988139), (15843263), (30101), (2060516), (17676), (4061338), (7351637), (35070), (20023418), (35206874), (53159), (1986865), (7738640), (1992394), (5367477), (27685), (44172), (46874), (45122), (31203), (44339), (1991966), (49387), (17823), (38060), (1993645), (1833139), (55324), (53239), (38807), (55395), (1986627), (42841), (36492), (9529160), (46636), (50850), (10664738), (19852), (52190), (32689), (45252), (29547), (41198698), (1994374), (46578), (48017), (39558266), (55242), (36935), (5949155), (30731557), (32298578), (51151), (2064618), (11364731), (1146742), (19158), (41649), (53593), (47487), (37175), (38904), (11436541), (43837572), (2064720), (7738339), (35666833), (48905589), (41366), (21368), (43641), (9283115), (1984959), (1990285), (36531210), (44587191), (54695), (11365272), (24448), (18290), (1985415), (39231), (47606), (39454), (44831), (46733), (41239), (10114007), (24242), (47921), (21859), (40768), (18165472), (16110362), (24781077), (43702020), (1995257), (21659), (59655), (39377), (18328480), (27868), (1988874), (31117139), (367300), (41879), (23077), (30980), (41615), (33905), (36531205), (48570), (2684053), (42753168), (25025), (46250), (45143324), (31340), (40646), (17418), (1988816), (34358), (1984760), (12910566), (2059839), (25273), (20707), (1985660), (1993946), (17904), (26570), (53347), (41160), (12910729), (38373), (53743), (27419533), (44781642), (42350), (38480), (33451), (2059991), (24793), (48496), (28091523), (1995103), (1985522), (26337), (4149206), (46152494), (32010), (1985174), (1994889), (2065944), (8537205), (32305843), (38616), (43184382), (39575), (42655), (1984904), (20840), (20291), (50189), (2063745), (28657), (27471), (34983), (1988207), (1433530), (54798), (28124), (37365), (17593634), (40473), (24971), (1989566), (34831), (2063458), (39083), (43526), (4061122), (26431), (44387), (1986716), (35330412), (23620), (43804), (31772), (20577), (1987706), (36664), (26721), (12879304), (1988937), (44660), (45582), (1988385), (36617), (43414), (46450), (1993711), (40556), (54523), (25766745), (1986946), (19857), (48890), (50086), (47398), (46968), (39687), (1994545), (45319), (37217), (35666828), (44781629), (1987463), (42428), (53948), (26851), (49502), (49548934), (1985474), (47247), (18746), (43758), (35666823), (22475), (20108), (1994732), (15498539), (4525614), (33768), (44222), (2064808), (23500), (52476), (1993242), (9455693), (1993811), (45375), (1993878), (17126), (2065496), (4061187), (28278), (30482936), (50194), (1990539), (18432), (39998), (32353), (6645142), (27631), (51034), (43155), (40425), (2061355), (37942), (45198113), (36327), (54166), (51833), (8142109), (2059260), (14913865), (19475), (35206879), (28867350), (22213550), (2062684), (15375608), (18462), (4761749), (1990954), (52801), (1993209), (2062410), (17811174), (18680), (28867356), (25763), (33100), (23991), (19115), (45054), (11367489), (35324), (31422), (21427), (18776204), (30565), (4061211), (43065), (31625), (47781), (9484915), (39297), (1992182), (1986015), (1991492), (1984997), (39007), (35382), (31843325), (31474), (1989306), (12279128), (1146711), (51357), (36160), (43433), (37746), (31543), (35655), (49497910), (42581), (34270), (9313566), (50011), (1987095), (28828), (23920), (25723022), (32750792), (47131), (42114), (1984665), (53474), (30764208), (1992261), (18042), (28587), (1989012), (1991623), (24375268), (42785), (1986433), (2059361), (54118), (4063051), (11185192), (19054), (1985351), (2064168), (1995175), (2058868), (4608272) create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (1986795),(23435),(55167),(38423),(46316),(54339),(52545),(44050),(45797),(49790),(25942),(30756),(28876),(18813),(25423486),(2060888),(49276),(1986681),(20203610),(48365),(41793),(34013),(33519),(30773134),(25522),(14659516),(28470795),(43125),(50325),(1984508),(42911),(46206),(1988139),(15843263),(30101),(2060516),(17676),(4061338),(7351637),(35070),(20023418),(35206874),(53159),(1986865),(7738640),(1992394),(5367477),(27685),(44172),(46874),(45122),(31203),(44339),(1991966),(49387),(17823),(38060),(1993645),(1833139),(55324),(53239),(38807),(55395),(1986627),(42841),(36492),(9529160),(46636),(50850),(10664738),(19852),(52190),(32689),(45252),(29547),(41198698),(1994374),(46578),(48017),(39558266),(55242),(36935),(5949155),(30731557),(32298578),(51151),(2064618),(11364731),(1146742),(19158),(41649),(53593),(47487),(37175),(38904),(11436541),(43837572),(2064720),(7738339),(35666833),(48905589),(41366),(21368),(43641),(9283115),(1984959),(1990285),(36531210),(44587191),(54695),(11365272),(24448),(18290),(1985415),(39231),(47606),(39454),(44831),(46733),(41239),(10114007),(24242),(47921),(21859),(40768),(18165472),(16110362),(24781077),(43702020),(1995257),(21659),(59655),(39377),(18328480),(27868),(1988874),(31117139),(367300),(41879),(23077),(30980),(41615),(33905),(36531205),(48570),(2684053),(42753168),(25025),(46250),(45143324),(31340),(40646),(17418),(1988816),(34358),(1984760),(12910566),(2059839),(25273),(20707),(1985660),(1993946),(17904),(26570),(53347),(41160),(12910729),(38373),(53743),(27419533),(44781642),(42350),(38480),(33451),(2059991),(24793),(48496),(28091523),(1995103),(1985522),(26337),(4149206),(46152494),(32010),(1985174),(1994889),(2065944),(8537205),(32305843),(38616),(43184382),(39575),(42655),(1984904),(20840),(20291),(50189),(2063745),(28657),(27471),(34983),(1988207),(1433530),(54798),(28124),(37365),(17593634),(40473),(24971),(1989566),(34831),(2063458),(39083),(43526),(4061122),(26431),(44387),(1986716),(35330412),(23620),(43804),(31772),(20577),(1987706),(36664),(26721),(12879304),(1988937),(44660),(45582),(1988385),(36617),(43414),(46450),(1993711),(40556),(54523),(25766745),(1986946),(19857),(48890),(50086),(47398),(46968),(39687),(1994545),(45319),(37217),(35666828),(44781629),(1987463),(42428),(53948),(26851),(49502),(49548934),(1985474),(47247),(18746),(43758),(35666823),(22475),(20108),(1994732),(15498539),(4525614),(33768),(44222),(2064808),(23500),(52476),(1993242),(9455693),(1993811),(45375),(1993878),(17126),(2065496),(4061187),(28278),(30482936),(50194),(1990539),(18432),(39998),(32353),(6645142),(27631),(51034),(43155),(40425),(2061355),(37942),(45198113),(36327),(54166),(51833),(8142109),(2059260),(14913865),(19475),(35206879),(28867350),(22213550),(2062684),(15375608),(18462),(4761749),(1990954),(52801),(1993209),(2062410),(17811174),(18680),(28867356),(25763),(33100),(23991),(19115),(45054),(11367489),(35324),(31422),(21427),(18776204),(30565),(4061211),(43065),(31625),(47781),(9484915),(39297),(1992182),(1986015),(1991492),(1984997),(39007),(35382),(31843325),(31474),(1989306),(12279128),(1146711),(51357),(36160),(43433),(37746),(31543),(35655),(49497910),(42581),(34270),(9313566),(50011),(1987095),(28828),(23920),(25723022),(32750792),(47131),(42114),(1984665),(53474),(30764208),(1992261),(18042),(28587),(1989012),(1991623),(24375268),(42785),(1986433),(2059361),(54118),(4063051),(11185192),(19054),(1985351),(2064168),(1995175),(2058868),(4608272);
13	16.53 ms	SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (6815, 6813, 13756965, 6825, 6809, 6831, 6806, 6839, 6807, 6824, 6817, 6816, 6819, 6822) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id Parameters: [] View formatted query View runnable query Explain query SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN ( 6815, 6813, 13756965, 6825, 6809, 6831, 6806, 6839, 6807, 6824, 6817, 6816, 6819, 6822 ) AND src_id IN ( select id from `steiermark`.accoIdsTowns ) group by dest_id SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (6815, 6813, 13756965, 6825, 6809, 6831, 6806, 6839, 6807, 6824, 6817, 6816, 6819, 6822) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id ;
14	0.06 ms	DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns; Parameters: [] View formatted query View runnable query Explain query DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns; DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;;
15	8.30 ms	SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (31474,18290,1986509,26626,30101,29754,30724471,19158,46529,2064618,20291,54523,17030,40768,1989224,55324,35341,4063160,35206874,52190,11365272,28278,2065098,18776204,40473,1993878,27740,46968,24971,47247,21622,1987680,21489,1989189,41879,46933,1994480,46284,19054,1986681,52801,39007,54118,2059447,48496,41546,25763,46874,2066111,52545,2058512,4525614,50189,53293,4061122,28587,25667,26506,2064168,32550,2061355,47606,47710,1986219,39297,2062596,2058626,20643,35324,51357,46733,36492,53474,4761749,8142109,44782,36299,22003,54660,2058868,1990242,40425,42551,2065425,32147,31543,27807120,36935,33905,32305843,30764208,1985114,19725,12910729,1993946,50011,1994761,35666823,1988269,4061187,26851,20810,35666833,33519,9455693,16110362,1990091,55395,46636,53159,52068,34270,30756,30731557,2065944,2062885,2063926,2059767,51034,1433530,47131,28470795,25522,35330412,22953,37827,1993209,27298,6645142,28657,37942,52516,17418,10114007,28980,46316,1990469,30482936,1987585,21363,1984760,20577,43155,35382,27294,27685,43125,2684053,46578,1986476,46206,41793,50194,8537205,47196,42237,53418,28876,44831,35989,38373,1993645,1985962,2060384,2059260,17227,51974,1988347,24793,4063051,29585,2063196,27471,43837572,47981,1991966,1343842,15843263,45923,1991623,51301,1986627,2059361,38549,11367489,43472,35994,36664,7738640,42911,44050,24523,11436541,17904,1987339,2060738,1984997,37308,1833139,2060516,33100,43065,43526,55242,1993438,38423,1987095,18680,2065496,16854,1987221,31422,9313566,7738339,1990911,27520,1990954,49910,1993811,46250,1987463,7351637,55010,1989566,24448,1989012,37859,2064954,18560,27631,1989882,1992224,18152,24118,39687,59655,39377,1987293,1985246,1987973,1994800,40704,43433,10664738,20023418,30773134,50963,45797,31843325,47781,18042,30400,1995175,48017,39922,1986758,19754,5367353,11364731,2062975,2060465,30565,24985,9283115,2066133,18272,20782,24580,1989465,21585,42977,27868,36160,1995103,43384,1994732,5367477,18891,26570,43686,1988874,20840,54339,23991,4608272,41198698,32689,54763,2058557,49158,21821,2059571,35206879,30980,53913,38807,2059088,35070,18943,1989419,17770,34983,1988207,18328480,19286,29109,24242,2063091,2062684,38904,2059839,41366,1990504,45122,43641,2063458,25101,28091523,21427,35238,18746,41494,17593634,50760,44587191,1988816,32750792,48570,19208,43804,21284,49387,1985474,31336,36100,36531210,37217,4061338,42350,43184382,42753168,55108,43414,22775,1991492,25366,31203,17823,27825,1985174,45582,35740,53010,4580754,20108,54695,1989075,1994502,1994374,19587,5949155,48928,1987706,1991534,1986795,21942,1993242,32582,34887538,50850,32076506,367300,19812,1989698,12879307,39454,23720,1985415,18813,33077,44387,1994096,21859,2060888,1986015,3263472,54166,36227,19244,28867353,52727,49497910,29836686,42655,18432,45082,27419533,1990037,19029556,21239,17676,32478,23077,19475,48365,38616,32802,14913865,1992394,49189,367148,1992182,32658,23055,15498539,25942,34358,23920,1986946,4063277,54798,45252,39558266,25414206,47398,1995257,1989832,1987149,52476,1989306,50718,17811174,49502,41239,31625,17541,28124,36531205,25766745,1987270,50086,46152494,27384,26890,23435,1988731,2062410,35456,1994545,31117139,3263475,12879304,42841,43594,25156,29619,19558,4061087,1994693,44222,31772,53347,27082,4061211,1986433,42785,18230,1988766,17626,39231,1991413,1985660,21543,35666828,51833,25423486,36066,18375,34180,1993711,37484,1989517,50135,34716,11185192,34831,44339,24173653,36095,36327,47487,1986865,19852,1988937,41710,54374,28508,1989124,1994822,2853535,31755375,45319,16889,23500,21327,9484915,44781642,1988139,51151,19612,45143324,52662,28828,25806,23620,1984665,49229,47921,35566,43758,1990830,1988015,44660,22916,52769,29907,28923,37175,48905589,47830,24781077,1984904,1984959,45503,39083,17354,42581,48890,41615,1992841,45375,1146742,40556,24375268,35697,1985351,15375608,39198,16922,20203610,25766748,33331,29764,34013,35655,39575,16975,12910566,41649,19115,53817,21368,18520,17126,26721,53593,2064513,38480,22047,1986716,1987442,55167,20885,1986581,54243,1990539,18015,1985522,7951197,2063414,39998,20668,1989922,1990285,48716,49790,4149206,25724,45054,21179,27568,37746,33768,2066268,1989734,31967,53743,1984508,33401,1987314,31291,22441,42114,1988385,9529160,20989,33031,53783,38583,53948,26337,1993788,21032,53239,22475,44172,1990181,25273,21659,2064808,37365,1146711,46450,50325,12279128,1994889,20188,2063745,18462,32298578,41160,1989268,42428,6945367,52980,14659516,2059991,25025,30852,1992261,29547,41842,33898,19857,32806,33451,40646,1990403,32010,49548934,53131,49276,29671,2064720,36617,1986914,38060,17068,31340,35829,54464,30448600,43702020,25723022,29829,18165472,48905586,4791432,20707,50584316,30843,41198724,49046532,28492,17115,14049003,30354,42753173,30359,48663392,367391,34969921,29903,367184,44781629,22213550,45756971,48675,45548175,4061075,31259,28867356,48625745,50593655,26431,2193918,48050342,29658071,46201539,48625751,47257351,32751,41935,48863,31960,17120,16421480,29614,27820,31953,36655,13440568,47463,17670,36716325,30751,48663426,35736,45756981,46597852,48663405,49548929,33992180,26717,47888734,32353,17001,367295,367388,29658091,29104,41198692,33178,12948653,47614112,1993620,29658076,36427,48625748,45756976,45198113,2853499,28920,22612,12879310,32108,28867350,27056,26578533,50692778,29658086,25500,46992771,4061295) AND dacco.o_published = 1 AND (dacco.town__id IN (6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947)) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) Parameters: [] View formatted query View runnable query Explain query SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN ( 31474, 18290, 1986509, 26626, 30101, 29754, 30724471, 19158, 46529, 2064618, 20291, 54523, 17030, 40768, 1989224, 55324, 35341, 4063160, 35206874, 52190, 11365272, 28278, 2065098, 18776204, 40473, 1993878, 27740, 46968, 24971, 47247, 21622, 1987680, 21489, 1989189, 41879, 46933, 1994480, 46284, 19054, 1986681, 52801, 39007, 54118, 2059447, 48496, 41546, 25763, 46874, 2066111, 52545, 2058512, 4525614, 50189, 53293, 4061122, 28587, 25667, 26506, 2064168, 32550, 2061355, 47606, 47710, 1986219, 39297, 2062596, 2058626, 20643, 35324, 51357, 46733, 36492, 53474, 4761749, 8142109, 44782, 36299, 22003, 54660, 2058868, 1990242, 40425, 42551, 2065425, 32147, 31543, 27807120, 36935, 33905, 32305843, 30764208, 1985114, 19725, 12910729, 1993946, 50011, 1994761, 35666823, 1988269, 4061187, 26851, 20810, 35666833, 33519, 9455693, 16110362, 1990091, 55395, 46636, 53159, 52068, 34270, 30756, 30731557, 2065944, 2062885, 2063926, 2059767, 51034, 1433530, 47131, 28470795, 25522, 35330412, 22953, 37827, 1993209, 27298, 6645142, 28657, 37942, 52516, 17418, 10114007, 28980, 46316, 1990469, 30482936, 1987585, 21363, 1984760, 20577, 43155, 35382, 27294, 27685, 43125, 2684053, 46578, 1986476, 46206, 41793, 50194, 8537205, 47196, 42237, 53418, 28876, 44831, 35989, 38373, 1993645, 1985962, 2060384, 2059260, 17227, 51974, 1988347, 24793, 4063051, 29585, 2063196, 27471, 43837572, 47981, 1991966, 1343842, 15843263, 45923, 1991623, 51301, 1986627, 2059361, 38549, 11367489, 43472, 35994, 36664, 7738640, 42911, 44050, 24523, 11436541, 17904, 1987339, 2060738, 1984997, 37308, 1833139, 2060516, 33100, 43065, 43526, 55242, 1993438, 38423, 1987095, 18680, 2065496, 16854, 1987221, 31422, 9313566, 7738339, 1990911, 27520, 1990954, 49910, 1993811, 46250, 1987463, 7351637, 55010, 1989566, 24448, 1989012, 37859, 2064954, 18560, 27631, 1989882, 1992224, 18152, 24118, 39687, 59655, 39377, 1987293, 1985246, 1987973, 1994800, 40704, 43433, 10664738, 20023418, 30773134, 50963, 45797, 31843325, 47781, 18042, 30400, 1995175, 48017, 39922, 1986758, 19754, 5367353, 11364731, 2062975, 2060465, 30565, 24985, 9283115, 2066133, 18272, 20782, 24580, 1989465, 21585, 42977, 27868, 36160, 1995103, 43384, 1994732, 5367477, 18891, 26570, 43686, 1988874, 20840, 54339, 23991, 4608272, 41198698, 32689, 54763, 2058557, 49158, 21821, 2059571, 35206879, 30980, 53913, 38807, 2059088, 35070, 18943, 1989419, 17770, 34983, 1988207, 18328480, 19286, 29109, 24242, 2063091, 2062684, 38904, 2059839, 41366, 1990504, 45122, 43641, 2063458, 25101, 28091523, 21427, 35238, 18746, 41494, 17593634, 50760, 44587191, 1988816, 32750792, 48570, 19208, 43804, 21284, 49387, 1985474, 31336, 36100, 36531210, 37217, 4061338, 42350, 43184382, 42753168, 55108, 43414, 22775, 1991492, 25366, 31203, 17823, 27825, 1985174, 45582, 35740, 53010, 4580754, 20108, 54695, 1989075, 1994502, 1994374, 19587, 5949155, 48928, 1987706, 1991534, 1986795, 21942, 1993242, 32582, 34887538, 50850, 32076506, 367300, 19812, 1989698, 12879307, 39454, 23720, 1985415, 18813, 33077, 44387, 1994096, 21859, 2060888, 1986015, 3263472, 54166, 36227, 19244, 28867353, 52727, 49497910, 29836686, 42655, 18432, 45082, 27419533, 1990037, 19029556, 21239, 17676, 32478, 23077, 19475, 48365, 38616, 32802, 14913865, 1992394, 49189, 367148, 1992182, 32658, 23055, 15498539, 25942, 34358, 23920, 1986946, 4063277, 54798, 45252, 39558266, 25414206, 47398, 1995257, 1989832, 1987149, 52476, 1989306, 50718, 17811174, 49502, 41239, 31625, 17541, 28124, 36531205, 25766745, 1987270, 50086, 46152494, 27384, 26890, 23435, 1988731, 2062410, 35456, 1994545, 31117139, 3263475, 12879304, 42841, 43594, 25156, 29619, 19558, 4061087, 1994693, 44222, 31772, 53347, 27082, 4061211, 1986433, 42785, 18230, 1988766, 17626, 39231, 1991413, 1985660, 21543, 35666828, 51833, 25423486, 36066, 18375, 34180, 1993711, 37484, 1989517, 50135, 34716, 11185192, 34831, 44339, 24173653, 36095, 36327, 47487, 1986865, 19852, 1988937, 41710, 54374, 28508, 1989124, 1994822, 2853535, 31755375, 45319, 16889, 23500, 21327, 9484915, 44781642, 1988139, 51151, 19612, 45143324, 52662, 28828, 25806, 23620, 1984665, 49229, 47921, 35566, 43758, 1990830, 1988015, 44660, 22916, 52769, 29907, 28923, 37175, 48905589, 47830, 24781077, 1984904, 1984959, 45503, 39083, 17354, 42581, 48890, 41615, 1992841, 45375, 1146742, 40556, 24375268, 35697, 1985351, 15375608, 39198, 16922, 20203610, 25766748, 33331, 29764, 34013, 35655, 39575, 16975, 12910566, 41649, 19115, 53817, 21368, 18520, 17126, 26721, 53593, 2064513, 38480, 22047, 1986716, 1987442, 55167, 20885, 1986581, 54243, 1990539, 18015, 1985522, 7951197, 2063414, 39998, 20668, 1989922, 1990285, 48716, 49790, 4149206, 25724, 45054, 21179, 27568, 37746, 33768, 2066268, 1989734, 31967, 53743, 1984508, 33401, 1987314, 31291, 22441, 42114, 1988385, 9529160, 20989, 33031, 53783, 38583, 53948, 26337, 1993788, 21032, 53239, 22475, 44172, 1990181, 25273, 21659, 2064808, 37365, 1146711, 46450, 50325, 12279128, 1994889, 20188, 2063745, 18462, 32298578, 41160, 1989268, 42428, 6945367, 52980, 14659516, 2059991, 25025, 30852, 1992261, 29547, 41842, 33898, 19857, 32806, 33451, 40646, 1990403, 32010, 49548934, 53131, 49276, 29671, 2064720, 36617, 1986914, 38060, 17068, 31340, 35829, 54464, 30448600, 43702020, 25723022, 29829, 18165472, 48905586, 4791432, 20707, 50584316, 30843, 41198724, 49046532, 28492, 17115, 14049003, 30354, 42753173, 30359, 48663392, 367391, 34969921, 29903, 367184, 44781629, 22213550, 45756971, 48675, 45548175, 4061075, 31259, 28867356, 48625745, 50593655, 26431, 2193918, 48050342, 29658071, 46201539, 48625751, 47257351, 32751, 41935, 48863, 31960, 17120, 16421480, 29614, 27820, 31953, 36655, 13440568, 47463, 17670, 36716325, 30751, 48663426, 35736, 45756981, 46597852, 48663405, 49548929, 33992180, 26717, 47888734, 32353, 17001, 367295, 367388, 29658091, 29104, 41198692, 33178, 12948653, 47614112, 1993620, 29658076, 36427, 48625748, 45756976, 45198113, 2853499, 28920, 22612, 12879310, 32108, 28867350, 27056, 26578533, 50692778, 29658086, 25500, 46992771, 4061295 ) AND dacco.o_published = 1 AND ( dacco.town__id IN ( 6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947 ) ) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (31474,18290,1986509,26626,30101,29754,30724471,19158,46529,2064618,20291,54523,17030,40768,1989224,55324,35341,4063160,35206874,52190,11365272,28278,2065098,18776204,40473,1993878,27740,46968,24971,47247,21622,1987680,21489,1989189,41879,46933,1994480,46284,19054,1986681,52801,39007,54118,2059447,48496,41546,25763,46874,2066111,52545,2058512,4525614,50189,53293,4061122,28587,25667,26506,2064168,32550,2061355,47606,47710,1986219,39297,2062596,2058626,20643,35324,51357,46733,36492,53474,4761749,8142109,44782,36299,22003,54660,2058868,1990242,40425,42551,2065425,32147,31543,27807120,36935,33905,32305843,30764208,1985114,19725,12910729,1993946,50011,1994761,35666823,1988269,4061187,26851,20810,35666833,33519,9455693,16110362,1990091,55395,46636,53159,52068,34270,30756,30731557,2065944,2062885,2063926,2059767,51034,1433530,47131,28470795,25522,35330412,22953,37827,1993209,27298,6645142,28657,37942,52516,17418,10114007,28980,46316,1990469,30482936,1987585,21363,1984760,20577,43155,35382,27294,27685,43125,2684053,46578,1986476,46206,41793,50194,8537205,47196,42237,53418,28876,44831,35989,38373,1993645,1985962,2060384,2059260,17227,51974,1988347,24793,4063051,29585,2063196,27471,43837572,47981,1991966,1343842,15843263,45923,1991623,51301,1986627,2059361,38549,11367489,43472,35994,36664,7738640,42911,44050,24523,11436541,17904,1987339,2060738,1984997,37308,1833139,2060516,33100,43065,43526,55242,1993438,38423,1987095,18680,2065496,16854,1987221,31422,9313566,7738339,1990911,27520,1990954,49910,1993811,46250,1987463,7351637,55010,1989566,24448,1989012,37859,2064954,18560,27631,1989882,1992224,18152,24118,39687,59655,39377,1987293,1985246,1987973,1994800,40704,43433,10664738,20023418,30773134,50963,45797,31843325,47781,18042,30400,1995175,48017,39922,1986758,19754,5367353,11364731,2062975,2060465,30565,24985,9283115,2066133,18272,20782,24580,1989465,21585,42977,27868,36160,1995103,43384,1994732,5367477,18891,26570,43686,1988874,20840,54339,23991,4608272,41198698,32689,54763,2058557,49158,21821,2059571,35206879,30980,53913,38807,2059088,35070,18943,1989419,17770,34983,1988207,18328480,19286,29109,24242,2063091,2062684,38904,2059839,41366,1990504,45122,43641,2063458,25101,28091523,21427,35238,18746,41494,17593634,50760,44587191,1988816,32750792,48570,19208,43804,21284,49387,1985474,31336,36100,36531210,37217,4061338,42350,43184382,42753168,55108,43414,22775,1991492,25366,31203,17823,27825,1985174,45582,35740,53010,4580754,20108,54695,1989075,1994502,1994374,19587,5949155,48928,1987706,1991534,1986795,21942,1993242,32582,34887538,50850,32076506,367300,19812,1989698,12879307,39454,23720,1985415,18813,33077,44387,1994096,21859,2060888,1986015,3263472,54166,36227,19244,28867353,52727,49497910,29836686,42655,18432,45082,27419533,1990037,19029556,21239,17676,32478,23077,19475,48365,38616,32802,14913865,1992394,49189,367148,1992182,32658,23055,15498539,25942,34358,23920,1986946,4063277,54798,45252,39558266,25414206,47398,1995257,1989832,1987149,52476,1989306,50718,17811174,49502,41239,31625,17541,28124,36531205,25766745,1987270,50086,46152494,27384,26890,23435,1988731,2062410,35456,1994545,31117139,3263475,12879304,42841,43594,25156,29619,19558,4061087,1994693,44222,31772,53347,27082,4061211,1986433,42785,18230,1988766,17626,39231,1991413,1985660,21543,35666828,51833,25423486,36066,18375,34180,1993711,37484,1989517,50135,34716,11185192,34831,44339,24173653,36095,36327,47487,1986865,19852,1988937,41710,54374,28508,1989124,1994822,2853535,31755375,45319,16889,23500,21327,9484915,44781642,1988139,51151,19612,45143324,52662,28828,25806,23620,1984665,49229,47921,35566,43758,1990830,1988015,44660,22916,52769,29907,28923,37175,48905589,47830,24781077,1984904,1984959,45503,39083,17354,42581,48890,41615,1992841,45375,1146742,40556,24375268,35697,1985351,15375608,39198,16922,20203610,25766748,33331,29764,34013,35655,39575,16975,12910566,41649,19115,53817,21368,18520,17126,26721,53593,2064513,38480,22047,1986716,1987442,55167,20885,1986581,54243,1990539,18015,1985522,7951197,2063414,39998,20668,1989922,1990285,48716,49790,4149206,25724,45054,21179,27568,37746,33768,2066268,1989734,31967,53743,1984508,33401,1987314,31291,22441,42114,1988385,9529160,20989,33031,53783,38583,53948,26337,1993788,21032,53239,22475,44172,1990181,25273,21659,2064808,37365,1146711,46450,50325,12279128,1994889,20188,2063745,18462,32298578,41160,1989268,42428,6945367,52980,14659516,2059991,25025,30852,1992261,29547,41842,33898,19857,32806,33451,40646,1990403,32010,49548934,53131,49276,29671,2064720,36617,1986914,38060,17068,31340,35829,54464,30448600,43702020,25723022,29829,18165472,48905586,4791432,20707,50584316,30843,41198724,49046532,28492,17115,14049003,30354,42753173,30359,48663392,367391,34969921,29903,367184,44781629,22213550,45756971,48675,45548175,4061075,31259,28867356,48625745,50593655,26431,2193918,48050342,29658071,46201539,48625751,47257351,32751,41935,48863,31960,17120,16421480,29614,27820,31953,36655,13440568,47463,17670,36716325,30751,48663426,35736,45756981,46597852,48663405,49548929,33992180,26717,47888734,32353,17001,367295,367388,29658091,29104,41198692,33178,12948653,47614112,1993620,29658076,36427,48625748,45756976,45198113,2853499,28920,22612,12879310,32108,28867350,27056,26578533,50692778,29658086,25500,46992771,4061295) AND dacco.o_published = 1 AND (dacco.town__id IN (6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947)) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) ;
16	0.10 ms	create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (1986795),(23435),(55167),(38423),(46316),(54339),(52545),(44050),(45797),(49790),(25942),(30756),(28876),(18813),(25423486),(2060888),(49276),(1986681),(20203610),(48365),(41793),(34013),(33519),(30773134),(25522),(14659516),(28470795),(43125),(50325),(1984508),(42911),(46206),(1988139),(15843263),(30101),(2060516),(17676),(4061338),(7351637),(35070),(20023418),(35206874),(53159),(1986865),(7738640),(1992394),(5367477),(27685),(44172),(46874),(45122),(31203),(44339),(1991966),(49387),(17823),(38060),(1993645),(1833139),(55324),(53239),(38807),(55395),(1986627),(42841),(36492),(9529160),(46636),(50850),(10664738),(19852),(52190),(32689),(45252),(29547),(41198698),(1994374),(46578),(48017),(39558266),(55242),(36935),(5949155),(30731557),(32298578),(51151),(2064618),(11364731),(1146742),(19158),(41649),(53593),(47487),(37175),(38904),(11436541),(43837572),(2064720),(7738339),(35666833),(48905589),(41366),(21368),(43641),(9283115),(1984959),(1990285),(36531210),(44587191),(54695),(11365272),(24448),(18290),(1985415),(39231),(47606),(39454),(44831),(46733),(41239),(10114007),(24242),(47921),(21859),(40768),(18165472),(16110362),(24781077),(43702020),(1995257),(21659),(59655),(39377),(18328480),(27868),(1988874),(31117139),(367300),(41879),(23077),(30980),(41615),(33905),(36531205),(48570),(2684053),(42753168),(25025),(46250),(45143324),(31340),(40646),(17418),(1988816),(34358),(1984760),(12910566),(2059839),(25273),(20707),(1985660),(1993946),(17904),(26570),(53347),(41160),(12910729),(38373),(53743),(27419533),(44781642),(42350),(38480),(33451),(2059991),(24793),(48496),(28091523),(1995103),(1985522),(26337),(4149206),(46152494),(32010),(1985174),(1994889),(2065944),(8537205),(32305843),(38616),(43184382),(39575),(42655),(1984904),(20840),(20291),(50189),(2063745),(28657),(27471),(34983),(1988207),(1433530),(54798),(28124),(37365),(17593634),(40473),(24971),(1989566),(34831),(2063458),(39083),(43526),(4061122),(26431),(44387),(1986716),(35330412),(23620),(43804),(31772),(20577),(1987706),(36664),(26721),(12879304),(1988937),(44660),(45582),(1988385),(36617),(43414),(46450),(1993711),(40556),(54523),(25766745),(1986946),(19857),(48890),(50086),(47398),(46968),(39687),(1994545),(45319),(37217),(35666828),(44781629),(1987463),(42428),(53948),(26851),(49502),(49548934),(1985474),(47247),(18746),(43758),(35666823),(22475),(20108),(1994732),(15498539),(4525614),(33768),(44222),(2064808),(23500),(52476),(1993242),(9455693),(1993811),(45375),(1993878),(17126),(2065496),(4061187),(28278),(30482936),(50194),(1990539),(18432),(39998),(32353),(6645142),(27631),(51034),(43155),(40425),(2061355),(37942),(45198113),(36327),(54166),(51833),(8142109),(2059260),(14913865),(19475),(35206879),(28867350),(22213550),(2062684),(15375608),(18462),(4761749),(1990954),(52801),(1993209),(2062410),(17811174),(18680),(28867356),(25763),(33100),(23991),(19115),(45054),(11367489),(35324),(31422),(21427),(18776204),(30565),(4061211),(43065),(31625),(47781),(9484915),(39297),(1992182),(1986015),(1991492),(1984997),(39007),(35382),(31843325),(31474),(1989306),(12279128),(1146711),(51357),(36160),(43433),(37746),(31543),(35655),(49497910),(42581),(34270),(9313566),(50011),(1987095),(28828),(23920),(25723022),(32750792),(47131),(42114),(1984665),(53474),(30764208),(1992261),(18042),(28587),(1989012),(1991623),(24375268),(42785),(1986433),(2059361),(54118),(4063051),(11185192),(19054),(1985351),(2064168),(1995175),(2058868),(4608272) Parameters: [] View formatted query View runnable query Explain query create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine = memory; insert into `steiermark`.accoIdsTowns (id) values (1986795), (23435), (55167), (38423), (46316), (54339), (52545), (44050), (45797), (49790), (25942), (30756), (28876), (18813), (25423486), (2060888), (49276), (1986681), (20203610), (48365), (41793), (34013), (33519), (30773134), (25522), (14659516), (28470795), (43125), (50325), (1984508), (42911), (46206), (1988139), (15843263), (30101), (2060516), (17676), (4061338), (7351637), (35070), (20023418), (35206874), (53159), (1986865), (7738640), (1992394), (5367477), (27685), (44172), (46874), (45122), (31203), (44339), (1991966), (49387), (17823), (38060), (1993645), (1833139), (55324), (53239), (38807), (55395), (1986627), (42841), (36492), (9529160), (46636), (50850), (10664738), (19852), (52190), (32689), (45252), (29547), (41198698), (1994374), (46578), (48017), (39558266), (55242), (36935), (5949155), (30731557), (32298578), (51151), (2064618), (11364731), (1146742), (19158), (41649), (53593), (47487), (37175), (38904), (11436541), (43837572), (2064720), (7738339), (35666833), (48905589), (41366), (21368), (43641), (9283115), (1984959), (1990285), (36531210), (44587191), (54695), (11365272), (24448), (18290), (1985415), (39231), (47606), (39454), (44831), (46733), (41239), (10114007), (24242), (47921), (21859), (40768), (18165472), (16110362), (24781077), (43702020), (1995257), (21659), (59655), (39377), (18328480), (27868), (1988874), (31117139), (367300), (41879), (23077), (30980), (41615), (33905), (36531205), (48570), (2684053), (42753168), (25025), (46250), (45143324), (31340), (40646), (17418), (1988816), (34358), (1984760), (12910566), (2059839), (25273), (20707), (1985660), (1993946), (17904), (26570), (53347), (41160), (12910729), (38373), (53743), (27419533), (44781642), (42350), (38480), (33451), (2059991), (24793), (48496), (28091523), (1995103), (1985522), (26337), (4149206), (46152494), (32010), (1985174), (1994889), (2065944), (8537205), (32305843), (38616), (43184382), (39575), (42655), (1984904), (20840), (20291), (50189), (2063745), (28657), (27471), (34983), (1988207), (1433530), (54798), (28124), (37365), (17593634), (40473), (24971), (1989566), (34831), (2063458), (39083), (43526), (4061122), (26431), (44387), (1986716), (35330412), (23620), (43804), (31772), (20577), (1987706), (36664), (26721), (12879304), (1988937), (44660), (45582), (1988385), (36617), (43414), (46450), (1993711), (40556), (54523), (25766745), (1986946), (19857), (48890), (50086), (47398), (46968), (39687), (1994545), (45319), (37217), (35666828), (44781629), (1987463), (42428), (53948), (26851), (49502), (49548934), (1985474), (47247), (18746), (43758), (35666823), (22475), (20108), (1994732), (15498539), (4525614), (33768), (44222), (2064808), (23500), (52476), (1993242), (9455693), (1993811), (45375), (1993878), (17126), (2065496), (4061187), (28278), (30482936), (50194), (1990539), (18432), (39998), (32353), (6645142), (27631), (51034), (43155), (40425), (2061355), (37942), (45198113), (36327), (54166), (51833), (8142109), (2059260), (14913865), (19475), (35206879), (28867350), (22213550), (2062684), (15375608), (18462), (4761749), (1990954), (52801), (1993209), (2062410), (17811174), (18680), (28867356), (25763), (33100), (23991), (19115), (45054), (11367489), (35324), (31422), (21427), (18776204), (30565), (4061211), (43065), (31625), (47781), (9484915), (39297), (1992182), (1986015), (1991492), (1984997), (39007), (35382), (31843325), (31474), (1989306), (12279128), (1146711), (51357), (36160), (43433), (37746), (31543), (35655), (49497910), (42581), (34270), (9313566), (50011), (1987095), (28828), (23920), (25723022), (32750792), (47131), (42114), (1984665), (53474), (30764208), (1992261), (18042), (28587), (1989012), (1991623), (24375268), (42785), (1986433), (2059361), (54118), (4063051), (11185192), (19054), (1985351), (2064168), (1995175), (2058868), (4608272) create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (1986795),(23435),(55167),(38423),(46316),(54339),(52545),(44050),(45797),(49790),(25942),(30756),(28876),(18813),(25423486),(2060888),(49276),(1986681),(20203610),(48365),(41793),(34013),(33519),(30773134),(25522),(14659516),(28470795),(43125),(50325),(1984508),(42911),(46206),(1988139),(15843263),(30101),(2060516),(17676),(4061338),(7351637),(35070),(20023418),(35206874),(53159),(1986865),(7738640),(1992394),(5367477),(27685),(44172),(46874),(45122),(31203),(44339),(1991966),(49387),(17823),(38060),(1993645),(1833139),(55324),(53239),(38807),(55395),(1986627),(42841),(36492),(9529160),(46636),(50850),(10664738),(19852),(52190),(32689),(45252),(29547),(41198698),(1994374),(46578),(48017),(39558266),(55242),(36935),(5949155),(30731557),(32298578),(51151),(2064618),(11364731),(1146742),(19158),(41649),(53593),(47487),(37175),(38904),(11436541),(43837572),(2064720),(7738339),(35666833),(48905589),(41366),(21368),(43641),(9283115),(1984959),(1990285),(36531210),(44587191),(54695),(11365272),(24448),(18290),(1985415),(39231),(47606),(39454),(44831),(46733),(41239),(10114007),(24242),(47921),(21859),(40768),(18165472),(16110362),(24781077),(43702020),(1995257),(21659),(59655),(39377),(18328480),(27868),(1988874),(31117139),(367300),(41879),(23077),(30980),(41615),(33905),(36531205),(48570),(2684053),(42753168),(25025),(46250),(45143324),(31340),(40646),(17418),(1988816),(34358),(1984760),(12910566),(2059839),(25273),(20707),(1985660),(1993946),(17904),(26570),(53347),(41160),(12910729),(38373),(53743),(27419533),(44781642),(42350),(38480),(33451),(2059991),(24793),(48496),(28091523),(1995103),(1985522),(26337),(4149206),(46152494),(32010),(1985174),(1994889),(2065944),(8537205),(32305843),(38616),(43184382),(39575),(42655),(1984904),(20840),(20291),(50189),(2063745),(28657),(27471),(34983),(1988207),(1433530),(54798),(28124),(37365),(17593634),(40473),(24971),(1989566),(34831),(2063458),(39083),(43526),(4061122),(26431),(44387),(1986716),(35330412),(23620),(43804),(31772),(20577),(1987706),(36664),(26721),(12879304),(1988937),(44660),(45582),(1988385),(36617),(43414),(46450),(1993711),(40556),(54523),(25766745),(1986946),(19857),(48890),(50086),(47398),(46968),(39687),(1994545),(45319),(37217),(35666828),(44781629),(1987463),(42428),(53948),(26851),(49502),(49548934),(1985474),(47247),(18746),(43758),(35666823),(22475),(20108),(1994732),(15498539),(4525614),(33768),(44222),(2064808),(23500),(52476),(1993242),(9455693),(1993811),(45375),(1993878),(17126),(2065496),(4061187),(28278),(30482936),(50194),(1990539),(18432),(39998),(32353),(6645142),(27631),(51034),(43155),(40425),(2061355),(37942),(45198113),(36327),(54166),(51833),(8142109),(2059260),(14913865),(19475),(35206879),(28867350),(22213550),(2062684),(15375608),(18462),(4761749),(1990954),(52801),(1993209),(2062410),(17811174),(18680),(28867356),(25763),(33100),(23991),(19115),(45054),(11367489),(35324),(31422),(21427),(18776204),(30565),(4061211),(43065),(31625),(47781),(9484915),(39297),(1992182),(1986015),(1991492),(1984997),(39007),(35382),(31843325),(31474),(1989306),(12279128),(1146711),(51357),(36160),(43433),(37746),(31543),(35655),(49497910),(42581),(34270),(9313566),(50011),(1987095),(28828),(23920),(25723022),(32750792),(47131),(42114),(1984665),(53474),(30764208),(1992261),(18042),(28587),(1989012),(1991623),(24375268),(42785),(1986433),(2059361),(54118),(4063051),(11185192),(19054),(1985351),(2064168),(1995175),(2058868),(4608272);
17	3.57 ms	SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (9804, 9782, 9610, 9669, 9616, 9707, 9628, 9665, 9694, 9670, 9698) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id Parameters: [] View formatted query View runnable query Explain query SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN ( 9804, 9782, 9610, 9669, 9616, 9707, 9628, 9665, 9694, 9670, 9698 ) AND src_id IN ( select id from `steiermark`.accoIdsTowns ) group by dest_id SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (9804, 9782, 9610, 9669, 9616, 9707, 9628, 9665, 9694, 9670, 9698) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id ;
18	0.06 ms	DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns; Parameters: [] View formatted query View runnable query Explain query DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns; DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;;
19	8.45 ms	SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (31474,18290,1986509,26626,30101,29754,30724471,19158,46529,2064618,20291,54523,17030,40768,1989224,55324,35341,4063160,35206874,52190,11365272,28278,2065098,18776204,40473,1993878,27740,46968,24971,47247,21622,1987680,21489,1989189,41879,46933,1994480,46284,19054,1986681,52801,39007,54118,2059447,48496,41546,25763,46874,2066111,52545,2058512,4525614,50189,53293,4061122,28587,25667,26506,2064168,32550,2061355,47606,47710,1986219,39297,2062596,2058626,20643,35324,51357,46733,36492,53474,4761749,8142109,44782,36299,22003,54660,2058868,1990242,40425,42551,2065425,32147,31543,27807120,36935,33905,32305843,30764208,1985114,19725,12910729,1993946,50011,1994761,35666823,1988269,4061187,26851,20810,35666833,33519,9455693,16110362,1990091,55395,46636,53159,52068,34270,30756,30731557,2065944,2062885,2063926,2059767,51034,1433530,47131,28470795,25522,35330412,22953,37827,1993209,27298,6645142,28657,37942,52516,17418,10114007,28980,46316,1990469,30482936,1987585,21363,1984760,20577,43155,35382,27294,27685,43125,2684053,46578,1986476,46206,41793,50194,8537205,47196,42237,53418,28876,44831,35989,38373,1993645,1985962,2060384,2059260,17227,51974,1988347,24793,4063051,29585,2063196,27471,43837572,47981,1991966,1343842,15843263,45923,1991623,51301,1986627,2059361,38549,11367489,43472,35994,36664,7738640,42911,44050,24523,11436541,17904,1987339,2060738,1984997,37308,1833139,2060516,33100,43065,43526,55242,1993438,38423,1987095,18680,2065496,16854,1987221,31422,9313566,7738339,1990911,27520,1990954,49910,1993811,46250,1987463,7351637,55010,1989566,24448,1989012,37859,2064954,18560,27631,1989882,1992224,18152,24118,39687,59655,39377,1987293,1985246,1987973,1994800,40704,43433,10664738,20023418,30773134,50963,45797,31843325,47781,18042,30400,1995175,48017,39922,1986758,19754,5367353,11364731,2062975,2060465,30565,24985,9283115,2066133,18272,20782,24580,1989465,21585,42977,27868,36160,1995103,43384,1994732,5367477,18891,26570,43686,1988874,20840,54339,23991,4608272,41198698,32689,54763,2058557,49158,21821,2059571,35206879,30980,53913,38807,2059088,35070,18943,1989419,17770,34983,1988207,18328480,19286,29109,24242,2063091,2062684,38904,2059839,41366,1990504,45122,43641,2063458,25101,28091523,21427,35238,18746,41494,17593634,50760,44587191,1988816,32750792,48570,19208,43804,21284,49387,1985474,31336,36100,36531210,37217,4061338,42350,43184382,42753168,55108,43414,22775,1991492,25366,31203,17823,27825,1985174,45582,35740,53010,4580754,20108,54695,1989075,1994502,1994374,19587,5949155,48928,1987706,1991534,1986795,21942,1993242,32582,34887538,50850,32076506,367300,19812,1989698,12879307,39454,23720,1985415,18813,33077,44387,1994096,21859,2060888,1986015,3263472,54166,36227,19244,28867353,52727,49497910,29836686,42655,18432,45082,27419533,1990037,19029556,21239,17676,32478,23077,19475,48365,38616,32802,14913865,1992394,49189,367148,1992182,32658,23055,15498539,25942,34358,23920,1986946,4063277,54798,45252,39558266,25414206,47398,1995257,1989832,1987149,52476,1989306,50718,17811174,49502,41239,31625,17541,28124,36531205,25766745,1987270,50086,46152494,27384,26890,23435,1988731,2062410,35456,1994545,31117139,3263475,12879304,42841,43594,25156,29619,19558,4061087,1994693,44222,31772,53347,27082,4061211,1986433,42785,18230,1988766,17626,39231,1991413,1985660,21543,35666828,51833,25423486,36066,18375,34180,1993711,37484,1989517,50135,34716,11185192,34831,44339,24173653,36095,36327,47487,1986865,19852,1988937,41710,54374,28508,1989124,1994822,2853535,31755375,45319,16889,23500,21327,9484915,44781642,1988139,51151,19612,45143324,52662,28828,25806,23620,1984665,49229,47921,35566,43758,1990830,1988015,44660,22916,52769,29907,28923,37175,48905589,47830,24781077,1984904,1984959,45503,39083,17354,42581,48890,41615,1992841,45375,1146742,40556,24375268,35697,1985351,15375608,39198,16922,20203610,25766748,33331,29764,34013,35655,39575,16975,12910566,41649,19115,53817,21368,18520,17126,26721,53593,2064513,38480,22047,1986716,1987442,55167,20885,1986581,54243,1990539,18015,1985522,7951197,2063414,39998,20668,1989922,1990285,48716,49790,4149206,25724,45054,21179,27568,37746,33768,2066268,1989734,31967,53743,1984508,33401,1987314,31291,22441,42114,1988385,9529160,20989,33031,53783,38583,53948,26337,1993788,21032,53239,22475,44172,1990181,25273,21659,2064808,37365,1146711,46450,50325,12279128,1994889,20188,2063745,18462,32298578,41160,1989268,42428,6945367,52980,14659516,2059991,25025,30852,1992261,29547,41842,33898,19857,32806,33451,40646,1990403,32010,49548934,53131,49276,29671,2064720,36617,1986914,38060,17068,31340,35829,54464,30448600,43702020,25723022,29829,18165472,48905586,4791432,20707,50584316,30843,41198724,49046532,28492,17115,14049003,30354,42753173,30359,48663392,367391,34969921,29903,367184,44781629,22213550,45756971,48675,45548175,4061075,31259,28867356,48625745,50593655,26431,2193918,48050342,29658071,46201539,48625751,47257351,32751,41935,48863,31960,17120,16421480,29614,27820,31953,36655,13440568,47463,17670,36716325,30751,48663426,35736,45756981,46597852,48663405,49548929,33992180,26717,47888734,32353,17001,367295,367388,29658091,29104,41198692,33178,12948653,47614112,1993620,29658076,36427,48625748,45756976,45198113,2853499,28920,22612,12879310,32108,28867350,27056,26578533,50692778,29658086,25500,46992771,4061295) AND dacco.o_published = 1 AND (dacco.town__id IN (6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947)) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) Parameters: [] View formatted query View runnable query Explain query SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN ( 31474, 18290, 1986509, 26626, 30101, 29754, 30724471, 19158, 46529, 2064618, 20291, 54523, 17030, 40768, 1989224, 55324, 35341, 4063160, 35206874, 52190, 11365272, 28278, 2065098, 18776204, 40473, 1993878, 27740, 46968, 24971, 47247, 21622, 1987680, 21489, 1989189, 41879, 46933, 1994480, 46284, 19054, 1986681, 52801, 39007, 54118, 2059447, 48496, 41546, 25763, 46874, 2066111, 52545, 2058512, 4525614, 50189, 53293, 4061122, 28587, 25667, 26506, 2064168, 32550, 2061355, 47606, 47710, 1986219, 39297, 2062596, 2058626, 20643, 35324, 51357, 46733, 36492, 53474, 4761749, 8142109, 44782, 36299, 22003, 54660, 2058868, 1990242, 40425, 42551, 2065425, 32147, 31543, 27807120, 36935, 33905, 32305843, 30764208, 1985114, 19725, 12910729, 1993946, 50011, 1994761, 35666823, 1988269, 4061187, 26851, 20810, 35666833, 33519, 9455693, 16110362, 1990091, 55395, 46636, 53159, 52068, 34270, 30756, 30731557, 2065944, 2062885, 2063926, 2059767, 51034, 1433530, 47131, 28470795, 25522, 35330412, 22953, 37827, 1993209, 27298, 6645142, 28657, 37942, 52516, 17418, 10114007, 28980, 46316, 1990469, 30482936, 1987585, 21363, 1984760, 20577, 43155, 35382, 27294, 27685, 43125, 2684053, 46578, 1986476, 46206, 41793, 50194, 8537205, 47196, 42237, 53418, 28876, 44831, 35989, 38373, 1993645, 1985962, 2060384, 2059260, 17227, 51974, 1988347, 24793, 4063051, 29585, 2063196, 27471, 43837572, 47981, 1991966, 1343842, 15843263, 45923, 1991623, 51301, 1986627, 2059361, 38549, 11367489, 43472, 35994, 36664, 7738640, 42911, 44050, 24523, 11436541, 17904, 1987339, 2060738, 1984997, 37308, 1833139, 2060516, 33100, 43065, 43526, 55242, 1993438, 38423, 1987095, 18680, 2065496, 16854, 1987221, 31422, 9313566, 7738339, 1990911, 27520, 1990954, 49910, 1993811, 46250, 1987463, 7351637, 55010, 1989566, 24448, 1989012, 37859, 2064954, 18560, 27631, 1989882, 1992224, 18152, 24118, 39687, 59655, 39377, 1987293, 1985246, 1987973, 1994800, 40704, 43433, 10664738, 20023418, 30773134, 50963, 45797, 31843325, 47781, 18042, 30400, 1995175, 48017, 39922, 1986758, 19754, 5367353, 11364731, 2062975, 2060465, 30565, 24985, 9283115, 2066133, 18272, 20782, 24580, 1989465, 21585, 42977, 27868, 36160, 1995103, 43384, 1994732, 5367477, 18891, 26570, 43686, 1988874, 20840, 54339, 23991, 4608272, 41198698, 32689, 54763, 2058557, 49158, 21821, 2059571, 35206879, 30980, 53913, 38807, 2059088, 35070, 18943, 1989419, 17770, 34983, 1988207, 18328480, 19286, 29109, 24242, 2063091, 2062684, 38904, 2059839, 41366, 1990504, 45122, 43641, 2063458, 25101, 28091523, 21427, 35238, 18746, 41494, 17593634, 50760, 44587191, 1988816, 32750792, 48570, 19208, 43804, 21284, 49387, 1985474, 31336, 36100, 36531210, 37217, 4061338, 42350, 43184382, 42753168, 55108, 43414, 22775, 1991492, 25366, 31203, 17823, 27825, 1985174, 45582, 35740, 53010, 4580754, 20108, 54695, 1989075, 1994502, 1994374, 19587, 5949155, 48928, 1987706, 1991534, 1986795, 21942, 1993242, 32582, 34887538, 50850, 32076506, 367300, 19812, 1989698, 12879307, 39454, 23720, 1985415, 18813, 33077, 44387, 1994096, 21859, 2060888, 1986015, 3263472, 54166, 36227, 19244, 28867353, 52727, 49497910, 29836686, 42655, 18432, 45082, 27419533, 1990037, 19029556, 21239, 17676, 32478, 23077, 19475, 48365, 38616, 32802, 14913865, 1992394, 49189, 367148, 1992182, 32658, 23055, 15498539, 25942, 34358, 23920, 1986946, 4063277, 54798, 45252, 39558266, 25414206, 47398, 1995257, 1989832, 1987149, 52476, 1989306, 50718, 17811174, 49502, 41239, 31625, 17541, 28124, 36531205, 25766745, 1987270, 50086, 46152494, 27384, 26890, 23435, 1988731, 2062410, 35456, 1994545, 31117139, 3263475, 12879304, 42841, 43594, 25156, 29619, 19558, 4061087, 1994693, 44222, 31772, 53347, 27082, 4061211, 1986433, 42785, 18230, 1988766, 17626, 39231, 1991413, 1985660, 21543, 35666828, 51833, 25423486, 36066, 18375, 34180, 1993711, 37484, 1989517, 50135, 34716, 11185192, 34831, 44339, 24173653, 36095, 36327, 47487, 1986865, 19852, 1988937, 41710, 54374, 28508, 1989124, 1994822, 2853535, 31755375, 45319, 16889, 23500, 21327, 9484915, 44781642, 1988139, 51151, 19612, 45143324, 52662, 28828, 25806, 23620, 1984665, 49229, 47921, 35566, 43758, 1990830, 1988015, 44660, 22916, 52769, 29907, 28923, 37175, 48905589, 47830, 24781077, 1984904, 1984959, 45503, 39083, 17354, 42581, 48890, 41615, 1992841, 45375, 1146742, 40556, 24375268, 35697, 1985351, 15375608, 39198, 16922, 20203610, 25766748, 33331, 29764, 34013, 35655, 39575, 16975, 12910566, 41649, 19115, 53817, 21368, 18520, 17126, 26721, 53593, 2064513, 38480, 22047, 1986716, 1987442, 55167, 20885, 1986581, 54243, 1990539, 18015, 1985522, 7951197, 2063414, 39998, 20668, 1989922, 1990285, 48716, 49790, 4149206, 25724, 45054, 21179, 27568, 37746, 33768, 2066268, 1989734, 31967, 53743, 1984508, 33401, 1987314, 31291, 22441, 42114, 1988385, 9529160, 20989, 33031, 53783, 38583, 53948, 26337, 1993788, 21032, 53239, 22475, 44172, 1990181, 25273, 21659, 2064808, 37365, 1146711, 46450, 50325, 12279128, 1994889, 20188, 2063745, 18462, 32298578, 41160, 1989268, 42428, 6945367, 52980, 14659516, 2059991, 25025, 30852, 1992261, 29547, 41842, 33898, 19857, 32806, 33451, 40646, 1990403, 32010, 49548934, 53131, 49276, 29671, 2064720, 36617, 1986914, 38060, 17068, 31340, 35829, 54464, 30448600, 43702020, 25723022, 29829, 18165472, 48905586, 4791432, 20707, 50584316, 30843, 41198724, 49046532, 28492, 17115, 14049003, 30354, 42753173, 30359, 48663392, 367391, 34969921, 29903, 367184, 44781629, 22213550, 45756971, 48675, 45548175, 4061075, 31259, 28867356, 48625745, 50593655, 26431, 2193918, 48050342, 29658071, 46201539, 48625751, 47257351, 32751, 41935, 48863, 31960, 17120, 16421480, 29614, 27820, 31953, 36655, 13440568, 47463, 17670, 36716325, 30751, 48663426, 35736, 45756981, 46597852, 48663405, 49548929, 33992180, 26717, 47888734, 32353, 17001, 367295, 367388, 29658091, 29104, 41198692, 33178, 12948653, 47614112, 1993620, 29658076, 36427, 48625748, 45756976, 45198113, 2853499, 28920, 22612, 12879310, 32108, 28867350, 27056, 26578533, 50692778, 29658086, 25500, 46992771, 4061295 ) AND dacco.o_published = 1 AND ( dacco.town__id IN ( 6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947 ) ) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (31474,18290,1986509,26626,30101,29754,30724471,19158,46529,2064618,20291,54523,17030,40768,1989224,55324,35341,4063160,35206874,52190,11365272,28278,2065098,18776204,40473,1993878,27740,46968,24971,47247,21622,1987680,21489,1989189,41879,46933,1994480,46284,19054,1986681,52801,39007,54118,2059447,48496,41546,25763,46874,2066111,52545,2058512,4525614,50189,53293,4061122,28587,25667,26506,2064168,32550,2061355,47606,47710,1986219,39297,2062596,2058626,20643,35324,51357,46733,36492,53474,4761749,8142109,44782,36299,22003,54660,2058868,1990242,40425,42551,2065425,32147,31543,27807120,36935,33905,32305843,30764208,1985114,19725,12910729,1993946,50011,1994761,35666823,1988269,4061187,26851,20810,35666833,33519,9455693,16110362,1990091,55395,46636,53159,52068,34270,30756,30731557,2065944,2062885,2063926,2059767,51034,1433530,47131,28470795,25522,35330412,22953,37827,1993209,27298,6645142,28657,37942,52516,17418,10114007,28980,46316,1990469,30482936,1987585,21363,1984760,20577,43155,35382,27294,27685,43125,2684053,46578,1986476,46206,41793,50194,8537205,47196,42237,53418,28876,44831,35989,38373,1993645,1985962,2060384,2059260,17227,51974,1988347,24793,4063051,29585,2063196,27471,43837572,47981,1991966,1343842,15843263,45923,1991623,51301,1986627,2059361,38549,11367489,43472,35994,36664,7738640,42911,44050,24523,11436541,17904,1987339,2060738,1984997,37308,1833139,2060516,33100,43065,43526,55242,1993438,38423,1987095,18680,2065496,16854,1987221,31422,9313566,7738339,1990911,27520,1990954,49910,1993811,46250,1987463,7351637,55010,1989566,24448,1989012,37859,2064954,18560,27631,1989882,1992224,18152,24118,39687,59655,39377,1987293,1985246,1987973,1994800,40704,43433,10664738,20023418,30773134,50963,45797,31843325,47781,18042,30400,1995175,48017,39922,1986758,19754,5367353,11364731,2062975,2060465,30565,24985,9283115,2066133,18272,20782,24580,1989465,21585,42977,27868,36160,1995103,43384,1994732,5367477,18891,26570,43686,1988874,20840,54339,23991,4608272,41198698,32689,54763,2058557,49158,21821,2059571,35206879,30980,53913,38807,2059088,35070,18943,1989419,17770,34983,1988207,18328480,19286,29109,24242,2063091,2062684,38904,2059839,41366,1990504,45122,43641,2063458,25101,28091523,21427,35238,18746,41494,17593634,50760,44587191,1988816,32750792,48570,19208,43804,21284,49387,1985474,31336,36100,36531210,37217,4061338,42350,43184382,42753168,55108,43414,22775,1991492,25366,31203,17823,27825,1985174,45582,35740,53010,4580754,20108,54695,1989075,1994502,1994374,19587,5949155,48928,1987706,1991534,1986795,21942,1993242,32582,34887538,50850,32076506,367300,19812,1989698,12879307,39454,23720,1985415,18813,33077,44387,1994096,21859,2060888,1986015,3263472,54166,36227,19244,28867353,52727,49497910,29836686,42655,18432,45082,27419533,1990037,19029556,21239,17676,32478,23077,19475,48365,38616,32802,14913865,1992394,49189,367148,1992182,32658,23055,15498539,25942,34358,23920,1986946,4063277,54798,45252,39558266,25414206,47398,1995257,1989832,1987149,52476,1989306,50718,17811174,49502,41239,31625,17541,28124,36531205,25766745,1987270,50086,46152494,27384,26890,23435,1988731,2062410,35456,1994545,31117139,3263475,12879304,42841,43594,25156,29619,19558,4061087,1994693,44222,31772,53347,27082,4061211,1986433,42785,18230,1988766,17626,39231,1991413,1985660,21543,35666828,51833,25423486,36066,18375,34180,1993711,37484,1989517,50135,34716,11185192,34831,44339,24173653,36095,36327,47487,1986865,19852,1988937,41710,54374,28508,1989124,1994822,2853535,31755375,45319,16889,23500,21327,9484915,44781642,1988139,51151,19612,45143324,52662,28828,25806,23620,1984665,49229,47921,35566,43758,1990830,1988015,44660,22916,52769,29907,28923,37175,48905589,47830,24781077,1984904,1984959,45503,39083,17354,42581,48890,41615,1992841,45375,1146742,40556,24375268,35697,1985351,15375608,39198,16922,20203610,25766748,33331,29764,34013,35655,39575,16975,12910566,41649,19115,53817,21368,18520,17126,26721,53593,2064513,38480,22047,1986716,1987442,55167,20885,1986581,54243,1990539,18015,1985522,7951197,2063414,39998,20668,1989922,1990285,48716,49790,4149206,25724,45054,21179,27568,37746,33768,2066268,1989734,31967,53743,1984508,33401,1987314,31291,22441,42114,1988385,9529160,20989,33031,53783,38583,53948,26337,1993788,21032,53239,22475,44172,1990181,25273,21659,2064808,37365,1146711,46450,50325,12279128,1994889,20188,2063745,18462,32298578,41160,1989268,42428,6945367,52980,14659516,2059991,25025,30852,1992261,29547,41842,33898,19857,32806,33451,40646,1990403,32010,49548934,53131,49276,29671,2064720,36617,1986914,38060,17068,31340,35829,54464,30448600,43702020,25723022,29829,18165472,48905586,4791432,20707,50584316,30843,41198724,49046532,28492,17115,14049003,30354,42753173,30359,48663392,367391,34969921,29903,367184,44781629,22213550,45756971,48675,45548175,4061075,31259,28867356,48625745,50593655,26431,2193918,48050342,29658071,46201539,48625751,47257351,32751,41935,48863,31960,17120,16421480,29614,27820,31953,36655,13440568,47463,17670,36716325,30751,48663426,35736,45756981,46597852,48663405,49548929,33992180,26717,47888734,32353,17001,367295,367388,29658091,29104,41198692,33178,12948653,47614112,1993620,29658076,36427,48625748,45756976,45198113,2853499,28920,22612,12879310,32108,28867350,27056,26578533,50692778,29658086,25500,46992771,4061295) AND dacco.o_published = 1 AND (dacco.town__id IN (6944, 6971, 12312, 12321, 6973, 12320, 6953, 12309, 6955, 6957, 6963, 6948, 12304, 6969, 6945, 6966, 6951, 6968, 6949, 12305, 6958, 6959, 6970, 6974, 12324, 12342, 6946, 6956, 6964, 6954, 6967, 12319, 12333, 6965, 12323, 12316, 6961, 12318, 6972, 6962, 6960, 12329, 12311, 6947)) AND dacco.bookable = 1 GROUP BY dacco.oo_id ORDER BY RAND(474) ;
20	0.16 ms	create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (1986795),(23435),(55167),(38423),(46316),(54339),(52545),(44050),(45797),(49790),(25942),(30756),(28876),(18813),(25423486),(2060888),(49276),(1986681),(20203610),(48365),(41793),(34013),(33519),(30773134),(25522),(14659516),(28470795),(43125),(50325),(1984508),(42911),(46206),(1988139),(15843263),(30101),(2060516),(17676),(4061338),(7351637),(35070),(20023418),(35206874),(53159),(1986865),(7738640),(1992394),(5367477),(27685),(44172),(46874),(45122),(31203),(44339),(1991966),(49387),(17823),(38060),(1993645),(1833139),(55324),(53239),(38807),(55395),(1986627),(42841),(36492),(9529160),(46636),(50850),(10664738),(19852),(52190),(32689),(45252),(29547),(41198698),(1994374),(46578),(48017),(39558266),(55242),(36935),(5949155),(30731557),(32298578),(51151),(2064618),(11364731),(1146742),(19158),(41649),(53593),(47487),(37175),(38904),(11436541),(43837572),(2064720),(7738339),(35666833),(48905589),(41366),(21368),(43641),(9283115),(1984959),(1990285),(36531210),(44587191),(54695),(11365272),(24448),(18290),(1985415),(39231),(47606),(39454),(44831),(46733),(41239),(10114007),(24242),(47921),(21859),(40768),(18165472),(16110362),(24781077),(43702020),(1995257),(21659),(59655),(39377),(18328480),(27868),(1988874),(31117139),(367300),(41879),(23077),(30980),(41615),(33905),(36531205),(48570),(2684053),(42753168),(25025),(46250),(45143324),(31340),(40646),(17418),(1988816),(34358),(1984760),(12910566),(2059839),(25273),(20707),(1985660),(1993946),(17904),(26570),(53347),(41160),(12910729),(38373),(53743),(27419533),(44781642),(42350),(38480),(33451),(2059991),(24793),(48496),(28091523),(1995103),(1985522),(26337),(4149206),(46152494),(32010),(1985174),(1994889),(2065944),(8537205),(32305843),(38616),(43184382),(39575),(42655),(1984904),(20840),(20291),(50189),(2063745),(28657),(27471),(34983),(1988207),(1433530),(54798),(28124),(37365),(17593634),(40473),(24971),(1989566),(34831),(2063458),(39083),(43526),(4061122),(26431),(44387),(1986716),(35330412),(23620),(43804),(31772),(20577),(1987706),(36664),(26721),(12879304),(1988937),(44660),(45582),(1988385),(36617),(43414),(46450),(1993711),(40556),(54523),(25766745),(1986946),(19857),(48890),(50086),(47398),(46968),(39687),(1994545),(45319),(37217),(35666828),(44781629),(1987463),(42428),(53948),(26851),(49502),(49548934),(1985474),(47247),(18746),(43758),(35666823),(22475),(20108),(1994732),(15498539),(4525614),(33768),(44222),(2064808),(23500),(52476),(1993242),(9455693),(1993811),(45375),(1993878),(17126),(2065496),(4061187),(28278),(30482936),(50194),(1990539),(18432),(39998),(32353),(6645142),(27631),(51034),(43155),(40425),(2061355),(37942),(45198113),(36327),(54166),(51833),(8142109),(2059260),(14913865),(19475),(35206879),(28867350),(22213550),(2062684),(15375608),(18462),(4761749),(1990954),(52801),(1993209),(2062410),(17811174),(18680),(28867356),(25763),(33100),(23991),(19115),(45054),(11367489),(35324),(31422),(21427),(18776204),(30565),(4061211),(43065),(31625),(47781),(9484915),(39297),(1992182),(1986015),(1991492),(1984997),(39007),(35382),(31843325),(31474),(1989306),(12279128),(1146711),(51357),(36160),(43433),(37746),(31543),(35655),(49497910),(42581),(34270),(9313566),(50011),(1987095),(28828),(23920),(25723022),(32750792),(47131),(42114),(1984665),(53474),(30764208),(1992261),(18042),(28587),(1989012),(1991623),(24375268),(42785),(1986433),(2059361),(54118),(4063051),(11185192),(19054),(1985351),(2064168),(1995175),(2058868),(4608272) Parameters: [] View formatted query View runnable query Explain query create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine = memory; insert into `steiermark`.accoIdsTowns (id) values (1986795), (23435), (55167), (38423), (46316), (54339), (52545), (44050), (45797), (49790), (25942), (30756), (28876), (18813), (25423486), (2060888), (49276), (1986681), (20203610), (48365), (41793), (34013), (33519), (30773134), (25522), (14659516), (28470795), (43125), (50325), (1984508), (42911), (46206), (1988139), (15843263), (30101), (2060516), (17676), (4061338), (7351637), (35070), (20023418), (35206874), (53159), (1986865), (7738640), (1992394), (5367477), (27685), (44172), (46874), (45122), (31203), (44339), (1991966), (49387), (17823), (38060), (1993645), (1833139), (55324), (53239), (38807), (55395), (1986627), (42841), (36492), (9529160), (46636), (50850), (10664738), (19852), (52190), (32689), (45252), (29547), (41198698), (1994374), (46578), (48017), (39558266), (55242), (36935), (5949155), (30731557), (32298578), (51151), (2064618), (11364731), (1146742), (19158), (41649), (53593), (47487), (37175), (38904), (11436541), (43837572), (2064720), (7738339), (35666833), (48905589), (41366), (21368), (43641), (9283115), (1984959), (1990285), (36531210), (44587191), (54695), (11365272), (24448), (18290), (1985415), (39231), (47606), (39454), (44831), (46733), (41239), (10114007), (24242), (47921), (21859), (40768), (18165472), (16110362), (24781077), (43702020), (1995257), (21659), (59655), (39377), (18328480), (27868), (1988874), (31117139), (367300), (41879), (23077), (30980), (41615), (33905), (36531205), (48570), (2684053), (42753168), (25025), (46250), (45143324), (31340), (40646), (17418), (1988816), (34358), (1984760), (12910566), (2059839), (25273), (20707), (1985660), (1993946), (17904), (26570), (53347), (41160), (12910729), (38373), (53743), (27419533), (44781642), (42350), (38480), (33451), (2059991), (24793), (48496), (28091523), (1995103), (1985522), (26337), (4149206), (46152494), (32010), (1985174), (1994889), (2065944), (8537205), (32305843), (38616), (43184382), (39575), (42655), (1984904), (20840), (20291), (50189), (2063745), (28657), (27471), (34983), (1988207), (1433530), (54798), (28124), (37365), (17593634), (40473), (24971), (1989566), (34831), (2063458), (39083), (43526), (4061122), (26431), (44387), (1986716), (35330412), (23620), (43804), (31772), (20577), (1987706), (36664), (26721), (12879304), (1988937), (44660), (45582), (1988385), (36617), (43414), (46450), (1993711), (40556), (54523), (25766745), (1986946), (19857), (48890), (50086), (47398), (46968), (39687), (1994545), (45319), (37217), (35666828), (44781629), (1987463), (42428), (53948), (26851), (49502), (49548934), (1985474), (47247), (18746), (43758), (35666823), (22475), (20108), (1994732), (15498539), (4525614), (33768), (44222), (2064808), (23500), (52476), (1993242), (9455693), (1993811), (45375), (1993878), (17126), (2065496), (4061187), (28278), (30482936), (50194), (1990539), (18432), (39998), (32353), (6645142), (27631), (51034), (43155), (40425), (2061355), (37942), (45198113), (36327), (54166), (51833), (8142109), (2059260), (14913865), (19475), (35206879), (28867350), (22213550), (2062684), (15375608), (18462), (4761749), (1990954), (52801), (1993209), (2062410), (17811174), (18680), (28867356), (25763), (33100), (23991), (19115), (45054), (11367489), (35324), (31422), (21427), (18776204), (30565), (4061211), (43065), (31625), (47781), (9484915), (39297), (1992182), (1986015), (1991492), (1984997), (39007), (35382), (31843325), (31474), (1989306), (12279128), (1146711), (51357), (36160), (43433), (37746), (31543), (35655), (49497910), (42581), (34270), (9313566), (50011), (1987095), (28828), (23920), (25723022), (32750792), (47131), (42114), (1984665), (53474), (30764208), (1992261), (18042), (28587), (1989012), (1991623), (24375268), (42785), (1986433), (2059361), (54118), (4063051), (11185192), (19054), (1985351), (2064168), (1995175), (2058868), (4608272) create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (1986795),(23435),(55167),(38423),(46316),(54339),(52545),(44050),(45797),(49790),(25942),(30756),(28876),(18813),(25423486),(2060888),(49276),(1986681),(20203610),(48365),(41793),(34013),(33519),(30773134),(25522),(14659516),(28470795),(43125),(50325),(1984508),(42911),(46206),(1988139),(15843263),(30101),(2060516),(17676),(4061338),(7351637),(35070),(20023418),(35206874),(53159),(1986865),(7738640),(1992394),(5367477),(27685),(44172),(46874),(45122),(31203),(44339),(1991966),(49387),(17823),(38060),(1993645),(1833139),(55324),(53239),(38807),(55395),(1986627),(42841),(36492),(9529160),(46636),(50850),(10664738),(19852),(52190),(32689),(45252),(29547),(41198698),(1994374),(46578),(48017),(39558266),(55242),(36935),(5949155),(30731557),(32298578),(51151),(2064618),(11364731),(1146742),(19158),(41649),(53593),(47487),(37175),(38904),(11436541),(43837572),(2064720),(7738339),(35666833),(48905589),(41366),(21368),(43641),(9283115),(1984959),(1990285),(36531210),(44587191),(54695),(11365272),(24448),(18290),(1985415),(39231),(47606),(39454),(44831),(46733),(41239),(10114007),(24242),(47921),(21859),(40768),(18165472),(16110362),(24781077),(43702020),(1995257),(21659),(59655),(39377),(18328480),(27868),(1988874),(31117139),(367300),(41879),(23077),(30980),(41615),(33905),(36531205),(48570),(2684053),(42753168),(25025),(46250),(45143324),(31340),(40646),(17418),(1988816),(34358),(1984760),(12910566),(2059839),(25273),(20707),(1985660),(1993946),(17904),(26570),(53347),(41160),(12910729),(38373),(53743),(27419533),(44781642),(42350),(38480),(33451),(2059991),(24793),(48496),(28091523),(1995103),(1985522),(26337),(4149206),(46152494),(32010),(1985174),(1994889),(2065944),(8537205),(32305843),(38616),(43184382),(39575),(42655),(1984904),(20840),(20291),(50189),(2063745),(28657),(27471),(34983),(1988207),(1433530),(54798),(28124),(37365),(17593634),(40473),(24971),(1989566),(34831),(2063458),(39083),(43526),(4061122),(26431),(44387),(1986716),(35330412),(23620),(43804),(31772),(20577),(1987706),(36664),(26721),(12879304),(1988937),(44660),(45582),(1988385),(36617),(43414),(46450),(1993711),(40556),(54523),(25766745),(1986946),(19857),(48890),(50086),(47398),(46968),(39687),(1994545),(45319),(37217),(35666828),(44781629),(1987463),(42428),(53948),(26851),(49502),(49548934),(1985474),(47247),(18746),(43758),(35666823),(22475),(20108),(1994732),(15498539),(4525614),(33768),(44222),(2064808),(23500),(52476),(1993242),(9455693),(1993811),(45375),(1993878),(17126),(2065496),(4061187),(28278),(30482936),(50194),(1990539),(18432),(39998),(32353),(6645142),(27631),(51034),(43155),(40425),(2061355),(37942),(45198113),(36327),(54166),(51833),(8142109),(2059260),(14913865),(19475),(35206879),(28867350),(22213550),(2062684),(15375608),(18462),(4761749),(1990954),(52801),(1993209),(2062410),(17811174),(18680),(28867356),(25763),(33100),(23991),(19115),(45054),(11367489),(35324),(31422),(21427),(18776204),(30565),(4061211),(43065),(31625),(47781),(9484915),(39297),(1992182),(1986015),(1991492),(1984997),(39007),(35382),(31843325),(31474),(1989306),(12279128),(1146711),(51357),(36160),(43433),(37746),(31543),(35655),(49497910),(42581),(34270),(9313566),(50011),(1987095),(28828),(23920),(25723022),(32750792),(47131),(42114),(1984665),(53474),(30764208),(1992261),(18042),(28587),(1989012),(1991623),(24375268),(42785),(1986433),(2059361),(54118),(4063051),(11185192),(19054),(1985351),(2064168),(1995175),(2058868),(4608272);
21	17.33 ms	SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (7999, 8006, 7556, 7732, 7500, 7483, 7330, 7303, 7319, 7299, 7313) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id Parameters: [] View formatted query View runnable query Explain query SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN ( 7999, 8006, 7556, 7732, 7500, 7483, 7330, 7303, 7319, 7299, 7313 ) AND src_id IN ( select id from `steiermark`.accoIdsTowns ) group by dest_id SELECT dest_id, count(src_id) as accoCount FROM `steiermark`.object_relations_8 daccorel WHERE dest_id IN (7999, 8006, 7556, 7732, 7500, 7483, 7330, 7303, 7319, 7299, 7313) AND src_id IN (select id from `steiermark`.accoIdsTowns) group by dest_id ;
22	0.07 ms	DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns; Parameters: [] View formatted query View runnable query Explain query DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns; DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;;

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.

Symfony Profiler

https://stage.steiermark.com/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles?_=1731456000000&nearbySearchId=47581501&nearbySearchLat=47.52833&nearbySearchLong=15.41605&randSeed=474

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

demi_vacancies connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

portal_engine entity manager

pimcore_direct_edit entity manager

statistics_explorer entity manager