Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

47 Database Queries

21 Different statements

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

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?_=1732075171683&nearbySearchId=854510&nearbySearchLat=46.93031&nearbySearchLong=15.2575&randSeed=614

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