Symfony Profiler

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
  x0_.position AS position_0,
  x0_.xpaymentsSubscriptionFeeModifier AS xpaymentsSubscriptionFeeModifier_1,
  x0_.xpaymentsSubscriptionFeeModifierType AS xpaymentsSubscriptionFeeModifierType_2,
  x0_.priceModifier AS priceModifier_3,
  x0_.priceModifierType AS priceModifierType_4,
  x0_.weightModifier AS weightModifier_5,
  x0_.weightModifierType AS weightModifierType_6,
  x0_.defaultValue AS defaultValue_7,
  x0_.id AS id_8,
  x0_.swatch_id AS swatch_id_9,
  x0_.attribute_option_id AS attribute_option_id_10,
  x0_.product_id AS product_id_11,
  x0_.attribute_id AS attribute_id_12
FROM
  xlite_attribute_values_select x0_
  LEFT JOIN xlite_attribute_values_select_translations x1_ ON x0_.id = x1_.id
  AND (x1_.code = ?)
WHERE
  x0_.product_id = ?
  AND x0_.attribute_id = ?
GROUP BY
  x0_.id

SELECT x0_.position AS position_0, x0_.xpaymentsSubscriptionFeeModifier AS xpaymentsSubscriptionFeeModifier_1, x0_.xpaymentsSubscriptionFeeModifierType AS xpaymentsSubscriptionFeeModifierType_2, x0_.priceModifier AS priceModifier_3, x0_.priceModifierType AS priceModifierType_4, x0_.weightModifier AS weightModifier_5, x0_.weightModifierType AS weightModifierType_6, x0_.defaultValue AS defaultValue_7, x0_.id AS id_8, x0_.swatch_id AS swatch_id_9, x0_.attribute_option_id AS attribute_option_id_10, x0_.product_id AS product_id_11, x0_.attribute_id AS attribute_id_12 FROM xlite_attribute_values_select x0_ LEFT JOIN xlite_attribute_values_select_translations x1_ ON x0_.id = x1_.id AND (x1_.code = 'en') WHERE x0_.product_id = 70 AND x0_.attribute_id = 50 GROUP BY x0_.id;

SELECT
  x0_.id AS id_0,
  x0_.position AS position_1,
  x0_.product_class_id AS product_class_id_2
FROM
  xlite_attribute_groups x0_
  LEFT JOIN xlite_attribute_group_translations x1_ ON x0_.id = x1_.id
  AND (x1_.code = ?)
WHERE
  x1_.name = ?
  AND x0_.product_class_id IS NULL
ORDER BY
  x0_.position ASC,
  x0_.id ASC
LIMIT
  1

SELECT x0_.id AS id_0, x0_.position AS position_1, x0_.product_class_id AS product_class_id_2 FROM xlite_attribute_groups x0_ LEFT JOIN xlite_attribute_group_translations x1_ ON x0_.id = x1_.id AND (x1_.code = 'en') WHERE x1_.name = 'Safety & Compliance' AND x0_.product_class_id IS NULL ORDER BY x0_.position ASC, x0_.id ASC LIMIT 1;

SELECT
  x0_.ogMeta AS ogMeta_0,
  x0_.useCustomOG AS useCustomOG_1,
  x0_.is_stickers_included_subcategories AS is_stickers_included_subcategories_2,
  x0_.autoPendingEnabled AS autoPendingEnabled_3,
  x0_.demo AS demo_4,
  x0_.wheelTireSizeFilter AS wheelTireSizeFilter_5,
  x0_.csCreated AS csCreated_6,
  x0_.csLastUpdate AS csLastUpdate_7,
  x0_.category_id AS category_id_8,
  x0_.lpos AS lpos_9,
  x0_.rpos AS rpos_10,
  x0_.enabled AS enabled_11,
  x0_.show_title AS show_title_12,
  x0_.depth AS depth_13,
  x0_.pos AS pos_14,
  x0_.root_category_look AS root_category_look_15,
  x0_.metaDescType AS metaDescType_16,
  x0_.xcPendingExport AS xcPendingExport_17,
  x0_.parent_id AS parent_id_18
