Query Metrics
12
Database Queries
7
Different statements
28.01 ms
Query time
0
Invalid entities
62
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
11.80 ms (42.14%) |
5 |
SELECT t0.locale_code AS locale_code_1, t0.text_value AS text_value_2, t0.boolean_value AS boolean_value_3, t0.integer_value AS integer_value_4, t0.float_value AS float_value_5, t0.datetime_value AS datetime_value_6, t0.date_value AS date_value_7, t0.json_value AS json_value_8, t0.id AS id_9, t0.product_id AS product_id_10, t0.attribute_id AS attribute_id_11 FROM sylius_product_attribute_value t0 WHERE t0.product_id = ? ORDER BY t0.id ASC
Parameters:
[
8
]
|
|
5.23 ms (18.69%) |
1 |
SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.position AS position_3, s0_.enabled AS enabled_4, s0_.id AS id_5, s0_.version AS version_6, s0_.on_hold AS on_hold_7, s0_.on_hand AS on_hand_8, s0_.tracked AS tracked_9, s0_.width AS width_10, s0_.height AS height_11, s0_.depth AS depth_12, s0_.weight AS weight_13, s0_.shipping_required AS shipping_required_14, s0_.recurring AS recurring_15, s0_.recurring_times AS recurring_times_16, s0_.recurring_interval AS recurring_interval_17, s0_.sold_by_square_meter AS sold_by_square_meter_18, s0_.price_per_square_meter AS price_per_square_meter_19, s0_.min_width_cm AS min_width_cm_20, s0_.max_width_cm AS max_width_cm_21, s0_.min_height_cm AS min_height_cm_22, s0_.max_height_cm AS max_height_cm_23, s0_.min_square_meters AS min_square_meters_24, s0_.square_meter_step AS square_meter_step_25, s0_.dpi_required AS dpi_required_26, s0_.image_aspect_ratio AS image_aspect_ratio_27, s0_.has_fixed_sizes_only AS has_fixed_sizes_only_28, s0_.available_sizes_json AS available_sizes_json_29, s1_.name AS name_30, s1_.id AS id_31, s1_.locale AS locale_32, s2_.code AS code_33, s2_.created_at AS created_at_34, s2_.updated_at AS updated_at_35, s2_.enabled AS enabled_36, s2_.id AS id_37, s2_.variant_selection_method AS variant_selection_method_38, s2_.average_rating AS average_rating_39, s2_.original_image AS original_image_40, s2_.show_image_cropper AS show_image_cropper_41, s2_.sold_by_square_meter AS sold_by_square_meter_42, s2_.width AS width_43, s2_.height AS height_44, s2_.price_per_square_meter AS price_per_square_meter_45, s3_.name AS name_46, s3_.slug AS slug_47, s3_.description AS description_48, s3_.meta_keywords AS meta_keywords_49, s3_.meta_description AS meta_description_50, s3_.id AS id_51, s3_.short_description AS short_description_52, s3_.locale AS locale_53, s4_.price AS price_54, s4_.original_price AS original_price_55, s4_.minimum_price AS minimum_price_56, s4_.lowest_price_before_discount AS lowest_price_before_discount_57, s4_.channel_code AS channel_code_58, s4_.id AS id_59, s5_.type AS type_60, s5_.path AS path_61, s5_.id AS id_62, s5_.position AS position_63, s0_.product_id AS product_id_64, s0_.tax_category_id AS tax_category_id_65, s0_.shipping_category_id AS shipping_category_id_66, s1_.translatable_id AS translatable_id_67, s2_.main_taxon_id AS main_taxon_id_68, s2_.product_type_id AS product_type_id_69, s3_.translatable_id AS translatable_id_70, s4_.product_variant_id AS product_variant_id_71, s5_.owner_id AS owner_id_72 FROM sylius_product_variant s0_ INNER JOIN sylius_product_variant_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_product s2_ ON s0_.product_id = s2_.id INNER JOIN sylius_product_translation s3_ ON s2_.id = s3_.translatable_id LEFT JOIN sylius_channel_pricing s4_ ON s0_.id = s4_.product_variant_id LEFT JOIN sylius_product_image_product_variants s6_ ON s0_.id = s6_.variant_id LEFT JOIN sylius_product_image s5_ ON s5_.id = s6_.image_id WHERE s2_.sold_by_square_meter = 1 AND s0_.enabled = 1 ORDER BY s2_.code ASC, s0_.position ASC, s0_.id ASC, s4_.id ASC, s5_.id ASC
Parameters:
[] |
|
4.57 ms (16.33%) |
2 |
SELECT t0.code AS code_1, t0.type AS type_2, t0.storage_type AS storage_type_3, t0.configuration AS configuration_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.translatable AS translatable_8, t0.id AS id_9 FROM sylius_product_attribute t0 WHERE t0.id = ?
Parameters:
[
7
]
|
|
2.72 ms (9.71%) |
1 |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ?
Parameters:
[
1
]
|
|
1.91 ms (6.81%) |
1 |
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = ? AND t0.enabled = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[ "dev.kamedia.pl" 1 ] |
|
0.97 ms (3.47%) |
1 |
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id LIMIT 1
Parameters:
[] |
|
0.80 ms (2.87%) |
1 |
SELECT COUNT(*) FROM sylius_channel t0
Parameters:
[] |
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\Entity\Product\ProductImage | 10 |
| App\Entity\Product\ProductVariant | 9 |
| App\Entity\Product\ProductVariantTranslation | 9 |
| App\Entity\Channel\ChannelPricing | 9 |
| App\Entity\Product\ProductAttributeValue | 6 |
| App\Entity\Product\Product | 5 |
| App\Entity\Product\ProductTranslation | 5 |
| App\Entity\Product\ProductAttribute | 2 |
| App\Entity\Channel\Channel | 1 |
| App\Entity\Addressing\Zone | 1 |
| App\Entity\Channel\ShopBillingData | 1 |
| App\Entity\Channel\ChannelPriceHistoryConfig | 1 |
| App\Entity\Locale\Locale | 1 |
| App\Entity\Currency\Currency | 1 |
| App\Entity\Taxation\TaxCategory | 1 |