Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1732693125502&nearbySearchId=325059&nearbySearchLat=46.821&nearbySearchLong=15.44949&randSeed=660

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