POST https://travelmanager.online/api/front/documents/preview

Query Metrics

8 Database Queries
8 Different statements
2.58 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 0.71 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:
[
  "maja@fokus.waw.pl"
]
2 0.29 ms
SELECT t0.description AS description_1, t0.config AS config_2, t0.enabled AS enabled_3, t0.type AS type_4, t0.format AS format_5, t0.id AS id_6, t0.version AS version_7, t0.name AS name_8, t0.operator_id AS operator_id_9 FROM document_templates t0 WHERE t0.id = ?
Parameters:
[
  3
]
3 0.33 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:
[
  564
]
4 0.24 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:
[
  23
]
5 0.17 ms
SELECT t0.registration_timestamp AS registration_timestamp_1, t0.id AS id_2, t0.version AS version_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.notes AS notes_6, t0.email AS email_7, t0.phone AS phone_8, t0.organization_id AS organization_id_9, t0.operator_id AS operator_id_10 FROM clients t0 WHERE t0.id = ?
Parameters:
[
  9521
]
6 0.17 ms
SELECT t0.name AS name_1, t0.short_name AS short_name_2, t0.tin AS tin_3, t0.id AS id_4, t0.version AS version_5, t0.notes AS notes_6, t0.email AS email_7, t0.phone AS phone_8, t0.address_line AS address_line_9, t0.address_postal_code AS address_postal_code_10, t0.address_city AS address_city_11, t0.address_country_code AS address_country_code_12, t0.address_google_place AS address_google_place_13, t0.operator_id AS operator_id_14 FROM organizations t0 WHERE t0.id = ?
Parameters:
[
  279
]
7 0.07 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:
[
  5
]
8 0.59 ms
SELECT t1.original_name AS original_name_2, t1.content_type AS content_type_3, t1.key AS key_4, t1.creation_timestamp AS creation_timestamp_5, t1.size AS size_6, t1.hash AS hash_7, t1.encryption_key AS encryption_key_8, t1.encryption_iv AS encryption_iv_9, t1.id AS id_10, t0.name AS name_11, t0.type AS type_12, t0.version AS version_13, t0.offer_id AS offer_id_14, t1.discriminator FROM offer_files t0 INNER JOIN files t1 ON t0.id = t1.id WHERE t0.offer_id = ?
Parameters:
[
  564
]

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 3
TravelManager\Admin\Model\Entity\TourOperatorEntity 1
TravelManager\Core\Model\Entity\DocumentTemplateEntity 1
TravelManager\Core\Model\Entity\OfferEntity 1
TravelManager\Core\Model\Entity\ClientEntity 1
TravelManager\Core\Model\Entity\OrganizationEntity 1
TravelManager\Core\Model\Entity\Base\DictionaryEntryEntity 1
TravelManager\Core\Model\Entity\Base\FileEntity 1