Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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?_=1732972107552&nearbySearchId=853654&nearbySearchLat=47.07177&nearbySearchLong=15.08857&randSeed=946

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