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

Query Metrics

5 Database Queries
5 Different statements
153.90 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

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
    __toString(): "1efe19ed-7bbe-6a6a-9885-7d18ff4944c1"
  }
  Symfony\Component\Uid\UuidV6 {#1322
    __toString(): "1efe1566-709d-6928-817c-e5681939c87a"
  }
  Symfony\Component\Uid\UuidV6 {#1371
    __toString(): "1efe0c92-b9d2-6b70-817c-3b72775ca308"
  }
  Symfony\Component\Uid\UuidV6 {#1384
    __toString(): "1efe08d5-2230-65da-b5df-57d2f4dc8807"
  }
  Symfony\Component\Uid\UuidV6 {#1397
    __toString(): "1efe08d4-83bc-64a8-817c-db90d1e05aad"
  }
  Symfony\Component\Uid\UuidV6 {#1410
    __toString(): "1efdfe71-e158-6124-817c-7fcded338105"
  }
  Symfony\Component\Uid\UuidV6 {#1423
    __toString(): "1efdfe69-849a-6746-b5df-3f76d63f8cca"
  }
  Symfony\Component\Uid\UuidV6 {#1442
    __toString(): "1efda265-ccf2-6800-b5df-c1aa340473fe"
  }
  Symfony\Component\Uid\UuidV6 {#1448
    __toString(): "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
    __toString(): "1ebb7b93-14ef-69d2-8766-4332412cc6fb"
  }
  Symfony\Component\Uid\UuidV6 {#1447
    __toString(): "1ebb7b93-14c4-6f66-8766-4332412cc6fb"
  }
  Symfony\Component\Uid\UuidV6 {#1435
    __toString(): "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
  • 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\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\ReportType No errors.
App\Entity\User No errors.
App\Entity\Vin No errors.
App\Entity\Promocode No errors.