Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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?_=1737234464590&nearbySearchId=17415491&nearbySearchLat=47.00803&nearbySearchLong=15.05715&randSeed=429

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