Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

169.16 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


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

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1732958986383&nearbySearchId=324768&nearbySearchLat=47.02159&nearbySearchLong=15.19547&randSeed=740

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