Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

11.52 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲

Time

Info

5.41 ms

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN brand_model b1_ ON p0_.model_id = b1_.id LEFT JOIN brand b2_ ON b1_.brand_id = b2_.id LEFT JOIN product_category p3_ ON p0_.product_category_id = p3_.id LEFT JOIN vehicle_document v4_ ON p0_.vehicle_document_id = v4_.id LEFT JOIN agency a5_ ON p0_.agency_id = a5_.id LEFT JOIN images i6_ ON p0_.id = i6_.product_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN brand_model b1_ ON p0_.model_id = b1_.id
  LEFT JOIN brand b2_ ON b1_.brand_id = b2_.id
  LEFT JOIN product_category p3_ ON p0_.product_category_id = p3_.id
  LEFT JOIN vehicle_document v4_ ON p0_.vehicle_document_id = v4_.id
  LEFT JOIN agency a5_ ON p0_.agency_id = a5_.id
  LEFT JOIN images i6_ ON p0_.id = i6_.product_id

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN brand_model b1_ ON p0_.model_id = b1_.id LEFT JOIN brand b2_ ON b1_.brand_id = b2_.id LEFT JOIN product_category p3_ ON p0_.product_category_id = p3_.id LEFT JOIN vehicle_document v4_ ON p0_.vehicle_document_id = v4_.id LEFT JOIN agency a5_ ON p0_.agency_id = a5_.id LEFT JOIN images i6_ ON p0_.id = i6_.product_id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 49)
8	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 68)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 103)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 51)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 92)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 58)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
14	Symfony\Component\Serializer\Serializer->normalize (line 138)
15	Symfony\Component\Serializer\Serializer->serialize (line 47)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
18	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 116)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 186)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

5.35 ms

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ LEFT JOIN brand_model b1_ ON p0_.model_id = b1_.id LEFT JOIN brand b2_ ON b1_.brand_id = b2_.id LEFT JOIN product_category p3_ ON p0_.product_category_id = p3_.id LEFT JOIN vehicle_document v4_ ON p0_.vehicle_document_id = v4_.id LEFT JOIN agency a5_ ON p0_.agency_id = a5_.id LEFT JOIN images i6_ ON p0_.id = i6_.product_id ORDER BY p0_.id ASC LIMIT 30

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.id AS id_1
FROM
  product p0_
  LEFT JOIN brand_model b1_ ON p0_.model_id = b1_.id
  LEFT JOIN brand b2_ ON b1_.brand_id = b2_.id
  LEFT JOIN product_category p3_ ON p0_.product_category_id = p3_.id
  LEFT JOIN vehicle_document v4_ ON p0_.vehicle_document_id = v4_.id
  LEFT JOIN agency a5_ ON p0_.agency_id = a5_.id
  LEFT JOIN images i6_ ON p0_.id = i6_.product_id
ORDER BY
  p0_.id ASC
