Query Metrics

73 Database Queries
18 Different statements
183.91 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 4.08 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
2 4.92 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:
[
  "/fr/wishlist/list"
  "path"
  "auto_create"
  "/fr/wishlist/list"
  "path_query"
  "https://testing.weverducre.com/fr/wishlist/list"
  "entire_uri"
]
3 4.41 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
4 4.01 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "reports"
  "pimcore"
]
5 4.67 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/fr/wishlist/"
  "list"
]
6 4.23 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/weverducre.com/fr/wishlist/list"
]
7 4.71 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/%"
  "/fr/wishlist/list"
]
8 4.75 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/fr/"
  "wishlist"
]
9 4.32 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/weverducre.com/fr/wishlist"
]
10 4.77 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/%"
  "/fr/wishlist"
]
11 3.70 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/weverducre.com/"
  "fr"
]
12 3.89 ms
SELECT object_localized_SCONF_fr.id as id, object_localized_SCONF_fr.type as `type` FROM object_localized_SCONF_fr LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1
AND `EcommerceB2B`.id = `object_localized_SCONF_fr`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_fr `EcommerceB2B_localized` ON 1
AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_fr`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1
AND `EcommerceB2C`.id = `object_localized_SCONF_fr`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_fr `EcommerceB2C_localized` ON 1
AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_fr`.id WHERE (((EcommerceB2B.dataAreaId = ? or EcommerceB2C.dataAreaId = ?))  AND  object_localized_SCONF_fr.type IN ('object','variant','folder')) AND object_localized_SCONF_fr.published = 1 LIMIT 1
Parameters:
[
  "wdbe"
  "wdbe"
]
13 4.57 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SCONF"
]
14 8.78 ms
SELECT * FROM object_relations_SCONF WHERE src_id = ?
Parameters:
[
  1547
]
15 4.12 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "prod"
]
16 5.22 ms
SELECT object_EF_OSO.id as id, object_EF_OSO.type as `type` FROM object_EF_OSO WHERE (cartId = ? AND IFNULL(successorOrder__id , "") = "" AND  object_EF_OSO.type IN ('object','variant','folder')) AND object_EF_OSO.published = 1
Parameters:
[
  "Pimcore\Bundle\EcommerceFrameworkBundle\CartManager\SessionCart_sesscart_69c08f74c1911"
]
17 4.16 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
18 4.50 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
19 4.57 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
20 4.14 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
21 2.44 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
22 0.41 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
23 0.41 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
24 0.44 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
25 0.43 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  2
]
26 0.42 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
27 1.38 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=fr&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=fr&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction"
  "entire_uri"
]
28 0.41 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
29 1.34 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=fr&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=fr&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
30 0.46 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  1375
]
31 0.51 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  16
]
32 0.39 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "PCAT"
]
33 0.46 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  1380
]
34 4.14 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4574046
]
35 4.41 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4574046
]
36 4.59 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  4538784
]
37 4.81 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  4538784
]
38 4.56 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
39 5.66 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=fr&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=fr&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
40 4.75 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  1379
]
41 4.43 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  41
]
42 4.69 ms
SELECT object_localized_8_fr.id as id, object_localized_8_fr.type as `type` FROM object_localized_8_fr WHERE ( object_localized_8_fr.type IN ('object','variant','folder')) AND object_localized_8_fr.published = 1
Parameters:
[]
43 4.59 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "8"
]
44 0.41 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  1372
]
45 0.55 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  797541
]
46 0.41 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  797541
]
47 0.46 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "7"
]
48 0.43 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3737995
]
49 0.46 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3737995
]
50 1.21 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
51 1.28 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=fr&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=fr&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
52 0.40 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  1376
]
53 0.36 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  38
]
54 0.34 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  1347
]
55 0.34 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  1390
]
56 0.34 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  5042933
]
57 0.36 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  5042933
]
58 0.37 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  2203379
]
59 0.40 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  2203379
]
60 0.35 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
61 1.22 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=fr&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=fr&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction"
  "entire_uri"
]
62 0.41 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  1378
]
63 0.38 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  39
]
64 0.31 ms
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
  1343
]
65 0.36 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3737893
]
66 0.37 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3737893
]
67 0.40 ms
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  3737897
]
68 0.34 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  3737897
]
69 4.14 ms
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
70 5.18 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=fr&_format=html&_controller=App%5CController%5CSnippetController%3A%3AfooterAction"
  "path_query"
  "https://testing.weverducre.com/_fragment?_path=_locale=fr&_format=html&_controller=App%5CController%5CSnippetController%3A%3AfooterAction"
  "entire_uri"
]
71 4.34 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  1374
]
72 4.61 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  10
]
73 4.72 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "SOPT"
]

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.