Query Metrics
254
Database Queries
38
Different statements
86.50 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.53 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.26 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.20 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 | 0.58 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" "wine-bottle-sized-custom-shopping-bag" 1 ] |
| 7 | 0.26 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" "wine-bottle-sized-custom-shopping-bag" 1 ] |
| 8 | 0.60 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" "wine-bottle-sized-custom-shopping-bag" 1 1 ] |
| 9 | 0.20 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:
[
[
41
]
]
|
| 10 | 0.34 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:
[
[
53
]
]
|
| 11 | 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:
[
[
53
]
]
|
| 12 | 0.27 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.31 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:
[
[
53
]
]
|
| 14 | 0.41 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 15 | 0.35 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 16 | 0.44 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 => 64
1 => 62
3 => 74
4 => 65
8 => 63
11 => 71
]
]
|
| 17 | 0.42 ms |
SELECT t0.id AS id_1 FROM dedi_sylius_seo_content t0 WHERE t0.id = ?
Parameters:
[
138
]
|
| 18 | 0.18 ms |
SELECT t0.id AS id_1 FROM dedi_sylius_seo_content t0 WHERE t0.id = ?
Parameters:
[
2887
]
|
| 19 | 0.19 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.16 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:
[ 138 "en_US" ] |
| 21 | 0.67 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" "wine-bottle-sized-custom-shopping-bag" 1 1 ] |
| 22 | 0.29 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:
[
[
53
]
]
|
| 23 | 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:
[
[
53
]
]
|
| 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.26 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:
[
[
53
]
]
|
| 26 | 0.31 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 27 | 0.29 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 28 | 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 => 64
1 => 62
3 => 74
4 => 65
8 => 63
11 => 71
]
]
|
| 29 | 0.19 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:
[
53
]
|
| 30 | 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:
[
194
]
|
| 31 | 3.53 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:
[
2
]
|
| 32 | 0.28 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
]
|
| 33 | 0.19 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" ] |
| 34 | 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:
[ 2 "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:
[ 194 "en_US" ] |
| 36 | 0.25 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:
[] |
| 37 | 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" "wine-bottle-sized-custom-shopping-bag" 1 1 ] |
| 38 | 0.28 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:
[
[
53
]
]
|
| 39 | 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:
[
[
53
]
]
|
| 40 | 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
]
]
|
| 41 | 0.26 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:
[
[
53
]
]
|
| 42 | 0.29 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 43 | 0.29 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 44 | 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 => 64
1 => 62
3 => 74
4 => 65
8 => 63
11 => 71
]
]
|
| 45 | 0.40 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" "wine-bottle-sized-custom-shopping-bag" 1 1 ] |
| 46 | 0.29 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:
[
[
53
]
]
|
| 47 | 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:
[
[
53
]
]
|
| 48 | 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
]
]
|
| 49 | 0.26 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:
[
[
53
]
]
|
| 50 | 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 51 | 0.29 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 52 | 0.26 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 => 64
1 => 62
3 => 74
4 => 65
8 => 63
11 => 71
]
]
|
| 53 | 7.10 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 ] |
| 54 | 1.01 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" ] |
| 55 | 0.27 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" ] |
| 56 | 0.40 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" "wine-bottle-sized-custom-shopping-bag" 1 1 ] |
| 57 | 0.47 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:
[
[
53
]
]
|
| 58 | 0.29 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:
[
[
53
]
]
|
| 59 | 0.30 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
]
]
|
| 60 | 0.30 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:
[
[
53
]
]
|
| 61 | 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 62 | 0.32 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 63 | 0.27 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 => 64
1 => 62
3 => 74
4 => 65
8 => 63
11 => 71
]
]
|
| 64 | 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" "wine-bottle-sized-custom-shopping-bag" 1 1 ] |
| 65 | 0.23 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:
[
[
53
]
]
|
| 66 | 0.24 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:
[
[
53
]
]
|
| 67 | 0.19 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
]
]
|
| 68 | 0.22 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:
[
[
53
]
]
|
| 69 | 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 70 | 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 71 | 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 => 64
1 => 62
3 => 74
4 => 65
8 => 63
11 => 71
]
]
|
| 72 | 0.34 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" 194 ] |
| 73 | 0.38 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 "restaurants_bags" ] |
| 74 | 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 "bags-restaurant-bags-custom-printed-bags" "en_US" ] |
| 75 | 0.31 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" "wine-bottle-sized-custom-shopping-bag" 1 1 ] |
| 76 | 0.22 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:
[
[
53
]
]
|
| 77 | 0.23 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:
[
[
53
]
]
|
| 78 | 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
]
]
|
| 79 | 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:
[
[
53
]
]
|
| 80 | 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 81 | 0.29 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 82 | 0.29 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 => 64
1 => 62
3 => 74
4 => 65
8 => 63
11 => 71
]
]
|
| 83 | 0.23 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-restaurant-bags-custom-printed-bags/5" 1 ] |
| 84 | 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 "products/label/top/taxon/bags-restaurant-bags-custom-printed-bags/5" "en_US" ] |
| 85 | 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-restaurant-bags-custom-printed-bags" "en_US" ] |
| 86 | 1.33 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" 303 310 150 ] |
| 87 | 0.20 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:
[
[
30
]
]
|
| 88 | 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 "bags-restaurant-bags-custom-printed-bags" "en_US" ] |
| 89 | 0.30 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" "wine-bottle-sized-custom-shopping-bag" 1 1 ] |
| 90 | 0.22 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:
[
[
53
]
]
|
| 91 | 0.23 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:
[
[
53
]
]
|
| 92 | 0.17 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
]
]
|
| 93 | 0.22 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:
[
[
53
]
]
|
| 94 | 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 95 | 0.29 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 96 | 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 => 64
1 => 62
3 => 74
4 => 65
8 => 63
11 => 71
]
]
|
| 97 | 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:
[
55
]
|
| 98 | 0.21 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:
[
212
]
|
| 99 | 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:
[
214
]
|
| 100 | 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:
[
2466
]
|
| 101 | 0.17 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:
[
2468
]
|
| 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:
[
19350
]
|
| 103 | 0.17 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:
[
19351
]
|
| 104 | 0.16 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:
[
19352
]
|
| 105 | 0.50 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:
[
19353
]
|
| 106 | 0.26 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:
[
212
]
|
| 107 | 0.27 ms |
SELECT t0.code AS code_1, t0.name AS name_2, t0.amount AS amount_3, t0.included_in_price AS included_in_price_4, t0.calculator AS calculator_5, t0.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 ] |
| 108 | 0.26 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 ] |
| 109 | 0.26 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:
[
212
]
|
| 110 | 0.27 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:
[ 55 "en_US" ] |
| 111 | 0.28 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:
[
55
]
|
| 112 | 0.71 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.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:
[
56
]
|
| 113 | 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:
[
216
]
|
| 114 | 0.41 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:
[
218
]
|
| 115 | 0.16 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:
[
2470
]
|
| 116 | 0.38 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:
[
2472
]
|
| 117 | 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:
[
19366
]
|
| 118 | 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 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:
[
19367
]
|
| 119 | 0.16 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:
[
19368
]
|
| 120 | 0.42 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:
[
19369
]
|
| 121 | 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:
[
216
]
|
| 122 | 0.25 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 ] |
| 123 | 0.15 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 ] |
| 124 | 0.30 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:
[
216
]
|
| 125 | 0.37 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:
[ 56 "en_US" ] |
| 126 | 0.30 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:
[
56
]
|
| 127 | 0.20 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:
[
57
]
|
| 128 | 0.32 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:
[
220
]
|
| 129 | 0.16 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:
[
222
]
|
| 130 | 0.37 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:
[
6467
]
|
| 131 | 0.17 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:
[
6469
]
|
| 132 | 0.39 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:
[
19370
]
|
| 133 | 0.17 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:
[
19371
]
|
| 134 | 0.39 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:
[
19372
]
|
| 135 | 0.17 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:
[
19373
]
|
| 136 | 0.32 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:
[
220
]
|
| 137 | 0.38 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.18 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.27 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:
[
220
]
|
| 140 | 0.33 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:
[ 57 "en_US" ] |
| 141 | 0.30 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:
[
57
]
|
| 142 | 0.44 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:
[
263
]
|
| 143 | 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:
[
727
]
|
| 144 | 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:
[
729
]
|
| 145 | 0.22 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:
[
3576
]
|
| 146 | 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:
[
3578
]
|
| 147 | 0.16 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:
[
19346
]
|
| 148 | 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:
[
19347
]
|
| 149 | 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:
[
19348
]
|
| 150 | 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:
[
19349
]
|
| 151 | 0.15 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:
[
727
]
|
| 152 | 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 ] |
| 153 | 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 ] |
| 154 | 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:
[
727
]
|
| 155 | 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:
[ 263 "en_US" ] |
| 156 | 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:
[
263
]
|
| 157 | 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:
[
782
]
|
| 158 | 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:
[
6381
]
|
| 159 | 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:
[
17098
]
|
| 160 | 0.14 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:
[
6381
]
|
| 161 | 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:
[
6381
]
|
| 162 | 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:
[ 782 "en_US" ] |
| 163 | 0.17 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:
[
782
]
|
| 164 | 0.31 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" "wine-bottle-sized-custom-shopping-bag" 1 1 ] |
| 165 | 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:
[
[
53
]
]
|
| 166 | 0.24 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:
[
[
53
]
]
|
| 167 | 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
]
]
|
| 168 | 0.23 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:
[
[
53
]
]
|
| 169 | 0.27 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 170 | 0.32 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 171 | 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 => 64
1 => 62
3 => 74
4 => 65
8 => 63
11 => 71
]
]
|
| 172 | 0.24 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:
[
53
]
|
| 173 | 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 ] |
| 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.15 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.15 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.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 ] |
| 178 | 0.15 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 ] |
| 179 | 0.15 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 ] |
| 180 | 0.15 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 ] |
| 181 | 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 ] |
| 182 | 0.15 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 ] |
| 183 | 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 ] |
| 184 | 0.18 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 ] |
| 185 | 0.15 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 ] |
| 186 | 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 ] |
| 187 | 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 ] |
| 188 | 0.15 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 ] |
| 189 | 0.15 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 ] |
| 190 | 0.15 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 ] |
| 191 | 0.15 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 ] |
| 192 | 0.19 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 ] |
| 193 | 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 ] |
| 194 | 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 ] |
| 195 | 4.21 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 ] |
| 196 | 0.19 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 ] |
| 197 | 0.18 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 ] |
| 198 | 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 ] |
| 199 | 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 ] |
| 200 | 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 ] |
| 201 | 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 ] |
| 202 | 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 ] |
| 203 | 0.42 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
]
|
| 204 | 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
]
|
| 205 | 0.15 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
]
|
| 206 | 0.28 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:
[
204
]
|
| 207 | 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:
[
206
]
|
| 208 | 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:
[
2458
]
|
| 209 | 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:
[
2459
]
|
| 210 | 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:
[
2460
]
|
| 211 | 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:
[
2461
]
|
| 212 | 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:
[
19382
]
|
| 213 | 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:
[
19383
]
|
| 214 | 0.18 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:
[
19384
]
|
| 215 | 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:
[
19385
]
|
| 216 | 0.23 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:
[
53
]
|
| 217 | 0.45 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 ] |
| 218 | 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 ] |
| 219 | 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 ] |
| 220 | 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 ] |
| 221 | 0.40 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" "wine-bottle-sized-custom-shopping-bag" 1 1 ] |
| 222 | 0.27 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:
[
[
53
]
]
|
| 223 | 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:
[
[
53
]
]
|
| 224 | 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
]
]
|
| 225 | 0.26 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:
[
[
53
]
]
|
| 226 | 0.29 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 227 | 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 228 | 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 => 64
1 => 62
3 => 74
4 => 65
8 => 63
11 => 71
]
]
|
| 229 | 0.17 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:
[
53
]
|
| 230 | 6.74 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 ] |
| 231 | 1.10 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" ] |
| 232 | 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" "wine-bottle-sized-custom-shopping-bag" 1 1 ] |
| 233 | 0.28 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:
[
[
53
]
]
|
| 234 | 0.37 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:
[
[
53
]
]
|
| 235 | 0.38 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
]
]
|
| 236 | 0.28 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:
[
[
53
]
]
|
| 237 | 0.31 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 238 | 0.31 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 239 | 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 => 64
1 => 62
3 => 74
4 => 65
8 => 63
11 => 71
]
]
|
| 240 | 0.32 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" ] |
| 241 | 0.19 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" ] |
| 242 | 0.18 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" ] |
| 243 | 0.16 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" ] |
| 244 | 0.23 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" ] |
| 245 | 0.24 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" ] |
| 246 | 0.34 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" "wine-bottle-sized-custom-shopping-bag" 1 1 ] |
| 247 | 0.29 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:
[
[
53
]
]
|
| 248 | 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:
[
[
53
]
]
|
| 249 | 0.23 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
]
]
|
| 250 | 0.26 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:
[
[
53
]
]
|
| 251 | 0.31 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 252 | 0.31 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:
[
[
204
206
2458
2459
2460
2461
19382
19383
19384
19385
]
]
|
| 253 | 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 => 64
1 => 62
3 => 74
4 => 65
8 => 63
11 => 71
]
]
|
| 254 | 0.22 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 WHERE b1_.locale = ? AND b0_.code = ? AND b0_.enabled = 1 ORDER BY b0_.id ASC
Parameters:
[ "en_US" "privacy_policy" ] |
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. |