Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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?_=1737245740434&nearbySearchId=854321&nearbySearchLat=47.07247&nearbySearchLong=15.1278&randSeed=91

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