GET https://xdracon.ru/categories/cvetnaa-aluminievaa-tverdosplavnaa-centrovocnaa-sverla-tverdost-u-hrc55-3

Query Metrics

15 Database Queries
12 Different statements
5.28 ms Query time
7 Invalid entities
35 Managed entities

Queries

Group similar statements

# Time Info
1 0.50 ms
SELECT t0.id AS id_1, t0.robots AS robots_2, t0.meta_suffix AS meta_suffix_3, t0.meta_suffix_separator AS meta_suffix_separator_4 FROM seo_settings t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
2 0.29 ms
SELECT t0.url AS url_1, t0.id AS id_2, t0.title AS title_3, t0.keywords AS keywords_4, t0.description AS description_5 FROM url_seo t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "/categories/cvetnaa-aluminievaa-tverdosplavnaa-centrovocnaa-sverla-tverdost-u-hrc55-3"
]
3 0.47 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.image_name AS image_name_4, t0.scheme_title AS scheme_title_5, t0.image_name_scheme AS image_name_scheme_6, t0.position AS position_7, t0.slug AS slug_8, t0.description AS description_9, t0.dots AS dots_10, t0.color_scheme_text AS color_scheme_text_11, t0.image_name_meta AS image_name_meta_12, t0.updated_at AS updated_at_13, t0.sub_category_id AS sub_category_id_14, t0.workpiece_id AS workpiece_id_15, t0.product_type_id AS product_type_id_16 FROM product t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "cvetnaa-aluminievaa-tverdosplavnaa-centrovocnaa-sverla-tverdost-u-hrc55-3"
]
4 0.60 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.image_name AS image_name_4, t0.scheme_title AS scheme_title_5, t0.image_name_scheme AS image_name_scheme_6, t0.position AS position_7, t0.slug AS slug_8, t0.description AS description_9, t0.dots AS dots_10, t0.color_scheme_text AS color_scheme_text_11, t0.image_name_meta AS image_name_meta_12, t0.updated_at AS updated_at_13, t0.sub_category_id AS sub_category_id_14, t0.workpiece_id AS workpiece_id_15, t0.product_type_id AS product_type_id_16 FROM product t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "cvetnaa-aluminievaa-tverdosplavnaa-centrovocnaa-sverla-tverdost-u-hrc55-3"
]
5 0.49 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_type AS file_type_3, t0.file_id AS file_id_4, t0.position AS position_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_file t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
6 0.26 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.name AS name_3, t0.position AS position_4, t0.updated_at AS updated_at_5, t0.product_id AS product_id_6 FROM characteristic t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
7 0.27 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_type AS file_type_3, t0.file_id AS file_id_4, t0.position AS position_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM shape_slice t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
8 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5 FROM schema_value t0 WHERE t0.product_id = ? LIMIT 8
Parameters:
[
  6
]
9 0.25 ms
SELECT t0.id AS id_1, t0.item_title AS item_title_2, t0.item_subtitle AS item_subtitle_3, t0.product_id AS product_id_4 FROM product_item_header t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
10 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.order_code AS order_code_4, t0.updated_at AS updated_at_5, t0.product_id AS product_id_6 FROM product_item t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
11 0.34 ms
SELECT t0.id AS id_1, t0.iso AS iso_2, t0.material AS material_3, t0.depth AS depth_4, t0.revolutions AS revolutions_5, t0.position AS position_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8 FROM meta_product_item t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
12 0.30 ms
SELECT t0.id AS id_1, t0.diameter AS diameter_2, t0.rpm AS rpm_3, t0.feed AS feed_4, t0.updated_at AS updated_at_5, t0.meta_product_item_id AS meta_product_item_id_6 FROM diameter_value t0 WHERE t0.meta_product_item_id = ?
Parameters:
[
  1
]
13 0.27 ms
SELECT t0.id AS id_1, t0.diameter AS diameter_2, t0.rpm AS rpm_3, t0.feed AS feed_4, t0.updated_at AS updated_at_5, t0.meta_product_item_id AS meta_product_item_id_6 FROM diameter_value t0 WHERE t0.meta_product_item_id = ?
Parameters:
[
  2
]
14 0.26 ms
SELECT t0.id AS id_1, t0.diameter AS diameter_2, t0.rpm AS rpm_3, t0.feed AS feed_4, t0.updated_at AS updated_at_5, t0.meta_product_item_id AS meta_product_item_id_6 FROM diameter_value t0 WHERE t0.meta_product_item_id = ?
Parameters:
[
  3
]
15 0.36 ms
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.inn AS inn_4, t0.kpp AS kpp_5, t0.rc AS rc_6, t0.vk AS vk_7, t0.yt AS yt_8, t0.address AS address_9, t0.address_lat AS address_lat_10, t0.address_lng AS address_lng_11, t0.updated_at AS updated_at_12, t0.policy AS policy_13, t0.counters_body AS counters_body_14, t0.counters_head AS counters_head_15 FROM settings t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Main\Entity\Catalog\SchemaValue 8
App\Main\Entity\Catalog\DiameterValue 6
App\Main\Entity\Catalog\ProductFile 4
App\Main\Entity\Catalog\Characteristic 4
App\Main\Entity\Catalog\ShapeSlice 4
App\Main\Entity\Catalog\MetaProductItem 3
App\Seo\Entity\SeoSettings 1
App\Main\Entity\Catalog\Product 1
App\Main\Entity\Catalog\SubCategory 1
App\Main\Entity\Catalog\ProductItemHeader 1
App\Main\Entity\Catalog\ProductItem 1
App\Main\Entity\Settings 1

