GET https://www.anuppu.in/orders/details/mOwtftvNE55FJ8oZ?p=orders%2Fdetails%2FmOwtftvNE55FJ8oZ

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1.78 ms
(14.92%)
1
select * from orders where orderid = 'mOwtftvNE55FJ8oZ'
Parameters:
[]
1.54 ms
(12.92%)
1
select * from useraddress
                             JOIN addresses ON addresses.addressid = useraddress.addressid
                             where userid = '22270733'
Parameters:
[]
1.33 ms
(11.21%)
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:
[
  "8113188"
]
1.16 ms
(9.72%)
1
SELECT o0_.id AS id_0, o0_.orderid AS orderid_1, o0_.addressid AS addressid_2, o0_.doornumber AS doornumber_3, o0_.streetname AS streetname_4, o0_.streetname2 AS streetname2_5, o0_.areaname AS areaname_6, o0_.cityid AS cityid_7, o0_.stateid AS stateid_8, o0_.landmark AS landmark_9 FROM orderaddress o0_ WHERE o0_.orderid = ?
Parameters:
[
  "mOwtftvNE55FJ8oZ"
]
1.05 ms
(8.83%)
1
select * from orderproducts where orderid = 'mOwtftvNE55FJ8oZ'
Parameters:
[]
0.89 ms
(7.49%)
1
select * from orderdeliverytimeslot where orderid = 'mOwtftvNE55FJ8oZ'
Parameters:
[]
0.86 ms
(7.26%)
1
select * from orderprescription where orderid = 'mOwtftvNE55FJ8oZ'
Parameters:
[]
0.84 ms
(7.02%)
1
select * from shopproductstax where shopid = '8113188' order by id asc
Parameters:
[]
0.74 ms
(6.18%)
1
select * from shopdetails where shopid = '8113188' and shopdetailsname = 'paymentqr'
Parameters:
[]
0.70 ms
(5.86%)
1
select * from orderstatus where orderid = 'mOwtftvNE55FJ8oZ' order by id desc
Parameters:
[]
0.67 ms
(5.61%)
1
select * from ordercourier where orderid IN ('mOwtftvNE55FJ8oZ') order by id desc
Parameters:
[]
0.35 ms
(2.97%)
1
select * from useraddress where userid = '22270733'
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\Orderaddress No errors.