Query Metrics

211 Database Queries
37 Different statements
122.42 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.48 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.google_analytics_code AS google_analytics_code_17, t0.google_tag_manager_id AS google_tag_manager_id_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.default_tax_zone_id AS default_tax_zone_id_31, t0.menu_taxon_id AS menu_taxon_id_32, t0.shop_billing_data_id AS shop_billing_data_id_33, t0.referenceable_content_id AS referenceable_content_id_34 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id WHERE t0.hostname = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  "test.sudekusa.com"
  1
]
2 0.21 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.google_analytics_code AS google_analytics_code_17, t0.google_tag_manager_id AS google_tag_manager_id_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.default_tax_zone_id AS default_tax_zone_id_31, t0.menu_taxon_id AS menu_taxon_id_32, t0.shop_billing_data_id AS shop_billing_data_id_33, t0.referenceable_content_id AS referenceable_content_id_34 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id
Parameters:
[]
3 0.26 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:
[
  1
]
4 0.17 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:
[
  1
]
5 0.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:
[
  1
]
6 12.65 ms
SELECT COUNT(s0_.id) AS sclr_0 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 = 1
Parameters:
[
  "en_US"
  "activ-drawstring-backpack-ap5002"
  1
]
7 0.50 ms
SELECT COUNT(s0_.id) AS sclr_0 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 = 1
Parameters:
[
  "en_US"
  "activ-drawstring-backpack-ap5002"
  1
]
8 8.62 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_.ean AS ean_7, s0_.min_quantity AS min_quantity_8, s0_.min_price AS min_price_9, s0_.max_price AS max_price_10, s0_.markup AS markup_11, s0_.only_breakpoints AS only_breakpoints_12, s0_.seo_brand AS seo_brand_13, s0_.seo_gtin8 AS seo_gtin8_14, s0_.seo_gtin13 AS seo_gtin13_15, s0_.seo_gtin14 AS seo_gtin14_16, s0_.seo_mpn AS seo_mpn_17, s0_.seo_isbn AS seo_isbn_18, s0_.seo_sku AS seo_sku_19, s0_.seo_offer_aggregated AS seo_offer_aggregated_20, s1_.name AS name_21, s1_.slug AS slug_22, s1_.description AS description_23, s1_.meta_description AS meta_description_24, s1_.id AS id_25, s1_.short_description AS short_description_26, s1_.meta_keywords AS meta_keywords_27, s1_.locale AS locale_28, s0_.main_taxon_id AS main_taxon_id_29, s0_.brand_id AS brand_id_30, s0_.referenceable_content_id AS referenceable_content_id_31, s1_.translatable_id AS translatable_id_32 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:
[
  "en_US"
  "activ-drawstring-backpack-ap5002"
  1
  1
]
9 0.32 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.id AS id_3, t0.plate_default AS plate_default_4, t0.plate_per_color AS plate_per_color_5, t0.production_time AS production_time_6, t0.setup_default AS setup_default_7, t0.url AS url_8, t0.freight AS freight_9 FROM loevgaard_brand t0 WHERE t0.id IN (?)
Parameters:
[
  [
    13
  ]
]
10 0.39 ms
SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s0_.main_taxon_id AS main_taxon_id_4, s0_.brand_id AS brand_id_5, s0_.referenceable_content_id AS referenceable_content_id_6, s1_.owner_id AS owner_id_7 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_.id ASC
Parameters:
[
  [
    2379
  ]
]
11 0.63 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_.required AS required_6, s1_.multiple AS multiple_7, s1_.switcher AS switcher_8, s0_.main_taxon_id AS main_taxon_id_9, s0_.brand_id AS brand_id_10, s0_.referenceable_content_id AS referenceable_content_id_11 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:
[
  [
    2379
  ]
]
12 0.33 ms
SELECT s0_.id AS id_0, s1_.name AS name_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.translatable_id AS translatable_id_4 FROM sylius_product_option s0_ LEFT JOIN sylius_product_option_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    1
    2
    5
  ]
]
13 0.36 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, s0_.main_taxon_id AS main_taxon_id_16, s0_.brand_id AS brand_id_17, s0_.referenceable_content_id AS referenceable_content_id_18, s1_.product_id AS product_id_19, s1_.tax_category_id AS tax_category_id_20, s1_.shipping_category_id AS shipping_category_id_21 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
Parameters:
[
  [
    2379
  ]
]
14 0.61 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_.channel_code AS channel_code_4, s1_.id AS id_5, s0_.product_id AS product_id_6, s0_.tax_category_id AS tax_category_id_7, s0_.shipping_category_id AS shipping_category_id_8, s1_.product_variant_id AS product_variant_id_9 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
15 0.37 ms
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s0_.product_id AS product_id_3, s0_.tax_category_id AS tax_category_id_4, s0_.shipping_category_id AS shipping_category_id_5, s1_.option_id AS option_id_6 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
16 0.38 ms
SELECT s0_.id AS id_0, s1_.value AS value_1, s1_.id AS id_2, s1_.locale AS locale_3, s0_.option_id AS option_id_4, s1_.translatable_id AS translatable_id_5 FROM sylius_product_option_value s0_ LEFT JOIN sylius_product_option_value_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    0 => 21
    2 => 74
    4 => 71
    8 => 3
  ]
]
17 0.38 ms
SELECT t0.id AS id_1 FROM dedi_sylius_seo_content t0 WHERE t0.id = ?
Parameters:
[
  2214
]
18 0.30 ms
SELECT t0.id AS id_1 FROM dedi_sylius_seo_content t0 WHERE t0.id = ?
Parameters:
[
  2887
]
19 0.26 ms
SELECT t0.seo_not_indexable AS seo_not_indexable_1, t0.seo_metadata_title AS seo_metadata_title_2, t0.seo_metadata_description AS seo_metadata_description_3, t0.seo_og_metadata_title AS seo_og_metadata_title_4, t0.seo_og_metadata_description AS seo_og_metadata_description_5, t0.seo_og_metadata_url AS seo_og_metadata_url_6, t0.seo_og_metadata_image AS seo_og_metadata_image_7, t0.seo_og_metadata_type AS seo_og_metadata_type_8, t0.id AS id_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM dedi_sylius_seo_content_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  2887
  "en_US"
]
20 0.27 ms
SELECT t0.seo_not_indexable AS seo_not_indexable_1, t0.seo_metadata_title AS seo_metadata_title_2, t0.seo_metadata_description AS seo_metadata_description_3, t0.seo_og_metadata_title AS seo_og_metadata_title_4, t0.seo_og_metadata_description AS seo_og_metadata_description_5, t0.seo_og_metadata_url AS seo_og_metadata_url_6, t0.seo_og_metadata_image AS seo_og_metadata_image_7, t0.seo_og_metadata_type AS seo_og_metadata_type_8, t0.id AS id_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM dedi_sylius_seo_content_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  2214
  "en_US"
]
21 9.88 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_.ean AS ean_7, s0_.min_quantity AS min_quantity_8, s0_.min_price AS min_price_9, s0_.max_price AS max_price_10, s0_.markup AS markup_11, s0_.only_breakpoints AS only_breakpoints_12, s0_.seo_brand AS seo_brand_13, s0_.seo_gtin8 AS seo_gtin8_14, s0_.seo_gtin13 AS seo_gtin13_15, s0_.seo_gtin14 AS seo_gtin14_16, s0_.seo_mpn AS seo_mpn_17, s0_.seo_isbn AS seo_isbn_18, s0_.seo_sku AS seo_sku_19, s0_.seo_offer_aggregated AS seo_offer_aggregated_20, s1_.name AS name_21, s1_.slug AS slug_22, s1_.description AS description_23, s1_.meta_description AS meta_description_24, s1_.id AS id_25, s1_.short_description AS short_description_26, s1_.meta_keywords AS meta_keywords_27, s1_.locale AS locale_28, s0_.main_taxon_id AS main_taxon_id_29, s0_.brand_id AS brand_id_30, s0_.referenceable_content_id AS referenceable_content_id_31, s1_.translatable_id AS translatable_id_32 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:
[
  "en_US"
  "activ-drawstring-backpack-ap5002"
  1
  1
]
22 0.60 ms
SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s0_.main_taxon_id AS main_taxon_id_4, s0_.brand_id AS brand_id_5, s0_.referenceable_content_id AS referenceable_content_id_6, s1_.owner_id AS owner_id_7 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_.id ASC
Parameters:
[
  [
    2379
  ]
]
23 0.30 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_.required AS required_6, s1_.multiple AS multiple_7, s1_.switcher AS switcher_8, s0_.main_taxon_id AS main_taxon_id_9, s0_.brand_id AS brand_id_10, s0_.referenceable_content_id AS referenceable_content_id_11 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:
[
  [
    2379
  ]
]
24 0.21 ms
SELECT s0_.id AS id_0, s1_.name AS name_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.translatable_id AS translatable_id_4 FROM sylius_product_option s0_ LEFT JOIN sylius_product_option_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    1
    2
    5
  ]
]
25 0.25 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, s0_.main_taxon_id AS main_taxon_id_16, s0_.brand_id AS brand_id_17, s0_.referenceable_content_id AS referenceable_content_id_18, s1_.product_id AS product_id_19, s1_.tax_category_id AS tax_category_id_20, s1_.shipping_category_id AS shipping_category_id_21 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
Parameters:
[
  [
    2379
  ]
]
26 0.26 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_.channel_code AS channel_code_4, s1_.id AS id_5, s0_.product_id AS product_id_6, s0_.tax_category_id AS tax_category_id_7, s0_.shipping_category_id AS shipping_category_id_8, s1_.product_variant_id AS product_variant_id_9 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
27 0.26 ms
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s0_.product_id AS product_id_3, s0_.tax_category_id AS tax_category_id_4, s0_.shipping_category_id AS shipping_category_id_5, s1_.option_id AS option_id_6 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
28 0.20 ms
SELECT s0_.id AS id_0, s1_.value AS value_1, s1_.id AS id_2, s1_.locale AS locale_3, s0_.option_id AS option_id_4, s1_.translatable_id AS translatable_id_5 FROM sylius_product_option_value s0_ LEFT JOIN sylius_product_option_value_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    0 => 21
    2 => 74
    4 => 71
    8 => 3
  ]
]
29 0.17 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:
[
  2379
]
30 0.15 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.icon AS icon_10, t0.redirect AS redirect_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.menu_assoc_id AS menu_assoc_id_14 FROM sylius_taxon t0 WHERE t0.id = ?
Parameters:
[
  251
]
31 9.12 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.icon AS icon_10, t0.redirect AS redirect_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.menu_assoc_id AS menu_assoc_id_14 FROM sylius_taxon t0 WHERE t0.id = ?
Parameters:
[
  248
]
32 0.20 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.icon AS icon_10, t0.redirect AS redirect_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.menu_assoc_id AS menu_assoc_id_14 FROM sylius_taxon t0 WHERE t0.id = ?
Parameters:
[
  1
]
33 0.16 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.icon AS icon_10, t0.redirect AS redirect_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.menu_assoc_id AS menu_assoc_id_14 FROM sylius_taxon t0 WHERE t0.id = ?
Parameters:
[
  150
]
34 0.21 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  150
  "en_US"
]
35 0.14 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  1
  "en_US"
]
36 0.15 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  248
  "en_US"
]
37 0.15 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  251
  "en_US"
]
38 10.69 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.google_analytics_code AS google_analytics_code_17, t0.google_tag_manager_id AS google_tag_manager_id_18, t0.default_locale_id AS default_locale_id_19, t20.code AS code_21, t20.created_at AS created_at_22, t20.updated_at AS updated_at_23, t20.id AS id_24, t0.base_currency_id AS base_currency_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.default_tax_zone_id AS default_tax_zone_id_31, t0.menu_taxon_id AS menu_taxon_id_32, t0.shop_billing_data_id AS shop_billing_data_id_33, t0.referenceable_content_id AS referenceable_content_id_34 FROM sylius_channel t0 INNER JOIN sylius_locale t20 ON t0.default_locale_id = t20.id INNER JOIN sylius_currency t26 ON t0.base_currency_id = t26.id
Parameters:
[]
39 0.41 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_.ean AS ean_7, s0_.min_quantity AS min_quantity_8, s0_.min_price AS min_price_9, s0_.max_price AS max_price_10, s0_.markup AS markup_11, s0_.only_breakpoints AS only_breakpoints_12, s0_.seo_brand AS seo_brand_13, s0_.seo_gtin8 AS seo_gtin8_14, s0_.seo_gtin13 AS seo_gtin13_15, s0_.seo_gtin14 AS seo_gtin14_16, s0_.seo_mpn AS seo_mpn_17, s0_.seo_isbn AS seo_isbn_18, s0_.seo_sku AS seo_sku_19, s0_.seo_offer_aggregated AS seo_offer_aggregated_20, s1_.name AS name_21, s1_.slug AS slug_22, s1_.description AS description_23, s1_.meta_description AS meta_description_24, s1_.id AS id_25, s1_.short_description AS short_description_26, s1_.meta_keywords AS meta_keywords_27, s1_.locale AS locale_28, s0_.main_taxon_id AS main_taxon_id_29, s0_.brand_id AS brand_id_30, s0_.referenceable_content_id AS referenceable_content_id_31, s1_.translatable_id AS translatable_id_32 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:
[
  "en_US"
  "activ-drawstring-backpack-ap5002"
  1
  1
]
40 0.26 ms
SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s0_.main_taxon_id AS main_taxon_id_4, s0_.brand_id AS brand_id_5, s0_.referenceable_content_id AS referenceable_content_id_6, s1_.owner_id AS owner_id_7 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_.id ASC
Parameters:
[
  [
    2379
  ]
]
41 0.27 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_.required AS required_6, s1_.multiple AS multiple_7, s1_.switcher AS switcher_8, s0_.main_taxon_id AS main_taxon_id_9, s0_.brand_id AS brand_id_10, s0_.referenceable_content_id AS referenceable_content_id_11 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:
[
  [
    2379
  ]
]
42 0.22 ms
SELECT s0_.id AS id_0, s1_.name AS name_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.translatable_id AS translatable_id_4 FROM sylius_product_option s0_ LEFT JOIN sylius_product_option_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    1
    2
    5
  ]
]
43 0.25 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, s0_.main_taxon_id AS main_taxon_id_16, s0_.brand_id AS brand_id_17, s0_.referenceable_content_id AS referenceable_content_id_18, s1_.product_id AS product_id_19, s1_.tax_category_id AS tax_category_id_20, s1_.shipping_category_id AS shipping_category_id_21 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
Parameters:
[
  [
    2379
  ]
]
44 0.28 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_.channel_code AS channel_code_4, s1_.id AS id_5, s0_.product_id AS product_id_6, s0_.tax_category_id AS tax_category_id_7, s0_.shipping_category_id AS shipping_category_id_8, s1_.product_variant_id AS product_variant_id_9 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
45 0.28 ms
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s0_.product_id AS product_id_3, s0_.tax_category_id AS tax_category_id_4, s0_.shipping_category_id AS shipping_category_id_5, s1_.option_id AS option_id_6 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
46 0.20 ms
SELECT s0_.id AS id_0, s1_.value AS value_1, s1_.id AS id_2, s1_.locale AS locale_3, s0_.option_id AS option_id_4, s1_.translatable_id AS translatable_id_5 FROM sylius_product_option_value s0_ LEFT JOIN sylius_product_option_value_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    0 => 21
    2 => 74
    4 => 71
    8 => 3
  ]
]
47 0.64 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_.ean AS ean_7, s0_.min_quantity AS min_quantity_8, s0_.min_price AS min_price_9, s0_.max_price AS max_price_10, s0_.markup AS markup_11, s0_.only_breakpoints AS only_breakpoints_12, s0_.seo_brand AS seo_brand_13, s0_.seo_gtin8 AS seo_gtin8_14, s0_.seo_gtin13 AS seo_gtin13_15, s0_.seo_gtin14 AS seo_gtin14_16, s0_.seo_mpn AS seo_mpn_17, s0_.seo_isbn AS seo_isbn_18, s0_.seo_sku AS seo_sku_19, s0_.seo_offer_aggregated AS seo_offer_aggregated_20, s1_.name AS name_21, s1_.slug AS slug_22, s1_.description AS description_23, s1_.meta_description AS meta_description_24, s1_.id AS id_25, s1_.short_description AS short_description_26, s1_.meta_keywords AS meta_keywords_27, s1_.locale AS locale_28, s0_.main_taxon_id AS main_taxon_id_29, s0_.brand_id AS brand_id_30, s0_.referenceable_content_id AS referenceable_content_id_31, s1_.translatable_id AS translatable_id_32 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:
[
  "en_US"
  "activ-drawstring-backpack-ap5002"
  1
  1
]
48 0.30 ms
SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s0_.main_taxon_id AS main_taxon_id_4, s0_.brand_id AS brand_id_5, s0_.referenceable_content_id AS referenceable_content_id_6, s1_.owner_id AS owner_id_7 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_.id ASC
Parameters:
[
  [
    2379
  ]
]
49 0.28 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_.required AS required_6, s1_.multiple AS multiple_7, s1_.switcher AS switcher_8, s0_.main_taxon_id AS main_taxon_id_9, s0_.brand_id AS brand_id_10, s0_.referenceable_content_id AS referenceable_content_id_11 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:
[
  [
    2379
  ]
]
50 0.21 ms
SELECT s0_.id AS id_0, s1_.name AS name_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.translatable_id AS translatable_id_4 FROM sylius_product_option s0_ LEFT JOIN sylius_product_option_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    1
    2
    5
  ]
]
51 0.24 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, s0_.main_taxon_id AS main_taxon_id_16, s0_.brand_id AS brand_id_17, s0_.referenceable_content_id AS referenceable_content_id_18, s1_.product_id AS product_id_19, s1_.tax_category_id AS tax_category_id_20, s1_.shipping_category_id AS shipping_category_id_21 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
Parameters:
[
  [
    2379
  ]
]
52 0.25 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_.channel_code AS channel_code_4, s1_.id AS id_5, s0_.product_id AS product_id_6, s0_.tax_category_id AS tax_category_id_7, s0_.shipping_category_id AS shipping_category_id_8, s1_.product_variant_id AS product_variant_id_9 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
53 0.26 ms
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s0_.product_id AS product_id_3, s0_.tax_category_id AS tax_category_id_4, s0_.shipping_category_id AS shipping_category_id_5, s1_.option_id AS option_id_6 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
54 0.21 ms
SELECT s0_.id AS id_0, s1_.value AS value_1, s1_.id AS id_2, s1_.locale AS locale_3, s0_.option_id AS option_id_4, s1_.translatable_id AS translatable_id_5 FROM sylius_product_option_value s0_ LEFT JOIN sylius_product_option_value_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    0 => 21
    2 => 74
    4 => 71
    8 => 3
  ]
]
55 7.07 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_.icon AS icon_9, s0_.redirect AS redirect_10, s0_.code AS code_11, s0_.tree_left AS tree_left_12, s0_.tree_right AS tree_right_13, s0_.tree_level AS tree_level_14, s0_.position AS position_15, s0_.enabled AS enabled_16, s0_.id AS id_17, s0_.created_at AS created_at_18, s0_.updated_at AS updated_at_19, s0_.icon AS icon_20, s0_.redirect AS redirect_21, s1_.name AS name_22, s1_.slug AS slug_23, s1_.description AS description_24, s1_.id AS id_25, s1_.locale AS locale_26, s2_.code AS code_27, s2_.tree_left AS tree_left_28, s2_.tree_right AS tree_right_29, s2_.tree_level AS tree_level_30, s2_.position AS position_31, s2_.enabled AS enabled_32, s2_.id AS id_33, s2_.created_at AS created_at_34, s2_.updated_at AS updated_at_35, s2_.icon AS icon_36, s2_.redirect AS redirect_37, s0_.tree_root AS tree_root_38, s0_.parent_id AS parent_id_39, s0_.menu_assoc_id AS menu_assoc_id_40, s1_.translatable_id AS translatable_id_41, s2_.tree_root AS tree_root_42, s2_.parent_id AS parent_id_43, s2_.menu_assoc_id AS menu_assoc_id_44 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:
[
  "en_US"
  150
]
56 1.15 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_.icon AS icon_9, s0_.redirect AS redirect_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.description AS description_13, s1_.id AS id_14, s1_.locale AS locale_15, s2_.code AS code_16, s2_.tree_left AS tree_left_17, s2_.tree_right AS tree_right_18, s2_.tree_level AS tree_level_19, s2_.position AS position_20, s2_.enabled AS enabled_21, s2_.id AS id_22, s2_.created_at AS created_at_23, s2_.updated_at AS updated_at_24, s2_.icon AS icon_25, s2_.redirect AS redirect_26, s0_.tree_root AS tree_root_27, s0_.parent_id AS parent_id_28, s0_.menu_assoc_id AS menu_assoc_id_29, s1_.translatable_id AS translatable_id_30, s2_.tree_root AS tree_root_31, s2_.parent_id AS parent_id_32, s2_.menu_assoc_id AS menu_assoc_id_33 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:
[
  "en_US"
  1
  "menu"
]
57 0.65 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_.icon AS icon_9, s0_.redirect AS redirect_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.description AS description_13, s1_.id AS id_14, s1_.locale AS locale_15, s0_.tree_root AS tree_root_16, s0_.parent_id AS parent_id_17, s0_.menu_assoc_id AS menu_assoc_id_18, s1_.translatable_id AS translatable_id_19 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.enabled = ? AND s1_.slug = ? AND s1_.locale = ? ORDER BY s0_.id ASC
Parameters:
[
  1
  "all-categories"
  "en_US"
]
58 0.39 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_.ean AS ean_7, s0_.min_quantity AS min_quantity_8, s0_.min_price AS min_price_9, s0_.max_price AS max_price_10, s0_.markup AS markup_11, s0_.only_breakpoints AS only_breakpoints_12, s0_.seo_brand AS seo_brand_13, s0_.seo_gtin8 AS seo_gtin8_14, s0_.seo_gtin13 AS seo_gtin13_15, s0_.seo_gtin14 AS seo_gtin14_16, s0_.seo_mpn AS seo_mpn_17, s0_.seo_isbn AS seo_isbn_18, s0_.seo_sku AS seo_sku_19, s0_.seo_offer_aggregated AS seo_offer_aggregated_20, s1_.name AS name_21, s1_.slug AS slug_22, s1_.description AS description_23, s1_.meta_description AS meta_description_24, s1_.id AS id_25, s1_.short_description AS short_description_26, s1_.meta_keywords AS meta_keywords_27, s1_.locale AS locale_28, s0_.main_taxon_id AS main_taxon_id_29, s0_.brand_id AS brand_id_30, s0_.referenceable_content_id AS referenceable_content_id_31, s1_.translatable_id AS translatable_id_32 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:
[
  "en_US"
  "activ-drawstring-backpack-ap5002"
  1
  1
]
59 0.25 ms
SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s0_.main_taxon_id AS main_taxon_id_4, s0_.brand_id AS brand_id_5, s0_.referenceable_content_id AS referenceable_content_id_6, s1_.owner_id AS owner_id_7 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_.id ASC
Parameters:
[
  [
    2379
  ]
]
60 0.28 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_.required AS required_6, s1_.multiple AS multiple_7, s1_.switcher AS switcher_8, s0_.main_taxon_id AS main_taxon_id_9, s0_.brand_id AS brand_id_10, s0_.referenceable_content_id AS referenceable_content_id_11 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:
[
  [
    2379
  ]
]
61 0.22 ms
SELECT s0_.id AS id_0, s1_.name AS name_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.translatable_id AS translatable_id_4 FROM sylius_product_option s0_ LEFT JOIN sylius_product_option_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    1
    2
    5
  ]
]
62 0.25 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, s0_.main_taxon_id AS main_taxon_id_16, s0_.brand_id AS brand_id_17, s0_.referenceable_content_id AS referenceable_content_id_18, s1_.product_id AS product_id_19, s1_.tax_category_id AS tax_category_id_20, s1_.shipping_category_id AS shipping_category_id_21 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
Parameters:
[
  [
    2379
  ]
]
63 0.25 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_.channel_code AS channel_code_4, s1_.id AS id_5, s0_.product_id AS product_id_6, s0_.tax_category_id AS tax_category_id_7, s0_.shipping_category_id AS shipping_category_id_8, s1_.product_variant_id AS product_variant_id_9 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
64 0.28 ms
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s0_.product_id AS product_id_3, s0_.tax_category_id AS tax_category_id_4, s0_.shipping_category_id AS shipping_category_id_5, s1_.option_id AS option_id_6 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
65 0.20 ms
SELECT s0_.id AS id_0, s1_.value AS value_1, s1_.id AS id_2, s1_.locale AS locale_3, s0_.option_id AS option_id_4, s1_.translatable_id AS translatable_id_5 FROM sylius_product_option_value s0_ LEFT JOIN sylius_product_option_value_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    0 => 21
    2 => 74
    4 => 71
    8 => 3
  ]
]
66 0.53 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_.ean AS ean_7, s0_.min_quantity AS min_quantity_8, s0_.min_price AS min_price_9, s0_.max_price AS max_price_10, s0_.markup AS markup_11, s0_.only_breakpoints AS only_breakpoints_12, s0_.seo_brand AS seo_brand_13, s0_.seo_gtin8 AS seo_gtin8_14, s0_.seo_gtin13 AS seo_gtin13_15, s0_.seo_gtin14 AS seo_gtin14_16, s0_.seo_mpn AS seo_mpn_17, s0_.seo_isbn AS seo_isbn_18, s0_.seo_sku AS seo_sku_19, s0_.seo_offer_aggregated AS seo_offer_aggregated_20, s1_.name AS name_21, s1_.slug AS slug_22, s1_.description AS description_23, s1_.meta_description AS meta_description_24, s1_.id AS id_25, s1_.short_description AS short_description_26, s1_.meta_keywords AS meta_keywords_27, s1_.locale AS locale_28, s0_.main_taxon_id AS main_taxon_id_29, s0_.brand_id AS brand_id_30, s0_.referenceable_content_id AS referenceable_content_id_31, s1_.translatable_id AS translatable_id_32 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:
[
  "en_US"
  "activ-drawstring-backpack-ap5002"
  1
  1
]
67 0.42 ms
SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s0_.main_taxon_id AS main_taxon_id_4, s0_.brand_id AS brand_id_5, s0_.referenceable_content_id AS referenceable_content_id_6, s1_.owner_id AS owner_id_7 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_.id ASC
Parameters:
[
  [
    2379
  ]
]
68 0.45 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_.required AS required_6, s1_.multiple AS multiple_7, s1_.switcher AS switcher_8, s0_.main_taxon_id AS main_taxon_id_9, s0_.brand_id AS brand_id_10, s0_.referenceable_content_id AS referenceable_content_id_11 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:
[
  [
    2379
  ]
]
69 0.37 ms
SELECT s0_.id AS id_0, s1_.name AS name_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.translatable_id AS translatable_id_4 FROM sylius_product_option s0_ LEFT JOIN sylius_product_option_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    1
    2
    5
  ]
]
70 0.41 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, s0_.main_taxon_id AS main_taxon_id_16, s0_.brand_id AS brand_id_17, s0_.referenceable_content_id AS referenceable_content_id_18, s1_.product_id AS product_id_19, s1_.tax_category_id AS tax_category_id_20, s1_.shipping_category_id AS shipping_category_id_21 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
Parameters:
[
  [
    2379
  ]
]
71 0.44 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_.channel_code AS channel_code_4, s1_.id AS id_5, s0_.product_id AS product_id_6, s0_.tax_category_id AS tax_category_id_7, s0_.shipping_category_id AS shipping_category_id_8, s1_.product_variant_id AS product_variant_id_9 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
72 0.44 ms
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s0_.product_id AS product_id_3, s0_.tax_category_id AS tax_category_id_4, s0_.shipping_category_id AS shipping_category_id_5, s1_.option_id AS option_id_6 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
73 0.37 ms
SELECT s0_.id AS id_0, s1_.value AS value_1, s1_.id AS id_2, s1_.locale AS locale_3, s0_.option_id AS option_id_4, s1_.translatable_id AS translatable_id_5 FROM sylius_product_option_value s0_ LEFT JOIN sylius_product_option_value_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    0 => 21
    2 => 74
    4 => 71
    8 => 3
  ]
]
74 0.46 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_.icon AS icon_9, s0_.redirect AS redirect_10, s0_.code AS code_11, s0_.tree_left AS tree_left_12, s0_.tree_right AS tree_right_13, s0_.tree_level AS tree_level_14, s0_.position AS position_15, s0_.enabled AS enabled_16, s0_.id AS id_17, s0_.created_at AS created_at_18, s0_.updated_at AS updated_at_19, s0_.icon AS icon_20, s0_.redirect AS redirect_21, s1_.name AS name_22, s1_.slug AS slug_23, s1_.description AS description_24, s1_.id AS id_25, s1_.locale AS locale_26, s2_.code AS code_27, s2_.tree_left AS tree_left_28, s2_.tree_right AS tree_right_29, s2_.tree_level AS tree_level_30, s2_.position AS position_31, s2_.enabled AS enabled_32, s2_.id AS id_33, s2_.created_at AS created_at_34, s2_.updated_at AS updated_at_35, s2_.icon AS icon_36, s2_.redirect AS redirect_37, s0_.tree_root AS tree_root_38, s0_.parent_id AS parent_id_39, s0_.menu_assoc_id AS menu_assoc_id_40, s1_.translatable_id AS translatable_id_41, s2_.tree_root AS tree_root_42, s2_.parent_id AS parent_id_43, s2_.menu_assoc_id AS menu_assoc_id_44 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:
[
  "en_US"
  248
]
75 0.41 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_.icon AS icon_9, s0_.redirect AS redirect_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.description AS description_13, s1_.id AS id_14, s1_.locale AS locale_15, s2_.code AS code_16, s2_.tree_left AS tree_left_17, s2_.tree_right AS tree_right_18, s2_.tree_level AS tree_level_19, s2_.position AS position_20, s2_.enabled AS enabled_21, s2_.id AS id_22, s2_.created_at AS created_at_23, s2_.updated_at AS updated_at_24, s2_.icon AS icon_25, s2_.redirect AS redirect_26, s0_.tree_root AS tree_root_27, s0_.parent_id AS parent_id_28, s0_.menu_assoc_id AS menu_assoc_id_29, s1_.translatable_id AS translatable_id_30, s2_.tree_root AS tree_root_31, s2_.parent_id AS parent_id_32, s2_.menu_assoc_id AS menu_assoc_id_33 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:
[
  "en_US"
  1
  "koozie-bags"
]
76 0.25 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_.icon AS icon_9, s0_.redirect AS redirect_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.description AS description_13, s1_.id AS id_14, s1_.locale AS locale_15, s0_.tree_root AS tree_root_16, s0_.parent_id AS parent_id_17, s0_.menu_assoc_id AS menu_assoc_id_18, s1_.translatable_id AS translatable_id_19 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.enabled = ? AND s1_.slug = ? AND s1_.locale = ? ORDER BY s0_.id ASC
Parameters:
[
  1
  "backpacks-216"
  "en_US"
]
77 0.41 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_.ean AS ean_7, s0_.min_quantity AS min_quantity_8, s0_.min_price AS min_price_9, s0_.max_price AS max_price_10, s0_.markup AS markup_11, s0_.only_breakpoints AS only_breakpoints_12, s0_.seo_brand AS seo_brand_13, s0_.seo_gtin8 AS seo_gtin8_14, s0_.seo_gtin13 AS seo_gtin13_15, s0_.seo_gtin14 AS seo_gtin14_16, s0_.seo_mpn AS seo_mpn_17, s0_.seo_isbn AS seo_isbn_18, s0_.seo_sku AS seo_sku_19, s0_.seo_offer_aggregated AS seo_offer_aggregated_20, s1_.name AS name_21, s1_.slug AS slug_22, s1_.description AS description_23, s1_.meta_description AS meta_description_24, s1_.id AS id_25, s1_.short_description AS short_description_26, s1_.meta_keywords AS meta_keywords_27, s1_.locale AS locale_28, s0_.main_taxon_id AS main_taxon_id_29, s0_.brand_id AS brand_id_30, s0_.referenceable_content_id AS referenceable_content_id_31, s1_.translatable_id AS translatable_id_32 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:
[
  "en_US"
  "activ-drawstring-backpack-ap5002"
  1
  1
]
78 0.24 ms
SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s0_.main_taxon_id AS main_taxon_id_4, s0_.brand_id AS brand_id_5, s0_.referenceable_content_id AS referenceable_content_id_6, s1_.owner_id AS owner_id_7 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_.id ASC
Parameters:
[
  [
    2379
  ]
]
79 0.27 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_.required AS required_6, s1_.multiple AS multiple_7, s1_.switcher AS switcher_8, s0_.main_taxon_id AS main_taxon_id_9, s0_.brand_id AS brand_id_10, s0_.referenceable_content_id AS referenceable_content_id_11 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:
[
  [
    2379
  ]
]
80 0.20 ms
SELECT s0_.id AS id_0, s1_.name AS name_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.translatable_id AS translatable_id_4 FROM sylius_product_option s0_ LEFT JOIN sylius_product_option_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    1
    2
    5
  ]
]
81 0.27 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, s0_.main_taxon_id AS main_taxon_id_16, s0_.brand_id AS brand_id_17, s0_.referenceable_content_id AS referenceable_content_id_18, s1_.product_id AS product_id_19, s1_.tax_category_id AS tax_category_id_20, s1_.shipping_category_id AS shipping_category_id_21 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
Parameters:
[
  [
    2379
  ]
]
82 0.25 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_.channel_code AS channel_code_4, s1_.id AS id_5, s0_.product_id AS product_id_6, s0_.tax_category_id AS tax_category_id_7, s0_.shipping_category_id AS shipping_category_id_8, s1_.product_variant_id AS product_variant_id_9 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
83 0.33 ms
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s0_.product_id AS product_id_3, s0_.tax_category_id AS tax_category_id_4, s0_.shipping_category_id AS shipping_category_id_5, s1_.option_id AS option_id_6 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
84 0.22 ms
SELECT s0_.id AS id_0, s1_.value AS value_1, s1_.id AS id_2, s1_.locale AS locale_3, s0_.option_id AS option_id_4, s1_.translatable_id AS translatable_id_5 FROM sylius_product_option_value s0_ LEFT JOIN sylius_product_option_value_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    0 => 21
    2 => 74
    4 => 71
    8 => 3
  ]
]
85 0.25 ms
SELECT COUNT(s0_.id) AS sclr_0 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 = 1
Parameters:
[
  "en_US"
  "products/label/top/taxon/bags-4/5"
  1
]
86 0.21 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_.icon AS icon_9, s0_.redirect AS redirect_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.description AS description_13, s1_.id AS id_14, s1_.locale AS locale_15, s0_.tree_root AS tree_root_16, s0_.parent_id AS parent_id_17, s0_.menu_assoc_id AS menu_assoc_id_18, s1_.translatable_id AS translatable_id_19 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.enabled = ? AND s1_.slug = ? AND s1_.locale = ? ORDER BY s0_.id ASC
Parameters:
[
  1
  "products/label/top/taxon/bags-4/5"
  "en_US"
]
87 0.22 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_.icon AS icon_9, s0_.redirect AS redirect_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.description AS description_13, s1_.id AS id_14, s1_.locale AS locale_15, s0_.tree_root AS tree_root_16, s0_.parent_id AS parent_id_17, s0_.menu_assoc_id AS menu_assoc_id_18, s1_.translatable_id AS translatable_id_19 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.enabled = ? AND s1_.slug = ? AND s1_.locale = ? ORDER BY s0_.id ASC
Parameters:
[
  1
  "bags-4"
  "en_US"
]
88 1.42 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_.ean AS ean_7, s0_.min_quantity AS min_quantity_8, s0_.min_price AS min_price_9, s0_.max_price AS max_price_10, s0_.markup AS markup_11, s0_.only_breakpoints AS only_breakpoints_12, s0_.seo_brand AS seo_brand_13, s0_.seo_gtin8 AS seo_gtin8_14, s0_.seo_gtin13 AS seo_gtin13_15, s0_.seo_gtin14 AS seo_gtin14_16, s0_.seo_mpn AS seo_mpn_17, s0_.seo_isbn AS seo_isbn_18, s0_.seo_sku AS seo_sku_19, s0_.seo_offer_aggregated AS seo_offer_aggregated_20, s0_.main_taxon_id AS main_taxon_id_21, s0_.brand_id AS brand_id_22, s0_.referenceable_content_id AS referenceable_content_id_23 FROM sylius_product s0_ INNER JOIN sylius_product_channels s2_ ON s0_.id = s2_.product_id INNER JOIN sylius_channel s1_ ON s1_.id = s2_.channel_id INNER JOIN tavy315_sylius_product_labels t4_ ON s0_.id = t4_.product_id INNER JOIN tavy315_sylius_product_label t3_ ON t3_.id = t4_.label_id INNER JOIN sylius_taxon s5_ ON s0_.main_taxon_id = s5_.id WHERE s1_.id = ? AND s0_.enabled = 1 AND t3_.code = ? AND s5_.tree_left >= ? AND s5_.tree_right <= ? AND s5_.tree_root = ? ORDER BY s0_.id ASC LIMIT 5
Parameters:
[
  1
  "top"
  671
  682
  150
]
89 0.24 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_.icon AS icon_9, s0_.redirect AS redirect_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.description AS description_13, s1_.id AS id_14, s1_.locale AS locale_15, s0_.tree_root AS tree_root_16, s0_.parent_id AS parent_id_17, s0_.menu_assoc_id AS menu_assoc_id_18, s1_.translatable_id AS translatable_id_19 FROM sylius_taxon s0_ INNER JOIN sylius_taxon_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.enabled = ? AND s1_.slug = ? AND s1_.locale = ? ORDER BY s0_.id ASC
Parameters:
[
  1
  "bags-4"
  "en_US"
]
90 0.44 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_.ean AS ean_7, s0_.min_quantity AS min_quantity_8, s0_.min_price AS min_price_9, s0_.max_price AS max_price_10, s0_.markup AS markup_11, s0_.only_breakpoints AS only_breakpoints_12, s0_.seo_brand AS seo_brand_13, s0_.seo_gtin8 AS seo_gtin8_14, s0_.seo_gtin13 AS seo_gtin13_15, s0_.seo_gtin14 AS seo_gtin14_16, s0_.seo_mpn AS seo_mpn_17, s0_.seo_isbn AS seo_isbn_18, s0_.seo_sku AS seo_sku_19, s0_.seo_offer_aggregated AS seo_offer_aggregated_20, s1_.name AS name_21, s1_.slug AS slug_22, s1_.description AS description_23, s1_.meta_description AS meta_description_24, s1_.id AS id_25, s1_.short_description AS short_description_26, s1_.meta_keywords AS meta_keywords_27, s1_.locale AS locale_28, s0_.main_taxon_id AS main_taxon_id_29, s0_.brand_id AS brand_id_30, s0_.referenceable_content_id AS referenceable_content_id_31, s1_.translatable_id AS translatable_id_32 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:
[
  "en_US"
  "activ-drawstring-backpack-ap5002"
  1
  1
]
91 0.26 ms
SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s0_.main_taxon_id AS main_taxon_id_4, s0_.brand_id AS brand_id_5, s0_.referenceable_content_id AS referenceable_content_id_6, s1_.owner_id AS owner_id_7 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_.id ASC
Parameters:
[
  [
    2379
  ]
]
92 0.26 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_.required AS required_6, s1_.multiple AS multiple_7, s1_.switcher AS switcher_8, s0_.main_taxon_id AS main_taxon_id_9, s0_.brand_id AS brand_id_10, s0_.referenceable_content_id AS referenceable_content_id_11 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:
[
  [
    2379
  ]
]
93 0.21 ms
SELECT s0_.id AS id_0, s1_.name AS name_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.translatable_id AS translatable_id_4 FROM sylius_product_option s0_ LEFT JOIN sylius_product_option_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    1
    2
    5
  ]
]
94 0.25 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, s0_.main_taxon_id AS main_taxon_id_16, s0_.brand_id AS brand_id_17, s0_.referenceable_content_id AS referenceable_content_id_18, s1_.product_id AS product_id_19, s1_.tax_category_id AS tax_category_id_20, s1_.shipping_category_id AS shipping_category_id_21 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
Parameters:
[
  [
    2379
  ]
]
95 0.26 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_.channel_code AS channel_code_4, s1_.id AS id_5, s0_.product_id AS product_id_6, s0_.tax_category_id AS tax_category_id_7, s0_.shipping_category_id AS shipping_category_id_8, s1_.product_variant_id AS product_variant_id_9 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
96 0.30 ms
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s0_.product_id AS product_id_3, s0_.tax_category_id AS tax_category_id_4, s0_.shipping_category_id AS shipping_category_id_5, s1_.option_id AS option_id_6 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
97 0.21 ms
SELECT s0_.id AS id_0, s1_.value AS value_1, s1_.id AS id_2, s1_.locale AS locale_3, s0_.option_id AS option_id_4, s1_.translatable_id AS translatable_id_5 FROM sylius_product_option_value s0_ LEFT JOIN sylius_product_option_value_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    0 => 21
    2 => 74
    4 => 71
    8 => 3
  ]
]
98 0.30 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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ?
Parameters:
[
  1692
]
99 0.23 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  8441
]
100 0.19 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  8442
]
101 0.20 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  10196
]
102 0.18 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  10197
]
103 0.19 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  10198
]
104 0.18 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  25871
]
105 0.20 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.channel_code AS channel_code_4, t0.id AS id_5, t0.product_variant_id AS product_variant_id_6 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC
Parameters:
[
  8441
]
106 0.17 ms
SELECT t0.price AS price_1, t0.qty AS qty_2, t0.id AS id_3, t0.manufacturer_price AS manufacturer_price_4, t0.channel_id AS channel_id_5, t0.product_variant_id AS product_variant_id_6, t0.customer_group_id AS customer_group_id_7 FROM brille24_tierprice t0 WHERE t0.product_variant_id = ?
Parameters:
[
  8441
]
107 0.19 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_description AS meta_description_4, t0.id AS id_5, t0.short_description AS short_description_6, t0.meta_keywords AS meta_keywords_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  1692
  "en_US"
]
108 0.16 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.id ASC
Parameters:
[
  1692
]
109 0.23 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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ?
Parameters:
[
  2377
]
110 0.20 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  9817
]
111 0.18 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  9818
]
112 0.19 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  15973
]
113 0.19 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  15974
]
114 0.19 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  15975
]
115 0.19 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  26070
]
116 0.17 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.channel_code AS channel_code_4, t0.id AS id_5, t0.product_variant_id AS product_variant_id_6 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC
Parameters:
[
  9817
]
117 0.16 ms
SELECT t0.price AS price_1, t0.qty AS qty_2, t0.id AS id_3, t0.manufacturer_price AS manufacturer_price_4, t0.channel_id AS channel_id_5, t0.product_variant_id AS product_variant_id_6, t0.customer_group_id AS customer_group_id_7 FROM brille24_tierprice t0 WHERE t0.product_variant_id = ?
Parameters:
[
  9817
]
118 0.17 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_description AS meta_description_4, t0.id AS id_5, t0.short_description AS short_description_6, t0.meta_keywords AS meta_keywords_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  2377
  "en_US"
]
119 0.16 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.id ASC
Parameters:
[
  2377
]
120 0.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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ?
Parameters:
[
  2393
]
121 0.20 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  9849
]
122 0.19 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  9850
]
123 0.18 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  16037
]
124 0.19 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  16038
]
125 0.18 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  16039
]
126 0.16 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.channel_code AS channel_code_4, t0.id AS id_5, t0.product_variant_id AS product_variant_id_6 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC
Parameters:
[
  9849
]
127 0.16 ms
SELECT t0.price AS price_1, t0.qty AS qty_2, t0.id AS id_3, t0.manufacturer_price AS manufacturer_price_4, t0.channel_id AS channel_id_5, t0.product_variant_id AS product_variant_id_6, t0.customer_group_id AS customer_group_id_7 FROM brille24_tierprice t0 WHERE t0.product_variant_id = ?
Parameters:
[
  9849
]
128 0.17 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_description AS meta_description_4, t0.id AS id_5, t0.short_description AS short_description_6, t0.meta_keywords AS meta_keywords_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  2393
  "en_US"
]
129 0.16 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.id ASC
Parameters:
[
  2393
]
130 0.21 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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ?
Parameters:
[
  2460
]
131 0.20 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  10351
]
132 0.19 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  10352
]
133 0.20 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  10353
]
134 0.18 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  10354
]
135 0.18 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  10355
]
136 0.16 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.channel_code AS channel_code_4, t0.id AS id_5, t0.product_variant_id AS product_variant_id_6 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC
Parameters:
[
  10351
]
137 0.20 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
138 0.16 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
139 0.16 ms
SELECT t0.price AS price_1, t0.qty AS qty_2, t0.id AS id_3, t0.manufacturer_price AS manufacturer_price_4, t0.channel_id AS channel_id_5, t0.product_variant_id AS product_variant_id_6, t0.customer_group_id AS customer_group_id_7 FROM brille24_tierprice t0 WHERE t0.product_variant_id = ?
Parameters:
[
  10351
]
140 0.16 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_description AS meta_description_4, t0.id AS id_5, t0.short_description AS short_description_6, t0.meta_keywords AS meta_keywords_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  2460
  "en_US"
]
141 0.15 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.id ASC
Parameters:
[
  2460
]
142 0.19 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.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = ?
Parameters:
[
  2473
]
143 0.20 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  10728
]
144 0.18 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  10729
]
145 0.18 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  10730
]
146 0.19 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  10731
]
147 0.19 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 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:
[
  10732
]
148 0.16 ms
SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.channel_code AS channel_code_4, t0.id AS id_5, t0.product_variant_id AS product_variant_id_6 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = ? ORDER BY t0.id ASC
Parameters:
[
  10728
]
149 0.17 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
150 0.16 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
151 0.16 ms
SELECT t0.price AS price_1, t0.qty AS qty_2, t0.id AS id_3, t0.manufacturer_price AS manufacturer_price_4, t0.channel_id AS channel_id_5, t0.product_variant_id AS product_variant_id_6, t0.customer_group_id AS customer_group_id_7 FROM brille24_tierprice t0 WHERE t0.product_variant_id = ?
Parameters:
[
  10728
]
152 0.15 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.meta_description AS meta_description_4, t0.id AS id_5, t0.short_description AS short_description_6, t0.meta_keywords AS meta_keywords_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM sylius_product_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  2473
  "en_US"
]
153 0.15 ms
SELECT t0.type AS type_1, t0.path AS path_2, t0.id AS id_3, t0.owner_id AS owner_id_4 FROM sylius_product_image t0 WHERE t0.owner_id = ? ORDER BY t0.id ASC
Parameters:
[
  2473
]
154 0.48 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_.ean AS ean_7, s0_.min_quantity AS min_quantity_8, s0_.min_price AS min_price_9, s0_.max_price AS max_price_10, s0_.markup AS markup_11, s0_.only_breakpoints AS only_breakpoints_12, s0_.seo_brand AS seo_brand_13, s0_.seo_gtin8 AS seo_gtin8_14, s0_.seo_gtin13 AS seo_gtin13_15, s0_.seo_gtin14 AS seo_gtin14_16, s0_.seo_mpn AS seo_mpn_17, s0_.seo_isbn AS seo_isbn_18, s0_.seo_sku AS seo_sku_19, s0_.seo_offer_aggregated AS seo_offer_aggregated_20, s1_.name AS name_21, s1_.slug AS slug_22, s1_.description AS description_23, s1_.meta_description AS meta_description_24, s1_.id AS id_25, s1_.short_description AS short_description_26, s1_.meta_keywords AS meta_keywords_27, s1_.locale AS locale_28, s0_.main_taxon_id AS main_taxon_id_29, s0_.brand_id AS brand_id_30, s0_.referenceable_content_id AS referenceable_content_id_31, s1_.translatable_id AS translatable_id_32 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:
[
  "en_US"
  "activ-drawstring-backpack-ap5002"
  1
  1
]
155 0.26 ms
SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s0_.main_taxon_id AS main_taxon_id_4, s0_.brand_id AS brand_id_5, s0_.referenceable_content_id AS referenceable_content_id_6, s1_.owner_id AS owner_id_7 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_.id ASC
Parameters:
[
  [
    2379
  ]
]
156 0.27 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_.required AS required_6, s1_.multiple AS multiple_7, s1_.switcher AS switcher_8, s0_.main_taxon_id AS main_taxon_id_9, s0_.brand_id AS brand_id_10, s0_.referenceable_content_id AS referenceable_content_id_11 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:
[
  [
    2379
  ]
]
157 0.20 ms
SELECT s0_.id AS id_0, s1_.name AS name_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.translatable_id AS translatable_id_4 FROM sylius_product_option s0_ LEFT JOIN sylius_product_option_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    1
    2
    5
  ]
]
158 0.25 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, s0_.main_taxon_id AS main_taxon_id_16, s0_.brand_id AS brand_id_17, s0_.referenceable_content_id AS referenceable_content_id_18, s1_.product_id AS product_id_19, s1_.tax_category_id AS tax_category_id_20, s1_.shipping_category_id AS shipping_category_id_21 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
Parameters:
[
  [
    2379
  ]
]
159 0.25 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_.channel_code AS channel_code_4, s1_.id AS id_5, s0_.product_id AS product_id_6, s0_.tax_category_id AS tax_category_id_7, s0_.shipping_category_id AS shipping_category_id_8, s1_.product_variant_id AS product_variant_id_9 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
160 0.27 ms
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s0_.product_id AS product_id_3, s0_.tax_category_id AS tax_category_id_4, s0_.shipping_category_id AS shipping_category_id_5, s1_.option_id AS option_id_6 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
161 0.21 ms
SELECT s0_.id AS id_0, s1_.value AS value_1, s1_.id AS id_2, s1_.locale AS locale_3, s0_.option_id AS option_id_4, s1_.translatable_id AS translatable_id_5 FROM sylius_product_option_value s0_ LEFT JOIN sylius_product_option_value_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    0 => 21
    2 => 74
    4 => 71
    8 => 3
  ]
]
162 0.22 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:
[
  2379
]
163 0.20 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
164 0.16 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
165 0.17 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
166 0.16 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
167 0.17 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
168 0.16 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
169 0.16 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
170 0.16 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
171 0.16 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
172 0.17 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
173 0.16 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
174 0.16 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
175 0.17 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
176 0.20 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
177 0.17 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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.category_id AS category_id_9, t0.zone_id AS zone_id_10 FROM sylius_tax_rate t0 WHERE t0.category_id = ? AND t0.zone_id = ? LIMIT 1
Parameters:
[
  1
  1
]
178 0.61 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 FROM sylius_product_option_value t0 WHERE t0.option_id = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
179 0.36 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 FROM sylius_product_option_value t0 WHERE t0.option_id = ? ORDER BY t0.id ASC
Parameters:
[
  2
]
180 0.14 ms
SELECT t0.code AS code_1, t0.id AS id_2, t0.option_id AS option_id_3 FROM sylius_product_option_value t0 WHERE t0.option_id = ? ORDER BY t0.id ASC
Parameters:
[
  5
]
181 0.20 ms
SELECT t0.price AS price_1, t0.qty AS qty_2, t0.id AS id_3, t0.manufacturer_price AS manufacturer_price_4, t0.channel_id AS channel_id_5, t0.product_variant_id AS product_variant_id_6, t0.customer_group_id AS customer_group_id_7 FROM brille24_tierprice t0 WHERE t0.product_variant_id = ?
Parameters:
[
  9821
]
182 0.16 ms
SELECT t0.price AS price_1, t0.qty AS qty_2, t0.id AS id_3, t0.manufacturer_price AS manufacturer_price_4, t0.channel_id AS channel_id_5, t0.product_variant_id AS product_variant_id_6, t0.customer_group_id AS customer_group_id_7 FROM brille24_tierprice t0 WHERE t0.product_variant_id = ?
Parameters:
[
  9822
]
183 0.15 ms
SELECT t0.price AS price_1, t0.qty AS qty_2, t0.id AS id_3, t0.manufacturer_price AS manufacturer_price_4, t0.channel_id AS channel_id_5, t0.product_variant_id AS product_variant_id_6, t0.customer_group_id AS customer_group_id_7 FROM brille24_tierprice t0 WHERE t0.product_variant_id = ?
Parameters:
[
  15987
]
184 0.15 ms
SELECT t0.price AS price_1, t0.qty AS qty_2, t0.id AS id_3, t0.manufacturer_price AS manufacturer_price_4, t0.channel_id AS channel_id_5, t0.product_variant_id AS product_variant_id_6, t0.customer_group_id AS customer_group_id_7 FROM brille24_tierprice t0 WHERE t0.product_variant_id = ?
Parameters:
[
  15988
]
185 0.31 ms
SELECT t0.price AS price_1, t0.qty AS qty_2, t0.id AS id_3, t0.manufacturer_price AS manufacturer_price_4, t0.channel_id AS channel_id_5, t0.product_variant_id AS product_variant_id_6, t0.customer_group_id AS customer_group_id_7 FROM brille24_tierprice t0 WHERE t0.product_variant_id = ?
Parameters:
[
  15989
]
186 0.16 ms
SELECT t0.type AS type_1, t0.mime_type AS mime_type_2, t0.path AS path_3, t0.id AS id_4, t0.owner_id AS owner_id_5 FROM sylius_product_file t0 WHERE t0.owner_id = ?
Parameters:
[
  2379
]
187 0.52 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_.ean AS ean_7, s0_.min_quantity AS min_quantity_8, s0_.min_price AS min_price_9, s0_.max_price AS max_price_10, s0_.markup AS markup_11, s0_.only_breakpoints AS only_breakpoints_12, s0_.seo_brand AS seo_brand_13, s0_.seo_gtin8 AS seo_gtin8_14, s0_.seo_gtin13 AS seo_gtin13_15, s0_.seo_gtin14 AS seo_gtin14_16, s0_.seo_mpn AS seo_mpn_17, s0_.seo_isbn AS seo_isbn_18, s0_.seo_sku AS seo_sku_19, s0_.seo_offer_aggregated AS seo_offer_aggregated_20, s1_.name AS name_21, s1_.slug AS slug_22, s1_.description AS description_23, s1_.meta_description AS meta_description_24, s1_.id AS id_25, s1_.short_description AS short_description_26, s1_.meta_keywords AS meta_keywords_27, s1_.locale AS locale_28, s0_.main_taxon_id AS main_taxon_id_29, s0_.brand_id AS brand_id_30, s0_.referenceable_content_id AS referenceable_content_id_31, s1_.translatable_id AS translatable_id_32 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:
[
  "en_US"
  "activ-drawstring-backpack-ap5002"
  1
  1
]
188 0.41 ms
SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s0_.main_taxon_id AS main_taxon_id_4, s0_.brand_id AS brand_id_5, s0_.referenceable_content_id AS referenceable_content_id_6, s1_.owner_id AS owner_id_7 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_.id ASC
Parameters:
[
  [
    2379
  ]
]
189 0.44 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_.required AS required_6, s1_.multiple AS multiple_7, s1_.switcher AS switcher_8, s0_.main_taxon_id AS main_taxon_id_9, s0_.brand_id AS brand_id_10, s0_.referenceable_content_id AS referenceable_content_id_11 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:
[
  [
    2379
  ]
]
190 0.37 ms
SELECT s0_.id AS id_0, s1_.name AS name_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.translatable_id AS translatable_id_4 FROM sylius_product_option s0_ LEFT JOIN sylius_product_option_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    1
    2
    5
  ]
]
191 0.43 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, s0_.main_taxon_id AS main_taxon_id_16, s0_.brand_id AS brand_id_17, s0_.referenceable_content_id AS referenceable_content_id_18, s1_.product_id AS product_id_19, s1_.tax_category_id AS tax_category_id_20, s1_.shipping_category_id AS shipping_category_id_21 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
Parameters:
[
  [
    2379
  ]
]
192 0.26 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_.channel_code AS channel_code_4, s1_.id AS id_5, s0_.product_id AS product_id_6, s0_.tax_category_id AS tax_category_id_7, s0_.shipping_category_id AS shipping_category_id_8, s1_.product_variant_id AS product_variant_id_9 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
193 0.26 ms
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s0_.product_id AS product_id_3, s0_.tax_category_id AS tax_category_id_4, s0_.shipping_category_id AS shipping_category_id_5, s1_.option_id AS option_id_6 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
194 0.20 ms
SELECT s0_.id AS id_0, s1_.value AS value_1, s1_.id AS id_2, s1_.locale AS locale_3, s0_.option_id AS option_id_4, s1_.translatable_id AS translatable_id_5 FROM sylius_product_option_value s0_ LEFT JOIN sylius_product_option_value_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    0 => 21
    2 => 74
    4 => 71
    8 => 3
  ]
]
195 0.38 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:
[
  2379
]
196 7.07 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_.icon AS icon_9, s0_.redirect AS redirect_10, s0_.code AS code_11, s0_.tree_left AS tree_left_12, s0_.tree_right AS tree_right_13, s0_.tree_level AS tree_level_14, s0_.position AS position_15, s0_.enabled AS enabled_16, s0_.id AS id_17, s0_.created_at AS created_at_18, s0_.updated_at AS updated_at_19, s0_.icon AS icon_20, s0_.redirect AS redirect_21, s1_.name AS name_22, s1_.slug AS slug_23, s1_.description AS description_24, s1_.id AS id_25, s1_.locale AS locale_26, s2_.code AS code_27, s2_.tree_left AS tree_left_28, s2_.tree_right AS tree_right_29, s2_.tree_level AS tree_level_30, s2_.position AS position_31, s2_.enabled AS enabled_32, s2_.id AS id_33, s2_.created_at AS created_at_34, s2_.updated_at AS updated_at_35, s2_.icon AS icon_36, s2_.redirect AS redirect_37, s0_.tree_root AS tree_root_38, s0_.parent_id AS parent_id_39, s0_.menu_assoc_id AS menu_assoc_id_40, s1_.translatable_id AS translatable_id_41, s2_.tree_root AS tree_root_42, s2_.parent_id AS parent_id_43, s2_.menu_assoc_id AS menu_assoc_id_44 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:
[
  "en_US"
  150
]
197 0.95 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_.icon AS icon_9, s0_.redirect AS redirect_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.description AS description_13, s1_.id AS id_14, s1_.locale AS locale_15, s2_.code AS code_16, s2_.tree_left AS tree_left_17, s2_.tree_right AS tree_right_18, s2_.tree_level AS tree_level_19, s2_.position AS position_20, s2_.enabled AS enabled_21, s2_.id AS id_22, s2_.created_at AS created_at_23, s2_.updated_at AS updated_at_24, s2_.icon AS icon_25, s2_.redirect AS redirect_26, s0_.tree_root AS tree_root_27, s0_.parent_id AS parent_id_28, s0_.menu_assoc_id AS menu_assoc_id_29, s1_.translatable_id AS translatable_id_30, s2_.tree_root AS tree_root_31, s2_.parent_id AS parent_id_32, s2_.menu_assoc_id AS menu_assoc_id_33 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:
[
  "en_US"
  1
  "menu"
]
198 0.53 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_.ean AS ean_7, s0_.min_quantity AS min_quantity_8, s0_.min_price AS min_price_9, s0_.max_price AS max_price_10, s0_.markup AS markup_11, s0_.only_breakpoints AS only_breakpoints_12, s0_.seo_brand AS seo_brand_13, s0_.seo_gtin8 AS seo_gtin8_14, s0_.seo_gtin13 AS seo_gtin13_15, s0_.seo_gtin14 AS seo_gtin14_16, s0_.seo_mpn AS seo_mpn_17, s0_.seo_isbn AS seo_isbn_18, s0_.seo_sku AS seo_sku_19, s0_.seo_offer_aggregated AS seo_offer_aggregated_20, s1_.name AS name_21, s1_.slug AS slug_22, s1_.description AS description_23, s1_.meta_description AS meta_description_24, s1_.id AS id_25, s1_.short_description AS short_description_26, s1_.meta_keywords AS meta_keywords_27, s1_.locale AS locale_28, s0_.main_taxon_id AS main_taxon_id_29, s0_.brand_id AS brand_id_30, s0_.referenceable_content_id AS referenceable_content_id_31, s1_.translatable_id AS translatable_id_32 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:
[
  "en_US"
  "activ-drawstring-backpack-ap5002"
  1
  1
]
199 0.43 ms
SELECT s0_.id AS id_0, s1_.type AS type_1, s1_.path AS path_2, s1_.id AS id_3, s0_.main_taxon_id AS main_taxon_id_4, s0_.brand_id AS brand_id_5, s0_.referenceable_content_id AS referenceable_content_id_6, s1_.owner_id AS owner_id_7 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_.id ASC
Parameters:
[
  [
    2379
  ]
]
200 0.62 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_.required AS required_6, s1_.multiple AS multiple_7, s1_.switcher AS switcher_8, s0_.main_taxon_id AS main_taxon_id_9, s0_.brand_id AS brand_id_10, s0_.referenceable_content_id AS referenceable_content_id_11 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:
[
  [
    2379
  ]
]
201 0.37 ms
SELECT s0_.id AS id_0, s1_.name AS name_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.translatable_id AS translatable_id_4 FROM sylius_product_option s0_ LEFT JOIN sylius_product_option_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    1
    2
    5
  ]
]
202 0.41 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, s0_.main_taxon_id AS main_taxon_id_16, s0_.brand_id AS brand_id_17, s0_.referenceable_content_id AS referenceable_content_id_18, s1_.product_id AS product_id_19, s1_.tax_category_id AS tax_category_id_20, s1_.shipping_category_id AS shipping_category_id_21 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
Parameters:
[
  [
    2379
  ]
]
203 0.45 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_.channel_code AS channel_code_4, s1_.id AS id_5, s0_.product_id AS product_id_6, s0_.tax_category_id AS tax_category_id_7, s0_.shipping_category_id AS shipping_category_id_8, s1_.product_variant_id AS product_variant_id_9 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
204 0.44 ms
SELECT s0_.id AS id_0, s1_.code AS code_1, s1_.id AS id_2, s0_.product_id AS product_id_3, s0_.tax_category_id AS tax_category_id_4, s0_.shipping_category_id AS shipping_category_id_5, s1_.option_id AS option_id_6 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:
[
  [
    9821
    9822
    15987
    15988
    15989
  ]
]
205 0.39 ms
SELECT s0_.id AS id_0, s1_.value AS value_1, s1_.id AS id_2, s1_.locale AS locale_3, s0_.option_id AS option_id_4, s1_.translatable_id AS translatable_id_5 FROM sylius_product_option_value s0_ LEFT JOIN sylius_product_option_value_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.id IN (?) ORDER BY s0_.id ASC
Parameters:
[
  [
    0 => 21
    2 => 74
    4 => 71
    8 => 3
  ]
]
206 0.69 ms
SELECT b0_.code AS code_0, b0_.enabled AS enabled_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3, b0_.publish_at AS publish_at_4, b0_.id AS id_5 FROM bitbag_cms_page b0_ LEFT JOIN bitbag_cms_page_translation b1_ ON b0_.id = b1_.translatable_id INNER JOIN bitbag_cms_page_sections b3_ ON b0_.id = b3_.block_id INNER JOIN bitbag_cms_section b2_ ON b2_.id = b3_.section_id WHERE b1_.locale = ? AND b2_.code = ? AND b0_.enabled = 1 ORDER BY b0_.id ASC
Parameters:
[
  "en_US"
  "footer_links"
]
207 0.34 ms
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.breadcrumb AS breadcrumb_3, t0.name_when_linked AS name_when_linked_4, t0.description_when_linked AS description_when_linked_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.content AS content_8, t0.title AS title_9, t0.id AS id_10, t0.locale AS locale_11, t0.translatable_id AS translatable_id_12, t0.image_id AS image_id_13 FROM bitbag_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  2
  "en_US"
]
208 0.32 ms
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.breadcrumb AS breadcrumb_3, t0.name_when_linked AS name_when_linked_4, t0.description_when_linked AS description_when_linked_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.content AS content_8, t0.title AS title_9, t0.id AS id_10, t0.locale AS locale_11, t0.translatable_id AS translatable_id_12, t0.image_id AS image_id_13 FROM bitbag_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  4
  "en_US"
]
209 0.34 ms
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.breadcrumb AS breadcrumb_3, t0.name_when_linked AS name_when_linked_4, t0.description_when_linked AS description_when_linked_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.content AS content_8, t0.title AS title_9, t0.id AS id_10, t0.locale AS locale_11, t0.translatable_id AS translatable_id_12, t0.image_id AS image_id_13 FROM bitbag_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  5
  "en_US"
]
210 0.38 ms
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.breadcrumb AS breadcrumb_3, t0.name_when_linked AS name_when_linked_4, t0.description_when_linked AS description_when_linked_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.content AS content_8, t0.title AS title_9, t0.id AS id_10, t0.locale AS locale_11, t0.translatable_id AS translatable_id_12, t0.image_id AS image_id_13 FROM bitbag_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  6
  "en_US"
]
211 0.41 ms
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.breadcrumb AS breadcrumb_3, t0.name_when_linked AS name_when_linked_4, t0.description_when_linked AS description_when_linked_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.content AS content_8, t0.title AS title_9, t0.id AS id_10, t0.locale AS locale_11, t0.translatable_id AS translatable_id_12, t0.image_id AS image_id_13 FROM bitbag_cms_page_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  7
  "en_US"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
Sylius\Component\Product\Model\Product No errors.
Sylius\Component\Core\Model\Product No errors.
App\Entity\Product\Product No errors.
Sylius\Component\Taxonomy\Model\Taxon No errors.
Sylius\Component\Core\Model\Taxon No errors.
App\Entity\Taxonomy\Taxon No errors.
Brille24\SyliusTierPricePlugin\Entity\TierPrice No errors.
App\Entity\Product\TierPrice 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\Core\Model\ShopBillingData No errors.
Dedi\SyliusSEOPlugin\Entity\SEOContent No errors.
Sylius\Component\Addressing\Model\Country No errors.
App\Entity\Addressing\Country No errors.
Sylius\Component\Addressing\Model\Province No errors.
App\Entity\Addressing\Province No errors.
Sylius\Component\Product\Model\ProductTranslation No errors.
Sylius\Component\Core\Model\ProductTranslation No errors.
App\Entity\Product\ProductTranslation No errors.
Loevgaard\SyliusBrandPlugin\Model\Brand No errors.
App\Entity\Brand\Brand No errors.
Sylius\Component\Product\Model\ProductVariant No errors.
Sylius\Component\Core\Model\ProductVariant No errors.
App\Entity\Product\ProductVariant No errors.
Mezcalito\SyliusFileUploadPlugin\Model\File No errors.
App\Entity\Product\ProductFile No errors.
Tavy315\SyliusLabelsPlugin\Model\Label No errors.
Setono\SyliusCalloutPlugin\Model\Callout No errors.
Sylius\Component\Core\Model\ProductTaxon No errors.
App\Entity\Product\ProductTaxon 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\Attribute\Model\Attribute No errors.
Sylius\Component\Product\Model\ProductAttribute No errors.
App\Entity\Product\ProductAttribute 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\Review\Model\Review No errors.
Sylius\Component\Core\Model\ProductReview No errors.
App\Entity\Product\ProductReview No errors.
Sylius\Component\Customer\Model\Customer No errors.
Sylius\Component\Core\Model\Customer No errors.
App\Entity\Customer\Customer No errors.
Loevgaard\SyliusBrandPlugin\Model\BrandImage No errors.
Sylius\Component\Product\Model\ProductOptionTranslation No errors.
App\Entity\Product\ProductOptionTranslation No errors.
Sylius\Component\Product\Model\ProductOptionValue No errors.
App\Entity\Product\ProductOptionValue 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\Promotion\Model\CatalogPromotion No errors.
Sylius\Component\Core\Model\CatalogPromotion No errors.
Sylius\Component\Product\Model\ProductOptionValueTranslation No errors.
App\Entity\Product\ProductOptionValueTranslation No errors.
BitBag\SyliusCmsPlugin\Entity\Block No errors.
BitBag\SyliusCmsPlugin\Entity\Media No errors.
BitBag\SyliusCmsPlugin\Entity\Page No errors.
Sylius\Component\Taxation\Model\TaxRate No errors.
Sylius\Component\Core\Model\TaxRate No errors.
App\Entity\Taxation\TaxRate No errors.
Dedi\SyliusSEOPlugin\Entity\SEOContentTranslation 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\Customer\Model\CustomerGroup No errors.
App\Entity\Customer\CustomerGroup No errors.
Sylius\Component\Promotion\Model\PromotionCoupon No errors.
Sylius\Component\Core\Model\PromotionCoupon No errors.
App\Entity\Promotion\PromotionCoupon No errors.
Sylius\Component\User\Model\User No errors.
Sylius\Component\Core\Model\AdminUser No errors.
App\Entity\User\AdminUser 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\OrderItem No errors.
Sylius\Component\Core\Model\OrderItem No errors.
App\Entity\Order\OrderItem No errors.
Sylius\Component\Order\Model\Adjustment No errors.
Sylius\Component\Core\Model\Adjustment No errors.
App\Entity\Order\Adjustment No errors.
Sylius\Component\Shipping\Model\ShippingMethod No errors.
Sylius\Component\Core\Model\ShippingMethod No errors.
App\Entity\Shipping\ShippingMethod No errors.
Sylius\Component\Order\Model\OrderItemUnit No errors.
Sylius\Component\Core\Model\OrderItemUnit No errors.
App\Entity\Order\OrderItemUnit No errors.
Sylius\Component\Addressing\Model\ZoneMember No errors.
App\Entity\Addressing\ZoneMember No errors.
Tavy315\SyliusLabelsPlugin\Model\LabelTranslation No errors.
Setono\SyliusCalloutPlugin\Model\CalloutTranslation No errors.
Setono\SyliusCalloutPlugin\Model\CalloutRule No errors.
Sylius\Component\Attribute\Model\AttributeTranslation No errors.
Sylius\Component\Product\Model\ProductAttributeTranslation No errors.
App\Entity\Product\ProductAttributeTranslation No errors.
Sylius\Component\Product\Model\ProductAssociationType No errors.
App\Entity\Product\ProductAssociationType No errors.
Sylius\Component\Core\Model\ShopUser No errors.
App\Entity\User\ShopUser No errors.
Sylius\Component\Promotion\Model\CatalogPromotionTranslation No errors.
Sylius\Component\Promotion\Model\CatalogPromotionScope No errors.
Sylius\Component\Core\Model\CatalogPromotionScope No errors.
Sylius\Component\Promotion\Model\CatalogPromotionAction No errors.
BitBag\SyliusCmsPlugin\Entity\BlockTranslation No errors.
BitBag\SyliusCmsPlugin\Entity\Section No errors.
BitBag\SyliusCmsPlugin\Entity\MediaTranslation No errors.
BitBag\SyliusCmsPlugin\Entity\PageTranslation No errors.
Sylius\Component\Core\Model\AvatarImage No errors.
Sylius\Component\User\Model\UserOAuth No errors.
App\Entity\User\UserOAuth No errors.
Sylius\Component\Payment\Model\PaymentMethod No errors.
Sylius\Component\Core\Model\PaymentMethod No errors.
App\Entity\Payment\PaymentMethod No errors.
Sylius\Component\Promotion\Model\PromotionRule No errors.
App\Entity\Promotion\PromotionRule No errors.
Sylius\Component\Promotion\Model\PromotionAction No errors.
App\Entity\Promotion\PromotionAction No errors.
App\Entity\Order\OrderItemFile No errors.
Sylius\Component\Shipping\Model\ShippingMethodTranslation No errors.
App\Entity\Shipping\ShippingMethodTranslation No errors.
Sylius\Component\Shipping\Model\ShippingMethodRule No errors.
Sylius\Component\Product\Model\ProductAssociationTypeTranslation No errors.
App\Entity\Product\ProductAssociationTypeTranslation No errors.
BitBag\SyliusCmsPlugin\Entity\SectionTranslation No errors.
Payum\Core\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.