Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

164.36 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	163.26 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 '%0828499904%' LIMIT 100 Parameters: [] View formatted query View runnable query Explain query 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 '%0828499904%' LIMIT 100 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 '%0828499904%' LIMIT 100;
2	1.11 ms	SELECT count(p0_.id) AS sclr_0 FROM products__products p0_ WHERE p0_.article_search = '0828499904' Parameters: [] View formatted query View runnable query Explain query SELECT count(p0_.id) AS sclr_0 FROM products__products p0_ WHERE p0_.article_search = '0828499904' SELECT count(p0_.id) AS sclr_0 FROM products__products p0_ WHERE p0_.article_search = '0828499904';

#▲

Time

Info

163.26 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 '%0828499904%' LIMIT 100

Parameters:

[]

View formatted query View runnable query Explain query

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 '%0828499904%'
LIMIT
  100

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 '%0828499904%' LIMIT 100;

1.11 ms

SELECT count(p0_.id) AS sclr_0 FROM products__products p0_ WHERE p0_.article_search = '0828499904'

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(p0_.id) AS sclr_0
FROM
  products__products p0_
WHERE
  p0_.article_search = '0828499904'

SELECT count(p0_.id) AS sclr_0 FROM products__products p0_ WHERE p0_.article_search = '0828499904';

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.

Symfony Profiler

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

Configuration Settings

Theme