Symfony Profiler

Query Metrics

59 Database Queries

7 Different statements

27.16 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.48 ms
(42.28%)

SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = ?

Parameters:

[
  266
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_name AS product_name_2,
  t0.product_reference AS product_reference_3,
  t0.pu AS pu_4,
  t0.quantity AS quantity_5,
  t0.sub_total AS sub_total_6,
  t0.checked_for_delivery AS checked_for_delivery_7,
  t0.checked_delivered AS checked_delivered_8,
  t0.is_packaging AS is_packaging_9,
  t0.connection_uid AS connection_uid_10,
  t0.parent_connection_uid AS parent_connection_uid_11,
  t0.discount AS discount_12,
  t0.discount_price AS discount_price_13,
  t0.created AS created_14,
  t0.updated AS updated_15,
  t0.orders_id AS orders_id_16
FROM
  order_line t0
WHERE
  t0.orders_id = ?

SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_reference AS product_reference_3, t0.pu AS pu_4, t0.quantity AS quantity_5, t0.sub_total AS sub_total_6, t0.checked_for_delivery AS checked_for_delivery_7, t0.checked_delivered AS checked_delivered_8, t0.is_packaging AS is_packaging_9, t0.connection_uid AS connection_uid_10, t0.parent_connection_uid AS parent_connection_uid_11, t0.discount AS discount_12, t0.discount_price AS discount_price_13, t0.created AS created_14, t0.updated AS updated_15, t0.orders_id AS orders_id_16 FROM order_line t0 WHERE t0.orders_id = 266;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3286)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 711)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 224)
8	App\Manager\OrderManager->getOrderLineWithChild (line 384)
9	App\Services\Api\Order\OrderServices->getOrderData (line 286)
10	App\Services\Api\Order\OrderServices->getOrders (line 42)
11	App\Controller\Api\Order\OrderApiController->getOrders (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

6.50 ms
(23.93%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = ?

Parameters:

[
  163355
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.status AS status_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.phone AS phone_9,
  t0.photo AS photo_10,
  t0.civility AS civility_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.sage_id AS sage_id_14,
  t0.created AS created_15,
  t0.updated AS updated_16,
  t0.local_area_id AS local_area_id_17,
  t0.commercial_customer_id AS commercial_customer_id_18
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.id = 163355;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\User->__get (line 202)
8	App\Entity\User->getEmail (line 371)
9	App\Services\Api\Order\OrderServices->getOrderData (line 286)
10	App\Services\Api\Order\OrderServices->getOrders (line 42)
11	App\Controller\Api\Order\OrderApiController->getOrders (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

5.21 ms
(19.18%)

SELECT t0.id AS id_1, t0.address AS address_2, t0.city AS city_3, t0.zip AS zip_4, t0.country AS country_5 FROM address t0 INNER JOIN user_address ON t0.id = user_address.address_id WHERE user_address.user_id = ?

Parameters:

[
  161684
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.address AS address_2,
  t0.city AS city_3,
  t0.zip AS zip_4,
  t0.country AS country_5
FROM
  address t0
  INNER JOIN user_address ON t0.id = user_address.address_id
WHERE
  user_address.user_id = ?

SELECT t0.id AS id_1, t0.address AS address_2, t0.city AS city_3, t0.zip AS zip_4, t0.country AS country_5 FROM address t0 INNER JOIN user_address ON t0.id = user_address.address_id WHERE user_address.user_id = 161684;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1092)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3290)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 711)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 176)
8	Symfony\Component\Serializer\Serializer->normalize (line 731)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 192)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 171)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 58)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
13	Symfony\Component\Serializer\Serializer->normalize (line 138)
14	Symfony\Component\Serializer\Serializer->serialize (line 47)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 373)
16	App\Services\Api\Order\OrderServices->getOrderData (line 286)
17	App\Services\Api\Order\OrderServices->getOrders (line 42)
18	App\Controller\Api\Order\OrderApiController->getOrders (line 181)
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)

