Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.62 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.57 ms
(35.37%)

SELECT COUNT(DISTINCT g0_.id) AS sclr_0 FROM gift_card g0_ INNER JOIN customer c1_ ON g0_.customer_id = c1_.id LEFT JOIN estimate_gift_card e3_ ON g0_.id = e3_.gift_card_id LEFT JOIN estimate e2_ ON e2_.id = e3_.estimate_id LEFT JOIN booking_gift_card b5_ ON g0_.id = b5_.gift_card_id LEFT JOIN booking b4_ ON b4_.id = b5_.booking_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT g0_.id) AS sclr_0
FROM
  gift_card g0_
  INNER JOIN customer c1_ ON g0_.customer_id = c1_.id
  LEFT JOIN estimate_gift_card e3_ ON g0_.id = e3_.gift_card_id
  LEFT JOIN estimate e2_ ON e2_.id = e3_.estimate_id
  LEFT JOIN booking_gift_card b5_ ON g0_.id = b5_.gift_card_id
  LEFT JOIN booking b4_ ON b4_.id = b5_.booking_id

SELECT COUNT(DISTINCT g0_.id) AS sclr_0 FROM gift_card g0_ INNER JOIN customer c1_ ON g0_.customer_id = c1_.id LEFT JOIN estimate_gift_card e3_ ON g0_.id = e3_.gift_card_id LEFT JOIN estimate e2_ ON e2_.id = e3_.estimate_id LEFT JOIN booking_gift_card b5_ ON g0_.id = b5_.gift_card_id LEFT JOIN booking b4_ ON b4_.id = b5_.booking_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.55 ms
(33.95%)

SELECT g0_.id AS id_0, g0_.amount AS amount_1, g0_.created_at AS created_at_2, g0_.status AS status_3, g0_.file AS file_4, g0_.code AS code_5, g0_.download AS download_6, g0_.recipient AS recipient_7, g0_.message AS message_8, g0_.refund AS refund_9, g0_.date_of_use AS date_of_use_10, g0_.recipient_infos AS recipient_infos_11, g0_.expiration_date AS expiration_date_12, g0_.updated_at AS updated_at_13, g0_.label AS label_14, c1_.id AS id_15, c1_.first_name AS first_name_16, c1_.last_name AS last_name_17, c1_.is_activated AS is_activated_18, c1_.email AS email_19, c1_.phone AS phone_20, c1_.birth_date AS birth_date_21, c1_.language AS language_22, c1_.created_at AS created_at_23, c1_.updated_at AS updated_at_24, c1_.password AS password_25, c1_.rattache_company AS rattache_company_26, e2_.id AS id_27, e2_.created_at AS created_at_28, e2_.updated_at AS updated_at_29, e2_.reference AS reference_30, e2_.status AS status_31, e2_.total_price AS total_price_32, e2_.date_begin AS date_begin_33, e2_.date_end AS date_end_34, b3_.id AS id_35, b3_.reference AS reference_36, b3_.date_begin AS date_begin_37, b3_.date_end AS date_end_38, b3_.total_price AS total_price_39, b3_.total_days AS total_days_40, b3_.created_at AS created_at_41, b3_.status AS status_42, b3_.estimate_id AS estimate_id_43, b3_.updated_at AS updated_at_44, g0_.customer_id AS customer_id_45, e2_.user_id AS user_id_46, e2_.booking_agency_source_id AS booking_agency_source_id_47, e2_.booking_agency_target_id AS booking_agency_target_id_48, e2_.customer_id AS customer_id_49, b3_.user_id AS user_id_50, b3_.booking_agency_source_id AS booking_agency_source_id_51, b3_.booking_agency_target_id AS booking_agency_target_id_52, b3_.customer_id AS customer_id_53 FROM gift_card g0_ INNER JOIN customer c1_ ON g0_.customer_id = c1_.id LEFT JOIN estimate_gift_card e4_ ON g0_.id = e4_.gift_card_id LEFT JOIN estimate e2_ ON e2_.id = e4_.estimate_id LEFT JOIN booking_gift_card b5_ ON g0_.id = b5_.gift_card_id LEFT JOIN booking b3_ ON b3_.id = b5_.booking_id WHERE g0_.id IN (?, ?, ?) ORDER BY g0_.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.amount AS amount_1,
  g0_.created_at AS created_at_2,
  g0_.status AS status_3,
  g0_.file AS file_4,
  g0_.code AS code_5,
  g0_.download AS download_6,
  g0_.recipient AS recipient_7,
  g0_.message AS message_8,
  g0_.refund AS refund_9,
  g0_.date_of_use AS date_of_use_10,
  g0_.recipient_infos AS recipient_infos_11,
  g0_.expiration_date AS expiration_date_12,
  g0_.updated_at AS updated_at_13,
  g0_.label AS label_14,
  c1_.id AS id_15,
  c1_.first_name AS first_name_16,
  c1_.last_name AS last_name_17,
  c1_.is_activated AS is_activated_18,
  c1_.email AS email_19,
  c1_.phone AS phone_20,
  c1_.birth_date AS birth_date_21,
  c1_.language AS language_22,
  c1_.created_at AS created_at_23,
  c1_.updated_at AS updated_at_24,
  c1_.password AS password_25,
  c1_.rattache_company AS rattache_company_26,
  e2_.id AS id_27,
  e2_.created_at AS created_at_28,
  e2_.updated_at AS updated_at_29,
  e2_.reference AS reference_30,
  e2_.status AS status_31,
  e2_.total_price AS total_price_32,
  e2_.date_begin AS date_begin_33,
  e2_.date_end AS date_end_34,
  b3_.id AS id_35,
  b3_.reference AS reference_36,
  b3_.date_begin AS date_begin_37,
  b3_.date_end AS date_end_38,
  b3_.total_price AS total_price_39,
  b3_.total_days AS total_days_40,
  b3_.created_at AS created_at_41,
  b3_.status AS status_42,
  b3_.estimate_id AS estimate_id_43,
  b3_.updated_at AS updated_at_44,
  g0_.customer_id AS customer_id_45,
  e2_.user_id AS user_id_46,
  e2_.booking_agency_source_id AS booking_agency_source_id_47,
  e2_.booking_agency_target_id AS booking_agency_target_id_48,
  e2_.customer_id AS customer_id_49,
  b3_.user_id AS user_id_50,
  b3_.booking_agency_source_id AS booking_agency_source_id_51,
  b3_.booking_agency_target_id AS booking_agency_target_id_52,
  b3_.customer_id AS customer_id_53
FROM
  gift_card g0_
  INNER JOIN customer c1_ ON g0_.customer_id = c1_.id
  LEFT JOIN estimate_gift_card e4_ ON g0_.id = e4_.gift_card_id
  LEFT JOIN estimate e2_ ON e2_.id = e4_.estimate_id
  LEFT JOIN booking_gift_card b5_ ON g0_.id = b5_.gift_card_id
  LEFT JOIN booking b3_ ON b3_.id = b5_.booking_id
WHERE
  g0_.id IN (?, ?, ?)
ORDER BY
  g0_.id ASC

