Symfony Profiler

SELECT
  `product`.`id` as `product.id`,
  `product`.`version_id` as `product.versionId`,
  `product`.`parent_id` as `product.parentId`,
  `product`.`parent_version_id` as `product.parentVersionId`,
  COALESCE(
    `product`.`product_manufacturer_id`,
    `product.parent`.`product_manufacturer_id`
  ) as `product.manufacturerId`,
  COALESCE(
    `product`.`product_manufacturer_version_id`,
    `product.parent`.`product_manufacturer_version_id`
  ) as `product.productManufacturerVersionId`,
  COALESCE(
    `product`.`unit_id`, `product.parent`.`unit_id`
  ) as `product.unitId`,
  COALESCE(
    `product`.`tax_id`, `product.parent`.`tax_id`
  ) as `product.taxId`,
  COALESCE(
    `product`.`product_media_id`, `product.parent`.`product_media_id`
  ) as `product.coverId`,
  COALESCE(
    `product`.`product_media_version_id`,
    `product.parent`.`product_media_version_id`
  ) as `product.productMediaVersionId`,
  COALESCE(
    `product`.`delivery_time_id`, `product.parent`.`delivery_time_id`
  ) as `product.deliveryTimeId`,
  COALESCE(
    `product`.`product_feature_set_id`,
    `product.parent`.`product_feature_set_id`
  ) as `product.featureSetId`,
  COALESCE(
    `product`.`canonical_product_id`,
    `product.parent`.`canonical_product_id`
  ) as `product.canonicalProductId`,
  COALESCE(
    `product`.`canonical_product_version_id`,
    `product.parent`.`canonical_product_version_id`
  ) as `product.canonicalProductVersionId`,
  COALESCE(
    `product`.`cms_page_id`, `product.parent`.`cms_page_id`
  ) as `product.cmsPageId`,
  COALESCE(
    `product`.`cms_page_version_id`,
    `product.parent`.`cms_page_version_id`
  ) as `product.cmsPageVersionId`,
  `product.parent`.`price` as `product.price.inherited`,
  COALESCE(
    `product`.`price`, `product.parent`.`price`
  ) as `product.price`,
  `product`.`product_number` as `product.productNumber`,
  COALESCE(
    `product`.`restock_time`, `product.parent`.`restock_time`
  ) as `product.restockTime`,
  `product`.`auto_increment` as `product.autoIncrement`,
  COALESCE(
    `product`.`active`, `product.parent`.`active`
  ) as `product.active`,
  `product`.`available` as `product.available`,
  COALESCE(
    `product`.`is_closeout`, `product.parent`.`is_closeout`
  ) as `product.isCloseout`,
  `product`.`available_stock` as `product.availableStock`,
  `product`.`stock` as `product.stock`,
  `product`.`display_group` as `product.displayGroup`,
  `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`,
  COALESCE(
    `product`.`variant_listing_config`,
    `product.parent`.`variant_listing_config`
  ) as `product.variantListingConfig`,
  `product`.`variant_restrictions` as `product.variantRestrictions`,
  COALESCE(
    `product`.`manufacturer_number`,
    `product.parent`.`manufacturer_number`
  ) as `product.manufacturerNumber`,
  COALESCE(
    `product`.`ean`, `product.parent`.`ean`
  ) as `product.ean`,
  COALESCE(
    `product`.`purchase_steps`, `product.parent`.`purchase_steps`
  ) as `product.purchaseSteps`,
  COALESCE(
    `product`.`max_purchase`, `product.parent`.`max_purchase`
  ) as `product.maxPurchase`,
  COALESCE(
    `product`.`min_purchase`, `product.parent`.`min_purchase`
  ) as `product.minPurchase`,
  COALESCE(
    `product`.`purchase_unit`, `product.parent`.`purchase_unit`
  ) as `product.purchaseUnit`,
  COALESCE(
    `product`.`reference_unit`, `product.parent`.`reference_unit`
  ) as `product.referenceUnit`,
  COALESCE(
    `product`.`shipping_free`, `product.parent`.`shipping_free`
  ) as `product.shippingFree`,
  `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`,
  COALESCE(
    `product`.`purchase_prices`, `product.parent`.`purchase_prices`
  ) as `product.purchasePrices`,
  COALESCE(
    `product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`
  ) as `product.markAsTopseller`,
  COALESCE(
    `product`.`weight`, `product.parent`.`weight`
  ) as `product.weight`,
  COALESCE(
    `product`.`width`, `product.parent`.`width`
  ) as `product.width`,
  COALESCE(
    `product`.`height`, `product.parent`.`height`
  ) as `product.height`,
  COALESCE(
    `product`.`length`, `product.parent`.`length`
  ) as `product.length`,
  COALESCE(
    `product`.`release_date`, `product.parent`.`release_date`
  ) as `product.releaseDate`,
  COALESCE(
    `product`.`rating_average`, `product.parent`.`rating_average`
  ) as `product.ratingAverage`,
  `product.parent`.`category_tree` as `product.categoryTree.inherited`,
  COALESCE(
    `product`.`category_tree`, `product.parent`.`category_tree`
  ) as `product.categoryTree`,
  `product.parent`.`property_ids` as `product.propertyIds.inherited`,
  COALESCE(
    `product`.`property_ids`, `product.parent`.`property_ids`
  ) as `product.propertyIds`,
  `product.parent`.`option_ids` as `product.optionIds.inherited`,
  COALESCE(
    `product`.`option_ids`, `product.parent`.`option_ids`
  ) as `product.optionIds`,
  `product.parent`.`stream_ids` as `product.streamIds.inherited`,
  COALESCE(
    `product`.`stream_ids`, `product.parent`.`stream_ids`
  ) as `product.streamIds`,
  `product.parent`.`tag_ids` as `product.tagIds.inherited`,
  COALESCE(
    `product`.`tag_ids`, `product.parent`.`tag_ids`
  ) as `product.tagIds`,
  `product.parent`.`category_ids` as `product.categoryIds.inherited`,
  COALESCE(
    `product`.`category_ids`, `product.parent`.`category_ids`
  ) as `product.categoryIds`,
  `product`.`child_count` as `product.childCount`,
  COALESCE(
    `product`.`custom_field_set_selection_active`,
    `product.parent`.`custom_field_set_selection_active`
  ) as `product.customFieldSetSelectionActive`,
  `product`.`sales` as `product.sales`,
  `product`.`states` as `product.states`,
  `product.tax`.`id` as `product.tax.id`,
  `product.tax`.`tax_rate` as `product.tax.taxRate`,
  `product.tax`.`name` as `product.tax.name`,
  `product.tax`.`position` as `product.tax.position`,
  `product.tax`.`custom_fields` as `product.tax.customFields`,
  `product.tax`.`created_at` as `product.tax.createdAt`,
  `product.tax`.`updated_at` as `product.tax.updatedAt`,
  `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`,
  COALESCE(
    `product`.`cheapest_price`, `product.parent`.`cheapest_price`
  ) as `product.cheapestPrice`,
  `product`.`created_at` as `product.createdAt`,
  `product`.`updated_at` as `product.updatedAt`,
  (
    SELECT
      GROUP_CONCAT(
        HEX(
          `product.options.mapping`.`property_group_option_id`
        ) SEPARATOR '||'
      )
    FROM
      `product_option` `product.options.mapping`
    WHERE
      `product.options.mapping`.`product_id` = `product`.`id`
  ) as `product.options.id_mapping`,
  `product.unit`.`id` as `product.unit.id`,
  `product.unit`.`created_at` as `product.unit.createdAt`,
  `product.unit`.`updated_at` as `product.unit.updatedAt`,
  `product.unit.translation.shortCode`,
  `product.unit.translation.shortCode` as `product.unit.shortCode`,
  `product.unit.translation.name`,
  `product.unit.translation.name` as `product.unit.name`,
  `product.unit.translation.customFields`,
  `product.unit.translation.customFields` as `product.unit.customFields`,
  `product.deliveryTime`.`id` as `product.deliveryTime.id`,
  `product.deliveryTime`.`min` as `product.deliveryTime.min`,
  `product.deliveryTime`.`max` as `product.deliveryTime.max`,
  `product.deliveryTime`.`unit` as `product.deliveryTime.unit`,
  `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`,
  `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`,
  `product.deliveryTime.translation.name`,
  `product.deliveryTime.translation.name` as `product.deliveryTime.name`,
  `product.deliveryTime.translation.customFields`,
  `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`,
  `product.cover`.`id` as `product.cover.id`,
  `product.cover`.`version_id` as `product.cover.versionId`,
  `product.cover`.`product_id` as `product.cover.productId`,
  `product.cover`.`product_version_id` as `product.cover.productVersionId`,
  `product.cover`.`media_id` as `product.cover.mediaId`,
  `product.cover`.`position` as `product.cover.position`,
  `product.cover.media`.`id` as `product.cover.media.id`,
  `product.cover.media`.`user_id` as `product.cover.media.userId`,
  `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`,
  `product.cover.media`.`mime_type` as `product.cover.media.mimeType`,
  `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`,
  `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`,
  `product.cover.media`.`file_name` as `product.cover.media.fileName`,
  `product.cover.media`.`file_size` as `product.cover.media.fileSize`,
  `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`,
  `product.cover.media`.`meta_data` as `product.cover.media.metaData`,
  `product.cover.media`.`config` as `product.cover.media.config`,
  `product.cover.media`.`path` as `product.cover.media.path`,
  `product.cover.media`.`private` as `product.cover.media.private`,
  `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`,
  `product.cover.media`.`created_at` as `product.cover.media.createdAt`,
  `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`,
  `product.cover.media.translation.title`,
  `product.cover.media.translation.title` as `product.cover.media.title`,
  `product.cover.media.translation.alt`,
  `product.cover.media.translation.alt` as `product.cover.media.alt`,
  `product.cover.media.translation.customFields`,
  `product.cover.media.translation.customFields` as `product.cover.media.customFields`,
  `product.cover`.`custom_fields` as `product.cover.customFields`,
  `product.cover`.`created_at` as `product.cover.createdAt`,
  `product.cover`.`updated_at` as `product.cover.updatedAt`,
  `product.translation.metaDescription`,
  `product.parent.translation.metaDescription`,
  COALESCE(
    `product.translation.metaDescription`,
    `product.parent.translation.metaDescription`
  ) as `product.metaDescription`,
  `product.translation.name`,
  `product.parent.translation.name`,
  COALESCE(
    `product.translation.name`, `product.parent.translation.name`
  ) as `product.name`,
  `product.translation.keywords`,
  `product.parent.translation.keywords`,
  COALESCE(
    `product.translation.keywords`,
    `product.parent.translation.keywords`
  ) as `product.keywords`,
  `product.translation.description`,
  `product.parent.translation.description`,
  COALESCE(
    `product.translation.description`,
    `product.parent.translation.description`
  ) as `product.description`,
  `product.translation.metaTitle`,
  `product.parent.translation.metaTitle`,
  COALESCE(
    `product.translation.metaTitle`,
    `product.parent.translation.metaTitle`
  ) as `product.metaTitle`,
  `product.translation.packUnit`,
  `product.parent.translation.packUnit`,
  COALESCE(
    `product.translation.packUnit`,
    `product.parent.translation.packUnit`
  ) as `product.packUnit`,
  `product.translation.packUnitPlural`,
  `product.parent.translation.packUnitPlural`,
  COALESCE(
    `product.translation.packUnitPlural`,
    `product.parent.translation.packUnitPlural`
  ) as `product.packUnitPlural`,
  `product.translation.customSearchKeywords`,
  `product.parent.translation.customSearchKeywords`,
  COALESCE(
    `product.translation.customSearchKeywords`,
    `product.parent.translation.customSearchKeywords`
  ) as `product.customSearchKeywords`,
  `product.translation.slotConfig`,
  `product.parent.translation.slotConfig`,
  COALESCE(
    `product.translation.slotConfig`,
    `product.parent.translation.slotConfig`
  ) as `product.slotConfig`,
  `product.translation.customFields`,
  `product.parent.translation.customFields`,
  COALESCE(
    `product.translation.customFields`,
    `product.parent.translation.customFields`
  ) as `product.customFields`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id`
  LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id`
  LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id`
  LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id`
  AND IFNULL(
    `product`.`product_media_version_id`,
    `product.parent`.`product_media_version_id`
  ) = `product.cover`.`version_id`
  LEFT JOIN (
    SELECT
      `product.translation`.`product_id`,
      `product.translation`.`product_version_id`,
      `product.translation`.`meta_description` as `product.translation.metaDescription`,
      `product.translation`.`name` as `product.translation.name`,
      `product.translation`.`keywords` as `product.translation.keywords`,
      `product.translation`.`description` as `product.translation.description`,
      `product.translation`.`meta_title` as `product.translation.metaTitle`,
      `product.translation`.`pack_unit` as `product.translation.packUnit`,
      `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`,
      `product.translation`.`custom_fields` as `product.translation.customFields`,
      `product.translation`.`slot_config` as `product.translation.slotConfig`,
      `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`
    FROM
      `product_translation` `product.translation`
    WHERE
      `product.translation`.`language_id` = ?
  ) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id`
  AND `product.product_translation`.`product_version_id` = `product`.`version_id`
  LEFT JOIN (
    SELECT
      `product.parent.translation`.`product_id`,
      `product.parent.translation`.`product_version_id`,
      `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`,
      `product.parent.translation`.`name` as `product.parent.translation.name`,
      `product.parent.translation`.`keywords` as `product.parent.translation.keywords`,
      `product.parent.translation`.`description` as `product.parent.translation.description`,
      `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`,
      `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`,
      `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`,
      `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`,
      `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`,
      `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords`
    FROM
      `product_translation` `product.parent.translation`
    WHERE
      `product.parent.translation`.`language_id` = ?
  ) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id`
  AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id`
  LEFT JOIN (
    SELECT
      `product.unit.translation`.`unit_id`,
      `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`,
      `product.unit.translation`.`name` as `product.unit.translation.name`,
      `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields`
    FROM
      `unit_translation` `product.unit.translation`
    WHERE
      `product.unit.translation`.`language_id` = ?
  ) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id`
  LEFT JOIN (
    SELECT
      `product.deliveryTime.translation`.`delivery_time_id`,
      `product.deliveryTime.translation`.`name` as `product.deliveryTime.translation.name`,
      `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields`
    FROM
      `delivery_time_translation` `product.deliveryTime.translation`
    WHERE
      `product.deliveryTime.translation`.`language_id` = ?
  ) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id`
  LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id`
  LEFT JOIN (
    SELECT
      `product.cover.media.translation`.`media_id`,
      `product.cover.media.translation`.`alt` as `product.cover.media.translation.alt`,
      `product.cover.media.translation`.`title` as `product.cover.media.translation.title`,
      `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields`
    FROM
      `media_translation` `product.cover.media.translation`
    WHERE
      `product.cover.media.translation`.`language_id` = ?
  ) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    `product`.`id` IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?
    )
  )

SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, `product.unit.translation.shortCode` as `product.unit.shortCode`, `product.unit.translation.name`, `product.unit.translation.name` as `product.unit.name`, `product.unit.translation.customFields`, `product.unit.translation.customFields` as `product.unit.customFields`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, `product.deliveryTime.translation.name` as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, `product.cover.media.translation.title` as `product.cover.media.title`, `product.cover.media.translation.alt`, `product.cover.media.translation.alt` as `product.cover.media.alt`, `product.cover.media.translation.customFields`, `product.cover.media.translation.customFields` as `product.cover.media.customFields`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.`delivery_time_id`, `product.deliveryTime.translation`.`name` as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.`media_id`, `product.cover.media.translation`.`alt` as `product.cover.media.translation.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product`.`id` IN (0x018E1DD869757068947CD286CFC58E2E, 0x018E1DCD667B705489323C12D728FFA7, 0x018E1DC221047221AB822C5C3050AAB7, 0x018FA463770273D8BA72E71A0F874A82, 0x018E1DDD804A724890BF549381D3A890, 0x018FA452E19C70D096429BAA724C84E4, 0x018FA471376971EEAC6A6F68B358AC5A, 0x018FA48F42DA7354AC2BD5B9EA706583, 0x018FA4A44B5C73BE8E210A72B17AB4D9, 0x018FA4F851687167977B480512D8F69A, 0x018FA51CF8B37033847A46EBED7F9A5E, 0x018FA51FE0EA71AEBFB5006A1D46FEBB, 0x018E1DE6B35A72F5A3C70EED60BEB373, 0x018E1DEF53E773F7AF9C82CC86F44A6B, 0x018E1DF5EA447324913DC176B6C3CD17, 0x018FF1E4A3ED739EA57DC94B63F3940D, 0x019078DABFE37385956D7C74C75AE23F, 0x019078EFD1657339AEDAC63BBC726E76, 0x01907CBA274A71A39C8DFB0BF8DA303F, 0x01907CBB2F2E7130806EED1C7554FCB3, 0x01907CBB829572ABB3DDE0F8B143270E, 0x01907CBBD7D671EE9D4BC5A1EAF7273F, 0x0191B7678777721CA905B9F21F105995, 0x0191B774B6B773D1B4AFEF8346E4480F, 0x0191B77AECFF722DB4561733E293D244, 0x019242C32A2470039C205036DC304A25, 0x019242D9B71F716AA661D51812C310D5, 0x019266D4A442703B8BB034D27C091FC7, 0x0192BE281EC17008BDEA0C832CDE1F0F, 0x0192BE2F43F672F0AC9C71B3F5D99E83, 0x0192BE3325637253B483853F32B916E4, 0x0192BE34C18C7007BCE92DC22EAFD2CD, 0x0192BE365426727EA943D2F40ACA9F2D, 0x0192BE3AC749716CA6DC018481EDBBA2, 0x0192BE3F43DF70D5B2540B15202FC327, 0x0192BE422DC470A0945998D237899BB4, 0x0192BE452FE572BEA5E8B7300DE8EF0D, 0x0192BE46FB5471AF8A26CCFD10DC326D, 0x0192BE488F187349A02BEAACDD7F40B1, 0x0192BE4A2C437314ABE7D7DA43768DA9, 0x0192BE4BF4987295BC0E5B47B29E0828, 0x0192BE4E67A073FFBA2F616B8C098CD0, 0x0192BE5099BE73CDAC2D02B01BC50DA8, 0x0192BE52474A714CB9CAB5DD752EBCFE, 0x0192BE53C17E71E8B9B8A76A07106EF6, 0x0192BE55B8D570B18ECDBBAA553FAF94, 0x0192BE57BB37732EBDC1451E0EABB96C, 0x0192BE5A50FC704398007C34D438B051, 0x0192BE5BDA2671029C7518D5BCBC5A65, 0x0192BE5E164B72E7B8E127C08EBC28DD, 0x0192BE5FA5E07137A73DDBDB91013919, 0x0192BE618D84722F910845F7FCE308F8, 0x0192BE63588E73C5A8D71DAA70C9B71C, 0x0192BE63A78A73E89D8C98EE1C350A4F, 0x0192BE6859BE73A2B65B959D13F7DA64, 0x0192BE69DE5973DCBBFC875780BE23D6, 0x0192BE6CD17970249592ECDC0581D195, 0x0192BE6E8641703AAAA13C234E1A6523, 0x0192BE71794B73E89BC73EBD8EF57060, 0x0192BE7366D27265AE4703DB9D08488B, 0x0192BE751B7C73F3B552CF544AA4C6A0, 0x0192BE76764570B9B4FB28EDED7381BF, 0x0192BE780908733FA035B6AF123A3774, 0x0192BE79A16B7358A11F5AA31AC3CC21, 0x0192BE7B683773A2A04CF6A68D28E0CD, 0x0192BE7DE574704584AB1270C189329E, 0x0192BE7FFB7673ABAFF78D18DCA0AEBE, 0x0192BE94A7C3716FA3FFE43D223C20FC, 0x0192BE968A57712B96CA50F7639238EB, 0x0192BE980B4773CD9968DF95759B6C03, 0x0192BE99E47870C097A34190EC41B3CD, 0x0192BE9CE93671E4800AE90E7423BAE0, 0x0192BE9E367B713190DB570AC3BB54DC, 0x0192BEA008F37281BCE8769716FBFD6C, 0x0192BEA44D60714FB091B69D4FAFA317, 0x0192BEA51C44732FB213DA80AA222E13, 0x0192BEA5E78971E1975A91D7C067B36A, 0x0192BEA698C17169B7E613C875136880, 0x0192BEA75CE8707F91418418947409A2, 0x0192BEA81EAE70BFA067403CD600E04A, 0x0192BEA8C87C7209BEF77DC9FA3F4F3C, 0x0192BEA9B1B173C98A81B4FF100ABEC0, 0x0192BEAA60F67263B1D8E809D6F941A2, 0x0192BEAB2054734B91AE5808ADE5163D, 0x0192BEABD3507351835526B8326708FC, 0x0192BEAC9352714E899D0729324F2127, 0x0192BEAD4F94716D970A7186C5CEE0CF, 0x0192BEAE16EA7237A4B63E646EEC3EB7, 0x0192BEAECD7073CA995E998406883367, 0x0192BEAF8E0A71C5856CB78700A10920, 0x0192BEB035C9700B96FD8914E859FADD, 0x0192BEB0D6827292BE5C2203C8E6696A, 0x0192BEB1709F7041A09DCFCD6C30F604, 0x0192BEB21C9C70FAAB88871CFA93CAE1, 0x0192BEB2CE2D73D1B6719E83BDDD34C9, 0x0192D8A490F372CB8C8F4B0430B16B31, 0x0193D4DEDC9B704A817FDD0D1DDD3FBF, 0x0193D4E486E172E8B7D2575301B4932B, 0x0193D4E719D373DFBAC8553FAB5DD036, 0x0193DA27FC057182B1B7EAEB5FCD4FD9, 0x0194652B1F4672E9ABA689F2A0A3E98B, 0x019465343DE07239886FA2F378198BB5, 0x01946539FFF970CEB3F9F84E553BDDF4, 0x0194653FF6F0725CBF3484EBC5C3BC41, 0x019465457F3970828C332259F1329F01, 0x0194654C94A57216A88D5289B17FFD19, 0x01946551702C70C39321895D19ECBAD1, 0x0194655604FA7056B8F672B03A764B52, 0x019469B0D3F97232B587CDB898D2BD03, 0x019469B7B0E671EEB66458DE8F3628CE, 0x019469BCC0F37101A6ABB1A6301B826A, 0x019469C0339070C7B4B55473F47760C3, 0x019469C3ABF171E2BD378C190BAC18EF, 0x019469C76F417116A055DEA5ECAD3E70, 0x019469C9ECEC7172A7C391A00EBEE712, 0x019469CE7FB972EF9736A6F17D2E6FB9, 0x019469D396707390B3E7EB3DF87F1DD5, 0x019469D7564372608FBFA6BFD982CF1B, 0x019469DA9A6673E1852E6F3891CE05E2, 0x019469DD0C2970519BA2312AB5C1631E, 0x019469E1A56A723FB0CCAB31452D922B, 0x019469E46FA170BA9D2E2C9CA1B1CE1B, 0x019469E6D4607281A1637C44740F69E7, 0x019469E9676373E4BDA4A192C389C607, 0x018E1DFBEF1071778E71C4A58FEA9A45));

