Symfony Profiler

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.level1_id AS level1_id_5,
  t0.level2_id AS level2_id_6,
  t0.level3_id AS level3_id_7,
  t0.level4_id AS level4_id_8,
  t0.brand_id AS brand_id_9,
  t0.news_message_id AS news_message_id_10,
  t0.product_id AS product_id_11,
  t0.category_id AS category_id_12
FROM
  xlite_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.level1_id AS level1_id_5, t0.level2_id AS level2_id_6, t0.level3_id AS level3_id_7, t0.level4_id AS level4_id_8, t0.brand_id AS brand_id_9, t0.news_message_id AS news_message_id_10, t0.product_id AS product_id_11, t0.category_id AS category_id_12 FROM xlite_clean_urls t0 WHERE t0.brand_id = 4 ORDER BY t0.id ASC;

SELECT
  t0.alt AS alt_1,
  t0.width AS width_2,
  t0.height AS height_3,
  t0.hash AS hash_4,
  t0.needProcess AS needProcess_5,
  t0.id AS id_6,
  t0.path AS path_7,
  t0.fileName AS fileName_8,
  t0.mime AS mime_9,
  t0.storageType AS storageType_10,
  t0.size AS size_11,
  t0.date AS date_12,
  t0.brand_id AS brand_id_13
FROM
  xlite_brand_images t0
WHERE
  t0.brand_id = ?

SELECT t0.alt AS alt_1, t0.width AS width_2, t0.height AS height_3, t0.hash AS hash_4, t0.needProcess AS needProcess_5, t0.id AS id_6, t0.path AS path_7, t0.fileName AS fileName_8, t0.mime AS mime_9, t0.storageType AS storageType_10, t0.size AS size_11, t0.date AS date_12, t0.brand_id AS brand_id_13 FROM xlite_brand_images t0 WHERE t0.brand_id = 1;

SELECT
  t0.name AS name_1,
  t0.label_id AS label_id_2,
  t0.code AS code_3,
  t0.id AS id_4
FROM
  xlite_attribute_option_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 xlite_attribute_option_translations t0 WHERE t0.id = 482;

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,
  x0_.parent_id AS parent_id_14
FROM
  xlite_view_lists x0_
WHERE
  x0_.child = ?
  AND x0_.tpl = ?
ORDER BY
  x0_.weight ASC,
  x0_.child ASC,
  x0_.tpl ASC,
  x0_.list_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, x0_.parent_id AS parent_id_14 FROM xlite_view_lists x0_ WHERE x0_.child = 'QSL\\Make\\View\\LevelSelectorBox' AND x0_.tpl = '' ORDER BY x0_.weight ASC, x0_.child ASC, x0_.tpl ASC, x0_.list_id ASC;

SELECT
  COUNT(DISTINCT x0_.id) AS sclr_0
FROM
  xlite_level1 x0_
  LEFT JOIN xlite_level1_translations x1_ ON x0_.id = x1_.id
  AND (x1_.code = ?)
WHERE
  x0_.enabled = ?

SELECT COUNT(DISTINCT x0_.id) AS sclr_0 FROM xlite_level1 x0_ LEFT JOIN xlite_level1_translations x1_ ON x0_.id = x1_.id AND (x1_.code = 'en') WHERE x0_.enabled = 1;

SELECT
  t0.anti_fraud_check AS anti_fraud_check_1,
  t0.method_id AS method_id_2,
  t0.service_name AS service_name_3,
  t0.class AS class_4,
  t0.moduleName AS moduleName_5,
  t0.orderby AS orderby_6,
  t0.adminOrderby AS adminOrderby_7,
  t0.enabled AS enabled_8,
  t0.added AS added_9,
  t0.creditCardRate AS creditCardRate_10,
  t0.transactionFee AS transactionFee_11,
  t0.predefined AS predefined_12,
  t0.type AS type_13,
  t0.fromMarketplace AS fromMarketplace_14,
  t0.modulePageURL AS modulePageURL_15,
  t0.countries AS countries_16,
  t0.exCountries AS exCountries_17
FROM
  xlite_payment_methods t0
WHERE
  t0.method_id = ?

