Symfony Profiler

[
  "event" => "xcart.boot"
  "listener" => "XCart\EventListener\XCartBootListener::onBoot"
]

[
  "event" => "xcart.boot"
  "listener" => "CDev\FedEx\Core\EventListener::onBoot"
]

[
  "event" => "xcart.boot"
  "listener" => "XC\UPS\Core\EventListener::onBoot"
]

[
  "event" => "xcart.boot"
  "listener" => "CDev\USPS\Core\EventListener::onBoot"
]

[
  "event" => "xcart.boot"
  "listener" => "XC\CanadaPost\Core\EventListener::onBoot"
]

[
  "params" => [
    "unix_socket" => ""
    "url" => "<redacted>"
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "luminoeu_lumint"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET sql_mode=(SELECT REPLACE(@@sql_mode, "ONLY_FULL_GROUP_BY", ""))"
      "table_prefix" => "xc"
      1009 => ""
      1008 => ""
      1007 => ""
    ]
    "driverClass" => "XCart\Doctrine\DBAL\Driver\PDO\MySQL\Driver"
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "luminoeu_xc5516"
    "serverVersion" => "5.7"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "576"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => ""
    3 => "E"
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
  ]
]

[
  "event" => "kernel.request"
  "listener" => "XCart\EventListener\CleanUrlListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Monolog\Processor\WebProcessor::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "XCart\EventListener\ConfigListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "XCart\EventListener\LanguageListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "XCart\API\EventSubscriber\Storefront\ProfileDetectionEventSubscriber::process"
]

[
  "event" => "kernel.request"
  "listener" => "XCart\API\EventSubscriber\Storefront\CartAccessValidationEventSubscriber::checkCart"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\JsonApi\TransformPaginationParametersListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\JsonApi\TransformSortingParametersListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\JsonApi\TransformFieldsetsParametersListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\JsonApi\TransformFilteringParametersListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "XCart\API\EventSubscriber\Storefront\CartAccessValidationEventSubscriber::checkCartItem"
]

[
  "event" => "kernel.request"
  "listener" => "CDev\Coupons\API\EventSubscriber\Storefront\CouponAccessValidationEventSubscriber::checkCartCoupon"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Core\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurity"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DenyAccessListener::onSecurityPostDenormalize"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\Bundle\EventListener\SwaggerUiListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "XCart\EventListener\KernelControllerInitListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "XCart\EventListener\ModulesInitEventDispatcher::dispatchModulesInitEvent"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "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"
  "params" => [
    1 => "rooster-mug-in-white"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "840"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "547"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "US"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "cloud_search_reg_scheduled"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "deferrer.callback.run"
  "listener" => "XCart\EntityCallback\MembershipCallback::runQuickData"
]

[
  "event" => "deferrer.callback.run"
  "listener" => "XCart\EntityCallback\ProductCallback::runQuickData"
]

[
  "sql" => "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"
  "params" => [
    1 => null
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.entityType AS entityType_1, x0_.version AS version_2 FROM xc_entity_type_versions x0_"
]

[
  "sql" => "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"
]

[
  "sql" => "SELECT COUNT(DISTINCT x0_.active_currency_id) AS sclr_0 FROM xc_active_currencies x0_ WHERE x0_.enabled = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "Lumino-LuminoBeady"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ExpressCheckout"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 27
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 27
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.title AS title_1, x0_.location AS location_2, x0_.width AS width_3, x0_.height AS height_4, x0_.position AS position_5, x0_.enabled AS enabled_6, x0_.parallax AS parallax_7, x0_.effect AS effect_8, x0_.timeout AS timeout_9, x0_.delay AS delay_10, x0_.home_page AS home_page_11, x0_.products_pages AS products_pages_12, x0_.navigation AS navigation_13, x0_.arrows AS arrows_14 FROM xc_banners x0_ LEFT JOIN xc_membership_banner x2_ ON x0_.id = x2_.banner_id LEFT JOIN xc_memberships x1_ ON x1_.membership_id = x2_.membership_id INNER JOIN xc_banner_category x4_ ON x0_.id = x4_.banner_id INNER JOIN xc_categories x3_ ON x3_.category_id = x4_.category_id WHERE x0_.id = ? AND x0_.enabled = 1 AND x1_.membership_id IS NULL AND x3_.category_id = ? AND x0_.products_pages = 1 GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => 1
    2 => 5
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "PaypalWPS"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT MAX(x0_.rpos) AS sclr_0 FROM xc_categories x0_ LIMIT 1"
]

[
  "sql" => "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"
  "params" => [
    1 => "en"
    2 => 1
    3 => 1
    4 => 1
    5 => 7
    6 => 8
    7 => 24
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.subcategories_count_all AS subcategories_count_all_2, t0.subcategories_count_enabled AS subcategories_count_enabled_3, t0.category_id AS category_id_4 FROM xc_category_quick_flags t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.alt AS alt_1, t0.width AS width_2, t0.height AS height_3, t0.hash AS hash_4, t0.needProcess AS needProcess_5, t0.id AS id_6, t0.path AS path_7, t0.fileName AS fileName_8, t0.mime AS mime_9, t0.storageType AS storageType_10, t0.size AS size_11, t0.date AS date_12, t0.category_id AS category_id_13 FROM xc_category_images t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.alt AS alt_1, t0.width AS width_2, t0.height AS height_3, t0.hash AS hash_4, t0.needProcess AS needProcess_5, t0.id AS id_6, t0.path AS path_7, t0.fileName AS fileName_8, t0.mime AS mime_9, t0.storageType AS storageType_10, t0.size AS size_11, t0.date AS date_12, t0.category_id AS category_id_13 FROM xc_category_banners t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.ogMeta AS ogMeta_1, t0.name AS name_2, t0.description AS description_3, t0.metaTags AS metaTags_4, t0.metaDesc AS metaDesc_5, t0.metaTitle AS metaTitle_6, t0.label_id AS label_id_7, t0.code AS code_8, t0.id AS id_9 FROM xc_category_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "en"
    2 => 1
    3 => 1
    4 => 1
    5 => 2
    6 => 9
    7 => 24
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.ogMeta AS ogMeta_1, t0.name AS name_2, t0.description AS description_3, t0.metaTags AS metaTags_4, t0.metaDesc AS metaDesc_5, t0.metaTitle AS metaTitle_6, t0.label_id AS label_id_7, t0.code AS code_8, t0.id AS id_9 FROM xc_category_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "en"
    2 => 1
    3 => 1
    4 => 1
    5 => 7
    6 => 8
    7 => 24
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.ogMeta AS ogMeta_1, t0.backorderQtyLabel AS backorderQtyLabel_2, t0.name AS name_3, t0.description AS description_4, t0.briefDescription AS briefDescription_5, t0.metaTags AS metaTags_6, t0.metaDesc AS metaDesc_7, t0.metaTitle AS metaTitle_8, t0.label_id AS label_id_9, t0.code AS code_10, t0.id AS id_11 FROM xc_product_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "XPaymentsCloud"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(x0_.id) AS sclr_0 FROM xc_product_variants x0_ WHERE x0_.product_id = ? LIMIT 1"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.orderby AS orderby_1, t0.alt AS alt_2, t0.width AS width_3, t0.height AS height_4, t0.hash AS hash_5, t0.needProcess AS needProcess_6, t0.id AS id_7, t0.path AS path_8, t0.fileName AS fileName_9, t0.mime AS mime_10, t0.storageType AS storageType_11, t0.size AS size_12, t0.date AS date_13, t0.product_id AS product_id_14 FROM xc_product_images t0 WHERE t0.product_id = ? ORDER BY t0.orderby ASC"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.quantity AS quantity_1, x0_.membership_id AS membership_id_2, x0_.product_id AS product_id_3 FROM xc_product_min_quantities x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = ? AND x0_.membership_id IS NULL LIMIT 1"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.class AS class_1, x0_.modificator AS modificator_2, x0_.validator AS validator_3, x0_.position AS position_4, x0_.behavior AS behavior_5, x0_.purpose AS purpose_6 FROM xc_money_modificators x0_ ORDER BY x0_.position ASC"
]

[
  "sql" => "SELECT x0_.useCustomOG AS useCustomOG_0, x0_.applyToWholesale AS applyToWholesale_1, x0_.id AS id_2, x0_.enabled AS enabled_3, x0_.value AS value_4, x0_.dateRangeBegin AS dateRangeBegin_5, x0_.dateRangeEnd AS dateRangeEnd_6, x0_.showInSeparateSection AS showInSeparateSection_7, x0_.metaDescType AS metaDescType_8, x0_.specificProducts AS specificProducts_9 FROM xc_sale_discounts x0_ WHERE x0_.enabled = ? AND (x0_.dateRangeBegin = 0 OR x0_.dateRangeBegin < ?) AND (x0_.dateRangeEnd = 0 OR x0_.dateRangeEnd > ?) ORDER BY x0_.value DESC"
  "params" => [
    1 => 1
    2 => 1760974644
    3 => 1760974644
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_select x1_ LEFT JOIN xc_attribute_values_select_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_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"
  "params" => [
    1 => "en"
    2 => 25
    3 => null
    4 => "brand"
    5 => "color"
    6 => "pattern"
    7 => "material"
    8 => "size"
    9 => "size_type"
    10 => "size_system"
    11 => "age_group"
    12 => "gender"
    13 => "google_product_category"
    14 => "identifier_exists"
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_text x1_ LEFT JOIN xc_attribute_values_text_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_attributes x0_ ON x1_.attribute_id = x0_.id WHERE (x1_.product_id = ? AND x1_.editable = ?) AND (x0_.product_class_id IS NULL OR x0_.product_class_id = ?) AND x0_.googleShoppingGroup IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY x0_.id ORDER BY x0_.position ASC"
  "params" => [
    1 => "en"
    2 => 25
    3 => 0
    4 => null
    5 => "brand"
    6 => "color"
    7 => "pattern"
    8 => "material"
    9 => "size"
    10 => "size_type"
    11 => "size_system"
    12 => "age_group"
    13 => "gender"
    14 => "google_product_category"
    15 => "identifier_exists"
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 5
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_checkbox x1_ LEFT JOIN xc_attribute_values_checkbox_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_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"
  "params" => [
    1 => "en"
    2 => 25
    3 => null
    4 => "brand"
    5 => "color"
    6 => "pattern"
    7 => "material"
    8 => "size"
    9 => "size_type"
    10 => "size_system"
    11 => "age_group"
    12 => "gender"
    13 => "google_product_category"
    14 => "identifier_exists"
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_hidden x1_ LEFT JOIN xc_attribute_values_hidden_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_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"
  "params" => [
    1 => "en"
    2 => 25
    3 => null
    4 => "brand"
    5 => "color"
    6 => "pattern"
    7 => "material"
    8 => "size"
    9 => "size_type"
    10 => "size_system"
    11 => "age_group"
    12 => "gender"
    13 => "google_product_category"
    14 => "identifier_exists"
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
  ]
]

[
  "sql" => "SELECT x0_.discountType AS discountType_0, x0_.salePriceValue AS salePriceValue_1, x0_.defaultSale AS defaultSale_2, x0_.costPrice AS costPrice_3, x0_.id AS id_4, x0_.price AS price_5, x0_.defaultPrice AS defaultPrice_6, x0_.amount AS amount_7, x0_.defaultAmount AS defaultAmount_8, x0_.weight AS weight_9, x0_.defaultWeight AS defaultWeight_10, x0_.sku AS sku_11, x0_.variant_id AS variant_id_12, x0_.defaultValue AS defaultValue_13, x0_.product_id AS product_id_14 FROM xc_product_variants x0_ WHERE x0_.product_id = ? AND x0_.defaultPrice = ? LIMIT 1"
  "params" => [
    1 => 25
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 5
  ]
]

[
  "sql" => "SELECT t0.show_selector AS show_selector_1, t0.show_on_list AS show_on_list_2, t0.googleShoppingGroup AS googleShoppingGroup_3, t0.id AS id_4, t0.position AS position_5, t0.displayAbove AS displayAbove_6, t0.decimals AS decimals_7, t0.type AS type_8, t0.displayMode AS displayMode_9, t0.addToNew AS addToNew_10, t0.product_class_id AS product_class_id_11, t0.attribute_group_id AS attribute_group_id_12, t0.product_id AS product_id_13 FROM xc_attributes t0 INNER JOIN xc_product_variants_attributes ON t0.id = xc_product_variants_attributes.attribute_id WHERE xc_product_variants_attributes.product_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.discountType AS discountType_1, t0.salePriceValue AS salePriceValue_2, t0.defaultSale AS defaultSale_3, t0.costPrice AS costPrice_4, t0.id AS id_5, t0.price AS price_6, t0.defaultPrice AS defaultPrice_7, t0.amount AS amount_8, t0.defaultAmount AS defaultAmount_9, t0.weight AS weight_10, t0.defaultWeight AS defaultWeight_11, t0.sku AS sku_12, t0.variant_id AS variant_id_13, t0.defaultValue AS defaultValue_14, t0.product_id AS product_id_15, t16.alt AS alt_17, t16.width AS width_18, t16.height AS height_19, t16.hash AS hash_20, t16.needProcess AS needProcess_21, t16.id AS id_22, t16.path AS path_23, t16.fileName AS fileName_24, t16.mime AS mime_25, t16.storageType AS storageType_26, t16.size AS size_27, t16.date AS date_28, t16.product_variant_id AS product_variant_id_29 FROM xc_product_variants t0 LEFT JOIN xc_product_variant_images t16 ON t16.product_variant_id = t0.id WHERE t0.product_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.discountType AS discountType_0, x0_.salePriceValue AS salePriceValue_1, x0_.defaultSale AS defaultSale_2, x0_.costPrice AS costPrice_3, x0_.id AS id_4, x0_.price AS price_5, x0_.defaultPrice AS defaultPrice_6, x0_.amount AS amount_7, x0_.defaultAmount AS defaultAmount_8, x0_.weight AS weight_9, x0_.defaultWeight AS defaultWeight_10, x0_.sku AS sku_11, x0_.variant_id AS variant_id_12, x0_.defaultValue AS defaultValue_13, x0_.product_id AS product_id_14 FROM xc_product_variants x0_ WHERE x0_.product_id = ? AND x0_.defaultWeight = ? LIMIT 1"
  "params" => [
    1 => 25
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 5
  ]
]

[
  "sql" => "SELECT x0_.discountType AS discountType_0, x0_.salePriceValue AS salePriceValue_1, x0_.defaultSale AS defaultSale_2, x0_.costPrice AS costPrice_3, x0_.id AS id_4, x0_.price AS price_5, x0_.defaultPrice AS defaultPrice_6, x0_.amount AS amount_7, x0_.defaultAmount AS defaultAmount_8, x0_.weight AS weight_9, x0_.defaultWeight AS defaultWeight_10, x0_.sku AS sku_11, x0_.variant_id AS variant_id_12, x0_.defaultValue AS defaultValue_13, x0_.product_id AS product_id_14 FROM xc_product_variants x0_ WHERE x0_.product_id = ? AND x0_.sku IS NOT NULL AND x0_.sku <> ? LIMIT 1"
  "params" => [
    1 => 25
    2 => ""
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT x0_.discountType AS discountType_0, x0_.salePriceValue AS salePriceValue_1, x0_.defaultSale AS defaultSale_2, x0_.costPrice AS costPrice_3, x0_.id AS id_4, x0_.price AS price_5, x0_.defaultPrice AS defaultPrice_6, x0_.amount AS amount_7, x0_.defaultAmount AS defaultAmount_8, x0_.weight AS weight_9, x0_.defaultWeight AS defaultWeight_10, x0_.sku AS sku_11, x0_.variant_id AS variant_id_12, x0_.defaultValue AS defaultValue_13, x0_.product_id AS product_id_14 FROM xc_product_variants x0_ WHERE x0_.product_id = ? AND x0_.defaultSale = ? LIMIT 1"
  "params" => [
    1 => 25
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 5
  ]
]

[
  "sql" => "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_variant_id AS product_variant_id_5, x0_.membership_id AS membership_id_6 FROM xc_product_variant_wholesale_prices x0_ INNER JOIN xc_product_variants x1_ ON x0_.product_variant_id = x1_.id WHERE x1_.product_id = ? LIMIT 1"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 xc_wholesale_prices x0_ WHERE x0_.product_id = ? LIMIT 1"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0 FROM xc_attribute_values_select x1_ LEFT JOIN xc_attribute_values_select_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_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 x1_.priceModifier <> 0 GROUP BY x0_.id LIMIT 1"
  "params" => [
    1 => "en"
    2 => 25
    3 => null
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0 FROM xc_attribute_values_select x1_ LEFT JOIN xc_attribute_values_select_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_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 x1_.weightModifier <> 0 GROUP BY x0_.id LIMIT 1"
  "params" => [
    1 => "en"
    2 => 25
    3 => null
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0 FROM xc_attribute_values_checkbox x1_ LEFT JOIN xc_attribute_values_checkbox_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_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 x1_.priceModifier <> 0 GROUP BY x0_.id LIMIT 1"
  "params" => [
    1 => "en"
    2 => 25
    3 => null
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0 FROM xc_attribute_values_checkbox x1_ LEFT JOIN xc_attribute_values_checkbox_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_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 x1_.weightModifier <> 0 GROUP BY x0_.id LIMIT 1"
  "params" => [
    1 => "en"
    2 => 25
    3 => null
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "en"
    2 => 1
    3 => 1
    4 => 1
    5 => 7
    6 => 8
    7 => 24
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "SELECT t0.sticker_id AS sticker_id_1, t0.position AS position_2, t0.enabled AS enabled_3, t0.text_color AS text_color_4, t0.bg_color AS bg_color_5, t0.isLabel AS isLabel_6 FROM xc_product_stickers t0 INNER JOIN xc_product_stickers_links ON t0.sticker_id = xc_product_stickers_links.sticker_id WHERE xc_product_stickers_links.product_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.sticker_id AS sticker_id_1, t0.position AS position_2, t0.enabled AS enabled_3, t0.text_color AS text_color_4, t0.bg_color AS bg_color_5, t0.isLabel AS isLabel_6 FROM xc_product_stickers t0 INNER JOIN xc_category_stickers_links ON t0.sticker_id = xc_category_stickers_links.sticker_id WHERE xc_category_stickers_links.category_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_select x1_ LEFT JOIN xc_attribute_values_select_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_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"
  "params" => [
    1 => "en"
    2 => 25
    3 => "P"
    4 => null
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_text x1_ LEFT JOIN xc_attribute_values_text_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_attributes x0_ ON x1_.attribute_id = x0_.id WHERE (x1_.product_id = ? AND x1_.editable = ?) AND (x0_.product_class_id IS NULL OR x0_.product_class_id = ?) GROUP BY x0_.id ORDER BY x0_.position ASC"
  "params" => [
    1 => "en"
    2 => 25
    3 => 1
    4 => null
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 5
    4 => 2
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_checkbox x1_ LEFT JOIN xc_attribute_values_checkbox_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_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"
  "params" => [
    1 => "en"
    2 => 25
    3 => "P"
    4 => null
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2 FROM xc_tags t0 INNER JOIN xc_product_tags ON t0.id = xc_product_tags.tag_id WHERE xc_product_tags.product_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.show_selector AS show_selector_1, t0.show_on_list AS show_on_list_2, t0.googleShoppingGroup AS googleShoppingGroup_3, t0.id AS id_4, t0.position AS position_5, t0.displayAbove AS displayAbove_6, t0.decimals AS decimals_7, t0.type AS type_8, t0.displayMode AS displayMode_9, t0.addToNew AS addToNew_10, t0.product_class_id AS product_class_id_11, t0.attribute_group_id AS attribute_group_id_12, t0.product_id AS product_id_13 FROM xc_attributes t0 WHERE t0.id = ?"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT AVG(x0_.rating) AS sclr_0 FROM xc_reviews x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = ? AND x0_.status = ? LIMIT 1"
  "params" => [
    1 => 25
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT x0_.id) AS sclr_0 FROM xc_reviews x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = ? AND x0_.status = ?"
  "params" => [
    1 => 25
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT x0_.id) AS sclr_0 FROM xc_reviews x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = ? AND x0_.status = ? AND x0_.review <> ?"
  "params" => [
    1 => 25
    2 => 1
    3 => ""
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.show_selector AS show_selector_1, t0.show_on_list AS show_on_list_2, t0.googleShoppingGroup AS googleShoppingGroup_3, t0.id AS id_4, t0.position AS position_5, t0.displayAbove AS displayAbove_6, t0.decimals AS decimals_7, t0.type AS type_8, t0.displayMode AS displayMode_9, t0.addToNew AS addToNew_10, t0.product_class_id AS product_class_id_11, t0.attribute_group_id AS attribute_group_id_12, t0.product_id AS product_id_13 FROM xc_attributes t0 WHERE t0.id = ?"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.show_selector AS show_selector_0, x0_.show_on_list AS show_on_list_1, x0_.googleShoppingGroup AS googleShoppingGroup_2, x0_.id AS id_3, x0_.position AS position_4, x0_.displayAbove AS displayAbove_5, x0_.decimals AS decimals_6, x0_.type AS type_7, x0_.displayMode AS displayMode_8, x0_.addToNew AS addToNew_9, x0_.product_class_id AS product_class_id_10, x0_.attribute_group_id AS attribute_group_id_11, x0_.product_id AS product_id_12 FROM xc_attributes x0_ LEFT JOIN xc_attribute_translations x1_ ON x0_.id = x1_.id AND (x1_.code = ?) INNER JOIN xc_attribute_values_select x2_ ON (x2_.attribute_id = x0_.id) WHERE x2_.product_id = ? ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => "en"
    2 => 25
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT x0_.show_selector AS show_selector_0, x0_.show_on_list AS show_on_list_1, x0_.googleShoppingGroup AS googleShoppingGroup_2, x0_.id AS id_3, x0_.position AS position_4, x0_.displayAbove AS displayAbove_5, x0_.decimals AS decimals_6, x0_.type AS type_7, x0_.displayMode AS displayMode_8, x0_.addToNew AS addToNew_9, x0_.product_class_id AS product_class_id_10, x0_.attribute_group_id AS attribute_group_id_11, x0_.product_id AS product_id_12 FROM xc_attributes x0_ LEFT JOIN xc_attribute_translations x1_ ON x0_.id = x1_.id AND (x1_.code = ?) INNER JOIN xc_attribute_values_text x2_ ON (x2_.attribute_id = x0_.id) LEFT JOIN xc_attribute_values_text_translations x3_ ON x2_.id = x3_.id WHERE x2_.product_id = ? AND (x2_.editable = ? OR x3_.value <> ?) ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => "en"
    2 => 25
    3 => 1
    4 => ""
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 5
    4 => 2
  ]
]

[
  "sql" => "SELECT x0_.show_selector AS show_selector_0, x0_.show_on_list AS show_on_list_1, x0_.googleShoppingGroup AS googleShoppingGroup_2, x0_.id AS id_3, x0_.position AS position_4, x0_.displayAbove AS displayAbove_5, x0_.decimals AS decimals_6, x0_.type AS type_7, x0_.displayMode AS displayMode_8, x0_.addToNew AS addToNew_9, x0_.product_class_id AS product_class_id_10, x0_.attribute_group_id AS attribute_group_id_11, x0_.product_id AS product_id_12 FROM xc_attributes x0_ LEFT JOIN xc_attribute_translations x1_ ON x0_.id = x1_.id AND (x1_.code = ?) INNER JOIN xc_attribute_values_checkbox x2_ ON (x2_.attribute_id = x0_.id) WHERE x2_.product_id = ? ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => "en"
    2 => 25
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "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 xc_wholesale_prices x0_ LEFT JOIN xc_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"
  "params" => [
    1 => 1
    2 => 25
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "XPaymentsApplePay"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "XPaymentsGooglePay"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 xc_wholesale_prices x0_ WHERE (x0_.quantityRangeBegin <> 1 OR x0_.membership_id IS NOT NULL) AND x0_.product_id = ? GROUP BY x0_.id"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.enabled AS enabled_3, t0.link AS link_4, t0.product_id AS product_id_5, t0.global_tab_id AS global_tab_id_6 FROM xc_product_tabs t0 WHERE t0.product_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 xc_global_product_tabs t0 LEFT JOIN xc_custom_global_tabs t7 ON t7.global_tab_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.tab_id AS tab_id_3 FROM xc_global_product_tab_provider t0 WHERE t0.tab_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 xc_global_product_tabs t0 LEFT JOIN xc_custom_global_tabs t7 ON t7.global_tab_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.tab_id AS tab_id_3 FROM xc_global_product_tab_provider t0 WHERE t0.tab_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.position AS position_1, x0_.product_class_id AS product_class_id_2 FROM xc_attribute_groups x0_ LEFT JOIN xc_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"
  "params" => [
    1 => "en"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 xc_global_product_tabs t0 LEFT JOIN xc_custom_global_tabs t7 ON t7.global_tab_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.tab_id AS tab_id_3 FROM xc_global_product_tab_provider t0 WHERE t0.tab_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 xc_global_product_tabs t0 LEFT JOIN xc_custom_global_tabs t7 ON t7.global_tab_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.tab_id AS tab_id_3 FROM xc_global_product_tab_provider t0 WHERE t0.tab_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 xc_global_product_tabs t0 LEFT JOIN xc_custom_global_tabs t7 ON t7.global_tab_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.brief_info AS brief_info_2, t0.content AS content_3, t0.label_id AS label_id_4, t0.code AS code_5, t0.id AS id_6 FROM xc_custom_global_tab_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 xc_global_product_tabs t0 LEFT JOIN xc_custom_global_tabs t7 ON t7.global_tab_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.brief_info AS brief_info_2, t0.content AS content_3, t0.label_id AS label_id_4, t0.code AS code_5, t0.id AS id_6 FROM xc_custom_global_tab_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 xc_global_product_tabs t0 LEFT JOIN xc_custom_global_tabs t7 ON t7.global_tab_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.brief_info AS brief_info_2, t0.content AS content_3, t0.label_id AS label_id_4, t0.code AS code_5, t0.id AS id_6 FROM xc_custom_global_tab_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.private AS private_1, t0.id AS id_2, t0.orderby AS orderby_3, t0.access AS access_4, t0.remoteUrl AS remoteUrl_5, t0.product_id AS product_id_6, t7.id AS id_8, t7.path AS path_9, t7.fileName AS fileName_10, t7.mime AS mime_11, t7.storageType AS storageType_12, t7.size AS size_13, t7.date AS date_14, t7.attachment_id AS attachment_id_15 FROM xc_product_attachments t0 LEFT JOIN xc_product_attachment_storages t7 ON t7.attachment_id = t0.id WHERE t0.product_id = ? ORDER BY t0.orderby ASC"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.show_selector AS show_selector_0, x0_.show_on_list AS show_on_list_1, x0_.googleShoppingGroup AS googleShoppingGroup_2, x0_.id AS id_3, x0_.position AS position_4, x0_.displayAbove AS displayAbove_5, x0_.decimals AS decimals_6, x0_.type AS type_7, x0_.displayMode AS displayMode_8, x0_.addToNew AS addToNew_9, x0_.product_class_id AS product_class_id_10, x0_.attribute_group_id AS attribute_group_id_11, x0_.product_id AS product_id_12 FROM xc_attributes x0_ LEFT JOIN xc_attribute_translations x1_ ON x0_.id = x1_.id AND (x1_.code = ?) WHERE x0_.product_id IS NULL AND x0_.attribute_group_id IS NULL AND x0_.product_class_id IS NULL AND x0_.type <> ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => "en"
    2 => "H"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT x0_.show_selector AS show_selector_0, x0_.show_on_list AS show_on_list_1, x0_.googleShoppingGroup AS googleShoppingGroup_2, x0_.id AS id_3, x0_.position AS position_4, x0_.displayAbove AS displayAbove_5, x0_.decimals AS decimals_6, x0_.type AS type_7, x0_.displayMode AS displayMode_8, x0_.addToNew AS addToNew_9, x0_.product_class_id AS product_class_id_10, x0_.attribute_group_id AS attribute_group_id_11, x0_.product_id AS product_id_12 FROM xc_attributes x0_ LEFT JOIN xc_attribute_translations x1_ ON x0_.id = x1_.id AND (x1_.code = ?) WHERE x0_.product_id = ? AND x0_.type <> ? GROUP BY x0_.id ORDER BY x0_.position ASC, x0_.id ASC"
  "params" => [
    1 => "en"
    2 => 25
    3 => "H"
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT x0_.id) AS sclr_0 FROM xc_upselling_products x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id LEFT JOIN xc_product_variants x2_ ON x1_.product_id = x2_.product_id LEFT JOIN xc_product_membership_links x4_ ON x1_.product_id = x4_.product_id LEFT JOIN xc_memberships x3_ ON x3_.membership_id = x4_.membership_id WHERE x0_.parent_product_id = ? AND (x1_.inventoryEnabled = ? OR x2_.amount > ? OR (x1_.amount > ? AND (x2_.id IS NULL OR x2_.defaultAmount = ?)) OR x1_.isAvailableForBackorder = ?) AND x1_.enabled = ? AND x1_.arrivalDate < ? AND x3_.membership_id IS NULL"
  "params" => [
    1 => 25
    2 => 0
    3 => 0
    4 => 0
    5 => 1
    6 => 1
    7 => 1
    8 => 1761001199
  ]
  "types" => [
    1 => 1
    2 => 5
    3 => 1
    4 => 1
    5 => 5
    6 => 5
    7 => 5
    8 => 1
  ]
]

[
  "sql" => "SELECT x0_.profile_id AS profile_id_0 FROM xc_orders x1_ INNER JOIN xc_order_items x2_ ON x1_.order_id = x2_.order_id AND x2_.object_type IN ('product') INNER JOIN xc_products x3_ ON x2_.object_id = x3_.product_id AND (x3_.product_id = ?) INNER JOIN xc_profiles x0_ ON x1_.orig_profile_id = x0_.profile_id WHERE (x1_.is_order NOT IN ('0')) AND x1_.is_order IN ('1', '0')"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT x0_.product_id) AS sclr_0 FROM xc_products x0_ LEFT JOIN xc_product_translations x1_ ON x0_.product_id = x1_.id LEFT JOIN xc_product_membership_links x3_ ON x0_.product_id = x3_.product_id LEFT JOIN xc_memberships x2_ ON x2_.membership_id = x3_.membership_id INNER JOIN xc_order_items x4_ ON x0_.product_id = x4_.object_id AND x4_.object_type IN ('product') INNER JOIN xc_orders x5_ ON x4_.order_id = x5_.order_id AND x5_.is_order IN ('1', '0') INNER JOIN xc_profiles x6_ ON x5_.orig_profile_id = x6_.profile_id AND (x6_.profile_id = ?) LEFT JOIN xc_product_variants x7_ ON x0_.product_id = x7_.product_id WHERE x0_.enabled = ? AND x0_.arrivalDate < ? AND x2_.membership_id IS NULL AND x0_.product_id <> ? AND (x0_.inventoryEnabled = ? OR x7_.amount > ? OR (x0_.amount > ? AND (x7_.id IS NULL OR x7_.defaultAmount = ?)) OR x0_.isAvailableForBackorder = ?)"
  "params" => [
    1 => null
    2 => 1
    3 => 1761001199
    4 => 25
    5 => 0
    6 => 0
    7 => 0
    8 => 1
    9 => 1
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
    5 => 5
    6 => 1
    7 => 1
    8 => 5
    9 => 5
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT x0_.product_id) AS sclr_0 FROM xc_products x0_ LEFT JOIN xc_product_translations x1_ ON x0_.product_id = x1_.id LEFT JOIN xc_product_membership_links x3_ ON x0_.product_id = x3_.product_id LEFT JOIN xc_memberships x2_ ON x2_.membership_id = x3_.membership_id INNER JOIN xc_product_stats x4_ ON x0_.product_id = x4_.bought_product_id INNER JOIN xc_products x5_ ON x4_.viewed_product_id = x5_.product_id AND (x5_.product_id = ?) LEFT JOIN xc_product_variants x6_ ON x0_.product_id = x6_.product_id WHERE x0_.enabled = ? AND x0_.arrivalDate < ? AND x2_.membership_id IS NULL AND (x0_.inventoryEnabled = ? OR x6_.amount > ? OR (x0_.amount > ? AND (x6_.id IS NULL OR x6_.defaultAmount = ?)) OR x0_.isAvailableForBackorder = ?)"
  "params" => [
    1 => 25
    2 => 1
    3 => 1761001199
    4 => 0
    5 => 0
    6 => 0
    7 => 1
    8 => 1
  ]
  "types" => [
    1 => 1
    2 => 5
    3 => 1
    4 => 5
    5 => 1
    6 => 1
    7 => 5
    8 => 5
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.orderBy AS orderBy_1, x0_.product_id AS product_id_2, x0_.parent_product_id AS parent_product_id_3 FROM xc_upselling_products x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id LEFT JOIN xc_product_variants x2_ ON x1_.product_id = x2_.product_id LEFT JOIN xc_product_membership_links x4_ ON x1_.product_id = x4_.product_id LEFT JOIN xc_memberships x3_ ON x3_.membership_id = x4_.membership_id WHERE x0_.parent_product_id = ? AND (x1_.inventoryEnabled = ? OR x2_.amount > ? OR (x1_.amount > ? AND (x2_.id IS NULL OR x2_.defaultAmount = ?)) OR x1_.isAvailableForBackorder = ?) AND x1_.enabled = ? AND x1_.arrivalDate < ? AND x3_.membership_id IS NULL GROUP BY x0_.id ORDER BY x0_.orderBy ASC, x0_.id ASC LIMIT 1000000000"
  "params" => [
    1 => 25
    2 => 0
    3 => 0
    4 => 0
    5 => 1
    6 => 1
    7 => 1
    8 => 1761001199
  ]
  "types" => [
    1 => 1
    2 => 5
    3 => 1
    4 => 1
    5 => 5
    6 => 5
    7 => 5
    8 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(x0_.id) AS sclr_0 FROM xc_product_variants x0_ WHERE x0_.product_id = ? LIMIT 1"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.quantity AS quantity_1, x0_.membership_id AS membership_id_2, x0_.product_id AS product_id_3 FROM xc_product_min_quantities x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = ? AND x0_.membership_id IS NULL LIMIT 1"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(x0_.id) AS sclr_0 FROM xc_product_variants x0_ WHERE x0_.product_id = ? LIMIT 1"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.quantity AS quantity_1, x0_.membership_id AS membership_id_2, x0_.product_id AS product_id_3 FROM xc_product_min_quantities x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = ? AND x0_.membership_id IS NULL LIMIT 1"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(x0_.id) AS sclr_0 FROM xc_product_variants x0_ WHERE x0_.product_id = ? LIMIT 1"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.quantity AS quantity_1, x0_.membership_id AS membership_id_2, x0_.product_id AS product_id_3 FROM xc_product_min_quantities x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = ? AND x0_.membership_id IS NULL LIMIT 1"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(x0_.id) AS sclr_0 FROM xc_product_variants x0_ WHERE x0_.product_id = ? LIMIT 1"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.quantity AS quantity_1, x0_.membership_id AS membership_id_2, x0_.product_id AS product_id_3 FROM xc_product_min_quantities x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = ? AND x0_.membership_id IS NULL LIMIT 1"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(x0_.id) AS sclr_0 FROM xc_product_variants x0_ WHERE x0_.product_id = ? LIMIT 1"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, x0_.quantity AS quantity_1, x0_.membership_id AS membership_id_2, x0_.product_id AS product_id_3 FROM xc_product_min_quantities x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = ? AND x0_.membership_id IS NULL LIMIT 1"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT x0_.product_id AS product_id_0 FROM xc_wishlist_link x1_ LEFT JOIN xc_products x0_ ON x1_.parent_product_id = x0_.product_id WHERE x1_.wishlist_id = ? AND x0_.enabled = ?"
  "params" => [
    1 => null
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.orderby AS orderby_1, t0.alt AS alt_2, t0.width AS width_3, t0.height AS height_4, t0.hash AS hash_5, t0.needProcess AS needProcess_6, t0.id AS id_7, t0.path AS path_8, t0.fileName AS fileName_9, t0.mime AS mime_10, t0.storageType AS storageType_11, t0.size AS size_12, t0.date AS date_13, t0.product_id AS product_id_14 FROM xc_product_images t0 WHERE t0.product_id = ? ORDER BY t0.orderby ASC"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.ogMeta AS ogMeta_1, t0.backorderQtyLabel AS backorderQtyLabel_2, t0.name AS name_3, t0.description AS description_4, t0.briefDescription AS briefDescription_5, t0.metaTags AS metaTags_6, t0.metaDesc AS metaDesc_7, t0.metaTitle AS metaTitle_8, t0.label_id AS label_id_9, t0.code AS code_10, t0.id AS id_11 FROM xc_product_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "en"
    2 => 1
    3 => 1
    4 => 1
    5 => 13
    6 => 14
    7 => 24
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.subcategories_count_all AS subcategories_count_all_2, t0.subcategories_count_enabled AS subcategories_count_enabled_3, t0.category_id AS category_id_4 FROM xc_category_quick_flags t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.alt AS alt_1, t0.width AS width_2, t0.height AS height_3, t0.hash AS hash_4, t0.needProcess AS needProcess_5, t0.id AS id_6, t0.path AS path_7, t0.fileName AS fileName_8, t0.mime AS mime_9, t0.storageType AS storageType_10, t0.size AS size_11, t0.date AS date_12, t0.category_id AS category_id_13 FROM xc_category_images t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.alt AS alt_1, t0.width AS width_2, t0.height AS height_3, t0.hash AS hash_4, t0.needProcess AS needProcess_5, t0.id AS id_6, t0.path AS path_7, t0.fileName AS fileName_8, t0.mime AS mime_9, t0.storageType AS storageType_10, t0.size AS size_11, t0.date AS date_12, t0.category_id AS category_id_13 FROM xc_category_banners t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.sticker_id AS sticker_id_1, t0.position AS position_2, t0.enabled AS enabled_3, t0.text_color AS text_color_4, t0.bg_color AS bg_color_5, t0.isLabel AS isLabel_6 FROM xc_product_stickers t0 INNER JOIN xc_product_stickers_links ON t0.sticker_id = xc_product_stickers_links.sticker_id WHERE xc_product_stickers_links.product_id = ?"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.sticker_id AS sticker_id_1, t0.position AS position_2, t0.enabled AS enabled_3, t0.text_color AS text_color_4, t0.bg_color AS bg_color_5, t0.isLabel AS isLabel_6 FROM xc_product_stickers t0 INNER JOIN xc_category_stickers_links ON t0.sticker_id = xc_category_stickers_links.sticker_id WHERE xc_category_stickers_links.category_id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_select x1_ LEFT JOIN xc_attribute_values_select_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_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"
  "params" => [
    1 => "en"
    2 => 43
    3 => "P"
    4 => null
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_text x1_ LEFT JOIN xc_attribute_values_text_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_attributes x0_ ON x1_.attribute_id = x0_.id WHERE (x1_.product_id = ? AND x1_.editable = ?) AND (x0_.product_class_id IS NULL OR x0_.product_class_id = ?) GROUP BY x0_.id ORDER BY x0_.position ASC"
  "params" => [
    1 => "en"
    2 => 43
    3 => 1
    4 => null
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 5
    4 => 2
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_checkbox x1_ LEFT JOIN xc_attribute_values_checkbox_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_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"
  "params" => [
    1 => "en"
    2 => 43
    3 => "P"
    4 => null
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT t0.show_selector AS show_selector_1, t0.show_on_list AS show_on_list_2, t0.googleShoppingGroup AS googleShoppingGroup_3, t0.id AS id_4, t0.position AS position_5, t0.displayAbove AS displayAbove_6, t0.decimals AS decimals_7, t0.type AS type_8, t0.displayMode AS displayMode_9, t0.addToNew AS addToNew_10, t0.product_class_id AS product_class_id_11, t0.attribute_group_id AS attribute_group_id_12, t0.product_id AS product_id_13 FROM xc_attributes t0 INNER JOIN xc_product_variants_attributes ON t0.id = xc_product_variants_attributes.attribute_id WHERE xc_product_variants_attributes.product_id = ?"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(x0_.category_id) AS sclr_0 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 INNER JOIN xc_category_products x4_ ON x0_.category_id = x4_.category_id WHERE x0_.enabled = ? AND x2_.membership_id IS NULL AND x0_.category_id <> ? AND x0_.category_id = ? AND x4_.product_id = ? ORDER BY x0_.pos ASC, x0_.category_id ASC LIMIT 1"
  "params" => [
    1 => "en"
    2 => 1
    3 => 1
    4 => 8
    5 => 43
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
    5 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "en"
    2 => 1
    3 => 1
    4 => 1
    5 => 13
    6 => 14
    7 => 24
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.show_selector AS show_selector_1, t0.show_on_list AS show_on_list_2, t0.googleShoppingGroup AS googleShoppingGroup_3, t0.id AS id_4, t0.position AS position_5, t0.displayAbove AS displayAbove_6, t0.decimals AS decimals_7, t0.type AS type_8, t0.displayMode AS displayMode_9, t0.addToNew AS addToNew_10, t0.product_class_id AS product_class_id_11, t0.attribute_group_id AS attribute_group_id_12, t0.product_id AS product_id_13 FROM xc_attributes t0 WHERE t0.id = ?"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT AVG(x0_.rating) AS sclr_0 FROM xc_reviews x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = ? AND x0_.status = ? LIMIT 1"
  "params" => [
    1 => 43
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT x0_.id) AS sclr_0 FROM xc_reviews x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = ? AND x0_.status = ? AND x0_.review <> ?"
  "params" => [
    1 => 43
    2 => 1
    3 => ""
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "SELECT COUNT(x0_.category_id) AS sclr_0 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 INNER JOIN xc_category_products x4_ ON x0_.category_id = x4_.category_id WHERE x0_.enabled = ? AND x2_.membership_id IS NULL AND x0_.category_id <> ? AND x0_.category_id = ? AND x4_.product_id = ? ORDER BY x0_.pos ASC, x0_.category_id ASC LIMIT 1"
  "params" => [
    1 => "en"
    2 => 1
    3 => 1
    4 => 8
    5 => 43
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
    5 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "en"
    2 => 1
    3 => 1
    4 => 1
    5 => 13
    6 => 14
    7 => 24
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT x0_.id) AS sclr_0 FROM xc_reviews x0_ INNER JOIN xc_products x1_ ON x0_.product_id = x1_.product_id WHERE x1_.product_id = ? AND x0_.status = ?"
  "params" => [
    1 => 43
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.orderby AS orderby_1, t0.alt AS alt_2, t0.width AS width_3, t0.height AS height_4, t0.hash AS hash_5, t0.needProcess AS needProcess_6, t0.id AS id_7, t0.path AS path_8, t0.fileName AS fileName_9, t0.mime AS mime_10, t0.storageType AS storageType_11, t0.size AS size_12, t0.date AS date_13, t0.product_id AS product_id_14 FROM xc_product_images t0 WHERE t0.product_id = ? ORDER BY t0.orderby ASC"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.ogMeta AS ogMeta_1, t0.backorderQtyLabel AS backorderQtyLabel_2, t0.name AS name_3, t0.description AS description_4, t0.briefDescription AS briefDescription_5, t0.metaTags AS metaTags_6, t0.metaDesc AS metaDesc_7, t0.metaTitle AS metaTitle_8, t0.label_id AS label_id_9, t0.code AS code_10, t0.id AS id_11 FROM xc_product_translations t0 WHERE t0.id = ?"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "en"
    2 => 1
    3 => 1
    4 => 1
    5 => 13
    6 => 14
    7 => 24
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "SELECT t0.sticker_id AS sticker_id_1, t0.position AS position_2, t0.enabled AS enabled_3, t0.text_color AS text_color_4, t0.bg_color AS bg_color_5, t0.isLabel AS isLabel_6 FROM xc_product_stickers t0 INNER JOIN xc_product_stickers_links ON t0.sticker_id = xc_product_stickers_links.sticker_id WHERE xc_product_stickers_links.product_id = ?"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_select x1_ LEFT JOIN xc_attribute_values_select_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_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"
  "params" => [
    1 => "en"
    2 => 42
    3 => "P"
    4 => null
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_text x1_ LEFT JOIN xc_attribute_values_text_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_attributes x0_ ON x1_.attribute_id = x0_.id WHERE (x1_.product_id = ? AND x1_.editable = ?) AND (x0_.product_class_id IS NULL OR x0_.product_class_id = ?) GROUP BY x0_.id ORDER BY x0_.position ASC"
  "params" => [
    1 => "en"
    2 => 42
    3 => 1
    4 => null
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 5
    4 => 2
  ]
]

[
  "sql" => "SELECT x0_.id AS id_0, COUNT(x0_.id) AS sclr_1 FROM xc_attribute_values_checkbox x1_ LEFT JOIN xc_attribute_values_checkbox_translations x2_ ON x1_.id = x2_.id AND (x2_.code = ?) INNER JOIN xc_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"
  "params" => [
    1 => "en"
    2 => 42
    3 => "P"
    4 => null
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT t0.show_selector AS show_selector_1, t0.show_on_list AS show_on_list_2, t0.googleShoppingGroup AS googleShoppingGroup_3, t0.id AS id_4, t0.position AS position_5, t0.displayAbove AS displayAbove_6, t0.decimals AS decimals_7, t0.type AS type_8, t0.displayMode AS displayMode_9, t0.addToNew AS addToNew_10, t0.product_class_id AS product_class_id_11, t0.attribute_group_id AS attribute_group_id_12, t0.product_id AS product_id_13 FROM xc_attributes t0 INNER JOIN xc_product_variants_attributes ON t0.id = xc_product_variants_attributes.attribute_id WHERE xc_product_variants_attributes.product_id = ?"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(x0_.category_id) AS sclr_0 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 INNER JOIN xc_category_products x4_ ON x0_.category_id = x4_.category_id WHERE x0_.enabled = ? AND x2_.membership_id IS NULL AND x0_.category_id <> ? AND x0_.category_id = ? AND x4_.product_id = ? ORDER BY x0_.pos ASC, x0_.category_id ASC LIMIT 1"
  "params" => [
    1 => "en"
    2 => 1
    3 => 1
    4 => 8
    5 => 42
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
    5 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "en"
    2 => 1
    3 => 1
    4 => 1
    5 => 13
    6 => 14
    7 => 24
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "SELECT t0.show_selector AS show_selector_1, t0.show_on_list AS show_on_list_2, t0.googleShoppingGroup AS googleShoppingGroup_3, t0.id AS id_4, t0.position AS position_5, t0.displayAbove AS displayAbove_6, t0.decimals AS decimals_7, t0.type AS type_8, t0.displayMode AS displayMode_9, t0.addToNew AS addToNew_10, t0.product_class_id AS product_class_id_11, t0.attribute_group_id AS attribute_group_id_12, t0.product_id AS product_id_13 FROM xc_attributes t0 WHERE t0.id = ?"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 1
  ]
]