Query Metrics

78 Database Queries
25 Different statements
40.83 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.47 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
2 1.85 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/ac/t25-85-lamp~181979"
  "path"
  "auto_create"
  "/en/products/ac/t25-85-lamp~181979"
  "path_query"
  "https://testing.weverducre.com/en/products/ac/t25-85-lamp~181979"
  "entire_uri"
]
3 0.44 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
4 0.51 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "reports"
  "pimcore"
]
5 0.66 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/en/products/ac/"
  "t25-85-lamp~181979"
]
6 0.77 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/weverducre.com/en/products/ac/t25-85-lamp~181979"
]
7 0.78 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/ac/t25-85-lamp~181979"
]
8 0.36 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/en/products/"
  "ac"
]
9 0.38 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/weverducre.com/en/products/ac"
]
10 0.36 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/ac"
]
11 0.37 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/en/"
  "products"
]
12 0.39 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.32 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SCONF"
]
14 0.81 ms
SELECT * FROM object_relations_SCONF WHERE src_id = ?
Parameters:
[
  1547
]
15 0.36 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "prod"
]
16 0.54 ms
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
  181979
]
17 0.74 ms
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
Parameters:
[
  181979
]
18 0.76 ms
SELECT * FROM object_store_ACCES WHERE oo_id = ? FOR UPDATE
Parameters:
[
  181979
]
19 0.31 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "ACCES"
]
20 0.89 ms
SELECT * FROM object_localized_data_ACCES WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es')
Parameters:
[
  181979
]
21 0.62 ms
SELECT * FROM object_brick_store_StrexAccessory_ACCES WHERE id = ? AND fieldname = ?
Parameters:
[
  181979
  "configurator"
]
22 0.62 ms
SELECT * FROM object_relations_ACCES WHERE src_id = ?
Parameters:
[
  181979
]
23 0.34 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
24 0.43 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Accessory"
]
25 0.59 ms
SELECT * FROM bundle_outputdataconfigtoolkit_outputdefinition WHERE objectId=? AND classId = ? AND `channel` = ?
Parameters:
[
  181979
  "ACCES"
  "accessory_description"
]
26 0.34 ms
SELECT * FROM bundle_outputdataconfigtoolkit_outputdefinition WHERE objectId=? AND classId = ? AND `channel` = ?
Parameters:
[
  28544
  "ACCES"
  "accessory_description"
]
27 0.33 ms
SELECT * FROM bundle_outputdataconfigtoolkit_outputdefinition WHERE objectId=? AND classId = ? AND `channel` = ?
Parameters:
[
  53
  "ACCES"
  "accessory_description"
]
28 0.37 ms
SELECT * FROM bundle_outputdataconfigtoolkit_outputdefinition WHERE objectId=? AND classId = ? AND `channel` = ?
Parameters:
[
  52
  "ACCES"
  "accessory_description"
]
29 0.40 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
30 0.37 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
31 0.50 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
32 0.36 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
33 0.35 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
34 0.35 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
35 0.35 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
36 0.39 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
37 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 = 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"
]
38 0.45 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
39 1.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 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"
]
40 0.50 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  242
]
41 0.56 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  16
]
42 0.34 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "PCAT"
]
43 0.45 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  169
]
44 0.50 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4574046
]
45 0.46 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4574046
]
46 0.33 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4538784
]
47 0.41 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4538784
]
48 0.35 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
49 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=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"
]
50 0.45 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  245
]
51 0.40 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  41
]
52 0.32 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:
[]
53 0.30 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "8"
]
54 0.35 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  1292
]
55 0.48 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  797541
]
56 0.40 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  797541
]
57 0.37 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "7"
]
58 0.46 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3737995
]
59 0.40 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3737995
]
60 0.43 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
61 1.60 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"
]
62 0.47 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  243
]
63 0.41 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  38
]
64 0.31 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  567
]
65 0.41 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  479
]
66 0.43 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  5042933
]
67 0.38 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  5042933
]
68 0.38 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  2203379
]
69 0.35 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  2203379
]
70 0.41 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
71 1.33 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"
]
72 0.51 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  244
]
73 0.51 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  39
]
74 0.30 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  215
]
75 0.35 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3737893
]
76 0.38 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3737893
]
77 0.38 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3737897
]
78 0.38 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.