Query Metrics

265 Database Queries
26 Different statements
173.96 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.34 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/klostertal/en/magazine/"
  "meine-schonsten-wasserplatze_m153"
]
2 0.28 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/klostertal/en/magazine/meine-schonsten-wasserplatze_m153"
]
3 0.22 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/klostertal/en/"
  "magazine"
]
4 0.24 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/klostertal/en/magazine"
]
5 0.22 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/klostertal/"
  "en"
]
6 0.58 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  103
]
7 0.37 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
8 0.47 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/en/magazine/meine-schonsten-wasserplatze_m153"
  "path"
  "auto_create"
  "/klostertal/en/magazine/meine-schonsten-wasserplatze_m153"
  "path_query"
  "https://alpenregion-staging.conecto.rocks/klostertal/en/magazine/meine-schonsten-wasserplatze_m153"
  "entire_uri"
]
9 0.29 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
10 0.70 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/klostertal/en/magazine/"
  "meine-schonsten-wasserplatze_m153"
]
11 0.33 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/klostertal/en/magazine/meine-schonsten-wasserplatze_m153"
]
12 0.25 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/klostertal/en/"
  "magazine"
]
13 1.01 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/klostertal/en/magazine"
]
14 0.42 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "CNMAG_ARTICLE"
]
15 2.59 ms
SELECT * FROM object_relations_CNMAG_ARTICLE WHERE src_id = ?
Parameters:
[
  153
]
16 2.62 ms
SELECT COUNT(*) FROM documents INNER JOIN  documents_translations ON documents.id = documents_translations.id WHERE  (documents_translations.sourceId = ? AND documents_translations.language = ?) AND published = 1
Parameters:
[
  397
  "en"
]
17 1.48 ms
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:
[
  "magazin_breadcrumb"
  null
  null
]
18 0.96 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  113
]
19 0.28 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  958
]
20 0.90 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  958
]
21 0.24 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  113
]
22 0.40 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  103
  113
  113
]
23 2.08 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  113
  113
]
24 0.34 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  103
  103
]
25 0.27 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "de"
]
26 0.25 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "en"
]
27 0.24 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/klostertal/"
  "de"
]
28 0.78 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,10) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  18
]
29 0.25 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  18
]
30 0.36 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
31 0.48 ms
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  113
]
32 0.33 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  113
]
33 0.41 ms
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  114
]
34 0.29 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  114
]
35 2.28 ms
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  116
]
36 0.69 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  116
]
37 2.51 ms
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  117
]
38 0.37 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  117
]
39 0.34 ms
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  120
]
40 1.98 ms
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  121
]
41 0.35 ms
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  122
]
42 0.31 ms
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  118
]
43 0.33 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  118
]
44 0.28 ms
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  119
]
45 0.35 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
46 0.25 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  18
]
47 0.34 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  18
]
48 0.49 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,10) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  18
]
49 0.52 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  524
]
50 0.61 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  524
]
51 0.51 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,506,502,20) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  524
]
52 1.40 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  113
]
53 0.46 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  103
  113
  113
]
54 0.36 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  113
  113
]
55 0.37 ms
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  103
  103
]
56 3.59 ms
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  117
]
57 0.48 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  117
]
58 0.32 ms
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  120
]
59 0.32 ms
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  121
]
60 0.86 ms
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
Parameters:
[
  122
]
61 0.27 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "weather"
]
62 0.48 ms
SELECT COUNT(*) FROM documents INNER JOIN  documents_translations ON documents.id = documents_translations.id WHERE  (documents_translations.sourceId = ? AND documents_translations.language = ?) AND published = 1
Parameters:
[
  397
  "en"
]
63 3.60 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  397
]
64 1.51 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,671,668,663,662,661) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  4650
]
65 0.40 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4650
]
66 0.77 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4650
]
67 0.39 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/de/snippets/Magazin Artikel/Klostertal/"
  "Meine schönsten Wasserplätze"
]
68 0.59 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
69 0.76 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%5CMagazineBundle%5CController%5CSnippetController%3A%3AmagazineSnippetAction"
  "path_query"
  "https://alpenregion-staging.conecto.rocks/_fragment?_path=_locale=de&_format=html&_controller=CONECTO%5CMagazineBundle%5CController%5CSnippetController%3A%3AmagazineSnippetAction"
  "entire_uri"
]
70 0.36 ms
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
  3819
]
71 0.35 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "vcloud_tour"
]
72 0.46 ms
SELECT * FROM object_relations_vcloud_tour WHERE src_id = ?
Parameters:
[
  4023
]
73 0.27 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "vcloud_concept"
]
74 0.31 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  4853
]
75 0.28 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  4876
]
76 0.25 ms
SELECT * FROM object_relations_vcloud_concept WHERE src_id = ?
Parameters:
[
  4863
]
77 0.28 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "klostertal"
]
78 0.22 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  102
]
79 0.25 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "vcloud_poi"
]
80 0.49 ms
SELECT * FROM object_relations_vcloud_poi WHERE src_id = ?
Parameters:
[
  3396
]
81 0.25 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  102
]
82 0.43 ms
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
  3982
]
83 0.66 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,671,668,663,662,661) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  4649
]
84 0.29 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4649
]
85 0.28 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4649
]
86 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
87 1.31 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__6cca1a8ec9ef39af3b7d593e8491eb54"
]
88 0.55 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
89 0.92 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__9dcbe4b1b6488f099d5932131411ffbd"
]
90 0.38 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
91 0.74 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__ea5c8edee6091afe3a2608cd71071f9d"
]
92 0.31 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
93 0.34 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__f737707678b0b74a876aac335a9ac5d9"
]
94 0.31 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
95 1.17 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__1ccd38160b800df2a8744806995eca6e"
]
96 0.32 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
97 0.34 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__89148a3e5d6a4223d1834921f7d59aba"
]
98 0.31 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
99 0.34 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__fa2ce2d8c0cbd4dcdf4f5a5593376d56"
]
100 0.32 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
101 0.31 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__37f39e92ba9f478c0c8944d2a9054437"
]
102 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
103 0.32 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__b296c74854dc01c5c1bcdb930cc57256"
]
104 0.35 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
105 0.34 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__0b2dc20d68727013547140a5153d0386"
]
106 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
107 0.33 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__4a710064ccdf2522f0d257776f4fb6a7"
]
108 0.32 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
109 0.43 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__5c7a77204add9c1a8bf54e4a477c85b0"
]
110 0.37 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
111 0.39 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__6345333539f6501ffedc6db671e8fb31"
]
112 0.37 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
113 0.52 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__3bf678b2422bbc578b3c556309b569ec"
]
114 0.36 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
115 0.40 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__e8214b4813bd74ff379ae745a1588e61"
]
116 0.37 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
117 0.51 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__55b9e54fda80de194e7108e7c42434e2"
]
118 0.34 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
119 0.36 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__d1f469e0d48fa331fd4b46f82b337f30"
]
120 0.38 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
121 0.38 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__05773d4eed6a61b493376ff5d29decbb"
]
122 0.36 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
123 0.49 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__1c267a7d5e3d26e8c53448e7420b0a95"
]
124 0.36 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
125 0.44 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__22f9747c623345a9cf94f39bb5c914a3"
]
126 0.38 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
127 0.41 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__2960d9ccc768d593344b50e81ad8c129"
]
128 0.40 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
129 0.39 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__581cea4e19e300805c0048fb18435ee8"
]
130 0.36 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
131 0.41 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__c49c323760ce4f38a1d546eb2f09f693"
]
132 0.37 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
133 0.39 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__04b25d4012cb7781cf7422f60d31555a"
]
134 0.37 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
135 0.41 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__ee2a045fc215de5107d8bf529bd61823"
]
136 0.38 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
137 0.40 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__b8822a3edd020eda0033d9b60820e39d"
]
138 0.36 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
139 0.42 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__29407ca087e43edf811a4e6dc2906c3d"
]
140 0.37 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
141 0.40 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__b8822a3edd020eda0033d9b60820e39d"
]
142 0.38 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
143 0.51 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4649__ee2a045fc215de5107d8bf529bd61823"
]
144 1.44 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,671,668,663,662,661) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  4652
]
145 0.31 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4652
]
146 0.41 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4652
]
147 0.32 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
148 0.89 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__431ebcde199d22c9a7d977197ed7f17c"
]
149 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
150 0.82 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__e3b176717ceacb1ca5462bb8ff726ffb"
]
151 0.31 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
152 1.05 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__309e93ccb4516dda92cb2695eba1097a"
]
153 0.35 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
154 0.35 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__3a9ab105a56344e27c197cf9e8993c7e"
]
155 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
156 2.21 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__77009831d66c38a3eeb29208ff89a86f"
]
157 0.36 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
158 0.77 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__62e6aa74bb7481855438424c7365fb7e"
]
159 2.74 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
160 0.31 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__6ea1b20b33f1aed2f9a85992ab288d60"
]
161 2.34 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
162 0.80 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__cfc38e1663683c67170cbbbe965ef2ab"
]
163 0.23 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
164 0.67 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__a12f92913c5fad58a62d23ecd06f3487"
]
165 0.26 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
166 0.76 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__0f65f407887d960c4cae79635d52be3d"
]
167 2.67 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
168 1.05 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__f584737ad5524a06747423adde5fba1c"
]
169 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
170 0.37 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__cbf31883b68aa553378649bbf3b37c90"
]
171 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
172 0.27 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__e73256ab47fc095c77a0d473362bdca0"
]
173 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
174 0.32 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__8f224574d34b30ed474418975020add1"
]
175 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
176 0.62 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__f392853222d3d6031e486485ee07c0ab"
]
177 0.49 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
178 1.83 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__ce0d8a6473daeb0a4640ebe1ccb45b49"
]
179 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
180 0.30 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__6fbec999ac05e312407464fbcb683c62"
]
181 0.28 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
182 1.25 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__cca7e5a8623570d821d09f7a9e412c64"
]
183 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
184 1.20 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__9cd401b2ac8305ecf5d15378389d2b57"
]
185 0.67 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
186 0.38 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__3aac49eb68f7e58bb917c4ddb891f33a"
]
187 0.26 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
188 0.27 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__2c620a4c8137ebf2fef461961150f266"
]
189 0.26 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
190 0.24 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__7b11dd0b39524031a06581af47701075"
]
191 0.23 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
192 0.27 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__89c3f89b522770433da5babed0bace16"
]
193 0.26 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
194 0.27 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__516f02173d7d1c12841442d8e83ca6ed"
]
195 1.09 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
196 0.25 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__ef7c6ecb1948163c583613050adee547"
]
197 0.24 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
198 0.22 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__a8d959cafbd510a8857c625ceb72ea72"
]
199 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
200 0.21 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__1db3b31f499f32bbb5c79c6d69494de2"
]
201 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
202 0.22 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__a8d959cafbd510a8857c625ceb72ea72"
]
203 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
204 0.26 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4652__ef7c6ecb1948163c583613050adee547"
]
205 1.27 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,671,668,663,662,661) AND inheritable = 1) OR cid = ? )
                                 AND ctype='asset'
