Query Metrics
15
Database Queries
6
Different statements
4.50 ms
Query time
0
Invalid entities
Grouped Statements
| 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. |