POST https://y-0a-ustx-16.test-dev.ing/sysop/update/api-keys/full

Query Metrics

12 Database Queries
5 Different statements
6.60 ms Query time
0 Invalid entities
15 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.33 ms
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.api_key = ? AND t0.revoked_at IS NULL LIMIT 1
Parameters:
[
  "c338a9b0-461e-43a6-a322-a2454014f465"
]
2 0.26 ms
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0
Parameters:
[]
3 0.23 ms
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.api_name = ? LIMIT 1
Parameters:
[
  "pod_personnel"
]
4 0.80 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "tierOne_id"
]
5 0.79 ms
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.identifier = ? LIMIT 1
Parameters:
[
  "tierOne-0198e7c1-789b-78ce-9891-a72bba5bc593"
]
6 0.24 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "tierTwo_url"
]
7 1.29 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "tierTwo_id"
]
8 1.40 ms
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.api_name = ? LIMIT 1
Parameters:
[
  "pod_atk"
]
9 0.32 ms
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.api_name = ? LIMIT 1
Parameters:
[
  "pod_ap2t_training"
]
10 0.37 ms
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.api_name = ? LIMIT 1
Parameters:
[
  "pod_ap2t_data_lake"
]
11 0.33 ms
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.api_name = ? LIMIT 1
Parameters:
[
  "pod_ap2t_analytics"
]
12 0.25 ms
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.identifier = ? LIMIT 1
Parameters:
[
  "POD_AP2T_ANALTYICS"
]

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
LoremIpsumDev\LoremAuthBundle\Entity\ApiKey 12
Ap2t\Controller\Entity\Settings 3

Entities Mapping