Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

164.67 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.42 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.15 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.16 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.40 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.15 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.14 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BlogPortal"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BlogPortal';
7	0.61 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=226&nearbySearchId=36152093&nearbySearchLat=47.04252&nearbySearchLong=14.46184&_=1726272000000" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1726272000000&nearbySearchId=36152093&nearbySearchLat=47.04252&nearbySearchLong=14.46184&randSeed=226" "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=226&nearbySearchId=36152093&nearbySearchLat=47.04252&nearbySearchLong=14.46184&_=1726272000000' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1726272000000&nearbySearchId=36152093&nearbySearchLat=47.04252&nearbySearchLong=14.46184&randSeed=226' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC;
8	0.20 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "reports" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
9	0.34 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "bubbles" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/' AND `key` = BINARY 'bubbles';
10	0.13 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles';
11	0.25 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.12 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "book-accommodation" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/' AND `key` = BINARY 'book-accommodation';
13	0.21 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
14	0.86 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.68 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"21"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '21';
16	0.35 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19960`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19960;
17	0.23 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.28 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.28 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.22 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.24 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.23 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.33 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.11 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.53 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1726272000000&nearbySearchId=36152093&nearbySearchLat=47.04252&nearbySearchLong=14.46184&randSeed=226

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