GET https://www.myecolabels.com/product/1427

Query Metrics

12 Database Queries
5 Different statements
3.04 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.36 ms
SELECT t0.id AS id_1, t0.class AS class_2, t0.name AS name_3, t0.item_number AS item_number_4, t0.size AS size_5, t0.shape AS shape_6, t0.quantity AS quantity_7, t0.weight AS weight_8, t0.is_viewable AS is_viewable_9, t0.notes AS notes_10, t0.image AS image_11, t0.product_category_id AS product_category_id_12, t0.material_id AS material_id_13 FROM product t0 WHERE t0.id = ?
Parameters:
[
  "1427"
]
2 0.40 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id IS NULL ORDER BY t0.priority ASC
Parameters:
[]
3 0.28 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = ? ORDER BY t0.priority ASC
Parameters:
[
  1
]
4 0.26 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = ? ORDER BY t0.priority ASC
Parameters:
[
  2
]
5 0.24 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = ? ORDER BY t0.priority ASC
Parameters:
[
  3
]
6 0.22 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = ? ORDER BY t0.priority ASC
Parameters:
[
  4
]
7 0.23 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = ? ORDER BY t0.priority ASC
Parameters:
[
  5
]
8 0.20 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = ? ORDER BY t0.priority ASC
Parameters:
[
  6
]
9 0.20 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = ? ORDER BY t0.priority ASC
Parameters:
[
  7
]
10 0.23 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = ? ORDER BY t0.priority ASC
Parameters:
[
  8
]
11 0.19 ms
SELECT t0.id AS id_1, t0.material AS material_2 FROM material t0 WHERE t0.id = ?
Parameters:
[
  21
]
12 0.23 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.label AS label_4, t0.product_id AS product_id_5 FROM product_quantity t0 WHERE t0.product_id = ? ORDER BY t0.quantity ASC
Parameters:
[
  1427
]

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\Product
  • The field 'App\Entity\Product#weight' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ProductCategory No errors.
App\Entity\Material No errors.
App\Entity\ProductQuantity No errors.