GET http://192.168.77.30/admin/product?query=aurum-xl

Query Metrics

9 Database Queries
7 Different statements
7.71 ms Query time
0 Invalid entities
166 Managed entities

Queries

Group similar statements

# Time Info
1 0.33 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 0.23 ms
SELECT a0_.attribute_name AS attribute_name_0 FROM attribute_list_field a0_ WHERE a0_.attribute_type = ?
Parameters:
[
  "boolean"
]
3 1.86 ms
SELECT DISTINCT p0_.product_type AS product_type_0 FROM product p0_ WHERE p0_.product_type IS NOT NULL ORDER BY p0_.product_type ASC
Parameters:
[]
4 2.05 ms
SELECT DISTINCT p0_.id AS id_0 FROM product p0_ WHERE LOWER(CONCAT(p0_.sku, '')) LIKE ? OR LOWER(CONCAT(p0_.product_type, '')) LIKE ? OR LOWER(CONCAT(p0_.parent_sku, '')) LIKE ? LIMIT 20
Parameters:
[
  "%aurum-xl%"
  "%aurum-xl%"
  "%aurum-xl%"
]
5 0.28 ms
SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.active AS active_2, p0_.product_type AS product_type_3, p0_.clearance AS clearance_4, p0_.sales_price AS sales_price_5, p0_.parent_sku AS parent_sku_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8 FROM product p0_ WHERE (LOWER(CONCAT(p0_.sku, '')) LIKE ? OR LOWER(CONCAT(p0_.product_type, '')) LIKE ? OR LOWER(CONCAT(p0_.parent_sku, '')) LIKE ?) AND p0_.id IN (?, ?, ?)
Parameters:
[
  "%aurum-xl%"
  "%aurum-xl%"
  "%aurum-xl%"
  586
  587
  588
]
6 1.98 ms
SELECT count(*) AS sclr_0 FROM product p0_ WHERE LOWER(CONCAT(p0_.sku, '')) LIKE ? OR LOWER(CONCAT(p0_.product_type, '')) LIKE ? OR LOWER(CONCAT(p0_.parent_sku, '')) LIKE ?
Parameters:
[
  "%aurum-xl%"
  "%aurum-xl%"
  "%aurum-xl%"
]
7 0.33 ms
SELECT t0.id AS id_1, t0.technical_name AS technical_name_2, t0.value AS value_3, t0.product_id AS product_id_4 FROM product_attribute t0 WHERE t0.product_id = ?
Parameters:
[
  586
]
8 0.31 ms
SELECT t0.id AS id_1, t0.technical_name AS technical_name_2, t0.value AS value_3, t0.product_id AS product_id_4 FROM product_attribute t0 WHERE t0.product_id = ?
Parameters:
[
  587
]
9 0.34 ms
SELECT t0.id AS id_1, t0.technical_name AS technical_name_2, t0.value AS value_3, t0.product_id AS product_id_4 FROM product_attribute t0 WHERE t0.product_id = ?
Parameters:
[
  588
]

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\ProductAttribute 162
App\Entity\Product 3
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\AttributeListField No errors.
App\Entity\Product No errors.
App\Entity\ProductAttribute No errors.
App\Entity\Price No errors.