https://api.vin.adevinta.t.crtweb.ru/api/order/1efe19ed-7bbe-6a6a-9885-7d18ff4944c1

Query Metrics

3 Database Queries
3 Different statements
22.03 ms Query time
2 Invalid entities

Queries

Group similar statements

# 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
  • The field 'App\Entity\Order#totalSum' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Vin No errors.
App\Entity\Promocode No errors.
App\Entity\Report
  • The field 'App\Entity\Report#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ReportType No errors.