http://backend.soft99.ru/api/get/product?id=nano_hard_clear

Query Metrics

18 Database Queries
9 Different statements
9.96 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.03 ms
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_ INNER JOIN product_article p1_ ON p0_.id = p1_.product_id AND (p1_.product_id = p0_.id) WHERE (p0_.id LIKE ? OR p1_.link LIKE ?) AND p0_.public = 1
Parameters:
[
  "nano_hard_clear"
  "nano_hard_clear"
]
2 0.69 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.code AS code_4, t0.description AS description_5, t0.value AS value_6, t0.product_id AS product_id_7 FROM product_article t0 WHERE t0.product_id = ?
Parameters:
[
  62
]
3 0.46 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.public AS public_3, t0.product_category_id AS product_category_id_4 FROM product_category t0 INNER JOIN product_product_category ON t0.id = product_product_category.product_category_id WHERE product_product_category.product_id = ?
Parameters:
[
  62
]
4 0.52 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.preview AS preview_3, t0.description AS description_4, t0.note AS note_5, t0.detail_time AS detail_time_6, t0.public AS public_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.link AS link_10, t0.title_detail AS title_detail_11, t0.category_id AS category_id_12, t0.video_id AS video_id_13 FROM news t0 INNER JOIN news_product ON t0.id = news_product.news_id WHERE news_product.product_id = ?
Parameters:
[
  62
]
5 0.51 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.public AS public_4, t0.sort AS sort_5 FROM video t0 INNER JOIN product_video ON t0.id = product_video.video_id WHERE product_video.product_id = ?
Parameters:
[
  62
]
6 0.55 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_detail AS title_detail_3, t0.sort AS sort_4, t0.public AS public_5, t0.description AS description_6, t0.features AS features_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.duration AS duration_10, t0.is_popular AS is_popular_11, t0.label AS label_12, t0.label_type AS label_type_13, t0.static AS static_14, t0.product_type_id AS product_type_id_15 FROM product t0 INNER JOIN product_video ON t0.id = product_video.product_id WHERE product_video.video_id = ?
Parameters:
[
  6
]
7 0.65 ms
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) INNER JOIN news_product n3_ ON n0_.id = n3_.news_id INNER JOIN product p2_ ON p2_.id = n3_.product_id AND (p2_.id = ?) WHERE n1_.id = 2
Parameters:
[
  62
]
8 0.42 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.public AS public_3 FROM product_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.45 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.public AS public_3, t0.product_category_id AS product_category_id_4 FROM product_category t0 INNER JOIN product_product_category ON t0.id = product_product_category.product_category_id WHERE product_product_category.product_id = ?
Parameters:
[
  25
]
10 0.40 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.code AS code_4, t0.description AS description_5, t0.value AS value_6, t0.product_id AS product_id_7 FROM product_article t0 WHERE t0.product_id = ?
Parameters:
[
  25
]
11 0.43 ms
SELECT t0.id AS id_1, t0.color_id AS color_id_2, t0.product_article_id AS product_article_id_3 FROM product_color t0 WHERE t0.product_article_id = ?
Parameters:
[
  39
]
12 0.44 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.public AS public_3, t0.product_category_id AS product_category_id_4 FROM product_category t0 INNER JOIN product_product_category ON t0.id = product_product_category.product_category_id WHERE product_product_category.product_id = ?
Parameters:
[
  34
]
13 0.39 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.code AS code_4, t0.description AS description_5, t0.value AS value_6, t0.product_id AS product_id_7 FROM product_article t0 WHERE t0.product_id = ?
Parameters:
[
  34
]
14 0.35 ms
SELECT t0.id AS id_1, t0.color_id AS color_id_2, t0.product_article_id AS product_article_id_3 FROM product_color t0 WHERE t0.product_article_id = ?
Parameters:
[
  50
]
15 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.public AS public_3, t0.product_category_id AS product_category_id_4 FROM product_category t0 INNER JOIN product_product_category ON t0.id = product_product_category.product_category_id WHERE product_product_category.product_id = ?
Parameters:
[
  61
]
16 0.40 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.code AS code_4, t0.description AS description_5, t0.value AS value_6, t0.product_id AS product_id_7 FROM product_article t0 WHERE t0.product_id = ?
Parameters:
[
  61
]
17 0.36 ms
SELECT t0.id AS id_1, t0.color_id AS color_id_2, t0.product_article_id AS product_article_id_3 FROM product_color t0 WHERE t0.product_article_id = ?
Parameters:
[
  82
]
18 0.47 ms
SELECT t0.id AS id_1, t0.color_id AS color_id_2, t0.product_article_id AS product_article_id_3 FROM product_color t0 WHERE t0.product_article_id = ?
Parameters:
[
  83
]

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\Video No errors.
App\Entity\CombineProduct No errors.
App\Entity\ProductColor No errors.
App\Entity\ProductCategoryType No errors.
App\Entity\NewsCategory No errors.
App\Entity\NewsTag No errors.
App\Entity\Color No errors.