Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.80 ms Query time

7 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.80 ms
(100.00%)

SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.value AS value_2, p0_.amount AS amount_3, p0_.type AS type_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.date_begin AS date_begin_7, p0_.date_end AS date_end_8, p0_.percentage AS percentage_9, p0_.description AS description_10, p0_.minimal_booking_days AS minimal_booking_days_11, p0_.date_purchase_start AS date_purchase_start_12, p0_.date_purchase_end AS date_purchase_end_13, a1_.id AS id_14, a1_.name AS name_15, a1_.type AS type_16, a1_.description AS description_17, a1_.picture AS picture_18, a1_.reference AS reference_19, a1_.phone AS phone_20, a1_.email AS email_21, a1_.is_visible AS is_visible_22, a1_.is_open AS is_open_23, a1_.updated_at AS updated_at_24, c2_.id AS id_25, c2_.name AS name_26, c2_.siren AS siren_27, c2_.siret AS siret_28, c2_.creation_date AS creation_date_29, c2_.tvaintra AS tvaintra_30, v3_.id AS id_31, v3_.country AS country_32, v3_.country_code AS country_code_33, v3_.standard_rate AS standard_rate_34, v3_.parking_rate AS parking_rate_35, v3_.reduced_rate1 AS reduced_rate1_36, v3_.reduced_rate2 AS reduced_rate2_37, v3_.super_reduced_rate AS super_reduced_rate_38, v3_.zero_rate AS zero_rate_39, p4_.id AS id_40, p4_.label AS label_41, p4_.type AS type_42, p4_.reference AS reference_43, p4_.updated_at AS updated_at_44, b5_.id AS id_45, b5_.price AS price_46, b5_.quantity AS quantity_47, b5_.vat_amount AS vat_amount_48, p6_.id AS id_49, p6_.type AS type_50, p6_.label AS label_51, p6_.updated_at AS updated_at_52, a7_.id AS id_53, a7_.label AS label_54, a7_.description AS description_55, a7_.price AS price_56, a7_.date_begin AS date_begin_57, a7_.date_end AS date_end_58, a7_.updated_at AS updated_at_59, a7_.is_activity_calculated_per_day AS is_activity_calculated_per_day_60, a7_.is_activity_calculated_per_booking AS is_activity_calculated_per_booking_61, i8_.id AS id_62, i8_.label AS label_63, i8_.description AS description_64, i8_.price AS price_65, i8_.updated_at AS updated_at_66, b9_.id AS id_67, b9_.reference AS reference_68, b9_.date_begin AS date_begin_69, b9_.date_end AS date_end_70, b9_.total_price AS total_price_71, b9_.total_days AS total_days_72, b9_.created_at AS created_at_73, b9_.status AS status_74, b9_.estimate_id AS estimate_id_75, b9_.updated_at AS updated_at_76, a10_.id AS id_77, a10_.name AS name_78, a10_.type AS type_79, a10_.description AS description_80, a10_.picture AS picture_81, a10_.reference AS reference_82, a10_.phone AS phone_83, a10_.email AS email_84, a10_.is_visible AS is_visible_85, a10_.is_open AS is_open_86, a10_.updated_at AS updated_at_87, c11_.id AS id_88, c11_.name AS name_89, c11_.siren AS siren_90, c11_.siret AS siret_91, c11_.creation_date AS creation_date_92, c11_.tvaintra AS tvaintra_93, v12_.id AS id_94, v12_.country AS country_95, v12_.country_code AS country_code_96, v12_.standard_rate AS standard_rate_97, v12_.parking_rate AS parking_rate_98, v12_.reduced_rate1 AS reduced_rate1_99, v12_.reduced_rate2 AS reduced_rate2_100, v12_.super_reduced_rate AS super_reduced_rate_101, v12_.zero_rate AS zero_rate_102, c13_.id AS id_103, c13_.first_name AS first_name_104, c13_.last_name AS last_name_105, c13_.is_activated AS is_activated_106, c13_.email AS email_107, c13_.phone AS phone_108, c13_.birth_date AS birth_date_109, c13_.language AS language_110, c13_.created_at AS created_at_111, c13_.updated_at AS updated_at_112, c13_.password AS password_113, c13_.rattache_company AS rattache_company_114, a1_.company_id AS company_id_115, a1_.vat_id AS vat_id_116, a1_.currency_id AS currency_id_117, b5_.product_id AS product_id_118, b5_.activity_id AS activity_id_119, b5_.insurance_id AS insurance_id_120, b5_.booking_id AS booking_id_121, b5_.estimate_id AS estimate_id_122, b5_.promotion_code_id AS promotion_code_id_123, p6_.model_id AS model_id_124, p6_.product_category_id AS product_category_id_125, p6_.vehicle_document_id AS vehicle_document_id_126, p6_.agency_id AS agency_id_127, b9_.user_id AS user_id_128, b9_.booking_agency_source_id AS booking_agency_source_id_129, b9_.booking_agency_target_id AS booking_agency_target_id_130, b9_.customer_id AS customer_id_131, a10_.company_id AS company_id_132, a10_.vat_id AS vat_id_133, a10_.currency_id AS currency_id_134 FROM promotion_code p0_ LEFT JOIN promotion_code_agency p14_ ON p0_.id = p14_.promotion_code_id LEFT JOIN agency a1_ ON a1_.id = p14_.agency_id LEFT JOIN company c2_ ON a1_.company_id = c2_.id LEFT JOIN vat v3_ ON a1_.vat_id = v3_.id LEFT JOIN promotion_code_product_category p15_ ON p0_.id = p15_.promotion_code_id LEFT JOIN product_category p4_ ON p4_.id = p15_.product_category_id LEFT JOIN booking_item b5_ ON p0_.id = b5_.promotion_code_id LEFT JOIN product p6_ ON b5_.product_id = p6_.id LEFT JOIN activity a7_ ON b5_.activity_id = a7_.id LEFT JOIN insurance i8_ ON b5_.insurance_id = i8_.id LEFT JOIN booking b9_ ON b5_.booking_id = b9_.id LEFT JOIN agency a10_ ON b9_.booking_agency_source_id = a10_.id LEFT JOIN company c11_ ON a10_.company_id = c11_.id LEFT JOIN vat v12_ ON a10_.vat_id = v12_.id LEFT JOIN customer c13_ ON b9_.customer_id = c13_.id WHERE p0_.id = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.label AS label_1,
  p0_.value AS value_2,
  p0_.amount AS amount_3,
  p0_.type AS type_4,
  p0_.created_at AS created_at_5,
  p0_.updated_at AS updated_at_6,
  p0_.date_begin AS date_begin_7,
  p0_.date_end AS date_end_8,
  p0_.percentage AS percentage_9,
  p0_.description AS description_10,
  p0_.minimal_booking_days AS minimal_booking_days_11,
  p0_.date_purchase_start AS date_purchase_start_12,
  p0_.date_purchase_end AS date_purchase_end_13,
  a1_.id AS id_14,
  a1_.name AS name_15,
  a1_.type AS type_16,
  a1_.description AS description_17,
  a1_.picture AS picture_18,
  a1_.reference AS reference_19,
  a1_.phone AS phone_20,
  a1_.email AS email_21,
  a1_.is_visible AS is_visible_22,
  a1_.is_open AS is_open_23,
  a1_.updated_at AS updated_at_24,
  c2_.id AS id_25,
  c2_.name AS name_26,
  c2_.siren AS siren_27,
  c2_.siret AS siret_28,
  c2_.creation_date AS creation_date_29,
  c2_.tvaintra AS tvaintra_30,
  v3_.id AS id_31,
  v3_.country AS country_32,
  v3_.country_code AS country_code_33,
  v3_.standard_rate AS standard_rate_34,
  v3_.parking_rate AS parking_rate_35,
  v3_.reduced_rate1 AS reduced_rate1_36,
  v3_.reduced_rate2 AS reduced_rate2_37,
  v3_.super_reduced_rate AS super_reduced_rate_38,
  v3_.zero_rate AS zero_rate_39,
  p4_.id AS id_40,
  p4_.label AS label_41,
  p4_.type AS type_42,
  p4_.reference AS reference_43,
  p4_.updated_at AS updated_at_44,
  b5_.id AS id_45,
  b5_.price AS price_46,
  b5_.quantity AS quantity_47,
  b5_.vat_amount AS vat_amount_48,
  p6_.id AS id_49,
  p6_.type AS type_50,
  p6_.label AS label_51,
  p6_.updated_at AS updated_at_52,
  a7_.id AS id_53,
  a7_.label AS label_54,
  a7_.description AS description_55,
  a7_.price AS price_56,
  a7_.date_begin AS date_begin_57,
  a7_.date_end AS date_end_58,
  a7_.updated_at AS updated_at_59,
  a7_.is_activity_calculated_per_day AS is_activity_calculated_per_day_60,
  a7_.is_activity_calculated_per_booking AS is_activity_calculated_per_booking_61,
  i8_.id AS id_62,
  i8_.label AS label_63,
  i8_.description AS description_64,
  i8_.price AS price_65,
  i8_.updated_at AS updated_at_66,
  b9_.id AS id_67,
  b9_.reference AS reference_68,
  b9_.date_begin AS date_begin_69,
  b9_.date_end AS date_end_70,
  b9_.total_price AS total_price_71,
  b9_.total_days AS total_days_72,
  b9_.created_at AS created_at_73,
  b9_.status AS status_74,
  b9_.estimate_id AS estimate_id_75,
  b9_.updated_at AS updated_at_76,
  a10_.id AS id_77,
  a10_.name AS name_78,
  a10_.type AS type_79,
  a10_.description AS description_80,
  a10_.picture AS picture_81,
  a10_.reference AS reference_82,
  a10_.phone AS phone_83,
  a10_.email AS email_84,
  a10_.is_visible AS is_visible_85,
  a10_.is_open AS is_open_86,
  a10_.updated_at AS updated_at_87,
  c11_.id AS id_88,
  c11_.name AS name_89,
  c11_.siren AS siren_90,
  c11_.siret AS siret_91,
  c11_.creation_date AS creation_date_92,
  c11_.tvaintra AS tvaintra_93,
  v12_.id AS id_94,
  v12_.country AS country_95,
  v12_.country_code AS country_code_96,
  v12_.standard_rate AS standard_rate_97,
  v12_.parking_rate AS parking_rate_98,
  v12_.reduced_rate1 AS reduced_rate1_99,
  v12_.reduced_rate2 AS reduced_rate2_100,
  v12_.super_reduced_rate AS super_reduced_rate_101,
  v12_.zero_rate AS zero_rate_102,
  c13_.id AS id_103,
  c13_.first_name AS first_name_104,
  c13_.last_name AS last_name_105,
  c13_.is_activated AS is_activated_106,
  c13_.email AS email_107,
  c13_.phone AS phone_108,
  c13_.birth_date AS birth_date_109,
  c13_.language AS language_110,
  c13_.created_at AS created_at_111,
  c13_.updated_at AS updated_at_112,
  c13_.password AS password_113,
  c13_.rattache_company AS rattache_company_114,
  a1_.company_id AS company_id_115,
  a1_.vat_id AS vat_id_116,
  a1_.currency_id AS currency_id_117,
  b5_.product_id AS product_id_118,
  b5_.activity_id AS activity_id_119,
  b5_.insurance_id AS insurance_id_120,
  b5_.booking_id AS booking_id_121,
  b5_.estimate_id AS estimate_id_122,
  b5_.promotion_code_id AS promotion_code_id_123,
  p6_.model_id AS model_id_124,
  p6_.product_category_id AS product_category_id_125,
  p6_.vehicle_document_id AS vehicle_document_id_126,
  p6_.agency_id AS agency_id_127,
  b9_.user_id AS user_id_128,
  b9_.booking_agency_source_id AS booking_agency_source_id_129,
  b9_.booking_agency_target_id AS booking_agency_target_id_130,
  b9_.customer_id AS customer_id_131,
  a10_.company_id AS company_id_132,
  a10_.vat_id AS vat_id_133,
  a10_.currency_id AS currency_id_134
