Symfony Profiler

Query Metrics

13 Database Queries

13 Different statements

39.08 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.48 ms
(39.60%)

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)

8.25 ms
(21.10%)

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.73 ms
(7.00%)

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.65 ms
(4.22%)

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

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.54 ms
(3.95%)

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)

1.52 ms
(3.90%)

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)

1.14 ms
(2.91%)

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.10 ms
(2.80%)

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)

1.06 ms
(2.71%)

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)

1.05 ms
(2.70%)

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.04 ms
(2.66%)

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)

0.91 ms
(2.32%)

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)

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