Query Metrics
104
Database Queries
25
Different statements
148.02 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
39.70 ms (26.82%) |
1 |
select o_id,contentScore,priority,bookable from object_8 where o_published = 1
Parameters:
[] |
|
36.68 ms (24.78%) |
1 |
select o_id as id, position__longitude as lon, position__latitude as lat from object_8 WHERE position__longitude IS NOT NULL AND position__latitude IS NOT NULL
Parameters:
[] |
|
3.32 ms (2.24%) |
14 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
9975
]
|
|
2.51 ms (1.70%) |
30 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
|
2.09 ms (1.41%) |
14 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 889419 ] |
|
0.96 ms (0.65%) |
7 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
|
0.79 ms (0.53%) |
7 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Accomodations-search-book" "path" => "/steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/" ] |
|
0.77 ms (0.52%) |
5 |
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/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book" ] |
|
0.64 ms (0.44%) |
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.50 ms (0.34%) |
5 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book" ] |
|
0.44 ms (0.29%) |
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/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book" "sourcePathQuery" => "/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book?nearbySearchId=32148397&nearbySearchLat=47.5319&nearbySearchLong=14.06544&sorting=nearbySearchAsc&page=4&randSeed=359" "sourceEntireUri" => "https://stage.steiermark.com/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book?nearbySearchId=32148397&nearbySearchLat=47.5319&nearbySearchLong=14.06544&page=4&randSeed=359&sorting=nearbySearchAsc" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
|
0.38 ms (0.26%) |
2 |
SELECT id FROM sites
Parameters:
[] |
|
0.37 ms (0.25%) |
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:
[
11462
]
|
|
0.32 ms (0.21%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 9975 9975 ] |
|
0.25 ms (0.17%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
9975
]
|
|
0.24 ms (0.16%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/steiermark.com//en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.24 ms (0.16%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 9667 9975 9975 ] |
|
0.18 ms (0.12%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.15 ms (0.10%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book' AND (siteId = 6 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.14 ms (0.10%) |
2 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
|
0.12 ms (0.08%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/en/Ausseerland-Salzkammergut/Plan-your-holidays/Accomodations-search-book' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.11 ms (0.08%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
|
0.10 ms (0.07%) |
1 |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_staticroutes"
]
|
demi_vacancies connection
| Time▼ | Count | Info |
|---|---|---|
|
52.12 ms (35.21%) |
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 (15187823,1821629,2454928,1615279,2457968,1615985,2458220,45582974,2455138,1905920,2194164,1615080,2457048,1615533,1906766,2530034,2418919,1612780,1905939,2456895,2457291,1906901,49758724,49723102,12176479,11993543,1615295,18743469,7452995,51238225,1615721,1703009,2456405,12141191,16552093,50330123,18778011,1616532,2104858,31116629,18743311,2104824,7453079,1821580,2368235,1702930,1614903,1615125,2458372,1616159,11993491,2457590,29850681,7453009,1906621,2457393,41643929,1905902,1612739,1612675,1616284,1616459,1906002,4062032,18861848,40480657,1616103,30806616,7449751,1616259,9684290,1906196,1616367,1615234,50330129,9159056,7453183,6342567,9490401,4820748,2104811,2458128,2459142,1615749,1930161,1616205,1615196,2457171,2457782,49522274,25114536,7452883,1612643,1612937,2104791,1930324,1615308,18776567,2458180,2458151,2453674,12076233,14957863,44781292,1614803,2457417,1616296,1821748,32203081,1906816,2457153,18777721,2458255,45468398,1821716,4062193,30192347,7452890,7453114,1612792,2458404,2194032,1614830,7452876,1616447,9490392,1616414,50613474,50062232,1930178,2457931,1821641,1930310,2458981,1906838,1612661,2457118,7453190,34613565,4063767,1613053,32662482,2458533,2457804,1614871,11825924,7453023,2194020,2455301,2457179,46121793,42085312,12141175,27961045,30629016,18721781,6995557,2459254,2457950,32396816,1821686,12076227,1615695,18776406,4442120,3032193,17197373,2529886,1615208,2458171,2104901,34043087,1614837,2453987,1906021,1907399,7453225,22817521,1616440,1906028,16993556,32043299,1616087,18743300,2454173,1702966,1906343,1616507,1612798,40649956,1612628,1615997,1612819,9651389,2458008,2530031,1821791,1616601,2453569,2453876,2455657,2457650,7162763,7453204,35259362,1905966,2310347,27998615,7453121,2404244,32356610,38702048,2454738,2104401,1821979,1615164,1612950,40935234,1615159,1906009,2530046,6775712,18776659,31116650,1616614,1930243,11993564,1613214,1612993,1615872,1612667,1612928,2458073,29827678,1907248,2458159,1612870,19739002,50062229,2529904,2457195,13169002,1615680,1612876,15136325,1616423,1612986,2829775,2368223,1615580,1821772,2454304,39952681,1616557,1821723,2404275,4062000,1616081,34595469,1612635,1930118,2458389,1821730,2457544,7453169,1905995,2104726,44079175,18777978,7452932,26147003,18777956,1615005,19763638,3213244,7452939,1615966,1821823,18743289,2310269,2459044,1906454,7452918,46904062,18777989,32356605,2104878,2455032,2453896,38973570,15028571,1616336,2456321,2455321,2455815,1930330,1906418,1821692,1821836,1906852,24874128,2059036,10223870,1906561,1616313,1612861,1821635,45911208,2457105,2530049,2454859,2457442,7453176,1930168,2457980,2459068,9735393,2454764,24109335,1821698,1616142,7453107,1612687,1905888,1614778,18776417,1612971,1930130,2458503,48208705,2458357,2458552,1906328,7453058,7453030,7453016,1821861,2104885,1616381,1702996,2310272,46837228,2309712,2455960,40066871,50330126,1906119,2104798,7452974,2455620,2529898,31439157,2457665,1906249,7452988,1614785,1615674,18777967,2104865,1612655,1906035,1821814,7452925,27858940,13205136,18777666,1821623,2457960,31116045,1614843,1616483,18743458,2457137,27961048,2529883,4062067,1907049,7453128,1822005,1821596,18743447,1613013,18776639,1613127,1821680,2457844,42339673,12736708,27858937,1906788,2455852,11993576,12212021,2454613,1615731,38954139,1906171,1822030,46648161,18743480,7453197,2457353,8924349,2310556,1615178,48320437,2104851,18777699,13734739,1615503,2457187,45886154,2457450,1906073,42766841,2194150,7453051,2458065,1612889,1616197,34613539,2309376,1615619,1906696,1906859,30192336,32996115,1906157,7453065,1612855,7452960,6208703,1613120,13415036,1615743,2454264,8924340,37260090,47650472,7453072,24629767,1906112,18094541,31116495,2309544,4062249,2458228,1612621,7453002,1821868,2458412,1616235,15115425,1906202,9566387,4149203,16192461,2194142,18777655,4062019,2308760,44735018,1615738,18777677,1615509,31116285,11644081,1615272,2456727,7453218,1614918,49619462,1905954,7452967,2459391,1612964,2456271,1616585,50660470,12771836,4063718,1615547,21905908,2458294,1907413,1702924,2457463,2457536,47698722,22968535,1906066,10990613,1613190,7453211,1906795,1907111,2457692,31569228,1906297,1906052,48319918,2454119,18776428,4062325,18755389,18777688,48753192,43139185,2308773,1906305,1907427,1616047,1615202,45167318,31116306,1612882,16463906,1821807,1821899,12785402,12665315,1906432,47698731,2458424,1822022,25076569,7576136,1906719,1615773,2458323,2458494,1615601,6645761,4063709,2456499,2457241,1616323,27090024,4090781,21285943,2310457,1616117,1614713,2457383,1821893,13468069,1907420,4062128,2104688,1616374,1906546,1613038,2530028,1616498,1906635,1906873,23827352,2456775,1614910,6645739,2458339,2456579,18777710,31159117,2456969,1906263,4062035,1906508,47840451,41643953,7452946,2458331,46703369,1615522,7452953,1616225,6342564,40066879,1702984,1612807,1616249,1905927,1821737,12578480,1906916,25851748,2457774,2458107,8776246,2529880,1906356,2458788,1616053,1907362,1612895,2458275,2456108,1616351,51735516,1615663,7453044,44760927,1822011,2457621,12578470,9238291,3121111,1906747,1612786,2455156,2457556,2455688,1821955,35677466,7453135,1906802,1906044,2457275,2458566,18778000,18541017,19763596,1615991,2530025,7453037,4062004,4704521,1613183,51333826,18776174,2454904,1906601,2456978,2454161,2453808,1612831,1616064,1613197,1906079,1907143,2458056,2454097,2309430,7452869,14055216,1930304,3259747,47650481,2454032,1821779,18777644,1821740,2310359,2458381,1616360,11106490,2454461,11993553,1906209,1821849,39621948,2104698,27167031,49289508,15221891,1614616,32043296,29699643,1703035,41003922,2458035,1614767,2456765,2458026,2104833,1614854,2457214,1615228,1906189,1821762,2457632,1907329,2458315,1616477,1906059,9108294,1616514,1616174,1821963,1615190,39249742,1612615,2456436,11993589,18411811,2458779,39976679,40480654,15136578,2453840,4062044,2456226,2457745,20926241,15154165,2456747,2454629,31116608,19763617,1907004,2456739,9566396) 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:
[] |
|
4.89 ms (3.30%) |
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 (11465, 11466, 11464, 11463, 1612603)) GROUP BY dacco.oo_id ORDER BY RAND(359)
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.