Symfony Profiler

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.state_id = ?

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.state_id = '576';

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_.conciergeUserId AS conciergeUserId_5,
  x0_.stripeCustomerId AS stripeCustomerId_6,
  x0_.xpaymentsCustomerId AS xpaymentsCustomerId_7,
  x0_.profile_id AS profile_id_8,
  x0_.login AS login_9,
  x0_.password AS password_10,
  x0_.password_hint AS password_hint_11,
  x0_.password_hint_answer AS password_hint_answer_12,
  x0_.passwordResetKey AS passwordResetKey_13,
  x0_.passwordResetKeyDate AS passwordResetKeyDate_14,
  x0_.access_level AS access_level_15,
  x0_.added AS added_16,
  x0_.first_login AS first_login_17,
  x0_.last_login AS last_login_18,
  x0_.status AS status_19,
  x0_.statusComment AS statusComment_20,
  x0_.referer AS referer_21,
  x0_.language AS language_22,
  x0_.last_shipping_id AS last_shipping_id_23,
  x0_.last_payment_id AS last_payment_id_24,
  x0_.anonymous AS anonymous_25,
  x0_.forceChangePassword AS forceChangePassword_26,
  x0_.dateOfLoginAttempt AS dateOfLoginAttempt_27,
  x0_.countOfLoginAttempts AS countOfLoginAttempts_28,
  x0_.searchFakeField AS searchFakeField_29,
  x0_.xcPendingExport AS xcPendingExport_30,
  x0_.lastCheckoutEmail AS lastCheckoutEmail_31,
  x0_.order_id AS order_id_32,
  x0_.membership_id AS membership_id_33,
  x0_.pending_membership_id AS pending_membership_id_34
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_.conciergeUserId AS conciergeUserId_5, x0_.stripeCustomerId AS stripeCustomerId_6, x0_.xpaymentsCustomerId AS xpaymentsCustomerId_7, x0_.profile_id AS profile_id_8, x0_.login AS login_9, x0_.password AS password_10, x0_.password_hint AS password_hint_11, x0_.password_hint_answer AS password_hint_answer_12, x0_.passwordResetKey AS passwordResetKey_13, x0_.passwordResetKeyDate AS passwordResetKeyDate_14, x0_.access_level AS access_level_15, x0_.added AS added_16, x0_.first_login AS first_login_17, x0_.last_login AS last_login_18, x0_.status AS status_19, x0_.statusComment AS statusComment_20, x0_.referer AS referer_21, x0_.language AS language_22, x0_.last_shipping_id AS last_shipping_id_23, x0_.last_payment_id AS last_payment_id_24, x0_.anonymous AS anonymous_25, x0_.forceChangePassword AS forceChangePassword_26, x0_.dateOfLoginAttempt AS dateOfLoginAttempt_27, x0_.countOfLoginAttempts AS countOfLoginAttempts_28, x0_.searchFakeField AS searchFakeField_29, x0_.xcPendingExport AS xcPendingExport_30, x0_.lastCheckoutEmail AS lastCheckoutEmail_31, x0_.order_id AS order_id_32, x0_.membership_id AS membership_id_33, x0_.pending_membership_id AS pending_membership_id_34 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 = 'rooster-mug-in-white' AND x0_.product_id IS NOT NULL ORDER BY x0_.id DESC LIMIT 1;

SELECT
  t0.amazonPaymentEnabled AS amazonPaymentEnabled_1,
  t0.marketPrice AS marketPrice_2,
  t0.pinCodesEnabled AS pinCodesEnabled_3,
  t0.autoPinCodes AS autoPinCodes_4,
  t0.isNFD AS isNFD_5,
  t0.ebayPrice AS ebayPrice_6,
  t0.max_price_discount_notify AS max_price_discount_notify_7,
  t0.isAvailableForBackorder AS isAvailableForBackorder_8,
  t0.isBackorderLimit AS isBackorderLimit_9,
  t0.backorderLimit AS backorderLimit_10,
  t0.csCreated AS csCreated_11,
  t0.csLastUpdate AS csLastUpdate_12,
  t0.costPrice AS costPrice_13,
  t0.participateSale AS participateSale_14,
  t0.discountType AS discountType_15,
  t0.salePriceValue AS salePriceValue_16,
  t0.xcPendingBulkEdit AS xcPendingBulkEdit_17,
  t0.isCustomerAttachmentsAvailable AS isCustomerAttachmentsAvailable_18,
  t0.isCustomerAttachmentsRequired AS isCustomerAttachmentsRequired_19,
  t0.facebookMarketingEnabled AS facebookMarketingEnabled_20,
  t0.freeShip AS freeShip_21,
  t0.shipForFree AS shipForFree_22,
  t0.freightFixedFee AS freightFixedFee_23,
  t0.googleFeedEnabled AS googleFeedEnabled_24,
  t0.useCustomOG AS useCustomOG_25,
  t0.useAsSegmentCondition AS useAsSegmentCondition_26,
  t0.applySaleToWholesale AS applySaleToWholesale_27,
  t0.product_id AS product_id_28,
  t0.price AS price_29,
  t0.sku AS sku_30,
  t0.enabled AS enabled_31,
  t0.weight AS weight_32,
  t0.useSeparateBox AS useSeparateBox_33,
  t0.boxWidth AS boxWidth_34,
  t0.boxLength AS boxLength_35,
  t0.boxHeight AS boxHeight_36,
  t0.itemsPerBox AS itemsPerBox_37,
  t0.free_shipping AS free_shipping_38,
  t0.taxable AS taxable_39,
  t0.arrivalDate AS arrivalDate_40,
  t0.date AS date_41,
  t0.updateDate AS updateDate_42,
  t0.needProcess AS needProcess_43,
  t0.inventoryEnabled AS inventoryEnabled_44,
  t0.amount AS amount_45,
  t0.lowLimitEnabledCustomer AS lowLimitEnabledCustomer_46,
  t0.lowLimitEnabled AS lowLimitEnabled_47,
  t0.lowLimitAmount AS lowLimitAmount_48,
  t0.attrSepTab AS attrSepTab_49,
  t0.metaDescType AS metaDescType_50,
  t0.sales AS sales_51,
  t0.xcPendingExport AS xcPendingExport_52,
  t0.isDemoProduct AS isDemoProduct_53,
  t0.entityVersion AS entityVersion_54,
  t0.nextagCategory AS nextagCategory_55,
  t0.shopzillaCategory AS shopzillaCategory_56,
  t0.pricegrabberCategory AS pricegrabberCategory_57,
  t0.eBayCommerceCategory AS eBayCommerceCategory_58,
  t0.googleShoppingCategory AS googleShoppingCategory_59,
  t60.id AS id_61,
  t60.isSubscription AS isSubscription_62,
  t60.setupFee AS setupFee_63,
  t60.calculateShipping AS calculateShipping_64,
  t60.trialDuration AS trialDuration_65,
  t60.trialDurationUnit AS trialDurationUnit_66,
  t60.hasTrialPeriod AS hasTrialPeriod_67,
  t60.fee AS fee_68,
  t60.type AS type_69,
  t60.number AS number_70,
  t60.period AS period_71,
  t60.reverse AS reverse_72,
  t60.periods AS periods_73,
  t60.productId AS productId_74,
  t0.product_class_id AS product_class_id_75,
  t0.tax_class_id AS tax_class_id_76
FROM
  xc_products t0
  LEFT JOIN xc_xpayments_subscription_plans t60 ON t60.productId = t0.product_id
WHERE
  t0.product_id = ?

SELECT t0.amazonPaymentEnabled AS amazonPaymentEnabled_1, t0.marketPrice AS marketPrice_2, t0.pinCodesEnabled AS pinCodesEnabled_3, t0.autoPinCodes AS autoPinCodes_4, t0.isNFD AS isNFD_5, t0.ebayPrice AS ebayPrice_6, t0.max_price_discount_notify AS max_price_discount_notify_7, t0.isAvailableForBackorder AS isAvailableForBackorder_8, t0.isBackorderLimit AS isBackorderLimit_9, t0.backorderLimit AS backorderLimit_10, t0.csCreated AS csCreated_11, t0.csLastUpdate AS csLastUpdate_12, t0.costPrice AS costPrice_13, t0.participateSale AS participateSale_14, t0.discountType AS discountType_15, t0.salePriceValue AS salePriceValue_16, t0.xcPendingBulkEdit AS xcPendingBulkEdit_17, t0.isCustomerAttachmentsAvailable AS isCustomerAttachmentsAvailable_18, t0.isCustomerAttachmentsRequired AS isCustomerAttachmentsRequired_19, t0.facebookMarketingEnabled AS facebookMarketingEnabled_20, t0.freeShip AS freeShip_21, t0.shipForFree AS shipForFree_22, t0.freightFixedFee AS freightFixedFee_23, t0.googleFeedEnabled AS googleFeedEnabled_24, t0.useCustomOG AS useCustomOG_25, t0.useAsSegmentCondition AS useAsSegmentCondition_26, t0.applySaleToWholesale AS applySaleToWholesale_27, t0.product_id AS product_id_28, t0.price AS price_29, t0.sku AS sku_30, t0.enabled AS enabled_31, t0.weight AS weight_32, t0.useSeparateBox AS useSeparateBox_33, t0.boxWidth AS boxWidth_34, t0.boxLength AS boxLength_35, t0.boxHeight AS boxHeight_36, t0.itemsPerBox AS itemsPerBox_37, t0.free_shipping AS free_shipping_38, t0.taxable AS taxable_39, t0.arrivalDate AS arrivalDate_40, t0.date AS date_41, t0.updateDate AS updateDate_42, t0.needProcess AS needProcess_43, t0.inventoryEnabled AS inventoryEnabled_44, t0.amount AS amount_45, t0.lowLimitEnabledCustomer AS lowLimitEnabledCustomer_46, t0.lowLimitEnabled AS lowLimitEnabled_47, t0.lowLimitAmount AS lowLimitAmount_48, t0.attrSepTab AS attrSepTab_49, t0.metaDescType AS metaDescType_50, t0.sales AS sales_51, t0.xcPendingExport AS xcPendingExport_52, t0.isDemoProduct AS isDemoProduct_53, t0.entityVersion AS entityVersion_54, t0.nextagCategory AS nextagCategory_55, t0.shopzillaCategory AS shopzillaCategory_56, t0.pricegrabberCategory AS pricegrabberCategory_57, t0.eBayCommerceCategory AS eBayCommerceCategory_58, t0.googleShoppingCategory AS googleShoppingCategory_59, t60.id AS id_61, t60.isSubscription AS isSubscription_62, t60.setupFee AS setupFee_63, t60.calculateShipping AS calculateShipping_64, t60.trialDuration AS trialDuration_65, t60.trialDurationUnit AS trialDurationUnit_66, t60.hasTrialPeriod AS hasTrialPeriod_67, t60.fee AS fee_68, t60.type AS type_69, t60.number AS number_70, t60.period AS period_71, t60.reverse AS reverse_72, t60.periods AS periods_73, t60.productId AS productId_74, t0.product_class_id AS product_class_id_75, t0.tax_class_id AS tax_class_id_76 FROM xc_products t0 LEFT JOIN xc_xpayments_subscription_plans t60 ON t60.productId = t0.product_id WHERE t0.product_id = 25;

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.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.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.product_id = 25 ORDER BY t0.id ASC;

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.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
  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 = 25 ORDER BY t0.orderbyInProduct ASC;

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 = 5;

SELECT
  t0.currency_id AS currency_id_1,
  t0.code AS code_2,
  t0.symbol AS symbol_3,
  t0.prefix AS prefix_4,
  t0.suffix AS suffix_5,
  t0.e AS e_6,
  t0.decimalDelimiter AS decimalDelimiter_7,
  t0.thousandDelimiter AS thousandDelimiter_8,
  t0.roundUp AS roundUp_9,
  t10.active_currency_id AS active_currency_id_11,
  t10.rate AS rate_12,
  t10.enabled AS enabled_13,
  t10.position AS position_14,
  t10.rateDate AS rateDate_15,
  t10.currency_id AS currency_id_16
FROM
  xc_currencies t0
  LEFT JOIN xc_active_currencies t10 ON t10.currency_id = t0.currency_id
WHERE
  t0.currency_id = ?

SELECT t0.currency_id AS currency_id_1, t0.code AS code_2, t0.symbol AS symbol_3, t0.prefix AS prefix_4, t0.suffix AS suffix_5, t0.e AS e_6, t0.decimalDelimiter AS decimalDelimiter_7, t0.thousandDelimiter AS thousandDelimiter_8, t0.roundUp AS roundUp_9, t10.active_currency_id AS active_currency_id_11, t10.rate AS rate_12, t10.enabled AS enabled_13, t10.position AS position_14, t10.rateDate AS rateDate_15, t10.currency_id AS currency_id_16 FROM xc_currencies t0 LEFT JOIN xc_active_currencies t10 ON t10.currency_id = t0.currency_id WHERE t0.currency_id = '840';

