GET https://anuppu.in.demodump.in/shop/products/8597665?p=shop%2Fproducts%2F8597665

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
14.34 ms
(59.21%)
1
select * from cart where establishmentid = '8597665' and userid = ''
Parameters:
[]
2.47 ms
(10.19%)
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:
[
  "8597665"
]
2.31 ms
(9.55%)
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:
[
  "8597665"
]
1.06 ms
(4.36%)
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:
[
  "8597665"
  "0"
]
0.70 ms
(2.89%)
1
select * from  shopdetails where shopid = '8597665' order by id desc
Parameters:
[]
0.65 ms
(2.67%)
1
select * from productmaster where productmasterid IN (117009,476306,332968)
Parameters:
[]
0.49 ms
(2.02%)
1
select * from prodproductprice where shopid = '8597665' and productid IN (392193371,400098936,266577626)
Parameters:
[]
0.47 ms
(1.92%)
1
select * from  shopimages where shopid = '8597665' and imageshowhide = '0'
Parameters:
[]
0.44 ms
(1.84%)
1
select * from shopkeywords where shopid = :shopid
Parameters:
[
  "shopid" => "8597665"
]
0.44 ms
(1.83%)
1
select * from productcategories where shopid = '8597665'
Parameters:
[]
0.44 ms
(1.83%)
1
select * from shoporderingtime where shopid = :shopid
Parameters:
[
  "shopid" => "8597665"
]
0.41 ms
(1.69%)
1
select * from productshopcategories where shopid = '8597665'
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.