Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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?_=1738664361257&nearbySearchId=27187837&nearbySearchLat=46.70896&nearbySearchLong=15.63138&randSeed=895

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