Symfony Profiler

Query Metrics

13 Database Queries

13 Different statements

49.28 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

18.35 ms
(37.23%)

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

Parameters:

[
  "shopid" => "8597665"
  "productid" => "400098936"
]

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 = '8597665' and productid = '400098936' 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)

13.73 ms
(27.86%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

select * from orderreview where  productid = '400098936' and shopid = '8597665' 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.99 ms
(6.06%)

select * from shop where shopid = '8597665'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  shop
where
  shopid = '8597665'

select * from shop where shopid = '8597665';

#	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)

2.43 ms
(4.92%)

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

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 = '8597665'
  and orderproducts.productid = '400098936'

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

#	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)

1.89 ms
(3.83%)

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

Parameters:

[
  "shopid" => "8597665"
  "productid" => "400098936"
]

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 = '8597665' and productid = '400098936';

#	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.62 ms
(3.28%)

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 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)

1.59 ms
(3.22%)

select * from serviceavailabletimes where shopid = '8597665' and productid = '400098936'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  serviceavailabletimes
where
  shopid = '8597665'
  and productid = '400098936'

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

#	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.29 ms
(2.62%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

select * from shopproductmoq   where  productid = '400098936' and shopid = '8597665' 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)

1.23 ms
(2.50%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

select * from shopproductimages   where  productid = '400098936' 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)

1.13 ms
(2.29%)

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 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)

1.07 ms
(2.17%)

select * from proddiscountprice 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
  proddiscountprice
where
  shopid = '8597665'
  and productid = '400098936'
order by
  id desc
limit
  0, 1

select * from proddiscountprice 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 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)

1.03 ms
(2.09%)

select * from productspecs where shopid = '8597665' and productid = '400098936'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  productspecs
where
  shopid = '8597665'
  and productid = '400098936'

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

#	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)

0.95 ms
(1.92%)

select * from cart where establishmentid = '8597665' and productid = '400098936' and userid = ''

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

select
  *
from
  cart
where
  establishmentid = '8597665'
  and productid = '400098936'
  and userid = ''

select * from cart where establishmentid = '8597665' and productid = '400098936' 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)

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://anuppu.in.demodump.in/shop/productdetails/8597665/400098936?p=shop%2Fproductdetails%2F8597665%2F400098936

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping