GET https://atelierhobby3d.fr/api/sub_categories

Query Metrics

12 Database Queries
2 Different statements
61.36 ms Query time
0 Invalid entities
19 Managed entities

Queries

Group similar statements

# Time Info
1 28.62 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.slug AS slug_3, s0_.category_id AS category_id_4 FROM sub_category s0_ ORDER BY s0_.id ASC
Parameters:
[]
2 17.76 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.creator AS creator_3, t0.slug AS slug_4, t0.description AS description_5, t0.main_illustration AS main_illustration_6, t0.illustrations AS illustrations_7, t0.price_tva AS price_tva_8, t0.price_ht AS price_ht_9, t0.is_new_product AS is_new_product_10, t0.nom_officiel AS nom_officiel_11, t0.category_id AS category_id_12, t0.subcategory_id AS subcategory_id_13 FROM product t0 WHERE t0.subcategory_id = ?
Parameters:
[
  1
]
3 3.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.creator AS creator_3, t0.slug AS slug_4, t0.description AS description_5, t0.main_illustration AS main_illustration_6, t0.illustrations AS illustrations_7, t0.price_tva AS price_tva_8, t0.price_ht AS price_ht_9, t0.is_new_product AS is_new_product_10, t0.nom_officiel AS nom_officiel_11, t0.category_id AS category_id_12, t0.subcategory_id AS subcategory_id_13 FROM product t0 WHERE t0.subcategory_id = ?
Parameters:
[
  2
]
4 3.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.creator AS creator_3, t0.slug AS slug_4, t0.description AS description_5, t0.main_illustration AS main_illustration_6, t0.illustrations AS illustrations_7, t0.price_tva AS price_tva_8, t0.price_ht AS price_ht_9, t0.is_new_product AS is_new_product_10, t0.nom_officiel AS nom_officiel_11, t0.category_id AS category_id_12, t0.subcategory_id AS subcategory_id_13 FROM product t0 WHERE t0.subcategory_id = ?
Parameters:
[
  3
]
5 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.creator AS creator_3, t0.slug AS slug_4, t0.description AS description_5, t0.main_illustration AS main_illustration_6, t0.illustrations AS illustrations_7, t0.price_tva AS price_tva_8, t0.price_ht AS price_ht_9, t0.is_new_product AS is_new_product_10, t0.nom_officiel AS nom_officiel_11, t0.category_id AS category_id_12, t0.subcategory_id AS subcategory_id_13 FROM product t0 WHERE t0.subcategory_id = ?
Parameters:
[
  4
]
6 1.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.creator AS creator_3, t0.slug AS slug_4, t0.description AS description_5, t0.main_illustration AS main_illustration_6, t0.illustrations AS illustrations_7, t0.price_tva AS price_tva_8, t0.price_ht AS price_ht_9, t0.is_new_product AS is_new_product_10, t0.nom_officiel AS nom_officiel_11, t0.category_id AS category_id_12, t0.subcategory_id AS subcategory_id_13 FROM product t0 WHERE t0.subcategory_id = ?
Parameters:
[
  5
]
7 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.creator AS creator_3, t0.slug AS slug_4, t0.description AS description_5, t0.main_illustration AS main_illustration_6, t0.illustrations AS illustrations_7, t0.price_tva AS price_tva_8, t0.price_ht AS price_ht_9, t0.is_new_product AS is_new_product_10, t0.nom_officiel AS nom_officiel_11, t0.category_id AS category_id_12, t0.subcategory_id AS subcategory_id_13 FROM product t0 WHERE t0.subcategory_id = ?
Parameters:
[
  6
]
8 1.98 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.creator AS creator_3, t0.slug AS slug_4, t0.description AS description_5, t0.main_illustration AS main_illustration_6, t0.illustrations AS illustrations_7, t0.price_tva AS price_tva_8, t0.price_ht AS price_ht_9, t0.is_new_product AS is_new_product_10, t0.nom_officiel AS nom_officiel_11, t0.category_id AS category_id_12, t0.subcategory_id AS subcategory_id_13 FROM product t0 WHERE t0.subcategory_id = ?
Parameters:
[
  7
]
9 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.creator AS creator_3, t0.slug AS slug_4, t0.description AS description_5, t0.main_illustration AS main_illustration_6, t0.illustrations AS illustrations_7, t0.price_tva AS price_tva_8, t0.price_ht AS price_ht_9, t0.is_new_product AS is_new_product_10, t0.nom_officiel AS nom_officiel_11, t0.category_id AS category_id_12, t0.subcategory_id AS subcategory_id_13 FROM product t0 WHERE t0.subcategory_id = ?
Parameters:
[
  8
]
10 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.creator AS creator_3, t0.slug AS slug_4, t0.description AS description_5, t0.main_illustration AS main_illustration_6, t0.illustrations AS illustrations_7, t0.price_tva AS price_tva_8, t0.price_ht AS price_ht_9, t0.is_new_product AS is_new_product_10, t0.nom_officiel AS nom_officiel_11, t0.category_id AS category_id_12, t0.subcategory_id AS subcategory_id_13 FROM product t0 WHERE t0.subcategory_id = ?
Parameters:
[
  9
]
11 1.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.creator AS creator_3, t0.slug AS slug_4, t0.description AS description_5, t0.main_illustration AS main_illustration_6, t0.illustrations AS illustrations_7, t0.price_tva AS price_tva_8, t0.price_ht AS price_ht_9, t0.is_new_product AS is_new_product_10, t0.nom_officiel AS nom_officiel_11, t0.category_id AS category_id_12, t0.subcategory_id AS subcategory_id_13 FROM product t0 WHERE t0.subcategory_id = ?
Parameters:
[
  10
]
12 1.88 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.creator AS creator_3, t0.slug AS slug_4, t0.description AS description_5, t0.main_illustration AS main_illustration_6, t0.illustrations AS illustrations_7, t0.price_tva AS price_tva_8, t0.price_ht AS price_ht_9, t0.is_new_product AS is_new_product_10, t0.nom_officiel AS nom_officiel_11, t0.category_id AS category_id_12, t0.subcategory_id AS subcategory_id_13 FROM product t0 WHERE t0.subcategory_id = ?
Parameters:
[
  11
]

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\SubCategory 11
App\Entity\Product 5
App\Entity\Category 3

Entities Mapping

Class Mapping errors
App\Entity\SubCategory No errors.
App\Entity\Category No errors.
App\Entity\Product No errors.