FROM
  promotion_code p0_
  LEFT JOIN promotion_code_agency p14_ ON p0_.id = p14_.promotion_code_id
  LEFT JOIN agency a1_ ON a1_.id = p14_.agency_id
  LEFT JOIN company c2_ ON a1_.company_id = c2_.id
  LEFT JOIN vat v3_ ON a1_.vat_id = v3_.id
  LEFT JOIN promotion_code_product_category p15_ ON p0_.id = p15_.promotion_code_id
  LEFT JOIN product_category p4_ ON p4_.id = p15_.product_category_id
  LEFT JOIN booking_item b5_ ON p0_.id = b5_.promotion_code_id
  LEFT JOIN product p6_ ON b5_.product_id = p6_.id
  LEFT JOIN activity a7_ ON b5_.activity_id = a7_.id
  LEFT JOIN insurance i8_ ON b5_.insurance_id = i8_.id
  LEFT JOIN booking b9_ ON b5_.booking_id = b9_.id
  LEFT JOIN agency a10_ ON b9_.booking_agency_source_id = a10_.id
  LEFT JOIN company c11_ ON a10_.company_id = c11_.id
  LEFT JOIN vat v12_ ON a10_.vat_id = v12_.id
  LEFT JOIN customer c13_ ON b9_.customer_id = c13_.id
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.value AS value_2, p0_.amount AS amount_3, p0_.type AS type_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.date_begin AS date_begin_7, p0_.date_end AS date_end_8, p0_.percentage AS percentage_9, p0_.description AS description_10, p0_.minimal_booking_days AS minimal_booking_days_11, p0_.date_purchase_start AS date_purchase_start_12, p0_.date_purchase_end AS date_purchase_end_13, a1_.id AS id_14, a1_.name AS name_15, a1_.type AS type_16, a1_.description AS description_17, a1_.picture AS picture_18, a1_.reference AS reference_19, a1_.phone AS phone_20, a1_.email AS email_21, a1_.is_visible AS is_visible_22, a1_.is_open AS is_open_23, a1_.updated_at AS updated_at_24, c2_.id AS id_25, c2_.name AS name_26, c2_.siren AS siren_27, c2_.siret AS siret_28, c2_.creation_date AS creation_date_29, c2_.tvaintra AS tvaintra_30, v3_.id AS id_31, v3_.country AS country_32, v3_.country_code AS country_code_33, v3_.standard_rate AS standard_rate_34, v3_.parking_rate AS parking_rate_35, v3_.reduced_rate1 AS reduced_rate1_36, v3_.reduced_rate2 AS reduced_rate2_37, v3_.super_reduced_rate AS super_reduced_rate_38, v3_.zero_rate AS zero_rate_39, p4_.id AS id_40, p4_.label AS label_41, p4_.type AS type_42, p4_.reference AS reference_43, p4_.updated_at AS updated_at_44, b5_.id AS id_45, b5_.price AS price_46, b5_.quantity AS quantity_47, b5_.vat_amount AS vat_amount_48, p6_.id AS id_49, p6_.type AS type_50, p6_.label AS label_51, p6_.updated_at AS updated_at_52, a7_.id AS id_53, a7_.label AS label_54, a7_.description AS description_55, a7_.price AS price_56, a7_.date_begin AS date_begin_57, a7_.date_end AS date_end_58, a7_.updated_at AS updated_at_59, a7_.is_activity_calculated_per_day AS is_activity_calculated_per_day_60, a7_.is_activity_calculated_per_booking AS is_activity_calculated_per_booking_61, i8_.id AS id_62, i8_.label AS label_63, i8_.description AS description_64, i8_.price AS price_65, i8_.updated_at AS updated_at_66, b9_.id AS id_67, b9_.reference AS reference_68, b9_.date_begin AS date_begin_69, b9_.date_end AS date_end_70, b9_.total_price AS total_price_71, b9_.total_days AS total_days_72, b9_.created_at AS created_at_73, b9_.status AS status_74, b9_.estimate_id AS estimate_id_75, b9_.updated_at AS updated_at_76, a10_.id AS id_77, a10_.name AS name_78, a10_.type AS type_79, a10_.description AS description_80, a10_.picture AS picture_81, a10_.reference AS reference_82, a10_.phone AS phone_83, a10_.email AS email_84, a10_.is_visible AS is_visible_85, a10_.is_open AS is_open_86, a10_.updated_at AS updated_at_87, c11_.id AS id_88, c11_.name AS name_89, c11_.siren AS siren_90, c11_.siret AS siret_91, c11_.creation_date AS creation_date_92, c11_.tvaintra AS tvaintra_93, v12_.id AS id_94, v12_.country AS country_95, v12_.country_code AS country_code_96, v12_.standard_rate AS standard_rate_97, v12_.parking_rate AS parking_rate_98, v12_.reduced_rate1 AS reduced_rate1_99, v12_.reduced_rate2 AS reduced_rate2_100, v12_.super_reduced_rate AS super_reduced_rate_101, v12_.zero_rate AS zero_rate_102, c13_.id AS id_103, c13_.first_name AS first_name_104, c13_.last_name AS last_name_105, c13_.is_activated AS is_activated_106, c13_.email AS email_107, c13_.phone AS phone_108, c13_.birth_date AS birth_date_109, c13_.language AS language_110, c13_.created_at AS created_at_111, c13_.updated_at AS updated_at_112, c13_.password AS password_113, c13_.rattache_company AS rattache_company_114, a1_.company_id AS company_id_115, a1_.vat_id AS vat_id_116, a1_.currency_id AS currency_id_117, b5_.product_id AS product_id_118, b5_.activity_id AS activity_id_119, b5_.insurance_id AS insurance_id_120, b5_.booking_id AS booking_id_121, b5_.estimate_id AS estimate_id_122, b5_.promotion_code_id AS promotion_code_id_123, p6_.model_id AS model_id_124, p6_.product_category_id AS product_category_id_125, p6_.vehicle_document_id AS vehicle_document_id_126, p6_.agency_id AS agency_id_127, b9_.user_id AS user_id_128, b9_.booking_agency_source_id AS booking_agency_source_id_129, b9_.booking_agency_target_id AS booking_agency_target_id_130, b9_.customer_id AS customer_id_131, a10_.company_id AS company_id_132, a10_.vat_id AS vat_id_133, a10_.currency_id AS currency_id_134 FROM promotion_code p0_ LEFT JOIN promotion_code_agency p14_ ON p0_.id = p14_.promotion_code_id LEFT JOIN agency a1_ ON a1_.id = p14_.agency_id LEFT JOIN company c2_ ON a1_.company_id = c2_.id LEFT JOIN vat v3_ ON a1_.vat_id = v3_.id LEFT JOIN promotion_code_product_category p15_ ON p0_.id = p15_.promotion_code_id LEFT JOIN product_category p4_ ON p4_.id = p15_.product_category_id LEFT JOIN booking_item b5_ ON p0_.id = b5_.promotion_code_id LEFT JOIN product p6_ ON b5_.product_id = p6_.id LEFT JOIN activity a7_ ON b5_.activity_id = a7_.id LEFT JOIN insurance i8_ ON b5_.insurance_id = i8_.id LEFT JOIN booking b9_ ON b5_.booking_id = b9_.id LEFT JOIN agency a10_ ON b9_.booking_agency_source_id = a10_.id LEFT JOIN company c11_ ON a10_.company_id = c11_.id LEFT JOIN vat v12_ ON a10_.vat_id = v12_.id LEFT JOIN customer c13_ ON b9_.customer_id = c13_.id WHERE p0_.id = 0;

