GET http://quark-api.nitrogenio.net/api/1/assistant/01961124-9c98-7a8b-a6fa-adb997ab338b

Query Metrics

13 Database Queries
13 Different statements
37.70 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 2.31 ms
SELECT t0.identifier AS identifier_1, t0.expiry AS expiry_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.revoked AS revoked_5, t0.client AS client_6 FROM oauth2_access_token t0 WHERE t0.identifier = ?
Parameters:
[
  "d160f2c86503a7344bbe9ed2dda6562d2e8eede48cd86ee660fe368af1c265392e3c4256697e14e0"
]
2 0.41 ms
"START TRANSACTION"
Parameters:
[]
3 18.73 ms
SAVEPOINT DOCTRINE_2
Parameters:
[]
4 3.43 ms
SELECT a0_.assistant_id AS assistant_id_0, a0_.assistant_svg AS assistant_svg_1, a0_.assistant_welcome_message AS assistant_welcome_message_2, a0_.query_placeholder AS query_placeholder_3, a0_.assistant_system_instructions AS assistant_system_instructions_4, a0_.assistant_model AS assistant_model_5, a0_.response_format AS response_format_6, a0_.temperature AS temperature_7, a0_.top_p AS top_p_8, a0_.id AS id_9, a0_.created_at AS created_at_10, a0_.name AS name_11, a0_.project_id AS project_id_12 FROM assistant a0_ INNER JOIN project p1_ ON a0_.project_id = p1_.id WHERE a0_.id = ? AND p1_.o_auth2_client_id = ?
Parameters:
[
  "01961124-9c98-7a8b-a6fa-adb997ab338b"
  "01960fc3e0b97cfaa778c216fe2d517b"
]
5 0.87 ms
SELECT t0.project_id AS project_id_1, t0.project_key AS project_key_2, t0.allowed_origins AS allowed_origins_3, t0.o_auth2_client_id AS o_auth2_client_id_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.name AS name_7, t0.organization_id AS organization_id_8 FROM project t0 WHERE t0.id = ?
Parameters:
[
  "01960fc3-e0b9-7cfa-a778-c216fe2d517b"
]
6 1.56 ms
SELECT t0.vat_number AS vat_number_1, t0.crm_id AS crm_id_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.name AS name_5, t0.description AS description_6, t0.address_line1 AS address_line1_7, t0.address_line2 AS address_line2_8, t0.address_line3 AS address_line3_9, t0.address_line4 AS address_line4_10, t0.address_locality AS address_locality_11, t0.address_postcode AS address_postcode_12, t0.address_county AS address_county_13, t0.address_country AS address_country_14, t0.business_category_id AS business_category_id_15, t0.image_id AS image_id_16 FROM organization t0 WHERE t0.id = ?
Parameters:
[
  "01960f90-341d-7d04-9d09-cfa8182e3faf"
]
7 0.49 ms
SAVEPOINT DOCTRINE_3
Parameters:
[]
8 1.11 ms
UPDATE assistant SET id = ? WHERE id = ?
Parameters:
[
  "01961124-9c98-7a8b-a6fa-adb997ab338b"
  "01961124-9c98-7a8b-a6fa-adb997ab338b"
]
9 0.87 ms
UPDATE project SET id = ? WHERE id = ?
Parameters:
[
  "01960fc3-e0b9-7cfa-a778-c216fe2d517b"
  "01960fc3-e0b9-7cfa-a778-c216fe2d517b"
]
10 0.75 ms
UPDATE organization SET id = ? WHERE id = ?
Parameters:
[
  "01960f90-341d-7d04-9d09-cfa8182e3faf"
  "01960f90-341d-7d04-9d09-cfa8182e3faf"
]
11 0.32 ms
RELEASE SAVEPOINT DOCTRINE_3
Parameters:
[]
12 0.22 ms
RELEASE SAVEPOINT DOCTRINE_2
Parameters:
[]
13 6.63 ms
"COMMIT"
Parameters:
[]

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
League\Bundle\OAuth2ServerBundle\Model\AccessToken 1
League\Bundle\OAuth2ServerBundle\Model\Client 1
App\Domain\Assistant\Entity\Assistant 1
App\Domain\Assistant\Entity\Project 1
App\Domain\Organization\Entity\Organization 1
App\Domain\Organization\Entity\BusinessCategory 1