Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

143.39 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.28 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.07 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.07 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.16 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.06 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.07 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.39 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=663&nearbySearchId=324372&nearbySearchLat=46.99337&nearbySearchLong=15.20616&_=1737254292979" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1737254292979&nearbySearchId=324372&nearbySearchLat=46.99337&nearbySearchLong=15.20616&randSeed=663" "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=663&nearbySearchId=324372&nearbySearchLat=46.99337&nearbySearchLong=15.20616&_=1737254292979' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1737254292979&nearbySearchId=324372&nearbySearchLat=46.99337&nearbySearchLong=15.20616&randSeed=663' 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.10 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.09 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.07 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.11 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.07 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.09 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
14	0.13 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19883`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19883;
15	0.07 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.10 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.10 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.07 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"72"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '72';
19	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"68"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '68';
20	0.05 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.05 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"51"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '51';
22	0.06 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"30"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '30';
23	0.11 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6515`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6515;
24	0.05 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.32 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1737254292979&nearbySearchId=324372&nearbySearchLat=46.99337&nearbySearchLong=15.20616&randSeed=663

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