Symfony Profiler

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
  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
  xlite_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 xlite_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_.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_.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_
  INNER JOIN xlite_profile_roles x2_ ON x0_.profile_id = x2_.profile_id
  INNER JOIN xlite_roles x1_ ON x1_.id = x2_.role_id
  INNER JOIN xlite_role_permissions x4_ ON x1_.id = x4_.role_id
  INNER JOIN xlite_permissions x3_ ON x3_.id = x4_.permission_id
WHERE
  x3_.code IN ('ROLE_ROOT_ACCESS')
  AND x0_.status = ?
  AND x0_.access_level > 0
ORDER BY
  x0_.profile_id 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_ INNER JOIN xlite_profile_roles x2_ ON x0_.profile_id = x2_.profile_id INNER JOIN xlite_roles x1_ ON x1_.id = x2_.role_id INNER JOIN xlite_role_permissions x4_ ON x1_.id = x4_.role_id INNER JOIN xlite_permissions x3_ ON x3_.id = x4_.permission_id WHERE x3_.code IN ('ROLE_ROOT_ACCESS') AND x0_.status = 'E' AND x0_.access_level > 0 ORDER BY x0_.profile_id ASC;

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 = 'rixxu-tm-sc-coff03-ssp-1st-strato-sport-series-1st-row-coffee-seat-covers' 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.applySaleToWholesale AS applySaleToWholesale_3,
  t0.max_price_discount_notify AS max_price_discount_notify_4,
  t0.isAvailableForBackorder AS isAvailableForBackorder_5,
  t0.isBackorderLimit AS isBackorderLimit_6,
  t0.backorderLimit AS backorderLimit_7,
  t0.csCreated AS csCreated_8,
  t0.csLastUpdate AS csLastUpdate_9,
  t0.rewardPoints AS rewardPoints_10,
  t0.fixedRewardPoints AS fixedRewardPoints_11,
  t0.assignedMembershipTTLType AS assignedMembershipTTLType_12,
  t0.assignedMembershipTTL AS assignedMembershipTTL_13,
  t0.localStockEnabled AS localStockEnabled_14,
  t0.manuallyUpdatedFields AS manuallyUpdatedFields_15,
  t0.isForAllFilters AS isForAllFilters_16,
  t0.fitmentType AS fitmentType_17,
  t0.costPrice AS costPrice_18,
  t0.xcPendingBulkEdit AS xcPendingBulkEdit_19,
  t0.coreCharge AS coreCharge_20,
  t0.facebookMarketingEnabled AS facebookMarketingEnabled_21,
  t0.freeShip AS freeShip_22,
  t0.shipForFree AS shipForFree_23,
  t0.freightFixedFee AS freightFixedFee_24,
  t0.googleFeedEnabled AS googleFeedEnabled_25,
  t0.useAsSegmentCondition AS useAsSegmentCondition_26,
  t0.participateSale AS participateSale_27,
  t0.discountType AS discountType_28,
  t0.salePriceValue AS salePriceValue_29,
  t0.upcIsbn AS upcIsbn_30,
  t0.mnfVendor AS mnfVendor_31,
  t0.useCustomOG AS useCustomOG_32,
  t0.product_id AS product_id_33,
  t0.price AS price_34,
  t0.sku AS sku_35,
  t0.enabled AS enabled_36,
  t0.weight AS weight_37,
  t0.useSeparateBox AS useSeparateBox_38,
  t0.boxWidth AS boxWidth_39,
  t0.boxLength AS boxLength_40,
  t0.boxHeight AS boxHeight_41,
  t0.itemsPerBox AS itemsPerBox_42,
  t0.free_shipping AS free_shipping_43,
  t0.taxable AS taxable_44,
  t0.arrivalDate AS arrivalDate_45,
  t0.date AS date_46,
  t0.updateDate AS updateDate_47,
  t0.needProcess AS needProcess_48,
  t0.inventoryEnabled AS inventoryEnabled_49,
  t0.amount AS amount_50,
  t0.lowLimitEnabledCustomer AS lowLimitEnabledCustomer_51,
  t0.lowLimitEnabled AS lowLimitEnabled_52,
  t0.lowLimitAmount AS lowLimitAmount_53,
  t0.attrSepTab AS attrSepTab_54,
  t0.metaDescType AS metaDescType_55,
  t0.sales AS sales_56,
  t0.xcPendingExport AS xcPendingExport_57,
  t0.isDemoProduct AS isDemoProduct_58,
  t0.entityVersion AS entityVersion_59,
  t0.appointment_membership_id AS appointment_membership_id_60,
  t0.nextagCategory AS nextagCategory_61,
  t0.shopzillaCategory AS shopzillaCategory_62,
  t0.pricegrabberCategory AS pricegrabberCategory_63,
  t0.eBayCommerceCategory AS eBayCommerceCategory_64,
  t0.googleShoppingCategory AS googleShoppingCategory_65,
  t0.active_cost_price_source_id AS active_cost_price_source_id_66,
  t0.active_price_source_id AS active_price_source_id_67,
  t68.id AS id_69,
  t68.isSubscription AS isSubscription_70,
  t68.setupFee AS setupFee_71,
  t68.calculateShipping AS calculateShipping_72,
  t68.trialDuration AS trialDuration_73,
  t68.trialDurationUnit AS trialDurationUnit_74,
  t68.hasTrialPeriod AS hasTrialPeriod_75,
  t68.fee AS fee_76,
  t68.type AS type_77,
  t68.number AS number_78,
  t68.period AS period_79,
  t68.reverse AS reverse_80,
  t68.periods AS periods_81,
  t68.productId AS productId_82,
  t0.product_class_id AS product_class_id_83,
  t0.tax_class_id AS tax_class_id_84
