GET https://e-commerce.it.com/

Query Metrics

22 Database Queries
3 Different statements
17.68 ms Query time
0 Invalid entities
18 Managed entities

Queries

Group similar statements

# Time Info
1 4.60 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.stock AS stock_4, p0_.image AS image_5, p0_.is_featured AS is_featured_6, p0_.category_id AS category_id_7 FROM products p0_ WHERE p0_.is_featured = true ORDER BY p0_.id DESC LIMIT 8
Parameters:
[]
2 4.07 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.parent_id AS parent_id_3 FROM categories c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC
Parameters:
[]
3 0.82 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.parent_id AS parent_id_3 FROM categories c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC
Parameters:
[]
4 1.15 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  4
]
5 0.55 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  9
]
6 0.45 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  7
]
7 0.41 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  18
]
8 0.37 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  8
]
9 0.35 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  6
]
10 0.37 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  10
]
11 0.33 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  2
]
12 0.39 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  13
]
13 0.31 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  15
]
14 0.39 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  12
]
15 0.33 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  14
]
16 0.38 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  17
]
17 0.37 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  5
]
18 0.40 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  1
]
19 0.37 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  16
]
20 0.39 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  11
]
21 0.39 ms
SELECT COUNT(*) FROM products t0 WHERE t0.category_id = ?
Parameters:
[
  3
]
22 0.49 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.parent_id AS parent_id_3 FROM categories c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.name ASC
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Catalog\Domain\Entity\Category 18

Entities Mapping

Class Mapping errors
App\Catalog\Domain\Entity\Product No errors.
App\Catalog\Domain\Entity\Category No errors.