Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

168.59 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


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

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

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

https://stage.steiermark.com/en/Suedsteiermark/Holiday/book-accommodation/bubbles?_=1729657472586&nearbySearchId=46257245&nearbySearchLat=46.72141&nearbySearchLong=15.55848&randSeed=570

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