Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1733322519024&nearbySearchId=46257267&nearbySearchLat=46.85754&nearbySearchLong=15.53589&randSeed=90

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