FROM
  xlite_products t0
  LEFT JOIN xlite_xpayments_subscription_plans t68 ON t68.productId = t0.product_id
WHERE
  t0.product_id = ?

SELECT t0.amazonPaymentEnabled AS amazonPaymentEnabled_1, t0.marketPrice AS marketPrice_2, t0.applySaleToWholesale AS applySaleToWholesale_3, t0.max_price_discount_notify AS max_price_discount_notify_4, t0.isAvailableForBackorder AS isAvailableForBackorder_5, t0.isBackorderLimit AS isBackorderLimit_6, t0.backorderLimit AS backorderLimit_7, t0.csCreated AS csCreated_8, t0.csLastUpdate AS csLastUpdate_9, t0.rewardPoints AS rewardPoints_10, t0.fixedRewardPoints AS fixedRewardPoints_11, t0.assignedMembershipTTLType AS assignedMembershipTTLType_12, t0.assignedMembershipTTL AS assignedMembershipTTL_13, t0.localStockEnabled AS localStockEnabled_14, t0.manuallyUpdatedFields AS manuallyUpdatedFields_15, t0.isForAllFilters AS isForAllFilters_16, t0.fitmentType AS fitmentType_17, t0.costPrice AS costPrice_18, t0.xcPendingBulkEdit AS xcPendingBulkEdit_19, t0.coreCharge AS coreCharge_20, t0.facebookMarketingEnabled AS facebookMarketingEnabled_21, t0.freeShip AS freeShip_22, t0.shipForFree AS shipForFree_23, t0.freightFixedFee AS freightFixedFee_24, t0.googleFeedEnabled AS googleFeedEnabled_25, t0.useAsSegmentCondition AS useAsSegmentCondition_26, t0.participateSale AS participateSale_27, t0.discountType AS discountType_28, t0.salePriceValue AS salePriceValue_29, t0.upcIsbn AS upcIsbn_30, t0.mnfVendor AS mnfVendor_31, t0.useCustomOG AS useCustomOG_32, t0.product_id AS product_id_33, t0.price AS price_34, t0.sku AS sku_35, t0.enabled AS enabled_36, t0.weight AS weight_37, t0.useSeparateBox AS useSeparateBox_38, t0.boxWidth AS boxWidth_39, t0.boxLength AS boxLength_40, t0.boxHeight AS boxHeight_41, t0.itemsPerBox AS itemsPerBox_42, t0.free_shipping AS free_shipping_43, t0.taxable AS taxable_44, t0.arrivalDate AS arrivalDate_45, t0.date AS date_46, t0.updateDate AS updateDate_47, t0.needProcess AS needProcess_48, t0.inventoryEnabled AS inventoryEnabled_49, t0.amount AS amount_50, t0.lowLimitEnabledCustomer AS lowLimitEnabledCustomer_51, t0.lowLimitEnabled AS lowLimitEnabled_52, t0.lowLimitAmount AS lowLimitAmount_53, t0.attrSepTab AS attrSepTab_54, t0.metaDescType AS metaDescType_55, t0.sales AS sales_56, t0.xcPendingExport AS xcPendingExport_57, t0.isDemoProduct AS isDemoProduct_58, t0.entityVersion AS entityVersion_59, t0.appointment_membership_id AS appointment_membership_id_60, t0.nextagCategory AS nextagCategory_61, t0.shopzillaCategory AS shopzillaCategory_62, t0.pricegrabberCategory AS pricegrabberCategory_63, t0.eBayCommerceCategory AS eBayCommerceCategory_64, t0.googleShoppingCategory AS googleShoppingCategory_65, t0.active_cost_price_source_id AS active_cost_price_source_id_66, t0.active_price_source_id AS active_price_source_id_67, t68.id AS id_69, t68.isSubscription AS isSubscription_70, t68.setupFee AS setupFee_71, t68.calculateShipping AS calculateShipping_72, t68.trialDuration AS trialDuration_73, t68.trialDurationUnit AS trialDurationUnit_74, t68.hasTrialPeriod AS hasTrialPeriod_75, t68.fee AS fee_76, t68.type AS type_77, t68.number AS number_78, t68.period AS period_79, t68.reverse AS reverse_80, t68.periods AS periods_81, t68.productId AS productId_82, t0.product_class_id AS product_class_id_83, t0.tax_class_id AS tax_class_id_84 FROM xlite_products t0 LEFT JOIN xlite_xpayments_subscription_plans t68 ON t68.productId = t0.product_id WHERE t0.product_id = 73;

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.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.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.product_id = 73 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
  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.ogMeta AS ogMeta_1,
  t0.useCustomOG AS useCustomOG_2,
  t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_3,
  t0.autoPendingEnabled AS autoPendingEnabled_4,
  t0.demo AS demo_5,
  t0.wheelTireSizeFilter AS wheelTireSizeFilter_6,
  t0.csCreated AS csCreated_7,
  t0.csLastUpdate AS csLastUpdate_8,
  t0.category_id AS category_id_9,
  t0.lpos AS lpos_10,
  t0.rpos AS rpos_11,
  t0.enabled AS enabled_12,
  t0.show_title AS show_title_13,
  t0.depth AS depth_14,
  t0.pos AS pos_15,
  t0.root_category_look AS root_category_look_16,
  t0.metaDescType AS metaDescType_17,
  t0.xcPendingExport AS xcPendingExport_18,
  t19.id AS id_20,
  t19.subcategories_count_all AS subcategories_count_all_21,
  t19.subcategories_count_enabled AS subcategories_count_enabled_22,
  t19.category_id AS category_id_23,
  t24.alt AS alt_25,
  t24.width AS width_26,
  t24.height AS height_27,
  t24.hash AS hash_28,
  t24.needProcess AS needProcess_29,
  t24.id AS id_30,
  t24.path AS path_31,
  t24.fileName AS fileName_32,
  t24.mime AS mime_33,
  t24.storageType AS storageType_34,
  t24.size AS size_35,
  t24.date AS date_36,
  t24.category_id AS category_id_37,
  t38.alt AS alt_39,
  t38.width AS width_40,
  t38.height AS height_41,
  t38.hash AS hash_42,
  t38.needProcess AS needProcess_43,
  t38.id AS id_44,
  t38.path AS path_45,
  t38.fileName AS fileName_46,
  t38.mime AS mime_47,
  t38.storageType AS storageType_48,
  t38.size AS size_49,
  t38.date AS date_50,
  t38.category_id AS category_id_51,
  t0.parent_id AS parent_id_52
