Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.link AS link_2,
  t0.lpos AS lpos_3,
  t0.rpos AS rpos_4,
  t0.depth AS depth_5,
  t0.type AS type_6,
  t0.position AS position_7,
  t0.enabled AS enabled_8,
  t0.visibleFor AS visibleFor_9,
  t10.id AS id_11,
  t10.submenus_count_all AS submenus_count_all_12,
  t10.submenus_count_enabled AS submenus_count_enabled_13,
  t10.menu_id AS menu_id_14,
  t0.parent_id AS parent_id_15
FROM
  xc_menus t0
  LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id
WHERE
  t0.parent_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.link AS link_2, t0.lpos AS lpos_3, t0.rpos AS rpos_4, t0.depth AS depth_5, t0.type AS type_6, t0.position AS position_7, t0.enabled AS enabled_8, t0.visibleFor AS visibleFor_9, t10.id AS id_11, t10.submenus_count_all AS submenus_count_all_12, t10.submenus_count_enabled AS submenus_count_enabled_13, t10.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM xc_menus t0 LEFT JOIN xc_menu_quick_flags t10 ON t10.menu_id = t0.id WHERE t0.parent_id = 301 ORDER BY t0.id ASC;

SELECT
  t0.name AS name_1,
  t0.label_id AS label_id_2,
  t0.code AS code_3,
  t0.id AS id_4
FROM
  xc_menu_translations t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.label_id AS label_id_2, t0.code AS code_3, t0.id AS id_4 FROM xc_menu_translations t0 WHERE t0.id = 301;

SELECT
  COUNT(DISTINCT x0_.brand_id) AS sclr_0
FROM
  xc_brands x0_
  LEFT JOIN xc_brand_products x1_ ON (x1_.brand_id = x0_.brand_id)
  INNER JOIN xc_attribute_options x2_ ON x0_.attribute_option_id = x2_.id
  INNER JOIN xc_attribute_option_translations x3_ ON x2_.id = x3_.id
  INNER JOIN xc_attribute_values_select x4_ ON x2_.id = x4_.attribute_option_id
  INNER JOIN xc_products x5_ ON x4_.product_id = x5_.product_id
WHERE
  x0_.enabled = ?
  AND x5_.enabled = ?
LIMIT
  1

SELECT COUNT(DISTINCT x0_.brand_id) AS sclr_0 FROM xc_brands x0_ LEFT JOIN xc_brand_products x1_ ON (x1_.brand_id = x0_.brand_id) INNER JOIN xc_attribute_options x2_ ON x0_.attribute_option_id = x2_.id INNER JOIN xc_attribute_option_translations x3_ ON x2_.id = x3_.id INNER JOIN xc_attribute_values_select x4_ ON x2_.id = x4_.attribute_option_id INNER JOIN xc_products x5_ ON x4_.product_id = x5_.product_id WHERE x0_.enabled = 1 AND x5_.enabled = 1 LIMIT 1;

SELECT
  x0_.csLastUpdate AS csLastUpdate_0,
  x0_.is_stickers_included_subcategories AS is_stickers_included_subcategories_1,
  x0_.category_id AS category_id_2,
  x0_.lpos AS lpos_3,
  x0_.rpos AS rpos_4,
  x0_.enabled AS enabled_5,
  x0_.show_title AS show_title_6,
  x0_.depth AS depth_7,
  x0_.pos AS pos_8,
  x0_.root_category_look AS root_category_look_9,
  x0_.metaDescType AS metaDescType_10,
  x0_.xcPendingExport AS xcPendingExport_11,
  x0_.parent_id AS parent_id_12
FROM
  xc_categories x0_
  LEFT JOIN xc_category_translations x1_ ON x0_.category_id = x1_.id
  AND (x1_.code = ?)
  LEFT JOIN xc_category_membership_links x3_ ON x0_.category_id = x3_.category_id
  LEFT JOIN xc_memberships x2_ ON x2_.membership_id = x3_.membership_id
WHERE
  x0_.enabled = ?
  AND x2_.membership_id IS NULL
  AND x0_.category_id <> ?
  AND (
    x0_.lpos BETWEEN ?
    AND ?
  )
  AND (
    x0_.rpos BETWEEN ?
    AND ?
  )
ORDER BY
  x0_.lpos ASC

SELECT x0_.csLastUpdate AS csLastUpdate_0, x0_.is_stickers_included_subcategories AS is_stickers_included_subcategories_1, x0_.category_id AS category_id_2, x0_.lpos AS lpos_3, x0_.rpos AS rpos_4, x0_.enabled AS enabled_5, x0_.show_title AS show_title_6, x0_.depth AS depth_7, x0_.pos AS pos_8, x0_.root_category_look AS root_category_look_9, x0_.metaDescType AS metaDescType_10, x0_.xcPendingExport AS xcPendingExport_11, x0_.parent_id AS parent_id_12 FROM xc_categories x0_ LEFT JOIN xc_category_translations x1_ ON x0_.category_id = x1_.id AND (x1_.code = 'en') LEFT JOIN xc_category_membership_links x3_ ON x0_.category_id = x3_.category_id LEFT JOIN xc_memberships x2_ ON x2_.membership_id = x3_.membership_id WHERE x0_.enabled = 1 AND x2_.membership_id IS NULL AND x0_.category_id <> 1 AND (x0_.lpos BETWEEN 1 AND 121) AND (x0_.rpos BETWEEN 122 AND '806') ORDER BY x0_.lpos ASC;

SELECT
  x0_.id AS id_0,
  x0_.link AS link_1,
  x0_.lpos AS lpos_2,
  x0_.rpos AS rpos_3,
  x0_.depth AS depth_4,
  x0_.type AS type_5,
  x0_.position AS position_6,
  x0_.enabled AS enabled_7,
  x0_.visibleFor AS visibleFor_8,
  x1_.id AS id_9,
  x1_.submenus_count_all AS submenus_count_all_10,
  x1_.submenus_count_enabled AS submenus_count_enabled_11,
  x0_.parent_id AS parent_id_12,
  x1_.menu_id AS menu_id_13
FROM
  xc_menus x0_
  INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id
  INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id
WHERE
  x0_.enabled = ?
  AND x0_.id <> ?
  AND x0_.type = ?
  AND x0_.enabled = ?
  AND x0_.visibleFor IN ('AL', 'A')
  AND x2_.id = ?
GROUP BY
  x0_.id
ORDER BY
  x0_.position ASC,
  x0_.id ASC

SELECT x0_.id AS id_0, x0_.link AS link_1, x0_.lpos AS lpos_2, x0_.rpos AS rpos_3, x0_.depth AS depth_4, x0_.type AS type_5, x0_.position AS position_6, x0_.enabled AS enabled_7, x0_.visibleFor AS visibleFor_8, x1_.id AS id_9, x1_.submenus_count_all AS submenus_count_all_10, x1_.submenus_count_enabled AS submenus_count_enabled_11, x0_.parent_id AS parent_id_12, x1_.menu_id AS menu_id_13 FROM xc_menus x0_ INNER JOIN xc_menu_quick_flags x1_ ON x0_.id = x1_.menu_id INNER JOIN xc_menus x2_ ON x0_.parent_id = x2_.id WHERE x0_.enabled = 1 AND x0_.id <> 495 AND x0_.type = 'P' AND x0_.enabled = 1 AND x0_.visibleFor IN ('AL', 'A') AND x2_.id = 495 GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC;

SELECT
  COUNT(x0_.category_id) AS sclr_0
FROM
  xc_categories x0_
  LEFT JOIN xc_category_translations x1_ ON x0_.category_id = x1_.id
  AND (x1_.code = ?)
  LEFT JOIN xc_category_membership_links x3_ ON x0_.category_id = x3_.category_id
  LEFT JOIN xc_memberships x2_ ON x2_.membership_id = x3_.membership_id
  INNER JOIN xc_category_products x4_ ON x0_.category_id = x4_.category_id
WHERE
  x0_.enabled = ?
  AND x2_.membership_id IS NULL
  AND x0_.category_id <> ?
  AND x0_.category_id = ?
  AND x4_.product_id = ?
ORDER BY
  x0_.pos ASC,
  x0_.category_id ASC
LIMIT
  1

SELECT COUNT(x0_.category_id) AS sclr_0 FROM xc_categories x0_ LEFT JOIN xc_category_translations x1_ ON x0_.category_id = x1_.id AND (x1_.code = 'en') LEFT JOIN xc_category_membership_links x3_ ON x0_.category_id = x3_.category_id LEFT JOIN xc_memberships x2_ ON x2_.membership_id = x3_.membership_id INNER JOIN xc_category_products x4_ ON x0_.category_id = x4_.category_id WHERE x0_.enabled = 1 AND x2_.membership_id IS NULL AND x0_.category_id <> 1 AND x0_.category_id = 1485 AND x4_.product_id = 4969 ORDER BY x0_.pos ASC, x0_.category_id ASC LIMIT 1;

SELECT
  x0_.id AS id_0,
  COUNT(x0_.id) AS sclr_1
FROM
  xc_attribute_values_select x1_
  LEFT JOIN xc_attribute_values_select_translations x2_ ON x1_.id = x2_.id
  AND (x2_.code = ?)
  INNER JOIN xc_attributes x0_ ON x1_.attribute_id = x0_.id
WHERE
  x1_.product_id = ?
  AND x0_.displayMode <> ?
  AND (
    x0_.product_class_id IS NULL
    OR x0_.product_class_id = ?
  )
GROUP BY
  x0_.id
HAVING
  COUNT(x0_.id) > 1
ORDER BY
  x0_.position ASC

SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_select x1_ LEFT JOIN xc_attribute_values_select_translations x2_ ON x1_.id = x2_.id AND (x2_.code = 'en') INNER JOIN xc_attributes x0_ ON x1_.attribute_id = x0_.id WHERE x1_.product_id = 4969 AND x0_.displayMode <> 'P' AND (x0_.product_class_id IS NULL OR x0_.product_class_id = 130) GROUP BY x0_.id HAVING COUNT(x0_.id) > 1 ORDER BY x0_.position ASC;

SELECT
  x0_.id AS id_0,
  x0_.quantity AS quantity_1,
  x0_.membership_id AS membership_id_2,
  x0_.product_id AS product_id_3
FROM
  xc_product_min_quantities x0_
  INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id
WHERE
  x1_.product_id = ?
  AND x0_.membership_id IS NULL
LIMIT
  1

SELECT x0_.id AS id_0, x0_.quantity AS quantity_1, x0_.membership_id AS membership_id_2, x0_.product_id AS product_id_3 FROM xc_product_min_quantities x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = 4969 AND x0_.membership_id IS NULL LIMIT 1;

SELECT
  x0_.id AS id_0,
  COUNT(x0_.id) AS sclr_1
FROM
  xc_attribute_values_checkbox x1_
  LEFT JOIN xc_attribute_values_checkbox_translations x2_ ON x1_.id = x2_.id
  AND (x2_.code = ?)
  INNER JOIN xc_attributes x0_ ON x1_.attribute_id = x0_.id
WHERE
  x1_.product_id = ?
  AND x0_.displayMode <> ?
  AND (
    x0_.product_class_id IS NULL
    OR x0_.product_class_id = ?
  )
GROUP BY
  x0_.id
HAVING
  COUNT(x0_.id) > 1
ORDER BY
  x0_.position ASC

SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_checkbox x1_ LEFT JOIN xc_attribute_values_checkbox_translations x2_ ON x1_.id = x2_.id AND (x2_.code = 'en') INNER JOIN xc_attributes x0_ ON x1_.attribute_id = x0_.id WHERE x1_.product_id = 4969 AND x0_.displayMode <> 'P' AND (x0_.product_class_id IS NULL OR x0_.product_class_id = 130) GROUP BY x0_.id HAVING COUNT(x0_.id) > 1 ORDER BY x0_.position ASC;

SELECT
  x0_.id AS id_0,
  COUNT(x0_.id) AS sclr_1
FROM
  xc_attribute_values_text x1_
  LEFT JOIN xc_attribute_values_text_translations x2_ ON x1_.id = x2_.id
  AND (x2_.code = ?)
  INNER JOIN xc_attributes x0_ ON x1_.attribute_id = x0_.id