1.76 ms
(6.47%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "415a7875fa0841846q@melis.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.status AS status_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.phone AS phone_9,
  t0.photo AS photo_10,
  t0.civility AS civility_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.sage_id AS sage_id_14,
  t0.created AS created_15,
  t0.updated AS updated_16,
  t0.local_area_id AS local_area_id_17,
  t0.commercial_customer_id AS commercial_customer_id_18
FROM
  "user" t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.status AS status_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.photo AS photo_10, t0.civility AS civility_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.sage_id AS sage_id_14, t0.created AS created_15, t0.updated AS updated_16, t0.local_area_id AS local_area_id_17, t0.commercial_customer_id AS commercial_customer_id_18 FROM "user" t0 WHERE t0.username = '415a7875fa0841846q@melis.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 32)
4	App\Utils\Utils->getCurrentUserByToken (line 50)
5	App\Utils\Utils->verifyCredential (line 34)
6	App\Controller\Api\Order\OrderApiController->getOrders (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

1.00 ms
(3.66%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.local AS local_3, t0.sage_id AS sage_id_4 FROM local_area t0 WHERE t0.id = ?

Parameters:

[
  40
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.local AS local_3,
  t0.sage_id AS sage_id_4
FROM
  local_area t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.local AS local_3, t0.sage_id AS sage_id_4 FROM local_area t0 WHERE t0.id = 40;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\LocalArea::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\LocalArea->__get (line 53)
8	App\Entity\LocalArea->getName (line 411)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 112)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 751)
11	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 192)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 171)
13	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 58)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
15	Symfony\Component\Serializer\Serializer->normalize (line 796)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 712)
17	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 192)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 171)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 58)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 159)
21	Symfony\Component\Serializer\Serializer->normalize (line 138)
22	Symfony\Component\Serializer\Serializer->serialize (line 47)
23	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 373)
24	App\Services\Api\Order\OrderServices->getOrderData (line 286)
25	App\Services\Api\Order\OrderServices->getOrders (line 42)
26	App\Controller\Api\Order\OrderApiController->getOrders (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.85 ms
(3.12%)

SELECT o0_.id AS id_0, o0_.deliver_to AS deliver_to_1, o0_.deliver_at AS deliver_at_2, o0_.amount AS amount_3, o0_.latitude AS latitude_4, o0_.longitude AS longitude_5, o0_.uid AS uid_6, o0_.hub AS hub_7, o0_.sale_type AS sale_type_8, o0_.note AS note_9, o0_.created AS created_10, o0_.updated AS updated_11, o0_.delivery_man_id AS delivery_man_id_12, o0_.commercial_id AS commercial_id_13, o0_.client_id AS client_id_14, o0_.distributor_id AS distributor_id_15, o0_.status_id AS status_id_16, o0_.local_area_id AS local_area_id_17, o0_.storage_id AS storage_id_18, o0_.driver_id AS driver_id_19, o0_.vehicle_id AS vehicle_id_20 FROM "order" o0_ WHERE o0_.status_id = ? ORDER BY o0_.status_id ASC LIMIT 300

Parameters:

[
  12
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.deliver_to AS deliver_to_1,
  o0_.deliver_at AS deliver_at_2,
  o0_.amount AS amount_3,
  o0_.latitude AS latitude_4,
  o0_.longitude AS longitude_5,
  o0_.uid AS uid_6,
  o0_.hub AS hub_7,
  o0_.sale_type AS sale_type_8,
  o0_.note AS note_9,
  o0_.created AS created_10,
  o0_.updated AS updated_11,
  o0_.delivery_man_id AS delivery_man_id_12,
  o0_.commercial_id AS commercial_id_13,
  o0_.client_id AS client_id_14,
  o0_.distributor_id AS distributor_id_15,
  o0_.status_id AS status_id_16,
  o0_.local_area_id AS local_area_id_17,
  o0_.storage_id AS storage_id_18,
  o0_.driver_id AS driver_id_19,
  o0_.vehicle_id AS vehicle_id_20
FROM
  "order" o0_
WHERE
  o0_.status_id = ?
ORDER BY
  o0_.status_id ASC
LIMIT
  300

SELECT o0_.id AS id_0, o0_.deliver_to AS deliver_to_1, o0_.deliver_at AS deliver_at_2, o0_.amount AS amount_3, o0_.latitude AS latitude_4, o0_.longitude AS longitude_5, o0_.uid AS uid_6, o0_.hub AS hub_7, o0_.sale_type AS sale_type_8, o0_.note AS note_9, o0_.created AS created_10, o0_.updated AS updated_11, o0_.delivery_man_id AS delivery_man_id_12, o0_.commercial_id AS commercial_id_13, o0_.client_id AS client_id_14, o0_.distributor_id AS distributor_id_15, o0_.status_id AS status_id_16, o0_.local_area_id AS local_area_id_17, o0_.storage_id AS storage_id_18, o0_.driver_id AS driver_id_19, o0_.vehicle_id AS vehicle_id_20 FROM "order" o0_ WHERE o0_.status_id = 12 ORDER BY o0_.status_id ASC LIMIT 300;

#	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 116)
7	App\Repository\OrderRepository->searchBy (line 280)
8	App\Services\Api\Order\OrderServices->getOrders (line 42)
9	App\Controller\Api\Order\OrderApiController->getOrders (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.37 ms
(1.36%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created AS created_4, t0.updated AS updated_5 FROM "order_statut" t0 WHERE t0.id = ?

Parameters:

[
  "12"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.created AS created_4,
  t0.updated AS updated_5
FROM
  "order_statut" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created AS created_4, t0.updated AS updated_5 FROM "order_statut" t0 WHERE t0.id = '12';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 250)
6	App\Services\Api\Order\OrderServices->getOrders (line 42)
7	App\Controller\Api\Order\OrderApiController->getOrders (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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
App\Entity\Order	The field 'App\Entity\Order#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\User	The association App\Entity\User#equipmentAttributions refers to the owning side field App\Entity\EquipmentAttribution#users which does not exist.
App\Entity\Address	No errors.
App\Entity\OrderHistory	No errors.
App\Entity\EquipmentAttribution	The mappings App\Entity\EquipmentAttribution#user and App\Entity\User#equipmentAttributions are inconsistent with each other.
App\Entity\Equipment	No errors.
App\Entity\LocalArea	No errors.
App\Entity\Distributor	No errors.
App\Entity\Product	No errors.
App\Entity\Category	No errors.
App\Entity\ProductPrice	No errors.
App\Entity\Stock	No errors.
App\Entity\Storage	No errors.
App\Entity\ProductConnection	No errors.
App\Entity\OrderStatut	No errors.
App\Entity\OrderLine	No errors.
App\Entity\Vehicle	No errors.

Symfony Profiler

GET https://mellis-command.mypreprod.xyz/api/orders?limit=300&status=12

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping