Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

148.29 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.35 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.09 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.31 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.37 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"mainBlogPortal" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.10 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BlogPortal"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BlogPortal';
7	0.55 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=880&nearbySearchId=4545362&nearbySearchLat=46.78234&nearbySearchLong=15.45336&_=1738954029960" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1738954029960&nearbySearchId=4545362&nearbySearchLat=46.78234&nearbySearchLong=15.45336&randSeed=880" "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=880&nearbySearchId=4545362&nearbySearchLat=46.78234&nearbySearchLong=15.45336&_=1738954029960' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1738954029960&nearbySearchId=4545362&nearbySearchLat=46.78234&nearbySearchLong=15.45336&randSeed=880' 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.17 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.24 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.14 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.19 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/en/Suedsteiermark/Holiday/book-accommodation/bubbles"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en/Suedsteiermark/Holiday/book-accommodation/bubbles';
12	0.11 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "book-accommodation" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/' AND `key` = BINARY 'book-accommodation';
13	0.16 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.31 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.24 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.28 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.14 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.13 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.21 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.22 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.26 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.26 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.32 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.12 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.59 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1738954029960&nearbySearchId=4545362&nearbySearchLat=46.78234&nearbySearchLong=15.45336&randSeed=880

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