WHERE
  (
    x1_.product_id = ?
    AND x1_.editable = ?
  )
  AND (
    x0_.product_class_id IS NULL
    OR x0_.product_class_id = ?
  )
GROUP BY
  x0_.id
ORDER BY
  x0_.position ASC

SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_text x1_ LEFT JOIN xc_attribute_values_text_translations x2_ ON x1_.id = x2_.id AND (x2_.code = 'en') INNER JOIN xc_attributes x0_ ON x1_.attribute_id = x0_.id WHERE (x1_.product_id = 4969 AND x1_.editable = 1) AND (x0_.product_class_id IS NULL OR x0_.product_class_id = 130) GROUP BY x0_.id ORDER BY x0_.position ASC;

SELECT
  COUNT(DISTINCT x0_.id) AS sclr_0
FROM
  xc_reviews x0_
  INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id
WHERE
  x1_.product_id = ?
  AND x0_.status = ?
LIMIT
  1

SELECT COUNT(DISTINCT x0_.id) AS sclr_0 FROM xc_reviews x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = 13247 AND x0_.status = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.orderby AS orderby_2,
  t0.orderbyInProduct AS orderbyInProduct_3,
  t0.category_id AS category_id_4,
  t0.product_id AS product_id_5
FROM
  xc_category_products t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.orderbyInProduct ASC

SELECT t0.id AS id_1, t0.orderby AS orderby_2, t0.orderbyInProduct AS orderbyInProduct_3, t0.category_id AS category_id_4, t0.product_id AS product_id_5 FROM xc_category_products t0 WHERE t0.product_id = 4969 ORDER BY t0.orderbyInProduct ASC;

SELECT
  t0.csLastUpdate AS csLastUpdate_1,
  t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_2,
  t0.category_id AS category_id_3,
  t0.lpos AS lpos_4,
  t0.rpos AS rpos_5,
  t0.enabled AS enabled_6,
  t0.show_title AS show_title_7,
  t0.depth AS depth_8,
  t0.pos AS pos_9,
  t0.root_category_look AS root_category_look_10,
  t0.metaDescType AS metaDescType_11,
  t0.xcPendingExport AS xcPendingExport_12,
  t13.id AS id_14,
  t13.subcategories_count_all AS subcategories_count_all_15,
  t13.subcategories_count_enabled AS subcategories_count_enabled_16,
  t13.category_id AS category_id_17,
  t18.alt AS alt_19,
  t18.width AS width_20,
  t18.height AS height_21,
  t18.hash AS hash_22,
  t18.needProcess AS needProcess_23,
  t18.id AS id_24,
  t18.path AS path_25,
  t18.fileName AS fileName_26,
  t18.mime AS mime_27,
  t18.storageType AS storageType_28,
  t18.size AS size_29,
  t18.date AS date_30,
  t18.category_id AS category_id_31,
  t32.alt AS alt_33,
  t32.width AS width_34,
  t32.height AS height_35,
  t32.hash AS hash_36,
  t32.needProcess AS needProcess_37,
  t32.id AS id_38,
  t32.path AS path_39,
  t32.fileName AS fileName_40,
  t32.mime AS mime_41,
  t32.storageType AS storageType_42,
  t32.size AS size_43,
  t32.date AS date_44,
  t32.category_id AS category_id_45,
  t0.parent_id AS parent_id_46
FROM
  xc_categories t0
  LEFT JOIN xc_category_quick_flags t13 ON t13.category_id = t0.category_id
  LEFT JOIN xc_category_images t18 ON t18.category_id = t0.category_id
  LEFT JOIN xc_category_banners t32 ON t32.category_id = t0.category_id
WHERE
  t0.category_id = ?

