Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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?_=1733049250997&nearbySearchId=324349&nearbySearchLat=46.97788&nearbySearchLong=14.98452&randSeed=966

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