http://backend.soft99.ru/api/get/search?text=8x7

Query Metrics

2 Database Queries
2 Different statements
15.61 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
14.32 ms
(91.77%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_detail AS title_detail_2, p0_.sort AS sort_3, p0_.public AS public_4, p0_.description AS description_5, p0_.features AS features_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.duration AS duration_9, p0_.is_popular AS is_popular_10, p0_.label AS label_11, p0_.label_type AS label_type_12, p0_.static AS static_13, p0_.product_type_id AS product_type_id_14 FROM product p0_ LEFT JOIN product_type p1_ ON (p1_.id = p0_.product_type_id) LEFT JOIN product_article p2_ ON p0_.id = p2_.product_id AND (p2_.product_id = p0_.id) LEFT JOIN product_color p3_ ON p2_.id = p3_.product_article_id AND (p3_.product_article_id = p2_.id) LEFT JOIN color c4_ ON p3_.color_id = c4_.id AND (p3_.color_id = c4_.id) WHERE p0_.public = 1 AND (p0_.title LIKE ? OR p0_.title_detail LIKE ? OR p0_.description LIKE ? OR p0_.features LIKE ? OR p0_.duration LIKE ? OR p0_.label LIKE ? OR p2_.code LIKE ? OR p2_.description LIKE ? OR p2_.title LIKE ? OR c4_.title LIKE ? OR c4_.code LIKE ?) ORDER BY p0_.id DESC LIMIT 1000
Parameters:
[
  "%8x7%"
  "%8x7%"
  "%8x7%"
  "%8x7%"
  "%8x7%"
  "%8x7%"
  "%8x7%"
  "%8x7%"
  "%8x7%"
  "%8x7%"
  "%8x7%"
]
1.28 ms
(8.23%)
1
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.preview AS preview_2, n0_.description AS description_3, n0_.note AS note_4, n0_.detail_time AS detail_time_5, n0_.public AS public_6, n0_.created_at AS created_at_7, n0_.updated_at AS updated_at_8, n0_.link AS link_9, n0_.title_detail AS title_detail_10, n0_.category_id AS category_id_11, n0_.video_id AS video_id_12 FROM news n0_ LEFT JOIN news_category n1_ ON (n1_.id = n0_.category_id) LEFT JOIN video v2_ ON (v2_.id = n0_.video_id) WHERE n0_.public = 1 AND (n0_.title LIKE ? OR n0_.title_detail LIKE ? OR n0_.detail_time LIKE ? OR n0_.description LIKE ?) ORDER BY n0_.id DESC LIMIT 1000
Parameters:
[
  "%8x7%"
  "%8x7%"
  "%8x7%"
  "%8x7%"
]

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\Product No errors.
App\Entity\ProductArticle No errors.
App\Entity\ProductType No errors.
App\Entity\ProductCategory No errors.
App\Entity\NewsStatic No errors.
App\Entity\News No errors.
App\Entity\NewsCategory No errors.
App\Entity\Video No errors.
App\Entity\ProductColor No errors.
App\Entity\Color No errors.