https://konsoplus-connect.com/

Query Metrics

5 Database Queries
5 Different statements
3.17 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.94 ms
(29.69%)
1
SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.subcategory_id AS subcategory_id_3, t0.productname AS productname_4, t0.description AS description_5, t0.retailprice AS retailprice_6, t0.wholesaleprice AS wholesaleprice_7, t0.semiretailprice AS semiretailprice_8, t0.image AS image_9, t0.status AS status_10, t0.category_id AS category_id_11, t0.subcategory_id AS subcategory_id_12 FROM products t0 WHERE t0.status = ? ORDER BY t0.id DESC
Parameters:
[
  true
]
0.64 ms
(20.34%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM categorie t0 ORDER BY t0.id DESC
Parameters:
[]
0.62 ms
(19.52%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.province_id AS province_id_3 FROM city t0 ORDER BY t0.name ASC
Parameters:
[]
0.58 ms
(18.26%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM province t0 ORDER BY t0.name ASC
Parameters:
[]
0.39 ms
(12.19%)
1
SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.name AS name_3, t0.status AS status_4, t0.category_id AS category_id_5 FROM subcategorie t0 WHERE t0.status = ?
Parameters:
[
  "1"
]

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\Products No errors.
App\Entity\Categorie No errors.
App\Entity\Subcategorie No errors.
App\Entity\City No errors.
App\Entity\Province No errors.