Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

236.56 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


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

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

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