GET https://travelmanager.online/api/front/notes?context=581&contextType=offer

Query Metrics

6 Database Queries
6 Different statements
1.94 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 0.76 ms
SELECT t0.role AS role_1, t0.email AS email_2, t0.password AS password_3, t0.id AS id_4, t0.version AS version_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.operator_id AS operator_id_8 FROM employees t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "aneta@fokus.waw.pl"
]
2 0.36 ms
SELECT t0.creation_timestamp AS creation_timestamp_1, t0.modification_timestamp AS modification_timestamp_2, t0.inquiry AS inquiry_3, t0.id AS id_4, t0.version AS version_5, t0.name AS name_6, t0.supervisor_id AS supervisor_id_7, t0.client_id AS client_id_8, t0.organization_id AS organization_id_9, t0.creator_id AS creator_id_10, t0.modifier_id AS modifier_id_11, t0.status_id AS status_id_12, t0.operator_id AS operator_id_13 FROM offers t0 WHERE t0.id = ?
Parameters:
[
  581
]
3 0.25 ms
SELECT t0.code AS code_1, t0.position AS position_2, t0.id AS id_3, t0.version AS version_4, t0.name AS name_5, t0.text_color AS text_color_6, t0.text_background_color AS text_background_color_7, t0.operator_id AS operator_id_8, t0.discriminator FROM dictionaries t0 WHERE t0.id = ? AND t0.discriminator IN ('offer_status')
Parameters:
[
  74
]
4 0.37 ms
SELECT t0.creation_timestamp AS creation_timestamp_1, t0.content AS content_2, t0.id AS id_3, t0.version AS version_4, t0.author_id AS author_id_5, t0.type_id AS type_id_6, t0.offer_id AS offer_id_7, t0.discriminator FROM notes t0 WHERE t0.offer_id = ? AND t0.discriminator IN ('offer') ORDER BY t0.id DESC
Parameters:
[
  581
]
5 0.11 ms
SELECT t0.code AS code_1, t0.position AS position_2, t0.id AS id_3, t0.version AS version_4, t0.name AS name_5, t0.operator_id AS operator_id_6, t0.discriminator FROM dictionaries t0 WHERE t0.id = ? AND t0.discriminator IN ('note_type')
Parameters:
[
  2
]
6 0.08 ms
SELECT t0.role AS role_1, t0.email AS email_2, t0.password AS password_3, t0.id AS id_4, t0.version AS version_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.operator_id AS operator_id_8 FROM employees t0 WHERE t0.id = ?
Parameters:
[
  11
]

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
TravelManager\Admin\Model\Entity\EmployeeEntity 2
TravelManager\Core\Model\Entity\Base\DictionaryEntryEntity 2
TravelManager\Core\Model\Entity\Base\NoteEntity 2
TravelManager\Admin\Model\Entity\TourOperatorEntity 1
TravelManager\Core\Model\Entity\OfferEntity 1
TravelManager\Core\Model\Entity\ClientEntity 1