Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

146.42 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.32 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.07 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.07 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.20 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.06 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.05 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.43 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=774&nearbySearchId=1430481&nearbySearchLat=47.06381&nearbySearchLong=15.06293&_=1731664948215" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1731664948215&nearbySearchId=1430481&nearbySearchLat=47.06381&nearbySearchLong=15.06293&randSeed=774" "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=774&nearbySearchId=1430481&nearbySearchLat=47.06381&nearbySearchLong=15.06293&_=1731664948215' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1731664948215&nearbySearchId=1430481&nearbySearchLat=47.06381&nearbySearchLong=15.06293&randSeed=774' 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.10 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.08 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.07 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.11 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.07 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.10 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.20 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.07 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.23 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.10 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.07 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.12 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.06 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"18"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '18';
21	0.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"51"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '51';
22	0.06 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.29 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.07 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.46 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

Database Connections

Name	Service
default	doctrine.dbal.default_connection
demi_vacancies	doctrine.dbal.demi_vacancies_connection

Entity Managers

Name	Service
portal_engine	doctrine.orm.portal_engine_entity_manager
pimcore_direct_edit	doctrine.orm.pimcore_direct_edit_entity_manager
statistics_explorer	doctrine.orm.statistics_explorer_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1731664948215&nearbySearchId=1430481&nearbySearchLat=47.06381&nearbySearchLong=15.06293&randSeed=774

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