Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1732959060426&nearbySearchId=1580530&nearbySearchLat=46.67333&nearbySearchLong=15.53538&randSeed=224

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