Query Metrics
7
Database Queries
7
Different statements
3.45 ms
Query time
7
Invalid entities
14
Managed entities
Queries
#▲ | 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 |
|
App\Main\Entity\Catalog\SubCategory | No errors. |
App\Main\Entity\Catalog\Product |
|
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 |
|
App\Main\Entity\Catalog\SchemaValue |
|
App\Main\Entity\Catalog\ShapeSlice | No errors. |
App\Main\Entity\Catalog\ProductItemHeader |
|
App\Main\Entity\Catalog\ProductItem |
|
App\Main\Entity\Catalog\MetaProductItem |
|
App\Main\Entity\Settings | No errors. |