Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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?_=1733036498249&nearbySearchId=1580605&nearbySearchLat=46.71856&nearbySearchLong=15.2707&randSeed=241

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