Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5237.21 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.95 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM "user" t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM "user" t0 WHERE t0.id = 1;

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

5236.26 ms

SELECT p.id, p.ean13 AS ean, p.name AS product_name, s.company_name as supplier, 
                            (select supplier_stock from supplier_product_stock_timeline where product_id = p.id and supplier_id = s.id order by id desc limit 1) as qty,
                            (select supplier_price from supplier_product_price_timeline where product_id = p.id and supplier_id = s.id order by id desc limit 1) as price 
                        FROM 
                            product p
                        JOIN 
                            supplier_product sp ON sp.product_id = p.id
                        JOIN 
                            supplier s ON sp.supplier_id = s.id
                        JOIN (
                            SELECT DISTINCT ON (product_id)
                                product_id, supplier_price
                            FROM 
                                supplier_product_price_timeline
                            ORDER BY 
                                product_id, id DESC
                        ) AS spp ON spp.product_id = p.id
                        join (
                            select distinct on (product_id)
                                product_id, supplier_stock
                            from 
                                supplier_product_stock_timeline
                            order by product_id, id desc
                        ) as sps on sps.product_id = p.id
                        WHERE p.ean13= ?

Parameters:

[
  "8808563545035"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.id,
  p.ean13 AS ean,
  p.name AS product_name,
  s.company_name as supplier,
  (
    select
      supplier_stock
    from
      supplier_product_stock_timeline
    where
      product_id = p.id
      and supplier_id = s.id
    order by
      id desc
    limit
      1
  ) as qty,
  (
    select
      supplier_price
    from
      supplier_product_price_timeline
    where
      product_id = p.id
      and supplier_id = s.id
    order by
      id desc
    limit
      1
  ) as price
FROM
  product p
  JOIN supplier_product sp ON sp.product_id = p.id
  JOIN supplier s ON sp.supplier_id = s.id
  JOIN (
    SELECT
      DISTINCT ON (product_id) product_id,
      supplier_price
    FROM
      supplier_product_price_timeline
    ORDER BY
      product_id,
      id DESC
  ) AS spp ON spp.product_id = p.id
  join (
    select
      distinct on (product_id) product_id,
      supplier_stock
    from
      supplier_product_stock_timeline
    order by
      product_id,
      id desc
  ) as sps on sps.product_id = p.id
WHERE
  p.ean13 = ?

SELECT p.id, p.ean13 AS ean, p.name AS product_name, s.company_name as supplier, 
                            (select supplier_stock from supplier_product_stock_timeline where product_id = p.id and supplier_id = s.id order by id desc limit 1) as qty,
                            (select supplier_price from supplier_product_price_timeline where product_id = p.id and supplier_id = s.id order by id desc limit 1) as price 
                        FROM 
                            product p
                        JOIN 
                            supplier_product sp ON sp.product_id = p.id
                        JOIN 
                            supplier s ON sp.supplier_id = s.id
                        JOIN (
                            SELECT DISTINCT ON (product_id)
                                product_id, supplier_price
                            FROM 
                                supplier_product_price_timeline
                            ORDER BY 
                                product_id, id DESC
                        ) AS spp ON spp.product_id = p.id
                        join (
                            select distinct on (product_id)
                                product_id, supplier_stock
                            from 
                                supplier_product_stock_timeline
                            order by product_id, id desc
                        ) as sps on sps.product_id = p.id
                        WHERE p.ean13= '8808563545035';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 20)
3	App\Controller\ProductsController->index (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.

Symfony Profiler

GET https://kaisr-interface.dss-solutions.fr/products?ean=8808563545035

Configuration Settings

Theme

Page Width