Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

145.95 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.25 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.15 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.34 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.09 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.57 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=507&nearbySearchId=853818&nearbySearchLat=46.94727&nearbySearchLong=15.23401&_=1738942033971" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1738942033971&nearbySearchId=853818&nearbySearchLat=46.94727&nearbySearchLong=15.23401&randSeed=507" "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=507&nearbySearchId=853818&nearbySearchLat=46.94727&nearbySearchLong=15.23401&_=1738942033971' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1738942033971&nearbySearchId=853818&nearbySearchLat=46.94727&nearbySearchLong=15.23401&randSeed=507' 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.12 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "bubbles" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/' AND `key` = BINARY 'bubbles';
10	0.10 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles';
11	0.15 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/en/Suedsteiermark/Holiday/book-accommodation/bubbles"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en/Suedsteiermark/Holiday/book-accommodation/bubbles';
12	0.08 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.28 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19883`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19883;
15	0.14 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"21"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '21';
16	0.34 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19960`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19960;
17	0.11 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`10835`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 10835;
18	0.11 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.15 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.10 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.09 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.10 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.21 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.09 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.57 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1738942033971&nearbySearchId=853818&nearbySearchLat=46.94727&nearbySearchLong=15.23401&randSeed=507

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