Query Metrics

15 Database Queries
6 Different statements
4.50 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.02 ms
(44.85%)
10
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_address AS company_address_3, t0.company_phone AS company_phone_4, t0.company_mail AS company_mail_5, t0.company_other AS company_other_6, t0.price_hour AS price_hour_7 FROM settings t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
0.65 ms
(14.44%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.display_name AS display_name_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.modified AS modified_7, t0.worker_id AS worker_id_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
  5
]
0.58 ms
(12.82%)
1
SELECT count(q0_.id) AS sclr_0 FROM quotes q0_
Parameters:
[]
0.56 ms
(12.41%)
1
SELECT q0_.id AS id_0, q0_.price_sum AS price_sum_1, q0_.price_sum_br AS price_sum_br_2, q0_.note AS note_3, q0_.created AS created_4, q0_.sent_date AS sent_date_5, q0_.updated AS updated_6, q0_.price_bodyguard AS price_bodyguard_7, q0_.price_paint AS price_paint_8, q0_.price_assembly AS price_assembly_9, q0_.tax AS tax_10, q0_.modified AS modified_11, q0_.customer_name AS customer_name_12, q0_.customer_mail AS customer_mail_13, q0_.customer_phone AS customer_phone_14, q0_.customer_address AS customer_address_15, q0_.title AS title_16, q0_.original_text AS original_text_17, q0_.short_desc AS short_desc_18, q0_.status AS status_19, q0_.discovery AS discovery_20, q0_.sent_mail AS sent_mail_21, q0_.parent_id AS parent_id_22 FROM quotes q0_ WHERE q0_.id IN (?, ?, ?, ?, ?) ORDER BY q0_.id DESC, q0_.created DESC
Parameters:
[
  8
  7
  6
  3
  1
]
0.35 ms
(7.86%)
1
SELECT t0.id AS id_1, t0.price_sum AS price_sum_2, t0.price_sum_br AS price_sum_br_3, t0.note AS note_4, t0.created AS created_5, t0.sent_date AS sent_date_6, t0.updated AS updated_7, t0.price_bodyguard AS price_bodyguard_8, t0.price_paint AS price_paint_9, t0.price_assembly AS price_assembly_10, t0.tax AS tax_11, t0.modified AS modified_12, t0.customer_name AS customer_name_13, t0.customer_mail AS customer_mail_14, t0.customer_phone AS customer_phone_15, t0.customer_address AS customer_address_16, t0.title AS title_17, t0.original_text AS original_text_18, t0.short_desc AS short_desc_19, t0.status AS status_20, t0.discovery AS discovery_21, t0.sent_mail AS sent_mail_22, t0.parent_id AS parent_id_23 FROM quotes t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[]
0.34 ms
(7.62%)
1
SELECT DISTINCT q0_.id AS id_0, q0_.id AS id_1, q0_.created AS created_2 FROM quotes q0_ ORDER BY q0_.id DESC, q0_.created DESC LIMIT 20
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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Workers No errors.
App\Entity\Attachment No errors.
App\Entity\Quotes No errors.
App\Entity\QuoteItems No errors.
App\Entity\Settings No errors.