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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1.94 ms
(31.24%)
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
]
1.19 ms
(19.09%)
1
SELECT DISTINCT p0_.size AS size_0 FROM product p0_
Parameters:
[]
0.93 ms
(14.89%)
1
SELECT DISTINCT p0_.shape AS shape_0 FROM product p0_ WHERE p0_.shape <> ?
Parameters:
[
  ""
]
0.89 ms
(14.36%)
1
SELECT DISTINCT p0_.class AS class_0 FROM product p0_ WHERE p0_.class <> ?
Parameters:
[
  ""
]
0.58 ms
(9.33%)
2
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.44 ms
(6.99%)
1
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
]
0.26 ms
(4.10%)
1
SELECT t0.id AS id_1, t0.material AS material_2 FROM material t0
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.