Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

139.61 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


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

#▲	Time	Info
1	0.36 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.09 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.11 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.21 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"mainBlogPortal" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.09 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BlogPortal"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BlogPortal';
7	0.32 ms	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC Parameters: ["sourcePath" => "/en/Suedsteiermark/Holiday/book-accommodation/bubbles" "sourcePathQuery" => "/en/Suedsteiermark/Holiday/book-accommodation/bubbles?randSeed=684&nearbySearchId=324980&nearbySearchLat=47.04942&nearbySearchLong=15.15013&_=1737254340663" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1737254340663&nearbySearchId=324980&nearbySearchLat=47.04942&nearbySearchLong=15.15013&randSeed=684" "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=684&nearbySearchId=324980&nearbySearchLat=47.04942&nearbySearchLong=15.15013&_=1737254340663' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1737254340663&nearbySearchId=324980&nearbySearchLat=47.04942&nearbySearchLong=15.15013&randSeed=684' 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.11 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.11 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.09 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.13 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/en/Suedsteiermark/Holiday/book-accommodation/bubbles"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en/Suedsteiermark/Holiday/book-accommodation/bubbles';
12	0.09 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "book-accommodation" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/' AND `key` = BINARY 'book-accommodation';
13	0.12 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.13 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.08 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.12 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19960`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19960;
17	0.12 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`10835`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 10835;
18	0.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"72"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '72';
19	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"68"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '68';
20	0.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"18"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '18';
21	0.07 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"51"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '51';
22	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"30"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '30';
23	0.13 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6515`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6515;
24	0.07 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"59"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '59';
25	0.38 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1737254340663&nearbySearchId=324980&nearbySearchLat=47.04942&nearbySearchLong=15.15013&randSeed=684

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