Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

146.61 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


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

#▲	Time	Info
1	0.29 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.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SiteConfig"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SiteConfig';
4	0.30 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"mainBlogPortal" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.10 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.09 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.39 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=864&nearbySearchId=1580493&nearbySearchLat=47.19112&nearbySearchLong=15.09608&_=1738594704929" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1738594704929&nearbySearchId=1580493&nearbySearchLat=47.19112&nearbySearchLong=15.09608&randSeed=864" "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=864&nearbySearchId=1580493&nearbySearchLat=47.19112&nearbySearchLong=15.09608&_=1738594704929' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1738594704929&nearbySearchId=1580493&nearbySearchLat=47.19112&nearbySearchLong=15.09608&randSeed=864' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC;
8	0.15 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "reports" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
9	0.17 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.13 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.19 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.13 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "book-accommodation" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/' AND `key` = BINARY 'book-accommodation';
13	0.15 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
14	0.20 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.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"21"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '21';
16	0.15 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19960`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19960;
17	0.13 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`10835`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 10835;
18	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"72"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '72';
19	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"68"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '68';
20	0.11 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"18"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '18';
21	0.16 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"51"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '51';
22	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"30"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '30';
23	0.16 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6515`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6515;
24	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"59"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '59';
25	0.41 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

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?_=1738594704929&nearbySearchId=1580493&nearbySearchLat=47.19112&nearbySearchLong=15.09608&randSeed=864

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