GET https://pimcore.aue-ec-dev03.de/en/shop/Products/Cars/Sports-Cars/Mercedes-Benz-190-SL~p139

Query Metrics

197 Database Queries
36 Different statements
35.86 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.35 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
2 0.27 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
3 0.40 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/shop/Products/Cars/Sports-Cars/Mercedes-Benz-190-SL~p139"
  "path"
  "auto_create"
  "/en/shop/Products/Cars/Sports-Cars/Mercedes-Benz-190-SL~p139"
  "path_query"
  "https://pimcore.aue-ec-dev03.de/en/shop/Products/Cars/Sports-Cars/Mercedes-Benz-190-SL~p139"
  "entire_uri"
]
4 0.17 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
5 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "reports"
  "pimcore"
]
6 0.25 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/en/shop/Products/Cars/Sports-Cars/"
  "Mercedes-Benz-190-SL~p139"
]
7 0.17 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/en/shop/Products/Cars/Sports-Cars/Mercedes-Benz-190-SL~p139"
]
8 0.19 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/en/shop/Products/Cars/"
  "Sports-Cars"
]
9 0.15 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/en/shop/Products/Cars/Sports-Cars"
]
10 0.18 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/en/shop/Products/"
  "Cars"
]
11 0.15 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/en/shop/Products/Cars"
]
12 0.17 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/en/shop/"
  "Products"
]
13 0.14 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/en/shop/Products"
]
14 0.19 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/en/"
  "shop"
]
15 0.15 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/en/shop"
]
16 0.18 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "en"
]
17 0.18 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "CAR"
]
18 0.26 ms
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '139'
Parameters:
[]
19 0.19 ms
SELECT * FROM object_relations_CAR WHERE src_id = ?
Parameters:
[
  139
]
20 0.20 ms
SELECT * FROM object_relations_CAR WHERE src_id = ?
Parameters:
[
  136
]
21 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
22 0.17 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "CA"
]
23 0.38 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:
[
  "defaultTaxClass"
  null
  null
]
24 0.17 ms
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
  2
]
25 0.16 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "EF_OSTC"
]
26 0.22 ms
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1  ORDER BY `prio` ASC
Parameters:
[]
27 0.17 ms
SELECT * FROM ecommerceframework_pricing_rule WHERE id='9'
Parameters:
[]
28 0.17 ms
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
Parameters:
[]
29 0.16 ms
SELECT * FROM ecommerceframework_pricing_rule WHERE id='8'
Parameters:
[]
30 0.23 ms
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/Product Data/Accessories/lights/head lights/"
  "citroen-2cv-head lights"
]
31 0.16 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "AP"
]
32 0.16 ms
SELECT * FROM ecommerceframework_pricing_rule WHERE id='6'
Parameters:
[]
33 0.15 ms
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
Parameters:
[]
34 0.66 ms
SELECT object_localized_AP_en.id as id, object_localized_AP_en.type as `type` FROM object_localized_AP_en WHERE (compatibleTo LIKE "%,139,%" OR compatibleTo LIKE "%,136,%" AND  object_localized_AP_en.type IN ('object','variant','folder')) AND object_localized_AP_en.published = 1
Parameters:
[]
35 0.23 ms
SELECT * FROM object_relations_AP WHERE src_id = ?
Parameters:
[
  488
]
36 0.18 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
37 0.23 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
38 0.21 ms
SELECT * FROM object_relations_AP WHERE src_id = ?
Parameters:
[
  489
]
39 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
40 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
41 0.21 ms
SELECT * FROM object_relations_AP WHERE src_id = ?
Parameters:
[
  490
]
42 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
43 0.15 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
44 0.20 ms
SELECT * FROM object_relations_AP WHERE src_id = ?
Parameters:
[
  492
]
45 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
46 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
47 0.20 ms
SELECT * FROM object_relations_AP WHERE src_id = ?
Parameters:
[
  493
]
48 0.23 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
49 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
50 0.20 ms
SELECT * FROM object_relations_AP WHERE src_id = ?
Parameters:
[
  494
]
51 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
52 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
53 0.23 ms
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
54 0.20 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
55 0.19 ms
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  1
]
56 0.31 ms
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  1
  1
  1
]
57 0.21 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "de"
]
58 0.20 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "fr"
]
59 0.16 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/fr"
]
60 0.19 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
61 0.18 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "product_detail_manufacturer"
  "pimcore_image_thumbnails"
]
62 0.17 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  305
]
63 0.20 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  305
]
64 0.18 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "galleryLightbox"
  "pimcore_image_thumbnails"
]
65 0.15 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  119
]
66 0.18 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  119
]
67 0.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "product_detail"
  "pimcore_image_thumbnails"
]
68 0.16 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  120
]
69 0.30 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  120
]
70 0.20 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "product_detail_small"
  "pimcore_image_thumbnails"
]
71 0.34 ms
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
Parameters:
[
  136
]
72 0.23 ms
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '138'
Parameters:
[]
73 0.27 ms
SELECT * FROM object_relations_CAR WHERE src_id = ?
Parameters:
[
  138
]
74 0.17 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "BS"
]
75 0.16 ms
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[]
76 0.65 ms
SELECT COUNT(*) FROM object_localized_AP_en WHERE (compatibleTo LIKE "%,139,%" OR compatibleTo LIKE "%,136,%" AND  object_localized_AP_en.type IN ('object','variant','folder')) AND object_localized_AP_en.published = 1
Parameters:
[]
77 0.56 ms
SELECT COUNT(*) FROM object_localized_AP_en WHERE (compatibleTo LIKE "%,139,%" OR compatibleTo LIKE "%,136,%" AND  object_localized_AP_en.type IN ('object','variant','folder')) AND object_localized_AP_en.published = 1
Parameters:
[]
78 0.62 ms
SELECT object_localized_AP_en.id as id, object_localized_AP_en.type as `type` FROM object_localized_AP_en WHERE (compatibleTo LIKE "%,139,%" OR compatibleTo LIKE "%,136,%" AND  object_localized_AP_en.type IN ('object','variant','folder')) AND object_localized_AP_en.published = 1
Parameters:
[]
79 0.26 ms
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '488'
Parameters:
[]
80 0.18 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
81 0.23 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid"
  "pimcore_image_thumbnails"
]
82 0.16 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  120
]
83 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_d00e07dd34f70985b3c699c1dfa104cc"
  "pimcore_image_thumbnails"
]
84 0.16 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__c4cc621a2dea69d47a379ad1b95b0ff1"
]
85 0.20 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_d00e07dd34f70985b3c699c1dfa104cc"
  "pimcore_image_thumbnails"
]
86 0.20 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__cae0d5b235cf01eba540934b08a8c484"
]
87 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_d00e07dd34f70985b3c699c1dfa104cc"
  "pimcore_image_thumbnails"
]
88 0.27 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__08cbab1af1620c3481e2a1ec603b9470"
]
89 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_d00e07dd34f70985b3c699c1dfa104cc"
  "pimcore_image_thumbnails"
]
90 0.15 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__bbf6204522a7d21920a339be84dde9a2"
]
91 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_d00e07dd34f70985b3c699c1dfa104cc"
  "pimcore_image_thumbnails"
]
92 0.18 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__08cbab1af1620c3481e2a1ec603b9470"
]
93 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_d00e07dd34f70985b3c699c1dfa104cc"
  "pimcore_image_thumbnails"
]
94 0.15 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__c4cc621a2dea69d47a379ad1b95b0ff1"
]
95 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
96 0.27 ms
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '489'
Parameters:
[]
97 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
98 0.20 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  124
]
99 0.18 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  124
]
100 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_b5ed6f72323b2d5c4d77c7a453ee4491"
  "pimcore_image_thumbnails"
]
101 0.15 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_124__66b1a1f6cc49f2a3052d864ec6f15a99"
]
102 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_b5ed6f72323b2d5c4d77c7a453ee4491"
  "pimcore_image_thumbnails"
]
103 0.15 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_124__343886ccf98641a75881701b589aed07"
]
104 0.15 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_b5ed6f72323b2d5c4d77c7a453ee4491"
  "pimcore_image_thumbnails"
]
105 0.15 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_124__835bb307b84d6ed47c8e3b92055f3ecd"
]
106 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_b5ed6f72323b2d5c4d77c7a453ee4491"
  "pimcore_image_thumbnails"
]
107 0.14 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_124__343886ccf98641a75881701b589aed07"
]
108 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_b5ed6f72323b2d5c4d77c7a453ee4491"
  "pimcore_image_thumbnails"
]
109 0.18 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_124__492e9f32b359f0ebdc548bd97ce81575"
]
110 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_b5ed6f72323b2d5c4d77c7a453ee4491"
  "pimcore_image_thumbnails"
]
111 0.14 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_124__00e747d9592153531ca3274a92f56017"
]
112 0.18 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_b5ed6f72323b2d5c4d77c7a453ee4491"
  "pimcore_image_thumbnails"
]
113 0.14 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_124__492e9f32b359f0ebdc548bd97ce81575"
]
114 0.20 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_b5ed6f72323b2d5c4d77c7a453ee4491"
  "pimcore_image_thumbnails"
]
115 0.16 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_124__66b1a1f6cc49f2a3052d864ec6f15a99"
]
116 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
117 0.23 ms
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '490'
Parameters:
[]
118 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
119 0.17 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  120
]
120 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_3479fbe798b7593f0a228b9177d779ee"
  "pimcore_image_thumbnails"
]
121 0.14 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__1f0cee781c7016aaca98a325cf13b413"
]
122 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_3479fbe798b7593f0a228b9177d779ee"
  "pimcore_image_thumbnails"
]
123 0.14 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__a79fe1b6f988cce5cc061d4310a79f53"
]
124 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_3479fbe798b7593f0a228b9177d779ee"
  "pimcore_image_thumbnails"
]
125 0.14 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__5bbaf466cd9da7e8818f6069beb2a51c"
]
126 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_3479fbe798b7593f0a228b9177d779ee"
  "pimcore_image_thumbnails"
]
127 0.14 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__a79fe1b6f988cce5cc061d4310a79f53"
]
128 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_3479fbe798b7593f0a228b9177d779ee"
  "pimcore_image_thumbnails"
]
129 0.14 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__7009c9c7887801508df5dc5ae1ce39aa"
]
130 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_3479fbe798b7593f0a228b9177d779ee"
  "pimcore_image_thumbnails"
]
131 0.14 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__0401022d92eb079d71bf0306798ea160"
]
132 0.16 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_3479fbe798b7593f0a228b9177d779ee"
  "pimcore_image_thumbnails"
]
133 0.14 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__7009c9c7887801508df5dc5ae1ce39aa"
]
134 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_3479fbe798b7593f0a228b9177d779ee"
  "pimcore_image_thumbnails"
]
135 0.12 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_120__1f0cee781c7016aaca98a325cf13b413"
]
136 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
137 0.24 ms
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '492'
Parameters:
[]
138 0.15 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
139 0.15 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  117
]
140 0.17 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  117
]
141 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_cdbc1cfefb05d5378dd3c5f4bd330a03"
  "pimcore_image_thumbnails"
]
142 0.13 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_117__bed069eb843efcbf14b039b25fa74577"
]
143 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_cdbc1cfefb05d5378dd3c5f4bd330a03"
  "pimcore_image_thumbnails"
]
144 0.13 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_117__5e92815e98f4e231cb10df3239e1d187"
]
145 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_cdbc1cfefb05d5378dd3c5f4bd330a03"
  "pimcore_image_thumbnails"
]
146 0.12 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_117__a19f20b95351e8ced3bc6b10111d6171"
]
147 0.13 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_cdbc1cfefb05d5378dd3c5f4bd330a03"
  "pimcore_image_thumbnails"
]
148 0.12 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_117__5ea28aeb72dcc4c2a319176001b7452d"
]
149 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_cdbc1cfefb05d5378dd3c5f4bd330a03"
  "pimcore_image_thumbnails"
]
150 0.13 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_117__a19f20b95351e8ced3bc6b10111d6171"
]
151 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_cdbc1cfefb05d5378dd3c5f4bd330a03"
  "pimcore_image_thumbnails"
]
152 0.13 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_117__bed069eb843efcbf14b039b25fa74577"
]
153 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
154 0.20 ms
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '493'
Parameters:
[]
155 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
156 0.15 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  114
]
157 0.17 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  114
]
158 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_4a8267d4e430b572d6e3acf5455d8868"
  "pimcore_image_thumbnails"
]
159 0.13 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__15186a8a8a7043daa43a34f854681c74"
]
160 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_4a8267d4e430b572d6e3acf5455d8868"
  "pimcore_image_thumbnails"
]
161 0.12 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__be76fd6b1ab09b583dbac2c2da2ee2dc"
]
162 0.13 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_4a8267d4e430b572d6e3acf5455d8868"
  "pimcore_image_thumbnails"
]
163 0.12 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__a87ed811f78955c03471fb51e22ddf65"
]
164 0.13 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_4a8267d4e430b572d6e3acf5455d8868"
  "pimcore_image_thumbnails"
]
165 0.12 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__be76fd6b1ab09b583dbac2c2da2ee2dc"
]
166 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_4a8267d4e430b572d6e3acf5455d8868"
  "pimcore_image_thumbnails"
]
167 0.12 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__84020ce6b574f63fa3156bc932852691"
]
168 0.13 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_4a8267d4e430b572d6e3acf5455d8868"
  "pimcore_image_thumbnails"
]
169 0.12 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__059fbfc42df0afa5c9c705b5d695f2ff"
]
170 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_4a8267d4e430b572d6e3acf5455d8868"
  "pimcore_image_thumbnails"
]
171 0.13 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__84020ce6b574f63fa3156bc932852691"
]
172 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_4a8267d4e430b572d6e3acf5455d8868"
  "pimcore_image_thumbnails"
]
173 0.12 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__15186a8a8a7043daa43a34f854681c74"
]
174 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
175 0.20 ms
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '494'
Parameters:
[]
176 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
177 0.16 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  114
]
178 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_33223ca21edc51cec7bb11e2b6d97fee"
  "pimcore_image_thumbnails"
]
179 0.13 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__d8669dd1284abda2bc1bdf10b36c49a9"
]
180 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_33223ca21edc51cec7bb11e2b6d97fee"
  "pimcore_image_thumbnails"
]
181 0.13 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__27cc15179289daa3641eba63b161f20b"
]
182 0.18 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_33223ca21edc51cec7bb11e2b6d97fee"
  "pimcore_image_thumbnails"
]
183 0.12 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__0836616ef0ebd8bfab4c81bd322cc7f4"
]
184 0.13 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_33223ca21edc51cec7bb11e2b6d97fee"
  "pimcore_image_thumbnails"
]
185 0.13 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__27cc15179289daa3641eba63b161f20b"
]
186 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_33223ca21edc51cec7bb11e2b6d97fee"
  "pimcore_image_thumbnails"
]
187 0.12 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__fe27b43a9180d7e90417b431e9ce2037"
]
188 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_33223ca21edc51cec7bb11e2b6d97fee"
  "pimcore_image_thumbnails"
]
189 0.12 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__23dddd79792c12413b87142163db7284"
]
190 0.13 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_33223ca21edc51cec7bb11e2b6d97fee"
  "pimcore_image_thumbnails"
]
191 0.13 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__fe27b43a9180d7e90417b431e9ce2037"
]
192 0.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "grid_auto_33223ca21edc51cec7bb11e2b6d97fee"
  "pimcore_image_thumbnails"
]
193 0.15 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_114__d8669dd1284abda2bc1bdf10b36c49a9"
]
194 0.15 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "system_settings"
  "pimcore_system_settings"
]
195 0.17 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
196 0.31 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=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://pimcore.aue-ec-dev03.de/_fragment?_path=_locale=en&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
197 0.21 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  12
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
pimcore doctrine.orm.pimcore_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.