http://backend.doubleforce.ru/api/select/all/data?search=583022PA00

Query Metrics

4 Database Queries
4 Different statements
127.20 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
125.29 ms
(98.50%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.public AS public_2, p0_.product_id AS product_id_3, p0_.position_id AS position_id_4 FROM product_article p0_ LEFT JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_oem p2_ ON p0_.id = p2_.product_article_id WHERE p0_.title LIKE ? OR p2_.oem LIKE ? OR p2_.oem_trim LIKE ? ORDER BY p0_.title ASC
Parameters:
[
  "%583022PA00%"
  "%583022PA00%"
  "%583022PA00%"
]
0.72 ms
(0.56%)
1
SELECT t0.id AS id_1, t0.oem AS oem_2, t0.oem_trim AS oem_trim_3, t0.product_article_id AS product_article_id_4, t0.product_id AS product_id_5 FROM product_oem t0 WHERE t0.product_article_id = ?
Parameters:
[
  459
]
0.63 ms
(0.49%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.file AS file_3, t0.public AS public_4, t0.type_id AS type_id_5, t0.season_id AS season_id_6, t0.category_id AS category_id_7 FROM product t0 WHERE t0.id = ?
Parameters:
[
  15
]
0.56 ms
(0.44%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.public AS public_3 FROM category t0 WHERE t0.id = ?
Parameters:
[
  4
]

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\ProductOem No errors.
App\Entity\ProductArticle No errors.
App\Entity\Product No errors.
App\Entity\Position No errors.
App\Entity\SelectionWiper No errors.
App\Entity\Type No errors.
App\Entity\Season No errors.
App\Entity\Category No errors.
App\Entity\SelectionPart No errors.