Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

167.90 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.38 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.08 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.08 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.17 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"mainBlogPortal" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.08 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.06 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.44 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=916&nearbySearchId=324629&nearbySearchLat=47.02159&nearbySearchLong=15.19547&_=1732782519790" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1732782519790&nearbySearchId=324629&nearbySearchLat=47.02159&nearbySearchLong=15.19547&randSeed=916" "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=916&nearbySearchId=324629&nearbySearchLat=47.02159&nearbySearchLong=15.19547&_=1732782519790' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1732782519790&nearbySearchId=324629&nearbySearchLat=47.02159&nearbySearchLong=15.19547&randSeed=916' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC;
8	0.11 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "reports" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
9	0.10 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.09 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.14 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.09 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "book-accommodation" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/' AND `key` = BINARY 'book-accommodation';
13	0.12 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
14	0.17 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.08 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.12 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.12 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`10835`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 10835;
18	0.07 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"72"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '72';
19	0.07 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.06 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.06 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.07 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.17 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.07 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.46 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

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?_=1732782519790&nearbySearchId=324629&nearbySearchLat=47.02159&nearbySearchLong=15.19547&randSeed=916

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