Query Metrics

107 Database Queries
20 Different statements
58.44 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.47 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/klostertal/de/akiv-sein/"
  "winter-schneeschuhwandern"
]
2 0.78 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  203
]
3 0.47 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
4 0.63 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/klostertal/de/akiv-sein/winter-schneeschuhwandern"
  "path"
  "auto_create"
  "/klostertal/de/akiv-sein/winter-schneeschuhwandern"
  "path_query"
  "https://alpenregion-staging.conecto.rocks/klostertal/de/akiv-sein/winter-schneeschuhwandern"
  "entire_uri"
]
5 0.37 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
6 0.58 ms
SELECT * FROM object_url_slugs WHERE slug = '/klostertal/de/akiv-sein/winter-schneeschuhwandern' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
7 0.59 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  1016
]
8 1.06 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  1016
]
9 0.32 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  203
]
10 0.40 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  203
  203
  203
]
11 0.36 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "de"
]
12 0.32 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "en"
]
13 0.66 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,10) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  18
]
14 0.36 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  18
]
15 0.56 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
16 0.60 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  18
]
17 0.40 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  18
]
18 0.47 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,10) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  18
]
19 0.46 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  5624
]
20 0.44 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  5624
]
21 1.10 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,4793,4831) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  5624
]
22 0.79 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  203
]
23 0.53 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  203
  203
  203
]
24 0.79 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "weather"
]
25 0.63 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "vcloud_tour"
]
26 1.09 ms
SELECT * FROM object_relations_vcloud_tour WHERE src_id = ?
Parameters:
[
  4023
]
27 0.76 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "vcloud_poi"
]
28 0.90 ms
SELECT * FROM object_relations_vcloud_poi WHERE src_id = ?
Parameters:
[
  5608
]
29 0.45 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "vcloud_concept"
]
30 0.47 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  4853
]
31 0.42 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  4872
]
32 0.43 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  8005
]
33 0.44 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "klostertal"
]
34 0.42 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  102
]
35 0.70 ms
SELECT * FROM object_relations_vcloud_poi WHERE src_id = ?
Parameters:
[
  2797
]
36 0.53 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  8001
]
37 0.60 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  102
]
38 0.75 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "CNMAG_ARTICLE"
]
39 0.68 ms
SELECT * FROM object_relations_CNMAG_ARTICLE WHERE src_id = ?
Parameters:
[
  86
]
40 0.55 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4662
]
41 0.53 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4662
]
42 0.68 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  1017
]
43 0.60 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  1017
]
44 0.43 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
45 1.09 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__412044f827e52e05424b1b973f3d9301"
]
46 0.39 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
47 0.37 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__0fc798c3cc9ae02c50cdfcc45872a465"
]
48 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
49 0.35 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__26f88988b893b930102aa5185e7053d7"
]
50 0.34 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
51 0.40 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__3d87cb846973eede05741bcd3f0507ba"
]
52 0.31 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
53 0.75 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__5743d503f8957c5f04b2d26a83fb8694"
]
54 0.34 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
55 0.32 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__2aff1f223b555e7f256938e931b52834"
]
56 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
57 0.69 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__b3497eef8d05bdd7bcaed5a9d7bdefc3"
]
58 0.40 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
59 0.37 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__559164cd8f15ec13fd8410eb466846dd"
]
60 0.31 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
61 0.32 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__3d46f18e5d719965cf34b3d3f51f0a26"
]
62 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
63 0.66 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__f636d72a194174334bbce65c738bf6f0"
]
64 0.54 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
65 0.47 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__20b0afb3fe19b0dd9dfdc4247d4179b1"
]
66 0.63 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
67 0.75 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__3d8d7d201f261f03ca6339b155160899"
]
68 0.46 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
69 0.43 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__468cabcc360d9e0e1660d5f4f094a865"
]
70 0.42 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
71 1.15 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__5b877e4ebc240bbceb5fd4c0f9c5ac77"
]
72 0.60 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
73 0.56 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__6a1ba110526ef088edf9f05f410d742c"
]
74 0.46 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
75 0.39 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__46fd8fa889dc43093b1798d0db202295"
]
76 0.46 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
77 0.96 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__d8f022a7a110b427eecbc83f4c379b7e"
]
78 0.44 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
79 0.39 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__a800c0a5f10fac255d41e5794477c6d4"
]
80 0.32 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
81 0.71 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__879dab2e7d4db4543accd5cb9a74b07f"
]
82 0.40 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
83 0.39 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__07946079052a904c9be8d8235d73bfd3"
]
84 0.33 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
85 0.32 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__943e6d0ef80db997d2a92874c78f091a"
]
86 0.31 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
87 0.39 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__e37e880a1285cd6a192662f2e0049642"
]
88 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
89 0.40 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__436d66a0c935e16eb95c23223ef86e80"
]
90 0.45 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
91 0.30 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__9547b0e36391741590e4730d29de9d92"
]
92 0.38 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
93 0.56 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__526facbf0fa4f44cbe87b82d45b0d77c"
]
94 0.35 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
95 0.40 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__79b7aeb1d52b27f8fcbb764e8f571829"
]
96 0.40 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
97 0.39 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__77ca758a8c757770eb3a653949a54e90"
]
98 0.37 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
99 0.43 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__79b7aeb1d52b27f8fcbb764e8f571829"
]
100 0.44 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-78_1"
  "pimcore_image_thumbnails"
]
101 0.39 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1017__526facbf0fa4f44cbe87b82d45b0d77c"
]
102 0.61 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
103 0.79 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=de&_format=html&_controller=CONECTO%5CProviderBundle%5CController%5CDocumentController%3A%3AfooterSnippetAction"
  "path_query"
  "https://alpenregion-staging.conecto.rocks/_fragment?_path=_locale=de&_format=html&_controller=CONECTO%5CProviderBundle%5CController%5CDocumentController%3A%3AfooterSnippetAction"
  "entire_uri"
]
104 0.56 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  108
]
105 1.08 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  503
]
106 1.34 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  503
]
107 2.30 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,502,20) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  503
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping