Symfony Profiler

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
  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
  x0_.name AS name_0,
  COUNT(DISTINCT x1_.product_id) AS sclr_1,
  x2_.brand_id AS brand_id_2,
  x2_.position AS position_3,
  x2_.enabled AS enabled_4,
  x3_.id AS id_5,
  x3_.addToNew AS addToNew_6,
  x3_.position AS position_7,
  x4_.alt AS alt_8,
  x4_.width AS width_9,
  x4_.height AS height_10,
  x4_.hash AS hash_11,
  x4_.needProcess AS needProcess_12,
  x4_.id AS id_13,
  x4_.path AS path_14,
  x4_.fileName AS fileName_15,
  x4_.mime AS mime_16,
  x4_.storageType AS storageType_17,
  x4_.size AS size_18,
  x4_.date AS date_19,
  x2_.attribute_option_id AS attribute_option_id_20,
  x3_.attribute_id AS attribute_id_21,
  x4_.brand_id AS brand_id_22
FROM
  xc_brands x2_
  LEFT JOIN xc_brand_products x5_ ON (x5_.brand_id = x2_.brand_id)
  INNER JOIN xc_attribute_options x3_ ON x2_.attribute_option_id = x3_.id
  INNER JOIN xc_attribute_option_translations x0_ ON x3_.id = x0_.id
  LEFT JOIN xc_brand_images x4_ ON x2_.brand_id = x4_.brand_id
  INNER JOIN xc_attribute_values_select x6_ ON x3_.id = x6_.attribute_option_id
  INNER JOIN xc_products x1_ ON x6_.product_id = x1_.product_id
WHERE
  x2_.enabled = ?
  AND x1_.enabled = ?
GROUP BY
  x2_.brand_id
ORDER BY
  x0_.name ASC

SELECT x0_.name AS name_0, COUNT(DISTINCT x1_.product_id) AS sclr_1, x2_.brand_id AS brand_id_2, x2_.position AS position_3, x2_.enabled AS enabled_4, x3_.id AS id_5, x3_.addToNew AS addToNew_6, x3_.position AS position_7, x4_.alt AS alt_8, x4_.width AS width_9, x4_.height AS height_10, x4_.hash AS hash_11, x4_.needProcess AS needProcess_12, x4_.id AS id_13, x4_.path AS path_14, x4_.fileName AS fileName_15, x4_.mime AS mime_16, x4_.storageType AS storageType_17, x4_.size AS size_18, x4_.date AS date_19, x2_.attribute_option_id AS attribute_option_id_20, x3_.attribute_id AS attribute_id_21, x4_.brand_id AS brand_id_22 FROM xc_brands x2_ LEFT JOIN xc_brand_products x5_ ON (x5_.brand_id = x2_.brand_id) INNER JOIN xc_attribute_options x3_ ON x2_.attribute_option_id = x3_.id INNER JOIN xc_attribute_option_translations x0_ ON x3_.id = x0_.id LEFT JOIN xc_brand_images x4_ ON x2_.brand_id = x4_.brand_id INNER JOIN xc_attribute_values_select x6_ ON x3_.id = x6_.attribute_option_id INNER JOIN xc_products x1_ ON x6_.product_id = x1_.product_id WHERE x2_.enabled = 1 AND x1_.enabled = 1 GROUP BY x2_.brand_id ORDER BY x0_.name 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.brand_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.brand_id = 21 ORDER BY t0.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 = ?
  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
  x0_.list_id AS list_id_0,
  x0_.list AS list_1,
  x0_.interface AS interface_2,
  x0_.zone AS zone_3,
  x0_.child AS child_4,
  x0_.weight AS weight_5,
  x0_.tpl AS tpl_6,
  x0_.version AS version_7,
  x0_.preset AS preset_8,
  x0_.list_override AS list_override_9,
  x0_.weight_override AS weight_override_10,
  x0_.override_mode AS override_mode_11,
  x0_.deleted AS deleted_12,
  x0_.entityId AS entityId_13,
  CASE WHEN x0_.override_mode > 0 THEN x0_.weight_override ELSE x0_.weight END AS sclr_14,
  x0_.parent_id AS parent_id_15
FROM
  xc_view_lists x0_
