Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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?_=1733327883251&nearbySearchId=853795&nearbySearchLat=46.97788&nearbySearchLong=14.98449&randSeed=235

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