Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

24 Database Queries

5 Different statements

264.48 ms Query time

2 Invalid entities

Queries

Group similar statements


SELECT DISTINCT o0_.id AS id_0, o0_.created_at AS created_at_1 FROM "order" o0_ ORDER BY o0_.created_at DESC LIMIT 20
SELECT o0_.id AS id_0, o0_.email AS email_1, o0_.total_sum AS total_sum_2, o0_.paid AS paid_3, o0_.email_sent AS email_sent_4, o0_.created_at AS created_at_5, o0_.report_link AS report_link_6, o0_.source AS source_7, o0_.email_pre_report_send AS email_pre_report_send_8, o0_.user_id AS user_id_9, o0_.vin_id AS vin_id_10, o0_.promocode_id AS promocode_id_11 FROM "order" o0_ WHERE o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.created_at DESC
SELECT t0.vin AS vin_1, t0.region AS region_2, t0.country AS country_3, t0.model AS model_4, t0.full_model AS full_model_5, t0.manufacturer AS manufacturer_6, t0.year AS year_7, t0.ready AS ready_8, t0.check_sum AS check_sum_9, t0.created_at AS created_at_10, t0.id AS id_11 FROM vin t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT COUNT(o0_.id) AS sclr_0 FROM "order" o0_
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?

#▲	Time	Info
1	6.79 ms	SELECT DISTINCT o0_.id AS id_0, o0_.created_at AS created_at_1 FROM "order" o0_ ORDER BY o0_.created_at DESC LIMIT 20 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT o0_.id AS id_0, o0_.created_at AS created_at_1 FROM "order" o0_ ORDER BY o0_.created_at DESC LIMIT 20 SELECT DISTINCT o0_.id AS id_0, o0_.created_at AS created_at_1 FROM "order" o0_ ORDER BY o0_.created_at DESC LIMIT 20;
2	6.19 ms	SELECT o0_.id AS id_0, o0_.email AS email_1, o0_.total_sum AS total_sum_2, o0_.paid AS paid_3, o0_.email_sent AS email_sent_4, o0_.created_at AS created_at_5, o0_.report_link AS report_link_6, o0_.source AS source_7, o0_.email_pre_report_send AS email_pre_report_send_8, o0_.user_id AS user_id_9, o0_.vin_id AS vin_id_10, o0_.promocode_id AS promocode_id_11 FROM "order" o0_ WHERE o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.created_at DESC Parameters: ["1efe19ed-7bbe-6a6a-9885-7d18ff4944c1" "1efe1566-709d-6928-817c-e5681939c87a" "1efe0c92-b9d2-6b70-817c-3b72775ca308" "1efe08d5-2230-65da-b5df-57d2f4dc8807" "1efe08d4-83bc-64a8-817c-db90d1e05aad" "1efdfe71-e158-6124-817c-7fcded338105" "1efdfe69-849a-6746-b5df-3f76d63f8cca" "1efda265-ccf2-6800-b5df-c1aa340473fe" "1efd9964-8d69-6da0-817c-07eb8befe7bd" "1efd9735-3d66-61b8-b5df-d5e8efedeb99" "1efd8759-6e4a-650e-817c-87798f034bf8" "1efd8750-9e20-620a-817c-c1a3c1d2e096" "1efd8267-d81b-615a-b5df-3d98b7ef7c20" "1efd8038-6ca0-669a-817c-493536ad77f0" "1efd7ded-c21b-6496-9885-5dbe04bbbf40" "1efd7d92-5c11-6228-817c-4530f17ccc22" "1efd7cd3-bfc7-6778-8c63-23ed580c6f39" "1efd7cd0-a3ab-672c-8c63-39d20648e9ef" "1efd56f9-5338-667a-80f5-23b295d07e9d" "1efd5161-bce8-60ae-80f5-eda9777911ea"] View formatted query View runnable query Explain query SELECT o0_.id AS id_0, o0_.email AS email_1, o0_.total_sum AS total_sum_2, o0_.paid AS paid_3, o0_.email_sent AS email_sent_4, o0_.created_at AS created_at_5, o0_.report_link AS report_link_6, o0_.source AS source_7, o0_.email_pre_report_send AS email_pre_report_send_8, o0_.user_id AS user_id_9, o0_.vin_id AS vin_id_10, o0_.promocode_id AS promocode_id_11 FROM "order" o0_ WHERE o0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY o0_.created_at DESC SELECT o0_.id AS id_0, o0_.email AS email_1, o0_.total_sum AS total_sum_2, o0_.paid AS paid_3, o0_.email_sent AS email_sent_4, o0_.created_at AS created_at_5, o0_.report_link AS report_link_6, o0_.source AS source_7, o0_.email_pre_report_send AS email_pre_report_send_8, o0_.user_id AS user_id_9, o0_.vin_id AS vin_id_10, o0_.promocode_id AS promocode_id_11 FROM "order" o0_ WHERE o0_.id IN ('1efe19ed-7bbe-6a6a-9885-7d18ff4944c1', '1efe1566-709d-6928-817c-e5681939c87a', '1efe0c92-b9d2-6b70-817c-3b72775ca308', '1efe08d5-2230-65da-b5df-57d2f4dc8807', '1efe08d4-83bc-64a8-817c-db90d1e05aad', '1efdfe71-e158-6124-817c-7fcded338105', '1efdfe69-849a-6746-b5df-3f76d63f8cca', '1efda265-ccf2-6800-b5df-c1aa340473fe', '1efd9964-8d69-6da0-817c-07eb8befe7bd', '1efd9735-3d66-61b8-b5df-d5e8efedeb99', '1efd8759-6e4a-650e-817c-87798f034bf8', '1efd8750-9e20-620a-817c-c1a3c1d2e096', '1efd8267-d81b-615a-b5df-3d98b7ef7c20', '1efd8038-6ca0-669a-817c-493536ad77f0', '1efd7ded-c21b-6496-9885-5dbe04bbbf40', '1efd7d92-5c11-6228-817c-4530f17ccc22', '1efd7cd3-bfc7-6778-8c63-23ed580c6f39', '1efd7cd0-a3ab-672c-8c63-39d20648e9ef', '1efd56f9-5338-667a-80f5-23b295d07e9d', '1efd5161-bce8-60ae-80f5-eda9777911ea') ORDER BY o0_.created_at DESC;
3	7.02 ms	SELECT t0.vin AS vin_1, t0.region AS region_2, t0.country AS country_3, t0.model AS model_4, t0.full_model AS full_model_5, t0.manufacturer AS manufacturer_6, t0.year AS year_7, t0.ready AS ready_8, t0.check_sum AS check_sum_9, t0.created_at AS created_at_10, t0.id AS id_11 FROM vin t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [Symfony\Component\Uid\UuidV6 {#1543 __toString(): "1ed4aef5-2340-60dc-a8d7-c3bb52b609ab" } Symfony\Component\Uid\UuidV6 {#1445 __toString(): "1efe1566-25ac-6f54-9885-abffd6590cff" } Symfony\Component\Uid\UuidV6 {#1453 __toString(): "1efe0c91-979c-6818-817c-1fe8cacb821b" } Symfony\Component\Uid\UuidV6 {#1469 __toString(): "1efe08d4-1a62-66f6-b5df-29abe2757ad5" } Symfony\Component\Uid\UuidV6 {#1484 __toString(): "1efdfe68-cb8a-6cc4-b5df-ab083331a2b2" } Symfony\Component\Uid\UuidV6 {#1505 __toString(): "1efd9734-991e-6e34-817c-d15e324857dd" } Symfony\Component\Uid\UuidV6 {#1513 __toString(): "1efb2acb-519f-66f8-ad4d-8def60f80aaa" } Symfony\Component\Uid\UuidV6 {#1535 __toString(): "1efb2ace-2d0f-636c-b459-39122b53a88c" } Symfony\Component\Uid\UuidV6 {#1580 __toString(): "1efb2acd-643e-610e-9a29-9f9377863ec5" } Symfony\Component\Uid\UuidV6 {#1573 __toString(): "1efb2ac6-8dde-6c86-b459-85217097e2c6" }] View formatted query View runnable query SELECT t0.vin AS vin_1, t0.region AS region_2, t0.country AS country_3, t0.model AS model_4, t0.full_model AS full_model_5, t0.manufacturer AS manufacturer_6, t0.year AS year_7, t0.ready AS ready_8, t0.check_sum AS check_sum_9, t0.created_at AS created_at_10, t0.id AS id_11 FROM vin t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT t0.vin AS vin_1, t0.region AS region_2, t0.country AS country_3, t0.model AS model_4, t0.full_model AS full_model_5, t0.manufacturer AS manufacturer_6, t0.year AS year_7, t0.ready AS ready_8, t0.check_sum AS check_sum_9, t0.created_at AS created_at_10, t0.id AS id_11 FROM vin t0 WHERE t0.id IN ('1ed4aef5-2340-60dc-a8d7-c3bb52b609ab', '1efe1566-25ac-6f54-9885-abffd6590cff', '1efe0c91-979c-6818-817c-1fe8cacb821b', '1efe08d4-1a62-66f6-b5df-29abe2757ad5', '1efdfe68-cb8a-6cc4-b5df-ab083331a2b2', '1efd9734-991e-6e34-817c-d15e324857dd', '1efb2acb-519f-66f8-ad4d-8def60f80aaa', '1efb2ace-2d0f-636c-b459-39122b53a88c', '1efb2acd-643e-610e-9a29-9f9377863ec5', '1efb2ac6-8dde-6c86-b459-85217097e2c6');
4	7.79 ms	SELECT COUNT(o0_.id) AS sclr_0 FROM "order" o0_ Parameters: [] View formatted query View runnable query Explain query SELECT COUNT(o0_.id) AS sclr_0 FROM "order" o0_ SELECT COUNT(o0_.id) AS sclr_0 FROM "order" o0_;
5	6.76 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"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efe19ed-7bbe-6a6a-9885-7d18ff4944c1';
6	6.39 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: [`"1efe1566-709d-6928-817c-e5681939c87a"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efe1566-709d-6928-817c-e5681939c87a';
7	6.68 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: [`"1efe0c92-b9d2-6b70-817c-3b72775ca308"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efe0c92-b9d2-6b70-817c-3b72775ca308';
8	6.40 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: [`"1efe08d5-2230-65da-b5df-57d2f4dc8807"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efe08d5-2230-65da-b5df-57d2f4dc8807';
9	8.39 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: [`"1efe08d4-83bc-64a8-817c-db90d1e05aad"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efe08d4-83bc-64a8-817c-db90d1e05aad';
10	6.45 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: [`"1efdfe71-e158-6124-817c-7fcded338105"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efdfe71-e158-6124-817c-7fcded338105';
11	6.62 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: [`"1efdfe69-849a-6746-b5df-3f76d63f8cca"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efdfe69-849a-6746-b5df-3f76d63f8cca';
12	46.99 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: [`"1efda265-ccf2-6800-b5df-c1aa340473fe"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efda265-ccf2-6800-b5df-c1aa340473fe';
13	9.20 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: [`"1efd9964-8d69-6da0-817c-07eb8befe7bd"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efd9964-8d69-6da0-817c-07eb8befe7bd';
14	41.26 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: [`"1efd9735-3d66-61b8-b5df-d5e8efedeb99"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efd9735-3d66-61b8-b5df-d5e8efedeb99';
15	7.21 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: [`"1efd8759-6e4a-650e-817c-87798f034bf8"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efd8759-6e4a-650e-817c-87798f034bf8';
16	6.75 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: [`"1efd8750-9e20-620a-817c-c1a3c1d2e096"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efd8750-9e20-620a-817c-c1a3c1d2e096';
17	6.63 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: [`"1efd8267-d81b-615a-b5df-3d98b7ef7c20"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efd8267-d81b-615a-b5df-3d98b7ef7c20';
18	6.34 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: [`"1efd8038-6ca0-669a-817c-493536ad77f0"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efd8038-6ca0-669a-817c-493536ad77f0';
19	6.33 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: [`"1efd7ded-c21b-6496-9885-5dbe04bbbf40"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efd7ded-c21b-6496-9885-5dbe04bbbf40';
20	6.33 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: [`"1efd7d92-5c11-6228-817c-4530f17ccc22"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efd7d92-5c11-6228-817c-4530f17ccc22';
21	6.35 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: [`"1efd7cd3-bfc7-6778-8c63-23ed580c6f39"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efd7cd3-bfc7-6778-8c63-23ed580c6f39';
22	8.97 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: [`"1efd7cd0-a3ab-672c-8c63-39d20648e9ef"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efd7cd0-a3ab-672c-8c63-39d20648e9ef';
23	6.41 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: [`"1efd56f9-5338-667a-80f5-23b295d07e9d"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efd56f9-5338-667a-80f5-23b295d07e9d';
24	30.22 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: [`"1efd5161-bce8-60ae-80f5-eda9777911ea"`] View formatted query View runnable query Explain query 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 = ? 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 = '1efd5161-bce8-60ae-80f5-eda9777911ea';

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\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\User	No errors.
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.

Symfony Profiler

https://vin.adevinta.t.crtweb.ru/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5COrderCrudController

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping