GET https://alpenregion-staging.conecto.rocks/offenelifte

Query Metrics

115 Database Queries
20 Different statements
158.90 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.24 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "offenelifte"
]
2 0.23 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/offenelifte"
]
3 2.11 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  191
]
4 2.52 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
5 2.16 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:
[
  "/offenelifte"
  "path"
  "auto_create"
  "/offenelifte"
  "path_query"
  "https://alpenregion-staging.conecto.rocks/offenelifte"
  "entire_uri"
]
6 0.21 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
7 0.34 ms
SELECT * FROM object_url_slugs WHERE slug = '/offenelifte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
8 2.75 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  2670
]
9 1.68 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  2670
]
10 0.53 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  191
]
11 2.82 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  191
  191
  191
]
12 0.79 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "de"
]
13 3.81 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "en"
]
14 1.00 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,10) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  15
]
15 0.97 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  15
]
16 0.86 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
17 2.01 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  15
]
18 1.04 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  15
]
19 0.47 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,10) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  15
]
20 0.88 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  441
]
21 0.46 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  441
]
22 0.44 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,429,323,20) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  441
]
23 3.56 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  191
]
24 0.47 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  191
  191
  191
]
25 0.34 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "weather"
]
26 1.05 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  1713
]
27 0.46 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  1713
]
28 3.16 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "vcloud_event"
]
29 0.55 ms
SELECT * FROM object_relations_vcloud_event WHERE src_id = ?
Parameters:
[
  4303
]
30 2.01 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "vcloud_concept"
]
31 0.27 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  4853
]
32 0.30 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  4856
]
33 0.25 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  8002
]
34 0.25 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "brandnertal"
]
35 3.01 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  56
]
36 0.47 ms
SELECT * FROM object_relations_vcloud_event WHERE src_id = ?
Parameters:
[
  4585
]
37 0.30 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  4877
]
38 0.29 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  8006
]
39 2.62 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  56
]
40 0.45 ms
SELECT * FROM object_relations_vcloud_event WHERE src_id = ?
Parameters:
[
  4588
]
41 0.29 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  4879
]
42 0.26 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  56
]
43 2.94 ms
SELECT * FROM object_relations_vcloud_event WHERE src_id = ?
Parameters:
[
  4308
]
44 1.99 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  56
]
45 0.43 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,13553,13367,4791,4831) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  13557
]
46 0.30 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  13557
]
47 0.43 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  13557
]
48 0.26 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
49 1.64 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__2c25fbf3ddde6cba1c70435f767e2547"
]
50 2.22 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
51 1.00 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__c6d76734fe30c7fb31792e0a832ed539"
]
52 2.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
53 0.73 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__0df786aa332d67b70e2eab6568fa64f6"
]
54 0.90 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
55 1.18 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__4ae48c5976d2ff6183ed87f9ca0680f6"
]
56 2.08 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
57 1.75 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__7f0b50b8411a21e0e1d58b3c8530a887"
]
58 1.40 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
59 1.30 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__91d8374515d966132340d528434ca69e"
]
60 2.68 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
61 3.58 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__3c975788c24f0762d7f7f6a593e3bde7"
]
62 1.72 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
63 2.33 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__cf69b01216c4dc2a18be4261f0db623d"
]
64 1.92 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
65 0.74 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__220ffb2ceb323ad36fa1472878003abe"
]
66 1.20 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
67 2.60 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__4d9c4887d368c9a9632ceaf373ce42fa"
]
68 2.32 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
69 1.37 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__21ebe6cf47165302d608e2fe2eb813be"
]
70 2.90 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
71 2.45 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__bffd3f41ffe0681f73682bfdb774d575"
]
72 0.93 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
73 1.83 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__24d0914e3d44a9c2ea872e940f660157"
]
74 1.41 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
75 1.26 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__9209b73c05a0044fa9e1d6a369f8d90f"
]
76 2.91 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
77 1.50 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__46c5d5699697a51c97fb5ada17d34424"
]
78 1.28 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
79 1.27 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__46e48d1f149d37025e06a4b70aaea626"
]
80 1.11 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
81 1.74 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__1a6630c9fd353f8426378d50e332bca2"
]
82 1.62 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
83 1.83 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__7a9c814fed251ab8ef9454739bf2e660"
]
84 2.60 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
85 1.38 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__2671bb6f5b9fcc53acaceb2f4ed5140b"
]
86 0.96 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
87 0.83 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__aa7e555e20502aea060862a75a0c0562"
]
88 2.67 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
89 1.55 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__15d73d82e8d7bc50df45ae77ed4283d1"
]
90 0.45 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
91 1.39 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__ed45f26a0abb03fa8b41ed3d687f4b24"
]
92 0.93 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
93 1.11 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__0df61640bb7c0cd2dc4df9f1141f4015"
]
94 1.35 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
95 0.89 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__216aea7d59994db57f8f8620e1782209"
]
96 3.09 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
97 1.90 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__89150eb94087a59ce09a0a0bbcfa2cf7"
]
98 1.20 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
99 1.26 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__f8397ab1ad5748cd414d2b30999d2b98"
]
100 1.90 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
101 0.51 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__89150eb94087a59ce09a0a0bbcfa2cf7"
]
102 1.01 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-5_2"
  "pimcore_image_thumbnails"
]
103 0.90 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_13557__216aea7d59994db57f8f8620e1782209"
]
104 0.40 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
105 1.52 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"
]
106 0.93 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  36
]
107 1.55 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  13535
]
108 0.33 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  13535
]
109 0.50 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,13532,13367,4791,4831) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  13535
]
110 0.36 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
111 0.64 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=App%5CController%5CDefaultController%3A%3AregionMapSnippetAction"
  "path_query"
  "https://alpenregion-staging.conecto.rocks/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AregionMapSnippetAction"
  "entire_uri"
]
112 4.33 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  766
]
113 0.44 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  434
]
114 1.11 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  434
]
115 2.89 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,429,323,20) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  434
]

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