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