Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

158.46 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


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

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

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?_=1737254007265&nearbySearchId=853538&nearbySearchLat=46.94388&nearbySearchLong=15.08005&randSeed=967

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