Query Metrics
143
Database Queries
44
Different statements
40214.54 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
1.20 ms (0.00%) |
10 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
1.15 ms (0.00%) |
4 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
14994
]
|
0.61 ms (0.00%) |
2 |
SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[ "defaultSiteConfig" null null ] |
0.58 ms (0.00%) |
1 |
SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '6' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "sourcePath" => "/en/Hochsteiermark/Plan-your-holiday/Find-book-accommodation/bubbles" "sourcePathQuery" => "/en/Hochsteiermark/Plan-your-holiday/Find-book-accommodation/bubbles?randSeed=757&nearbySearchId=1580324&nearbySearchLat=47.57266&nearbySearchLong=15.5001&_=1728864000000" "sourceEntireUri" => "https://stage.steiermark.com/en/Hochsteiermark/Plan-your-holiday/Find-book-accommodation/bubbles?_=1728864000000&nearbySearchId=1580324&nearbySearchLat=47.57266&nearbySearchLong=15.5001&randSeed=757" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
0.34 ms (0.00%) |
1 |
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:
[
11507
]
|
0.21 ms (0.00%) |
2 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "bubbles" "path" => "/steiermark.com/en/Hochsteiermark/Plan-your-holiday/Find-book-accommodation/" ] |
0.18 ms (0.00%) |
1 |
SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[ "/steiermark.com/%" "/en/Hochsteiermark/Plan-your-holiday/Find-book-accommodation/bubbles" ] |
0.16 ms (0.00%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
0.14 ms (0.00%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
0.13 ms (0.00%) |
1 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
0.11 ms (0.00%) |
1 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/steiermark.com/en/Hochsteiermark/Plan-your-holiday/Find-book-accommodation/bubbles" ] |
demi_vacancies connection
Time▼ | Count | Info |
---|---|---|
40129.71 ms (99.79%) |
29 |
SELECT dacco.isTop, dacco.bookable, dacco.oo_id oo_id FROM `steiermark`.object_8 dacco WHERE dacco.oo_id IN (2659288,1648391,1645885,1647500,1647231,15730622,1623962,1621542,45794146,1633707,1646258,1635256,1625445,1624928,1633762,1626047,1648359,1633994,1625285,1627052,1634574,4062150,1634940,1625496,1625639,11753999,1632008,1621181,1619845,1632497,1635520,1635495,35617129,1620528,1622139,1622327,1633774,1626974,2530373,1625225,1643509,1634217,2659058,1633946,1634534,1620205,1624458,1646822,1637071,1635550,1634247,1639192,1633380,1634109,1635097,1638201,1635060,1626927,1619257,1624824,9624503,1635930,1622191,1626434,1625798,1645256,1621213,1647275,1621908,1635202,8484467,18743357,4062202,1633581,36619704,1619716,1634862,1623678,5612752,1638503,1635028,36260848,1625132,1625531,1626131,1645934,1624054,6285088,1626078,1619833,1622416,1632225,1646975,1624206,1619615,1620303,1623716,1619783,1635377,1648477,1625983,1646091,1639682,1620087,5367350,2661674,1632826,39952619,1622643,21236516,1635138,1636646,1633679,1621683,1632749,13418149,1621992,1637797,1636022,1624776,1620892,1621086,1634280,1648172,1621340,1619082,1633342,1621280,1631532,1624901,1620047,1633857,1622502,1625875,1643418,1622066,1633506,1622470,1620371,1631738,26342359,1638661,1625755,1626162,1619113,1621941,1643484,1631825,1625388,35757609,1626620,1619289,1624685,12406905,4062278,1633539,1640532,1635895,1635281,1619043,1619453,1639755,1620331,1623305,1634372,1634918,1638406,1634459,1619864,1931242,1635360,1645676,1637831,1624562,1633481,32341429,16605339,1623157,6356118,1633626,23455755,1625681,1619633,1640108,14383937,1632798,1619430,1645656,1633276,1636769,1625179,1626287,1646646,39226898,1622354,1633155,48224470,5612646,1634962,1620658,1625429,1621367,1625784,1632429,1623990,42449618,1624179,1640572,1632860,1622686,1619797,1623492,1623749,1646511,1637716,1637922,11753981,1646152,2660121,1625909,1635442,1622914,1634078,1625836,1621239,1620355,1632926,1622865,18129824,2661087,1646659,1632999,1626378,1646625,1646563,2587910,1625771,12435028,1632608,1637581,1637479,1648428,1632452,1622536,3379852,1625728,1625106,1638938,1634602,1621646,1633887,31729351,1632111,1620510,1634090,42105627,1625303,1633182,35322667,1626682,1620998,19326229,1622267,1632762,1648697,1627127,1631662,1638980,1639599,1619305,1624490,3213231,1623363,1648586,1648515,1632667,1648548,1622610,1622382,1620737,1620967,1624588,1620709,43384756,10490264,1640812,45916289,8925508,2660012,43384770,1620033,1621080,39270097,2657360,1639729,6142093,1620627,43384764,1620732,1620881,1624427) 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(757)
Parameters:
[] |
45.41 ms (0.11%) |
1 |
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 (2659288,1648391,1645885,1647500,1647231,15730622,1623962,1621542,1620967,45794146,1633707,1646258,1635256,1625445,1624928,1633762,1626047,1648359,1633994,1624588,1625285,1627052,1634574,4062150,1634940,1625496,1625639,11753999,1632008,1621181,1619845,1632497,1635520,1635495,1620709,35617129,1620528,1622139,1622327,1633774,1626974,2530373,1625225,1643509,1634217,2659058,1633946,1634534,1620205,1624458,1646822,1637071,1635550,43384756,1634247,1639192,1633380,1634109,1635097,1638201,1635060,1626927,1619257,10490264,1624824,9624503,1635930,1622191,1626434,1625798,1645256,1621213,1647275,1621908,1635202,8484467,18743357,1640812,4062202,45916289,1633581,36619704,1619716,1634862,1623678,5612752,1638503,1635028,36260848,1625132,1625531,1626131,1645934,1624054,6285088,1626078,1619833,1622416,1632225,1646975,1624206,1619615,1620303,1623716,1619783,1635377,1648477,1625983,1646091,1639682,1620087,5367350,2661674,1632826,39952619,1622643,21236516,1635138,1636646,1633679,1621683,1632749,13418149,1621992,1637797,1636022,1624776,1620892,1621086,1634280,1648172,1621340,1619082,1633342,1621280,1631532,1624901,1620047,1633857,1622502,1625875,1643418,1622066,1633506,1622470,1620371,1631738,26342359,1638661,1625755,1626162,1619113,1621941,1643484,1631825,1625388,35757609,1626620,1619289,1624685,12406905,4062278,1633539,1640532,1635895,1635281,1619043,1619453,1639755,1620331,8925508,1623305,1634372,2660012,1634918,1638406,1634459,1619864,1931242,1635360,1645676,43384770,1637831,1624562,1633481,32341429,16605339,1623157,6356118,1633626,23455755,1625681,1619633,1640108,1620033,14383937,1632798,1619430,1645656,1633276,1621080,1636769,1625179,1626287,1646646,39270097,2657360,39226898,1622354,1633155,48224470,5612646,1634962,1639729,1620658,1625429,1621367,1625784,1632429,1623990,42449618,1624179,1640572,6142093,1632860,1622686,1619797,1623492,1623749,1646511,1637716,1637922,11753981,1646152,2660121,1625909,1620627,1635442,1622914,1634078,43384764,1625836,1621239,1620355,1632926,1622865,18129824,2661087,1646659,1632999,1626378,1646625,1646563,2587910,1625771,12435028,1632608,1637581,1637479,1620732,1648428,1620881,1632452,1622536,3379852,1625728,1625106,1638938,1634602,1621646,1633887,1624427,31729351,1632111,1620510,1634090,42105627,1625303,1633182,35322667,1626682,1620998,19326229,1622267,1632762,1648697,1627127,1631662,1638980,1639599,1619305,1624490,3213231,1623363,1648586,1648515,1632667,1648548,1622610,1622382,1620737) 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:
[] |
11.79 ms (0.03%) |
1 |
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:
[] |
4.40 ms (0.01%) |
29 |
create TEMPORARY table `steiermark`.accoIdsTowns( id int(11) NOT NULL, PRIMARY KEY (`id`) ) engine=memory; insert into `steiermark`.accoIdsTowns (id) values (1648359),(36619704),(12435028),(35617129),(32341429),(1625681),(1624562),(1622416),(1621280),(1624824),(1635520),(16605339),(1640572),(1631532),(1626047),(1635550),(1632926),(36260848),(1636769),(1625836),(1626927),(1633626),(1638503),(1625429),(1639192),(1631662),(1631825),(1625639),(1634078),(1621646),(1620033),(1634280),(1645656),(1645256),(1621086),(1633762),(1620732),(1625132),(1622643),(1635895),(1633581),(1620892),(1626682),(10490264),(1637716),(1648172),(1636646),(1638406),(1620658),(1625388),(26342359),(1646511),(1645676),(45794146),(1637797),(2661674),(1635202),(1637581),(1639755),(1646975),(1639729),(1633539),(1619257),(1931242),(1626620),(1648697),(1645934),(1625179),(1633380),(1632497),(11753981),(1621683),(35322667),(1622536),(1640532),(1620998),(1624776),(5612752),(1622865),(1619783),(1635377),(1622139),(1619615),(1638938),(1624427),(1648515),(1647275),(1639682),(8484467),(1626131),(1631738),(1633155),(13418149),(1625755),(1648548),(1632999),(1619864),(1623157),(1634109),(31729351),(1625496),(1619430),(1620331),(1624458),(1619633),(1643484),(39270097),(1632860),(14383937),(3379852),(1620303),(1648477),(43384770),(1634862),(1622327),(1623716),(2587910),(1640108),(1646152),(1635495),(1622502),(1634534),(2530373),(1624928),(1646646),(1646091),(1625909),(1621239),(1621542),(1637831),(35757609),(1622382),(1619082),(1635138),(1621941),(1633857),(1625983),(1620205),(1635930),(1623363),(1632667),(8925508),(1625106),(1635281),(1623305),(1620510),(1633946),(6285088),(2660012),(1632225),(1633182),(1619113),(1624901),(9624503),(1633994),(1627052),(1622066),(1633481),(1619289),(1625875),(1626287),(1620967),(1635360),(5367350),(1645885),(1640812),(1619043),(1619833),(4062202),(1620355),(1621080),(1624179),(1637922),(1648391),(1638980),(1647231),(1638201),(1620047),(1647500),(1643418),(12406905),(48224470),(1646659),(1625798),(1635256),(2657360),(1633707),(1624054),(1648586),(1635442),(1626434),(1632008),(1619453),(4062278),(1620087),(1626378),(1634602),(1619797),(11753999),(1635097),(1621367),(1646258),(1626162),(1633276),(21236516),(1622267),(1632762),(1622191),(1625225),(1635028),(1622354),(1624685),(1639599),(4062150),(1620881),(1627127),(1622686),(1632452),(1634217),(1624588),(1633774),(1625771),(5612646),(1621992),(1634918),(1623749),(1619845),(1625285),(1624490),(18129824),(1646625),(1646822),(1625531),(15730622),(1648428),(1632749),(1620737),(1643509),(1623990),(1637071),(45916289),(1632608),(1621908),(1620371),(1634940),(1623962),(1619716),(6142093),(23455755),(1634962),(1633342),(19326229),(18743357),(43384764),(1632429),(1632826),(1634372),(2659288),(1646563),(1621181),(39226898),(1625728),(1634247),(1623492),(1620528),(1632111),(1626078),(2660121),(1638661),(1622470),(1636022),(1625303),(1625445),(1634090),(1620709),(1637479),(2659058),(1626974),(1635060),(6356118),(1633506),(1621340),(1620627),(1622610),(1634574),(43384756),(1633679),(1633887),(2661087),(3213231),(1619305),(1625784),(1632798),(1624206),(42449618),(39952619),(1634459),(42105627),(1623678),(1622914),(1621213)
Parameters:
[] |
3.28 ms (0.01%) |
1 |
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(757)
Parameters:
[] |
2.02 ms (0.01%) |
1 |
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:
[] |
1.89 ms (0.00%) |
29 |
DROP TABLE IF EXISTS `steiermark`.accoIdsTowns; DROP TABLE IF EXISTS `steiermark`.productIdsTowns;
Parameters:
[] |
1.10 ms (0.00%) |
1 |
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:
[] |
1.09 ms (0.00%) |
1 |
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:
[] |
1.02 ms (0.00%) |
1 |
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:
[] |
0.84 ms (0.00%) |
1 |
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:
[] |
0.63 ms (0.00%) |
1 |
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:
[] |
0.61 ms (0.00%) |
1 |
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:
[] |
0.53 ms (0.00%) |
1 |
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:
[] |
0.42 ms (0.00%) |
1 |
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:
[] |
0.34 ms (0.00%) |
1 |
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:
[] |
0.34 ms (0.00%) |
1 |
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:
[] |
0.31 ms (0.00%) |
1 |
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:
[] |
0.31 ms (0.00%) |
1 |
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:
[] |
0.31 ms (0.00%) |
1 |
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:
[] |
0.31 ms (0.00%) |
1 |
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:
[] |
0.29 ms (0.00%) |
1 |
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:
[] |
0.29 ms (0.00%) |
1 |
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:
[] |
0.29 ms (0.00%) |
1 |
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:
[] |
0.28 ms (0.00%) |
1 |
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:
[] |
0.27 ms (0.00%) |
1 |
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:
[] |
0.27 ms (0.00%) |
1 |
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:
[] |
0.26 ms (0.00%) |
1 |
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:
[] |
0.26 ms (0.00%) |
1 |
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:
[] |
0.25 ms (0.00%) |
1 |
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:
[] |
0.22 ms (0.00%) |
1 |
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:
[] |
0.22 ms (0.00%) |
1 |
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:
[] |
0.17 ms (0.00%) |
1 |
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:
[] |
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.