Symfony Profiler

SELECT
  t0.code AS code_1,
  t0.id AS id_2,
  t0.code3 AS code3_3,
  t0.enabled AS enabled_4,
  t0.active_currency AS active_currency_5,
  t0.currency_id AS currency_id_6,
  t0.lng_id AS lng_id_7
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.active_currency AS active_currency_5, t0.currency_id AS currency_id_6, t0.lng_id AS lng_id_7 FROM xc_countries t0 WHERE t0.code = 'US';

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 = 'US' ORDER BY t0.state 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_.braintree_customer_id AS braintree_customer_id_5,
  x0_.saveCardBoxChecked AS saveCardBoxChecked_6,
  x0_.conciergeUserId AS conciergeUserId_7,
  x0_.stripeCustomerId AS stripeCustomerId_8,
  x0_.xpaymentsCustomerId AS xpaymentsCustomerId_9,
  x0_.profile_id AS profile_id_10,
  x0_.login AS login_11,
  x0_.password AS password_12,
  x0_.password_hint AS password_hint_13,
  x0_.password_hint_answer AS password_hint_answer_14,
  x0_.passwordResetKey AS passwordResetKey_15,
  x0_.passwordResetKeyDate AS passwordResetKeyDate_16,
  x0_.access_level AS access_level_17,
  x0_.added AS added_18,
  x0_.first_login AS first_login_19,
  x0_.last_login AS last_login_20,
  x0_.status AS status_21,
  x0_.statusComment AS statusComment_22,
  x0_.referer AS referer_23,
  x0_.language AS language_24,
  x0_.last_shipping_id AS last_shipping_id_25,
  x0_.last_payment_id AS last_payment_id_26,
  x0_.anonymous AS anonymous_27,
  x0_.forceChangePassword AS forceChangePassword_28,
  x0_.dateOfLoginAttempt AS dateOfLoginAttempt_29,
  x0_.countOfLoginAttempts AS countOfLoginAttempts_30,
  x0_.searchFakeField AS searchFakeField_31,
  x0_.xcPendingExport AS xcPendingExport_32,
  x0_.lastCheckoutEmail AS lastCheckoutEmail_33,
  x0_.order_id AS order_id_34,
  x0_.membership_id AS membership_id_35,
  x0_.pending_membership_id AS pending_membership_id_36
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_.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_.braintree_customer_id AS braintree_customer_id_5, x0_.saveCardBoxChecked AS saveCardBoxChecked_6, x0_.conciergeUserId AS conciergeUserId_7, x0_.stripeCustomerId AS stripeCustomerId_8, x0_.xpaymentsCustomerId AS xpaymentsCustomerId_9, x0_.profile_id AS profile_id_10, x0_.login AS login_11, x0_.password AS password_12, x0_.password_hint AS password_hint_13, x0_.password_hint_answer AS password_hint_answer_14, x0_.passwordResetKey AS passwordResetKey_15, x0_.passwordResetKeyDate AS passwordResetKeyDate_16, x0_.access_level AS access_level_17, x0_.added AS added_18, x0_.first_login AS first_login_19, x0_.last_login AS last_login_20, x0_.status AS status_21, x0_.statusComment AS statusComment_22, x0_.referer AS referer_23, x0_.language AS language_24, x0_.last_shipping_id AS last_shipping_id_25, x0_.last_payment_id AS last_payment_id_26, x0_.anonymous AS anonymous_27, x0_.forceChangePassword AS forceChangePassword_28, x0_.dateOfLoginAttempt AS dateOfLoginAttempt_29, x0_.countOfLoginAttempts AS countOfLoginAttempts_30, x0_.searchFakeField AS searchFakeField_31, x0_.xcPendingExport AS xcPendingExport_32, x0_.lastCheckoutEmail AS lastCheckoutEmail_33, x0_.order_id AS order_id_34, x0_.membership_id AS membership_id_35, x0_.pending_membership_id AS pending_membership_id_36 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
  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_.news_message_id AS news_message_id_5,
  x0_.product_id AS product_id_6,
  x0_.category_id AS category_id_7
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_.news_message_id AS news_message_id_5, x0_.product_id AS product_id_6, x0_.category_id AS category_id_7 FROM xc_clean_urls x0_ WHERE x0_.cleanURL = 'fashion' AND x0_.product_id IS NOT NULL ORDER BY x0_.id DESC LIMIT 1;

