Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.72 ms Query time

6 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.72 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.type AS type_2, a0_.description AS description_3, a0_.picture AS picture_4, a0_.reference AS reference_5, a0_.phone AS phone_6, a0_.email AS email_7, a0_.is_visible AS is_visible_8, a0_.is_open AS is_open_9, a0_.updated_at AS updated_at_10, a0_.company_id AS company_id_11, a0_.vat_id AS vat_id_12, a0_.currency_id AS currency_id_13 FROM agency a0_ WHERE a0_.id = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.type AS type_2,
  a0_.description AS description_3,
  a0_.picture AS picture_4,
  a0_.reference AS reference_5,
  a0_.phone AS phone_6,
  a0_.email AS email_7,
  a0_.is_visible AS is_visible_8,
  a0_.is_open AS is_open_9,
  a0_.updated_at AS updated_at_10,
  a0_.company_id AS company_id_11,
  a0_.vat_id AS vat_id_12,
  a0_.currency_id AS currency_id_13
FROM
  agency a0_
WHERE
  a0_.id = ?

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.type AS type_2, a0_.description AS description_3, a0_.picture AS picture_4, a0_.reference AS reference_5, a0_.phone AS phone_6, a0_.email AS email_7, a0_.is_visible AS is_visible_8, a0_.is_open AS is_open_9, a0_.updated_at AS updated_at_10, a0_.company_id AS company_id_11, a0_.vat_id AS vat_id_12, a0_.currency_id AS currency_id_13 FROM agency a0_ WHERE a0_.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\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\Vat	No errors.
App\Entity\Currency	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\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\ProductCategory	The mappings App\Entity\ProductCategory#agencies and App\Entity\Agency#productCategories are inconsistent with each other.
App\Entity\Product	The mappings App\Entity\Product#bookings and App\Entity\Booking#products are inconsistent with each other.
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\Estimate	The mappings App\Entity\Estimate#bookingAgencyTarget and App\Entity\Agency#estimates are inconsistent with each other.
App\Entity\PromotionCode	No errors.
App\Entity\Activity	No errors.
App\Entity\Customer	No errors.
App\Entity\Images	No errors.

Symfony Profiler

GET https://www.bo.blacksheep-van.com/api/agencies/new

Configuration Settings

Theme