GET https://dev-acti.basicom.fr/sub-categorie/protection-pied

Query Metrics

4 Database Queries
4 Different statements
4.70 ms Query time
1 Invalid entities
568 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.17 ms
(46.27%)
1
SELECT p0_.id AS id_0, p0_.product_code AS product_code_1, p0_.product_name AS product_name_2, p0_.description AS description_3, p0_.item_code AS item_code_4, p0_.image_filename AS image_filename_5, p0_.is_clearance AS is_clearance_6, p0_.slug AS slug_7, p0_.stock AS stock_8, p0_.price AS price_9, p0_.other_product_specification AS other_product_specification_10, p0_.created_at AS created_at_11, p0_.category_id AS category_id_12, p0_.supplier_id AS supplier_id_13 FROM product p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.slug = ?
Parameters:
[
  "protection-pied"
]
1.63 ms
(34.75%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.image AS image_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "protection-pied"
]
0.49 ms
(10.43%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.slug AS slug_3, c0_.image AS image_4, c0_.parent_id AS parent_id_5 FROM category c0_ WHERE c0_.parent_id IS NULL
Parameters:
[]
0.40 ms
(8.55%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.slug AS slug_3, c0_.image AS image_4, c0_.parent_id AS parent_id_5 FROM category c0_ WHERE c0_.parent_id IS NOT NULL
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\Entity\Product 535
App\Entity\Category 19
App\Entity\Supplier 14

Entities Mapping

Class Mapping errors
App\Entity\Category No errors.
App\Entity\Product
  • The association App\Entity\Product#supplier refers to the inverse side field App\Entity\Supplier#products which does not exist.
App\Entity\Supplier No errors.
App\Entity\Job No errors.
App\Entity\ProductSize No errors.