Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

183.62 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.44 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.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SiteConfig"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SiteConfig';
4	0.24 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"mainBlogPortal" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.10 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.11 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.37 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=444&nearbySearchId=1580692&nearbySearchLat=47.18097&nearbySearchLong=15.11577&_=1731695054742" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1731695054742&nearbySearchId=1580692&nearbySearchLat=47.18097&nearbySearchLong=15.11577&randSeed=444" "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=444&nearbySearchId=1580692&nearbySearchLat=47.18097&nearbySearchLong=15.11577&_=1731695054742' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1731695054742&nearbySearchId=1580692&nearbySearchLat=47.18097&nearbySearchLong=15.11577&randSeed=444' 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.15 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "bubbles" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/' AND `key` = BINARY 'bubbles';
10	0.11 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles';
11	0.15 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.13 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
14	0.19 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`19883`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 19883;
15	0.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.14 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`10835`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 10835;
18	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"72"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '72';
19	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"68"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '68';
20	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"18"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '18';
21	0.11 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.09 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.18 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6515`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6515;
24	0.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"59"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '59';
25	0.40 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

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