GET https://dev-acti.basicom.fr/category/equipement

Query Metrics

15 Database Queries
4 Different statements
6.01 ms Query time
1 Invalid entities
456 Managed entities

Queries

Group similar statements

# Time Info
1 0.84 ms
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:
[]
2 0.36 ms
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:
[
  "equipement"
]
3 0.31 ms
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.parent_id = ?
Parameters:
[
  6
]
4 0.42 ms
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.product_name AS product_name_3, t0.description AS description_4, t0.item_code AS item_code_5, t0.image_filename AS image_filename_6, t0.is_clearance AS is_clearance_7, t0.slug AS slug_8, t0.stock AS stock_9, t0.price AS price_10, t0.other_product_specification AS other_product_specification_11, t0.created_at AS created_at_12, t0.category_id AS category_id_13, t0.supplier_id AS supplier_id_14 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  7
]
5 0.44 ms
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.product_name AS product_name_3, t0.description AS description_4, t0.item_code AS item_code_5, t0.image_filename AS image_filename_6, t0.is_clearance AS is_clearance_7, t0.slug AS slug_8, t0.stock AS stock_9, t0.price AS price_10, t0.other_product_specification AS other_product_specification_11, t0.created_at AS created_at_12, t0.category_id AS category_id_13, t0.supplier_id AS supplier_id_14 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  8
]
6 0.34 ms
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.product_name AS product_name_3, t0.description AS description_4, t0.item_code AS item_code_5, t0.image_filename AS image_filename_6, t0.is_clearance AS is_clearance_7, t0.slug AS slug_8, t0.stock AS stock_9, t0.price AS price_10, t0.other_product_specification AS other_product_specification_11, t0.created_at AS created_at_12, t0.category_id AS category_id_13, t0.supplier_id AS supplier_id_14 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  11
]
7 0.49 ms
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.product_name AS product_name_3, t0.description AS description_4, t0.item_code AS item_code_5, t0.image_filename AS image_filename_6, t0.is_clearance AS is_clearance_7, t0.slug AS slug_8, t0.stock AS stock_9, t0.price AS price_10, t0.other_product_specification AS other_product_specification_11, t0.created_at AS created_at_12, t0.category_id AS category_id_13, t0.supplier_id AS supplier_id_14 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  12
]
8 0.40 ms
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.product_name AS product_name_3, t0.description AS description_4, t0.item_code AS item_code_5, t0.image_filename AS image_filename_6, t0.is_clearance AS is_clearance_7, t0.slug AS slug_8, t0.stock AS stock_9, t0.price AS price_10, t0.other_product_specification AS other_product_specification_11, t0.created_at AS created_at_12, t0.category_id AS category_id_13, t0.supplier_id AS supplier_id_14 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  13
]
9 0.44 ms
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.product_name AS product_name_3, t0.description AS description_4, t0.item_code AS item_code_5, t0.image_filename AS image_filename_6, t0.is_clearance AS is_clearance_7, t0.slug AS slug_8, t0.stock AS stock_9, t0.price AS price_10, t0.other_product_specification AS other_product_specification_11, t0.created_at AS created_at_12, t0.category_id AS category_id_13, t0.supplier_id AS supplier_id_14 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  14
]
10 0.32 ms
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.product_name AS product_name_3, t0.description AS description_4, t0.item_code AS item_code_5, t0.image_filename AS image_filename_6, t0.is_clearance AS is_clearance_7, t0.slug AS slug_8, t0.stock AS stock_9, t0.price AS price_10, t0.other_product_specification AS other_product_specification_11, t0.created_at AS created_at_12, t0.category_id AS category_id_13, t0.supplier_id AS supplier_id_14 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  15
]
11 0.36 ms
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.product_name AS product_name_3, t0.description AS description_4, t0.item_code AS item_code_5, t0.image_filename AS image_filename_6, t0.is_clearance AS is_clearance_7, t0.slug AS slug_8, t0.stock AS stock_9, t0.price AS price_10, t0.other_product_specification AS other_product_specification_11, t0.created_at AS created_at_12, t0.category_id AS category_id_13, t0.supplier_id AS supplier_id_14 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  19
]
12 0.49 ms
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.product_name AS product_name_3, t0.description AS description_4, t0.item_code AS item_code_5, t0.image_filename AS image_filename_6, t0.is_clearance AS is_clearance_7, t0.slug AS slug_8, t0.stock AS stock_9, t0.price AS price_10, t0.other_product_specification AS other_product_specification_11, t0.created_at AS created_at_12, t0.category_id AS category_id_13, t0.supplier_id AS supplier_id_14 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  21
]
13 0.34 ms
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.product_name AS product_name_3, t0.description AS description_4, t0.item_code AS item_code_5, t0.image_filename AS image_filename_6, t0.is_clearance AS is_clearance_7, t0.slug AS slug_8, t0.stock AS stock_9, t0.price AS price_10, t0.other_product_specification AS other_product_specification_11, t0.created_at AS created_at_12, t0.category_id AS category_id_13, t0.supplier_id AS supplier_id_14 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  22
]
14 0.25 ms
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:
[
  "equipement"
]
15 0.21 ms
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:
[
  "equipement"
]

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 405
App\Entity\Supplier 38
App\Entity\Category 13

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.