Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

Database Connections

Name	Service
default	doctrine.dbal.default_connection
demi_vacancies	doctrine.dbal.demi_vacancies_connection

Entity Managers

Name	Service
portal_engine	doctrine.orm.portal_engine_entity_manager
pimcore_direct_edit	doctrine.orm.pimcore_direct_edit_entity_manager
statistics_explorer	doctrine.orm.statistics_explorer_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1732944636134&nearbySearchId=46460123&nearbySearchLat=46.89684&nearbySearchLong=15.26355&randSeed=68

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