SELECT t0.anti_fraud_check AS anti_fraud_check_1, t0.method_id AS method_id_2, t0.service_name AS service_name_3, t0.class AS class_4, t0.moduleName AS moduleName_5, t0.orderby AS orderby_6, t0.adminOrderby AS adminOrderby_7, t0.enabled AS enabled_8, t0.added AS added_9, t0.creditCardRate AS creditCardRate_10, t0.transactionFee AS transactionFee_11, t0.predefined AS predefined_12, t0.type AS type_13, t0.fromMarketplace AS fromMarketplace_14, t0.modulePageURL AS modulePageURL_15, t0.countries AS countries_16, t0.exCountries AS exCountries_17 FROM xlite_payment_methods t0 WHERE t0.method_id = 13;

SELECT
  t0.anti_fraud_check AS anti_fraud_check_1,
  t0.method_id AS method_id_2,
  t0.service_name AS service_name_3,
  t0.class AS class_4,
  t0.moduleName AS moduleName_5,
  t0.orderby AS orderby_6,
  t0.adminOrderby AS adminOrderby_7,
  t0.enabled AS enabled_8,
  t0.added AS added_9,
  t0.creditCardRate AS creditCardRate_10,
  t0.transactionFee AS transactionFee_11,
  t0.predefined AS predefined_12,
  t0.type AS type_13,
  t0.fromMarketplace AS fromMarketplace_14,
  t0.modulePageURL AS modulePageURL_15,
  t0.countries AS countries_16,
  t0.exCountries AS exCountries_17
FROM
  xlite_payment_methods t0
WHERE
  t0.service_name = ?
LIMIT
  1

SELECT t0.anti_fraud_check AS anti_fraud_check_1, t0.method_id AS method_id_2, t0.service_name AS service_name_3, t0.class AS class_4, t0.moduleName AS moduleName_5, t0.orderby AS orderby_6, t0.adminOrderby AS adminOrderby_7, t0.enabled AS enabled_8, t0.added AS added_9, t0.creditCardRate AS creditCardRate_10, t0.transactionFee AS transactionFee_11, t0.predefined AS predefined_12, t0.type AS type_13, t0.fromMarketplace AS fromMarketplace_14, t0.modulePageURL AS modulePageURL_15, t0.countries AS countries_16, t0.exCountries AS exCountries_17 FROM xlite_payment_methods t0 WHERE t0.service_name = 'PaypalWPS' 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_.level1_id AS level1_id_4,
  x0_.level2_id AS level2_id_5,
  x0_.level3_id AS level3_id_6,
  x0_.level4_id AS level4_id_7,
  x0_.brand_id AS brand_id_8,
  x0_.news_message_id AS news_message_id_9,
  x0_.product_id AS product_id_10,
  x0_.category_id AS category_id_11
FROM
  xlite_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_.level1_id AS level1_id_4, x0_.level2_id AS level2_id_5, x0_.level3_id AS level3_id_6, x0_.level4_id AS level4_id_7, x0_.brand_id AS brand_id_8, x0_.news_message_id AS news_message_id_9, x0_.product_id AS product_id_10, x0_.category_id AS category_id_11 FROM xlite_clean_urls x0_ WHERE x0_.cleanURL = 'all-brands' AND x0_.product_id IS NOT NULL ORDER BY x0_.id DESC LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.adminDescription AS adminDescription_4,
  t0.altAdminDescription AS altAdminDescription_5,
  t0.instruction AS instruction_6,
  t0.label_id AS label_id_7,
  t0.code AS code_8,
  t0.id AS id_9
