Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

2.57 ms Query time

0 Invalid entities

13 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

0.76 ms
(29.46%)

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.code AS code_3, t0.name AS name_4, t0.price AS price_5, t0.custom AS custom_6, t0.quantity AS quantity_7, t0.counted_at AS counted_at_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.inventory_id AS inventory_id_12, t0.product_id AS product_id_13, t0.created_by_id AS created_by_id_14 FROM inventory_line t0 WHERE t0.inventory_id = ? AND t0.deleted_at IS NULL ORDER BY t0.counted_at ASC

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.code AS code_3,
  t0.name AS name_4,
  t0.price AS price_5,
  t0.custom AS custom_6,
  t0.quantity AS quantity_7,
  t0.counted_at AS counted_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.inventory_id AS inventory_id_12,
  t0.product_id AS product_id_13,
  t0.created_by_id AS created_by_id_14
FROM
  inventory_line t0
WHERE
  t0.inventory_id = ?
  AND t0.deleted_at IS NULL
ORDER BY
  t0.counted_at ASC

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.code AS code_3, t0.name AS name_4, t0.price AS price_5, t0.custom AS custom_6, t0.quantity AS quantity_7, t0.counted_at AS counted_at_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.inventory_id AS inventory_id_12, t0.product_id AS product_id_13, t0.created_by_id AS created_by_id_14 FROM inventory_line t0 WHERE t0.inventory_id = 4 AND t0.deleted_at IS NULL ORDER BY t0.counted_at ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Service\InventoryService->loadMergeContext (line 641)
5	App\Service\InventoryService->mergePreview (line 533)
6	App\Service\ApiDataService->getInventoryMergePreviewData (line 645)
7	ReflectionMethod->invokeArgs (line 173)
8	App\Plugin\CovetoBundle\Service\DataResolverService->invokeLocalMethod (line 173)
9	App\Plugin\CovetoBundle\Service\DataResolverService->getData (line 53)
10	App\Plugin\CovetoBundle\Controller\InventoryController->resolve (line 329)
11	App\Plugin\CovetoBundle\Controller\InventoryController->mergePreview (line 207)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.75 ms
(29.35%)

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.status AS status_2, i0_.closed_at AS closed_at_3, i0_.created_at AS created_at_4, i0_.updated_at AS updated_at_5, i0_.customer_coveto_id AS customer_coveto_id_6, i0_.created_by_id AS created_by_id_7, i0_.closed_by_id AS closed_by_id_8, i0_.merged_into_id AS merged_into_id_9 FROM inventory i0_ WHERE i0_.id = ? AND ((i0_.customer_coveto_id IS NULL AND i0_.created_by_id = ?) OR i0_.customer_coveto_id IN (?, ?))

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.status AS status_2,
  i0_.closed_at AS closed_at_3,
  i0_.created_at AS created_at_4,
  i0_.updated_at AS updated_at_5,
  i0_.customer_coveto_id AS customer_coveto_id_6,
  i0_.created_by_id AS created_by_id_7,
  i0_.closed_by_id AS closed_by_id_8,
  i0_.merged_into_id AS merged_into_id_9
FROM
  inventory i0_
WHERE
  i0_.id = ?
  AND (
    (
      i0_.customer_coveto_id IS NULL
      AND i0_.created_by_id = ?
    )
    OR i0_.customer_coveto_id IN (?, ?)
  )

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.status AS status_2, i0_.closed_at AS closed_at_3, i0_.created_at AS created_at_4, i0_.updated_at AS updated_at_5, i0_.customer_coveto_id AS customer_coveto_id_6, i0_.created_by_id AS created_by_id_7, i0_.closed_by_id AS closed_by_id_8, i0_.merged_into_id AS merged_into_id_9 FROM inventory i0_ WHERE i0_.id = 4 AND ((i0_.customer_coveto_id IS NULL AND i0_.created_by_id = 10) OR i0_.customer_coveto_id IN (2159, 2161));

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\Inventory\InventoryRepository->findOneForUser (line 65)
7	App\Service\InventoryService->findOpen (line 728)
8	App\Service\InventoryService->loadMergeContext (line 614)
9	App\Service\InventoryService->mergePreview (line 533)
10	App\Service\ApiDataService->getInventoryMergePreviewData (line 645)
11	ReflectionMethod->invokeArgs (line 173)
12	App\Plugin\CovetoBundle\Service\DataResolverService->invokeLocalMethod (line 173)
13	App\Plugin\CovetoBundle\Service\DataResolverService->getData (line 53)
14	App\Plugin\CovetoBundle\Controller\InventoryController->resolve (line 329)
15	App\Plugin\CovetoBundle\Controller\InventoryController->mergePreview (line 207)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.64 ms
(24.76%)

SELECT t0.id AS id_1, t0.external_code AS external_code_2, t0.name AS name_3, t0.delivery_code AS delivery_code_4, t0.email AS email_5, t0.phone AS phone_6, t0.state AS state_7, t0.postal_code AS postal_code_8, t0.address AS address_9, t0.adrline1 AS adrline1_10, t0.adrline2 AS adrline2_11, t0.adrline3 AS adrline3_12, t0.city AS city_13, t0.is_spe_ali AS is_spe_ali_14, t0.depot_id AS depot_id_15, t0.is_packaging_prohibited AS is_packaging_prohibited_16, t0.updated_at AS updated_at_17 FROM customer_coveto t0 INNER JOIN auth_user_customer_coveto ON t0.id = auth_user_customer_coveto.customer_coveto_id WHERE auth_user_customer_coveto.auth_user_id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.external_code AS external_code_2,
  t0.name AS name_3,
  t0.delivery_code AS delivery_code_4,
  t0.email AS email_5,
  t0.phone AS phone_6,
  t0.state AS state_7,
  t0.postal_code AS postal_code_8,
  t0.address AS address_9,
  t0.adrline1 AS adrline1_10,
  t0.adrline2 AS adrline2_11,
  t0.adrline3 AS adrline3_12,
  t0.city AS city_13,
  t0.is_spe_ali AS is_spe_ali_14,
  t0.depot_id AS depot_id_15,
  t0.is_packaging_prohibited AS is_packaging_prohibited_16,
  t0.updated_at AS updated_at_17
FROM
  customer_coveto t0
  INNER JOIN auth_user_customer_coveto ON t0.id = auth_user_customer_coveto.customer_coveto_id
WHERE
  auth_user_customer_coveto.auth_user_id = ?

SELECT t0.id AS id_1, t0.external_code AS external_code_2, t0.name AS name_3, t0.delivery_code AS delivery_code_4, t0.email AS email_5, t0.phone AS phone_6, t0.state AS state_7, t0.postal_code AS postal_code_8, t0.address AS address_9, t0.adrline1 AS adrline1_10, t0.adrline2 AS adrline2_11, t0.adrline3 AS adrline3_12, t0.city AS city_13, t0.is_spe_ali AS is_spe_ali_14, t0.depot_id AS depot_id_15, t0.is_packaging_prohibited AS is_packaging_prohibited_16, t0.updated_at AS updated_at_17 FROM customer_coveto t0 INNER JOIN auth_user_customer_coveto ON t0.id = auth_user_customer_coveto.customer_coveto_id WHERE auth_user_customer_coveto.auth_user_id = 10;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 159)
7	App\Repository\Inventory\InventoryRepository->restrictToUser (line 73)
8	App\Repository\Inventory\InventoryRepository->findOneForUser (line 63)
9	App\Service\InventoryService->findOpen (line 728)
10	App\Service\InventoryService->loadMergeContext (line 614)
11	App\Service\InventoryService->mergePreview (line 533)
12	App\Service\ApiDataService->getInventoryMergePreviewData (line 645)
13	ReflectionMethod->invokeArgs (line 173)
14	App\Plugin\CovetoBundle\Service\DataResolverService->invokeLocalMethod (line 173)
15	App\Plugin\CovetoBundle\Service\DataResolverService->getData (line 53)
16	App\Plugin\CovetoBundle\Controller\InventoryController->resolve (line 329)
17	App\Plugin\CovetoBundle\Controller\InventoryController->mergePreview (line 207)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

0.42 ms
(16.43%)

SELECT t0.id AS id_1, t0.login AS login_2, t0.email AS email_3, t0.password AS password_4, t0.roles AS roles_5, t0.api_token AS api_token_6, t0.created_at AS created_at_7 FROM auth_user t0 WHERE t0.id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.api_token AS api_token_6,
  t0.created_at AS created_at_7
FROM
  auth_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login AS login_2, t0.email AS email_3, t0.password AS password_4, t0.roles AS roles_5, t0.api_token AS api_token_6, t0.created_at AS created_at_7 FROM auth_user t0 WHERE t0.id = 10;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
mediatheque	doctrine.dbal.mediatheque_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Inventory\InventoryLine	5
App\Entity\Product\Product	3
App\Entity\Customer\CustomerCoveto	2
App\Entity\Inventory\Inventory	2
App\Entity\Auth\AuthUser	1

Entities Mapping

Class	Mapping errors
App\Entity\Auth\AuthUser	No errors.
App\Entity\Customer\CustomerCoveto	No errors.
App\Entity\Order\OrderCart	No errors.
App\Entity\Inventory\Inventory	No errors.
App\Entity\Customer\Tour	No errors.
App\Entity\Inventory\InventoryLine	No errors.
App\Entity\Product\Product	No errors.

Symfony Profiler

GET https://preprod.covetonet.com/order/inventory/4/merge-preview?sources%5B0%5D=5

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping