Query Metrics

23 Database Queries
8 Different statements
5.76 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.35 ms
(23.40%)
7
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/https\u003A\/\/liprospect.centric.ae\/_profiler\/"
  "' + newToken + '"
]
1.15 ms
(20.03%)
6
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/https\u003A\/\/liprospect.centric.ae\/_profiler\/' + newToken + '"
]
1.05 ms
(18.26%)
4
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
0.99 ms
(17.10%)
2
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1753085073
  "site_domain_acb4e494e0c66d128fa7d826d0416529"
]
0.40 ms
(6.91%)
1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1753085073
  "system\x01tags\x01"
  "site\x01tags\x01"
]
0.31 ms
(5.32%)
1
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
0.29 ms
(5.02%)
1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?)
Parameters:
[
  1753085073
  "document_1\x01tags\x01"
  "asset_5\x01tags\x01"
  "asset_8\x01tags\x01"
  "asset_9\x01tags\x01"
  "asset_10\x01tags\x01"
  "asset_7\x01tags\x01"
]
0.23 ms
(3.96%)
1
SELECT * FROM object_url_slugs WHERE slug = '/https\\u003A\\/\\/liprospect.centric.ae\\/_profiler\\/\' + newToken + \'' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No mapped entities.