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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
4.84 ms
(19.64%)
1
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"
]
3.88 ms
(15.76%)
1
"COMMIT"
Parameters:
[]
3.84 ms
(15.59%)
1
UPDATE assistant SET id = ? WHERE id = ?
Parameters:
[
  "01961124-9c98-7a8b-a6fa-adb997ab338b"
  "01961124-9c98-7a8b-a6fa-adb997ab338b"
]
3.34 ms
(13.56%)
1
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"
]
2.47 ms
(10.04%)
1
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:
[
  "2a5f6f09e0e93d07e7f335d927c552d1d2ed4f884ea7cd41fac63d6acd3f26ec61d05ad4741dfe8b"
]
1.43 ms
(5.81%)
1
RELEASE SAVEPOINT DOCTRINE_3
Parameters:
[]
1.19 ms
(4.82%)
1
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"
]
0.97 ms
(3.93%)
1
UPDATE project SET id = ? WHERE id = ?
Parameters:
[
  "01960fc3-e0b9-7cfa-a778-c216fe2d517b"
  "01960fc3-e0b9-7cfa-a778-c216fe2d517b"
]
0.92 ms
(3.75%)
1
UPDATE organization SET id = ? WHERE id = ?
Parameters:
[
  "01960f90-341d-7d04-9d09-cfa8182e3faf"
  "01960f90-341d-7d04-9d09-cfa8182e3faf"
]
0.50 ms
(2.05%)
1
SAVEPOINT DOCTRINE_3
Parameters:
[]
0.46 ms
(1.87%)
1
"START TRANSACTION"
Parameters:
[]
0.41 ms
(1.66%)
1
SAVEPOINT DOCTRINE_2
Parameters:
[]
0.38 ms
(1.53%)
1
RELEASE SAVEPOINT DOCTRINE_2
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