http://backend.soft99.ru/api/get/news?cards=true&id=avtokhimiya_g%27zox

Query Metrics

38 Database Queries
8 Different statements
37.38 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
12.26 ms
(32.81%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.public AS public_3 FROM news_tag t0 INNER JOIN news_news_tag ON t0.id = news_news_tag.news_tag_id WHERE news_news_tag.news_id = ?
Parameters:
[
  33
]
6.60 ms
(17.65%)
1
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 news_product ON t0.id = news_product.product_id WHERE news_product.news_id = ?
Parameters:
[
  33
]
5.18 ms
(13.86%)
11
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:
[
  86
]
4.91 ms
(13.12%)
11
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:
[
  86
]
4.55 ms
(12.16%)
11
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:
[
  938
]
2.77 ms
(7.40%)
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_ WHERE (n0_.id LIKE ? OR n0_.link LIKE ?) AND n0_.public = 1
Parameters:
[
  "avtokhimiya_g'zox"
  "avtokhimiya_g'zox"
]
0.65 ms
(1.74%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.public AS public_4, t0.preview AS preview_5 FROM news_category t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.47 ms
(1.27%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.filename AS filename_3, t0.news_id AS news_id_4 FROM news_static t0 WHERE t0.news_id = ?
Parameters:
[
  33
]

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