Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

161.36 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.38 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.23 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SiteConfig"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SiteConfig';
4	0.29 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"mainBlogPortal" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.10 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.10 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.59 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=382&nearbySearchId=1580303&nearbySearchLat=47.0618&nearbySearchLong=15.0821&_=1732689208128" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1732689208128&nearbySearchId=1580303&nearbySearchLat=47.0618&nearbySearchLong=15.0821&randSeed=382" "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=382&nearbySearchId=1580303&nearbySearchLat=47.0618&nearbySearchLong=15.0821&_=1732689208128' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1732689208128&nearbySearchId=1580303&nearbySearchLat=47.0618&nearbySearchLong=15.0821&randSeed=382' 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.14 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.25 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "bubbles" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/' AND `key` = BINARY 'bubbles';
10	0.14 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles';
11	0.16 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.09 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "book-accommodation" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/' AND `key` = BINARY 'book-accommodation';
13	0.14 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
14	0.36 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19883`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19883;
15	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"21"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '21';
16	0.25 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19960`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19960;
17	0.13 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`10835`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 10835;
18	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"72"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '72';
19	0.14 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.08 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.12 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.10 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.19 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6515`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6515;
24	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"59"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '59';
25	0.48 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

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?_=1732689208128&nearbySearchId=1580303&nearbySearchLat=47.0618&nearbySearchLong=15.0821&randSeed=382

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