SELECT
  t0.ogMeta AS ogMeta_1,
  t0.useCustomOG AS useCustomOG_2,
  t0.csCreated AS csCreated_3,
  t0.csLastUpdate AS csLastUpdate_4,
  t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_5,
  t0.demo AS demo_6,
  t0.category_id AS category_id_7,
  t0.lpos AS lpos_8,
  t0.rpos AS rpos_9,
  t0.enabled AS enabled_10,
  t0.show_title AS show_title_11,
  t0.depth AS depth_12,
  t0.pos AS pos_13,
  t0.root_category_look AS root_category_look_14,
  t0.metaDescType AS metaDescType_15,
  t0.xcPendingExport AS xcPendingExport_16,
  t17.id AS id_18,
  t17.subcategories_count_all AS subcategories_count_all_19,
  t17.subcategories_count_enabled AS subcategories_count_enabled_20,
  t17.category_id AS category_id_21,
  t22.alt AS alt_23,
  t22.width AS width_24,
  t22.height AS height_25,
  t22.hash AS hash_26,
  t22.needProcess AS needProcess_27,
  t22.id AS id_28,
  t22.path AS path_29,
  t22.fileName AS fileName_30,
  t22.mime AS mime_31,
  t22.storageType AS storageType_32,
  t22.size AS size_33,
  t22.date AS date_34,
  t22.category_id AS category_id_35,
  t36.alt AS alt_37,
  t36.width AS width_38,
  t36.height AS height_39,
  t36.hash AS hash_40,
  t36.needProcess AS needProcess_41,
  t36.id AS id_42,
  t36.path AS path_43,
  t36.fileName AS fileName_44,
  t36.mime AS mime_45,
  t36.storageType AS storageType_46,
  t36.size AS size_47,
  t36.date AS date_48,
  t36.category_id AS category_id_49,
  t0.parent_id AS parent_id_50
FROM
  xc_categories t0
  LEFT JOIN xc_category_quick_flags t17 ON t17.category_id = t0.category_id
  LEFT JOIN xc_category_images t22 ON t22.category_id = t0.category_id
  LEFT JOIN xc_category_banners t36 ON t36.category_id = t0.category_id
WHERE
  t0.lpos = ?
LIMIT
  1

SELECT t0.ogMeta AS ogMeta_1, t0.useCustomOG AS useCustomOG_2, t0.csCreated AS csCreated_3, t0.csLastUpdate AS csLastUpdate_4, t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_5, t0.demo AS demo_6, t0.category_id AS category_id_7, t0.lpos AS lpos_8, t0.rpos AS rpos_9, t0.enabled AS enabled_10, t0.show_title AS show_title_11, t0.depth AS depth_12, t0.pos AS pos_13, t0.root_category_look AS root_category_look_14, t0.metaDescType AS metaDescType_15, t0.xcPendingExport AS xcPendingExport_16, t17.id AS id_18, t17.subcategories_count_all AS subcategories_count_all_19, t17.subcategories_count_enabled AS subcategories_count_enabled_20, t17.category_id AS category_id_21, t22.alt AS alt_23, t22.width AS width_24, t22.height AS height_25, t22.hash AS hash_26, t22.needProcess AS needProcess_27, t22.id AS id_28, t22.path AS path_29, t22.fileName AS fileName_30, t22.mime AS mime_31, t22.storageType AS storageType_32, t22.size AS size_33, t22.date AS date_34, t22.category_id AS category_id_35, t36.alt AS alt_37, t36.width AS width_38, t36.height AS height_39, t36.hash AS hash_40, t36.needProcess AS needProcess_41, t36.id AS id_42, t36.path AS path_43, t36.fileName AS fileName_44, t36.mime AS mime_45, t36.storageType AS storageType_46, t36.size AS size_47, t36.date AS date_48, t36.category_id AS category_id_49, t0.parent_id AS parent_id_50 FROM xc_categories t0 LEFT JOIN xc_category_quick_flags t17 ON t17.category_id = t0.category_id LEFT JOIN xc_category_images t22 ON t22.category_id = t0.category_id LEFT JOIN xc_category_banners t36 ON t36.category_id = t0.category_id WHERE t0.lpos = 1 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_.news_message_id AS news_message_id_5,
  x0_.product_id AS product_id_6,
  x0_.category_id AS category_id_7
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_.news_message_id AS news_message_id_5, x0_.product_id AS product_id_6, x0_.category_id AS category_id_7 FROM xc_clean_urls x0_ INNER JOIN xc_categories x1_ ON x0_.category_id = x1_.category_id WHERE x0_.cleanURL = 'fashion' AND x0_.category_id IS NOT NULL AND x1_.parent_id = 1 ORDER BY x0_.id DESC LIMIT 1;

SELECT
  t0.ogMeta AS ogMeta_1,
  t0.useCustomOG AS useCustomOG_2,
  t0.csCreated AS csCreated_3,
  t0.csLastUpdate AS csLastUpdate_4,
  t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_5,
  t0.demo AS demo_6,
  t0.category_id AS category_id_7,
  t0.lpos AS lpos_8,
  t0.rpos AS rpos_9,
  t0.enabled AS enabled_10,
  t0.show_title AS show_title_11,
  t0.depth AS depth_12,
  t0.pos AS pos_13,
  t0.root_category_look AS root_category_look_14,
  t0.metaDescType AS metaDescType_15,
  t0.xcPendingExport AS xcPendingExport_16,
  t17.id AS id_18,
  t17.subcategories_count_all AS subcategories_count_all_19,
  t17.subcategories_count_enabled AS subcategories_count_enabled_20,
  t17.category_id AS category_id_21,
  t22.alt AS alt_23,
  t22.width AS width_24,
  t22.height AS height_25,
  t22.hash AS hash_26,
  t22.needProcess AS needProcess_27,
  t22.id AS id_28,
  t22.path AS path_29,
  t22.fileName AS fileName_30,
  t22.mime AS mime_31,
  t22.storageType AS storageType_32,
  t22.size AS size_33,
  t22.date AS date_34,
  t22.category_id AS category_id_35,
  t36.alt AS alt_37,
  t36.width AS width_38,
  t36.height AS height_39,
  t36.hash AS hash_40,
  t36.needProcess AS needProcess_41,
  t36.id AS id_42,
  t36.path AS path_43,
  t36.fileName AS fileName_44,
  t36.mime AS mime_45,
  t36.storageType AS storageType_46,
  t36.size AS size_47,
  t36.date AS date_48,
  t36.category_id AS category_id_49,
  t0.parent_id AS parent_id_50
FROM
  xc_categories t0
  LEFT JOIN xc_category_quick_flags t17 ON t17.category_id = t0.category_id
  LEFT JOIN xc_category_images t22 ON t22.category_id = t0.category_id
  LEFT JOIN xc_category_banners t36 ON t36.category_id = t0.category_id
WHERE
  t0.category_id = ?

SELECT t0.ogMeta AS ogMeta_1, t0.useCustomOG AS useCustomOG_2, t0.csCreated AS csCreated_3, t0.csLastUpdate AS csLastUpdate_4, t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_5, t0.demo AS demo_6, t0.category_id AS category_id_7, t0.lpos AS lpos_8, t0.rpos AS rpos_9, t0.enabled AS enabled_10, t0.show_title AS show_title_11, t0.depth AS depth_12, t0.pos AS pos_13, t0.root_category_look AS root_category_look_14, t0.metaDescType AS metaDescType_15, t0.xcPendingExport AS xcPendingExport_16, t17.id AS id_18, t17.subcategories_count_all AS subcategories_count_all_19, t17.subcategories_count_enabled AS subcategories_count_enabled_20, t17.category_id AS category_id_21, t22.alt AS alt_23, t22.width AS width_24, t22.height AS height_25, t22.hash AS hash_26, t22.needProcess AS needProcess_27, t22.id AS id_28, t22.path AS path_29, t22.fileName AS fileName_30, t22.mime AS mime_31, t22.storageType AS storageType_32, t22.size AS size_33, t22.date AS date_34, t22.category_id AS category_id_35, t36.alt AS alt_37, t36.width AS width_38, t36.height AS height_39, t36.hash AS hash_40, t36.needProcess AS needProcess_41, t36.id AS id_42, t36.path AS path_43, t36.fileName AS fileName_44, t36.mime AS mime_45, t36.storageType AS storageType_46, t36.size AS size_47, t36.date AS date_48, t36.category_id AS category_id_49, t0.parent_id AS parent_id_50 FROM xc_categories t0 LEFT JOIN xc_category_quick_flags t17 ON t17.category_id = t0.category_id LEFT JOIN xc_category_images t22 ON t22.category_id = t0.category_id LEFT JOIN xc_category_banners t36 ON t36.category_id = t0.category_id WHERE t0.category_id = 2;

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
  MAX(x0_.rpos) AS sclr_0
FROM
  xc_categories x0_