FROM
  xlite_categories t0
  LEFT JOIN xlite_category_quick_flags t19 ON t19.category_id = t0.category_id
  LEFT JOIN xlite_category_images t24 ON t24.category_id = t0.category_id
  LEFT JOIN xlite_category_banners t38 ON t38.category_id = t0.category_id
WHERE
  t0.lpos = ?
LIMIT
  1

SELECT t0.ogMeta AS ogMeta_1, t0.useCustomOG AS useCustomOG_2, t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_3, t0.autoPendingEnabled AS autoPendingEnabled_4, t0.demo AS demo_5, t0.wheelTireSizeFilter AS wheelTireSizeFilter_6, t0.csCreated AS csCreated_7, t0.csLastUpdate AS csLastUpdate_8, t0.category_id AS category_id_9, t0.lpos AS lpos_10, t0.rpos AS rpos_11, t0.enabled AS enabled_12, t0.show_title AS show_title_13, t0.depth AS depth_14, t0.pos AS pos_15, t0.root_category_look AS root_category_look_16, t0.metaDescType AS metaDescType_17, t0.xcPendingExport AS xcPendingExport_18, t19.id AS id_20, t19.subcategories_count_all AS subcategories_count_all_21, t19.subcategories_count_enabled AS subcategories_count_enabled_22, t19.category_id AS category_id_23, t24.alt AS alt_25, t24.width AS width_26, t24.height AS height_27, t24.hash AS hash_28, t24.needProcess AS needProcess_29, t24.id AS id_30, t24.path AS path_31, t24.fileName AS fileName_32, t24.mime AS mime_33, t24.storageType AS storageType_34, t24.size AS size_35, t24.date AS date_36, t24.category_id AS category_id_37, t38.alt AS alt_39, t38.width AS width_40, t38.height AS height_41, t38.hash AS hash_42, t38.needProcess AS needProcess_43, t38.id AS id_44, t38.path AS path_45, t38.fileName AS fileName_46, t38.mime AS mime_47, t38.storageType AS storageType_48, t38.size AS size_49, t38.date AS date_50, t38.category_id AS category_id_51, t0.parent_id AS parent_id_52 FROM xlite_categories t0 LEFT JOIN xlite_category_quick_flags t19 ON t19.category_id = t0.category_id LEFT JOIN xlite_category_images t24 ON t24.category_id = t0.category_id LEFT JOIN xlite_category_banners t38 ON t38.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
  xlite_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 xlite_category_products t0 WHERE t0.product_id = 73 ORDER BY t0.orderbyInProduct ASC;

