GET https://dev.kamedia.pl/fototapeta-galazka-oliwna-i-wino

Query Metrics

16 Database Queries
13 Different statements
29.79 ms Query time
0 Invalid entities
29 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.77 ms
(16.02%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM km_pattern_style t0 INNER JOIN km_pattern_style_relation ON t0.id = km_pattern_style_relation.pattern_style_id WHERE km_pattern_style_relation.pattern_id = ?
Parameters:
[
  45
]
3.84 ms
(12.87%)
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
]
3.49 ms
(11.72%)
2
SELECT t0.id AS id_1, t0.path AS path_2, t0.is_main AS is_main_3, t0.orientation AS orientation_4, t0.alt_text AS alt_text_5, t0.pattern_id AS pattern_id_6, t0.room_type_id AS room_type_id_7 FROM km_mockup t0 WHERE t0.pattern_id = ?
Parameters:
[
  30
]
2.66 ms
(8.91%)
1
SELECT k0_.id AS id_0, k0_.original_filename AS original_filename_1, k0_.name AS name_2, k0_.slug AS slug_3, k0_.hash AS hash_4, k0_.path AS path_5, k0_.width AS width_6, k0_.height AS height_7, k0_.original_width AS original_width_8, k0_.original_height AS original_height_9, k0_.mime_type AS mime_type_10, k0_.source AS source_11, k0_.s3_key AS s3_key_12, k0_.popularity AS popularity_13, k0_.created_at AS created_at_14, k0_.seo_title AS seo_title_15, k0_.seo_description AS seo_description_16, k0_.seo_subtitle AS seo_subtitle_17, k0_.description_intro AS description_intro_18, k0_.description_features AS description_features_19, k0_.description_usage AS description_usage_20, k0_.category1_id AS category1_id_21, k0_.category2_id AS category2_id_22, k0_.main_room_id AS main_room_id_23, k0_.collection_id AS collection_id_24 FROM km_pattern k0_ INNER JOIN km_pattern_style_relation k2_ ON k0_.id = k2_.pattern_id INNER JOIN km_pattern_style k1_ ON k1_.id = k2_.pattern_style_id WHERE k1_.id = ? AND k0_.id <> ? ORDER BY k0_.id ASC LIMIT 4
Parameters:
[
  7
  45
]
2.29 ms
(7.69%)
1
SELECT MIN(s0_.price) AS sclr_0 FROM sylius_product_variant s1_ INNER JOIN sylius_product s2_ ON s1_.product_id = s2_.id INNER JOIN sylius_channel_pricing s0_ ON s1_.id = s0_.product_variant_id WHERE s2_.sold_by_square_meter = 1 AND s1_.enabled = 1
Parameters:
[]
2.19 ms
(7.33%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM km_pattern_theme t0 INNER JOIN km_pattern_theme_relation ON t0.id = km_pattern_theme_relation.pattern_theme_id WHERE km_pattern_theme_relation.pattern_id = ?
Parameters:
[
  45
]
2.15 ms
(7.21%)
1
SELECT t0.id AS id_1, t0.original_filename AS original_filename_2, t0.name AS name_3, t0.slug AS slug_4, t0.hash AS hash_5, t0.path AS path_6, t0.width AS width_7, t0.height AS height_8, t0.original_width AS original_width_9, t0.original_height AS original_height_10, t0.mime_type AS mime_type_11, t0.source AS source_12, t0.s3_key AS s3_key_13, t0.popularity AS popularity_14, t0.created_at AS created_at_15, t0.seo_title AS seo_title_16, t0.seo_description AS seo_description_17, t0.seo_subtitle AS seo_subtitle_18, t0.description_intro AS description_intro_19, t0.description_features AS description_features_20, t0.description_usage AS description_usage_21, t0.category1_id AS category1_id_22, t0.category2_id AS category2_id_23, t0.main_room_id AS main_room_id_24, t0.collection_id AS collection_id_25 FROM km_pattern t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "galazka-oliwna-i-wino"
]
1.69 ms
(5.68%)
1
SELECT COUNT(*) FROM sylius_channel t0
Parameters:
[]
1.67 ms
(5.60%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.hex_code AS hex_code_4 FROM km_pattern_color t0 INNER JOIN km_pattern_color_relation ON t0.id = km_pattern_color_relation.pattern_color_id WHERE km_pattern_color_relation.pattern_id = ?
Parameters:
[
  45
]
1.46 ms
(4.89%)
1
SELECT t0.id AS id_1, t0.path AS path_2, t0.is_main AS is_main_3, t0.orientation AS orientation_4, t0.alt_text AS alt_text_5, t0.pattern_id AS pattern_id_6, t0.room_type_id AS room_type_id_7 FROM km_mockup t0 WHERE t0.pattern_id = ? ORDER BY t0.id ASC
Parameters:
[
  45
]
1.30 ms
(4.36%)
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:
[]
1.28 ms
(4.30%)
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.01 ms
(3.41%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.visible AS visible_5, t0.parent_id AS parent_id_6 FROM km_pattern_category t0 WHERE t0.id = ?
Parameters:
[
  3
]

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
Kamedia\Pattern\Domain\Entity\PatternTheme 8
Kamedia\Pattern\Domain\Entity\Pattern 3
Kamedia\Pattern\Domain\Entity\Category 3
Kamedia\Pattern\Domain\Entity\PatternRoom 3
Kamedia\Pattern\Domain\Entity\Mockup 3
Kamedia\Pattern\Domain\Entity\PatternColor 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
Kamedia\Pattern\Domain\Entity\PatternStyle 1

Entities Mapping

Class Mapping errors
Sylius\Component\Payment\Model\PaymentMethod No errors.
Sylius\Component\Core\Model\PaymentMethod No errors.
App\Entity\Payment\PaymentMethod No errors.
Sylius\Component\Order\Model\Order No errors.
Sylius\Component\Core\Model\Order No errors.
App\Entity\Order\Order No errors.
Sylius\Component\Shipping\Model\Shipment No errors.
Sylius\Component\Core\Model\Shipment No errors.
App\Entity\Shipping\Shipment No errors.
Sylius\Component\Channel\Model\Channel No errors.
Sylius\Component\Core\Model\Channel No errors.
App\Entity\Channel\Channel No errors.
Sylius\Component\Locale\Model\Locale No errors.
App\Entity\Locale\Locale No errors.
Sylius\Component\Currency\Model\Currency No errors.
App\Entity\Currency\Currency No errors.
Sylius\Component\Addressing\Model\Zone No errors.
App\Entity\Addressing\Zone No errors.
Sylius\Component\Taxonomy\Model\Taxon No errors.
Sylius\Component\Core\Model\Taxon No errors.
App\Entity\Taxonomy\Taxon No errors.
Sylius\Component\Core\Model\ShopBillingData No errors.
App\Entity\Channel\ShopBillingData No errors.
Sylius\Component\Core\Model\ChannelPriceHistoryConfig No errors.
App\Entity\Channel\ChannelPriceHistoryConfig No errors.
Sylius\Component\Addressing\Model\Country No errors.
App\Entity\Addressing\Country No errors.
Kamedia\Pattern\Domain\Entity\Pattern No errors.
Kamedia\Pattern\Domain\Entity\Category No errors.
Kamedia\Pattern\Domain\Entity\PatternRoom No errors.
Kamedia\Pattern\Domain\Entity\Collection No errors.
Kamedia\Pattern\Domain\Entity\PatternStyle No errors.
Kamedia\Pattern\Domain\Entity\PatternColor No errors.
Kamedia\Pattern\Domain\Entity\PatternTheme No errors.
Kamedia\Pattern\Domain\Entity\Mockup No errors.
Sylius\Component\Product\Model\ProductVariant No errors.
Sylius\Component\Core\Model\ProductVariant No errors.
App\Entity\Product\ProductVariant No errors.
Sylius\Component\Product\Model\Product No errors.
Sylius\Component\Core\Model\Product No errors.
App\Entity\Product\Product No errors.
Sylius\Component\Core\Model\ChannelPricing No errors.
App\Entity\Channel\ChannelPricing No errors.
Sylius\Component\Currency\Model\ExchangeRate No errors.
App\Entity\Currency\ExchangeRate No errors.
Sylius\Component\Shipping\Model\ShippingMethod No errors.
Sylius\Component\Core\Model\ShippingMethod No errors.
App\Entity\Shipping\ShippingMethod No errors.
Sylius\MolliePlugin\Entity\MollieCustomer No errors.
Sylius\MolliePlugin\Entity\MollieGatewayConfig No errors.