SELECT t0.csLastUpdate AS csLastUpdate_1, t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_2, t0.category_id AS category_id_3, t0.lpos AS lpos_4, t0.rpos AS rpos_5, t0.enabled AS enabled_6, t0.show_title AS show_title_7, t0.depth AS depth_8, t0.pos AS pos_9, t0.root_category_look AS root_category_look_10, t0.metaDescType AS metaDescType_11, t0.xcPendingExport AS xcPendingExport_12, t13.id AS id_14, t13.subcategories_count_all AS subcategories_count_all_15, t13.subcategories_count_enabled AS subcategories_count_enabled_16, t13.category_id AS category_id_17, t18.alt AS alt_19, t18.width AS width_20, t18.height AS height_21, t18.hash AS hash_22, t18.needProcess AS needProcess_23, t18.id AS id_24, t18.path AS path_25, t18.fileName AS fileName_26, t18.mime AS mime_27, t18.storageType AS storageType_28, t18.size AS size_29, t18.date AS date_30, t18.category_id AS category_id_31, t32.alt AS alt_33, t32.width AS width_34, t32.height AS height_35, t32.hash AS hash_36, t32.needProcess AS needProcess_37, t32.id AS id_38, t32.path AS path_39, t32.fileName AS fileName_40, t32.mime AS mime_41, t32.storageType AS storageType_42, t32.size AS size_43, t32.date AS date_44, t32.category_id AS category_id_45, t0.parent_id AS parent_id_46 FROM xc_categories t0 LEFT JOIN xc_category_quick_flags t13 ON t13.category_id = t0.category_id LEFT JOIN xc_category_images t18 ON t18.category_id = t0.category_id LEFT JOIN xc_category_banners t32 ON t32.category_id = t0.category_id WHERE t0.category_id = 1483;

SELECT
  AVG(x0_.rating) AS sclr_0
FROM
  xc_reviews x0_
  INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id
WHERE
  x1_.product_id = ?
  AND x0_.status = ?
LIMIT
  1

SELECT AVG(x0_.rating) AS sclr_0 FROM xc_reviews x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = 13247 AND x0_.status = 1 LIMIT 1;

SELECT
  t0.orderby AS orderby_1,
  t0.alt AS alt_2,
  t0.width AS width_3,
  t0.height AS height_4,
  t0.hash AS hash_5,
  t0.needProcess AS needProcess_6,
  t0.id AS id_7,
  t0.path AS path_8,
  t0.fileName AS fileName_9,
  t0.mime AS mime_10,
  t0.storageType AS storageType_11,
  t0.size AS size_12,
  t0.date AS date_13,
  t0.product_id AS product_id_14
FROM
  xc_product_images t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.orderby ASC

SELECT t0.orderby AS orderby_1, t0.alt AS alt_2, t0.width AS width_3, t0.height AS height_4, t0.hash AS hash_5, t0.needProcess AS needProcess_6, t0.id AS id_7, t0.path AS path_8, t0.fileName AS fileName_9, t0.mime AS mime_10, t0.storageType AS storageType_11, t0.size AS size_12, t0.date AS date_13, t0.product_id AS product_id_14 FROM xc_product_images t0 WHERE t0.product_id = 4969 ORDER BY t0.orderby ASC;

SELECT
  t0.membership_id AS membership_id_1,
  t0.position AS position_2,
  t0.enabled AS enabled_3
FROM
  xc_memberships t0
  INNER JOIN xc_product_membership_links ON t0.membership_id = xc_product_membership_links.membership_id
WHERE
  xc_product_membership_links.product_id = ?

SELECT t0.membership_id AS membership_id_1, t0.position AS position_2, t0.enabled AS enabled_3 FROM xc_memberships t0 INNER JOIN xc_product_membership_links ON t0.membership_id = xc_product_membership_links.membership_id WHERE xc_product_membership_links.product_id = 4969;

