https://vlad-mehanik.ru/product/search_items?from_crm=1&query=1780150060

Query Metrics

4 Database Queries
4 Different statements
116.16 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 113.58 ms
SELECT p0_.article_search AS article_search_0, p0_.article_original AS article_original_1, p0_.description AS description_2, p0_.id AS id_3, p0_.brand_id AS brand_id_4 FROM products__products p0_ INNER JOIN brands__brands b1_ ON p0_.brand_id = b1_.id WHERE p0_.article_search LIKE '%1780150060%' LIMIT 100
Parameters:
[]
2 1.61 ms
SELECT t0.place AS place_1, t0.id AS id_2, t0.product_id AS product_id_3 FROM storages__storages t0 WHERE t0.product_id = ?
Parameters:
[
  104163
]
3 0.30 ms
SELECT t0.stock AS stock_1, t0.price AS price_2, t0.show_in_search AS show_in_search_3, t0.id AS id_4, t0.updated AS updated_5, t0.product_id AS product_id_6, t0.warehouse_id AS warehouse_id_7 FROM products__items t0 WHERE t0.product_id = ?
Parameters:
[
  104163
]
4 0.68 ms
SELECT count(p0_.id) AS sclr_0 FROM products__products p0_ WHERE p0_.article_search = '1780150060'
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\User
  • The field App\Entity\User#roles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserRole#user does not contain the required 'inversedBy="roles"' attribute.
  • The field App\Entity\User#manager is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Manager#user does not contain the required 'inversedBy="manager"' attribute.
App\Entity\Product
  • The field App\Entity\Product#supplierItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SupplierItem#product does not contain the required 'inversedBy="supplierItems"' attribute.
  • The field App\Entity\Product#images is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProductImage#product does not contain the required 'inversedBy="images"' attribute.
  • The field App\Entity\Product#storage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Storage#product does not contain the required 'inversedBy="storage"' attribute.
App\Entity\Brand
  • The field App\Entity\Brand#aliases is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\BrandAlias#brand does not contain the required 'inversedBy="aliases"' attribute.
App\Entity\Item No errors.
App\Entity\SupplierItem
  • The field App\Entity\SupplierItem#supplierWarehouseItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SupplierWarehouseItem#item does not contain the required 'inversedBy="supplierWarehouseItems"' attribute.
App\Entity\ProductImage No errors.
App\Entity\Analog No errors.
App\Entity\Storage No errors.
App\Entity\Warehouse No errors.