GET https://demo.jakobaio.dev/teams/6

Query Metrics

66 Database Queries
11 Different statements
12.70 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.15 ms
(32.67%)
22
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:
[
  1768452030
  "site_domain_2bffa610fd526a079e2975e1cb0491f5"
]
2.09 ms
(16.49%)
11
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  27
]
2.07 ms
(16.28%)
11
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  27
]
1.77 ms
(13.91%)
10
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:
[
  1768452030
  "object_6\x01tags\x01"
  "class_2\x01tags\x01"
  "asset_27\x01tags\x01"
]
0.63 ms
(4.98%)
3
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/teams/"
  "6"
]
0.49 ms
(3.83%)
3
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:
[
  1768452030
  "system\x01tags\x01"
  "site\x01tags\x01"
]
0.41 ms
(3.22%)
2
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/teams/6"
]
0.39 ms
(3.09%)
1
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
  "2"
]
0.30 ms
(2.37%)
1
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
  6
]
0.23 ms
(1.80%)
1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
Parameters:
[
  1
]
0.17 ms
(1.35%)
1
SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ?
Parameters:
[
  "/Portraits/Players/"
  "Default.png"
]

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.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.