SELECT
  t0.ogMeta AS ogMeta_1,
  t0.useCustomOG AS useCustomOG_2,
  t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_3,
  t0.autoPendingEnabled AS autoPendingEnabled_4,
  t0.demo AS demo_5,
  t0.wheelTireSizeFilter AS wheelTireSizeFilter_6,
  t0.csCreated AS csCreated_7,
  t0.csLastUpdate AS csLastUpdate_8,
  t0.category_id AS category_id_9,
  t0.lpos AS lpos_10,
  t0.rpos AS rpos_11,
  t0.enabled AS enabled_12,
  t0.show_title AS show_title_13,
  t0.depth AS depth_14,
  t0.pos AS pos_15,
  t0.root_category_look AS root_category_look_16,
  t0.metaDescType AS metaDescType_17,
  t0.xcPendingExport AS xcPendingExport_18,
  t19.id AS id_20,
  t19.subcategories_count_all AS subcategories_count_all_21,
  t19.subcategories_count_enabled AS subcategories_count_enabled_22,
  t19.category_id AS category_id_23,
  t24.alt AS alt_25,
  t24.width AS width_26,
  t24.height AS height_27,
  t24.hash AS hash_28,
  t24.needProcess AS needProcess_29,
  t24.id AS id_30,
  t24.path AS path_31,
  t24.fileName AS fileName_32,
  t24.mime AS mime_33,
  t24.storageType AS storageType_34,
  t24.size AS size_35,
  t24.date AS date_36,
  t24.category_id AS category_id_37,
  t38.alt AS alt_39,
  t38.width AS width_40,
  t38.height AS height_41,
  t38.hash AS hash_42,
  t38.needProcess AS needProcess_43,
  t38.id AS id_44,
  t38.path AS path_45,
  t38.fileName AS fileName_46,
  t38.mime AS mime_47,
  t38.storageType AS storageType_48,
  t38.size AS size_49,
  t38.date AS date_50,
  t38.category_id AS category_id_51,
  t0.parent_id AS parent_id_52
