GET https://xdracon.ru/

Query Metrics

10 Database Queries
10 Different statements
2.68 ms Query time
7 Invalid entities
15 Managed entities

Queries

Group similar statements

# Time Info
1 0.44 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.26 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:
[
  "/"
]
3 0.23 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 hero t0 LIMIT 1
Parameters:
[]
4 0.20 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 FROM category c0_ ORDER BY c0_.id ASC LIMIT 3
Parameters:
[]
5 0.31 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.short_description AS short_description_2, p0_.image_name AS image_name_3, p0_.scheme_title AS scheme_title_4, p0_.image_name_scheme AS image_name_scheme_5, p0_.position AS position_6, p0_.slug AS slug_7, p0_.description AS description_8, p0_.dots AS dots_9, p0_.color_scheme_text AS color_scheme_text_10, p0_.image_name_meta AS image_name_meta_11, p0_.updated_at AS updated_at_12, p0_.sub_category_id AS sub_category_id_13, p0_.workpiece_id AS workpiece_id_14, p0_.product_type_id AS product_type_id_15 FROM product p0_ ORDER BY p0_.id ASC
Parameters:
[]
6 0.27 ms
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.image_name AS image_name_3, c0_.position AS position_4, c0_.updated_at AS updated_at_5 FROM complex c0_ ORDER BY c0_.id ASC
Parameters:
[]
7 0.24 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.position AS position_4 FROM info_block t0 ORDER BY t0.position ASC LIMIT 1
Parameters:
[]
8 0.20 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.image_name AS image_name_3, p0_.position AS position_4, p0_.updated_at AS updated_at_5, p0_.possibility_main_id AS possibility_main_id_6 FROM possibility p0_ ORDER BY p0_.id ASC
Parameters:
[]
9 0.24 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM possibility_main t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
10 0.27 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\Complex 3
App\Main\Entity\Possibility 2
App\Seo\Entity\SeoSettings 1
App\Main\Entity\Common\Hero 1
App\Main\Entity\Catalog\Product 1
App\Main\Entity\Catalog\SubCategory 1
App\Main\Entity\InfoBlock 1
App\Main\Entity\PossibilityMain 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\Common\Hero 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\Complex No errors.
App\Main\Entity\InfoBlock No errors.
App\Main\Entity\Possibility No errors.
App\Main\Entity\PossibilityMain No errors.
App\Main\Entity\Settings No errors.