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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
2.10 ms
(63.80%)
8
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
]
0.39 ms
(11.77%)
1
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:
[]
0.37 ms
(11.37%)
1
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:
[
  "179"
]
0.25 ms
(7.69%)
1
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:
[
  179
]
0.18 ms
(5.38%)
1
SELECT t0.id AS id_1, t0.material AS material_2 FROM material t0 WHERE t0.id = ?
Parameters:
[
  9
]

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.