Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

166.73 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.46 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.11 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.24 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.40 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.11 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.12 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.58 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=788&nearbySearchId=30366158&nearbySearchLat=46.85754&nearbySearchLong=15.53586&_=1738941199199" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1738941199199&nearbySearchId=30366158&nearbySearchLat=46.85754&nearbySearchLong=15.53586&randSeed=788" "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=788&nearbySearchId=30366158&nearbySearchLat=46.85754&nearbySearchLong=15.53586&_=1738941199199' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1738941199199&nearbySearchId=30366158&nearbySearchLat=46.85754&nearbySearchLong=15.53586&randSeed=788' 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.24 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.34 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.15 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.21 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.13 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.19 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.41 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.32 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.34 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.13 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.22 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.27 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.32 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.31 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.32 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.45 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.20 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.82 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

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?_=1738941199199&nearbySearchId=30366158&nearbySearchLat=46.85754&nearbySearchLong=15.53586&randSeed=788

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