WHERE
  (
    IF(
      x0_.list_override <> ?
      AND x0_.override_mode > 0,
      x0_.list_override,
      x0_.list
    ) IN (?)
  )
  AND (
    x0_.list_id NOT IN (
      SELECT
        DISTINCT x1_.parent_id AS sclr_16
      FROM
        xc_view_lists x1_
      WHERE
        x1_.parent_id IS NOT NULL
        AND x1_.preset LIKE ?
        AND x1_.override_mode <> ?
    )
  )
  AND (
    x0_.list_id NOT IN (
      SELECT
        DISTINCT x2_.list_id
      FROM
        xc_view_lists x2_
      WHERE
        x2_.parent_id IS NOT NULL
        AND (
          x2_.preset NOT LIKE ?
          OR x2_.override_mode = ?
        )
    )
  )
  AND x0_.version IS NULL
  AND x0_.override_mode IN (?, ?)
  AND x0_.deleted = ?
  AND x0_.interface LIKE ?
  AND x0_.zone LIKE ?
ORDER BY
  sclr_14 ASC

SELECT x0_.list_id AS list_id_0, x0_.list AS list_1, x0_.interface AS interface_2, x0_.zone AS zone_3, x0_.child AS child_4, x0_.weight AS weight_5, x0_.tpl AS tpl_6, x0_.version AS version_7, x0_.preset AS preset_8, x0_.list_override AS list_override_9, x0_.weight_override AS weight_override_10, x0_.override_mode AS override_mode_11, x0_.deleted AS deleted_12, x0_.entityId AS entityId_13, CASE WHEN x0_.override_mode > 0 THEN x0_.weight_override ELSE x0_.weight END AS sclr_14, x0_.parent_id AS parent_id_15 FROM xc_view_lists x0_ WHERE (IF(x0_.list_override <> '' AND x0_.override_mode > 0, x0_.list_override, x0_.list) IN ('customer.brands')) AND (x0_.list_id NOT IN (SELECT DISTINCT x1_.parent_id AS sclr_16 FROM xc_view_lists x1_ WHERE x1_.parent_id IS NOT NULL AND x1_.preset LIKE 'left' AND x1_.override_mode <> 3)) AND (x0_.list_id NOT IN (SELECT DISTINCT x2_.list_id FROM xc_view_lists x2_ WHERE x2_.parent_id IS NOT NULL AND (x2_.preset NOT LIKE 'left' OR x2_.override_mode = 3))) AND x0_.version IS NULL AND x0_.override_mode IN (0, 1) AND x0_.deleted = 0 AND x0_.interface LIKE 'web' AND x0_.zone LIKE 'customer' ORDER BY sclr_14 ASC;

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

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 <> 1) AND x0_.login = '' AND x0_.status = 'E' 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 = ?
  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_.popup_id AS popup_id_0,
  x0_.enabled AS enabled_1,
  x0_.position AS position_2,
  x0_.popupType AS popupType_3,
  x0_.displayMode AS displayMode_4,
  x0_.showCloseButton AS showCloseButton_5,
  x0_.displayPeriod AS displayPeriod_6,
  x0_.delay AS delay_7,
  x0_.modal AS modal_8,
  x0_.width AS width_9,
  x0_.widthType AS widthType_10,
  x0_.location AS location_11,
  x0_.animation AS animation_12,
  x0_.targetPages AS targetPages_13,
  x0_.blockedPages AS blockedPages_14,
  x0_.activeFrom AS activeFrom_15,
  x0_.activeTill AS activeTill_16,
  x0_.customTemplate AS customTemplate_17,
  x0_.targetUsers AS targetUsers_18,
  x0_.minItemQty AS minItemQty_19,
  x0_.maxItemQty AS maxItemQty_20,
  x0_.minCartTotal AS minCartTotal_21,
  x0_.maxCartTotal AS maxCartTotal_22
FROM
  xc_anywhere_popups x0_
  LEFT JOIN xc_anywhere_popup_translations x1_ ON x0_.popup_id = x1_.id
  AND (x1_.code = ?)
WHERE
  x0_.enabled <> 0
  AND (
    (
      (x0_.activeFrom = 0)
      OR (x0_.activeFrom <= ?)
    )
    AND (
      (x0_.activeTill = 0)
      OR (x0_.activeTill >= ?)
    )
  )
GROUP BY
  x0_.popup_id

