Symfony Profiler

Query Metrics

13 Database Queries

13 Different statements

86.00 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

32.63 ms
(37.95%)

select * from shop where shopid = '4247814'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  shop
where
  shopid = '4247814'

select * from shop where shopid = '4247814';

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 305)
3	App\Controller\ShopController->productdetails (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)

13.80 ms
(16.05%)

select * from cart where establishmentid = '4247814' and productid = '466622709' and userid = ''

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  cart
where
  establishmentid = '4247814'
  and productid = '466622709'
  and userid = ''

select * from cart where establishmentid = '4247814' and productid = '466622709' and userid = '';

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 348)
3	App\Controller\ShopController->productdetails (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)

12.15 ms
(14.13%)

select * from shopproductmoq   where  productid = '466622709' and shopid = '4247814' order by id desc

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  shopproductmoq
where
  productid = '466622709'
  and shopid = '4247814'
order by
  id desc

select * from shopproductmoq   where  productid = '466622709' and shopid = '4247814' order by id desc;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 356)
3	App\Controller\ShopController->productdetails (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)

4.42 ms
(5.14%)

select * from shopproductimages   where  productid = '466622709' and productimagevisibility = '0' order by id desc

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  shopproductimages
where
  productid = '466622709'
  and productimagevisibility = '0'
order by
  id desc

select * from shopproductimages   where  productid = '466622709' and productimagevisibility = '0' order by id desc;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 353)
3	App\Controller\ShopController->productdetails (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)

4.24 ms
(4.93%)

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:

[
  "4247814"
  "466622709"
]

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 = '4247814' AND p0_.productid = '466622709' 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 326)
8	App\Controller\ShopController->productdetails (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)

3.88 ms
(4.51%)

select * from orders
        JOIN orderproducts ON orders.orderid = orderproducts.orderid
        where orders.userid = '' and orders.establishmentid = '4247814' and orderproducts.productid = '466622709'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  orders
  JOIN orderproducts ON orders.orderid = orderproducts.orderid
where
  orders.userid = ''
  and orders.establishmentid = '4247814'
  and orderproducts.productid = '466622709'

select * from orders
        JOIN orderproducts ON orders.orderid = orderproducts.orderid
        where orders.userid = '' and orders.establishmentid = '4247814' and orderproducts.productid = '466622709';

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 361)
3	App\Controller\ShopController->productdetails (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)

2.60 ms
(3.02%)

select * from orderreview where  productid = '466622709' and shopid = '4247814' and displayreview = '1' order by id desc

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  orderreview
where
  productid = '466622709'
  and shopid = '4247814'
  and displayreview = '1'
order by
  id desc

select * from orderreview where  productid = '466622709' and shopid = '4247814' and displayreview = '1' order by id desc;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 380)
3	App\Controller\ShopController->productdetails (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)

2.58 ms
(3.00%)

select * from productspecs where shopid = '4247814' and productid = '466622709'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  productspecs
where
  shopid = '4247814'
  and productid = '466622709'

select * from productspecs where shopid = '4247814' and productid = '466622709';

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 342)
3	App\Controller\ShopController->productdetails (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)

2.35 ms
(2.74%)

select * from proddiscountprice where shopid = '4247814' and productid = '466622709' order by id desc limit 0,1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  proddiscountprice
where
  shopid = '4247814'
  and productid = '466622709'
order by
  id desc
limit
  0, 1

select * from proddiscountprice where shopid = '4247814' and productid = '466622709' order by id desc limit 0,1;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 345)
3	App\Controller\ShopController->productdetails (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)

2.28 ms
(2.65%)

select * from serviceavailabletimes where shopid = '4247814' and productid = '466622709'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  serviceavailabletimes
where
  shopid = '4247814'
  and productid = '466622709'

select * from serviceavailabletimes where shopid = '4247814' and productid = '466622709'
        ;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 337)
3	App\Controller\ShopController->productdetails (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.93 ms
(2.24%)

select * from shopproductsstock where shopid = :shopid and productid = :productid and showhide = '0' order by id desc

Parameters:

[
  "shopid" => "4247814"
  "productid" => "466622709"
]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  shopproductsstock
where
  shopid = :shopid
  and productid = :productid
  and showhide = '0'
order by
  id desc

select * from shopproductsstock where shopid = '4247814' and productid = '466622709' and showhide = '0' order by id desc;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 385)
3	App\Controller\ShopController->productdetails (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.69 ms
(1.96%)

select * from shopproductvariants where shopid = :shopid and productid = :productid

Parameters:

[
  "shopid" => "4247814"
  "productid" => "466622709"
]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  shopproductvariants
where
  shopid = :shopid
  and productid = :productid

select * from shopproductvariants where shopid = '4247814' and productid = '466622709';

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 389)
3	App\Controller\ShopController->productdetails (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.44 ms
(1.68%)

select * from shopproducts where shopid = '4247814' and shopproductid = '466622709'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  shopproducts
where
  shopid = '4247814'
  and shopproductid = '466622709'

select * from shopproducts where shopid = '4247814' and shopproductid = '466622709';

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 323)
3	App\Controller\ShopController->productdetails (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)

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

Symfony Profiler

GET https://www.anuppu.in/shop/productdetails/4247814/466622709?p=shop%2Fproductdetails%2F4247814%2F466622709

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping