Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

170.83 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

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

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?_=1733310535291&nearbySearchId=1430481&nearbySearchLat=47.06381&nearbySearchLong=15.06293&randSeed=487

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