Query Metrics

236 Database Queries
79 Different statements
150.49 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.27 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/en/"
  "accessible-enjoy-the-great-view-on-the-panorama-walk_vc4921"
]
2 0.27 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/en/accessible-enjoy-the-great-view-on-the-panorama-walk_vc4921"
]
3 0.21 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "en"
]
4 0.49 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  2
]
5 1.36 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
6 0.70 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:
[
  "/en/accessible-enjoy-the-great-view-on-the-panorama-walk_vc4921"
  "path"
  "auto_create"
  "/en/accessible-enjoy-the-great-view-on-the-panorama-walk_vc4921"
  "path_query"
  "https://montafon-staging.conecto.rocks/en/accessible-enjoy-the-great-view-on-the-panorama-walk_vc4921"
  "entire_uri"
]
7 1.32 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
8 0.44 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/en/"
  "accessible-enjoy-the-great-view-on-the-panorama-walk_vc4921"
]
9 0.39 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/en/accessible-enjoy-the-great-view-on-the-panorama-walk_vc4921"
]
10 0.38 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "vcloud_tour"
]
11 2.39 ms
SELECT * FROM object_relations_vcloud_tour WHERE src_id = ?
Parameters:
[
  4921
]
12 0.44 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "vcloud_concept"
]
13 0.60 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  19
]
14 1.54 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  56728
]
15 0.98 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  56728
]
16 0.41 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  19
]
17 0.42 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  19
  19
  19
]
18 0.24 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "de"
]
19 0.77 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "nl"
]
20 0.28 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "fr"
]
21 0.31 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/fr"
]
22 0.41 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
23 0.42 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
24 0.26 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  8
]
25 0.45 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  8
]
26 0.30 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,2) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  8
]
27 0.25 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  19
]
28 0.37 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  19
  19
  19
]
29 0.23 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "fr"
]
30 0.19 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/fr"
]
31 2.00 ms
SELECT dependencies.targetid,dependencies.targettype
            FROM dependencies
            LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.id
            LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id
            LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id
            WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ?
            ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[
  4921
  "object"
]
32 0.47 ms
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies
            LEFT JOIN objects ON dependencies.sourceid=objects.id AND dependencies.sourcetype="object"
            LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset"
            LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document"
            WHERE dependencies.targettype = ? AND dependencies.targetid = ?
            ORDER BY objects.path, objects.key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[
  "object"
  4921
]
33 1.37 ms
SELECT * FROM object_collection_vcloudContentblock_vcloud_tour WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  4921
  "contentblocks"
]
34 1.98 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  0
]
35 0.26 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  0
Parameters:
[]
36 0.60 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  0
Parameters:
[]
37 0.42 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  0
Parameters:
[]
38 0.26 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  0
Parameters:
[]
39 1.05 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  1
]
40 0.23 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  1
Parameters:
[]
41 0.52 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  1
Parameters:
[]
42 0.25 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  1
Parameters:
[]
43 0.38 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  1
Parameters:
[]
44 0.98 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  2
]
45 0.36 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  2
Parameters:
[]
46 0.53 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  2
Parameters:
[]
47 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  2
Parameters:
[]
48 0.29 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  2
Parameters:
[]
49 0.45 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  3
]
50 0.24 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  3
Parameters:
[]
51 0.21 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  3
Parameters:
[]
52 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  3
Parameters:
[]
53 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  3
Parameters:
[]
54 0.44 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  4
]
55 0.21 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  4
Parameters:
[]
56 0.22 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  4
Parameters:
[]
57 0.19 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  4
Parameters:
[]
58 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  4
Parameters:
[]
59 0.45 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  5
]
60 0.26 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  5
Parameters:
[]
61 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  5
Parameters:
[]
62 0.23 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  5
Parameters:
[]
63 0.19 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  5
Parameters:
[]
64 0.41 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  6
]
65 0.23 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  6
Parameters:
[]
66 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  6
Parameters:
[]
67 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  6
Parameters:
[]
68 0.18 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  6
Parameters:
[]
69 0.51 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  7
]
70 0.22 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  7
Parameters:
[]
71 0.22 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  7
Parameters:
[]
72 0.21 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  7
Parameters:
[]
73 0.23 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  7
Parameters:
[]
74 0.43 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  8
]
75 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  8
Parameters:
[]
76 0.21 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  8
Parameters:
[]
77 0.25 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  8
Parameters:
[]
78 0.21 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  8
Parameters:
[]
79 0.45 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  9
]
80 0.22 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  9
Parameters:
[]
81 0.19 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  9
Parameters:
[]
82 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  9
Parameters:
[]
83 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  9
Parameters:
[]
84 0.44 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  10
]
85 0.21 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  10
Parameters:
[]
86 0.21 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  10
Parameters:
[]
87 0.19 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  10
Parameters:
[]
88 0.22 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  10
Parameters:
[]
89 0.50 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  11
]
90 0.24 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  11
Parameters:
[]
91 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  11
Parameters:
[]
92 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  11
Parameters:
[]
93 0.19 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  11
Parameters:
[]
94 0.41 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  12
]
95 0.22 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  12
Parameters:
[]
96 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  12
Parameters:
[]
97 0.20 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  12
Parameters:
[]
98 0.19 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  12
Parameters:
[]
99 0.43 ms
SELECT * FROM object_collection_vcloudContentblock_localized_vcloud_tour WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  4921
  "contentblocks"
  13
]
100 0.21 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'de' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  13
Parameters:
[]
101 0.21 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'en' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  13
Parameters:
[]
102 0.19 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'fr' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  13
Parameters:
[]
103 0.21 ms
select `links` from object_collection_vcloudContentblock_localized_vcloud_tour where language = 'nl' and  ooo_id  = 4921 and fieldname = 'contentblocks' and `index` =  13
Parameters:
[]
104 0.20 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "vcloud_safety_tip"
]
105 0.36 ms
SELECT * FROM object_collection_vcloudExternalLink_vcloud_safety_tip WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  7155
  "externalLinks"
]
106 0.55 ms
SELECT * FROM object_collection_vcloudExternalLink_localized_vcloud_safety_tip WHERE ooo_id = ? AND language IN ('de','en','nl','fr') AND `fieldname` = ? AND `index` = ?
Parameters:
[
  7155
  "externalLinks"
  0
]
107 0.93 ms
SELECT * FROM object_collection_vcloudExternalLink_vcloud_tour WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[
  4921
  "externalLinks"
]
108 0.39 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
109 1.44 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__ff2b0ec7398eb77deb09c6fb05b90705"
]
110 0.18 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
111 0.60 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__0abed5f27ab33c4f3ab086110837732d"
]
112 0.91 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
113 2.32 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__14d0a3b4eec9b73bd1066d8a8dc0d0db"
]
114 0.49 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
115 1.05 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__a9ffab638d6e414e6e45416a700f8ca0"
]
116 0.57 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
117 0.73 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__36053af59f993fe9bfff9015d77e0305"
]
118 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
119 0.59 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__439412136b9d334f01c8aea53ebed879"
]
120 1.46 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
121 0.30 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__da8691268d1943d5e817b5f02c034294"
]
122 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
123 0.20 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__4a17eb81bba96fd20ea2f1c0405a2b35"
]
124 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
125 0.24 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__57d480040b4734e206311d670dfb92ce"
]
126 1.63 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
127 0.23 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__07486a52e1d9520b2550f8754bcd9724"
]
128 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
129 0.36 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__3b66d18cbc2826af6b085a51edd1d389"
]
130 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
131 0.76 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__e4efe8f3caff091ec0863c023b55196a"
]
132 0.24 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
133 0.23 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__53e67b31bc926e21b144408ddbbd6ce6"
]
134 0.40 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
135 3.82 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__6fbac5d70fc947d126a337a4c0ac3168"
]
136 8.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
137 0.28 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__2f2b2d57fb25a2a8f81303635b4fe045"
]
138 0.23 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
139 0.21 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__362406dbc00cf0e0f77ac06ad656f9e4"
]
140 2.70 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
141 4.80 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__a62d8044a69356ca4988d560d1a5a755"
]
142 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
143 3.50 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__620a51e57cbe4eb5a42a622511df3e22"
]
144 4.46 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
145 2.91 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__7d9bb67811bd8d1b12909bd87d5755dd"
]
146 4.68 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
147 4.54 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__b01539a4e3b9651f6c53d58969324162"
]
148 0.25 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
149 0.25 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__61679de7691101b5ae4c05c4a359ae5f"
]
150 3.23 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
151 0.65 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__36d422fb676b88a4d305c4b605dff4df"
]
152 3.64 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
153 3.79 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__221e519518d4461a1fae72088a5430c4"
]
154 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
155 0.22 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__064248467485f5cb9b30644891bd9ca6"
]
156 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
157 0.22 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__02d42b8321085ec56078493fdb61db1a"
]
158 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
159 0.20 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_56728__064248467485f5cb9b30644891bd9ca6"
]
160 2.89 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  68366
]
161 0.82 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  68366
]
162 0.22 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
163 1.41 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__2906900f03d129a02eb3b7b089a42567"
]
164 0.20 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
165 1.38 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__77f6881f3a06b1db520253dc46383f1c"
]
166 0.22 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
167 0.20 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__184565bb29cee483913641d1a4c07f2f"
]
168 0.23 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
169 0.27 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__75dce28b0cdf3b458328b59db1f9cf04"
]
170 1.23 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
171 1.26 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__df1e40bc2342aa2580f6ddd872fdf429"
]
172 0.49 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
173 1.97 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__b202ac49e2245fa367fa203287ebf764"
]
174 0.22 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
175 0.19 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__d24c4fdb560b558dbae86879149ac586"
]
176 0.20 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
177 0.25 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__b0e93e71cae281779151123c97f949bd"
]
178 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
179 0.93 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__9a1d961f88d7f0b5bff4a627b0f36441"
]
180 0.28 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
181 0.20 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__2b778663a00e504de909c5265a4cb330"
]
182 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
183 0.72 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__6254ea4c22de331146aecde0f8cbbcc6"
]
184 0.23 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
185 2.29 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__34b790291a457c18539fe94c0e347bae"
]
186 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
187 0.23 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__baf17fba9d545c43dc7a932301b44bc7"
]
188 0.32 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
189 0.36 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__badf149a89e68977f64ff28c1de96e69"
]
190 0.19 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
191 0.21 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__f6cc801f664af8da0e05283151430d72"
]
192 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
193 0.19 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__e60e1c0f71c6f41b331974d565f86287"
]
194 0.20 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
195 0.20 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__91dd1d02b364959a3d14f92b876b9ece"
]
196 0.19 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
197 0.20 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__33d09c5b1182be654c32b843a3b1e5df"
]
198 0.24 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
199 0.19 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__f41db51763f49f46153551d003ccbc2a"
]
200 0.19 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
201 0.23 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__5e97b25dbc76f81e5969421c39381019"
]
202 0.18 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
203 0.21 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__083c541603933605055660e09695d4e7"
]
204 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
205 0.23 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__fcb37776b8752694344597dfcd43df54"
]
206 0.19 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
207 0.23 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__b36bc3d71beae969cd68a862c54eeb9f"
]
208 0.19 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
209 0.23 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__3b0daed78494e68fd1633d3864dacf6f"
]
210 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
211 0.22 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__0aa92c3175884f55e609b5fbb1355cef"
]
212 0.22 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
213 0.24 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__3b0daed78494e68fd1633d3864dacf6f"
]
214 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
215 0.19 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__ef55790df2cb9771bbd7b896209db0e9"
]
216 0.20 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
217 0.21 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__3b0daed78494e68fd1633d3864dacf6f"
]
218 0.20 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
219 0.22 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__3b0daed78494e68fd1633d3864dacf6f"
]
220 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "textMedia_1-33_3"
  "pimcore_image_thumbnails"
]
221 0.20 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_68366__0aa92c3175884f55e609b5fbb1355cef"
]
222 0.27 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/en/snippets/"
  "footer"
]
223 0.22 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
224 0.49 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=en&_format=html&_controller=CONECTO%5CProviderBundle%5CController%5CDocumentController%3A%3AfooterSnippetAction"
  "path_query"
  "https://montafon-staging.conecto.rocks/_fragment?_path=_locale=en&_format=html&_controller=CONECTO%5CProviderBundle%5CController%5CDocumentController%3A%3AfooterSnippetAction"
  "entire_uri"
]
225 0.26 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  23
]
226 0.40 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  7
]
227 1.94 ms
SELECT documents.*, tree_locks.locked FROM documents
            LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document'
                WHERE documents.id = ?
Parameters:
[
  2521
]
228 2.61 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  5
]
229 0.33 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  5
]
230 0.29 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,3) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  5
]
231 0.25 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  149
]
232 0.27 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  149
]
233 0.28 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,3) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  149
]
234 0.28 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  145
]
235 0.24 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  145
]
236 0.29 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,3) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  145
]

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.

Entities Mapping