Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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?_=1730976022251&nearbySearchId=4579000&nearbySearchLat=46.82101&nearbySearchLong=15.4495&randSeed=549

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