Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

11 Database Queries

7 Different statements

76.38 ms Query time

1 Invalid entities

20135 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

70.30 ms
(92.03%)

SELECT p0_.id AS id_0, p0_.cod AS cod_1, p0_.reference AS reference_2, p0_.name AS name_3, p0_.slug AS slug_4, p0_.stock AS stock_5, p0_.pvp AS pvp_6, p0_.discount AS discount_7, p0_.net_price AS net_price_8, p0_.extra AS extra_9, p0_.images AS images_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.views AS views_13, p0_.brand_id AS brand_id_14 FROM product p0_ WHERE p0_.images IS NOT NULL AND p0_.images <> '[]'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.cod AS cod_1,
  p0_.reference AS reference_2,
  p0_.name AS name_3,
  p0_.slug AS slug_4,
  p0_.stock AS stock_5,
  p0_.pvp AS pvp_6,
  p0_.discount AS discount_7,
  p0_.net_price AS net_price_8,
  p0_.extra AS extra_9,
  p0_.images AS images_10,
  p0_.created_at AS created_at_11,
  p0_.updated_at AS updated_at_12,
  p0_.views AS views_13,
  p0_.brand_id AS brand_id_14
FROM
  product p0_
WHERE
  p0_.images IS NOT NULL
  AND p0_.images <> '[]'

SELECT p0_.id AS id_0, p0_.cod AS cod_1, p0_.reference AS reference_2, p0_.name AS name_3, p0_.slug AS slug_4, p0_.stock AS stock_5, p0_.pvp AS pvp_6, p0_.discount AS discount_7, p0_.net_price AS net_price_8, p0_.extra AS extra_9, p0_.images AS images_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.views AS views_13, p0_.brand_id AS brand_id_14 FROM product p0_ WHERE p0_.images IS NOT NULL AND p0_.images <> '[]';

#	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->getResult (line 688)
6	App\Repository\ProductRepository->findRandom (line 41)
7	App\Controller\ShopController->show (line 80)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 208)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

3.69 ms
(4.83%)

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.slug AS slug_5, t0.stock AS stock_6, t0.pvp AS pvp_7, t0.discount AS discount_8, t0.net_price AS net_price_9, t0.extra AS extra_10, t0.images AS images_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.views AS views_14, t0.brand_id AS brand_id_15 FROM product t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "pld-6254-s-x-j5g-m9-55-polaroid-mod-pld-6254-s-x"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.stock AS stock_6,
  t0.pvp AS pvp_7,
  t0.discount AS discount_8,
  t0.net_price AS net_price_9,
  t0.extra AS extra_10,
  t0.images AS images_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.views AS views_14,
  t0.brand_id AS brand_id_15
FROM
  product t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.slug AS slug_5, t0.stock AS stock_6, t0.pvp AS pvp_7, t0.discount AS discount_8, t0.net_price AS net_price_9, t0.extra AS extra_10, t0.images AS images_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.views AS views_14, t0.brand_id AS brand_id_15 FROM product t0 WHERE t0.slug = 'pld-6254-s-x-j5g-m9-55-polaroid-mod-pld-6254-s-x' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\ShopController->show (line 63)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 208)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.12 ms
(1.46%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.parent_id AS parent_id_5 FROM category t0 WHERE t0.parent_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5
FROM
  category t0
WHERE
  t0.parent_id IS NULL

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.parent_id AS parent_id_5 FROM category t0 WHERE t0.parent_id IS NULL;

#	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\Controller\ShopController->show (line 78)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 208)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.71 ms
(0.92%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 434)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\ShopController->show (line 74)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.27 ms
(0.36%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM brand t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  brand t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM brand t0;

#	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	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\ShopController->show (line 79)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 208)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.22 ms
(0.28%)

UPDATE product SET views = ?, updated_at = ? WHERE id = ?

Parameters:

[
  1
  "2026-08-08 02:05:52"
  7648
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  product
SET
  views = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE product SET views = 1, updated_at = '2026-08-08 02:05:52' WHERE id = 7648;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1141)
4	Doctrine\ORM\UnitOfWork->commit (line 409)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\ShopController->show (line 74)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 208)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.09 ms
(0.12%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 383)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\ShopController->show (line 74)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 208)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	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\Product	19598
App\Entity\Brand	530
App\Entity\Category	7

Entities Mapping

Class	Mapping errors
App\Entity\Product	The association App\Entity\Product#brand refers to the inverse side field App\Entity\Brand#products which does not exist.
App\Entity\Brand	No errors.
App\Entity\Category	No errors.

Symfony Profiler

GET https://www.mipeluco.devlaboratory.es/product/pld-6254-s-x-j5g-m9-55-polaroid-mod-pld-6254-s-x

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping