Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

162.41 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

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

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