# seo_url::replacement
SELECT
  seo_path_info,
  path_info,
  sales_channel_id
FROM
  seo_url
WHERE
  (seo_url.is_canonical = 1)
  AND (
    seo_url.path_info IN (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
  )
  AND (seo_url.language_id = ?)
  AND (
    seo_url.sales_channel_id = ?
    OR seo_url.sales_channel_id IS NULL
  )
  AND (seo_url.is_deleted = 0)

# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN ('/detail/018e1e00bb18719f8b0a693152276675', '/navigation/018a8e05871277b3a98578efc759b2ae', '/navigation/018b0514daa07661a240c4784f1607fb', '/navigation/7a87c3a0613e473aa36bc385ecc48ba5', '/navigation/de55ac55c8744b3ba91b40943e39df3c', '/navigation/4d22bc54ff254743b336c146b3123ccc', '/navigation/018bfb93368a704e8af377e7aee49656', '/navigation/018eeb03f4c578b99eb910e577d32e50', '/navigation/00e4c01624c947fc844677be6041823b', '/navigation/0c5b4ddfaf954f009425d95b676966c4', '/navigation/f97a7bd4acb04faeba5a712260189f31', '/navigation/b402cab0b2c14e149544f53befcfed9f', '/navigation/2321866ea02f445f8fe99ab86154ab39', '/navigation/523e1fc48edb4fa49f4646cbdfc363f3', '/navigation/480c057d500b42bb93f2637f023ab85e', '/navigation/54e6efb5b26f4b7a9820940f4ec66b23', '/navigation/9f2d5ccf1e1b4e5a936541e0075c042b', '/navigation/018a466213977684a147cad54481e914', '/navigation/018b27df7b6b779b945a4d9f32a586ed', '/navigation/018bb31e02ff7f75813589fcc073faab', '/navigation/018c5d3a0dd37a90ae96d8f612981f17', '/navigation/018de54cf1e37130a702d8f14411136f', '/navigation/018fa009510f7950bc30514f13f17150', '/navigation/01900b15d11376e0975bf5b0c59759e2', '/navigation/1be10bc161df4d8fb4b2d7d794d7d70b', '/navigation/0192c3a069f579aa843a9cf369328e13', '/navigation/8aac33a98cd2432e8e5bc815ea190b8c', '/navigation/1de51695f23c4c4cb18945804a6be7c9', '/navigation/dc894dac99af4299814040fdf7f8f8de', '/navigation/5b93b0d06b634346af8bbd4a86478f0f', '/navigation/b819de59af684d9c97629478c63c43f0', '/navigation/018c19eefe757082a2b5543639d38b94', '/navigation/b9c63eb740be4bc4806693973a0417a5', '/navigation/99ec5149ab9e4588bdd9b8c93f7757f7', '/navigation/cf56d9e7a1d740569f14aa63a194d160', '/navigation/93f676700eed4a489d7ed42dc728f2e0', '/navigation/018b03e09e4871b29a575f75dbc07380', '/navigation/b3e8b65b967f4cd5a876a323039ebf6d', '/navigation/294ff0a0d4684cdb8a7afb02bf601d5d', '/navigation/47a458bf51fb4c21a9b0e361ee2fccad', '/navigation/b689a161eb1841c28b82f64d1acf2322', '/navigation/f479edb2a8754436893e6f9495ad5eae', '/navigation/018bc7ae2c9a7209b27a5ce880f4e621', '/navigation/f1243af5c0ae4a548d85a8e9944de228', '/navigation/0cf9d7e6a92343feaf2143d68e4fa2f3', '/navigation/018b23b3be28720881be1be7d85aaf22', '/navigation/018c90807d7a7ee4a491f8e0922bfd68', '/navigation/018dc68486f974c0823096bcc9863fc1', '/navigation/018de54c816376b194f2233fc6dfce7e', '/navigation/59209182e0c94b91b420c670c4662d14', '/navigation/5c3bc1e7533b47ca93637a785d855444', '/navigation/b2a3dd3856c348a099065eae1aaf3bca', '/navigation/4c41b51b942c4844998aee954bbeae8b', '/navigation/f34bfee8839e418abc3529e5f5153312', '/navigation/898edb7ebeae4ad8ad662ae3c33f7864', '/navigation/0504d971c57f4831b805453304d92dba', '/navigation/3b5cc999670243b29c2803580a42b805', '/navigation/018e13080490792fb97c0872296cc5a5', '/navigation/018f5742b7be786da8ed9d1c12ab3254', '/navigation/018f61629cbb70d0aa40be7a29061ca9', '/navigation/4f8cbc189ffc451b83501f047cd03b87', '/navigation/e11deed955854b88bb433f3960039144', '/navigation/a40362dba93a4cf08738785207dc712e', '/navigation/383ac47a208b4902995ac1d8501a6508', '/navigation/804520db365f4281ad819ab97670a467', '/navigation/f8198bf6f56542208e1e5d633f176bf8', '/navigation/018bfb951ffb74ee887375f65eeab002', '/navigation/018bfb9538e871bd86a4533b16a9642e', '/detail/018e1dd869757068947cd286cfc58e2e', '/detail/018e1dcd667b705489323c12d728ffa7', '/detail/018e1dc221047221ab822c5c3050aab7', '/detail/018fa463770273d8ba72e71a0f874a82', '/detail/018e1ddd804a724890bf549381d3a890', '/detail/018fa452e19c70d096429baa724c84e4', '/detail/018fa471376971eeac6a6f68b358ac5a', '/detail/018fa48f42da7354ac2bd5b9ea706583', '/detail/018fa4a44b5c73be8e210a72b17ab4d9', '/detail/018fa4f851687167977b480512d8f69a', '/detail/018fa51cf8b37033847a46ebed7f9a5e', '/detail/018fa51fe0ea71aebfb5006a1d46febb', '/detail/018e1de6b35a72f5a3c70eed60beb373', '/detail/018e1def53e773f7af9c82cc86f44a6b', '/detail/018e1df5ea447324913dc176b6c3cd17', '/detail/018ff1e4a3ed739ea57dc94b63f3940d', '/detail/019078dabfe37385956d7c74c75ae23f', '/detail/019078efd1657339aedac63bbc726e76', '/detail/01907cba274a71a39c8dfb0bf8da303f', '/detail/01907cbb2f2e7130806eed1c7554fcb3', '/detail/01907cbb829572abb3dde0f8b143270e', '/detail/01907cbbd7d671ee9d4bc5a1eaf7273f', '/detail/0191b7678777721ca905b9f21f105995', '/detail/0191b774b6b773d1b4afef8346e4480f', '/detail/0191b77aecff722db4561733e293d244', '/detail/019242c32a2470039c205036dc304a25', '/detail/019242d9b71f716aa661d51812c310d5', '/detail/019266d4a442703b8bb034d27c091fc7', '/detail/0192be281ec17008bdea0c832cde1f0f', '/detail/0192be2f43f672f0ac9c71b3f5d99e83', '/detail/0192be3325637253b483853f32b916e4', '/detail/0192be34c18c7007bce92dc22eafd2cd', '/detail/0192be365426727ea943d2f40aca9f2d', '/detail/0192be3ac749716ca6dc018481edbba2', '/detail/0192be3f43df70d5b2540b15202fc327', '/detail/0192be422dc470a0945998d237899bb4', '/detail/0192be452fe572bea5e8b7300de8ef0d', '/detail/0192be46fb5471af8a26ccfd10dc326d', '/detail/0192be488f187349a02beaacdd7f40b1', '/detail/0192be4a2c437314abe7d7da43768da9', '/detail/0192be4bf4987295bc0e5b47b29e0828', '/detail/0192be4e67a073ffba2f616b8c098cd0', '/detail/0192be5099be73cdac2d02b01bc50da8', '/detail/0192be52474a714cb9cab5dd752ebcfe', '/detail/0192be53c17e71e8b9b8a76a07106ef6', '/detail/0192be55b8d570b18ecdbbaa553faf94', '/detail/0192be57bb37732ebdc1451e0eabb96c', '/detail/0192be5a50fc704398007c34d438b051', '/detail/0192be5bda2671029c7518d5bcbc5a65', '/detail/0192be5e164b72e7b8e127c08ebc28dd', '/detail/0192be5fa5e07137a73ddbdb91013919', '/detail/0192be618d84722f910845f7fce308f8', '/detail/0192be63588e73c5a8d71daa70c9b71c', '/detail/0192be63a78a73e89d8c98ee1c350a4f', '/detail/0192be6859be73a2b65b959d13f7da64', '/detail/0192be69de5973dcbbfc875780be23d6', '/detail/0192be6cd17970249592ecdc0581d195', '/detail/0192be6e8641703aaaa13c234e1a6523', '/detail/0192be71794b73e89bc73ebd8ef57060', '/detail/0192be7366d27265ae4703db9d08488b', '/detail/0192be751b7c73f3b552cf544aa4c6a0', '/detail/0192be76764570b9b4fb28eded7381bf', '/detail/0192be780908733fa035b6af123a3774', '/detail/0192be79a16b7358a11f5aa31ac3cc21', '/detail/0192be7b683773a2a04cf6a68d28e0cd', '/detail/0192be7de574704584ab1270c189329e', '/detail/0192be7ffb7673abaff78d18dca0aebe', '/detail/0192be94a7c3716fa3ffe43d223c20fc', '/detail/0192be968a57712b96ca50f7639238eb', '/detail/0192be980b4773cd9968df95759b6c03', '/detail/0192be99e47870c097a34190ec41b3cd', '/detail/0192be9ce93671e4800ae90e7423bae0', '/detail/0192be9e367b713190db570ac3bb54dc', '/detail/0192bea008f37281bce8769716fbfd6c', '/detail/0192bea44d60714fb091b69d4fafa317', '/detail/0192bea51c44732fb213da80aa222e13', '/detail/0192bea5e78971e1975a91d7c067b36a', '/detail/0192bea698c17169b7e613c875136880', '/detail/0192bea75ce8707f91418418947409a2', '/detail/0192bea81eae70bfa067403cd600e04a', '/detail/0192bea8c87c7209bef77dc9fa3f4f3c', '/detail/0192bea9b1b173c98a81b4ff100abec0', '/detail/0192beaa60f67263b1d8e809d6f941a2', '/detail/0192beab2054734b91ae5808ade5163d', '/detail/0192beabd3507351835526b8326708fc', '/detail/0192beac9352714e899d0729324f2127', '/detail/0192bead4f94716d970a7186c5cee0cf', '/detail/0192beae16ea7237a4b63e646eec3eb7', '/detail/0192beaecd7073ca995e998406883367', '/detail/0192beaf8e0a71c5856cb78700a10920', '/detail/0192beb035c9700b96fd8914e859fadd', '/detail/0192beb0d6827292be5c2203c8e6696a', '/detail/0192beb1709f7041a09dcfcd6c30f604', '/detail/0192beb21c9c70faab88871cfa93cae1', '/detail/0192beb2ce2d73d1b6719e83bddd34c9', '/detail/0192d8a490f372cb8c8f4b0430b16b31', '/detail/0193d4dedc9b704a817fdd0d1ddd3fbf', '/detail/0193d4e486e172e8b7d2575301b4932b', '/detail/0193d4e719d373dfbac8553fab5dd036', '/detail/0193da27fc057182b1b7eaeb5fcd4fd9', '/detail/0194652b1f4672e9aba689f2a0a3e98b', '/detail/019465343de07239886fa2f378198bb5', '/detail/01946539fff970ceb3f9f84e553bddf4', '/detail/0194653ff6f0725cbf3484ebc5c3bc41', '/detail/019465457f3970828c332259f1329f01', '/detail/0194654c94a57216a88d5289b17ffd19', '/detail/01946551702c70c39321895d19ecbad1', '/detail/0194655604fa7056b8f672b03a764b52', '/detail/019469b0d3f97232b587cdb898d2bd03', '/detail/019469b7b0e671eeb66458de8f3628ce', '/detail/019469bcc0f37101a6abb1a6301b826a', '/detail/019469c0339070c7b4b55473f47760c3', '/detail/019469c3abf171e2bd378c190bac18ef', '/detail/019469c76f417116a055dea5ecad3e70', '/detail/019469c9ecec7172a7c391a00ebee712', '/detail/019469ce7fb972ef9736a6f17d2e6fb9', '/detail/019469d396707390b3e7eb3df87f1dd5', '/detail/019469d7564372608fbfa6bfd982cf1b', '/detail/019469da9a6673e1852e6f3891ce05e2', '/detail/019469dd0c2970519ba2312ab5c1631e', '/detail/019469e1a56a723fb0ccab31452d922b', '/detail/019469e46fa170ba9d2e2c9ca1b1ce1b', '/detail/019469e6d4607281a1637c44740f69e7', '/detail/019469e9676373e4bda4a192c389c607', '/detail/018e1dfbef1071778e71c4a58fea9a45', '/navigation/44d0c741f1c04c008728f1d3ab7ec5bf', '/navigation/591c1da6b3dd4940bf3872ac851abd04', '/navigation/484a749a1a2345f396c30b6078e4bbb2', '/navigation/805f99bd458c4176ae973f800e3c6f48', '/navigation/a89173a67c3341f998a1efb8b101547d', '/navigation/74c703ceae8c4d1e91ea8edfd9c7b233')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x847D21CC09534FAFA59D3DC095007FFD OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);