LIMIT
  30

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ LEFT JOIN brand_model b1_ ON p0_.model_id = b1_.id LEFT JOIN brand b2_ ON b1_.brand_id = b2_.id LEFT JOIN product_category p3_ ON p0_.product_category_id = p3_.id LEFT JOIN vehicle_document v4_ ON p0_.vehicle_document_id = v4_.id LEFT JOIN agency a5_ ON p0_.agency_id = a5_.id LEFT JOIN images i6_ ON p0_.id = i6_.product_id ORDER BY p0_.id ASC LIMIT 30;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 87)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 110)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 51)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 92)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 58)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
14	Symfony\Component\Serializer\Serializer->normalize (line 138)
15	Symfony\Component\Serializer\Serializer->serialize (line 47)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
18	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 116)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 186)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.76 ms

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.label AS label_2, p0_.updated_at AS updated_at_3, b1_.id AS id_4, b1_.label AS label_5, b1_.updated_at AS updated_at_6, b2_.id AS id_7, b2_.label AS label_8, p3_.id AS id_9, p3_.label AS label_10, p3_.type AS type_11, p3_.reference AS reference_12, p3_.updated_at AS updated_at_13, v4_.id AS id_14, v4_.created_at AS created_at_15, v4_.updated_at AS updated_at_16, v4_.immatriculation AS immatriculation_17, v4_.immatriculation_date AS immatriculation_date_18, v4_.type AS type_19, v4_.image_front AS image_front_20, v4_.image_back AS image_back_21, v4_.serial_number AS serial_number_22, v4_.car_body AS car_body_23, v4_.energy AS energy_24, v4_.tank_capacity AS tank_capacity_25, v4_.color AS color_26, v4_.tax_horsepower AS tax_horsepower_27, v4_.purchase_date AS purchase_date_28, v4_.purchase_price AS purchase_price_29, v4_.co2 AS co2_30, v4_.date1st_circulation AS date1st_circulation_31, v4_.gears AS gears_32, v4_.passengers AS passengers_33, v4_.doors AS doors_34, v4_.weight AS weight_35, v4_.commercial_name AS commercial_name_36, v4_.brand_logo AS brand_logo_37, v4_.km AS km_38, a5_.id AS id_39, a5_.name AS name_40, a5_.type AS type_41, a5_.description AS description_42, a5_.picture AS picture_43, a5_.reference AS reference_44, a5_.phone AS phone_45, a5_.email AS email_46, a5_.is_visible AS is_visible_47, a5_.is_open AS is_open_48, a5_.updated_at AS updated_at_49, i6_.id AS id_50, i6_.file_path AS file_path_51, i6_.file_url AS file_url_52, i6_.default_image AS default_image_53, p0_.model_id AS model_id_54, p0_.product_category_id AS product_category_id_55, p0_.vehicle_document_id AS vehicle_document_id_56, p0_.agency_id AS agency_id_57, b1_.brand_id AS brand_id_58, a5_.company_id AS company_id_59, a5_.vat_id AS vat_id_60, a5_.currency_id AS currency_id_61, i6_.product_id AS product_id_62, i6_.agency_id AS agency_id_63, i6_.product_category_id AS product_category_id_64, i6_.insurance_id AS insurance_id_65, i6_.option_img_id AS option_img_id_66, i6_.activity_id AS activity_id_67, i6_.brand_model_id AS brand_model_id_68, i6_.product_event_id AS product_event_id_69, i6_.memo_id AS memo_id_70 FROM product p0_ LEFT JOIN brand_model b1_ ON p0_.model_id = b1_.id LEFT JOIN brand b2_ ON b1_.brand_id = b2_.id LEFT JOIN product_category p3_ ON p0_.product_category_id = p3_.id LEFT JOIN vehicle_document v4_ ON p0_.vehicle_document_id = v4_.id LEFT JOIN agency a5_ ON p0_.agency_id = a5_.id LEFT JOIN images i6_ ON p0_.id = i6_.product_id WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1,
  p0_.label AS label_2,
  p0_.updated_at AS updated_at_3,
  b1_.id AS id_4,
  b1_.label AS label_5,
  b1_.updated_at AS updated_at_6,
  b2_.id AS id_7,
  b2_.label AS label_8,
  p3_.id AS id_9,
  p3_.label AS label_10,
  p3_.type AS type_11,
  p3_.reference AS reference_12,
  p3_.updated_at AS updated_at_13,
  v4_.id AS id_14,
  v4_.created_at AS created_at_15,
  v4_.updated_at AS updated_at_16,
  v4_.immatriculation AS immatriculation_17,
  v4_.immatriculation_date AS immatriculation_date_18,
  v4_.type AS type_19,
  v4_.image_front AS image_front_20,
  v4_.image_back AS image_back_21,
  v4_.serial_number AS serial_number_22,
  v4_.car_body AS car_body_23,
  v4_.energy AS energy_24,
  v4_.tank_capacity AS tank_capacity_25,
  v4_.color AS color_26,
  v4_.tax_horsepower AS tax_horsepower_27,
  v4_.purchase_date AS purchase_date_28,
  v4_.purchase_price AS purchase_price_29,
  v4_.co2 AS co2_30,
  v4_.date1st_circulation AS date1st_circulation_31,
  v4_.gears AS gears_32,
  v4_.passengers AS passengers_33,
  v4_.doors AS doors_34,
  v4_.weight AS weight_35,
  v4_.commercial_name AS commercial_name_36,
  v4_.brand_logo AS brand_logo_37,
  v4_.km AS km_38,
  a5_.id AS id_39,
  a5_.name AS name_40,
  a5_.type AS type_41,
  a5_.description AS description_42,
  a5_.picture AS picture_43,
  a5_.reference AS reference_44,
  a5_.phone AS phone_45,
  a5_.email AS email_46,
  a5_.is_visible AS is_visible_47,
  a5_.is_open AS is_open_48,
  a5_.updated_at AS updated_at_49,
  i6_.id AS id_50,
  i6_.file_path AS file_path_51,
  i6_.file_url AS file_url_52,
  i6_.default_image AS default_image_53,
  p0_.model_id AS model_id_54,
  p0_.product_category_id AS product_category_id_55,
  p0_.vehicle_document_id AS vehicle_document_id_56,
  p0_.agency_id AS agency_id_57,
  b1_.brand_id AS brand_id_58,
  a5_.company_id AS company_id_59,
  a5_.vat_id AS vat_id_60,
  a5_.currency_id AS currency_id_61,
  i6_.product_id AS product_id_62,
  i6_.agency_id AS agency_id_63,
  i6_.product_category_id AS product_category_id_64,
  i6_.insurance_id AS insurance_id_65,
  i6_.option_img_id AS option_img_id_66,
  i6_.activity_id AS activity_id_67,
  i6_.brand_model_id AS brand_model_id_68,
  i6_.product_event_id AS product_event_id_69,
  i6_.memo_id AS memo_id_70
FROM
  product p0_
  LEFT JOIN brand_model b1_ ON p0_.model_id = b1_.id
  LEFT JOIN brand b2_ ON b1_.brand_id = b2_.id
  LEFT JOIN product_category p3_ ON p0_.product_category_id = p3_.id
  LEFT JOIN vehicle_document v4_ ON p0_.vehicle_document_id = v4_.id
  LEFT JOIN agency a5_ ON p0_.agency_id = a5_.id
  LEFT JOIN images i6_ ON p0_.id = i6_.product_id
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.label AS label_2, p0_.updated_at AS updated_at_3, b1_.id AS id_4, b1_.label AS label_5, b1_.updated_at AS updated_at_6, b2_.id AS id_7, b2_.label AS label_8, p3_.id AS id_9, p3_.label AS label_10, p3_.type AS type_11, p3_.reference AS reference_12, p3_.updated_at AS updated_at_13, v4_.id AS id_14, v4_.created_at AS created_at_15, v4_.updated_at AS updated_at_16, v4_.immatriculation AS immatriculation_17, v4_.immatriculation_date AS immatriculation_date_18, v4_.type AS type_19, v4_.image_front AS image_front_20, v4_.image_back AS image_back_21, v4_.serial_number AS serial_number_22, v4_.car_body AS car_body_23, v4_.energy AS energy_24, v4_.tank_capacity AS tank_capacity_25, v4_.color AS color_26, v4_.tax_horsepower AS tax_horsepower_27, v4_.purchase_date AS purchase_date_28, v4_.purchase_price AS purchase_price_29, v4_.co2 AS co2_30, v4_.date1st_circulation AS date1st_circulation_31, v4_.gears AS gears_32, v4_.passengers AS passengers_33, v4_.doors AS doors_34, v4_.weight AS weight_35, v4_.commercial_name AS commercial_name_36, v4_.brand_logo AS brand_logo_37, v4_.km AS km_38, a5_.id AS id_39, a5_.name AS name_40, a5_.type AS type_41, a5_.description AS description_42, a5_.picture AS picture_43, a5_.reference AS reference_44, a5_.phone AS phone_45, a5_.email AS email_46, a5_.is_visible AS is_visible_47, a5_.is_open AS is_open_48, a5_.updated_at AS updated_at_49, i6_.id AS id_50, i6_.file_path AS file_path_51, i6_.file_url AS file_url_52, i6_.default_image AS default_image_53, p0_.model_id AS model_id_54, p0_.product_category_id AS product_category_id_55, p0_.vehicle_document_id AS vehicle_document_id_56, p0_.agency_id AS agency_id_57, b1_.brand_id AS brand_id_58, a5_.company_id AS company_id_59, a5_.vat_id AS vat_id_60, a5_.currency_id AS currency_id_61, i6_.product_id AS product_id_62, i6_.agency_id AS agency_id_63, i6_.product_category_id AS product_category_id_64, i6_.insurance_id AS insurance_id_65, i6_.option_img_id AS option_img_id_66, i6_.activity_id AS activity_id_67, i6_.brand_model_id AS brand_model_id_68, i6_.product_event_id AS product_event_id_69, i6_.memo_id AS memo_id_70 FROM product p0_ LEFT JOIN brand_model b1_ ON p0_.model_id = b1_.id LEFT JOIN brand b2_ ON b1_.brand_id = b2_.id LEFT JOIN product_category p3_ ON p0_.product_category_id = p3_.id LEFT JOIN vehicle_document v4_ ON p0_.vehicle_document_id = v4_.id LEFT JOIN agency a5_ ON p0_.agency_id = a5_.id LEFT JOIN images i6_ ON p0_.id = i6_.product_id WHERE p0_.id IN (6213, 6215, 6216, 6217, 6218, 8395, 8396, 8397, 8398, 8399, 8400, 8401, 8402, 8403, 8404, 8405, 8406, 8407, 8408, 8409, 8410, 8411, 8412, 8413, 8414, 8415, 8416, 8417, 8418, 8419) ORDER BY p0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 87)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 110)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 51)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 92)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 58)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
14	Symfony\Component\Serializer\Serializer->normalize (line 138)
15	Symfony\Component\Serializer\Serializer->serialize (line 47)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
18	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 116)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 186)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

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\Product	The mappings App\Entity\Product#bookings and App\Entity\Booking#products are inconsistent with each other.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\BrandModel	No errors.
App\Entity\ProductCategory	The mappings App\Entity\ProductCategory#agencies and App\Entity\Agency#productCategories are inconsistent with each other.
App\Entity\VehicleDocument	No errors.
App\Entity\Agency	The association App\Entity\Agency#options refers to the owning side field App\Entity\Option#Agency which does not exist. The association App\Entity\Agency#productCategories refers to the inverse side field App\Entity\ProductCategory#agency which does not exist.
App\Entity\Images	No errors.
App\Entity\Brand	No errors.
App\Entity\Company	No errors.
App\Entity\Vat	No errors.
App\Entity\Currency	No errors.
App\Entity\Insurance	No errors.
App\Entity\Option	The association App\Entity\Option#bookingItemOptions refers to the owning side field App\Entity\BookingItemOption#options which does not exist.
App\Entity\Activity	No errors.
App\Entity\ProductEvent	No errors.
App\Entity\Memo	No errors.

Symfony Profiler

GET https://www.bo.blacksheep-van.com/api/products.jsonld

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping