https://www.service-africa.com/

Query Metrics

9 Database Queries
5 Different statements
5.59 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.21 ms
(0.00%)
5
SELECT c0_.id AS id_0, c0_.cart_cat AS cart_cat_1, c0_.type AS type_2, c0_.type1 AS type1_3, c0_.status AS status_4, c0_.user_id AS user_id_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.name AS name_8, c0_.name_en AS name_en_9, c0_.content AS content_10, c0_.content_en AS content_en_11, c0_.image AS image_12, c0_.price AS price_13, c0_.price_old AS price_old_14 FROM cart_product c0_ WHERE c0_.cart_cat = ? ORDER BY c0_.id ASC LIMIT 7
Parameters:
[
  1
]
0.76 ms
(0.00%)
1
SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.name AS name_3, c0_.content AS content_4, c0_.image AS image_5, c0_.price AS price_6 FROM cart_payment c0_
Parameters:
[]
0.67 ms
(0.00%)
1
SELECT cat_sp, sum(price) as sum1
                FROM cart_product_sp
				WHERE cat_sp =1
				UNION
				SELECT cat_sp, sum(price) as sum2
                FROM cart_product_sp
			    WHERE cat_sp =2
				UNION
				SELECT cat_sp, sum(price) as sum3
				FROM cart_product_sp
				WHERE cat_sp =3
				UNION
				SELECT cat_sp, sum(price) as sum4
				FROM cart_product_sp
				WHERE 	cat_sp =4
				UNION
				SELECT cat_sp, sum(price) as sum5
				FROM cart_product_sp
				WHERE 	cat_sp =5
Parameters:
[]
0.48 ms
(0.00%)
1
SELECT c0_.id AS id_0, c0_.cart_cat AS cart_cat_1, c0_.type AS type_2, c0_.type1 AS type1_3, c0_.status AS status_4, c0_.user_id AS user_id_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.name AS name_8, c0_.name_en AS name_en_9, c0_.content AS content_10, c0_.content_en AS content_en_11, c0_.image AS image_12, c0_.price AS price_13, c0_.price_old AS price_old_14 FROM cart_product c0_ WHERE c0_.cart_cat <> ? ORDER BY c0_.created_at DESC LIMIT 10
Parameters:
[
  10
]
0.46 ms
(0.00%)
1
SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.name AS name_3, c0_.price AS price_4, c0_.content AS content_5, c0_.image AS image_6 FROM cart_shipment c0_
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\Component\Product\Model\Product No errors.
App\Entity\WishList No errors.
App\Component\Order\Model\OrderItem No errors.
App\Component\Payment\Model\Payment No errors.
App\Component\Shipment\Model\Shipment No errors.