Query Metrics
3
Database Queries
3
Different statements
22.03 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 7.66 ms |
SELECT t0.password AS password_1, t0.roles AS roles_2, t0.id AS id_3 FROM "user" t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"1efae476-a490-6cfe-80d9-45e87b41dacd"
]
|
2 | 7.56 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.total_sum AS total_sum_3, t0.paid AS paid_4, t0.email_sent AS email_sent_5, t0.created_at AS created_at_6, t0.report_link AS report_link_7, t0.source AS source_8, t0.email_pre_report_send AS email_pre_report_send_9, t0.user_id AS user_id_10, t0.vin_id AS vin_id_11, t12.vin AS vin_13, t12.region AS region_14, t12.country AS country_15, t12.model AS model_16, t12.full_model AS full_model_17, t12.manufacturer AS manufacturer_18, t12.year AS year_19, t12.ready AS ready_20, t12.check_sum AS check_sum_21, t12.created_at AS created_at_22, t12.id AS id_23, t0.promocode_id AS promocode_id_24 FROM "order" t0 INNER JOIN vin t12 ON t0.vin_id = t12.id WHERE t0.id = ?
Parameters:
[
"1efe19ed-7bbe-6a6a-9885-7d18ff4944c1"
]
|
3 | 6.80 ms |
SELECT t0.content AS content_1, t0.price AS price_2, t0.loaded AS loaded_3, t0.handled AS handled_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.report_type_id AS report_type_id_8, t9.name AS name_10, t9.description AS description_11, t9.id AS id_12, t0.order_id AS order_id_13, t14.id AS id_15, t14.email AS email_16, t14.total_sum AS total_sum_17, t14.paid AS paid_18, t14.email_sent AS email_sent_19, t14.created_at AS created_at_20, t14.report_link AS report_link_21, t14.source AS source_22, t14.email_pre_report_send AS email_pre_report_send_23, t14.user_id AS user_id_24, t14.vin_id AS vin_id_25, t14.promocode_id AS promocode_id_26 FROM report t0 INNER JOIN report_type t9 ON t0.report_type_id = t9.id LEFT JOIN "order" t14 ON t0.order_id = t14.id WHERE t0.order_id = ?
Parameters:
[
"1efe19ed-7bbe-6a6a-9885-7d18ff4944c1"
]
|
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\Order |
|
App\Entity\Vin | No errors. |
App\Entity\Promocode | No errors. |
App\Entity\Report |
|
App\Entity\ReportType | No errors. |