SELECT
  x0_.freight_charge AS freight_charge_0,
  x0_.participateSale AS participateSale_1,
  x0_.discountType AS discountType_2,
  x0_.salePriceValue AS salePriceValue_3,
  x0_.applySaleToWholesale AS applySaleToWholesale_4,
  x0_.makeAnOfferState AS makeAnOfferState_5,
  x0_.csiMultiple AS csiMultiple_6,
  x0_.isAvailableForBackorder AS isAvailableForBackorder_7,
  x0_.isBackorderLimit AS isBackorderLimit_8,
  x0_.backorderLimit AS backorderLimit_9,
  x0_.callForPrice AS callForPrice_10,
  x0_.csLastUpdate AS csLastUpdate_11,
  x0_.rewardPoints AS rewardPoints_12,
  x0_.fixedRewardPoints AS fixedRewardPoints_13,
  x0_.taxExempt AS taxExempt_14,
  x0_.isGiftCard AS isGiftCard_15,
  x0_.xcPendingBulkEdit AS xcPendingBulkEdit_16,
  x0_.googleFeedEnabled AS googleFeedEnabled_17,
  x0_.product_id AS product_id_18,
  x0_.price AS price_19,
  x0_.sku AS sku_20,
  x0_.enabled AS enabled_21,
  x0_.weight AS weight_22,
  x0_.useSeparateBox AS useSeparateBox_23,
  x0_.boxWidth AS boxWidth_24,
  x0_.boxLength AS boxLength_25,
  x0_.boxHeight AS boxHeight_26,
  x0_.itemsPerBox AS itemsPerBox_27,
  x0_.free_shipping AS free_shipping_28,
  x0_.taxable AS taxable_29,
  x0_.arrivalDate AS arrivalDate_30,
  x0_.date AS date_31,
  x0_.updateDate AS updateDate_32,
  x0_.needProcess AS needProcess_33,
  x0_.inventoryEnabled AS inventoryEnabled_34,
  x0_.amount AS amount_35,
  x0_.lowLimitEnabledCustomer AS lowLimitEnabledCustomer_36,
  x0_.lowLimitEnabled AS lowLimitEnabled_37,
  x0_.lowLimitAmount AS lowLimitAmount_38,
  x0_.attrSepTab AS attrSepTab_39,
  x0_.metaDescType AS metaDescType_40,
  x0_.sales AS sales_41,
  x0_.xcPendingExport AS xcPendingExport_42,
  x0_.isDemoProduct AS isDemoProduct_43,
  x0_.quantity1 AS quantity1_44,
  x0_.entityVersion AS entityVersion_45,
  IF(
    x0_.discountType = ?, x0_.salePriceValue,
    100 - 100 * x0_.salePriceValue / x0_.price
  ) AS sclr_46,
  x0_.product_class_id AS product_class_id_47,
  x0_.tax_class_id AS tax_class_id_48
FROM
  xc_products x0_
  LEFT JOIN xc_product_translations x1_ ON x0_.product_id = x1_.id
  LEFT JOIN xc_product_membership_links x3_ ON x0_.product_id = x3_.product_id
  LEFT JOIN xc_memberships x2_ ON x2_.membership_id = x3_.membership_id
  LEFT JOIN xc_category_products x4_ ON x0_.product_id = x4_.product_id
  LEFT JOIN xc_categories x5_ ON x4_.category_id = x5_.category_id
WHERE
  x0_.enabled = ?
  AND (
    x0_.arrivalDate < ?
    OR x0_.isAvailableForBackorder = ?
  )
  AND x2_.membership_id IS NULL
  AND (
    x5_.lpos BETWEEN ?
    AND ?
  )
  AND x0_.participateSale = ?
  AND (
    (
      x0_.discountType = ?
      AND x0_.salePriceValue > 0
    )
    OR (
      x0_.discountType = ?
      AND x0_.price > x0_.salePriceValue
    )
  )
GROUP BY
  x0_.product_id
ORDER BY
  sclr_46 DESC,
  x0_.product_id DESC
LIMIT
  3

