Query Metrics

18 Database Queries
7 Different statements
18.40 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.27 ms
(28.65%)
6
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.template AS template_4, t0.content AS content_5, t0.code AS code_6, t0.priority AS priority_7, t0.sub_title AS sub_title_8, t0.document_name AS document_name_9, t0.document_path AS document_path_10, t0.document_size AS document_size_11, t0.document_type AS document_type_12, t0.updated_at AS updated_at_13, t0.section_image_id AS section_image_id_14, t0.section_image_search_id AS section_image_search_id_15 FROM section t0 WHERE t0.code = ? ORDER BY t0.priority ASC
Parameters:
[
  2
]
4.67 ms
(25.36%)
4
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.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_13, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_14, t0.account_verification_required AS account_verification_required_15, t0.shop_billing_data_id AS shop_billing_data_id_16, t0.default_locale_id AS default_locale_id_17, t18.code AS code_19, t18.created_at AS created_at_20, t18.updated_at AS updated_at_21, t18.id AS id_22, t0.base_currency_id AS base_currency_id_23, t24.code AS code_25, t24.created_at AS created_at_26, t24.updated_at AS updated_at_27, t24.id AS id_28, t0.default_tax_zone_id AS default_tax_zone_id_29 FROM sylius_channel t0 INNER JOIN sylius_locale t18 ON t0.default_locale_id = t18.id INNER JOIN sylius_currency t24 ON t0.base_currency_id = t24.id
Parameters:
[]
3.48 ms
(18.93%)
3
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.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_13, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_14, t0.account_verification_required AS account_verification_required_15, t0.shop_billing_data_id AS shop_billing_data_id_16, t0.default_locale_id AS default_locale_id_17, t18.code AS code_19, t18.created_at AS created_at_20, t18.updated_at AS updated_at_21, t18.id AS id_22, t0.base_currency_id AS base_currency_id_23, t24.code AS code_25, t24.created_at AS created_at_26, t24.updated_at AS updated_at_27, t24.id AS id_28, t0.default_tax_zone_id AS default_tax_zone_id_29 FROM sylius_channel t0 INNER JOIN sylius_locale t18 ON t0.default_locale_id = t18.id INNER JOIN sylius_currency t24 ON t0.base_currency_id = t24.id WHERE t0.hostname = ? LIMIT 1
Parameters:
[
  "example.com"
]
2.25 ms
(12.23%)
2
SELECT s0_.number AS number_0, s0_.notes AS notes_1, s0_.state AS state_2, s0_.checkout_completed_at AS checkout_completed_at_3, s0_.items_total AS items_total_4, s0_.adjustments_total AS adjustments_total_5, s0_.total AS total_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.id AS id_9, s0_.currency_code AS currency_code_10, s0_.locale_code AS locale_code_11, s0_.checkout_state AS checkout_state_12, s0_.payment_state AS payment_state_13, s0_.shipping_state AS shipping_state_14, s0_.token_value AS token_value_15, s0_.customer_ip AS customer_ip_16, s0_.channel_id AS channel_id_17, s0_.promotion_coupon_id AS promotion_coupon_id_18, s0_.customer_id AS customer_id_19, s0_.shipping_address_id AS shipping_address_id_20, s0_.billing_address_id AS billing_address_id_21 FROM sylius_order s0_ WHERE s0_.token_value = ? AND s0_.state = ? AND s0_.channel_id = ?
Parameters:
[
  null
  "shopping_cart"
  1
]
1.04 ms
(5.67%)
1
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.template AS template_3, s0_.content AS content_4, s0_.code AS code_5, s0_.priority AS priority_6, s0_.sub_title AS sub_title_7, s0_.document_name AS document_name_8, s0_.document_path AS document_path_9, s0_.document_size AS document_size_10, s0_.document_type AS document_type_11, s0_.updated_at AS updated_at_12, s0_.section_image_id AS section_image_id_13, s0_.section_image_search_id AS section_image_search_id_14 FROM section s0_ WHERE s0_.template NOT IN (?) AND s0_.code IN (?) ORDER BY s0_.priority ASC
Parameters:
[
  [
    11
    12
    13
  ]
  [
    1
  ]
]
0.88 ms
(4.77%)
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
]
0.81 ms
(4.39%)
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_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = ?
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.

Entities Mapping

Class Mapping errors
Sylius\Component\Order\Model\Order No errors.
Sylius\Component\Core\Model\Order No errors.
App\Entity\Core\Order No errors.
Sylius\Component\Channel\Model\Channel No errors.
Sylius\Component\Core\Model\Channel No errors.
Sylius\Component\Core\Model\ShopBillingData No errors.
Sylius\Component\Locale\Model\Locale No errors.
Sylius\Component\Currency\Model\Currency No errors.
Sylius\Component\Addressing\Model\Zone No errors.
Sylius\Component\Shipping\Model\ShippingMethod No errors.
Sylius\Component\Core\Model\ShippingMethod No errors.
Sylius\Component\Order\Model\OrderSequence No errors.
Sylius\Component\Core\Model\OrderSequence No errors.
Sylius\Component\Order\Model\OrderItem No errors.
Sylius\Component\Core\Model\OrderItem No errors.
App\Entity\Core\OrderItem No errors.
Sylius\Component\Product\Model\ProductVariant No errors.
Sylius\Component\Core\Model\ProductVariant No errors.
App\Entity\Core\ProductVariant No errors.
Sylius\Component\User\Model\User No errors.
Sylius\Component\Core\Model\ShopUser No errors.
Sylius\Component\Payment\Model\PaymentMethod No errors.
Sylius\Component\Core\Model\PaymentMethod No errors.
App\Entity\Section No errors.
Sylius\Component\Core\Model\Image No errors.
App\Entity\SectionImage No errors.
App\Entity\SectionImageSearch No errors.
App\Entity\RelatedProduct
  • The mappings App\Entity\RelatedProduct#product and App\Entity\Core\Product#relatedProducts are inconsistent with each other.
Sylius\Component\Promotion\Model\PromotionCoupon No errors.
Sylius\Component\Core\Model\PromotionCoupon No errors.
Sylius\Component\Customer\Model\Customer No errors.
Sylius\Component\Core\Model\Customer No errors.
App\Entity\Core\Customer No errors.
Sylius\Component\Addressing\Model\Address No errors.
Sylius\Component\Core\Model\Address No errors.
Sylius\Component\Product\Model\Product No errors.
Sylius\Component\Core\Model\Product No errors.
App\Entity\Core\Product No errors.
Sylius\Component\Taxonomy\Model\Taxon No errors.
Sylius\Component\Core\Model\Taxon No errors.
App\Entity\Core\Taxon No errors.