Symfony Profiler

Query Metrics

78 Database Queries

39 Different statements

79.76 ms Query time

0 Invalid entities

107 Managed entities

Queries


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.translatable_id AS translatable_id_32, t0.shop_billing_data_id AS shop_billing_data_id_33, t0.channel_price_history_config_id AS channel_price_history_config_id_34 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
SELECT COUNT(*) FROM sylius_channel t0
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.translatable_id AS translatable_id_32, t0.shop_billing_data_id AS shop_billing_data_id_33, t0.channel_price_history_config_id AS channel_price_history_config_id_34 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
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 = ?
SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.variant_selection_method AS variant_selection_method_5, s0_.average_rating AS average_rating_6, s0_.min_quantity AS min_quantity_7, s0_.max_quantity AS max_quantity_8, s0_.step_quantity AS step_quantity_9, s0_.wp_permalink AS wp_permalink_10, s0_.og_image AS og_image_11, s0_.wp_id AS wp_id_12, s0_.wp_data AS wp_data_13, s1_.name AS name_14, s1_.slug AS slug_15, s1_.description AS description_16, s1_.meta_keywords AS meta_keywords_17, s1_.meta_description AS meta_description_18, s1_.id AS id_19, s1_.short_description AS short_description_20, s1_.og_title AS og_title_21, s1_.og_description AS og_description_22, s1_.locale AS locale_23, s0_.main_taxon_id AS main_taxon_id_24, s0_.vendor_id AS vendor_id_25, s1_.translatable_id AS translatable_id_26 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE s1_.slug = ? AND EXISTS (SELECT 1 FROM sylius_product_channels s2_ WHERE s2_.product_id = s0_.id AND s2_.channel_id IN (?)) AND s0_.enabled = ? ORDER BY s0_.id ASC
SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s1_.position AS position_4, s1_.alt_ca AS alt_ca_5, s1_.alt_es AS alt_es_6, s0_.main_taxon_id AS main_taxon_id_7, s0_.vendor_id AS vendor_id_8, s1_.owner_id AS owner_id_9 FROM sylius_product s0_ LEFT JOIN sylius_product_image s1_ ON s0_.id = s1_.owner_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.position ASC, s1_.id ASC
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.position AS position_2, s1_.created_at AS created_at_3, s1_.updated_at AS updated_at_4, s1_.id AS id_5, s1_.wp_id AS wp_id_6, s1_.wp_data AS wp_data_7, s0_.main_taxon_id AS main_taxon_id_8, s0_.vendor_id AS vendor_id_9 FROM sylius_product s0_ LEFT JOIN sylius_product_options s2_ ON s0_.id = s2_.product_id LEFT JOIN sylius_product_option s1_ ON s1_.id = s2_.option_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.position ASC, s1_.id ASC
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.created_at AS created_at_2, s1_.updated_at AS updated_at_3, s1_.position AS position_4, s1_.enabled AS enabled_5, s1_.id AS id_6, s1_.version AS version_7, s1_.on_hold AS on_hold_8, s1_.on_hand AS on_hand_9, s1_.tracked AS tracked_10, s1_.width AS width_11, s1_.height AS height_12, s1_.depth AS depth_13, s1_.weight AS weight_14, s1_.shipping_required AS shipping_required_15, s1_.wp_id AS wp_id_16, s1_.wp_data AS wp_data_17, s0_.main_taxon_id AS main_taxon_id_18, s0_.vendor_id AS vendor_id_19, s1_.product_id AS product_id_20, s1_.tax_category_id AS tax_category_id_21, s1_.shipping_category_id AS shipping_category_id_22 FROM sylius_product s0_ LEFT JOIN sylius_product_variant s1_ ON s0_.id = s1_.product_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.position ASC, s1_.id ASC
SELECT s0_.id AS id_0, s1_.price AS price_1, s1_.original_price AS original_price_2, s1_.minimum_price AS minimum_price_3, s1_.lowest_price_before_discount AS lowest_price_before_discount_4, s1_.channel_code AS channel_code_5, s1_.id AS id_6, s0_.product_id AS product_id_7, s0_.tax_category_id AS tax_category_id_8, s0_.shipping_category_id AS shipping_category_id_9, s1_.product_variant_id AS product_variant_id_10 FROM sylius_product_variant s0_ LEFT JOIN sylius_channel_pricing s1_ ON s0_.id = s1_.product_variant_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.id ASC
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s1_.wp_id AS wp_id_3, s1_.wp_data AS wp_data_4, s0_.product_id AS product_id_5, s0_.tax_category_id AS tax_category_id_6, s0_.shipping_category_id AS shipping_category_id_7, s1_.option_id AS option_id_8 FROM sylius_product_variant s0_ LEFT JOIN sylius_product_variant_option_value s2_ ON s0_.id = s2_.variant_id LEFT JOIN sylius_product_option_value s1_ ON s1_.id = s2_.option_value_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.id ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.code AS code_4, t0.commercial_email AS commercial_email_5, t0.commercial_phone_number AS commercial_phone_number_6, t0.business_type AS business_type_7, t0.identification_document_number AS identification_document_number_8, t0.fcac_member AS fcac_member_9, t0.street AS street_10, t0.city AS city_11, t0.postcode AS postcode_12, t0.region AS region_13, t0.vegueria AS vegueria_14, t0.demarcation AS demarcation_15, t0.latitude AS latitude_16, t0.longitude AS longitude_17, t0.shipping_method AS shipping_method_18, t0.stripe_user_id AS stripe_user_id_19, t0.woo_commerce_api_key AS woo_commerce_api_key_20, t0.woo_commerce_api_secret AS woo_commerce_api_secret_21, t0.enabled AS enabled_22, t0.address AS address_23, t0.social_reason AS social_reason_24, t0.schedule AS schedule_25, t0.featured AS featured_26, t0.generalitat_cooperative_number AS generalitat_cooperative_number_27, t0.riaac_number AS riaac_number_28, t0.og_image AS og_image_29, t30.type AS type_31, t30.path AS path_32, t30.id AS id_33, t30.alt AS alt_34, t30.owner_id AS owner_id_35, t36.type AS type_37, t36.path AS path_38, t36.id AS id_39, t36.alt AS alt_40, t36.owner_id AS owner_id_41, t0.province_id AS province_id_42 FROM vendor t0 LEFT JOIN vendor_logo t30 ON t30.owner_id = t0.id LEFT JOIN vendor_main_image t36 ON t36.owner_id = t0.id WHERE t0.id = ?
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 = ? ORDER BY t0.id ASC
SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.og_image AS og_image_9, s0_.wp_id AS wp_id_10, s0_.wp_data AS wp_data_11, s0_.code AS code_12, s0_.tree_left AS tree_left_13, s0_.tree_right AS tree_right_14, s0_.tree_level AS tree_level_15, s0_.position AS position_16, s0_.enabled AS enabled_17, s0_.id AS id_18, s0_.created_at AS created_at_19, s0_.updated_at AS updated_at_20, s0_.og_image AS og_image_21, s0_.wp_id AS wp_id_22, s0_.wp_data AS wp_data_23, s1_.name AS name_24, s1_.slug AS slug_25, s1_.description AS description_26, s1_.id AS id_27, s1_.meta_title AS meta_title_28, s1_.meta_description AS meta_description_29, s1_.og_title AS og_title_30, s1_.og_description AS og_description_31, s1_.locale AS locale_32, s2_.code AS code_33, s2_.tree_left AS tree_left_34, s2_.tree_right AS tree_right_35, s2_.tree_level AS tree_level_36, s2_.position AS position_37, s2_.enabled AS enabled_38, s2_.id AS id_39, s2_.created_at AS created_at_40, s2_.updated_at AS updated_at_41, s2_.og_image AS og_image_42, s2_.wp_id AS wp_id_43, s2_.wp_data AS wp_data_44, s0_.tree_root AS tree_root_45, s0_.parent_id AS parent_id_46, s1_.translatable_id AS translatable_id_47, s2_.tree_root AS tree_root_48, s2_.parent_id AS parent_id_49 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.tree_root = ? ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC
SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.og_image AS og_image_9, s0_.wp_id AS wp_id_10, s0_.wp_data AS wp_data_11, s1_.name AS name_12, s1_.slug AS slug_13, s1_.description AS description_14, s1_.id AS id_15, s1_.meta_title AS meta_title_16, s1_.meta_description AS meta_description_17, s1_.og_title AS og_title_18, s1_.og_description AS og_description_19, s1_.locale AS locale_20, s2_.code AS code_21, s2_.tree_left AS tree_left_22, s2_.tree_right AS tree_right_23, s2_.tree_level AS tree_level_24, s2_.position AS position_25, s2_.enabled AS enabled_26, s2_.id AS id_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s2_.og_image AS og_image_30, s2_.wp_id AS wp_id_31, s2_.wp_data AS wp_data_32, s0_.tree_root AS tree_root_33, s0_.parent_id AS parent_id_34, s1_.translatable_id AS translatable_id_35, s2_.tree_root AS tree_root_36, s2_.parent_id AS parent_id_37 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.enabled = ? AND s3_.code = ? ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1
SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_product_review s0_ WHERE s0_.product_id = ? AND s0_.status = ?
SELECT t0.lowest_price_for_discounted_products_checking_period AS lowest_price_for_discounted_products_checking_period_1, t0.lowest_price_for_discounted_products_visible AS lowest_price_for_discounted_products_visible_2, t0.id AS id_3 FROM sylius_channel_price_history_config t0 WHERE t0.id = ?
SELECT t0.position AS position_1, t0.id AS id_2, t0.product_id AS product_id_3, t0.taxon_id AS taxon_id_4 FROM sylius_product_taxon t0 WHERE t0.product_id = ? ORDER BY t0.id ASC
SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.og_image AS og_image_10, t0.wp_id AS wp_id_11, t0.wp_data AS wp_data_12, t0.tree_root AS tree_root_13, t0.parent_id AS parent_id_14 FROM sylius_taxon t0 INNER JOIN sylius_channel_price_history_config_excluded_taxons ON t0.id = sylius_channel_price_history_config_excluded_taxons.taxon_id WHERE sylius_channel_price_history_config_excluded_taxons.channel_id = ? ORDER BY t0.id ASC
SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.wp_id AS wp_id_7, t0.wp_data AS wp_data_8 FROM sylius_tax_category t0 WHERE t0.id = ?
SELECT t0.code AS code_1, t0.name AS name_2, t0.amount AS amount_3, t0.included_in_price AS included_in_price_4, t0.calculator AS calculator_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.wp_id AS wp_id_11, t0.wp_data AS wp_data_12, t0.category_id AS category_id_13, t0.zone_id AS zone_id_14 FROM sylius_tax_rate t0 WHERE t0.category_id = ? ORDER BY t0.id ASC
SELECT t0.code AS code_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.enabled AS enabled_5, t0.priority AS priority_6, t0.exclusive AS exclusive_7, t0.state AS state_8, t0.id AS id_9 FROM sylius_catalog_promotion t0 INNER JOIN sylius_channel_pricing_catalog_promotions ON t0.id = sylius_channel_pricing_catalog_promotions.catalog_promotion_id WHERE sylius_channel_pricing_catalog_promotions.channel_pricing_id = ? ORDER BY t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
SELECT s0_.code AS code_0, s0_.environment AS environment_1, s0_.is_enabled AS is_enabled_2, s0_.position AS position_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.gateway_config_id AS gateway_config_id_7 FROM sylius_payment_method s0_ WHERE s0_.is_enabled = ? AND EXISTS (SELECT 1 FROM sylius_payment_method_channels s1_ WHERE s1_.payment_method_id = s0_.id AND s1_.channel_id IN (?)) ORDER BY s0_.position ASC, s0_.id ASC
SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = ?
SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = ?
SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = ?
SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC
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
SELECT t0.title AS title_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.product_id AS product_id_8, t0.author_id AS author_id_9 FROM sylius_product_review t0 WHERE t0.product_id = ?
SELECT s0_.title AS title_0, s0_.rating AS rating_1, s0_.comment AS comment_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.product_id AS product_id_7, s0_.author_id AS author_id_8 FROM sylius_product_review s0_ WHERE s0_.product_id = ? AND s0_.status = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 3
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.association_type_id AS association_type_id_4, t0.product_id AS product_id_5 FROM sylius_product_association t0 WHERE t0.product_id = ? ORDER BY t0.id ASC
SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.id AS id_2, s1_.code AS code_3, s1_.created_at AS created_at_4, s1_.updated_at AS updated_at_5, s1_.enabled AS enabled_6, s1_.id AS id_7, s1_.variant_selection_method AS variant_selection_method_8, s1_.average_rating AS average_rating_9, s1_.min_quantity AS min_quantity_10, s1_.max_quantity AS max_quantity_11, s1_.step_quantity AS step_quantity_12, s1_.wp_permalink AS wp_permalink_13, s1_.og_image AS og_image_14, s1_.wp_id AS wp_id_15, s1_.wp_data AS wp_data_16, s0_.association_type_id AS association_type_id_17, s0_.product_id AS product_id_18, s1_.main_taxon_id AS main_taxon_id_19, s1_.vendor_id AS vendor_id_20 FROM sylius_product_association s0_ LEFT JOIN sylius_product_association_product s2_ ON s0_.id = s2_.association_id LEFT JOIN sylius_product s1_ ON s1_.id = s2_.product_id AND (s1_.enabled = 1) INNER JOIN sylius_product_channels s4_ ON s1_.id = s4_.product_id INNER JOIN sylius_channel s3_ ON s3_.id = s4_.channel_id AND (s3_.id = ?) WHERE s0_.id = ? ORDER BY s0_.id ASC, s1_.id ASC
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_product_association_type t0 WHERE t0.id = ?
SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_association_type_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1
SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC
SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.wp_id AS wp_id_7, t0.wp_data AS wp_data_8 FROM sylius_tax_category t0 WHERE t0.id = ?
SELECT t0.code AS code_1, t0.name AS name_2, t0.amount AS amount_3, t0.included_in_price AS included_in_price_4, t0.calculator AS calculator_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.wp_id AS wp_id_11, t0.wp_data AS wp_data_12, t0.category_id AS category_id_13, t0.zone_id AS zone_id_14 FROM sylius_tax_rate t0 WHERE t0.category_id = ? ORDER BY t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1
SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1
SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1
SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1
SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC

#▲	Time	Info
1	3.09 ms	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.translatable_id AS translatable_id_32, t0.shop_billing_data_id AS shop_billing_data_id_33, t0.channel_price_history_config_id AS channel_price_history_config_id_34 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: [`"acooptest01.taller.fesomia.net" 1`] View formatted query View runnable query Explain query 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.translatable_id AS translatable_id_32, t0.shop_billing_data_id AS shop_billing_data_id_33, t0.channel_price_history_config_id AS channel_price_history_config_id_34 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 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.translatable_id AS translatable_id_32, t0.shop_billing_data_id AS shop_billing_data_id_33, t0.channel_price_history_config_id AS channel_price_history_config_id_34 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 = 'acooptest01.taller.fesomia.net' AND t0.enabled = 1 ORDER BY t0.id ASC LIMIT 1;
2	0.67 ms	SELECT COUNT() FROM sylius_channel t0 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM sylius_channel t0 SELECT COUNT(*) FROM sylius_channel t0;
3	0.64 ms	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.translatable_id AS translatable_id_32, t0.shop_billing_data_id AS shop_billing_data_id_33, t0.channel_price_history_config_id AS channel_price_history_config_id_34 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: [] View formatted query View runnable query Explain query 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.translatable_id AS translatable_id_32, t0.shop_billing_data_id AS shop_billing_data_id_33, t0.channel_price_history_config_id AS channel_price_history_config_id_34 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 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.translatable_id AS translatable_id_32, t0.shop_billing_data_id AS shop_billing_data_id_33, t0.channel_price_history_config_id AS channel_price_history_config_id_34 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;
4	1.44 ms	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: [`2`] View formatted query View runnable query Explain query 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 = ? 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 = 2;
5	1.51 ms	SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.variant_selection_method AS variant_selection_method_5, s0_.average_rating AS average_rating_6, s0_.min_quantity AS min_quantity_7, s0_.max_quantity AS max_quantity_8, s0_.step_quantity AS step_quantity_9, s0_.wp_permalink AS wp_permalink_10, s0_.og_image AS og_image_11, s0_.wp_id AS wp_id_12, s0_.wp_data AS wp_data_13, s1_.name AS name_14, s1_.slug AS slug_15, s1_.description AS description_16, s1_.meta_keywords AS meta_keywords_17, s1_.meta_description AS meta_description_18, s1_.id AS id_19, s1_.short_description AS short_description_20, s1_.og_title AS og_title_21, s1_.og_description AS og_description_22, s1_.locale AS locale_23, s0_.main_taxon_id AS main_taxon_id_24, s0_.vendor_id AS vendor_id_25, s1_.translatable_id AS translatable_id_26 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE s1_.slug = ? AND EXISTS (SELECT 1 FROM sylius_product_channels s2_ WHERE s2_.product_id = s0_.id AND s2_.channel_id IN (?)) AND s0_.enabled = ? ORDER BY s0_.id ASC Parameters: [`"ca" "oli-verge-extra-ecologica-degustus" 2 1`] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.variant_selection_method AS variant_selection_method_5, s0_.average_rating AS average_rating_6, s0_.min_quantity AS min_quantity_7, s0_.max_quantity AS max_quantity_8, s0_.step_quantity AS step_quantity_9, s0_.wp_permalink AS wp_permalink_10, s0_.og_image AS og_image_11, s0_.wp_id AS wp_id_12, s0_.wp_data AS wp_data_13, s1_.name AS name_14, s1_.slug AS slug_15, s1_.description AS description_16, s1_.meta_keywords AS meta_keywords_17, s1_.meta_description AS meta_description_18, s1_.id AS id_19, s1_.short_description AS short_description_20, s1_.og_title AS og_title_21, s1_.og_description AS og_description_22, s1_.locale AS locale_23, s0_.main_taxon_id AS main_taxon_id_24, s0_.vendor_id AS vendor_id_25, s1_.translatable_id AS translatable_id_26 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE s1_.slug = ? AND EXISTS ( SELECT 1 FROM sylius_product_channels s2_ WHERE s2_.product_id = s0_.id AND s2_.channel_id IN (?) ) AND s0_.enabled = ? ORDER BY s0_.id ASC SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.variant_selection_method AS variant_selection_method_5, s0_.average_rating AS average_rating_6, s0_.min_quantity AS min_quantity_7, s0_.max_quantity AS max_quantity_8, s0_.step_quantity AS step_quantity_9, s0_.wp_permalink AS wp_permalink_10, s0_.og_image AS og_image_11, s0_.wp_id AS wp_id_12, s0_.wp_data AS wp_data_13, s1_.name AS name_14, s1_.slug AS slug_15, s1_.description AS description_16, s1_.meta_keywords AS meta_keywords_17, s1_.meta_description AS meta_description_18, s1_.id AS id_19, s1_.short_description AS short_description_20, s1_.og_title AS og_title_21, s1_.og_description AS og_description_22, s1_.locale AS locale_23, s0_.main_taxon_id AS main_taxon_id_24, s0_.vendor_id AS vendor_id_25, s1_.translatable_id AS translatable_id_26 FROM sylius_product s0_ INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = 'ca') WHERE s1_.slug = 'oli-verge-extra-ecologica-degustus' AND EXISTS (SELECT 1 FROM sylius_product_channels s2_ WHERE s2_.product_id = s0_.id AND s2_.channel_id IN (2)) AND s0_.enabled = 1 ORDER BY s0_.id ASC;
6	1.27 ms	SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s1_.position AS position_4, s1_.alt_ca AS alt_ca_5, s1_.alt_es AS alt_es_6, s0_.main_taxon_id AS main_taxon_id_7, s0_.vendor_id AS vendor_id_8, s1_.owner_id AS owner_id_9 FROM sylius_product s0_ LEFT JOIN sylius_product_image s1_ ON s0_.id = s1_.owner_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.position ASC, s1_.id ASC Parameters: [`8360`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s1_.position AS position_4, s1_.alt_ca AS alt_ca_5, s1_.alt_es AS alt_es_6, s0_.main_taxon_id AS main_taxon_id_7, s0_.vendor_id AS vendor_id_8, s1_.owner_id AS owner_id_9 FROM sylius_product s0_ LEFT JOIN sylius_product_image s1_ ON s0_.id = s1_.owner_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.position ASC, s1_.id ASC SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s1_.position AS position_4, s1_.alt_ca AS alt_ca_5, s1_.alt_es AS alt_es_6, s0_.main_taxon_id AS main_taxon_id_7, s0_.vendor_id AS vendor_id_8, s1_.owner_id AS owner_id_9 FROM sylius_product s0_ LEFT JOIN sylius_product_image s1_ ON s0_.id = s1_.owner_id WHERE s0_.id IN (8360) ORDER BY s0_.id ASC, s1_.position ASC, s1_.id ASC;
7	1.19 ms	SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.position AS position_2, s1_.created_at AS created_at_3, s1_.updated_at AS updated_at_4, s1_.id AS id_5, s1_.wp_id AS wp_id_6, s1_.wp_data AS wp_data_7, s0_.main_taxon_id AS main_taxon_id_8, s0_.vendor_id AS vendor_id_9 FROM sylius_product s0_ LEFT JOIN sylius_product_options s2_ ON s0_.id = s2_.product_id LEFT JOIN sylius_product_option s1_ ON s1_.id = s2_.option_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.position ASC, s1_.id ASC Parameters: [`8360`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.position AS position_2, s1_.created_at AS created_at_3, s1_.updated_at AS updated_at_4, s1_.id AS id_5, s1_.wp_id AS wp_id_6, s1_.wp_data AS wp_data_7, s0_.main_taxon_id AS main_taxon_id_8, s0_.vendor_id AS vendor_id_9 FROM sylius_product s0_ LEFT JOIN sylius_product_options s2_ ON s0_.id = s2_.product_id LEFT JOIN sylius_product_option s1_ ON s1_.id = s2_.option_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.position ASC, s1_.id ASC SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.position AS position_2, s1_.created_at AS created_at_3, s1_.updated_at AS updated_at_4, s1_.id AS id_5, s1_.wp_id AS wp_id_6, s1_.wp_data AS wp_data_7, s0_.main_taxon_id AS main_taxon_id_8, s0_.vendor_id AS vendor_id_9 FROM sylius_product s0_ LEFT JOIN sylius_product_options s2_ ON s0_.id = s2_.product_id LEFT JOIN sylius_product_option s1_ ON s1_.id = s2_.option_id WHERE s0_.id IN (8360) ORDER BY s0_.id ASC, s1_.position ASC, s1_.id ASC;
8	1.85 ms	SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.created_at AS created_at_2, s1_.updated_at AS updated_at_3, s1_.position AS position_4, s1_.enabled AS enabled_5, s1_.id AS id_6, s1_.version AS version_7, s1_.on_hold AS on_hold_8, s1_.on_hand AS on_hand_9, s1_.tracked AS tracked_10, s1_.width AS width_11, s1_.height AS height_12, s1_.depth AS depth_13, s1_.weight AS weight_14, s1_.shipping_required AS shipping_required_15, s1_.wp_id AS wp_id_16, s1_.wp_data AS wp_data_17, s0_.main_taxon_id AS main_taxon_id_18, s0_.vendor_id AS vendor_id_19, s1_.product_id AS product_id_20, s1_.tax_category_id AS tax_category_id_21, s1_.shipping_category_id AS shipping_category_id_22 FROM sylius_product s0_ LEFT JOIN sylius_product_variant s1_ ON s0_.id = s1_.product_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.position ASC, s1_.id ASC Parameters: [`8360`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.created_at AS created_at_2, s1_.updated_at AS updated_at_3, s1_.position AS position_4, s1_.enabled AS enabled_5, s1_.id AS id_6, s1_.version AS version_7, s1_.on_hold AS on_hold_8, s1_.on_hand AS on_hand_9, s1_.tracked AS tracked_10, s1_.width AS width_11, s1_.height AS height_12, s1_.depth AS depth_13, s1_.weight AS weight_14, s1_.shipping_required AS shipping_required_15, s1_.wp_id AS wp_id_16, s1_.wp_data AS wp_data_17, s0_.main_taxon_id AS main_taxon_id_18, s0_.vendor_id AS vendor_id_19, s1_.product_id AS product_id_20, s1_.tax_category_id AS tax_category_id_21, s1_.shipping_category_id AS shipping_category_id_22 FROM sylius_product s0_ LEFT JOIN sylius_product_variant s1_ ON s0_.id = s1_.product_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.position ASC, s1_.id ASC SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.created_at AS created_at_2, s1_.updated_at AS updated_at_3, s1_.position AS position_4, s1_.enabled AS enabled_5, s1_.id AS id_6, s1_.version AS version_7, s1_.on_hold AS on_hold_8, s1_.on_hand AS on_hand_9, s1_.tracked AS tracked_10, s1_.width AS width_11, s1_.height AS height_12, s1_.depth AS depth_13, s1_.weight AS weight_14, s1_.shipping_required AS shipping_required_15, s1_.wp_id AS wp_id_16, s1_.wp_data AS wp_data_17, s0_.main_taxon_id AS main_taxon_id_18, s0_.vendor_id AS vendor_id_19, s1_.product_id AS product_id_20, s1_.tax_category_id AS tax_category_id_21, s1_.shipping_category_id AS shipping_category_id_22 FROM sylius_product s0_ LEFT JOIN sylius_product_variant s1_ ON s0_.id = s1_.product_id WHERE s0_.id IN (8360) ORDER BY s0_.id ASC, s1_.position ASC, s1_.id ASC;
9	1.46 ms	SELECT s0_.id AS id_0, s1_.price AS price_1, s1_.original_price AS original_price_2, s1_.minimum_price AS minimum_price_3, s1_.lowest_price_before_discount AS lowest_price_before_discount_4, s1_.channel_code AS channel_code_5, s1_.id AS id_6, s0_.product_id AS product_id_7, s0_.tax_category_id AS tax_category_id_8, s0_.shipping_category_id AS shipping_category_id_9, s1_.product_variant_id AS product_variant_id_10 FROM sylius_product_variant s0_ LEFT JOIN sylius_channel_pricing s1_ ON s0_.id = s1_.product_variant_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.id ASC Parameters: [`9974`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s1_.price AS price_1, s1_.original_price AS original_price_2, s1_.minimum_price AS minimum_price_3, s1_.lowest_price_before_discount AS lowest_price_before_discount_4, s1_.channel_code AS channel_code_5, s1_.id AS id_6, s0_.product_id AS product_id_7, s0_.tax_category_id AS tax_category_id_8, s0_.shipping_category_id AS shipping_category_id_9, s1_.product_variant_id AS product_variant_id_10 FROM sylius_product_variant s0_ LEFT JOIN sylius_channel_pricing s1_ ON s0_.id = s1_.product_variant_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.id ASC SELECT s0_.id AS id_0, s1_.price AS price_1, s1_.original_price AS original_price_2, s1_.minimum_price AS minimum_price_3, s1_.lowest_price_before_discount AS lowest_price_before_discount_4, s1_.channel_code AS channel_code_5, s1_.id AS id_6, s0_.product_id AS product_id_7, s0_.tax_category_id AS tax_category_id_8, s0_.shipping_category_id AS shipping_category_id_9, s1_.product_variant_id AS product_variant_id_10 FROM sylius_product_variant s0_ LEFT JOIN sylius_channel_pricing s1_ ON s0_.id = s1_.product_variant_id WHERE s0_.id IN (9974) ORDER BY s0_.id ASC, s1_.id ASC;
10	1.91 ms	SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s1_.wp_id AS wp_id_3, s1_.wp_data AS wp_data_4, s0_.product_id AS product_id_5, s0_.tax_category_id AS tax_category_id_6, s0_.shipping_category_id AS shipping_category_id_7, s1_.option_id AS option_id_8 FROM sylius_product_variant s0_ LEFT JOIN sylius_product_variant_option_value s2_ ON s0_.id = s2_.variant_id LEFT JOIN sylius_product_option_value s1_ ON s1_.id = s2_.option_value_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.id ASC Parameters: [`9974`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s1_.wp_id AS wp_id_3, s1_.wp_data AS wp_data_4, s0_.product_id AS product_id_5, s0_.tax_category_id AS tax_category_id_6, s0_.shipping_category_id AS shipping_category_id_7, s1_.option_id AS option_id_8 FROM sylius_product_variant s0_ LEFT JOIN sylius_product_variant_option_value s2_ ON s0_.id = s2_.variant_id LEFT JOIN sylius_product_option_value s1_ ON s1_.id = s2_.option_value_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC, s1_.id ASC SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s1_.wp_id AS wp_id_3, s1_.wp_data AS wp_data_4, s0_.product_id AS product_id_5, s0_.tax_category_id AS tax_category_id_6, s0_.shipping_category_id AS shipping_category_id_7, s1_.option_id AS option_id_8 FROM sylius_product_variant s0_ LEFT JOIN sylius_product_variant_option_value s2_ ON s0_.id = s2_.variant_id LEFT JOIN sylius_product_option_value s1_ ON s1_.id = s2_.option_value_id WHERE s0_.id IN (9974) ORDER BY s0_.id ASC, s1_.id ASC;
11	1.44 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.code AS code_4, t0.commercial_email AS commercial_email_5, t0.commercial_phone_number AS commercial_phone_number_6, t0.business_type AS business_type_7, t0.identification_document_number AS identification_document_number_8, t0.fcac_member AS fcac_member_9, t0.street AS street_10, t0.city AS city_11, t0.postcode AS postcode_12, t0.region AS region_13, t0.vegueria AS vegueria_14, t0.demarcation AS demarcation_15, t0.latitude AS latitude_16, t0.longitude AS longitude_17, t0.shipping_method AS shipping_method_18, t0.stripe_user_id AS stripe_user_id_19, t0.woo_commerce_api_key AS woo_commerce_api_key_20, t0.woo_commerce_api_secret AS woo_commerce_api_secret_21, t0.enabled AS enabled_22, t0.address AS address_23, t0.social_reason AS social_reason_24, t0.schedule AS schedule_25, t0.featured AS featured_26, t0.generalitat_cooperative_number AS generalitat_cooperative_number_27, t0.riaac_number AS riaac_number_28, t0.og_image AS og_image_29, t30.type AS type_31, t30.path AS path_32, t30.id AS id_33, t30.alt AS alt_34, t30.owner_id AS owner_id_35, t36.type AS type_37, t36.path AS path_38, t36.id AS id_39, t36.alt AS alt_40, t36.owner_id AS owner_id_41, t0.province_id AS province_id_42 FROM vendor t0 LEFT JOIN vendor_logo t30 ON t30.owner_id = t0.id LEFT JOIN vendor_main_image t36 ON t36.owner_id = t0.id WHERE t0.id = ? Parameters: [`153`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.code AS code_4, t0.commercial_email AS commercial_email_5, t0.commercial_phone_number AS commercial_phone_number_6, t0.business_type AS business_type_7, t0.identification_document_number AS identification_document_number_8, t0.fcac_member AS fcac_member_9, t0.street AS street_10, t0.city AS city_11, t0.postcode AS postcode_12, t0.region AS region_13, t0.vegueria AS vegueria_14, t0.demarcation AS demarcation_15, t0.latitude AS latitude_16, t0.longitude AS longitude_17, t0.shipping_method AS shipping_method_18, t0.stripe_user_id AS stripe_user_id_19, t0.woo_commerce_api_key AS woo_commerce_api_key_20, t0.woo_commerce_api_secret AS woo_commerce_api_secret_21, t0.enabled AS enabled_22, t0.address AS address_23, t0.social_reason AS social_reason_24, t0.schedule AS schedule_25, t0.featured AS featured_26, t0.generalitat_cooperative_number AS generalitat_cooperative_number_27, t0.riaac_number AS riaac_number_28, t0.og_image AS og_image_29, t30.type AS type_31, t30.path AS path_32, t30.id AS id_33, t30.alt AS alt_34, t30.owner_id AS owner_id_35, t36.type AS type_37, t36.path AS path_38, t36.id AS id_39, t36.alt AS alt_40, t36.owner_id AS owner_id_41, t0.province_id AS province_id_42 FROM vendor t0 LEFT JOIN vendor_logo t30 ON t30.owner_id = t0.id LEFT JOIN vendor_main_image t36 ON t36.owner_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.code AS code_4, t0.commercial_email AS commercial_email_5, t0.commercial_phone_number AS commercial_phone_number_6, t0.business_type AS business_type_7, t0.identification_document_number AS identification_document_number_8, t0.fcac_member AS fcac_member_9, t0.street AS street_10, t0.city AS city_11, t0.postcode AS postcode_12, t0.region AS region_13, t0.vegueria AS vegueria_14, t0.demarcation AS demarcation_15, t0.latitude AS latitude_16, t0.longitude AS longitude_17, t0.shipping_method AS shipping_method_18, t0.stripe_user_id AS stripe_user_id_19, t0.woo_commerce_api_key AS woo_commerce_api_key_20, t0.woo_commerce_api_secret AS woo_commerce_api_secret_21, t0.enabled AS enabled_22, t0.address AS address_23, t0.social_reason AS social_reason_24, t0.schedule AS schedule_25, t0.featured AS featured_26, t0.generalitat_cooperative_number AS generalitat_cooperative_number_27, t0.riaac_number AS riaac_number_28, t0.og_image AS og_image_29, t30.type AS type_31, t30.path AS path_32, t30.id AS id_33, t30.alt AS alt_34, t30.owner_id AS owner_id_35, t36.type AS type_37, t36.path AS path_38, t36.id AS id_39, t36.alt AS alt_40, t36.owner_id AS owner_id_41, t0.province_id AS province_id_42 FROM vendor t0 LEFT JOIN vendor_logo t30 ON t30.owner_id = t0.id LEFT JOIN vendor_main_image t36 ON t36.owner_id = t0.id WHERE t0.id = 153;
12	1.16 ms	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 = ? ORDER BY t0.id ASC Parameters: [`2`] View formatted query View runnable query Explain query 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 = ? ORDER BY t0.id ASC 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 = 2 ORDER BY t0.id ASC;
13	2.87 ms	SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.og_image AS og_image_9, s0_.wp_id AS wp_id_10, s0_.wp_data AS wp_data_11, s0_.code AS code_12, s0_.tree_left AS tree_left_13, s0_.tree_right AS tree_right_14, s0_.tree_level AS tree_level_15, s0_.position AS position_16, s0_.enabled AS enabled_17, s0_.id AS id_18, s0_.created_at AS created_at_19, s0_.updated_at AS updated_at_20, s0_.og_image AS og_image_21, s0_.wp_id AS wp_id_22, s0_.wp_data AS wp_data_23, s1_.name AS name_24, s1_.slug AS slug_25, s1_.description AS description_26, s1_.id AS id_27, s1_.meta_title AS meta_title_28, s1_.meta_description AS meta_description_29, s1_.og_title AS og_title_30, s1_.og_description AS og_description_31, s1_.locale AS locale_32, s2_.code AS code_33, s2_.tree_left AS tree_left_34, s2_.tree_right AS tree_right_35, s2_.tree_level AS tree_level_36, s2_.position AS position_37, s2_.enabled AS enabled_38, s2_.id AS id_39, s2_.created_at AS created_at_40, s2_.updated_at AS updated_at_41, s2_.og_image AS og_image_42, s2_.wp_id AS wp_id_43, s2_.wp_data AS wp_data_44, s0_.tree_root AS tree_root_45, s0_.parent_id AS parent_id_46, s1_.translatable_id AS translatable_id_47, s2_.tree_root AS tree_root_48, s2_.parent_id AS parent_id_49 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.tree_root = ? ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC Parameters: [`"ca" 28`] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.og_image AS og_image_9, s0_.wp_id AS wp_id_10, s0_.wp_data AS wp_data_11, s0_.code AS code_12, s0_.tree_left AS tree_left_13, s0_.tree_right AS tree_right_14, s0_.tree_level AS tree_level_15, s0_.position AS position_16, s0_.enabled AS enabled_17, s0_.id AS id_18, s0_.created_at AS created_at_19, s0_.updated_at AS updated_at_20, s0_.og_image AS og_image_21, s0_.wp_id AS wp_id_22, s0_.wp_data AS wp_data_23, s1_.name AS name_24, s1_.slug AS slug_25, s1_.description AS description_26, s1_.id AS id_27, s1_.meta_title AS meta_title_28, s1_.meta_description AS meta_description_29, s1_.og_title AS og_title_30, s1_.og_description AS og_description_31, s1_.locale AS locale_32, s2_.code AS code_33, s2_.tree_left AS tree_left_34, s2_.tree_right AS tree_right_35, s2_.tree_level AS tree_level_36, s2_.position AS position_37, s2_.enabled AS enabled_38, s2_.id AS id_39, s2_.created_at AS created_at_40, s2_.updated_at AS updated_at_41, s2_.og_image AS og_image_42, s2_.wp_id AS wp_id_43, s2_.wp_data AS wp_data_44, s0_.tree_root AS tree_root_45, s0_.parent_id AS parent_id_46, s1_.translatable_id AS translatable_id_47, s2_.tree_root AS tree_root_48, s2_.parent_id AS parent_id_49 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.tree_root = ? ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.og_image AS og_image_9, s0_.wp_id AS wp_id_10, s0_.wp_data AS wp_data_11, s0_.code AS code_12, s0_.tree_left AS tree_left_13, s0_.tree_right AS tree_right_14, s0_.tree_level AS tree_level_15, s0_.position AS position_16, s0_.enabled AS enabled_17, s0_.id AS id_18, s0_.created_at AS created_at_19, s0_.updated_at AS updated_at_20, s0_.og_image AS og_image_21, s0_.wp_id AS wp_id_22, s0_.wp_data AS wp_data_23, s1_.name AS name_24, s1_.slug AS slug_25, s1_.description AS description_26, s1_.id AS id_27, s1_.meta_title AS meta_title_28, s1_.meta_description AS meta_description_29, s1_.og_title AS og_title_30, s1_.og_description AS og_description_31, s1_.locale AS locale_32, s2_.code AS code_33, s2_.tree_left AS tree_left_34, s2_.tree_right AS tree_right_35, s2_.tree_level AS tree_level_36, s2_.position AS position_37, s2_.enabled AS enabled_38, s2_.id AS id_39, s2_.created_at AS created_at_40, s2_.updated_at AS updated_at_41, s2_.og_image AS og_image_42, s2_.wp_id AS wp_id_43, s2_.wp_data AS wp_data_44, s0_.tree_root AS tree_root_45, s0_.parent_id AS parent_id_46, s1_.translatable_id AS translatable_id_47, s2_.tree_root AS tree_root_48, s2_.parent_id AS parent_id_49 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = 'ca' AND s0_.tree_root = 28 ORDER BY s0_.id ASC, s2_.position ASC, s2_.id ASC;
14	2.13 ms	SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.og_image AS og_image_9, s0_.wp_id AS wp_id_10, s0_.wp_data AS wp_data_11, s1_.name AS name_12, s1_.slug AS slug_13, s1_.description AS description_14, s1_.id AS id_15, s1_.meta_title AS meta_title_16, s1_.meta_description AS meta_description_17, s1_.og_title AS og_title_18, s1_.og_description AS og_description_19, s1_.locale AS locale_20, s2_.code AS code_21, s2_.tree_left AS tree_left_22, s2_.tree_right AS tree_right_23, s2_.tree_level AS tree_level_24, s2_.position AS position_25, s2_.enabled AS enabled_26, s2_.id AS id_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s2_.og_image AS og_image_30, s2_.wp_id AS wp_id_31, s2_.wp_data AS wp_data_32, s0_.tree_root AS tree_root_33, s0_.parent_id AS parent_id_34, s1_.translatable_id AS translatable_id_35, s2_.tree_root AS tree_root_36, s2_.parent_id AS parent_id_37 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.enabled = ? AND s3_.code = ? ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC Parameters: [`"ca" 1 "ABC_CATEGORY"`] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.og_image AS og_image_9, s0_.wp_id AS wp_id_10, s0_.wp_data AS wp_data_11, s1_.name AS name_12, s1_.slug AS slug_13, s1_.description AS description_14, s1_.id AS id_15, s1_.meta_title AS meta_title_16, s1_.meta_description AS meta_description_17, s1_.og_title AS og_title_18, s1_.og_description AS og_description_19, s1_.locale AS locale_20, s2_.code AS code_21, s2_.tree_left AS tree_left_22, s2_.tree_right AS tree_right_23, s2_.tree_level AS tree_level_24, s2_.position AS position_25, s2_.enabled AS enabled_26, s2_.id AS id_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s2_.og_image AS og_image_30, s2_.wp_id AS wp_id_31, s2_.wp_data AS wp_data_32, s0_.tree_root AS tree_root_33, s0_.parent_id AS parent_id_34, s1_.translatable_id AS translatable_id_35, s2_.tree_root AS tree_root_36, s2_.parent_id AS parent_id_37 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = ? AND s0_.enabled = ? AND s3_.code = ? ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.og_image AS og_image_9, s0_.wp_id AS wp_id_10, s0_.wp_data AS wp_data_11, s1_.name AS name_12, s1_.slug AS slug_13, s1_.description AS description_14, s1_.id AS id_15, s1_.meta_title AS meta_title_16, s1_.meta_description AS meta_description_17, s1_.og_title AS og_title_18, s1_.og_description AS og_description_19, s1_.locale AS locale_20, s2_.code AS code_21, s2_.tree_left AS tree_left_22, s2_.tree_right AS tree_right_23, s2_.tree_level AS tree_level_24, s2_.position AS position_25, s2_.enabled AS enabled_26, s2_.id AS id_27, s2_.created_at AS created_at_28, s2_.updated_at AS updated_at_29, s2_.og_image AS og_image_30, s2_.wp_id AS wp_id_31, s2_.wp_data AS wp_data_32, s0_.tree_root AS tree_root_33, s0_.parent_id AS parent_id_34, s1_.translatable_id AS translatable_id_35, s2_.tree_root AS tree_root_36, s2_.parent_id AS parent_id_37 FROM sylius_taxon s0_ LEFT JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_taxon s3_ ON s0_.parent_id = s3_.id LEFT JOIN sylius_taxon s2_ ON s0_.id = s2_.parent_id WHERE s1_.locale = 'ca' AND s0_.enabled = 1 AND s3_.code = 'ABC_CATEGORY' ORDER BY s0_.position ASC, s0_.id ASC, s2_.position ASC, s2_.id ASC;
15	1.26 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 Parameters: [`8360 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8360 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;
16	1.24 ms	SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_product_review s0_ WHERE s0_.product_id = ? AND s0_.status = ? Parameters: [`8360 "accepted"`] View formatted query View runnable query Explain query SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_product_review s0_ WHERE s0_.product_id = ? AND s0_.status = ? SELECT COUNT(s0_.id) AS sclr_0 FROM sylius_product_review s0_ WHERE s0_.product_id = 8360 AND s0_.status = 'accepted';
17	1.06 ms	SELECT t0.lowest_price_for_discounted_products_checking_period AS lowest_price_for_discounted_products_checking_period_1, t0.lowest_price_for_discounted_products_visible AS lowest_price_for_discounted_products_visible_2, t0.id AS id_3 FROM sylius_channel_price_history_config t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.lowest_price_for_discounted_products_checking_period AS lowest_price_for_discounted_products_checking_period_1, t0.lowest_price_for_discounted_products_visible AS lowest_price_for_discounted_products_visible_2, t0.id AS id_3 FROM sylius_channel_price_history_config t0 WHERE t0.id = ? SELECT t0.lowest_price_for_discounted_products_checking_period AS lowest_price_for_discounted_products_checking_period_1, t0.lowest_price_for_discounted_products_visible AS lowest_price_for_discounted_products_visible_2, t0.id AS id_3 FROM sylius_channel_price_history_config t0 WHERE t0.id = 2;
18	0.64 ms	SELECT t0.position AS position_1, t0.id AS id_2, t0.product_id AS product_id_3, t0.taxon_id AS taxon_id_4 FROM sylius_product_taxon t0 WHERE t0.product_id = ? ORDER BY t0.id ASC Parameters: [`8360`] View formatted query View runnable query Explain query SELECT t0.position AS position_1, t0.id AS id_2, t0.product_id AS product_id_3, t0.taxon_id AS taxon_id_4 FROM sylius_product_taxon t0 WHERE t0.product_id = ? ORDER BY t0.id ASC SELECT t0.position AS position_1, t0.id AS id_2, t0.product_id AS product_id_3, t0.taxon_id AS taxon_id_4 FROM sylius_product_taxon t0 WHERE t0.product_id = 8360 ORDER BY t0.id ASC;
19	0.55 ms	SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.og_image AS og_image_10, t0.wp_id AS wp_id_11, t0.wp_data AS wp_data_12, t0.tree_root AS tree_root_13, t0.parent_id AS parent_id_14 FROM sylius_taxon t0 INNER JOIN sylius_channel_price_history_config_excluded_taxons ON t0.id = sylius_channel_price_history_config_excluded_taxons.taxon_id WHERE sylius_channel_price_history_config_excluded_taxons.channel_id = ? ORDER BY t0.id ASC Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.og_image AS og_image_10, t0.wp_id AS wp_id_11, t0.wp_data AS wp_data_12, t0.tree_root AS tree_root_13, t0.parent_id AS parent_id_14 FROM sylius_taxon t0 INNER JOIN sylius_channel_price_history_config_excluded_taxons ON t0.id = sylius_channel_price_history_config_excluded_taxons.taxon_id WHERE sylius_channel_price_history_config_excluded_taxons.channel_id = ? ORDER BY t0.id ASC SELECT t0.code AS code_1, t0.tree_left AS tree_left_2, t0.tree_right AS tree_right_3, t0.tree_level AS tree_level_4, t0.position AS position_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.og_image AS og_image_10, t0.wp_id AS wp_id_11, t0.wp_data AS wp_data_12, t0.tree_root AS tree_root_13, t0.parent_id AS parent_id_14 FROM sylius_taxon t0 INNER JOIN sylius_channel_price_history_config_excluded_taxons ON t0.id = sylius_channel_price_history_config_excluded_taxons.taxon_id WHERE sylius_channel_price_history_config_excluded_taxons.channel_id = 2 ORDER BY t0.id ASC;
20	0.85 ms	SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.wp_id AS wp_id_7, t0.wp_data AS wp_data_8 FROM sylius_tax_category t0 WHERE t0.id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.wp_id AS wp_id_7, t0.wp_data AS wp_data_8 FROM sylius_tax_category t0 WHERE t0.id = ? SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.wp_id AS wp_id_7, t0.wp_data AS wp_data_8 FROM sylius_tax_category t0 WHERE t0.id = 16;
21	1.27 ms	SELECT t0.code AS code_1, t0.name AS name_2, t0.amount AS amount_3, t0.included_in_price AS included_in_price_4, t0.calculator AS calculator_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.wp_id AS wp_id_11, t0.wp_data AS wp_data_12, t0.category_id AS category_id_13, t0.zone_id AS zone_id_14 FROM sylius_tax_rate t0 WHERE t0.category_id = ? ORDER BY t0.id ASC Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.name AS name_2, t0.amount AS amount_3, t0.included_in_price AS included_in_price_4, t0.calculator AS calculator_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.wp_id AS wp_id_11, t0.wp_data AS wp_data_12, t0.category_id AS category_id_13, t0.zone_id AS zone_id_14 FROM sylius_tax_rate t0 WHERE t0.category_id = ? ORDER BY t0.id ASC SELECT t0.code AS code_1, t0.name AS name_2, t0.amount AS amount_3, t0.included_in_price AS included_in_price_4, t0.calculator AS calculator_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.wp_id AS wp_id_11, t0.wp_data AS wp_data_12, t0.category_id AS category_id_13, t0.zone_id AS zone_id_14 FROM sylius_tax_rate t0 WHERE t0.category_id = 16 ORDER BY t0.id ASC;
22	1.00 ms	SELECT t0.code AS code_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.enabled AS enabled_5, t0.priority AS priority_6, t0.exclusive AS exclusive_7, t0.state AS state_8, t0.id AS id_9 FROM sylius_catalog_promotion t0 INNER JOIN sylius_channel_pricing_catalog_promotions ON t0.id = sylius_channel_pricing_catalog_promotions.catalog_promotion_id WHERE sylius_channel_pricing_catalog_promotions.channel_pricing_id = ? ORDER BY t0.id ASC Parameters: [`9966`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.enabled AS enabled_5, t0.priority AS priority_6, t0.exclusive AS exclusive_7, t0.state AS state_8, t0.id AS id_9 FROM sylius_catalog_promotion t0 INNER JOIN sylius_channel_pricing_catalog_promotions ON t0.id = sylius_channel_pricing_catalog_promotions.catalog_promotion_id WHERE sylius_channel_pricing_catalog_promotions.channel_pricing_id = ? ORDER BY t0.id ASC SELECT t0.code AS code_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.enabled AS enabled_5, t0.priority AS priority_6, t0.exclusive AS exclusive_7, t0.state AS state_8, t0.id AS id_9 FROM sylius_catalog_promotion t0 INNER JOIN sylius_channel_pricing_catalog_promotions ON t0.id = sylius_channel_pricing_catalog_promotions.catalog_promotion_id WHERE sylius_channel_pricing_catalog_promotions.channel_pricing_id = 9966 ORDER BY t0.id ASC;
23	1.46 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 Parameters: [`8360 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8360 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;
24	1.23 ms	SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ? SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = 2;
25	1.66 ms	SELECT s0_.code AS code_0, s0_.environment AS environment_1, s0_.is_enabled AS is_enabled_2, s0_.position AS position_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.gateway_config_id AS gateway_config_id_7 FROM sylius_payment_method s0_ WHERE s0_.is_enabled = ? AND EXISTS (SELECT 1 FROM sylius_payment_method_channels s1_ WHERE s1_.payment_method_id = s0_.id AND s1_.channel_id IN (?)) ORDER BY s0_.position ASC, s0_.id ASC Parameters: [`1 2`] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.environment AS environment_1, s0_.is_enabled AS is_enabled_2, s0_.position AS position_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.gateway_config_id AS gateway_config_id_7 FROM sylius_payment_method s0_ WHERE s0_.is_enabled = ? AND EXISTS ( SELECT 1 FROM sylius_payment_method_channels s1_ WHERE s1_.payment_method_id = s0_.id AND s1_.channel_id IN (?) ) ORDER BY s0_.position ASC, s0_.id ASC SELECT s0_.code AS code_0, s0_.environment AS environment_1, s0_.is_enabled AS is_enabled_2, s0_.position AS position_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.gateway_config_id AS gateway_config_id_7 FROM sylius_payment_method s0_ WHERE s0_.is_enabled = 1 AND EXISTS (SELECT 1 FROM sylius_payment_method_channels s1_ WHERE s1_.payment_method_id = s0_.id AND s1_.channel_id IN (2)) ORDER BY s0_.position ASC, s0_.id ASC;
26	1.13 ms	SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = ? SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = 1;
27	0.76 ms	SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = ? SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = 2;
28	0.54 ms	SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = ? SELECT t0.gateway_name AS gateway_name_1, t0.factory_name AS factory_name_2, t0.config AS config_3, t0.id AS id_4, t0.use_payum AS use_payum_5 FROM sylius_gateway_config t0 WHERE t0.id = 3;
29	3.39 ms	SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.hostname AS hostname_2 FROM sylius_channel s0_ ORDER BY s0_.id ASC;
30	1.12 ms	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: [`8360`] View formatted query View runnable query Explain query 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 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 = 8360 ORDER BY t0.id ASC;
31	1.01 ms	SELECT t0.title AS title_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.product_id AS product_id_8, t0.author_id AS author_id_9 FROM sylius_product_review t0 WHERE t0.product_id = ? Parameters: [`8360`] View formatted query View runnable query Explain query SELECT t0.title AS title_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.product_id AS product_id_8, t0.author_id AS author_id_9 FROM sylius_product_review t0 WHERE t0.product_id = ? SELECT t0.title AS title_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.product_id AS product_id_8, t0.author_id AS author_id_9 FROM sylius_product_review t0 WHERE t0.product_id = 8360;
32	1.10 ms	SELECT s0_.title AS title_0, s0_.rating AS rating_1, s0_.comment AS comment_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.product_id AS product_id_7, s0_.author_id AS author_id_8 FROM sylius_product_review s0_ WHERE s0_.product_id = ? AND s0_.status = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 3 Parameters: [`8360 "accepted"`] View formatted query View runnable query Explain query SELECT s0_.title AS title_0, s0_.rating AS rating_1, s0_.comment AS comment_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.product_id AS product_id_7, s0_.author_id AS author_id_8 FROM sylius_product_review s0_ WHERE s0_.product_id = ? AND s0_.status = ? ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 3 SELECT s0_.title AS title_0, s0_.rating AS rating_1, s0_.comment AS comment_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.product_id AS product_id_7, s0_.author_id AS author_id_8 FROM sylius_product_review s0_ WHERE s0_.product_id = 8360 AND s0_.status = 'accepted' ORDER BY s0_.created_at DESC, s0_.id ASC LIMIT 3;
33	0.94 ms	SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.association_type_id AS association_type_id_4, t0.product_id AS product_id_5 FROM sylius_product_association t0 WHERE t0.product_id = ? ORDER BY t0.id ASC Parameters: [`8360`] View formatted query View runnable query Explain query SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.association_type_id AS association_type_id_4, t0.product_id AS product_id_5 FROM sylius_product_association t0 WHERE t0.product_id = ? ORDER BY t0.id ASC SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.association_type_id AS association_type_id_4, t0.product_id AS product_id_5 FROM sylius_product_association t0 WHERE t0.product_id = 8360 ORDER BY t0.id ASC;
34	1.93 ms	SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.id AS id_2, s1_.code AS code_3, s1_.created_at AS created_at_4, s1_.updated_at AS updated_at_5, s1_.enabled AS enabled_6, s1_.id AS id_7, s1_.variant_selection_method AS variant_selection_method_8, s1_.average_rating AS average_rating_9, s1_.min_quantity AS min_quantity_10, s1_.max_quantity AS max_quantity_11, s1_.step_quantity AS step_quantity_12, s1_.wp_permalink AS wp_permalink_13, s1_.og_image AS og_image_14, s1_.wp_id AS wp_id_15, s1_.wp_data AS wp_data_16, s0_.association_type_id AS association_type_id_17, s0_.product_id AS product_id_18, s1_.main_taxon_id AS main_taxon_id_19, s1_.vendor_id AS vendor_id_20 FROM sylius_product_association s0_ LEFT JOIN sylius_product_association_product s2_ ON s0_.id = s2_.association_id LEFT JOIN sylius_product s1_ ON s1_.id = s2_.product_id AND (s1_.enabled = 1) INNER JOIN sylius_product_channels s4_ ON s1_.id = s4_.product_id INNER JOIN sylius_channel s3_ ON s3_.id = s4_.channel_id AND (s3_.id = ?) WHERE s0_.id = ? ORDER BY s0_.id ASC, s1_.id ASC Parameters: [`2 1048`] View formatted query View runnable query Explain query SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.id AS id_2, s1_.code AS code_3, s1_.created_at AS created_at_4, s1_.updated_at AS updated_at_5, s1_.enabled AS enabled_6, s1_.id AS id_7, s1_.variant_selection_method AS variant_selection_method_8, s1_.average_rating AS average_rating_9, s1_.min_quantity AS min_quantity_10, s1_.max_quantity AS max_quantity_11, s1_.step_quantity AS step_quantity_12, s1_.wp_permalink AS wp_permalink_13, s1_.og_image AS og_image_14, s1_.wp_id AS wp_id_15, s1_.wp_data AS wp_data_16, s0_.association_type_id AS association_type_id_17, s0_.product_id AS product_id_18, s1_.main_taxon_id AS main_taxon_id_19, s1_.vendor_id AS vendor_id_20 FROM sylius_product_association s0_ LEFT JOIN sylius_product_association_product s2_ ON s0_.id = s2_.association_id LEFT JOIN sylius_product s1_ ON s1_.id = s2_.product_id AND (s1_.enabled = 1) INNER JOIN sylius_product_channels s4_ ON s1_.id = s4_.product_id INNER JOIN sylius_channel s3_ ON s3_.id = s4_.channel_id AND (s3_.id = ?) WHERE s0_.id = ? ORDER BY s0_.id ASC, s1_.id ASC SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.id AS id_2, s1_.code AS code_3, s1_.created_at AS created_at_4, s1_.updated_at AS updated_at_5, s1_.enabled AS enabled_6, s1_.id AS id_7, s1_.variant_selection_method AS variant_selection_method_8, s1_.average_rating AS average_rating_9, s1_.min_quantity AS min_quantity_10, s1_.max_quantity AS max_quantity_11, s1_.step_quantity AS step_quantity_12, s1_.wp_permalink AS wp_permalink_13, s1_.og_image AS og_image_14, s1_.wp_id AS wp_id_15, s1_.wp_data AS wp_data_16, s0_.association_type_id AS association_type_id_17, s0_.product_id AS product_id_18, s1_.main_taxon_id AS main_taxon_id_19, s1_.vendor_id AS vendor_id_20 FROM sylius_product_association s0_ LEFT JOIN sylius_product_association_product s2_ ON s0_.id = s2_.association_id LEFT JOIN sylius_product s1_ ON s1_.id = s2_.product_id AND (s1_.enabled = 1) INNER JOIN sylius_product_channels s4_ ON s1_.id = s4_.product_id INNER JOIN sylius_channel s3_ ON s3_.id = s4_.channel_id AND (s3_.id = 2) WHERE s0_.id = 1048 ORDER BY s0_.id ASC, s1_.id ASC;
35	0.69 ms	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_product_association_type t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query 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_product_association_type t0 WHERE t0.id = ? 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_product_association_type t0 WHERE t0.id = 2;
36	0.99 ms	SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_association_type_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 Parameters: [`2 "ca"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_association_type_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 SELECT t0.name AS name_1, t0.id AS id_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM sylius_product_association_type_translation t0 WHERE t0.translatable_id = 2 AND t0.locale = 'ca' LIMIT 1;
37	0.80 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 Parameters: [`8324 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8324 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;
38	0.56 ms	SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC Parameters: [`9932`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = 9932 ORDER BY t0.id ASC;
39	0.73 ms	SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 Parameters: [`8324 "ca"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = 8324 AND t0.locale = 'ca' LIMIT 1;
40	0.97 ms	SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8324`] View formatted query View runnable query Explain query SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = 8324 ORDER BY t0.position ASC, t0.id ASC;
41	1.22 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8324`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8324 ORDER BY t0.position ASC, t0.id ASC;
42	0.73 ms	SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC Parameters: [`9932`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = 9932 ORDER BY t0.id ASC;
43	1.15 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 Parameters: [`8324 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8324 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;
44	1.16 ms	SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8324`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = 8324 ORDER BY t0.position ASC, t0.id ASC;
45	0.89 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 Parameters: [`8331 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8331 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;
46	0.59 ms	SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC Parameters: [`9939`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = 9939 ORDER BY t0.id ASC;
47	0.53 ms	SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 Parameters: [`8331 "ca"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = 8331 AND t0.locale = 'ca' LIMIT 1;
48	0.75 ms	SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8331`] View formatted query View runnable query Explain query SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = 8331 ORDER BY t0.position ASC, t0.id ASC;
49	0.66 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8331`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8331 ORDER BY t0.position ASC, t0.id ASC;
50	0.55 ms	SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC Parameters: [`9939`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = 9939 ORDER BY t0.id ASC;
51	0.50 ms	SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.wp_id AS wp_id_7, t0.wp_data AS wp_data_8 FROM sylius_tax_category t0 WHERE t0.id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.wp_id AS wp_id_7, t0.wp_data AS wp_data_8 FROM sylius_tax_category t0 WHERE t0.id = ? SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.wp_id AS wp_id_7, t0.wp_data AS wp_data_8 FROM sylius_tax_category t0 WHERE t0.id = 17;
52	0.53 ms	SELECT t0.code AS code_1, t0.name AS name_2, t0.amount AS amount_3, t0.included_in_price AS included_in_price_4, t0.calculator AS calculator_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.wp_id AS wp_id_11, t0.wp_data AS wp_data_12, t0.category_id AS category_id_13, t0.zone_id AS zone_id_14 FROM sylius_tax_rate t0 WHERE t0.category_id = ? ORDER BY t0.id ASC Parameters: [`17`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.name AS name_2, t0.amount AS amount_3, t0.included_in_price AS included_in_price_4, t0.calculator AS calculator_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.wp_id AS wp_id_11, t0.wp_data AS wp_data_12, t0.category_id AS category_id_13, t0.zone_id AS zone_id_14 FROM sylius_tax_rate t0 WHERE t0.category_id = ? ORDER BY t0.id ASC SELECT t0.code AS code_1, t0.name AS name_2, t0.amount AS amount_3, t0.included_in_price AS included_in_price_4, t0.calculator AS calculator_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.wp_id AS wp_id_11, t0.wp_data AS wp_data_12, t0.category_id AS category_id_13, t0.zone_id AS zone_id_14 FROM sylius_tax_rate t0 WHERE t0.category_id = 17 ORDER BY t0.id ASC;
53	0.73 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 Parameters: [`8331 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8331 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;
54	0.94 ms	SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8331`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = 8331 ORDER BY t0.position ASC, t0.id ASC;
55	0.71 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 Parameters: [`8332 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8332 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;
56	0.58 ms	SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC Parameters: [`9940`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = 9940 ORDER BY t0.id ASC;
57	0.67 ms	SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 Parameters: [`8332 "ca"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = 8332 AND t0.locale = 'ca' LIMIT 1;
58	0.74 ms	SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8332`] View formatted query View runnable query Explain query SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = 8332 ORDER BY t0.position ASC, t0.id ASC;
59	0.87 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8332`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8332 ORDER BY t0.position ASC, t0.id ASC;
60	0.59 ms	SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC Parameters: [`9940`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = 9940 ORDER BY t0.id ASC;
61	0.67 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 Parameters: [`8332 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8332 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;
62	0.92 ms	SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8332`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = 8332 ORDER BY t0.position ASC, t0.id ASC;
63	0.81 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 Parameters: [`8345 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8345 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;
64	0.48 ms	SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC Parameters: [`9956`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = 9956 ORDER BY t0.id ASC;
65	0.62 ms	SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 Parameters: [`8345 "ca"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = 8345 AND t0.locale = 'ca' LIMIT 1;
66	0.60 ms	SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8345`] View formatted query View runnable query Explain query SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = 8345 ORDER BY t0.position ASC, t0.id ASC;
67	1.00 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8345`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8345 ORDER BY t0.position ASC, t0.id ASC;
68	0.57 ms	SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC Parameters: [`9956`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = 9956 ORDER BY t0.id ASC;
69	1.10 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 Parameters: [`8345 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8345 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;
70	1.04 ms	SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8345`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = 8345 ORDER BY t0.position ASC, t0.id ASC;
71	0.76 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 Parameters: [`8358 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8358 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;
72	0.56 ms	SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC Parameters: [`9972`] View formatted query View runnable query Explain query SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = 9972 ORDER BY t0.id ASC;
73	0.58 ms	SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 Parameters: [`8358 "ca"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_keywords AS meta_keywords_4, t0.meta_description AS meta_description_5, t0.id AS id_6, t0.short_description AS short_description_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM sylius_product_translation t0 WHERE t0.translatable_id = 8358 AND t0.locale = 'ca' LIMIT 1;
74	0.60 ms	SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8358`] View formatted query View runnable query Explain query SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.position AS position_4, t0.alt_ca AS alt_ca_5, t0.alt_es AS alt_es_6, t0.owner_id AS owner_id_7 FROM sylius_product_image t0 WHERE t0.owner_id = 8358 ORDER BY t0.position ASC, t0.id ASC;
75	0.77 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8358`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8358 ORDER BY t0.position ASC, t0.id ASC;
76	0.50 ms	SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC Parameters: [`9972`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = ? ORDER BY t0.id ASC SELECT t0.code AS code_1, t0.id AS id_2, t0.wp_id AS wp_id_3, t0.wp_data AS wp_data_4, t0.option_id AS option_id_5 FROM sylius_product_option_value t0 INNER JOIN sylius_product_variant_option_value ON t0.id = sylius_product_variant_option_value.option_value_id WHERE sylius_product_variant_option_value.variant_id = 9972 ORDER BY t0.id ASC;
77	0.67 ms	SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 Parameters: [`8358 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = ? AND t0.enabled = ? ORDER BY t0.position ASC, t0.id ASC LIMIT 1 SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.wp_id AS wp_id_16, t0.wp_data AS wp_data_17, t0.product_id AS product_id_18, t0.tax_category_id AS tax_category_id_19, t0.shipping_category_id AS shipping_category_id_20 FROM sylius_product_variant t0 WHERE t0.product_id = 8358 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;
78	0.87 ms	SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC Parameters: [`8358`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = ? ORDER BY t0.position ASC, t0.id ASC SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.wp_id AS wp_id_6, t0.wp_data AS wp_data_7 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = 8358 ORDER BY t0.position ASC, t0.id ASC;

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\Taxonomy\Taxon	27
App\Entity\Taxonomy\TaxonTranslation	27
App\Entity\Product\Product	6
App\Entity\Product\ProductTranslation	6
App\Entity\Product\ProductImage	6
App\Entity\Product\ProductVariant	6
App\Entity\Channel\ChannelPricing	6
App\Entity\Payment\PaymentMethod	3
App\Entity\Payment\GatewayConfig	3
App\Entity\Taxation\TaxCategory	2
App\Entity\Taxation\TaxRate	2
App\Entity\Channel\Channel	1
App\Entity\Addressing\Zone	1
App\Entity\Channel\ChannelTranslatable	1
App\Entity\Channel\ShopBillingData	1
App\Entity\Channel\ChannelPriceHistoryConfig	1
App\Entity\Locale\Locale	1
App\Entity\Currency\Currency	1
App\Entity\Marketplace\Vendor	1
App\Entity\Product\ProductTaxon	1
App\Entity\Addressing\Country	1
App\Entity\Product\ProductAssociation	1
App\Entity\Product\ProductAssociationType	1
App\Entity\Product\ProductAssociationTypeTranslation	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.
App\Entity\Channel\ChannelTranslatable	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.
Sylius\Component\Product\Model\Product	No errors.
Sylius\Component\Core\Model\Product	No errors.
App\Entity\Product\Product	No errors.
Sylius\Component\Product\Model\ProductTranslation	No errors.
Sylius\Component\Core\Model\ProductTranslation	No errors.
App\Entity\Product\ProductTranslation	No errors.
App\Entity\Marketplace\Vendor	No errors.
Sylius\Component\Core\Model\ProductTaxon	No errors.
App\Entity\Product\ProductTaxon	No errors.
Sylius\Component\Review\Model\Review	No errors.
Sylius\Component\Core\Model\ProductReview	No errors.
App\Entity\Product\ProductReview	No errors.
Sylius\Component\Core\Model\Image	No errors.
Sylius\Component\Core\Model\ProductImage	No errors.
App\Entity\Product\ProductImage	No errors.
Sylius\Component\Attribute\Model\AttributeValue	No errors.
Sylius\Component\Product\Model\ProductAttributeValue	No errors.
App\Entity\Product\ProductAttributeValue	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\ProductAssociation	No errors.
App\Entity\Product\ProductAssociation	No errors.
Sylius\Component\Product\Model\ProductOption	No errors.
App\Entity\Product\ProductOption	No errors.
Sylius\Component\Taxation\Model\TaxCategory	No errors.
App\Entity\Taxation\TaxCategory	No errors.
Sylius\Component\Shipping\Model\ShippingCategory	No errors.
App\Entity\Shipping\ShippingCategory	No errors.
Sylius\Component\Product\Model\ProductVariantTranslation	No errors.
App\Entity\Product\ProductVariantTranslation	No errors.
Sylius\Component\Core\Model\ChannelPricing	No errors.
App\Entity\Channel\ChannelPricing	No errors.
Sylius\Component\Product\Model\ProductOptionValue	No errors.
App\Entity\Product\ProductOptionValue	No errors.
Sylius\Component\Promotion\Model\CatalogPromotion	No errors.
Sylius\Component\Core\Model\CatalogPromotion	No errors.
App\Entity\Promotion\CatalogPromotion	No errors.
App\Entity\Marketplace\VendorLogo	No errors.
App\Entity\Marketplace\VendorMainImage	No errors.
Sylius\Component\Addressing\Model\Province	No errors.
App\Entity\Addressing\Province	No errors.
Sylius\Component\Order\Model\OrderItem	No errors.
Sylius\Component\Core\Model\OrderItem	No errors.
App\Entity\Order\OrderItem	No errors.
App\Entity\Marketplace\VendorImage	No errors.
Sylius\Component\User\Model\User	No errors.
Sylius\Component\Core\Model\AdminUser	No errors.
App\Entity\User\AdminUser	No errors.
App\Entity\Marketplace\VendorTranslation	No errors.
Sylius\CmsPlugin\Entity\Block	No errors.
Sylius\CmsPlugin\Entity\Collection	No errors.
Sylius\CmsPlugin\Entity\Media	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\RefundPlugin\Entity\Refund	No errors.
Sylius\RefundPlugin\Entity\RefundPayment	No errors.
Sylius\Component\Order\Model\OrderItemUnit	No errors.
Sylius\Component\Core\Model\OrderItemUnit	No errors.
App\Entity\Order\OrderItemUnit	No errors.
Sylius\Component\Taxonomy\Model\TaxonTranslation	No errors.
App\Entity\Taxonomy\TaxonTranslation	No errors.
Sylius\Component\Core\Model\TaxonImage	No errors.
App\Entity\Taxonomy\TaxonImage	No errors.
Sylius\Component\Taxation\Model\TaxRate	No errors.
Sylius\Component\Core\Model\TaxRate	No errors.
App\Entity\Taxation\TaxRate	No errors.
Sylius\Component\Payment\Model\GatewayConfig	No errors.
Sylius\Bundle\PayumBundle\Model\GatewayConfig	No errors.
App\Entity\Payment\GatewayConfig	No errors.
Sylius\Component\Payment\Model\PaymentMethodTranslation	No errors.
App\Entity\Payment\PaymentMethodTranslation	No errors.
Sylius\Component\Promotion\Model\PromotionCoupon	No errors.
Sylius\Component\Core\Model\PromotionCoupon	No errors.
App\Entity\Promotion\PromotionCoupon	No errors.
Sylius\Component\Customer\Model\Customer	No errors.
Sylius\Component\Core\Model\Customer	No errors.
App\Entity\Customer\Customer	No errors.
App\Entity\Marketplace\VendorOrder	No errors.
Sylius\Component\Addressing\Model\Address	No errors.
Sylius\Component\Core\Model\Address	No errors.
App\Entity\Addressing\Address	No errors.
Sylius\Component\Payment\Model\Payment	No errors.
Sylius\Component\Core\Model\Payment	No errors.
App\Entity\Payment\Payment	No errors.
Sylius\Component\Promotion\Model\Promotion	No errors.
Sylius\Component\Core\Model\Promotion	No errors.
App\Entity\Promotion\Promotion	No errors.
Sylius\Component\Order\Model\Adjustment	No errors.
Sylius\Component\Core\Model\Adjustment	No errors.
App\Entity\Order\Adjustment	No errors.
App\Entity\Shipping\PartialShipment	No errors.
Sylius\Component\Addressing\Model\ZoneMember	No errors.
App\Entity\Addressing\ZoneMember	No errors.
App\Entity\Channel\ChannelTranslatableTranslation	No errors.
Sylius\Component\Attribute\Model\Attribute	No errors.
Sylius\Component\Product\Model\ProductAttribute	No errors.
App\Entity\Product\ProductAttribute	No errors.
Sylius\Component\Product\Model\ProductAssociationType	No errors.
App\Entity\Product\ProductAssociationType	No errors.
Sylius\Component\Product\Model\ProductOptionTranslation	No errors.
App\Entity\Product\ProductOptionTranslation	No errors.
Sylius\Component\Product\Model\ProductOptionValueTranslation	No errors.
App\Entity\Product\ProductOptionValueTranslation	No errors.
Sylius\Component\Promotion\Model\CatalogPromotionTranslation	No errors.
App\Entity\Promotion\CatalogPromotionTranslation	No errors.
Sylius\Component\Promotion\Model\CatalogPromotionScope	No errors.
Sylius\Component\Core\Model\CatalogPromotionScope	No errors.
App\Entity\Promotion\CatalogPromotionScope	No errors.
Sylius\Component\Promotion\Model\CatalogPromotionAction	No errors.
App\Entity\Promotion\CatalogPromotionAction	No errors.
Odiseo\SyliusRbacPlugin\Entity\AdministrationRole	No errors.
Sylius\Component\Core\Model\AvatarImage	No errors.
App\Entity\User\AvatarImage	No errors.
Sylius\Component\User\Model\UserOAuth	No errors.
App\Entity\User\UserOAuth	No errors.
Sylius\CmsPlugin\Entity\ContentConfiguration	No errors.
Sylius\CmsPlugin\Entity\Page	No errors.
Sylius\CmsPlugin\Entity\MediaTranslation	No errors.
Sylius\CmsPlugin\Entity\PageTranslation	No errors.
Sylius\Component\Shipping\Model\ShippingMethodTranslation	No errors.
App\Entity\Shipping\ShippingMethodTranslation	No errors.
Sylius\Component\Shipping\Model\ShippingMethodRule	No errors.
App\Entity\Shipping\ShippingMethodRule	No errors.
Sylius\Component\Product\Model\ProductAssociationTypeTranslation	No errors.
App\Entity\Product\ProductAssociationTypeTranslation	No errors.

Symfony Profiler

GET https://acooptest01.taller.fesomia.net/productes/oli-verge-extra-ecologica-degustus

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping