Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

150.16 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


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

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1731403503999&nearbySearchId=1430909&nearbySearchLat=46.66739&nearbySearchLong=15.46824&randSeed=965

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