FROM
  xlite_categories x0_
  LEFT JOIN xlite_category_translations x1_ ON x0_.category_id = x1_.id
  AND (x1_.code = ?)
  LEFT JOIN xlite_category_membership_links x3_ ON x0_.category_id = x3_.category_id
  LEFT JOIN xlite_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_.is_stickers_included_subcategories AS is_stickers_included_subcategories_2, x0_.autoPendingEnabled AS autoPendingEnabled_3, x0_.demo AS demo_4, x0_.wheelTireSizeFilter AS wheelTireSizeFilter_5, x0_.csCreated AS csCreated_6, x0_.csLastUpdate AS csLastUpdate_7, x0_.category_id AS category_id_8, x0_.lpos AS lpos_9, x0_.rpos AS rpos_10, x0_.enabled AS enabled_11, x0_.show_title AS show_title_12, x0_.depth AS depth_13, x0_.pos AS pos_14, x0_.root_category_look AS root_category_look_15, x0_.metaDescType AS metaDescType_16, x0_.xcPendingExport AS xcPendingExport_17, x0_.parent_id AS parent_id_18 FROM xlite_categories x0_ LEFT JOIN xlite_category_translations x1_ ON x0_.category_id = x1_.id AND (x1_.code = 'en') LEFT JOIN xlite_category_membership_links x3_ ON x0_.category_id = x3_.category_id LEFT JOIN xlite_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 3) AND (x0_.rpos BETWEEN 4 AND 76) ORDER BY x0_.lpos ASC;

SELECT
  COUNT(DISTINCT x0_.id) AS sclr_0
FROM
  xlite_reviews x0_
  INNER JOIN xlite_products x1_ ON x0_.product_id = x1_.product_id
WHERE
  x1_.product_id = ?
  AND x0_.status = ?

SELECT COUNT(DISTINCT x0_.id) AS sclr_0 FROM xlite_reviews x0_ INNER JOIN xlite_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = 70 AND x0_.status = 1;

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

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

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 = 'ExpressCheckout' LIMIT 1;

SELECT
  AVG(x0_.rating) AS sclr_0
FROM
  xlite_reviews x0_
  INNER JOIN xlite_products x1_ ON x0_.product_id = x1_.product_id
WHERE
  x1_.product_id = ?
  AND x0_.status = ?
LIMIT
  1

SELECT AVG(x0_.rating) AS sclr_0 FROM xlite_reviews x0_ INNER JOIN xlite_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = 70 AND x0_.status = 1 LIMIT 1;

SELECT
  t0.enabled AS enabled_1,
  t0.link AS link_2,
  t0.id AS id_3,
  t0.position AS position_4,
  t0.service_name AS service_name_5,
  t0.module AS module_6,
  t7.id AS id_8,
  t7.global_tab_id AS global_tab_id_9
FROM
  xlite_global_product_tabs t0
  LEFT JOIN xlite_custom_global_tabs t7 ON t7.global_tab_id = t0.id
WHERE
  t0.id = ?

SELECT t0.enabled AS enabled_1, t0.link AS link_2, t0.id AS id_3, t0.position AS position_4, t0.service_name AS service_name_5, t0.module AS module_6, t7.id AS id_8, t7.global_tab_id AS global_tab_id_9 FROM xlite_global_product_tabs t0 LEFT JOIN xlite_custom_global_tabs t7 ON t7.global_tab_id = t0.id WHERE t0.id = 1;

SELECT
  x0_.id AS id_0,
  COUNT(x0_.id) AS sclr_1
FROM
  xlite_attribute_values_select x1_
  LEFT JOIN xlite_attribute_values_select_translations x2_ ON x1_.id = x2_.id
  AND (x2_.code = ?)
  INNER JOIN xlite_attributes x0_ ON x1_.attribute_id = x0_.id
WHERE
  x1_.product_id = ?
  AND x0_.displayMode <> ?
  AND (
    x0_.product_class_id IS NULL
    OR x0_.product_class_id = ?
  )
GROUP BY
  x0_.id
HAVING
  COUNT(x0_.id) > 1
ORDER BY
  x0_.position ASC

SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xlite_attribute_values_select x1_ LEFT JOIN xlite_attribute_values_select_translations x2_ ON x1_.id = x2_.id AND (x2_.code = 'en') INNER JOIN xlite_attributes x0_ ON x1_.attribute_id = x0_.id WHERE x1_.product_id = 70 AND x0_.displayMode <> 'P' AND (x0_.product_class_id IS NULL OR x0_.product_class_id = NULL) GROUP BY x0_.id HAVING COUNT(x0_.id) > 1 ORDER BY x0_.position ASC;

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

SELECT
  x0_.id AS id_0,
  COUNT(x0_.id) AS sclr_1
FROM
  xlite_attribute_values_select x1_
  LEFT JOIN xlite_attribute_values_select_translations x2_ ON x1_.id = x2_.id
  AND (x2_.code = ?)
  INNER JOIN xlite_attributes x0_ ON x1_.attribute_id = x0_.id
WHERE
  x1_.product_id = ?
  AND (
    x0_.product_class_id IS NULL
    OR x0_.product_class_id = ?
  )
  AND x0_.googleShoppingGroup IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  x0_.id
HAVING
  COUNT(x0_.id) = 1
ORDER BY
  x0_.position ASC

SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xlite_attribute_values_select x1_ LEFT JOIN xlite_attribute_values_select_translations x2_ ON x1_.id = x2_.id AND (x2_.code = 'en') INNER JOIN xlite_attributes x0_ ON x1_.attribute_id = x0_.id WHERE x1_.product_id = 70 AND (x0_.product_class_id IS NULL OR x0_.product_class_id = NULL) AND x0_.googleShoppingGroup IN ('brand', 'color', 'pattern', 'material', 'size', 'size_type', 'size_system', 'age_group', 'gender', 'google_product_category', 'identifier_exists') GROUP BY x0_.id HAVING COUNT(x0_.id) = 1 ORDER BY x0_.position ASC;

SELECT
  x0_.id AS id_0,
  x0_.review AS review_1,
  x0_.response AS response_2,
  x0_.rating AS rating_3,
  x0_.additionDate AS additionDate_4,
  x0_.responseDate AS responseDate_5,
  x0_.reviewerName AS reviewerName_6,
  x0_.status AS status_7,
  x0_.useForMeta AS useForMeta_8,
  x0_.isNew AS isNew_9,
  x0_.xcPendingExport AS xcPendingExport_10,
  x0_.profile_id AS profile_id_11,
  x0_.respondent_id AS respondent_id_12,
  x0_.product_id AS product_id_13,
  x0_.rkey_id AS rkey_id_14
FROM
  xlite_reviews x0_
  INNER JOIN xlite_products x1_ ON x0_.product_id = x1_.product_id
WHERE
  x1_.product_id = ?
  AND x0_.status = 1
  AND x0_.review <> ?
GROUP BY
  x0_.id
ORDER BY
  x0_.additionDate DESC
LIMIT
  5

SELECT x0_.id AS id_0, x0_.review AS review_1, x0_.response AS response_2, x0_.rating AS rating_3, x0_.additionDate AS additionDate_4, x0_.responseDate AS responseDate_5, x0_.reviewerName AS reviewerName_6, x0_.status AS status_7, x0_.useForMeta AS useForMeta_8, x0_.isNew AS isNew_9, x0_.xcPendingExport AS xcPendingExport_10, x0_.profile_id AS profile_id_11, x0_.respondent_id AS respondent_id_12, x0_.product_id AS product_id_13, x0_.rkey_id AS rkey_id_14 FROM xlite_reviews x0_ INNER JOIN xlite_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = 70 AND x0_.status = 1 AND x0_.review <> '' GROUP BY x0_.id ORDER BY x0_.additionDate DESC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.orderby AS orderby_2,
  t0.access AS access_3,
  t0.remoteUrl AS remoteUrl_4,
  t0.product_id AS product_id_5,
  t6.id AS id_7,
  t6.path AS path_8,
  t6.fileName AS fileName_9,
  t6.mime AS mime_10,
  t6.storageType AS storageType_11,
  t6.size AS size_12,
  t6.date AS date_13,
  t6.attachment_id AS attachment_id_14
FROM
  xlite_product_attachments t0
  LEFT JOIN xlite_product_attachment_storages t6 ON t6.attachment_id = t0.id
WHERE
  t0.product_id = ?
ORDER BY
  t0.orderby ASC

SELECT t0.id AS id_1, t0.orderby AS orderby_2, t0.access AS access_3, t0.remoteUrl AS remoteUrl_4, t0.product_id AS product_id_5, t6.id AS id_7, t6.path AS path_8, t6.fileName AS fileName_9, t6.mime AS mime_10, t6.storageType AS storageType_11, t6.size AS size_12, t6.date AS date_13, t6.attachment_id AS attachment_id_14 FROM xlite_product_attachments t0 LEFT JOIN xlite_product_attachment_storages t6 ON t6.attachment_id = t0.id WHERE t0.product_id = 70 ORDER BY t0.orderby ASC;

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

SELECT
  x0_.id AS id_0,
  x0_.type AS type_1,
  x0_.price AS price_2,
  x0_.quantityRangeBegin AS quantityRangeBegin_3,
  x0_.quantityRangeEnd AS quantityRangeEnd_4,
  x0_.product_id AS product_id_5,
  x0_.membership_id AS membership_id_6
FROM
  xlite_wholesale_prices x0_
WHERE
  x0_.product_id = ?
LIMIT
  1

SELECT x0_.id AS id_0, x0_.type AS type_1, x0_.price AS price_2, x0_.quantityRangeBegin AS quantityRangeBegin_3, x0_.quantityRangeEnd AS quantityRangeEnd_4, x0_.product_id AS product_id_5, x0_.membership_id AS membership_id_6 FROM xlite_wholesale_prices x0_ WHERE x0_.product_id = 70 LIMIT 1;

SELECT
  COUNT(DISTINCT x0_.active_currency_id) AS sclr_0
FROM
  xlite_active_currencies x0_
WHERE
  x0_.enabled = ?

