GET https://alpenregion-staging.conecto.rocks/brandnertal/de/unsere-vielfalt/aktiv/schwimmen

Query Metrics

123 Database Queries
23 Different statements
61.20 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.45 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/brandnertal/de/unsere-vielfalt/aktiv/"
  "schwimmen"
]
2 1.47 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  284
]
3 0.39 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
4 0.73 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:
[
  "/brandnertal/de/unsere-vielfalt/aktiv/schwimmen"
  "path"
  "auto_create"
  "/brandnertal/de/unsere-vielfalt/aktiv/schwimmen"
  "path_query"
  "https://alpenregion-staging.conecto.rocks/brandnertal/de/unsere-vielfalt/aktiv/schwimmen"
  "entire_uri"
]
5 0.37 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
6 2.47 ms
SELECT * FROM object_url_slugs WHERE slug = '/brandnertal/de/unsere-vielfalt/aktiv/schwimmen' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
7 2.18 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,1901,664,663,662,661) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  2787
]
8 0.78 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  2787
]
9 0.44 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  2787
]
10 1.00 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  284
]
11 0.49 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  284
  284
  284
]
12 0.90 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "de"
]
13 0.36 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "en"
]
14 0.58 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,10) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  16
]
15 0.36 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  16
]
16 0.47 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
17 0.53 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,10) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  16
]
18 0.43 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  440
]
19 0.43 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  440
]
20 0.54 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,429,323,20) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  440
]
21 0.53 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  284
]
22 0.51 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  284
  284
  284
]
23 0.51 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "weather"
]
24 0.48 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "CNMAG_ARTICLE"
]
25 0.46 ms
SELECT * FROM object_relations_CNMAG_ARTICLE WHERE src_id = ?
Parameters:
[
  4401
]
26 0.32 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3006
]
27 0.42 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3006
]
28 0.49 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "vcloud_poi"
]
29 0.84 ms
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
  3271
]
30 0.60 ms
SELECT * FROM object_collection_vcloudOpeningHours_vcloud_poi WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  2950
  "openingHours"
]
31 1.01 ms
SELECT * FROM object_collection_vcloudOpeningHours_localized_vcloud_poi WHERE ooo_id = ? AND language IN ('de','en') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  2950
  "openingHours"
  0
]
32 1.07 ms
SELECT * FROM object_relations_vcloud_poi WHERE src_id = ?
Parameters:
[
  2950
]
33 0.35 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "vcloud_concept"
]
34 0.36 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  4853
]
35 0.73 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  4879
]
36 2.43 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "brandnertal"
]
37 0.35 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  56
]
38 0.68 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  56
]
39 0.43 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  24637
]
40 0.44 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  24637
]
41 0.33 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
42 0.87 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__a447fbb998fee9d260865efe2607316d"
]
43 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
44 0.76 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__13143c9c641e90c66da402dd0227f6d2"
]
45 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
46 0.71 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__f345ccef242738c50f13b6b7cfda6e4c"
]
47 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
48 0.81 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__2904e7685927012737ff0a837362cd01"
]
49 0.26 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
50 1.13 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__76f36e9b74db84afda28064cbc642820"
]
51 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
52 0.35 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__26f9be96591806384e7dd47de733155f"
]
53 0.28 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
54 0.39 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__198844b70eb74260586bd1e195202d58"
]
55 0.33 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
56 0.30 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__1eb7b6ecddcd6e43d9486a6cffa9fafa"
]
57 0.28 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
58 0.35 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__8ef0781975e3331a1e26bb7d80b882fa"
]
59 0.31 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
60 0.27 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__6acfa5e64923821721296ed9c17cae64"
]
61 0.26 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
62 0.31 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__c9d97dd2ff46f6680abd23478bc4a2d6"
]
63 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
64 0.33 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__ebca6212ce2ec3c845fab0a9ccd12e3b"
]
65 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
66 0.28 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__b36ac9bf02664ccc30fa9ea5925f1bb6"
]
67 0.26 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
68 0.32 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__7ff03cecebc16bdd89d7c48e50f8b6c5"
]
69 0.32 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
70 0.29 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__de226141da5ac975c05b58196c005e78"
]
71 0.26 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
72 0.27 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__a950b086f83e8ce8928e166accf7e1b5"
]
73 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
74 0.31 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__9ccf4eda6482ba162b323513c4627f16"
]
75 0.28 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
76 0.28 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__63c49cc620fc3d66f879b82b366fa1d1"
]
77 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
78 0.24 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__fb28b17414f1cdef8414109a297f3276"
]
79 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
80 0.26 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__0187f8b5026acc32d5346c5032be99ce"
]
81 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
82 0.30 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__2c0d8f8578f0e10793decb48c589783a"
]
83 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
84 0.36 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__964f155a96f5f1e94d5088df5b65716f"
]
85 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
86 0.29 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__d42a969113ce744dd94ba806f3270350"
]
87 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
88 0.32 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__3c0373f4fcc9abcc6ef095ee5bc0a454"
]
89 0.33 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
90 0.30 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__9c8307161d404c41817b1713efd611aa"
]
91 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
92 0.37 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__95b32bfb46c498510548293803285a05"
]
93 0.32 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
94 0.32 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__9c8307161d404c41817b1713efd611aa"
]
95 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
96 0.34 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__63582a8e43fd0f60fe5f1ac6cb96f801"
]
97 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
98 0.35 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__beea2b7f8b3642d17cdaaabc90079d85"
]
99 0.26 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
100 0.31 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__63582a8e43fd0f60fe5f1ac6cb96f801"
]
101 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
102 0.34 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__9c8307161d404c41817b1713efd611aa"
]
103 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
104 0.31 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__9c8307161d404c41817b1713efd611aa"
]
105 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "teaserDefault_1-78_3"
  "pimcore_image_thumbnails"
]
106 0.32 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_24637__95b32bfb46c498510548293803285a05"
]
107 0.29 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  56
]
108 0.26 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  56
]
109 0.27 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  56
]
110 0.29 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  56
]
111 0.31 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  56
]
112 0.60 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
113 0.83 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"
]
114 0.63 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  66
]
115 0.54 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  338
]
116 0.40 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  338
]
117 0.53 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,328,323,20) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  338
]
118 1.33 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
119 1.17 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"
]
120 1.13 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  766
]
121 0.59 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  329
]
122 0.53 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  329
]
123 0.57 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,328,323,20) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  329
]

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