Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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?_=1733119695600&nearbySearchId=2918456&nearbySearchLat=46.77808&nearbySearchLong=15.51091&randSeed=436

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