Entities Mapping

Class Mapping errors
App\Seo\Entity\SeoSettings No errors.
App\Seo\Entity\UrlSeo No errors.
App\Main\Entity\Catalog\Product
  • The mappings App\Main\Entity\Catalog\Product#characteristics and App\Main\Entity\Catalog\Characteristic#product are inconsistent with each other.
  • The mappings App\Main\Entity\Catalog\Product#schemeValues and App\Main\Entity\Catalog\SchemaValue#product are inconsistent with each other.
  • The mappings App\Main\Entity\Catalog\Product#headers and App\Main\Entity\Catalog\ProductItemHeader#product are inconsistent with each other.
  • The mappings App\Main\Entity\Catalog\Product#items and App\Main\Entity\Catalog\ProductItem#product are inconsistent with each other.
  • The mappings App\Main\Entity\Catalog\Product#metaItems and App\Main\Entity\Catalog\MetaProductItem#product are inconsistent with each other.
App\Main\Entity\Catalog\SubCategory No errors.
App\Main\Entity\Catalog\ProductWorkpiece No errors.
App\Main\Entity\Catalog\ProductType No errors.
App\Main\Entity\Catalog\ProductFile No errors.
App\Main\Entity\Catalog\Characteristic
  • The association App\Main\Entity\Catalog\Characteristic#product refers to the inverse side field App\Main\Entity\Catalog\Product#characteristic which does not exist.
App\Main\Entity\Catalog\SchemaValue
  • The association App\Main\Entity\Catalog\SchemaValue#product refers to the inverse side field App\Main\Entity\Catalog\Product#schemeValue which does not exist.
App\Main\Entity\Catalog\ShapeSlice No errors.
App\Main\Entity\Catalog\ProductItemHeader
  • The association App\Main\Entity\Catalog\ProductItemHeader#product refers to the inverse side field App\Main\Entity\Catalog\Product#productItemHeader which does not exist.
App\Main\Entity\Catalog\ProductItem
  • The association App\Main\Entity\Catalog\ProductItem#product refers to the inverse side field App\Main\Entity\Catalog\Product#productItem which does not exist.
App\Main\Entity\Catalog\MetaProductItem
  • The association App\Main\Entity\Catalog\MetaProductItem#product refers to the inverse side field App\Main\Entity\Catalog\Product#metaProductItem which does not exist.
App\Main\Entity\Catalog\DiameterValue
  • The field 'App\Main\Entity\Catalog\DiameterValue#diameter' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
  • The field 'App\Main\Entity\Catalog\DiameterValue#rpm' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
  • The field 'App\Main\Entity\Catalog\DiameterValue#feed' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Main\Entity\Settings No errors.