Query Metrics
5
Database Queries
5
Different statements
153.90 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
116.01 ms (75.38%) |
1 |
SELECT DISTINCT r0_.id AS id_0, o1_.created_at AS created_at_1 FROM report r0_ LEFT JOIN "order" o1_ ON r0_.order_id = o1_.id ORDER BY o1_.created_at DESC LIMIT 20
Parameters:
[] |
18.14 ms (11.79%) |
1 |
SELECT r0_.content AS content_0, r0_.price AS price_1, r0_.loaded AS loaded_2, r0_.handled AS handled_3, r0_.id AS id_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.report_type_id AS report_type_id_7, r0_.order_id AS order_id_8 FROM report r0_ LEFT JOIN "order" o1_ ON r0_.order_id = o1_.id WHERE r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o1_.created_at DESC
Parameters:
[ "1efe19ed-7c0d-6872-9885-7d18ff4944c1" "1efe19ed-7c0d-67b4-9885-7d18ff4944c1" "1efe19ed-7c0d-6624-9885-7d18ff4944c1" "1efe1566-70ef-6ef8-817c-e5681939c87a" "1efe1566-70ef-6d86-817c-e5681939c87a" "1efe0c92-ba29-63ee-817c-3b72775ca308" "1efe0c92-ba29-61b4-817c-3b72775ca308" "1efe0c92-ba29-6326-817c-3b72775ca308" "1efe08d5-227e-6a32-b5df-57d2f4dc8807" "1efe08d5-227e-68ac-b5df-57d2f4dc8807" "1efe08d4-8470-6a02-817c-db90d1e05aad" "1efe08d4-8470-67c8-817c-db90d1e05aad" "1efdfe71-e329-6480-817c-7fcded338105" "1efdfe71-e329-6318-817c-7fcded338105" "1efdfe69-8536-62cc-b5df-3f76d63f8cca" "1efdfe69-8536-6498-b5df-3f76d63f8cca" "1efda265-cd49-6178-b5df-c1aa340473fe" "1efda265-cd49-60a6-b5df-c1aa340473fe" "1efda265-cd48-6f20-b5df-c1aa340473fe" "1efd9964-8dd2-6bc0-817c-07eb8befe7bd" ] |
7.05 ms (4.58%) |
1 |
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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ Symfony\Component\Uid\UuidV6 {#1346 : "1efe19ed-7bbe-6a6a-9885-7d18ff4944c1" } Symfony\Component\Uid\UuidV6 {#1322 : "1efe1566-709d-6928-817c-e5681939c87a" } Symfony\Component\Uid\UuidV6 {#1371 : "1efe0c92-b9d2-6b70-817c-3b72775ca308" } Symfony\Component\Uid\UuidV6 {#1384 : "1efe08d5-2230-65da-b5df-57d2f4dc8807" } Symfony\Component\Uid\UuidV6 {#1397 : "1efe08d4-83bc-64a8-817c-db90d1e05aad" } Symfony\Component\Uid\UuidV6 {#1410 : "1efdfe71-e158-6124-817c-7fcded338105" } Symfony\Component\Uid\UuidV6 {#1423 : "1efdfe69-849a-6746-b5df-3f76d63f8cca" } Symfony\Component\Uid\UuidV6 {#1442 : "1efda265-ccf2-6800-b5df-c1aa340473fe" } Symfony\Component\Uid\UuidV6 {#1448 : "1efd9964-8d69-6da0-817c-07eb8befe7bd" } ] |
6.43 ms (4.18%) |
1 |
SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM report r0_ LEFT JOIN "order" o1_ ON r0_.order_id = o1_.id
Parameters:
[] |
6.26 ms (4.07%) |
1 |
SELECT t0.name AS name_1, t0.description AS description_2, t0.id AS id_3 FROM report_type t0 WHERE t0.id IN (?, ?, ?)
Parameters:
[ Symfony\Component\Uid\UuidV6 {#1441 : "1ebb7b93-14ef-69d2-8766-4332412cc6fb" } Symfony\Component\Uid\UuidV6 {#1447 : "1ebb7b93-14c4-6f66-8766-4332412cc6fb" } Symfony\Component\Uid\UuidV6 {#1435 : "1ebb7b93-1496-688c-8766-4332412cc6fb" } ] |
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\Report |
|
App\Entity\Order |
|
App\Entity\ReportType | No errors. |
App\Entity\User | No errors. |
App\Entity\Vin | No errors. |
App\Entity\Promocode | No errors. |