GET https://www.anuppu.in.demodump.in/shop/products/4247814?p=shop%2Fproducts%2F4247814

Query Metrics

12 Database Queries
12 Different statements
167.06 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
27.27 ms
(16.32%)
1
select * from productmaster where productmasterid IN (115116,340299,476306)
Parameters:
[]
22.28 ms
(13.34%)
1
select * from prodproductprice where shopid = '4247814' and productid IN (466622709,865489730,633410670)
Parameters:
[]
19.25 ms
(11.52%)
1
select * from  shopimages where shopid = '4247814' and imageshowhide = '0'
Parameters:
[]
16.87 ms
(10.10%)
1
select * from shoporderingtime where shopid = :shopid
Parameters:
[
  "shopid" => "4247814"
]
13.88 ms
(8.31%)
1
SELECT s0_.id AS id_0, s0_.shopid AS shopid_1, s0_.shopname AS shopname_2, s0_.shopaddressid AS shopaddressid_3, s0_.contactuserid AS contactuserid_4, s0_.contactname AS contactname_5, s0_.addedtime AS addedtime_6 FROM shop s0_ WHERE s0_.shopid = ?
Parameters:
[
  "4247814"
]
12.80 ms
(7.66%)
1
select * from cart where establishmentid = '4247814' and userid = ''
Parameters:
[]
12.78 ms
(7.65%)
1
select * from shopkeywords where shopid = :shopid
Parameters:
[
  "shopid" => "4247814"
]
11.16 ms
(6.68%)
1
select * from  shopdetails where shopid = '4247814' order by id desc
Parameters:
[]
10.55 ms
(6.32%)
1
SELECT s0_.id AS id_0, s0_.shopid AS shopid_1, s0_.shopname AS shopname_2, s0_.shopaddressid AS shopaddressid_3, s0_.contactuserid AS contactuserid_4, s0_.contactname AS contactname_5, s0_.addedtime AS addedtime_6 FROM shop s0_ WHERE s0_.shopid IN (?)
Parameters:
[
  "4247814"
]
7.91 ms
(4.74%)
1
select * from productshopcategories where shopid = '4247814'
Parameters:
[]
7.10 ms
(4.25%)
1
SELECT s0_.id AS id_0, s0_.shopid AS shopid_1, s0_.shopproductid AS shopproductid_2, s0_.masterproductid AS masterproductid_3, s0_.shopproductname AS shopproductname_4, s0_.shopproductprice AS shopproductprice_5, s0_.shopproductdesc AS shopproductdesc_6, s0_.displayproduct AS displayproduct_7, s0_.stockout AS stockout_8 FROM shopproducts s0_ WHERE s0_.shopid = ? AND s0_.displayproduct = ?
Parameters:
[
  "4247814"
  "0"
]
5.21 ms
(3.12%)
1
select * from productcategories where shopid = '4247814'
Parameters:
[]

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\Shop No errors.
App\Entity\Shopproducts No errors.