Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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