LIMIT
  1

SELECT MAX(x0_.rpos) AS sclr_0 FROM xc_categories x0_ LIMIT 1;

SELECT
  x0_.ogMeta AS ogMeta_0,
  x0_.useCustomOG AS useCustomOG_1,
  x0_.csCreated AS csCreated_2,
  x0_.csLastUpdate AS csLastUpdate_3,
  x0_.is_stickers_included_subcategories AS is_stickers_included_subcategories_4,
  x0_.demo AS demo_5,
  x0_.category_id AS category_id_6,
  x0_.lpos AS lpos_7,
  x0_.rpos AS rpos_8,
  x0_.enabled AS enabled_9,
  x0_.show_title AS show_title_10,
  x0_.depth AS depth_11,
  x0_.pos AS pos_12,
  x0_.root_category_look AS root_category_look_13,
  x0_.metaDescType AS metaDescType_14,
  x0_.xcPendingExport AS xcPendingExport_15,
  x0_.parent_id AS parent_id_16
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_.ogMeta AS ogMeta_0, x0_.useCustomOG AS useCustomOG_1, x0_.csCreated AS csCreated_2, x0_.csLastUpdate AS csLastUpdate_3, x0_.is_stickers_included_subcategories AS is_stickers_included_subcategories_4, x0_.demo AS demo_5, x0_.category_id AS category_id_6, x0_.lpos AS lpos_7, x0_.rpos AS rpos_8, x0_.enabled AS enabled_9, x0_.show_title AS show_title_10, x0_.depth AS depth_11, x0_.pos AS pos_12, x0_.root_category_look AS root_category_look_13, x0_.metaDescType AS metaDescType_14, x0_.xcPendingExport AS xcPendingExport_15, x0_.parent_id AS parent_id_16 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 2) AND (x0_.rpos BETWEEN 9 AND 24) ORDER BY x0_.lpos 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.news_message_id AS news_message_id_6,
  t0.product_id AS product_id_7,
  t0.category_id AS category_id_8
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.news_message_id AS news_message_id_6, t0.product_id AS product_id_7, t0.category_id AS category_id_8 FROM xc_clean_urls t0 WHERE t0.category_id = 2 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  xc_tmp_vars t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM xc_tmp_vars t0 WHERE t0.name = 'cloud_search_reg_scheduled' LIMIT 1;

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_category_membership_links ON t0.membership_id = xc_category_membership_links.membership_id
WHERE
  xc_category_membership_links.category_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_category_membership_links ON t0.membership_id = xc_category_membership_links.membership_id WHERE xc_category_membership_links.category_id = 2;

SELECT
  x0_.ogMeta AS ogMeta_0,
  x0_.useCustomOG AS useCustomOG_1,
  x0_.csCreated AS csCreated_2,
  x0_.csLastUpdate AS csLastUpdate_3,
  x0_.is_stickers_included_subcategories AS is_stickers_included_subcategories_4,
  x0_.demo AS demo_5,
  x0_.category_id AS category_id_6,
  x0_.lpos AS lpos_7,
  x0_.rpos AS rpos_8,
  x0_.enabled AS enabled_9,
  x0_.show_title AS show_title_10,
  x0_.depth AS depth_11,
  x0_.pos AS pos_12,
  x0_.root_category_look AS root_category_look_13,
  x0_.metaDescType AS metaDescType_14,
  x0_.xcPendingExport AS xcPendingExport_15,
  x0_.parent_id AS parent_id_16
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_.ogMeta AS ogMeta_0, x0_.useCustomOG AS useCustomOG_1, x0_.csCreated AS csCreated_2, x0_.csLastUpdate AS csLastUpdate_3, x0_.is_stickers_included_subcategories AS is_stickers_included_subcategories_4, x0_.demo AS demo_5, x0_.category_id AS category_id_6, x0_.lpos AS lpos_7, x0_.rpos AS rpos_8, x0_.enabled AS enabled_9, x0_.show_title AS show_title_10, x0_.depth AS depth_11, x0_.pos AS pos_12, x0_.root_category_look AS root_category_look_13, x0_.metaDescType AS metaDescType_14, x0_.xcPendingExport AS xcPendingExport_15, x0_.parent_id AS parent_id_16 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 2) AND (x0_.rpos BETWEEN 9 AND 24) ORDER BY x0_.lpos 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 ('amp.body')) 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_.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 ('amp.layout.main')) 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_.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 ('amp.layout.header')) 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;