FROM
  xlite_payment_method_translations t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.title AS title_2, t0.description AS description_3, t0.adminDescription AS adminDescription_4, t0.altAdminDescription AS altAdminDescription_5, t0.instruction AS instruction_6, t0.label_id AS label_id_7, t0.code AS code_8, t0.id AS id_9 FROM xlite_payment_method_translations t0 WHERE t0.id = 13;

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
  xlite_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
        xlite_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
        xlite_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 xlite_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 xlite_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 xlite_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_.socialLoginProvider AS socialLoginProvider_0,
  x0_.socialLoginId AS socialLoginId_1,
  x0_.gaClientId AS gaClientId_2,
  x0_.gaSessionId AS gaSessionId_3,
  x0_.numberOfReminderCoupons AS numberOfReminderCoupons_4,
  x0_.af_ip_address AS af_ip_address_5,
  x0_.af_proxy_ip_address AS af_proxy_ip_address_6,
  x0_.braintree_customer_id AS braintree_customer_id_7,
  x0_.saveCardBoxChecked AS saveCardBoxChecked_8,
  x0_.rewardPoints AS rewardPoints_9,
  x0_.storedSelectors AS storedSelectors_10,
  x0_.conciergeUserId AS conciergeUserId_11,
  x0_.stripeCustomerId AS stripeCustomerId_12,
  x0_.xpaymentsCustomerId AS xpaymentsCustomerId_13,
  x0_.profile_id AS profile_id_14,
  x0_.login AS login_15,
  x0_.password AS password_16,
  x0_.password_hint AS password_hint_17,
  x0_.password_hint_answer AS password_hint_answer_18,
  x0_.passwordResetKey AS passwordResetKey_19,
  x0_.passwordResetKeyDate AS passwordResetKeyDate_20,
  x0_.access_level AS access_level_21,
  x0_.added AS added_22,
  x0_.first_login AS first_login_23,
  x0_.last_login AS last_login_24,
  x0_.status AS status_25,
  x0_.statusComment AS statusComment_26,
  x0_.referer AS referer_27,
  x0_.language AS language_28,
  x0_.last_shipping_id AS last_shipping_id_29,
  x0_.last_payment_id AS last_payment_id_30,
  x0_.anonymous AS anonymous_31,
  x0_.forceChangePassword AS forceChangePassword_32,
  x0_.dateOfLoginAttempt AS dateOfLoginAttempt_33,
  x0_.countOfLoginAttempts AS countOfLoginAttempts_34,
  x0_.searchFakeField AS searchFakeField_35,
  x0_.xcPendingExport AS xcPendingExport_36,
  x0_.lastCheckoutEmail AS lastCheckoutEmail_37,
  x0_.order_id AS order_id_38,
  x0_.membership_id AS membership_id_39,
  x0_.pending_membership_id AS pending_membership_id_40
FROM
  xlite_profiles x0_
  LEFT JOIN xlite_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_.socialLoginProvider AS socialLoginProvider_0, x0_.socialLoginId AS socialLoginId_1, x0_.gaClientId AS gaClientId_2, x0_.gaSessionId AS gaSessionId_3, x0_.numberOfReminderCoupons AS numberOfReminderCoupons_4, x0_.af_ip_address AS af_ip_address_5, x0_.af_proxy_ip_address AS af_proxy_ip_address_6, x0_.braintree_customer_id AS braintree_customer_id_7, x0_.saveCardBoxChecked AS saveCardBoxChecked_8, x0_.rewardPoints AS rewardPoints_9, x0_.storedSelectors AS storedSelectors_10, x0_.conciergeUserId AS conciergeUserId_11, x0_.stripeCustomerId AS stripeCustomerId_12, x0_.xpaymentsCustomerId AS xpaymentsCustomerId_13, x0_.profile_id AS profile_id_14, x0_.login AS login_15, x0_.password AS password_16, x0_.password_hint AS password_hint_17, x0_.password_hint_answer AS password_hint_answer_18, x0_.passwordResetKey AS passwordResetKey_19, x0_.passwordResetKeyDate AS passwordResetKeyDate_20, x0_.access_level AS access_level_21, x0_.added AS added_22, x0_.first_login AS first_login_23, x0_.last_login AS last_login_24, x0_.status AS status_25, x0_.statusComment AS statusComment_26, x0_.referer AS referer_27, x0_.language AS language_28, x0_.last_shipping_id AS last_shipping_id_29, x0_.last_payment_id AS last_payment_id_30, x0_.anonymous AS anonymous_31, x0_.forceChangePassword AS forceChangePassword_32, x0_.dateOfLoginAttempt AS dateOfLoginAttempt_33, x0_.countOfLoginAttempts AS countOfLoginAttempts_34, x0_.searchFakeField AS searchFakeField_35, x0_.xcPendingExport AS xcPendingExport_36, x0_.lastCheckoutEmail AS lastCheckoutEmail_37, x0_.order_id AS order_id_38, x0_.membership_id AS membership_id_39, x0_.pending_membership_id AS pending_membership_id_40 FROM xlite_profiles x0_ LEFT JOIN xlite_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
  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_.level1_id AS level1_id_4,
  x0_.level2_id AS level2_id_5,
  x0_.level3_id AS level3_id_6,
  x0_.level4_id AS level4_id_7,
  x0_.brand_id AS brand_id_8,
  x0_.news_message_id AS news_message_id_9,
  x0_.product_id AS product_id_10,
  x0_.category_id AS category_id_11
