Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.21 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.21 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 = ?

Parameters:

[
  9348
]

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 = ?

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 = 9348;

#	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 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 87)
7	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 76)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 87)
10	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
11	ApiPlatform\State\Provider\ParameterProvider->provide (line 50)
12	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 95)
14	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\Product	The mappings App\Entity\Product#bookings and App\Entity\Booking#products are inconsistent with each other.
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/9348

Configuration Settings

Theme