Query Metrics

133 Database Queries
21 Different statements
86.63 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 9.77 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
2 0.52 ms
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 1) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/de/produkte/c/badezimmer~22235"
  "path"
  "auto_create"
  "/de/produkte/c/badezimmer~22235?page=3"
  "path_query"
  "https://testing.weverducre.com/de/produkte/c/badezimmer~22235?page=3"
  "entire_uri"
]
3 0.20 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
4 0.22 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "reports"
  "pimcore"
]
5 0.25 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/de/produkte/c/"
  "badezimmer~22235"
]
6 0.23 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/weverducre.com/de/produkte/c/badezimmer~22235"
]
7 0.27 ms
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/weverducre.com/%"
  "/de/produkte/c/badezimmer~22235"
]
8 0.17 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/de/produkte/"
  "c"
]
9 0.20 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/weverducre.com/de/produkte/c"
]
10 0.18 ms
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[
  "/weverducre.com/%"
  "/de/produkte/c"
]
11 0.20 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/de/"
  "produkte"
]
12 0.22 ms
SELECT object_localized_SCONF_de.id as id, object_localized_SCONF_de.type as `type` FROM object_localized_SCONF_de LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1
AND `EcommerceB2B`.id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_de `EcommerceB2B_localized` ON 1
AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1
AND `EcommerceB2C`.id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_de `EcommerceB2C_localized` ON 1
AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_de`.id WHERE (((EcommerceB2B.dataAreaId = ? or EcommerceB2C.dataAreaId = ?))  AND  object_localized_SCONF_de.type IN ('object','variant','folder')) AND object_localized_SCONF_de.published = 1 LIMIT 1
Parameters:
[
  "wdbe"
  "wdbe"
]
13 0.71 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SCONF"
]
14 2.05 ms
SELECT * FROM object_relations_SCONF WHERE src_id = ?
Parameters:
[
  1547
]
15 0.44 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "prod"
]
16 0.35 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "PCAT"
]
17 0.85 ms
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE
                     (
                         (cid IN (1,22224,22218,1548,1544) AND inheritable = 1)
                         OR cid = ? ) AND ctype='object'
Parameters:
[
  22235
]
18 0.34 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
19 0.29 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
20 0.57 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
21 0.31 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
22 0.31 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
23 0.31 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
24 0.31 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
25 0.29 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
26 0.49 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
27 0.34 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Product"
]
28 1.22 ms
SELECT * FROM object_relations_prod WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[
  22235
  "additionalCategories"
]
29 0.54 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120062
]
30 0.37 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  22289
]
31 0.31 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17425
]
32 0.79 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  22299
]
33 0.30 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  26148
]
34 0.29 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17434
]
35 0.35 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17158
]
36 0.32 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17451
]
37 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120120
]
38 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157284
]
39 0.30 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  23647
]
40 0.34 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17332
]
41 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17137
]
42 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17438
]
43 0.22 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  23660
]
44 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120121
]
45 0.27 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157278
]
46 0.27 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17435
]
47 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157285
]
48 0.25 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  68100
]
49 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157288
]
50 0.26 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  26136
]
51 0.38 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157291
]
52 0.34 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17452
]
53 0.30 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  49049
]
54 0.27 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  23648
]
55 0.27 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  68105
]
56 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120082
]
57 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  26147
]
58 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157286
]
59 0.26 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  23658
]
60 0.26 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157280
]
61 0.26 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  87579
]
62 0.63 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  171540
]
63 0.27 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120084
]
64 0.64 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  171538
]
65 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  23649
]
66 0.31 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  49010
]
67 0.33 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  49011
]
68 0.26 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  68102
]
69 0.35 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120083
]
70 0.31 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17440
]
71 0.26 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17334
]
72 0.29 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  94575
]
73 0.31 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  23659
]
74 0.29 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  49008
]
75 0.27 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17159
]
76 0.72 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  22300
]
77 0.39 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  22278
]
78 0.35 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157283
]
79 0.62 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  171539
]
80 0.54 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  22322
]
81 0.43 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120119
]
82 0.30 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157290
]
83 0.29 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157281
]
84 0.34 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157279
]
85 0.36 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  68103
]
86 0.33 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157282
]
87 0.37 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17439
]
88 0.35 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120063
]
89 0.89 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  87546
]
90 3.47 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157287
]
91 5.50 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120061
]
92 4.27 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  68106
]
93 2.55 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  49015
]
94 3.37 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  49050
]
95 6.22 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120122
]
96 1.67 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
97 1.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 OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction"
  "entire_uri"
]
98 0.38 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
99 1.15 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 OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
100 0.35 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  16
]
101 0.54 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  120
]
102 0.55 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4574046
]
103 0.26 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4574046
]
104 0.26 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4538784
]
105 0.29 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4538784
]
106 0.40 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
107 1.35 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 OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
108 0.40 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  41
]
109 0.30 ms
SELECT object_localized_8_de.id as id, object_localized_8_de.type as `type` FROM object_localized_8_de WHERE ( object_localized_8_de.type IN ('object','variant','folder')) AND object_localized_8_de.published = 1
Parameters:
[]
110 0.24 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "8"
]
111 0.46 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  1288
]
112 0.33 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  797541
]
113 0.29 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  797541
]
114 0.32 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "7"
]
115 0.33 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3737995
]
116 0.32 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3737995
]
117 0.36 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
118 1.13 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 OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
119 0.31 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  38
]
120 0.24 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  566
]
121 0.30 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  34
]
122 0.36 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  5042933
]
123 0.26 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  5042933
]
124 0.29 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  2203379
]
125 0.33 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  2203379
]
126 0.31 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
127 1.04 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 OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/_fragment"
  "path"
  "auto_create"
  "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
128 0.32 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  39
]
129 0.26 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  25
]
130 0.27 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3737893
]
131 0.24 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3737893
]
132 0.28 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3737897
]
133 0.27 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3737897
]

Database Connections

Name Service
default doctrine.dbal.default_connection
ax doctrine.dbal.ax_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

No loaded entities.