Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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?_=1737897367177&nearbySearchId=46257266&nearbySearchLat=46.89757&nearbySearchLong=15.46674&randSeed=884

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