Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

171.60 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1732786247904&nearbySearchId=46257192&nearbySearchLat=46.71353&nearbySearchLong=15.45684&randSeed=498

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