Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

149.94 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


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

#▲	Time	Info
1	0.34 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.15 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.17 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SiteConfig"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SiteConfig';
4	0.22 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"mainBlogPortal" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'mainBlogPortal' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
5	0.07 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 8;
6	0.06 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"BlogPortal"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'BlogPortal';
7	0.26 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=801&nearbySearchId=46460142&nearbySearchLat=46.94588&nearbySearchLong=15.33511&_=1733026767951" "sourceEntireUri" => "https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1733026767951&nearbySearchId=46460142&nearbySearchLat=46.94588&nearbySearchLong=15.33511&randSeed=801" "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=801&nearbySearchId=46460142&nearbySearchLat=46.94588&nearbySearchLong=15.33511&_=1733026767951' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1733026767951&nearbySearchId=46460142&nearbySearchLat=46.94588&nearbySearchLong=15.33511&randSeed=801' 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.09 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.08 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.07 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.11 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.06 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.09 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.11 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.07 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.09 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.10 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.06 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.14 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.11 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.11 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"51"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '51';
22	0.11 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"30"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '30';
23	0.20 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6515`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6515;
24	0.12 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"59"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '59';
25	0.52 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1733026767951&nearbySearchId=46460142&nearbySearchLat=46.94588&nearbySearchLong=15.33511&randSeed=801

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