Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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