Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

152.91 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


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

#▲	Time	Info
1	0.36 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.07 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.28 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.06 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.60 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=633&nearbySearchId=48872575&nearbySearchLat=46.7824&nearbySearchLong=15.54065&_=1733036086355" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1733036086355&nearbySearchId=48872575&nearbySearchLat=46.7824&nearbySearchLong=15.54065&randSeed=633" "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=633&nearbySearchId=48872575&nearbySearchLat=46.7824&nearbySearchLong=15.54065&_=1733036086355' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1733036086355&nearbySearchId=48872575&nearbySearchLat=46.7824&nearbySearchLong=15.54065&randSeed=633' 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.13 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.13 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "bubbles" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/' AND `key` = BINARY 'bubbles';
10	0.11 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles';
11	0.16 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/steiermark.com/%" "/en/Suedsteiermark/Holiday/book-accommodation/bubbles"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/steiermark.com/%' AND documents_page.prettyUrl = '/en/Suedsteiermark/Holiday/book-accommodation/bubbles';
12	0.09 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "book-accommodation" "path" => "/steiermark.com/en/Suedsteiermark/Holiday/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/steiermark.com/en/Suedsteiermark/Holiday/' AND `key` = BINARY 'book-accommodation';
13	0.12 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
14	0.33 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.13 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.29 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.11 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.30 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.20 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.26 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.23 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.35 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.12 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.64 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1733036086355&nearbySearchId=48872575&nearbySearchLat=46.7824&nearbySearchLong=15.54065&randSeed=633

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