Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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?_=1731693544151&nearbySearchId=46257265&nearbySearchLat=46.89751&nearbySearchLong=15.46669&randSeed=732

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