Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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