Parameters:
[
  4647
]
206 0.44 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4647
]
207 3.50 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4647
]
208 0.34 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
209 3.00 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__b5cfb00989705377684b5795a21a7362"
]
210 0.33 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
211 0.89 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__219aab89ed7d9be3182ae73baeeb50b4"
]
212 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
213 0.76 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__98ef722ac88be1cc4be5bf14655c1e48"
]
214 0.26 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
215 1.69 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__f41a228765f9e25d65bc74af1120a9e1"
]
216 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
217 1.85 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__530f31e4b760be4112edf45e9b3ce44c"
]
218 0.80 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
219 0.64 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__e71c264837457078ae4756dc7a85f5cc"
]
220 5.59 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
221 1.04 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__71d034fe5601d779a11fbe4e3b0d1499"
]
222 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
223 2.22 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__a2fe1ddc2aedfc6a73c359a42dae5654"
]
224 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
225 0.34 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__94ee1822f7d0822220fa018f5aa9a8fd"
]
226 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
227 1.44 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__cd0ee6166e3d7aaa99e6357df3489c48"
]
228 0.32 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
229 0.90 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__0f850efae06fed5156c63d5eb7d21821"
]
230 2.19 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
231 0.38 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__51d6487666eb04ba0ec962dd771a98c0"
]
232 0.28 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
233 1.83 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__f9a71bd8064d9d4cd4d4bce3bd8638bd"
]
234 0.43 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
235 1.69 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__7a6b40aef7bd87b77dd247401d0d9044"
]
236 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
237 0.29 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__1120e72c1e60853fd648ad2da160a9f2"
]
238 0.70 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
239 0.89 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__b96fa6d3ae352fd3d048adbd71b6866f"
]
240 2.65 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
241 0.40 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__061b65624c56e4070b5e6598343d0691"
]
242 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
243 0.33 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__8b3a09d88dea048f6b5ae13c1afa0d68"
]
244 0.28 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
245 0.29 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__60285446d008bed9a96a957549b3b3b0"
]
246 1.77 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
247 0.33 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__17c433f7cf5ace9422b8ea4a164aba14"
]
248 0.26 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
249 0.30 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__781b97ff570fda080960e12d49d99367"
]
250 2.12 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
251 0.33 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__236eb554ecfbbe357ec8e46a88c280ec"
]
252 2.35 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
253 1.08 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__6f440a33f4262f0fad0045ed50832394"
]
254 2.19 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
255 0.36 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__efddf5121732fda8a8e4f2764840ee5d"
]
256 0.28 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
257 0.30 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__be522a9e06b5b6c970ccb8f0be3a6806"
]
258 0.37 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
259 0.34 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__6caedb359e188be7bff2ea3e5a451c97"
]
260 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
261 0.42 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__895a32e3e96003b4df372309452368fa"
]
262 0.33 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
263 0.34 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__6caedb359e188be7bff2ea3e5a451c97"
]
264 0.30 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "areaMedia_1-5_3"
  "pimcore_image_thumbnails"
]
265 0.28 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_4647__be522a9e06b5b6c970ccb8f0be3a6806"
]

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