#	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\PromotionCode	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\Company	No errors.
App\Entity\ProductCategory	The mappings App\Entity\ProductCategory#agencies and App\Entity\Agency#productCategories are inconsistent with each other.
App\Entity\BookingItem	No errors.
App\Entity\Product	The mappings App\Entity\Product#bookings and App\Entity\Booking#products are inconsistent with each other.
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\Customer	No errors.
App\Entity\Vat	No errors.
App\Entity\Activity	No errors.
App\Entity\Insurance	No errors.
App\Entity\Currency	No errors.
App\Entity\Estimate	The mappings App\Entity\Estimate#bookingAgencyTarget and App\Entity\Agency#estimates are inconsistent with each other.
App\Entity\BrandModel	No errors.
App\Entity\VehicleDocument	No errors.
App\Entity\User	No errors.
App\Entity\Calendar	No errors.
App\Entity\PriceList	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\OptionStock	No errors.
App\Entity\Address	No errors.
App\Entity\CalendarClosedDays	No errors.
App\Entity\CalendarOpenDays	No errors.
App\Entity\CalendarBooking	No errors.
App\Entity\Images	No errors.
App\Entity\BookingItemOption	The mappings App\Entity\BookingItemOption#option and App\Entity\Option#bookingItemOptions are inconsistent with each other.
App\Entity\Driver	No errors.
App\Entity\ProductEvent	No errors.
App\Entity\Memo	No errors.
App\Entity\Invoice	No errors.
App\Entity\Caution	No errors.
App\Entity\GiftCard	No errors.
App\Entity\Refund	No errors.
App\Entity\Brand	No errors.
App\Entity\PaymentDetail	No errors.

Symfony Profiler

GET https://www.bo.blacksheep-van.com/api/promotion_codes/post/

Configuration Settings

Theme