Query Metrics
15
Database Queries
12
Different statements
5.28 ms
Query time
7
Invalid entities
35
Managed entities
Queries
#▲ | 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 |
|
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 |
|
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\Catalog\DiameterValue |
|
App\Main\Entity\Settings | No errors. |