Query Metrics
2
Database Queries
2
Different statements
15.61 ms
Query time
0
Invalid entities
Grouped Statements
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. |