FROM
  xlite_categories t0
  LEFT JOIN xlite_category_quick_flags t19 ON t19.category_id = t0.category_id
  LEFT JOIN xlite_category_images t24 ON t24.category_id = t0.category_id
  LEFT JOIN xlite_category_banners t38 ON t38.category_id = t0.category_id
WHERE
  t0.category_id = ?

SELECT t0.ogMeta AS ogMeta_1, t0.useCustomOG AS useCustomOG_2, t0.is_stickers_included_subcategories AS is_stickers_included_subcategories_3, t0.autoPendingEnabled AS autoPendingEnabled_4, t0.demo AS demo_5, t0.wheelTireSizeFilter AS wheelTireSizeFilter_6, t0.csCreated AS csCreated_7, t0.csLastUpdate AS csLastUpdate_8, t0.category_id AS category_id_9, t0.lpos AS lpos_10, t0.rpos AS rpos_11, t0.enabled AS enabled_12, t0.show_title AS show_title_13, t0.depth AS depth_14, t0.pos AS pos_15, t0.root_category_look AS root_category_look_16, t0.metaDescType AS metaDescType_17, t0.xcPendingExport AS xcPendingExport_18, t19.id AS id_20, t19.subcategories_count_all AS subcategories_count_all_21, t19.subcategories_count_enabled AS subcategories_count_enabled_22, t19.category_id AS category_id_23, t24.alt AS alt_25, t24.width AS width_26, t24.height AS height_27, t24.hash AS hash_28, t24.needProcess AS needProcess_29, t24.id AS id_30, t24.path AS path_31, t24.fileName AS fileName_32, t24.mime AS mime_33, t24.storageType AS storageType_34, t24.size AS size_35, t24.date AS date_36, t24.category_id AS category_id_37, t38.alt AS alt_39, t38.width AS width_40, t38.height AS height_41, t38.hash AS hash_42, t38.needProcess AS needProcess_43, t38.id AS id_44, t38.path AS path_45, t38.fileName AS fileName_46, t38.mime AS mime_47, t38.storageType AS storageType_48, t38.size AS size_49, t38.date AS date_50, t38.category_id AS category_id_51, t0.parent_id AS parent_id_52 FROM xlite_categories t0 LEFT JOIN xlite_category_quick_flags t19 ON t19.category_id = t0.category_id LEFT JOIN xlite_category_images t24 ON t24.category_id = t0.category_id LEFT JOIN xlite_category_banners t38 ON t38.category_id = t0.category_id WHERE t0.category_id = 3;

SELECT
  x0_.id AS id_0,
  x0_.class AS class_1,
  x0_.weight AS weight_2
FROM
  xlite_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 xlite_order_modifiers x0_ ORDER BY x0_.weight ASC, x0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  xlite_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 xlite_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
  xlite_memberships t0
  INNER JOIN xlite_product_membership_links ON t0.membership_id = xlite_product_membership_links.membership_id
WHERE
  xlite_product_membership_links.product_id = ?

SELECT t0.membership_id AS membership_id_1, t0.position AS position_2, t0.enabled AS enabled_3 FROM xlite_memberships t0 INNER JOIN xlite_product_membership_links ON t0.membership_id = xlite_product_membership_links.membership_id WHERE xlite_product_membership_links.product_id = 73;

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
  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
  xlite_currencies t0
  LEFT JOIN xlite_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 xlite_currencies t0 LEFT JOIN xlite_active_currencies t10 ON t10.currency_id = t0.currency_id WHERE t0.currency_id = 840;