GET https://westmar.intgate.io/warehouse/api/items/search?limit=200&q=Lower&warehouse=3

Query Metrics

8 Database Queries
5 Different statements
2.57 ms Query time
0 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 0.20 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.position AS position_7, t0.user_group AS user_group_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.created_by_name AS created_by_name_11, t0.is_active AS is_active_12 FROM users t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 1.39 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.material AS material_2, w0_.dimension AS dimension_3, w0_.quantity AS quantity_4, w0_.cut_length AS cut_length_5, w0_.warning_level AS warning_level_6, w0_.price AS price_7, w0_.position AS position_8, w0_.supplier AS supplier_9, w0_.product_code AS product_code_10, w0_.image_file_name AS image_file_name_11, w0_.created_at AS created_at_12, w0_.updated_at AS updated_at_13, w0_.item_type AS item_type_14, w0_.is_active AS is_active_15, w0_.unit_id AS unit_id_16, w0_.warehouse_id AS warehouse_id_17, w0_.category_id AS category_id_18, w0_.subcategory_id AS subcategory_id_19 FROM warehouse_items w0_ WHERE (w0_.name LIKE ? OR w0_.material LIKE ? OR w0_.dimension LIKE ?) AND w0_.warehouse_id = ? ORDER BY w0_.name ASC LIMIT 100
Parameters:
[
  "%Lower%"
  "%Lower%"
  "%Lower%"
  3
]
3 0.53 ms
SELECT COUNT(w0_.id) AS sclr_0 FROM warehouse_items w0_ WHERE (w0_.name LIKE ? OR w0_.material LIKE ? OR w0_.dimension LIKE ?) AND w0_.is_active = ? AND w0_.warehouse_id = ?
Parameters:
[
  "%Lower%"
  "%Lower%"
  "%Lower%"
  1
  3
]
4 0.14 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2776
]
5 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.is_cut AS is_cut_4, t0.is_active AS is_active_5 FROM warehouse_units t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.08 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2775
]
7 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2777
]
8 0.07 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.file_name AS file_name_3, t0.item_id AS item_id_4, t0.field_id AS field_id_5 FROM warehouse_item_value t0 WHERE t0.item_id = ?
Parameters:
[
  2774
]

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\WarehouseItem 4
App\Entity\User 1
App\Entity\WarehouseUnit 1
App\Entity\Warehouse 1
App\Entity\WarehouseCategory 1