GET https://xdracon.ru/categories

Query Metrics

7 Database Queries
7 Different statements
3.45 ms Query time
7 Invalid entities
14 Managed entities

Queries

Group similar statements

# Time Info
1 0.51 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"
]
3 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5 FROM category_hero t0 LIMIT 1
Parameters:
[]
4 1.22 ms
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.image_name AS image_name_2, c0_.updated_at AS updated_at_3, s1_.id AS id_4, s1_.title AS title_5, s1_.updated_at AS updated_at_6, p2_.id AS id_7, p2_.title AS title_8, p2_.short_description AS short_description_9, p2_.image_name AS image_name_10, p2_.scheme_title AS scheme_title_11, p2_.image_name_scheme AS image_name_scheme_12, p2_.position AS position_13, p2_.slug AS slug_14, p2_.description AS description_15, p2_.dots AS dots_16, p2_.color_scheme_text AS color_scheme_text_17, p2_.image_name_meta AS image_name_meta_18, p2_.updated_at AS updated_at_19, s1_.category_id AS category_id_20, p2_.sub_category_id AS sub_category_id_21, p2_.workpiece_id AS workpiece_id_22, p2_.product_type_id AS product_type_id_23 FROM category c0_ LEFT JOIN sub_category s1_ ON c0_.id = s1_.category_id LEFT JOIN product p2_ ON s1_.id = p2_.sub_category_id ORDER BY c0_.title ASC, s1_.title ASC, p2_.title ASC
Parameters:
[]
5 0.42 ms
SELECT t0.id AS id_1, t0.title AS title_2 FROM product_workpiece t0
Parameters:
[]
6 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2 FROM product_type t0
Parameters:
[]
7 0.46 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\Category 3
App\Main\Entity\Catalog\SubCategory 3
App\Main\Entity\Catalog\ProductWorkpiece 2
App\Main\Entity\Catalog\ProductType 2
App\Seo\Entity\SeoSettings 1
App\Main\Entity\Catalog\CategoryHero 1
App\Main\Entity\Catalog\Product 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\CategoryHero No errors.
App\Main\Entity\Catalog\Category
  • The field App\Main\Entity\Catalog\Category#subCategories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Main\Entity\Catalog\SubCategory#category does not contain the required 'inversedBy="subCategories"' attribute.
App\Main\Entity\Catalog\SubCategory 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\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\Settings No errors.