GET https://www.myecolabels.com/search

Query Metrics

15 Database Queries
7 Different statements
6.22 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.44 ms
SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.priority AS priority_2, p0_.image AS image_3, p0_.parent_id AS parent_id_4 FROM product_category p0_ WHERE p0_.parent_id = ? ORDER BY p0_.priority ASC
Parameters:
[
  null
]
2 0.26 ms
SELECT t0.id AS id_1, t0.material AS material_2 FROM material t0
Parameters:
[]
3 1.19 ms
SELECT DISTINCT p0_.size AS size_0 FROM product p0_
Parameters:
[]
4 0.89 ms
SELECT DISTINCT p0_.class AS class_0 FROM product p0_ WHERE p0_.class <> ?
Parameters:
[
  ""
]
5 0.93 ms
SELECT DISTINCT p0_.shape AS shape_0 FROM product p0_ WHERE p0_.shape <> ?
Parameters:
[
  ""
]
6 0.32 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:
[]
7 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
]
8 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
]
9 0.25 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
]
10 0.25 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
]
11 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:
[
  5
]
12 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:
[
  6
]
13 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:
[
  7
]
14 0.21 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
]
15 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 IS NULL ORDER BY t0.priority ASC
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.

Entities Mapping

Class Mapping errors
App\Entity\ProductCategory No 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\Material No errors.