SELECT COUNT(DISTINCT x0_.active_currency_id) AS sclr_0 FROM xlite_active_currencies x0_ WHERE x0_.enabled = 1;

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

SELECT
  x0_.id AS id_0,
  x0_.position AS position_1,
  x0_.product_class_id AS product_class_id_2
FROM
  xlite_attribute_groups x0_
  LEFT JOIN xlite_attribute_group_translations x1_ ON x0_.id = x1_.id
  AND (x1_.code = ?)
WHERE
  x0_.product_class_id IS NULL
GROUP BY
  x0_.id
ORDER BY
  x0_.position ASC,
  x0_.id ASC

SELECT x0_.id AS id_0, x0_.position AS position_1, x0_.product_class_id AS product_class_id_2 FROM xlite_attribute_groups x0_ LEFT JOIN xlite_attribute_group_translations x1_ ON x0_.id = x1_.id AND (x1_.code = 'en') WHERE x0_.product_class_id IS NULL GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC;

SELECT
  x0_.show_selector AS show_selector_0,
  x0_.show_on_list AS show_on_list_1,
  x0_.googleShoppingGroup AS googleShoppingGroup_2,
  x0_.useForVariations AS useForVariations_3,
  x0_.id AS id_4,
  x0_.position AS position_5,
  x0_.displayAbove AS displayAbove_6,
  x0_.decimals AS decimals_7,
  x0_.type AS type_8,
  x0_.displayMode AS displayMode_9,
  x0_.addToNew AS addToNew_10,
  x0_.product_class_id AS product_class_id_11,
  x0_.attribute_group_id AS attribute_group_id_12,
  x0_.product_id AS product_id_13
FROM
  xlite_attributes x0_
  LEFT JOIN xlite_attribute_translations x1_ ON x0_.id = x1_.id
  AND (x1_.code = ?)
WHERE
  x1_.name = ?
  AND x0_.product_class_id IS NULL
  AND x0_.attribute_group_id IS NULL
  AND x0_.type = ?
  AND x0_.product_id IS NULL
ORDER BY
  x0_.position ASC,
  x0_.id ASC

SELECT x0_.show_selector AS show_selector_0, x0_.show_on_list AS show_on_list_1, x0_.googleShoppingGroup AS googleShoppingGroup_2, x0_.useForVariations AS useForVariations_3, x0_.id AS id_4, x0_.position AS position_5, x0_.displayAbove AS displayAbove_6, x0_.decimals AS decimals_7, x0_.type AS type_8, x0_.displayMode AS displayMode_9, x0_.addToNew AS addToNew_10, x0_.product_class_id AS product_class_id_11, x0_.attribute_group_id AS attribute_group_id_12, x0_.product_id AS product_id_13 FROM xlite_attributes x0_ LEFT JOIN xlite_attribute_translations x1_ ON x0_.id = x1_.id AND (x1_.code = 'en') WHERE x1_.name = 'Prop 65 Yes/No' AND x0_.product_class_id IS NULL AND x0_.attribute_group_id IS NULL AND x0_.type = 'C' AND x0_.product_id IS NULL ORDER BY x0_.position ASC, x0_.id ASC;

SELECT
  x0_.id AS id_0,
  x0_.type AS type_1,
  x0_.price AS price_2,
  x0_.quantityRangeBegin AS quantityRangeBegin_3,
  x0_.quantityRangeEnd AS quantityRangeEnd_4,
  x0_.product_id AS product_id_5,
  x0_.membership_id AS membership_id_6
FROM
  xlite_wholesale_prices x0_
  LEFT JOIN xlite_memberships x1_ ON x0_.membership_id = x1_.membership_id
WHERE
  (
    x0_.quantityRangeBegin <> 1
    OR x0_.membership_id IS NOT NULL
  )
  AND x0_.membership_id IS NULL
  AND (
    x0_.quantityRangeEnd >= ?
    OR x0_.quantityRangeEnd = 0
  )
  AND x0_.product_id = ?
GROUP BY
  x0_.id
ORDER BY
  x0_.quantityRangeBegin ASC

SELECT x0_.id AS id_0, x0_.type AS type_1, x0_.price AS price_2, x0_.quantityRangeBegin AS quantityRangeBegin_3, x0_.quantityRangeEnd AS quantityRangeEnd_4, x0_.product_id AS product_id_5, x0_.membership_id AS membership_id_6 FROM xlite_wholesale_prices x0_ LEFT JOIN xlite_memberships x1_ ON x0_.membership_id = x1_.membership_id WHERE (x0_.quantityRangeBegin <> 1 OR x0_.membership_id IS NOT NULL) AND x0_.membership_id IS NULL AND (x0_.quantityRangeEnd >= 1 OR x0_.quantityRangeEnd = 0) AND x0_.product_id = 70 GROUP BY x0_.id ORDER BY x0_.quantityRangeBegin ASC;