SELECT x0_.popup_id AS popup_id_0, x0_.enabled AS enabled_1, x0_.position AS position_2, x0_.popupType AS popupType_3, x0_.displayMode AS displayMode_4, x0_.showCloseButton AS showCloseButton_5, x0_.displayPeriod AS displayPeriod_6, x0_.delay AS delay_7, x0_.modal AS modal_8, x0_.width AS width_9, x0_.widthType AS widthType_10, x0_.location AS location_11, x0_.animation AS animation_12, x0_.targetPages AS targetPages_13, x0_.blockedPages AS blockedPages_14, x0_.activeFrom AS activeFrom_15, x0_.activeTill AS activeTill_16, x0_.customTemplate AS customTemplate_17, x0_.targetUsers AS targetUsers_18, x0_.minItemQty AS minItemQty_19, x0_.maxItemQty AS maxItemQty_20, x0_.minCartTotal AS minCartTotal_21, x0_.maxCartTotal AS maxCartTotal_22 FROM xc_anywhere_popups x0_ LEFT JOIN xc_anywhere_popup_translations x1_ ON x0_.popup_id = x1_.id AND (x1_.code = 'en') WHERE x0_.enabled <> 0 AND (((x0_.activeFrom = 0) OR (x0_.activeFrom <= 1765698104)) AND ((x0_.activeTill = 0) OR (x0_.activeTill >= 1765698104))) GROUP BY x0_.popup_id;

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.lpos = ?
LIMIT
  1

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.lpos = 1 LIMIT 1;

SELECT
  x0_.id AS id_0,
  x0_.entityType AS entityType_1,
  x0_.version AS version_2
FROM
  xc_entity_type_versions x0_

SELECT x0_.id AS id_0, x0_.entityType AS entityType_1, x0_.version AS version_2 FROM xc_entity_type_versions x0_;

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.lpos = ?
LIMIT
  1

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.lpos = 1 LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.customHeader AS customHeader_2,
  t0.body AS body_3,
  t0.label_id AS label_id_4,
  t0.code AS code_5,
  t0.id AS id_6
FROM
  xc_anywhere_popup_translations t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.customHeader AS customHeader_2, t0.body AS body_3, t0.label_id AS label_id_4, t0.code AS code_5, t0.id AS id_6 FROM xc_anywhere_popup_translations t0 WHERE t0.id = 11;

SELECT
  x0_.id AS id_0,
  x0_.cleanURL AS cleanURL_1,
  x0_.sale_discount_id AS sale_discount_id_2,
  x0_.page_id AS page_id_3,
  x0_.brand_id AS brand_id_4,
  x0_.product_id AS product_id_5,
  x0_.category_id AS category_id_6
FROM
  xc_clean_urls x0_
  INNER JOIN xc_categories x1_ ON x0_.category_id = x1_.category_id
WHERE
  x0_.cleanURL = ?
  AND x0_.category_id IS NOT NULL
  AND x1_.parent_id = ?
ORDER BY
  x0_.id DESC
LIMIT
  1

SELECT x0_.id AS id_0, x0_.cleanURL AS cleanURL_1, x0_.sale_discount_id AS sale_discount_id_2, x0_.page_id AS page_id_3, x0_.brand_id AS brand_id_4, x0_.product_id AS product_id_5, x0_.category_id AS category_id_6 FROM xc_clean_urls x0_ INNER JOIN xc_categories x1_ ON x0_.category_id = x1_.category_id WHERE x0_.cleanURL = 'all-brands' AND x0_.category_id IS NOT NULL AND x1_.parent_id = 1 ORDER BY x0_.id DESC LIMIT 1;

SELECT
  x0_.id AS id_0,
  x0_.value AS value_1,
  x0_.name AS name_2,
  x0_.used AS used_3,
  x0_.order_id AS order_id_4,
  x0_.card_id AS card_id_5
FROM
  xc_gift_certificates_orders x0_
WHERE
  x0_.order_id = ?

SELECT x0_.id AS id_0, x0_.value AS value_1, x0_.name AS name_2, x0_.used AS used_3, x0_.order_id AS order_id_4, x0_.card_id AS card_id_5 FROM xc_gift_certificates_orders x0_ WHERE x0_.order_id = NULL;

SELECT
  x0_.id AS id_0,
  x0_.cleanURL AS cleanURL_1,
  x0_.sale_discount_id AS sale_discount_id_2,
  x0_.page_id AS page_id_3,
  x0_.brand_id AS brand_id_4,
  x0_.product_id AS product_id_5,
  x0_.category_id AS category_id_6
FROM
  xc_clean_urls x0_
WHERE
  x0_.cleanURL = ?
  AND x0_.product_id IS NOT NULL
ORDER BY
  x0_.id DESC
LIMIT
  1

SELECT x0_.id AS id_0, x0_.cleanURL AS cleanURL_1, x0_.sale_discount_id AS sale_discount_id_2, x0_.page_id AS page_id_3, x0_.brand_id AS brand_id_4, x0_.product_id AS product_id_5, x0_.category_id AS category_id_6 FROM xc_clean_urls x0_ WHERE x0_.cleanURL = 'all-brands' AND x0_.product_id IS NOT NULL ORDER BY x0_.id DESC LIMIT 1;

SELECT
  t0.state_id AS state_id_1,
  t0.state AS state_2,
  t0.code AS code_3,
  t0.country_code AS country_code_4,
  t0.region_code AS region_code_5
FROM
  xc_states t0
WHERE
  t0.country_code = ?
ORDER BY
  t0.state ASC

SELECT t0.state_id AS state_id_1, t0.state AS state_2, t0.code AS code_3, t0.country_code AS country_code_4, t0.region_code AS region_code_5 FROM xc_states t0 WHERE t0.country_code = 'CA' ORDER BY t0.state ASC;

SELECT
  x0_.id AS id_0,
  x0_.code AS code_1,
  x0_.model AS model_2,
  x0_.moduleName AS moduleName_3,
  x0_.width AS width_4,
  x0_.height AS height_5
FROM
  xc_images_settings x0_
WHERE
  x0_.moduleName = ?

SELECT x0_.id AS id_0, x0_.code AS code_1, x0_.model AS model_2, x0_.moduleName AS moduleName_3, x0_.width AS width_4, x0_.height AS height_5 FROM xc_images_settings x0_ WHERE x0_.moduleName = 'XC-CrispWhiteSkin';

SELECT
  t0.id AS id_1,
  t0.wishlistName AS wishlistName_2,
  t0.hash AS hash_3,
  t0.profile_id AS profile_id_4
FROM
  xc_wishlists t0
WHERE
  t0.profile_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.wishlistName AS wishlistName_2, t0.hash AS hash_3, t0.profile_id AS profile_id_4 FROM xc_wishlists t0 WHERE t0.profile_id IS NULL LIMIT 1;

SELECT
  x0_.lng_id AS lng_id_0,
  x0_.code AS code_1,
  x0_.code3 AS code3_2,
  x0_.r2l AS r2l_3,
  x0_.added AS added_4,
  x0_.enabled AS enabled_5,
  x0_.module AS module_6
FROM
  xc_languages x0_
WHERE
  x0_.added = 1
  AND x0_.enabled = ?

SELECT x0_.lng_id AS lng_id_0, x0_.code AS code_1, x0_.code3 AS code3_2, x0_.r2l AS r2l_3, x0_.added AS added_4, x0_.enabled AS enabled_5, x0_.module AS module_6 FROM xc_languages x0_ WHERE x0_.added = 1 AND x0_.enabled = 1;

SELECT
  t0.code AS code_1,
  t0.id AS id_2,
  t0.code3 AS code3_3,
  t0.enabled AS enabled_4,
  t0.currency_id AS currency_id_5,
  t0.lng_id AS lng_id_6
FROM
  xc_countries t0
WHERE
  t0.code = ?

SELECT t0.code AS code_1, t0.id AS id_2, t0.code3 AS code3_3, t0.enabled AS enabled_4, t0.currency_id AS currency_id_5, t0.lng_id AS lng_id_6 FROM xc_countries t0 WHERE t0.code = 'CA';

SELECT
  x0_.id AS id_0,
  x0_.cleanURL AS cleanURL_1,
  x0_.sale_discount_id AS sale_discount_id_2,
  x0_.page_id AS page_id_3,
  x0_.brand_id AS brand_id_4,
  x0_.product_id AS product_id_5,
  x0_.category_id AS category_id_6
FROM
  xc_clean_urls x0_
WHERE
  x0_.cleanURL = ?
  AND x0_.page_id IS NOT NULL
ORDER BY
  x0_.id DESC
LIMIT
  1

SELECT x0_.id AS id_0, x0_.cleanURL AS cleanURL_1, x0_.sale_discount_id AS sale_discount_id_2, x0_.page_id AS page_id_3, x0_.brand_id AS brand_id_4, x0_.product_id AS product_id_5, x0_.category_id AS category_id_6 FROM xc_clean_urls x0_ WHERE x0_.cleanURL = 'all-brands' AND x0_.page_id IS NOT NULL ORDER BY x0_.id DESC LIMIT 1;