Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

150.14 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.47 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.37 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.48 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.11 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.11 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.55 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=268&nearbySearchId=853536&nearbySearchLat=46.97886&nearbySearchLong=15.02406&_=1738942330591" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1738942330591&nearbySearchId=853536&nearbySearchLat=46.97886&nearbySearchLong=15.02406&randSeed=268" "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=268&nearbySearchId=853536&nearbySearchLat=46.97886&nearbySearchLong=15.02406&_=1738942330591' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1738942330591&nearbySearchId=853536&nearbySearchLat=46.97886&nearbySearchLong=15.02406&randSeed=268' 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.22 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.34 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.15 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.10 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.21 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.27 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.13 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.35 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.14 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.15 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.44 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.30 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.29 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.30 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.28 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.14 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.66 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

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?_=1738942330591&nearbySearchId=853536&nearbySearchLat=46.97886&nearbySearchLong=15.02406&randSeed=268

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