GET https://api.jambostack.site/public-api/collections

Query Metrics

17 Database Queries
7 Different statements
33.21 ms Query time
0 Invalid entities
141 Managed entities

Queries

Group similar statements

# Time Info
1 7.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.token_hash AS token_hash_3, t0.token_version AS token_version_4, t0.abilities AS abilities_5, t0.last_used_at AS last_used_at_6, t0.expires_at AS expires_at_7, t0.created_at AS created_at_8, t0.project_id AS project_id_9 FROM api_token t0 WHERE t0.token_hash = ? AND t0.token_version = ? LIMIT 1
Parameters:
[
  "824c6888710cd68650cb176a7ce932b705fcb04999dc35990f6a88fdf1fa9e17"
  2
]
2 0.97 ms
"START TRANSACTION"
Parameters:
[]
3 3.03 ms
UPDATE api_token SET last_used_at = ? WHERE id = ?
Parameters:
[
  "2026-07-30 11:46:03"
  7
]
4 8.29 ms
"COMMIT"
Parameters:
[]
5 2.41 ms
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.description AS description_4, c0_.is_singleton AS is_singleton_5, c0_.`order` AS order_6, c0_.deleted_at AS deleted_at_7, c0_.settings AS settings_8, c0_.project_id AS project_id_9 FROM `collection` c0_ WHERE c0_.project_id = ? AND c0_.deleted_at IS NULL ORDER BY c0_.`order` ASC LIMIT 50
Parameters:
[
  4
]
6 0.98 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM `collection` c0_ WHERE c0_.project_id = ? AND c0_.deleted_at IS NULL
Parameters:
[
  4
]
7 1.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.options AS options_5, t0.validation_rules AS validation_rules_6, t0.`order` AS order_7, t0.is_required AS is_required_8, t0.deleted_at AS deleted_at_9, t0.collection_id AS collection_id_10 FROM field t0 WHERE t0.collection_id = ?
Parameters:
[
  42
]
8 0.84 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.options AS options_5, t0.validation_rules AS validation_rules_6, t0.`order` AS order_7, t0.is_required AS is_required_8, t0.deleted_at AS deleted_at_9, t0.collection_id AS collection_id_10 FROM field t0 WHERE t0.collection_id = ?
Parameters:
[
  43
]
9 1.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.options AS options_5, t0.validation_rules AS validation_rules_6, t0.`order` AS order_7, t0.is_required AS is_required_8, t0.deleted_at AS deleted_at_9, t0.collection_id AS collection_id_10 FROM field t0 WHERE t0.collection_id = ?
Parameters:
[
  44
]
10 0.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.options AS options_5, t0.validation_rules AS validation_rules_6, t0.`order` AS order_7, t0.is_required AS is_required_8, t0.deleted_at AS deleted_at_9, t0.collection_id AS collection_id_10 FROM field t0 WHERE t0.collection_id = ?
Parameters:
[
  45
]
11 1.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.options AS options_5, t0.validation_rules AS validation_rules_6, t0.`order` AS order_7, t0.is_required AS is_required_8, t0.deleted_at AS deleted_at_9, t0.collection_id AS collection_id_10 FROM field t0 WHERE t0.collection_id = ?
Parameters:
[
  46
]
12 1.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.options AS options_5, t0.validation_rules AS validation_rules_6, t0.`order` AS order_7, t0.is_required AS is_required_8, t0.deleted_at AS deleted_at_9, t0.collection_id AS collection_id_10 FROM field t0 WHERE t0.collection_id = ?
Parameters:
[
  47
]
13 0.71 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.options AS options_5, t0.validation_rules AS validation_rules_6, t0.`order` AS order_7, t0.is_required AS is_required_8, t0.deleted_at AS deleted_at_9, t0.collection_id AS collection_id_10 FROM field t0 WHERE t0.collection_id = ?
Parameters:
[
  48
]
14 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.options AS options_5, t0.validation_rules AS validation_rules_6, t0.`order` AS order_7, t0.is_required AS is_required_8, t0.deleted_at AS deleted_at_9, t0.collection_id AS collection_id_10 FROM field t0 WHERE t0.collection_id = ?
Parameters:
[
  49
]
15 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.options AS options_5, t0.validation_rules AS validation_rules_6, t0.`order` AS order_7, t0.is_required AS is_required_8, t0.deleted_at AS deleted_at_9, t0.collection_id AS collection_id_10 FROM field t0 WHERE t0.collection_id = ?
Parameters:
[
  50
]
16 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.options AS options_5, t0.validation_rules AS validation_rules_6, t0.`order` AS order_7, t0.is_required AS is_required_8, t0.deleted_at AS deleted_at_9, t0.collection_id AS collection_id_10 FROM field t0 WHERE t0.collection_id = ?
Parameters:
[
  51
]
17 0.71 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.options AS options_5, t0.validation_rules AS validation_rules_6, t0.`order` AS order_7, t0.is_required AS is_required_8, t0.deleted_at AS deleted_at_9, t0.collection_id AS collection_id_10 FROM field t0 WHERE t0.collection_id = ?
Parameters:
[
  52
]

Database Connections

Name Service
default doctrine.dbal.default_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
App\Entity\Field 128
App\Entity\Collection 11
App\Entity\ApiToken 1
App\Entity\Project 1

Entities Mapping

Class Mapping errors
App\Entity\ApiToken No errors.
App\Entity\Project No errors.
App\Entity\Collection No errors.
App\Entity\Field No errors.
App\Entity\ContentEntry No errors.