Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

198.61 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.45 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.07 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.10 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.26 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.10 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.08 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.87 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=653&nearbySearchId=324863&nearbySearchLat=46.66726&nearbySearchLong=15.46755&_=1732861760395" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1732861760395&nearbySearchId=324863&nearbySearchLat=46.66726&nearbySearchLong=15.46755&randSeed=653" "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=653&nearbySearchId=324863&nearbySearchLat=46.66726&nearbySearchLong=15.46755&_=1732861760395' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1732861760395&nearbySearchId=324863&nearbySearchLat=46.66726&nearbySearchLong=15.46755&randSeed=653' 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.15 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.16 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.14 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles';
11	0.17 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/en/Suedsteiermark/Holiday/book-accommodation/bubbles"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en/Suedsteiermark/Holiday/book-accommodation/bubbles';
12	0.11 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.15 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.50 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19883`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19883;
15	0.11 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"21"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '21';
16	0.45 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19960`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19960;
17	0.15 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`10835`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 10835;
18	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"72"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '72';
19	0.31 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.15 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.28 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.28 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.43 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6515`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6515;
24	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"59"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '59';
25	0.65 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

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?_=1732861760395&nearbySearchId=324863&nearbySearchLat=46.66726&nearbySearchLong=15.46755&randSeed=653

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