SELECT g0_.id AS id_0, g0_.amount AS amount_1, g0_.created_at AS created_at_2, g0_.status AS status_3, g0_.file AS file_4, g0_.code AS code_5, g0_.download AS download_6, g0_.recipient AS recipient_7, g0_.message AS message_8, g0_.refund AS refund_9, g0_.date_of_use AS date_of_use_10, g0_.recipient_infos AS recipient_infos_11, g0_.expiration_date AS expiration_date_12, g0_.updated_at AS updated_at_13, g0_.label AS label_14, c1_.id AS id_15, c1_.first_name AS first_name_16, c1_.last_name AS last_name_17, c1_.is_activated AS is_activated_18, c1_.email AS email_19, c1_.phone AS phone_20, c1_.birth_date AS birth_date_21, c1_.language AS language_22, c1_.created_at AS created_at_23, c1_.updated_at AS updated_at_24, c1_.password AS password_25, c1_.rattache_company AS rattache_company_26, e2_.id AS id_27, e2_.created_at AS created_at_28, e2_.updated_at AS updated_at_29, e2_.reference AS reference_30, e2_.status AS status_31, e2_.total_price AS total_price_32, e2_.date_begin AS date_begin_33, e2_.date_end AS date_end_34, b3_.id AS id_35, b3_.reference AS reference_36, b3_.date_begin AS date_begin_37, b3_.date_end AS date_end_38, b3_.total_price AS total_price_39, b3_.total_days AS total_days_40, b3_.created_at AS created_at_41, b3_.status AS status_42, b3_.estimate_id AS estimate_id_43, b3_.updated_at AS updated_at_44, g0_.customer_id AS customer_id_45, e2_.user_id AS user_id_46, e2_.booking_agency_source_id AS booking_agency_source_id_47, e2_.booking_agency_target_id AS booking_agency_target_id_48, e2_.customer_id AS customer_id_49, b3_.user_id AS user_id_50, b3_.booking_agency_source_id AS booking_agency_source_id_51, b3_.booking_agency_target_id AS booking_agency_target_id_52, b3_.customer_id AS customer_id_53 FROM gift_card g0_ INNER JOIN customer c1_ ON g0_.customer_id = c1_.id LEFT JOIN estimate_gift_card e4_ ON g0_.id = e4_.gift_card_id LEFT JOIN estimate e2_ ON e2_.id = e4_.estimate_id LEFT JOIN booking_gift_card b5_ ON g0_.id = b5_.gift_card_id LEFT JOIN booking b3_ ON b3_.id = b5_.booking_id WHERE g0_.id IN (16, 17, 18) ORDER BY g0_.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)

0.50 ms
(30.68%)

SELECT DISTINCT g0_.id AS id_0, g0_.id AS id_1 FROM gift_card g0_ INNER JOIN customer c1_ ON g0_.customer_id = c1_.id LEFT JOIN estimate_gift_card e3_ ON g0_.id = e3_.gift_card_id LEFT JOIN estimate e2_ ON e2_.id = e3_.estimate_id LEFT JOIN booking_gift_card b5_ ON g0_.id = b5_.gift_card_id LEFT JOIN booking b4_ ON b4_.id = b5_.booking_id ORDER BY g0_.id ASC LIMIT 30

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT g0_.id AS id_0,
  g0_.id AS id_1
FROM
  gift_card g0_
  INNER JOIN customer c1_ ON g0_.customer_id = c1_.id
  LEFT JOIN estimate_gift_card e3_ ON g0_.id = e3_.gift_card_id
  LEFT JOIN estimate e2_ ON e2_.id = e3_.estimate_id
  LEFT JOIN booking_gift_card b5_ ON g0_.id = b5_.gift_card_id
  LEFT JOIN booking b4_ ON b4_.id = b5_.booking_id
ORDER BY
  g0_.id ASC
LIMIT
  30

SELECT DISTINCT g0_.id AS id_0, g0_.id AS id_1 FROM gift_card g0_ INNER JOIN customer c1_ ON g0_.customer_id = c1_.id LEFT JOIN estimate_gift_card e3_ ON g0_.id = e3_.gift_card_id LEFT JOIN estimate e2_ ON e2_.id = e3_.estimate_id LEFT JOIN booking_gift_card b5_ ON g0_.id = b5_.gift_card_id LEFT JOIN booking b4_ ON b4_.id = b5_.booking_id ORDER BY g0_.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)

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\GiftCard	No errors.
App\Entity\Customer	No errors.
App\Entity\Estimate	The mappings App\Entity\Estimate#bookingAgencyTarget and App\Entity\Agency#estimates 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\User	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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping