https://dnwp-omar.tst.cdl.fi/sales-journals/

Query Metrics

324 Database Queries
3 Different statements
34.52 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
18.46 ms
(53.48%)
160
SELECT t0.id AS id_1, t0.banned AS banned_2, t0.contract AS contract_3, t0.contract_number AS contract_number_4, t0.contract_valid_to AS contract_valid_to_5, t0.currency AS currency_6, t0.electronic_invoicing_identifier AS electronic_invoicing_identifier_7, t0.electronic_invoicing_identifier_scheme AS electronic_invoicing_identifier_scheme_8, t0.electronic_invoicing_intermediator AS electronic_invoicing_intermediator_9, t0.indirect AS indirect_10, t0.name AS name_11, t0.notes AS notes_12, t0.warranty AS warranty_13, t0.address_row_1 AS address_row_1_14, t0.address_row_2 AS address_row_2_15, t0.address_row_3 AS address_row_3_16, t0.address_row_4 AS address_row_4_17, t0.city AS city_18, t0.contact_person_email AS contact_person_email_19, t0.contact_person_name AS contact_person_name_20, t0.country AS country_21, t0.postal_code AS postal_code_22, t0.vat_id AS vat_id_23, t0.terms_of_delivery AS terms_of_delivery_24, t0.terms_of_delivery_rules AS terms_of_delivery_rules_25, t0.transportation AS transportation_26, t0.bank_account_id AS bank_account_id_27, t0.price_group_id AS price_group_id_28, t29.id AS id_30, t29.name AS name_31, t29.notes AS notes_32, t29.company_id AS company_id_33 FROM company t0 LEFT JOIN potential_customer_company t29 ON t29.company_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
15.89 ms
(46.04%)
163
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.phone AS phone_4, t0.role AS role_5, t0.company_id AS company_id_6 FROM potential_customer_company_contact t0 WHERE t0.company_id = ? ORDER BY t0.name ASC
Parameters:
[
  5
]
0.16 ms
(0.48%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.notes AS notes_3, t0.company_id AS company_id_4 FROM potential_customer_company t0 ORDER BY t0.name ASC
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.