Symfony Profiler

Query Metrics

12 Database Queries

11 Different statements

10.17 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.89 ms
(28.41%)

select * from shopproductmoq where shopid = '8597665' and productid = '400098936' order by id desc limit 0,1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  shopproductmoq
where
  shopid = '8597665'
  and productid = '400098936'
order by
  id desc
limit
  0, 1

select * from shopproductmoq where shopid = '8597665' and productid = '400098936' order by id desc limit 0,1;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 466)
3	App\Controller\CartController->addservicetocart (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 8)

1.14 ms
(11.24%)

select * from shopproductvariants where shopid = '8597665' and productid = '400098936' and productvariantid = ''

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  shopproductvariants
where
  shopid = '8597665'
  and productid = '400098936'
  and productvariantid = ''

select * from shopproductvariants where shopid = '8597665' and productid = '400098936' and productvariantid = '';

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 561)
3	App\Controller\CartController->addservicetocart (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 8)

1.07 ms
(10.50%)

SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = ? AND c0_.establishmentid = ? AND c0_.productid = ?

Parameters:

[
  "22270733"
  "8597665"
  "400098936"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.userid AS userid_1,
  c0_.cartid AS cartid_2,
  c0_.establishmentid AS establishmentid_3,
  c0_.productid AS productid_4,
  c0_.productvariantid AS productvariantid_5,
  c0_.productname AS productname_6,
  c0_.productcartprice AS productcartprice_7,
  c0_.quantity AS quantity_8,
  c0_.engravetext AS engravetext_9,
  c0_.addedtime AS addedtime_10
FROM
  cart c0_
WHERE
  c0_.userid = ?
  AND c0_.establishmentid = ?
  AND c0_.productid = ?

SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = '22270733' AND c0_.establishmentid = '8597665' AND c0_.productid = '400098936';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 47)
7	App\Repository\CartRepository->getMyCarts (line 525)
8	App\Controller\CartController->addservicetocart (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 8)

1.06 ms
(10.44%)

select * from cartproductvariant where shopid = '8597665' and productid = '400098936' and productvariantid = ''

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  cartproductvariant
where
  shopid = '8597665'
  and productid = '400098936'
  and productvariantid = ''

select * from cartproductvariant where shopid = '8597665' and productid = '400098936' and productvariantid = '';

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 564)
3	App\Controller\CartController->addservicetocart (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 8)

0.86 ms
(8.50%)

SELECT p0_.id AS id_0, p0_.shopid AS shopid_1, p0_.productid AS productid_2, p0_.productprice AS productprice_3, p0_.markasoffer AS markasoffer_4, p0_.addedtime AS addedtime_5 FROM prodproductprice p0_ WHERE p0_.shopid = ? AND p0_.productid = ? ORDER BY p0_.id DESC LIMIT 1

Parameters:

[
  "8597665"
  "400098936"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.shopid AS shopid_1,
  p0_.productid AS productid_2,
  p0_.productprice AS productprice_3,
  p0_.markasoffer AS markasoffer_4,
  p0_.addedtime AS addedtime_5
FROM
  prodproductprice p0_
WHERE
  p0_.shopid = ?
  AND p0_.productid = ?
ORDER BY
  p0_.id DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.shopid AS shopid_1, p0_.productid AS productid_2, p0_.productprice AS productprice_3, p0_.markasoffer AS markasoffer_4, p0_.addedtime AS addedtime_5 FROM prodproductprice p0_ WHERE p0_.shopid = '8597665' AND p0_.productid = '400098936' ORDER BY p0_.id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 32)
7	App\Repository\ProdproductpriceRepository->shopproductprice (line 488)
8	App\Controller\CartController->addservicetocart (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 8)

0.77 ms
(7.55%)

SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = ? AND c0_.establishmentid = ? AND c0_.productid = ? ORDER BY c0_.id ASC

Parameters:

[
  "22270733"
  "8597665"
  "400098936"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.userid AS userid_1,
  c0_.cartid AS cartid_2,
  c0_.establishmentid AS establishmentid_3,
  c0_.productid AS productid_4,
  c0_.productvariantid AS productvariantid_5,
  c0_.productname AS productname_6,
  c0_.productcartprice AS productcartprice_7,
  c0_.quantity AS quantity_8,
  c0_.engravetext AS engravetext_9,
  c0_.addedtime AS addedtime_10
FROM
  cart c0_
WHERE
  c0_.userid = ?
  AND c0_.establishmentid = ?
  AND c0_.productid = ?
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = '22270733' AND c0_.establishmentid = '8597665' AND c0_.productid = '400098936' ORDER BY c0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 109)
7	App\Repository\CartRepository->getCartProduct (line 484)
8	App\Controller\CartController->addservicetocart (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 8)

0.69 ms
(6.77%)

INSERT INTO cart (userid, cartid, establishmentid, productid, productvariantid, productname, productcartprice, quantity, engravetext, addedtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "22270733"
  "z3HxcsIEQzzHIG9lb6xAKrxE"
  "8597665"
  "400098936"
  "0"
  "Potato"
  31.0
  2
  ""
  "2026-07-26 13:49:43"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO cart (
  userid, cartid, establishmentid, productid,
  productvariantid, productname, productcartprice,
  quantity, engravetext, addedtime
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO cart (userid, cartid, establishmentid, productid, productvariantid, productname, productcartprice, quantity, engravetext, addedtime) VALUES ('22270733', 'z3HxcsIEQzzHIG9lb6xAKrxE', '8597665', '400098936', '0', 'Potato', 31, 2, '', '2026-07-26 13:49:43');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 249)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 541)
7	App\Controller\CartController->addservicetocart (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 8)

0.51 ms
(5.02%)

select * from shopproducts where shopid = '8597665' and shopproductid = '400098936'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  shopproducts
where
  shopid = '8597665'
  and shopproductid = '400098936'

select * from shopproducts where shopid = '8597665' and shopproductid = '400098936';

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 494)
3	App\Controller\CartController->addservicetocart (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 8)

0.49 ms
(4.87%)

SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = ? AND c0_.establishmentid = ? ORDER BY c0_.id ASC

Parameters:

[
  "22270733"
  "8597665"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.userid AS userid_1,
  c0_.cartid AS cartid_2,
  c0_.establishmentid AS establishmentid_3,
  c0_.productid AS productid_4,
  c0_.productvariantid AS productvariantid_5,
  c0_.productname AS productname_6,
  c0_.productcartprice AS productcartprice_7,
  c0_.quantity AS quantity_8,
  c0_.engravetext AS engravetext_9,
  c0_.addedtime AS addedtime_10
FROM
  cart c0_
WHERE
  c0_.userid = ?
  AND c0_.establishmentid = ?
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.userid AS userid_1, c0_.cartid AS cartid_2, c0_.establishmentid AS establishmentid_3, c0_.productid AS productid_4, c0_.productvariantid AS productvariantid_5, c0_.productname AS productname_6, c0_.productcartprice AS productcartprice_7, c0_.quantity AS quantity_8, c0_.engravetext AS engravetext_9, c0_.addedtime AS addedtime_10 FROM cart c0_ WHERE c0_.userid = '22270733' AND c0_.establishmentid = '8597665' ORDER BY c0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 90)
7	App\Repository\CartRepository->getCart (line 513)
8	App\Controller\CartController->addservicetocart (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 8)

0.36 ms
(3.51%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 541)
5	App\Controller\CartController->addservicetocart (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 8)

0.32 ms
(3.18%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 541)
4	App\Controller\CartController->addservicetocart (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 8)

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\Cart	No errors.
App\Entity\Prodproductprice	No errors.

Symfony Profiler

POST https://www.anuppu.in/cart/addservicetocart?p=cart%2Faddservicetocart

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping