Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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?_=1731196800021&nearbySearchId=853869&nearbySearchLat=47.42607&nearbySearchLong=15.78616&randSeed=372

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