SELECT x0_.freight_charge AS freight_charge_0, x0_.participateSale AS participateSale_1, x0_.discountType AS discountType_2, x0_.salePriceValue AS salePriceValue_3, x0_.applySaleToWholesale AS applySaleToWholesale_4, x0_.makeAnOfferState AS makeAnOfferState_5, x0_.csiMultiple AS csiMultiple_6, x0_.isAvailableForBackorder AS isAvailableForBackorder_7, x0_.isBackorderLimit AS isBackorderLimit_8, x0_.backorderLimit AS backorderLimit_9, x0_.callForPrice AS callForPrice_10, x0_.csLastUpdate AS csLastUpdate_11, x0_.rewardPoints AS rewardPoints_12, x0_.fixedRewardPoints AS fixedRewardPoints_13, x0_.taxExempt AS taxExempt_14, x0_.isGiftCard AS isGiftCard_15, x0_.xcPendingBulkEdit AS xcPendingBulkEdit_16, x0_.googleFeedEnabled AS googleFeedEnabled_17, x0_.product_id AS product_id_18, x0_.price AS price_19, x0_.sku AS sku_20, x0_.enabled AS enabled_21, x0_.weight AS weight_22, x0_.useSeparateBox AS useSeparateBox_23, x0_.boxWidth AS boxWidth_24, x0_.boxLength AS boxLength_25, x0_.boxHeight AS boxHeight_26, x0_.itemsPerBox AS itemsPerBox_27, x0_.free_shipping AS free_shipping_28, x0_.taxable AS taxable_29, x0_.arrivalDate AS arrivalDate_30, x0_.date AS date_31, x0_.updateDate AS updateDate_32, x0_.needProcess AS needProcess_33, x0_.inventoryEnabled AS inventoryEnabled_34, x0_.amount AS amount_35, x0_.lowLimitEnabledCustomer AS lowLimitEnabledCustomer_36, x0_.lowLimitEnabled AS lowLimitEnabled_37, x0_.lowLimitAmount AS lowLimitAmount_38, x0_.attrSepTab AS attrSepTab_39, x0_.metaDescType AS metaDescType_40, x0_.sales AS sales_41, x0_.xcPendingExport AS xcPendingExport_42, x0_.isDemoProduct AS isDemoProduct_43, x0_.quantity1 AS quantity1_44, x0_.entityVersion AS entityVersion_45, IF(x0_.discountType = 'sale_percent', x0_.salePriceValue, 100 - 100 * x0_.salePriceValue / x0_.price) AS sclr_46, x0_.product_class_id AS product_class_id_47, x0_.tax_class_id AS tax_class_id_48 FROM xc_products x0_ LEFT JOIN xc_product_translations x1_ ON x0_.product_id = x1_.id LEFT JOIN xc_product_membership_links x3_ ON x0_.product_id = x3_.product_id LEFT JOIN xc_memberships x2_ ON x2_.membership_id = x3_.membership_id LEFT JOIN xc_category_products x4_ ON x0_.product_id = x4_.product_id LEFT JOIN xc_categories x5_ ON x4_.category_id = x5_.category_id WHERE x0_.enabled = 1 AND (x0_.arrivalDate < 1765699199 OR x0_.isAvailableForBackorder = 1) AND x2_.membership_id IS NULL AND (x5_.lpos BETWEEN 121 AND 122) AND x0_.participateSale = 1 AND ((x0_.discountType = 'sale_percent' AND x0_.salePriceValue > 0) OR (x0_.discountType = 'sale_price' AND x0_.price > x0_.salePriceValue)) GROUP BY x0_.product_id ORDER BY sclr_46 DESC, x0_.product_id DESC LIMIT 3;

SELECT
  COUNT(DISTINCT x0_.id) AS sclr_0
FROM
  xc_reviews x0_
  INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id
WHERE
  x1_.product_id = ?
  AND x0_.status = ?
  AND x0_.review <> ?
LIMIT
  1

SELECT COUNT(DISTINCT x0_.id) AS sclr_0 FROM xc_reviews x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = 13247 AND x0_.status = 1 AND x0_.review <> '' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cleanURL AS cleanURL_2,
  t0.sale_discount_id AS sale_discount_id_3,
  t0.page_id AS page_id_4,
  t0.brand_id AS brand_id_5,
  t0.product_id AS product_id_6,
  t0.category_id AS category_id_7
FROM
  xc_clean_urls t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.cleanURL AS cleanURL_2, t0.sale_discount_id AS sale_discount_id_3, t0.page_id AS page_id_4, t0.brand_id AS brand_id_5, t0.product_id AS product_id_6, t0.category_id AS category_id_7 FROM xc_clean_urls t0 WHERE t0.product_id = 4969 ORDER BY t0.id ASC;

