Query Metrics
229
Database Queries
30
Different statements
112.42 ms
Query time
0
Invalid entities
174
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
41.04 ms (36.50%) |
6 |
SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translations p0_ WHERE p0_.foreign_key = ? AND p0_.locale = ? AND p0_.object_class = ?
Parameters:
[ "8380" "en" "App\Entity\Product\Object\BaseProduct" ] |
|
20.37 ms (18.11%) |
115 |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "405" "en" "App\Entity\Product\Category" ] |
|
12.23 ms (10.88%) |
1 |
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM cart t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
"cart_69d7869159f4e7.13810014"
]
|
|
12.02 ms (10.69%) |
6 |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_value_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "810" "en" "App\Entity\Product\Attribute\AttributeValue" ] |
|
5.31 ms (4.72%) |
1 |
"COMMIT"
Parameters:
[] |
|
5.07 ms (4.51%) |
28 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
1
]
|
|
3.25 ms (2.89%) |
17 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
4
]
|
|
3.06 ms (2.72%) |
10 |
SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = ? AND a0_.locale = ? AND a0_.object_class = ?
Parameters:
[ "66" "en" "App\Entity\Product\Attribute\Attribute" ] |
|
1.60 ms (1.43%) |
10 |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.name AS name_3, t0.comments AS comments_4, t0.has_quantity AS has_quantity_5, t0.sort_index AS sort_index_6, t0.filter AS filter_7, t0.filter_type AS filter_type_8, t0.published AS published_9, t0.attribute_type AS attribute_type_10, t0.attribute_group_id AS attribute_group_id_11 FROM attribute t0 WHERE t0.id = ?
Parameters:
[
66
]
|
|
1.56 ms (1.39%) |
5 |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.summary AS summary_6, t0.description AS description_7, t0.status AS status_8, t0.keywords AS keywords_9, t0.general_comments AS general_comments_10, t0.published AS published_11, t0.featured AS featured_12, t0.sku AS sku_13, t0.mfr_code AS mfr_code_14, t0.blk_code AS blk_code_15, t0.ean_code AS ean_code_16, t0.supplier_code AS supplier_code_17, t0.volumetric_weight AS volumetric_weight_18, t0.views AS views_19, t0.sales AS sales_20, t0.created_at AS created_at_21, t0.supplier_url AS supplier_url_22, t0.in_the_box_text AS in_the_box_text_23, t0.online_discount_percentage AS online_discount_percentage_24, t0.availability AS availability_25, t0.available_at AS available_at_26, t0.offer AS offer_27, t0.cash_back AS cash_back_28, t0.ask_for_price AS ask_for_price_29, t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_30, t0.warehouse_stock_quantity AS warehouse_stock_quantity_31, t0.warehouse_stock_reserved AS warehouse_stock_reserved_32, t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_33, t0.warehouse_stock_immutable AS warehouse_stock_immutable_34, t0.price_gross_amount AS price_gross_amount_35, t0.price_gross_currency AS price_gross_currency_36, t0.price_with_discount_amount AS price_with_discount_amount_37, t0.price_with_discount_currency AS price_with_discount_currency_38, t0.type_id AS type_id_39, t0.main_image_id AS main_image_id_40, t0.manufacturer_id AS manufacturer_id_41, t0.variant_group_id AS variant_group_id_42, t0.discr, t0.price_url AS price_url_43, t0.price_comments AS price_comments_44, t0.supplier_discount AS supplier_discount_45, t0.special_discount AS special_discount_46, t0.customs_charges_percentage AS customs_charges_percentage_47, t0.markup_percentage AS markup_percentage_48, t0.product_dimensions AS product_dimensions_49, t0.net_weight AS net_weight_50, t0.warranty AS warranty_51, t0.accessories AS accessories_52, t0.original_price_amount AS original_price_amount_53, t0.original_price_currency AS original_price_currency_54, t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_55, t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_56, t0.package_length_mm AS package_length_mm_57, t0.package_width_mm AS package_width_mm_58, t0.package_height_mm AS package_height_mm_59, t0.package_details AS package_details_60, t0.package_dimension_unit AS package_dimension_unit_61, t0.package_grams AS package_grams_62, t0.package_weight_details AS package_weight_details_63, t0.package_weight_unit AS package_weight_unit_64, t0.kit_discount_percentage AS kit_discount_percentage_65 FROM products t0 WHERE t0.id = ? AND t0.discr IN ('product', 'product_kit')
Parameters:
[
5087
]
|
|
0.79 ms (0.70%) |
6 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.sort_index AS sort_index_3, t0.extra_info AS extra_info_4, t0.attribute_id AS attribute_id_5 FROM attribute_value t0 WHERE t0.id = ?
Parameters:
[
810
]
|
|
0.77 ms (0.69%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"USD"
]
|
|
0.73 ms (0.65%) |
1 |
SELECT p0_.id AS id_0, p0_.migration_id AS migration_id_1, p0_.softone_id AS softone_id_2, p0_.name AS name_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.published AS published_9, p0_.sort_index AS sort_index_10 FROM product_category p0_ WHERE p0_.rgt < 932 AND p0_.lft > 1 AND p0_.tree_root = ? ORDER BY p0_.tree_root ASC, p0_.lft ASC
Parameters:
[
1
]
|
|
0.51 ms (0.45%) |
3 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.sort_index AS sort_index_4, t0.published AS published_5 FROM attribute_group t0 WHERE t0.id = ?
Parameters:
[
5
]
|
|
0.43 ms (0.38%) |
1 |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.summary AS summary_6, t0.description AS description_7, t0.status AS status_8, t0.keywords AS keywords_9, t0.general_comments AS general_comments_10, t0.published AS published_11, t0.featured AS featured_12, t0.sku AS sku_13, t0.mfr_code AS mfr_code_14, t0.blk_code AS blk_code_15, t0.ean_code AS ean_code_16, t0.supplier_code AS supplier_code_17, t0.volumetric_weight AS volumetric_weight_18, t0.views AS views_19, t0.sales AS sales_20, t0.created_at AS created_at_21, t0.supplier_url AS supplier_url_22, t0.in_the_box_text AS in_the_box_text_23, t0.online_discount_percentage AS online_discount_percentage_24, t0.availability AS availability_25, t0.available_at AS available_at_26, t0.offer AS offer_27, t0.cash_back AS cash_back_28, t0.ask_for_price AS ask_for_price_29, t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_30, t0.warehouse_stock_quantity AS warehouse_stock_quantity_31, t0.warehouse_stock_reserved AS warehouse_stock_reserved_32, t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_33, t0.warehouse_stock_immutable AS warehouse_stock_immutable_34, t0.price_gross_amount AS price_gross_amount_35, t0.price_gross_currency AS price_gross_currency_36, t0.price_with_discount_amount AS price_with_discount_amount_37, t0.price_with_discount_currency AS price_with_discount_currency_38, t0.type_id AS type_id_39, t0.main_image_id AS main_image_id_40, t0.manufacturer_id AS manufacturer_id_41, t0.variant_group_id AS variant_group_id_42, t0.discr, t0.price_url AS price_url_43, t0.price_comments AS price_comments_44, t0.supplier_discount AS supplier_discount_45, t0.special_discount AS special_discount_46, t0.customs_charges_percentage AS customs_charges_percentage_47, t0.markup_percentage AS markup_percentage_48, t0.product_dimensions AS product_dimensions_49, t0.net_weight AS net_weight_50, t0.warranty AS warranty_51, t0.accessories AS accessories_52, t0.original_price_amount AS original_price_amount_53, t0.original_price_currency AS original_price_currency_54, t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_55, t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_56, t0.package_length_mm AS package_length_mm_57, t0.package_width_mm AS package_width_mm_58, t0.package_height_mm AS package_height_mm_59, t0.package_details AS package_details_60, t0.package_dimension_unit AS package_dimension_unit_61, t0.package_grams AS package_grams_62, t0.package_weight_details AS package_weight_details_63, t0.package_weight_unit AS package_weight_unit_64, t0.kit_discount_percentage AS kit_discount_percentage_65 FROM products t0 WHERE t0.slug = ? AND t0.discr IN ('product', 'product_kit') LIMIT 1
Parameters:
[
"XVE126"
]
|
|
0.39 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.lvl = ? AND t0.website = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[ 0 "blk.gr" ] |
|
0.36 ms (0.32%) |
1 |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.url AS url_6, t0.email AS email_7, t0.published AS published_8, t0.official_dealer AS official_dealer_9, t0.european_support AS european_support_10, t0.discount_percent AS discount_percent_11, t0.extra_discount AS extra_discount_12, t0.logo_id AS logo_id_13 FROM product_manufacturer t0 WHERE t0.id = ?
Parameters:
[
110
]
|
|
0.33 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.discr FROM app_file t0 INNER JOIN product_images ON t0.id = product_images.image_id WHERE product_images.product_id = ? AND t0.discr IN ('product_image')
Parameters:
[
8380
]
|
|
0.33 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.discr FROM app_file t0 WHERE t0.id = ? AND t0.discr IN ('product_image')
Parameters:
[
44741
]
|
|
0.32 ms (0.28%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"power_suppliers"
]
|
|
0.31 ms (0.27%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.lvl = ?
Parameters:
[
1
]
|
|
0.23 ms (0.20%) |
1 |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.wishlist AS wishlist_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.price_amount AS price_amount_6, t0.price_currency AS price_currency_7, t0.cart_id AS cart_id_8, t0.product_id AS product_id_9 FROM cart_item t0 WHERE t0.cart_id = ?
Parameters:
[
b"\x1F\x13@2ç\x04k(—Œ…PTÿk%"
]
|
|
0.21 ms (0.19%) |
1 |
UPDATE products SET views = ? WHERE id = ?
Parameters:
[ 1 8380 ] |
|
0.20 ms (0.18%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.file_id AS file_id_5 FROM product_reference t0 INNER JOIN products_references ON t0.id = products_references.reference_id WHERE products_references.product_id = ?
Parameters:
[
8380
]
|
|
0.19 ms (0.17%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.id = ?
Parameters:
[
33
]
|
|
0.19 ms (0.17%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.lvl = ? AND t0.website = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[ 0 "blk.gr" ] |
|
0.18 ms (0.16%) |
1 |
SELECT t0.id AS id_1, t0.text_value AS text_value_2, t0.extra_info AS extra_info_3, t0.quantity AS quantity_4, t0.product_id AS product_id_5, t0.attribute_id AS attribute_id_6, t0.attribute_value_id AS attribute_value_id_7 FROM product_attribute_value t0 WHERE t0.product_id = ?
Parameters:
[
8380
]
|
|
0.16 ms (0.15%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4 FROM product_type t0 WHERE t0.id = ?
Parameters:
[
92
]
|
|
0.16 ms (0.14%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.tree_root = ? LIMIT 1
Parameters:
[
true
]
|
|
0.13 ms (0.11%) |
1 |
"START TRANSACTION"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| blk | doctrine.dbal.blk_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\Entity\Product\Category | 85 |
| App\Entity\Menu | 28 |
| App\Entity\Product\Object\ProductAttributeValue | 10 |
| App\Entity\Product\Attribute\Attribute | 10 |
| App\Entity\Common\Files\AppFile | 7 |
| App\Entity\Product\Object\BaseProduct | 6 |
| App\Entity\Product\Attribute\AttributeValue | 6 |
| App\Entity\Product\ProductManufacturer | 5 |
| App\Entity\Cart\CartItem | 5 |
| App\Entity\Product\ProductType | 4 |
| App\Entity\Product\Attribute\AttributeGroup | 3 |
| App\Entity\Product\Object\ProductVariantGroup | 2 |
| App\Entity\Common\Currency | 2 |
| App\Entity\Cart\Cart | 1 |