FROM
  xlite_clean_urls x0_
WHERE
  x0_.cleanURL = ?
  AND x0_.level1_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_.level1_id AS level1_id_4, x0_.level2_id AS level2_id_5, x0_.level3_id AS level3_id_6, x0_.level4_id AS level4_id_7, x0_.brand_id AS brand_id_8, x0_.news_message_id AS news_message_id_9, x0_.product_id AS product_id_10, x0_.category_id AS category_id_11 FROM xlite_clean_urls x0_ WHERE x0_.cleanURL = 'all-brands' AND x0_.level1_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_.level1_id AS level1_id_4,
  x0_.level2_id AS level2_id_5,
  x0_.level3_id AS level3_id_6,
  x0_.level4_id AS level4_id_7,
  x0_.brand_id AS brand_id_8,
  x0_.news_message_id AS news_message_id_9,
  x0_.product_id AS product_id_10,
  x0_.category_id AS category_id_11
FROM
  xlite_clean_urls x0_
  INNER JOIN xlite_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_.level1_id AS level1_id_4, x0_.level2_id AS level2_id_5, x0_.level3_id AS level3_id_6, x0_.level4_id AS level4_id_7, x0_.brand_id AS brand_id_8, x0_.news_message_id AS news_message_id_9, x0_.product_id AS product_id_10, x0_.category_id AS category_id_11 FROM xlite_clean_urls x0_ INNER JOIN xlite_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_.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
  xlite_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 xlite_images_settings x0_ WHERE x0_.moduleName = 'XC-CrispWhiteSkin';

SELECT
  x0_.name AS name_0,
  COUNT(DISTINCT x1_.product_id) AS sclr_1,
  CASE WHEN x2_.position IS NULL
  OR x2_.position = '' THEN 0 ELSE 1 END AS sclr_2,
  x2_.aaiaId AS aaiaId_3,
  x2_.brand_id AS brand_id_4,
  x2_.position AS position_5,
  x2_.enabled AS enabled_6,
  x3_.id AS id_7,
  x3_.addToNew AS addToNew_8,
  x3_.position AS position_9,
  x4_.alt AS alt_10,
  x4_.width AS width_11,
  x4_.height AS height_12,
  x4_.hash AS hash_13,
  x4_.needProcess AS needProcess_14,
  x4_.id AS id_15,
  x4_.path AS path_16,
  x4_.fileName AS fileName_17,
  x4_.mime AS mime_18,
  x4_.storageType AS storageType_19,
  x4_.size AS size_20,
  x4_.date AS date_21,
  x2_.attribute_option_id AS attribute_option_id_22,
  x3_.swatch_id AS swatch_id_23,
  x3_.attribute_id AS attribute_id_24,
  x4_.brand_id AS brand_id_25
FROM
  xlite_brands x2_
  LEFT JOIN xlite_brand_products x5_ ON (x5_.brand_id = x2_.brand_id)
  INNER JOIN xlite_attribute_options x3_ ON x2_.attribute_option_id = x3_.id
  INNER JOIN xlite_attribute_option_translations x0_ ON x3_.id = x0_.id
  LEFT JOIN xlite_brand_images x4_ ON x2_.brand_id = x4_.brand_id
  INNER JOIN xlite_attribute_values_select x6_ ON x3_.id = x6_.attribute_option_id
  INNER JOIN xlite_products x1_ ON x6_.product_id = x1_.product_id
WHERE
  x2_.enabled = ?
  AND x1_.enabled = ?
  AND (
    x1_.inventoryEnabled = 0
    OR (
      x1_.localStockEnabled = 1
      AND x1_.amount > 0
    )
  )
GROUP BY
  x2_.brand_id
ORDER BY
  sclr_2 DESC,
  x2_.position ASC