SELECT
  x0_.id AS id_0,
  x0_.class AS class_1,
  x0_.weight AS weight_2
FROM
  xc_order_modifiers x0_
ORDER BY
  x0_.weight ASC,
  x0_.id ASC

SELECT x0_.id AS id_0, x0_.class AS class_1, x0_.weight AS weight_2 FROM xc_order_modifiers x0_ ORDER BY x0_.weight ASC, x0_.id 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.state_id = ?

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.state_id = '547';

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.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_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 = 25;

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
  xc_active_currencies x0_
  INNER JOIN xc_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 xc_active_currencies x0_ INNER JOIN xc_currencies x1_ ON x0_.currency_id = x1_.currency_id WHERE x1_.code = NULL AND x0_.enabled = 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.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
  COUNT(DISTINCT x0_.active_currency_id) AS sclr_0
FROM
  xc_active_currencies x0_
WHERE
  x0_.enabled = ?

SELECT COUNT(DISTINCT x0_.active_currency_id) AS sclr_0 FROM xc_active_currencies x0_ WHERE x0_.enabled = 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
  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 = 'Lumino-LuminoBeady';

SELECT
  t0.method_id AS method_id_1,
  t0.service_name AS service_name_2,
  t0.class AS class_3,
  t0.moduleName AS moduleName_4,
  t0.orderby AS orderby_5,
  t0.adminOrderby AS adminOrderby_6,
  t0.enabled AS enabled_7,
  t0.added AS added_8,
  t0.creditCardRate AS creditCardRate_9,
  t0.transactionFee AS transactionFee_10,
  t0.predefined AS predefined_11,
  t0.type AS type_12,
  t0.fromMarketplace AS fromMarketplace_13,
  t0.modulePageURL AS modulePageURL_14,
  t0.countries AS countries_15,
  t0.exCountries AS exCountries_16
FROM
  xc_payment_methods t0
WHERE
  t0.service_name = ?
LIMIT
  1

SELECT t0.method_id AS method_id_1, t0.service_name AS service_name_2, t0.class AS class_3, t0.moduleName AS moduleName_4, t0.orderby AS orderby_5, t0.adminOrderby AS adminOrderby_6, t0.enabled AS enabled_7, t0.added AS added_8, t0.creditCardRate AS creditCardRate_9, t0.transactionFee AS transactionFee_10, t0.predefined AS predefined_11, t0.type AS type_12, t0.fromMarketplace AS fromMarketplace_13, t0.modulePageURL AS modulePageURL_14, t0.countries AS countries_15, t0.exCountries AS exCountries_16 FROM xc_payment_methods t0 WHERE t0.service_name = 'ExpressCheckout' LIMIT 1;

SELECT
  t0.method_id AS method_id_1,
  t0.service_name AS service_name_2,
  t0.class AS class_3,
  t0.moduleName AS moduleName_4,
  t0.orderby AS orderby_5,
  t0.adminOrderby AS adminOrderby_6,
  t0.enabled AS enabled_7,
  t0.added AS added_8,
  t0.creditCardRate AS creditCardRate_9,
  t0.transactionFee AS transactionFee_10,
  t0.predefined AS predefined_11,
  t0.type AS type_12,
  t0.fromMarketplace AS fromMarketplace_13,
  t0.modulePageURL AS modulePageURL_14,
  t0.countries AS countries_15,
  t0.exCountries AS exCountries_16
FROM
  xc_payment_methods t0
WHERE
  t0.method_id = ?

SELECT t0.method_id AS method_id_1, t0.service_name AS service_name_2, t0.class AS class_3, t0.moduleName AS moduleName_4, t0.orderby AS orderby_5, t0.adminOrderby AS adminOrderby_6, t0.enabled AS enabled_7, t0.added AS added_8, t0.creditCardRate AS creditCardRate_9, t0.transactionFee AS transactionFee_10, t0.predefined AS predefined_11, t0.type AS type_12, t0.fromMarketplace AS fromMarketplace_13, t0.modulePageURL AS modulePageURL_14, t0.countries AS countries_15, t0.exCountries AS exCountries_16 FROM xc_payment_methods t0 WHERE t0.method_id = 27;

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
  xc_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 xc_payment_method_translations t0 WHERE t0.id = 27;