POST https://phi-test.unotre5.it/crm-ajax/offer/view-detail

Query Metrics

8 Database Queries
4 Different statements
2.32 ms Query time
0 Invalid entities
177 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.08 ms
(46.40%)
5
SELECT t0.handled AS handled_1, t0.record_id AS record_id_2, t0.code AS code_3, t0.description AS description_4, t0.id AS id_5 FROM crm_document_row_type t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "1"
]
0.46 ms
(19.98%)
1
SELECT c0_.handled AS handled_0, c0_.record_id AS record_id_1, c0_.code AS code_2, c0_.description AS description_3, c0_.id AS id_4 FROM crm_province c0_ ORDER BY c0_.description ASC
Parameters:
[]
0.44 ms
(18.98%)
1
SELECT t0.handled AS handled_1, t0.record_id AS record_id_2, t0.code AS code_3, t0.description AS description_4, t0.id AS id_5, t0.percentage AS percentage_6 FROM crm_vat t0
Parameters:
[]
0.34 ms
(14.64%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_verified AS is_verified_6, t0.first_and_last_name AS first_and_last_name_7, t0.fluentis_remote_user_id AS fluentis_remote_user_id_8, t0.address AS address_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.province AS province_12, t0.fluentis_remote_region_id AS fluentis_remote_region_id_13, t0.country AS country_14, t0.vat_number AS vat_number_15, t0.fiscal_code AS fiscal_code_16, t0.user_type AS user_type_17, t0.company_name AS company_name_18, t0.erp_role_id AS erp_role_id_19, t0.default_customer_id AS default_customer_id_20, t0.default_customer_description AS default_customer_description_21, t0.website_language_id AS website_language_id_22, t0.language_id AS language_id_23 FROM user t0 WHERE t0.id = ?
Parameters:
[
  5
]

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
App\Entity\CRM\CrmProvince 111
App\Entity\CRM\CrmVat 63
App\Entity\User 1
App\Entity\Language 1
App\Entity\CRM\CrmDocumentRowType 1