SELECT
  t0.backorderQtyLabel AS backorderQtyLabel_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.briefDescription AS briefDescription_4,
  t0.metaTags AS metaTags_5,
  t0.metaDesc AS metaDesc_6,
  t0.metaTitle AS metaTitle_7,
  t0.label_id AS label_id_8,
  t0.code AS code_9,
  t0.id AS id_10
FROM
  xc_product_translations t0
WHERE
  t0.id = ?

SELECT t0.backorderQtyLabel AS backorderQtyLabel_1, t0.name AS name_2, t0.description AS description_3, t0.briefDescription AS briefDescription_4, t0.metaTags AS metaTags_5, t0.metaDesc AS metaDesc_6, t0.metaTitle AS metaTitle_7, t0.label_id AS label_id_8, t0.code AS code_9, t0.id AS id_10 FROM xc_product_translations t0 WHERE t0.id = 4969;

SELECT
  t0.id AS id_1,
  t0.cleanURL AS cleanURL_2,
  t0.sale_discount_id AS sale_discount_id_3,
  t0.page_id AS page_id_4,
  t0.brand_id AS brand_id_5,
  t0.product_id AS product_id_6,
  t0.category_id AS category_id_7
FROM
  xc_clean_urls t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.cleanURL AS cleanURL_2, t0.sale_discount_id AS sale_discount_id_3, t0.page_id AS page_id_4, t0.brand_id AS brand_id_5, t0.product_id AS product_id_6, t0.category_id AS category_id_7 FROM xc_clean_urls t0 WHERE t0.category_id = 1485 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.template AS template_3,
  t0.body AS body_4,
  t0.date AS date_5
FROM
  xc_theme_tweaker_template t0
WHERE
  t0.template = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.template AS template_3, t0.body AS body_4, t0.date AS date_5 FROM xc_theme_tweaker_template t0 WHERE t0.template = 'web/customer/layout/header/header.bar.links.logged.twig' AND t0.enabled = 1 LIMIT 1;

SELECT
  x0_.csiProfileType AS csiProfileType_0,
  x0_.rewardPoints AS rewardPoints_1,
  x0_.taxExempt AS taxExempt_2,
  x0_.emailConfirmed AS emailConfirmed_3,
  x0_.emailConfirmationCode AS emailConfirmationCode_4,
  x0_.emailConfirmationCodeDate AS emailConfirmationCodeDate_5,
  x0_.newLogin AS newLogin_6,
  x0_.profile_id AS profile_id_7,
  x0_.login AS login_8,
  x0_.password AS password_9,
  x0_.password_hint AS password_hint_10,
  x0_.password_hint_answer AS password_hint_answer_11,
  x0_.passwordResetKey AS passwordResetKey_12,
  x0_.passwordResetKeyDate AS passwordResetKeyDate_13,
  x0_.access_level AS access_level_14,
  x0_.added AS added_15,
  x0_.first_login AS first_login_16,
  x0_.last_login AS last_login_17,
  x0_.status AS status_18,
  x0_.statusComment AS statusComment_19,
  x0_.referer AS referer_20,
  x0_.language AS language_21,
  x0_.last_shipping_id AS last_shipping_id_22,
  x0_.last_payment_id AS last_payment_id_23,
  x0_.anonymous AS anonymous_24,
  x0_.forceChangePassword AS forceChangePassword_25,
  x0_.dateOfLoginAttempt AS dateOfLoginAttempt_26,
  x0_.countOfLoginAttempts AS countOfLoginAttempts_27,
  x0_.searchFakeField AS searchFakeField_28,
  x0_.xcPendingExport AS xcPendingExport_29,
  x0_.lastCheckoutEmail AS lastCheckoutEmail_30,
  x0_.order_id AS order_id_31,
  x0_.membership_id AS membership_id_32,
  x0_.pending_membership_id AS pending_membership_id_33
FROM
  xc_profiles x0_
  LEFT JOIN xc_profile_addresses x1_ ON x0_.profile_id = x1_.profile_id
WHERE
  (
    x0_.order_id IS NULL
    AND x0_.anonymous <> ?
  )
  AND x0_.login = ?
  AND x0_.status = ?
LIMIT
  1