Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

11.85 ms Query time

7 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.57 ms
(46.98%)

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)

5.45 ms
(46.00%)

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)

0.83 ms
(7.03%)

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.
App\Entity\BookingItem	No errors.
App\Entity\Booking	The association App\Entity\Booking#products refers to the inverse side field App\Entity\Product#products which does not exist.
App\Entity\Estimate	The mappings App\Entity\Estimate#bookingAgencyTarget and App\Entity\Agency#estimates are inconsistent with each other.
App\Entity\PriceList	No errors.
App\Entity\PromotionCode	No errors.
App\Entity\Calendar	No errors.
App\Entity\OptionStock	No errors.
App\Entity\User	No errors.
App\Entity\Address	No errors.
App\Entity\CalendarClosedDays	No errors.
App\Entity\CalendarOpenDays	No errors.
App\Entity\CalendarBooking	No errors.
App\Entity\Customer	No errors.
App\Entity\BookingItemOption	The mappings App\Entity\BookingItemOption#option and App\Entity\Option#bookingItemOptions are inconsistent with each other.
App\Entity\StateOfPlay	No errors.
App\Entity\Payment	No errors.
App\Entity\GiftCard	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping