Query Metrics

143 Database Queries
44 Different statements
49238.82 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

#â–² Time Info
1 0.35 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:
0 of 0
[â–¼ "defaultSiteConfig" null null ]
2 0.09 ms
SELECT * FROM website_settings WHERE id = ?
Parameters:
0 of 0
[â–¼ 1 ]
3 0.16 ms
SELECT name FROM classes WHERE id = ?
Parameters:
0 of 0
[â–¼ "SiteConfig" ]
4 0.24 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:
0 of 0
[â–¼ "mainBlogPortal" null null ]
5 0.07 ms
SELECT * FROM website_settings WHERE id = ?
Parameters:
0 of 0
[â–¼ 8 ]
6 0.08 ms
SELECT name FROM classes WHERE id = ?
Parameters:
0 of 0
[â–¼ "BlogPortal" ]
7 0.47 ms
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
0 of 0
[â–¼ "sourcePath" => "/en/Hochsteiermark/Plan-your-holiday/Find-book-accommodation/bubbles" "sourcePathQuery" => "/en/Hochsteiermark/Plan-your-holiday/Find-book-accommodation/bubbles?randSeed=532&nearbySearchId=1580621&nearbySearchLat=47.77356&nearbySearchLong=15.31861&_=1733331920840" "sourceEntireUri" => "https://stage.steiermark.com/en/Hochsteiermark/Plan-your-holiday/Find-book-accommodation/bubbles?_=1733331920840&nearbySearchId=1580621&nearbySearchLat=47.77356&nearbySearchLong=15.31861&randSeed=532" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ]
8 0.14 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
0 of 0
[â–¼ "id" => "reports" "scope" => "pimcore" ]
9 0.13 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
0 of 0
[â–¼ "key" => "bubbles" "path" => "/steiermark.com/en/Hochsteiermark/Plan-your-holiday/Find-book-accommodation/" ]
10 0.10 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
0 of 0
[â–¼ "prettyUrl" => "/steiermark.com/en/Hochsteiermark/Plan-your-holiday/Find-book-accommodation/bubbles" ]
11 0.13 ms
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
0 of 0
[â–¼ "/steiermark.com/%" "/en/Hochsteiermark/Plan-your-holiday/Find-book-accommodation/bubbles" ]
12 0.08 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
0 of 0
[â–¼ "key" => "Find-book-accommodation" "path" => "/steiermark.com/en/Hochsteiermark/Plan-your-holiday/" ]
13 0.13 ms
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
14 0.35 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
0 of 0
[â–¼ 14994 ]
15 0.10 ms
SELECT name FROM classes WHERE id = ?
Parameters:
0 of 0
[â–¼ "21" ]
16 0.14 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
0 of 0
[â–¼ 15020 ]
17 0.11 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
0 of 0
[â–¼ 14093 ]
18 0.07 ms
SELECT name FROM classes WHERE id = ?
Parameters:
0 of 0
[â–¼ "51" ]
19 0.08 ms
SELECT name FROM classes WHERE id = ?
Parameters:
0 of 0
[â–¼ "18" ]
20 0.09 ms
SELECT name FROM classes WHERE id = ?
Parameters:
0 of 0
[â–¼ "31" ]
21 0.17 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
0 of 0
[â–¼ 11846 ]
22 0.08 ms
SELECT name FROM classes WHERE id = ?
Parameters:
0 of 0
[â–¼ "59" ]
23 0.34 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:
0 of 0
[â–¼ 11507 ]
24 0.08 ms
SELECT name FROM classes WHERE id = ?
Parameters:
0 of 0
[â–¼ "72" ]
25 0.32 ms
SELECT name FROM classes WHERE id = ?
Parameters:
0 of 0
[â–¼ "68" ]
26 0.26 ms
SELECT name FROM classes WHERE id = ?
Parameters:
0 of 0
[â–¼ "20" ]

demi_vacancies connection

#â–² Time Info
1 4.68 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 (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
2 46.76 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 (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1620881,1634574,1626682,1633155,1637831,1621280,1625771,1620709,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,2660012,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,43384764,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,8925508,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,43384756,1624054,1624685,1632826,45794146,2661087,1633774,1621080,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,45916289,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1639729,1637797,1639682,1648477,1624588,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620732,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1640812,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1624427,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,6142093,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,43384770,1633762,14383937,39952619,1646659,1631532,21236516,2657360,2587910,1625496,1620033,1635550,39270097,1626378,1637071,1625755,1622502,10490264,1619633,1620627,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1620967,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520)
                  
                   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:
[]
3 2179.41 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
4 0.15 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
5 1.02 ms
SELECT  dest_id,  count(src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (9616, 9804)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)

             group by dest_id
Parameters:
[]
6 0.06 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
7 2159.08 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
8 0.18 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
9 0.08 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
10 2167.38 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
11 0.21 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
12 12.59 ms
SELECT  dest_id,  count(src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6812, 6815, 6830, 6813, 13756965, 6825, 6809, 6831, 6806, 6839, 12662, 6814, 6807, 6838, 6824, 6826, 6817, 6816, 6819, 6832, 6820, 6822)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)

             group by dest_id
Parameters:
[]
13 0.12 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
14 1986.32 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
15 0.16 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
16 0.25 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (9941)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
17 0.07 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
18 1675.79 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
19 0.14 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
20 0.30 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (9943)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
21 0.06 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
22 1817.91 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
23 0.15 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
24 1.21 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (9948)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
25 0.06 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
26 1866.93 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
27 0.14 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
28 0.33 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (9939)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
29 0.07 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
30 1810.58 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
31 0.17 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
32 2.01 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (9944)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
33 0.08 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
34 1800.63 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
35 0.17 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
36 0.84 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6877)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
37 0.07 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
38 1788.39 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
39 0.16 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
40 0.51 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6859)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
41 0.07 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
42 1789.03 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
43 0.17 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
44 0.28 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6868)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
45 0.07 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
46 1792.39 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
47 0.17 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
48 0.95 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6896)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
49 0.06 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
50 1789.83 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
51 0.16 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
52 0.55 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6898)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
53 0.06 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
54 1793.92 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
55 0.13 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
56 0.26 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (6925)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
57 0.06 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
58 1791.65 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
59 0.16 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
60 0.34 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11534)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
61 0.06 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
62 1770.81 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
63 0.17 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
64 0.29 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11539)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
65 0.07 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
66 1781.41 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
67 0.17 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
68 0.30 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11538)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
69 0.07 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
70 1789.53 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
71 0.19 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
72 0.29 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11527)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
73 0.07 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
74 1812.96 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
75 0.15 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
76 0.30 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11522)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
77 0.06 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
78 1542.61 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
79 0.13 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
80 0.23 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11524)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
81 0.06 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
82 1358.04 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
83 0.14 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
84 0.50 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11559)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
85 0.06 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
86 1373.22 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
87 0.16 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
88 0.28 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11521)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
89 0.07 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
90 1338.54 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
91 0.17 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
92 0.33 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11567)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
93 0.07 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
94 1360.49 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
95 0.17 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
96 0.31 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11526)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
97 0.07 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
98 1364.97 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
99 0.18 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
100 0.28 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11536)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
101 0.07 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
102 1375.10 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
103 0.14 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
104 0.29 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11560)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
105 0.06 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
106 1371.36 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
107 0.16 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
108 0.26 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11528)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
109 0.07 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
110 1363.05 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
111 0.15 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
112 0.28 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11535)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
113 0.06 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]
114 1339.57 ms
SELECT   dacco.isTop, dacco.bookable, dacco.oo_id oo_id  FROM `steiermark`.object_8 dacco WHERE  dacco.oo_id IN (1635138,1633626,1648391,1621683,1619082,1632497,1639192,5612646,1632429,1620331,1621646,1636022,1646646,42105627,1632667,1646563,18129824,1634574,1626682,1633155,1637831,1621280,1625771,8484467,1638503,3213231,1637716,1623305,1632225,1645676,1648428,1648548,1648515,1622327,1626974,1623492,1620892,1645934,1620658,1646822,1622416,1636646,6285088,1621367,1646975,1634459,1619833,1625179,2659058,1622865,1635360,1619864,1620355,5612752,11753999,1623157,2661674,1621239,1635442,1625225,11753981,1623749,1648586,1626047,1640108,1634280,1637581,4062150,1635256,6356118,1635202,31729351,1633887,1619043,1633857,1631825,1626927,1638406,1640532,1624776,1632798,1624458,1625303,1645885,1619783,1622354,1619113,1624901,1634109,1647275,13418149,1639599,1619305,1619453,1625388,1633481,32341429,1638938,1625798,1635895,15730622,1619289,1619845,1637479,1625681,1624054,1624685,1632826,45794146,2661087,1633774,1625875,1647231,1632749,1635281,1625285,1634962,1621992,35322667,3379852,1625909,4062278,1625983,1621086,1638201,1645656,1648172,1620087,1626131,36619704,4062202,1633276,1646625,1633581,1619257,1622191,1622536,1620998,2660121,1632008,1626434,1625836,1620528,12406905,1647500,1620510,1633946,1637797,1639682,1648477,1643509,1632111,1643484,1631662,1621340,1634534,1625531,1624824,1633182,1623678,1634217,1632926,1622643,1646258,1624179,1635060,19326229,1634078,1620737,1619615,1625106,42449618,1622610,1633342,1646152,1624206,1633994,1638980,1625445,1633707,48224470,1634918,1633380,1621213,1632608,1620205,1626162,1634940,1648359,1620303,1624490,1636769,1622470,1632762,1627127,1623962,35617129,1621941,18743357,26342359,1626620,1622382,1931242,1648697,1624928,1624562,1640572,1625784,1625429,1621542,1635495,2659288,9624503,1633679,1633539,1633506,1635377,1634372,1623716,35757609,1634247,1625132,1620371,1625728,1646091,1619716,1634602,1620047,1634862,1622267,1626078,1627052,23455755,1623990,1632452,1619797,1622066,36260848,39226898,1633762,14383937,39952619,1646659,1631532,21236516,2587910,1625496,1635550,1626378,1637071,1625755,1622502,1619633,5367350,1619430,1632860,1637922,1639755,1635097,1635028,1622914,1646511,1632999,16605339,12435028,1631738,1622686,1626287,2530373,1621181,1621908,1623363,1625639,1645256,1622139,1634090,1643418,1638661,1635930,1635520,1620881,1620709,2660012,43384764,8925508,43384756,1621080,45916289,1639729,1624588,1620732,1640812,1624427,6142093,43384770,2657360,1620033,39270097,10490264,1620627,1620967)  AND  dacco.o_published = 1  AND (dacco.town__id IN (11534, 11539, 11538, 11527, 11522, 11524, 11559, 11521, 11567, 11560, 11526, 11536, 3896603, 11528, 11535, 11537))  GROUP BY dacco.oo_id  ORDER BY  RAND(532)
Parameters:
[]
115 0.11 ms
create TEMPORARY table `steiermark`.accoIdsTowns(
            id int(11) NOT NULL,
            PRIMARY KEY (`id`)
            )
             engine=memory;
            insert into `steiermark`.accoIdsTowns (id) values (1640108),(1635442),(36619704),(1622502),(1619082),(1634280),(2661674),(1624685),(1634217),(1620355),(1622470),(1646091),(21236516),(2659058),(1634459),(18743357),(1619716),(1625728),(1638503),(1633506),(1635028),(1646659),(1621941),(1632429),(1621086),(1620998),(1647275),(1632798),(1646625),(1624179),(1634109),(12406905),(39226898),(42105627),(39952619),(1622643),(1633581),(1625285),(1648391),(1621239),(13418149),(1620881),(26342359),(1623157),(1646152),(1648548),(1622686),(31729351),(1638201),(1619864),(1626162),(1648172),(1623962),(1643418),(1620047),(45916289),(1620371),(1648515),(1625639),(1624054),(43384770),(1621908),(1643509),(1626682),(1625531),(1624490),(42449618),(1632926),(4062278),(1637831),(2659288),(1625429),(1640572),(1648586),(1640532),(1625445),(1636022),(1619043),(1635930),(1633994),(1633539),(1647231),(5367350),(1625909),(1621080),(1634602),(1625388),(1626974),(12435028),(1619633),(1625225),(1619113),(1625983),(1637581),(35322667),(2530373),(3213231),(1619305),(1619833),(1627052),(1635256),(2657360),(2660121),(1632497),(1645885),(1625681),(1619289),(1620033),(1646563),(1632008),(45794146),(1625755),(1625875),(1634862),(1624824),(6142093),(1635895),(1621367),(1632667),(32341429),(1634534),(1640812),(1626927),(1639599),(1624928),(6356118),(1620528),(1632749),(1620967),(1632860),(1621542),(1646975),(11753999),(35757609),(1620303),(1633155),(1619783),(1622139),(1622865),(1635097),(19326229),(1635377),(1619257),(1625179),(1623492),(1621340),(1648428),(1634078),(1633380),(1632608),(1620732),(1626287),(35617129),(1620709),(1636646),(4062150),(1646646),(3379852),(39270097),(1625836),(10490264),(1634090),(9624503),(1633887),(1622382),(1638406),(1631738),(1626620),(1635060),(1624427),(1637716),(1634940),(1623716),(16605339),(1625771),(1639729),(1620627),(1637071),(1621181),(1621213),(1619430),(1626078),(1633774),(1623678),(1635138),(15730622),(1625496),(1636769),(2661087),(1631532),(1635520),(1622354),(1638980),(1635202),(1621683),(1634372),(1620658),(1633182),(1639192),(36260848),(1620331),(1625784),(1646258),(1623305),(1634574),(1633679),(1624562),(1633762),(1624901),(1624776),(6285088),(1633481),(1622914),(5612752),(1647500),(43384756),(1626047),(1625798),(5612646),(1632452),(1627127),(1622416),(1645256),(1648359),(1648697),(1635495),(1635360),(1625303),(1635281),(1643484),(1637922),(1624458),(1622066),(1637797),(1626131),(1620510),(1632111),(1621992),(14383937),(1619615),(1638661),(1620205),(1638938),(1622610),(1632999),(1633626),(1626434),(1624588),(1634247),(1619845),(1625106),(8484467),(1622191),(48224470),(1635550),(1626378),(1622327),(23455755),(1633857),(2587910),(1632762),(43384764),(1631662),(1620087),(1645676),(1622267),(1633342),(1646511),(1632225),(1623363),(1931242),(1619453),(1620737),(1648477),(1619797),(1634918),(1646822),(4062202),(1639755),(1639682),(1623990),(18129824),(1634962),(1633707),(1632826),(1633946),(1623749),(1633276),(1620892),(1621646),(1622536),(1624206),(1621280),(1631825),(11753981),(1625132),(1637479),(8925508),(2660012),(1645934),(1645656)
Parameters:
[]
116 0.23 ms
SELECT  count(DISTINCT src_id) as accoCount
                      FROM `steiermark`.object_relations_8 daccorel
                     WHERE
                        dest_id IN (11537)
                        AND
                            src_id IN
                              (select id from `steiermark`.accoIdsTowns)
Parameters:
[]
117 0.06 ms
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[]

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.