Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

45 Database Queries

21 Different statements

160.28 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 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 name FROM classes WHERE id = ?
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC

#▲	Time	Info
1	0.42 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"defaultSiteConfig" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'defaultSiteConfig' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
2	0.11 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 1;
3	0.16 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.18 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.06 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.05 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" => "/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles" "sourcePathQuery" => "/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles?randSeed=750&nearbySearchId=3738333&nearbySearchLat=46.71882&nearbySearchLong=15.27116&_=1739232000000" "sourceEntireUri" => "https://stage.steiermark.com/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles?_=1739232000000&nearbySearchId=3738333&nearbySearchLat=46.71882&nearbySearchLong=15.27116&randSeed=750" "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 = '/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles?randSeed=750&nearbySearchId=3738333&nearbySearchLat=46.71882&nearbySearchLong=15.27116&_=1739232000000' AND `type` = 'path_query') OR (source = 'https://stage.steiermark.com/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles?_=1739232000000&nearbySearchId=3738333&nearbySearchLat=46.71882&nearbySearchLong=15.27116&randSeed=750' 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.08 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.12 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "bubbles" "path" => "/steiermark.com/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/"`] 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/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/' AND `key` = BINARY 'bubbles';
10	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/steiermark.com/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/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/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles';
11	0.12 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/%" "/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/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 = '/de/Suedsteiermark/Urlaub-planen/Unterkuenfte-suchen-und-buchen/bubbles';
12	0.07 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Unterkuenfte-suchen-und-buchen" "path" => "/steiermark.com/de/Suedsteiermark/Urlaub-planen/"`] 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/de/Suedsteiermark/Urlaub-planen/' AND `key` = BINARY 'Unterkuenfte-suchen-und-buchen';
13	0.10 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.30 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;
15	0.22 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.32 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;
17	0.11 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';
18	0.22 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';
19	0.12 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';
20	0.12 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';
21	0.21 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';
22	0.23 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';
23	0.72 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`6938`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 6938 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;

demi_vacancies connection

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

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