Symfony Profiler

Query Metrics

13 Database Queries

13 Different statements

38.15 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.81 ms
(33.58%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

6.42 ms
(16.82%)

select * from orderreview where  productid = '392193371' 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 = '392193371'
  and shopid = '8597665'
  and displayreview = '1'
order by
  id desc

select * from orderreview where  productid = '392193371' 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.84 ms
(7.43%)

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.63 ms
(6.90%)

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

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 = '392193371'

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

#	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.11 ms
(5.53%)

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

Parameters:

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

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 = '392193371';

#	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.96 ms
(5.13%)

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"
  "392193371"
]

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 = '392193371' 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.74 ms
(4.56%)

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

Parameters:

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

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 = '392193371' 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.64 ms
(4.30%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	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.26 ms
(3.31%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

select * from shopproductmoq   where  productid = '392193371' 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.25 ms
(3.28%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

select * from shopproductimages   where  productid = '392193371' 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.25 ms
(3.27%)

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

select * from proddiscountprice where shopid = '8597665' and productid = '392193371' 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.14 ms
(3.00%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

1.10 ms
(2.89%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

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/392193371?p=shop%2Fproductdetails%2F8597665%2F392193371

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping