Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

161.40 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.36 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.10 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.25 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SiteConfig"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SiteConfig';
4	0.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: [`"mainBlogPortal" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.07 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.07 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BlogPortal"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BlogPortal';
7	0.38 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=881&nearbySearchId=1430522&nearbySearchLat=46.99363&nearbySearchLong=15.20777&_=1732773533648" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1732773533648&nearbySearchId=1430522&nearbySearchLat=46.99363&nearbySearchLong=15.20777&randSeed=881" "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=881&nearbySearchId=1430522&nearbySearchLat=46.99363&nearbySearchLong=15.20777&_=1732773533648' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1732773533648&nearbySearchId=1430522&nearbySearchLat=46.99363&nearbySearchLong=15.20777&randSeed=881' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC;
8	0.16 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "reports" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
9	0.21 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "bubbles" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/' AND `key` = BINARY 'bubbles';
10	0.13 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles';
11	0.16 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/en/Suedsteiermark/Holiday/book-accommodation/bubbles"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en/Suedsteiermark/Holiday/book-accommodation/bubbles';
12	0.10 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "book-accommodation" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/' AND `key` = BINARY 'book-accommodation';
13	0.14 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
14	0.17 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19883`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19883;
15	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"21"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '21';
16	0.13 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19960`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19960;
17	0.13 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`10835`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 10835;
18	0.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"72"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '72';
19	0.25 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"68"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '68';
20	0.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"18"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '18';
21	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"51"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '51';
22	0.08 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"30"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '30';
23	0.16 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6515`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6515;
24	0.07 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"59"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '59';
25	0.42 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

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?_=1732773533648&nearbySearchId=1430522&nearbySearchLat=46.99363&nearbySearchLong=15.20777&randSeed=881

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