Query Metrics

117 Database Queries
21 Different statements
40.11 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.23 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
2 1.37 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:
[
  "/en/products/c/bathroom~22235"
  "path"
  "auto_create"
  "/en/products/c/bathroom~22235"
  "path_query"
  "https://testing.weverducre.com/en/products/c/bathroom~22235"
  "entire_uri"
]
3 0.28 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
4 0.24 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "reports"
  "pimcore"
]
5 0.41 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/en/products/c/"
  "bathroom~22235"
]
6 0.40 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/weverducre.com/en/products/c/bathroom~22235"
]
7 0.44 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/%"
  "/en/products/c/bathroom~22235"
]
8 0.32 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/en/products/"
  "c"
]
9 0.23 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/weverducre.com/en/products/c"
]
10 0.25 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/%"
  "/en/products/c"
]
11 0.25 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/en/"
  "products"
]
12 0.30 ms
SELECT object_localized_SCONF_en.id as id, object_localized_SCONF_en.type as `type` FROM object_localized_SCONF_en LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1
AND `EcommerceB2B`.id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_en `EcommerceB2B_localized` ON 1
AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1
AND `EcommerceB2C`.id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_en `EcommerceB2C_localized` ON 1
AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_en`.id WHERE (((EcommerceB2B.dataAreaId = ? or EcommerceB2C.dataAreaId = ?))  AND  object_localized_SCONF_en.type IN ('object','variant','folder')) AND object_localized_SCONF_en.published = 1 LIMIT 1
Parameters:
[
  "wdbe"
  "wdbe"
]
13 0.35 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SCONF"
]
14 0.64 ms
SELECT * FROM object_relations_SCONF WHERE src_id = ?
Parameters:
[
  1547
]
15 0.26 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "prod"
]
16 0.34 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "PCAT"
]
17 0.72 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.39 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
19 0.63 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
20 0.30 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
21 0.24 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
22 0.25 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
23 0.21 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
24 0.21 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
25 0.20 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
26 0.38 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Product"
]
27 1.25 ms
SELECT * FROM object_relations_prod WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[
  22235
  "additionalCategories"
]
28 0.54 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120062
]
29 0.85 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  22289
]
30 0.62 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17425
]
31 0.26 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  22299
]
32 0.29 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  26148
]
33 0.49 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17434
]
34 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17158
]
35 0.27 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17451
]
36 0.29 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120120
]
37 0.25 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157284
]
38 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  23647
]
39 0.26 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17332
]
40 0.25 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17137
]
41 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17438
]
42 0.25 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  23660
]
43 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120121
]
44 0.25 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157278
]
45 0.78 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17435
]
46 0.27 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157285
]
47 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  68100
]
48 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157288
]
49 0.23 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  26136
]
50 0.26 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157291
]
51 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17452
]
52 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  49049
]
53 0.36 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  23648
]
54 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  68105
]
55 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120082
]
56 0.26 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  26147
]
57 0.25 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157286
]
58 0.27 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  23658
]
59 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157280
]
60 0.26 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  87579
]
61 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  171540
]
62 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120084
]
63 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  171538
]
64 0.25 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  23649
]
65 0.23 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  49010
]
66 0.35 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  49011
]
67 0.22 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  68102
]
68 0.23 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120083
]
69 0.25 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17440
]
70 0.21 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17334
]
71 0.25 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  94575
]
72 0.22 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  23659
]
73 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  49008
]
74 0.46 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17159
]
75 0.24 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  22300
]
76 0.23 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  22278
]
77 0.22 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157283
]
78 0.23 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  171539
]
79 0.21 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  22322
]
80 0.38 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120119
]
81 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157290
]
82 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157281
]
83 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157279
]
84 0.29 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  68103
]
85 0.28 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157282
]
86 0.25 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  17439
]
87 0.25 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120063
]
88 0.22 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  87546
]
89 0.23 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  157287
]
90 0.26 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120061
]
91 0.25 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  68106
]
92 0.30 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  49015
]
93 0.30 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  49050
]
94 0.22 ms
SELECT * FROM object_relations_prod WHERE src_id = ?
Parameters:
[
  120122
]
95 0.43 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
96 0.88 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=en&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=en&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction"
  "entire_uri"
]
97 0.31 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
98 0.97 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=en&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=en&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
99 0.32 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  242
]
100 0.27 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  16
]
101 0.41 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  169
]
102 0.52 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4574046
]
103 0.33 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4574046
]
104 0.31 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4538784
]
105 0.27 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4538784
]
106 0.29 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
107 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=en&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=en&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
108 0.42 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  245
]
109 0.31 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  41
]
110 0.26 ms
SELECT object_localized_8_en.id as id, object_localized_8_en.type as `type` FROM object_localized_8_en WHERE ( object_localized_8_en.type IN ('object','variant','folder')) AND object_localized_8_en.published = 1
Parameters:
[]
111 0.22 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "8"
]
112 0.38 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  1292
]
113 0.47 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  797541
]
114 0.26 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  797541
]
115 0.28 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "7"
]
116 0.27 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3737995
]
117 0.30 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3737995
]

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.