Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

173.54 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


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

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

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