SELECT x0_.name AS name_0, COUNT(DISTINCT x1_.product_id) AS sclr_1, CASE WHEN x2_.position IS NULL OR x2_.position = '' THEN 0 ELSE 1 END AS sclr_2, x2_.aaiaId AS aaiaId_3, x2_.brand_id AS brand_id_4, x2_.position AS position_5, x2_.enabled AS enabled_6, x3_.id AS id_7, x3_.addToNew AS addToNew_8, x3_.position AS position_9, x4_.alt AS alt_10, x4_.width AS width_11, x4_.height AS height_12, x4_.hash AS hash_13, x4_.needProcess AS needProcess_14, x4_.id AS id_15, x4_.path AS path_16, x4_.fileName AS fileName_17, x4_.mime AS mime_18, x4_.storageType AS storageType_19, x4_.size AS size_20, x4_.date AS date_21, x2_.attribute_option_id AS attribute_option_id_22, x3_.swatch_id AS swatch_id_23, x3_.attribute_id AS attribute_id_24, x4_.brand_id AS brand_id_25 FROM xlite_brands x2_ LEFT JOIN xlite_brand_products x5_ ON (x5_.brand_id = x2_.brand_id) INNER JOIN xlite_attribute_options x3_ ON x2_.attribute_option_id = x3_.id INNER JOIN xlite_attribute_option_translations x0_ ON x3_.id = x0_.id LEFT JOIN xlite_brand_images x4_ ON x2_.brand_id = x4_.brand_id INNER JOIN xlite_attribute_values_select x6_ ON x3_.id = x6_.attribute_option_id INNER JOIN xlite_products x1_ ON x6_.product_id = x1_.product_id WHERE x2_.enabled = 1 AND x1_.enabled = 1 AND (x1_.inventoryEnabled = 0 OR (x1_.localStockEnabled = 1 AND x1_.amount > 0)) GROUP BY x2_.brand_id ORDER BY sclr_2 DESC, x2_.position ASC;

SELECT
  COUNT(DISTINCT x0_.id) AS sclr_0
FROM
  xlite_news x0_
  LEFT JOIN xlite_news_message_translations x1_ ON x0_.id = x1_.id
  AND (x1_.code = ?)
WHERE
  x0_.enabled = ?
  AND x0_.date < ?

SELECT COUNT(DISTINCT x0_.id) AS sclr_0 FROM xlite_news x0_ LEFT JOIN xlite_news_message_translations x1_ ON x0_.id = x1_.id AND (x1_.code = 'en') WHERE x0_.enabled = 1 AND x0_.date < 1746073676;

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
  xlite_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 xlite_languages x0_ WHERE x0_.added = 1 AND x0_.enabled = 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
  xlite_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 xlite_wishlists t0 WHERE t0.profile_id IS NULL LIMIT 1;

SELECT
  x0_.active_currency_id AS active_currency_id_0,
  x0_.rate AS rate_1,
  x0_.enabled AS enabled_2,
  x0_.position AS position_3,
  x0_.rateDate AS rateDate_4,
  x0_.currency_id AS currency_id_5
FROM
  xlite_active_currencies x0_
  INNER JOIN xlite_currencies x1_ ON x0_.currency_id = x1_.currency_id
WHERE
  x1_.code = ?
  AND x0_.enabled = ?
LIMIT
  1

SELECT x0_.active_currency_id AS active_currency_id_0, x0_.rate AS rate_1, x0_.enabled AS enabled_2, x0_.position AS position_3, x0_.rateDate AS rateDate_4, x0_.currency_id AS currency_id_5 FROM xlite_active_currencies x0_ INNER JOIN xlite_currencies x1_ ON x0_.currency_id = x1_.currency_id WHERE x1_.code = NULL AND x0_.enabled = 1 LIMIT 1;

SELECT
  COUNT(DISTINCT x0_.brand_id) AS sclr_0
FROM
  xlite_brands x0_
  LEFT JOIN xlite_brand_products x1_ ON (x1_.brand_id = x0_.brand_id)
  INNER JOIN xlite_attribute_options x2_ ON x0_.attribute_option_id = x2_.id
  INNER JOIN xlite_attribute_option_translations x3_ ON x2_.id = x3_.id
  INNER JOIN xlite_attribute_values_select x4_ ON x2_.id = x4_.attribute_option_id
  INNER JOIN xlite_products x5_ ON x4_.product_id = x5_.product_id
WHERE
  x0_.enabled = ?
  AND x5_.enabled = ?
  AND (
    x5_.inventoryEnabled = 0
    OR (
      x5_.localStockEnabled = 1
      AND x5_.amount > 0
    )
  )

