Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.27 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.68 ms
(53.21%)

SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle_document v0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  vehicle_document v0_

SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle_document v0_;

#	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.60 ms
(46.79%)

SELECT v0_.id AS id_0, v0_.created_at AS created_at_1, v0_.updated_at AS updated_at_2, v0_.immatriculation AS immatriculation_3, v0_.immatriculation_date AS immatriculation_date_4, v0_.type AS type_5, v0_.image_front AS image_front_6, v0_.image_back AS image_back_7, v0_.serial_number AS serial_number_8, v0_.car_body AS car_body_9, v0_.energy AS energy_10, v0_.tank_capacity AS tank_capacity_11, v0_.color AS color_12, v0_.tax_horsepower AS tax_horsepower_13, v0_.purchase_date AS purchase_date_14, v0_.purchase_price AS purchase_price_15, v0_.co2 AS co2_16, v0_.date1st_circulation AS date1st_circulation_17, v0_.gears AS gears_18, v0_.passengers AS passengers_19, v0_.doors AS doors_20, v0_.weight AS weight_21, v0_.commercial_name AS commercial_name_22, v0_.brand_logo AS brand_logo_23, v0_.km AS km_24 FROM vehicle_document v0_ ORDER BY v0_.id ASC LIMIT 30

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.created_at AS created_at_1,
  v0_.updated_at AS updated_at_2,
  v0_.immatriculation AS immatriculation_3,
  v0_.immatriculation_date AS immatriculation_date_4,
  v0_.type AS type_5,
  v0_.image_front AS image_front_6,
  v0_.image_back AS image_back_7,
  v0_.serial_number AS serial_number_8,
  v0_.car_body AS car_body_9,
  v0_.energy AS energy_10,
  v0_.tank_capacity AS tank_capacity_11,
  v0_.color AS color_12,
  v0_.tax_horsepower AS tax_horsepower_13,
  v0_.purchase_date AS purchase_date_14,
  v0_.purchase_price AS purchase_price_15,
  v0_.co2 AS co2_16,
  v0_.date1st_circulation AS date1st_circulation_17,
  v0_.gears AS gears_18,
  v0_.passengers AS passengers_19,
  v0_.doors AS doors_20,
  v0_.weight AS weight_21,
  v0_.commercial_name AS commercial_name_22,
  v0_.brand_logo AS brand_logo_23,
  v0_.km AS km_24
FROM
  vehicle_document v0_
ORDER BY
  v0_.id ASC
LIMIT
  30

SELECT v0_.id AS id_0, v0_.created_at AS created_at_1, v0_.updated_at AS updated_at_2, v0_.immatriculation AS immatriculation_3, v0_.immatriculation_date AS immatriculation_date_4, v0_.type AS type_5, v0_.image_front AS image_front_6, v0_.image_back AS image_back_7, v0_.serial_number AS serial_number_8, v0_.car_body AS car_body_9, v0_.energy AS energy_10, v0_.tank_capacity AS tank_capacity_11, v0_.color AS color_12, v0_.tax_horsepower AS tax_horsepower_13, v0_.purchase_date AS purchase_date_14, v0_.purchase_price AS purchase_price_15, v0_.co2 AS co2_16, v0_.date1st_circulation AS date1st_circulation_17, v0_.gears AS gears_18, v0_.passengers AS passengers_19, v0_.doors AS doors_20, v0_.weight AS weight_21, v0_.commercial_name AS commercial_name_22, v0_.brand_logo AS brand_logo_23, v0_.km AS km_24 FROM vehicle_document v0_ ORDER BY v0_.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 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 177)
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\VehicleDocument	No errors.

Symfony Profiler

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

Configuration Settings

Theme