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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
4.50 ms
(34.18%)
23
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:
[
  1768452153
  "site_domain_2bffa610fd526a079e2975e1cb0491f5"
]
2.02 ms
(15.37%)
10
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  8
]
1.81 ms
(13.76%)
10
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  8
]
1.56 ms
(11.89%)
9
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:
[
  1768452153
  "object_73\x01tags\x01"
  "class_1\x01tags\x01"
  "asset_18\x01tags\x01"
]
1.12 ms
(8.52%)
5
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:
[
  1768452153
  "system\x01tags\x01"
  "site\x01tags\x01"
]
0.64 ms
(4.87%)
3
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/teams/"
  "12"
]
0.40 ms
(3.01%)
2
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/teams/12"
]
0.34 ms
(2.58%)
1
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
Parameters:
[
  1
]
0.27 ms
(2.08%)
1
SELECT * FROM object_relations_2 WHERE src_id = ?
Parameters:
[
  12
]
0.27 ms
(2.02%)
1
SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ?
Parameters:
[
  "/Portraits/Players/"
  "Default.png"
]
0.23 ms
(1.72%)
1
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
  "2"
]

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.