SELECT COUNT(DISTINCT x0_.brand_id) AS sclr_0 FROM xlite_brands x0_ LEFT JOIN xlite_brand_products x1_ ON (x1_.brand_id = x0_.brand_id) INNER JOIN xlite_attribute_options x2_ ON x0_.attribute_option_id = x2_.id INNER JOIN xlite_attribute_option_translations x3_ ON x2_.id = x3_.id INNER JOIN xlite_attribute_values_select x4_ ON x2_.id = x4_.attribute_option_id INNER JOIN xlite_products x5_ ON x4_.product_id = x5_.product_id WHERE x0_.enabled = 1 AND x5_.enabled = 1 AND (x5_.inventoryEnabled = 0 OR (x5_.localStockEnabled = 1 AND x5_.amount > 0));

SELECT
  t0.is_fraudlent AS is_fraudlent_1,
  t0.code AS code_2,
  t0.id AS id_3,
  t0.code3 AS code3_4,
  t0.enabled AS enabled_5,
  t0.active_currency AS active_currency_6,
  t0.currency_id AS currency_id_7,
  t0.lng_id AS lng_id_8
FROM
  xlite_countries t0
WHERE
  t0.code = ?

SELECT t0.is_fraudlent AS is_fraudlent_1, t0.code AS code_2, t0.id AS id_3, t0.code3 AS code3_4, t0.enabled AS enabled_5, t0.active_currency AS active_currency_6, t0.currency_id AS currency_id_7, t0.lng_id AS lng_id_8 FROM xlite_countries t0 WHERE t0.code = 'US';

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

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

SELECT
  x0_.name AS name_0,
  x1_.aaiaId AS aaiaId_1,
  x1_.brand_id AS brand_id_2,
  x1_.position AS position_3,
  x1_.enabled AS enabled_4,
  x2_.id AS id_5,
  x2_.addToNew AS addToNew_6,
  x2_.position AS position_7,
  x1_.attribute_option_id AS attribute_option_id_8,
  x2_.swatch_id AS swatch_id_9,
  x2_.attribute_id AS attribute_id_10
FROM
  xlite_brands x1_
  LEFT JOIN xlite_brand_products x3_ ON (x3_.brand_id = x1_.brand_id)
  INNER JOIN xlite_attribute_options x2_ ON x1_.attribute_option_id = x2_.id
  INNER JOIN xlite_attribute_option_translations x0_ ON x2_.id = x0_.id
  INNER JOIN xlite_attribute_values_select x4_ ON x2_.id = x4_.attribute_option_id
  INNER JOIN xlite_products x5_ ON x4_.product_id = x5_.product_id
WHERE
  x1_.enabled = ?
  AND x5_.enabled = ?
  AND (
    x5_.inventoryEnabled = 0
    OR (
      x5_.localStockEnabled = 1
      AND x5_.amount > 0
    )
  )
GROUP BY
  x1_.brand_id

SELECT x0_.name AS name_0, x1_.aaiaId AS aaiaId_1, x1_.brand_id AS brand_id_2, x1_.position AS position_3, x1_.enabled AS enabled_4, x2_.id AS id_5, x2_.addToNew AS addToNew_6, x2_.position AS position_7, x1_.attribute_option_id AS attribute_option_id_8, x2_.swatch_id AS swatch_id_9, x2_.attribute_id AS attribute_id_10 FROM xlite_brands x1_ LEFT JOIN xlite_brand_products x3_ ON (x3_.brand_id = x1_.brand_id) INNER JOIN xlite_attribute_options x2_ ON x1_.attribute_option_id = x2_.id INNER JOIN xlite_attribute_option_translations x0_ ON x2_.id = x0_.id INNER JOIN xlite_attribute_values_select x4_ ON x2_.id = x4_.attribute_option_id INNER JOIN xlite_products x5_ ON x4_.product_id = x5_.product_id WHERE x1_.enabled = 1 AND x5_.enabled = 1 AND (x5_.inventoryEnabled = 0 OR (x5_.localStockEnabled = 1 AND x5_.amount > 0)) GROUP BY x1_.brand_id;

SELECT
  t0.setting_id AS setting_id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.method_id AS method_id_4
FROM
  xlite_payment_method_settings t0
WHERE
  t0.method_id = ?