Symfony Profiler

SELECT
  `product`.`id`,
  `product`.`product_number`,
  `product`.`auto_increment`
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 `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (
          (
            `product`.`id` IN (
              ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
              ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
              ?, ?, ?, ?, ?, ?, ?, ?
            )
            OR `product`.`parent_id` IN (
              ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
              ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
              ?, ?, ?, ?, ?, ?, ?, ?
            )
          )
        )
      )
      AND NOT (`product`.`id` <=> ?)
      AND NOT (`product`.`display_group` <=> ?)
      AND (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
    )
  )
GROUP BY
  `product`.`display_group`
ORDER BY
  MAX(
    IFNULL(
      `product`.`release_date`, `product.parent`.`release_date`
    )
  ) DESC
LIMIT
  50

SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` 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 `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((((`product`.`id` IN (0xF1703FF7F6FC4AF99DEC6BE21E026D24, 0x91469D81A73C473988D8A0252A957EEE, 0x3453A0AF6E994E91BC9C5109B4D6928E, 0x573E67EA49A14B0AAE36510FDACC2552, 0x07C6C77235004790A0F086AF941063CC, 0xFFB5CE933891424482BC33FE186924E4, 0xDD49F0612E8C4324A137CA01121F6740, 0x33EF1EC031F24563B2ED49A5387796CE, 0xFCA6A5199ADA415B87A90CFB928DF2DB, 0xDD12CF702D3F464B85C3410717AD1E65, 0xF5B764065DCF4048935FA55D1307D5FF, 0x728717EC1422413D872D92F860A37B8C, 0x98CFC6A33EF24D208CE8D93A253F512E, 0x029023DCB77E42068066E4C4454FB31C, 0x8E1AEDA23A294E9BA89CC9C35674049A, 0x587A359BD5D34C5484737B565BAD7CC7, 0x64ED51EEFD044D55B4F3B34FF7394B7A, 0xE5DA5FDB124749E39F8DC2653EA68215, 0x309992F7F0A74AC29B6CECE5CC949E98, 0x0953B66279F34D309D474F09FDF2FF2F, 0xD8CCD33EE62B4FCAA4FD9DA0367B15ED, 0x7A4E33337E674587B78D9B63298D45C5, 0x591FC0D8CD5E4ABC8A344BB4C7CF7411, 0x1046FE90DC25466C8D91E5A331508BE2, 0x1E68697660EC498FBA71FD47925B9203, 0xEA27895BE7B546CEBE0C8E25B4B10FA3, 0x53AF443259DE4A0AB28627ED92B0EED3, 0x1BA4CDD020E144EAB26CD494395BA07D, 0x5BA0EAA83E4B481290BCB4F25940887A, 0xB31948F61DC84B0AA53B57CD33B60DF6, 0xE66DE006E6674858A873B5A0AFDA9D44, 0x21B036B840CC408B9E8A679900772022, 0xB0707D79A0A84269872A7AEA5F3D6736, 0x5153F19F5BB24A4DBE6EBCC11CA67FF4, 0x240BC95873744ED691D69E795E24E03F, 0x5F5B706CC3F34E6F991A5F3A6968BA56, 0x32A18F3CDF184D099D36423FD0A82353, 0x71EC2C6257044E369EEA23D626B2A641, 0xAF6F63330EA0452CA8DF012C035778F4) OR `product`.`parent_id` IN (0xF1703FF7F6FC4AF99DEC6BE21E026D24, 0x91469D81A73C473988D8A0252A957EEE, 0x3453A0AF6E994E91BC9C5109B4D6928E, 0x573E67EA49A14B0AAE36510FDACC2552, 0x07C6C77235004790A0F086AF941063CC, 0xFFB5CE933891424482BC33FE186924E4, 0xDD49F0612E8C4324A137CA01121F6740, 0x33EF1EC031F24563B2ED49A5387796CE, 0xFCA6A5199ADA415B87A90CFB928DF2DB, 0xDD12CF702D3F464B85C3410717AD1E65, 0xF5B764065DCF4048935FA55D1307D5FF, 0x728717EC1422413D872D92F860A37B8C, 0x98CFC6A33EF24D208CE8D93A253F512E, 0x029023DCB77E42068066E4C4454FB31C, 0x8E1AEDA23A294E9BA89CC9C35674049A, 0x587A359BD5D34C5484737B565BAD7CC7, 0x64ED51EEFD044D55B4F3B34FF7394B7A, 0xE5DA5FDB124749E39F8DC2653EA68215, 0x309992F7F0A74AC29B6CECE5CC949E98, 0x0953B66279F34D309D474F09FDF2FF2F, 0xD8CCD33EE62B4FCAA4FD9DA0367B15ED, 0x7A4E33337E674587B78D9B63298D45C5, 0x591FC0D8CD5E4ABC8A344BB4C7CF7411, 0x1046FE90DC25466C8D91E5A331508BE2, 0x1E68697660EC498FBA71FD47925B9203, 0xEA27895BE7B546CEBE0C8E25B4B10FA3, 0x53AF443259DE4A0AB28627ED92B0EED3, 0x1BA4CDD020E144EAB26CD494395BA07D, 0x5BA0EAA83E4B481290BCB4F25940887A, 0xB31948F61DC84B0AA53B57CD33B60DF6, 0xE66DE006E6674858A873B5A0AFDA9D44, 0x21B036B840CC408B9E8A679900772022, 0xB0707D79A0A84269872A7AEA5F3D6736, 0x5153F19F5BB24A4DBE6EBCC11CA67FF4, 0x240BC95873744ED691D69E795E24E03F, 0x5F5B706CC3F34E6F991A5F3A6968BA56, 0x32A18F3CDF184D099D36423FD0A82353, 0x71EC2C6257044E369EEA23D626B2A641, 0xAF6F63330EA0452CA8DF012C035778F4)))) AND NOT (`product`.`id` <=> 0x1046FE90DC25466C8D91E5A331508BE2) AND NOT (`product`.`display_group` <=> NULL) AND ((`product.visibilities`.`visibility` >= 10) AND `product.visibilities`.`sales_channel_id` = 0xC9A6F5BF098244B1B12678C36AED2C51 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1))) GROUP BY `product`.`display_group` ORDER BY MAX(IFNULL(`product`.`release_date`, `product.parent`.`release_date`)) DESC LIMIT 50;

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 (0x0191035A3D9A72F2B62732BC290E4626, 0x7A4E33337E674587B78D9B63298D45C5, 0x01910359F4FB738A942AA9765EC2E870, 0x64ED51EEFD044D55B4F3B34FF7394B7A, 0x0190FDCD51B371D086BFF14CD43F2D3A, 0x5BA0EAA83E4B481290BCB4F25940887A, 0x0190FDCC4A2C7164905C650E27A61F19, 0x591FC0D8CD5E4ABC8A344BB4C7CF7411, 0x0190EE78B3387026953D66779BDA3056, 0x587A359BD5D34C5484737B565BAD7CC7, 0x0190EE6C007771998DAA67931326425F, 0x53AF443259DE4A0AB28627ED92B0EED3, 0x0190EE5921A372F7AD487570822C23FC, 0x309992F7F0A74AC29B6CECE5CC949E98, 0x0190EE583C3072FA81F8F6CD786E11E7, 0x21B036B840CC408B9E8A679900772022, 0x0190EE57537A7070A6774515C4DAD8D1, 0x1E68697660EC498FBA71FD47925B9203, 0x0190EE566B2472ED981DD96DEEC41FE6, 0x1BA4CDD020E144EAB26CD494395BA07D, 0xEA27895BE7B546CEBE0C8E25B4B10FA3, 0x0190EE0552C172C098FA3FEDD915E664, 0x0953B66279F34D309D474F09FDF2FF2F, 0xE66DE006E6674858A873B5A0AFDA9D44, 0x0190EE045B3773928B5215E7159BD63A, 0x029023DCB77E42068066E4C4454FB31C, 0xE5DA5FDB124749E39F8DC2653EA68215, 0x0190EE0367587361AA07C94527A35034, 0x0191035BA95A72A69BA2EE6049E32199, 0xD8CCD33EE62B4FCAA4FD9DA0367B15ED, 0x0190EE02704873A48588FB6BC7D54609, 0x0191035B601E73C38BED2D189F3A2136, 0xB31948F61DC84B0AA53B57CD33B60DF6, 0x0190D9DA42CD7389A6C7AF139CB7E5A3, 0x0191035B17F572D1BBEF0DB3518D569A, 0x98CFC6A33EF24D208CE8D93A253F512E, 0x0191035A825E70239A61A270B7BBCEDC, 0x8E1AEDA23A294E9BA89CC9C35674049A));

# 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/1046fe90dc25466c8d91e5a331508be2', '/navigation/c1d9a37345a042938c0b318c1b1c7603', '/navigation/05c8c55fe903479a87662295a58c4ead', '/navigation/cf910d9c7c214c77af2002e17ec82112', '/navigation/9bb9ec7bf58444c1948e9aaead4b6069', '/navigation/fc0ff7a7a5094e36b991634a6f05d37e', '/navigation/1f2a1232cddd49dfa559b8bd24df44f8', '/navigation/537fd57254854488a70bf045a1ff7c46', '/navigation/8d98c038a81248ccaa597daf100c00b3', '/navigation/45b39a11aed94b5aa3f8e4c1f3713f5f', '/navigation/9107e059db954570ba554c9f854a9d8a', '/navigation/5b545df6c690496e87fe1b08927ae772', '/navigation/f325cf96ccd947fe8cfaf91bc3126486', '/navigation/8e1bba960e8c4be2ad164acc9fb07a13', '/navigation/62e12dca076d486f89b69989712d82c7', '/navigation/d7820350e1df4e71984322e4c1311cd5', '/navigation/63d70e435ef44dd1bf6aa623fda58e8c', '/navigation/704bcfdd971f4c56aac782c2b41dc83e', '/navigation/90d2f43568ad4614bda8bd041fa4abe7', '/navigation/c82ff124b1364381b541e46dcb735549', '/navigation/d5c1e7cd6ad440aa91122cb57eaeb69e', '/navigation/b6d5f38073bf4228a0d8bea55380b993', '/navigation/90e8c49f111f4518affb4cbf2805b242', '/navigation/f17261e393c447a1921c28bcca6db3f9', '/navigation/80b822cbb77d48dd869b22fe5b7b8588', '/navigation/3218742a897d44129c822e5faa48a64b', '/navigation/67434ea6f1aa45db83e72d59650f9644', '/navigation/c363f43d4e404db59853cbefb0bd7069', '/navigation/23e6e97ababe48a29f2490cc04b83952', '/navigation/c27d4f2afb1247b2818b5ecbfd585a40', '/navigation/7e6ede8c5ede4ffe8de1877628b1018b', '/navigation/b2c2b4fe7a744b0ca4c6b0763274225c', '/navigation/266838ca78a940bb9ebd7cec3ee32749', '/navigation/fd9f1d01d8d2430aa12b7077479dc7a4', '/navigation/fa3e69fe19e94cc89f113f0aff04a505', '/navigation/8c2332b671474fc8b2e13e44c0f0190a', '/navigation/36b4cf2468c74b8dbc6256795478cf90', '/navigation/88ea449bf9e6401597e1b54b02b1c0d0', '/navigation/e9a8020de3154a9db056caff4ab975e3', '/navigation/46398b1b21fc45e98521fbd404773c79', '/navigation/b676635231ea4095af8b593c0651f2f4', '/navigation/963711ce416647cdaf10fc322af5541f', '/navigation/dbfcdbfc097d4573a466033d791b2bbc', '/navigation/14bb75adb0a042db82703556da9383f6', '/navigation/1eceafaf68a848a68af45019d39cdc2f', '/navigation/4b9db8a420af4e5e9880c115fe932362', '/navigation/24e5ca5a2aa642d9b5681d15e3ab4a84', '/navigation/0447f6c1f3e54521936efadd8db78dc4', '/navigation/38aff8a4e09b4b628c36b3157c59bda8', '/navigation/8c2d8520c8674e2583640fad21fbac07', '/navigation/332ccd2f295c47b68ae319fb152dedc3', '/navigation/64eae93739214024a9c8766b43941bc5', '/navigation/63302c2f386148a9bab6b79b189e74a2', '/navigation/887dc301356a46799891fa5832c80a03', '/navigation/6104cd1569e94060a1158598b5d7474b', '/navigation/b9637a1f2b3f4fcea34d88988ebbcef1', '/navigation/51e82fb69fba4842af0f54fa2b99a2c2', '/navigation/2e1395e3f5a1474e8e7e0637dcc801a7', '/navigation/c730e39461984875a39f4552895848f4', '/navigation/595443089bf944398b8568193c218803', '/navigation/563faaf412d640aba6cdd6617c797ed6', '/navigation/bf553b75dc8a4647bde36ed6fd951a39', '/navigation/e5b83032fec040088deb63f6b3520fed', '/navigation/b56dfaca7e024e1aa3dcef9c523109e0', '/navigation/71f23e85777a4aeb9372366b5a6751dd', '/navigation/068db263e33845829e874a8c4aa32d87', '/navigation/3e454b306f544f208c9799e56f5de5be', '/navigation/018ad60dff0c7b66849681a72a4d8d6f', '/navigation/c047662d6b2445dfb57c8b867b31b07a', '/navigation/9f6f003af1324eaa8d9dbc164b07302b', '/navigation/743d6a38399844538c602144087bf739', '/navigation/6c77112a83724bf78c88b89738b48b64', '/navigation/daac6c256c7544be8a12eb4951caaa24', '/navigation/200231c145b64c7f936fa6f47175739c', '/navigation/48647050b43e4f788ebf75cf8dfe47e3', '/navigation/7831b4af0bd34445b6b55eb60f12dfe5', '/navigation/41f5d33bae6d4919adffb7e1c5665712', '/navigation/c82f851230b441a697834f5005460dfb', '/navigation/6ebe3f001a474100aec86568619c72fb', '/navigation/f5b452ede4c547ce8fcd0503dbe56059', '/navigation/5451addf6e1442e083a0b8634754245b', '/navigation/d9988c1aba7e45c4b6bf51172e746481', '/navigation/3c4efcc9997e4d179cef0e01b57d1e41', '/navigation/ecfb4571a39047829b259c9bcd029d5a', '/navigation/5d1bc2308d1642d7b3d8a519351c9494', '/navigation/a044f9c23ae148b383a9e7d99ce6b8d4', '/navigation/df4d9f26a1774bbdb09e20bd178d8a99', '/navigation/cea0dd23f1e84eaf927c97d5d50fc46a', '/navigation/36a4175181c742e08d7a2056816d131e', '/navigation/4ecb954a4b6f496a9dadafaf3b8640e1', '/navigation/0d3861d9baf64d1aa367dc3605a3152a', '/navigation/5f372af8dd194a9b8b44cf662772d0a0', '/navigation/c722eeb65d564a7ab7010031868098d6', '/navigation/db307ec54bce415d8eb6e7bca214233a', '/navigation/b933c58445c744098b586b1934fdf5f3', '/navigation/4d95e6e34c6040548f9da64589c39f7b', '/navigation/74bcb9644a904a3d871c1b7502a99ee2', '/navigation/f472edc261294d8fb9f1feee6cd2d911', '/navigation/854ab813d03940c0a47583db7c554171', '/navigation/50647a83895449e19d149d6af76c2301', '/navigation/97ab69b0204445ea974f85930f40d4f0', '/navigation/cfa92da3a5a347f1807afb4df7e37dfd', '/navigation/9bd17caa9d074399a80dab51c13c1ccb', '/navigation/319efcff73ce469e85e8ceb87ff5e05a', '/navigation/a0079db1b54549b9b927995250e7f534', '/navigation/dc90590ae6df47bd9be939f9e50d5b5f', '/navigation/aaf2e2f57a554be089c18bbe628f2b1f', '/navigation/30778256954c47cd8e6dab73243b62dd', '/detail/0191035a3d9a72f2b62732bc290e4626', '/detail/7a4e33337e674587b78d9b63298d45c5', '/detail/01910359f4fb738a942aa9765ec2e870', '/detail/64ed51eefd044d55b4f3b34ff7394b7a', '/detail/0190fdcd51b371d086bff14cd43f2d3a', '/detail/5ba0eaa83e4b481290bcb4f25940887a', '/detail/0190fdcc4a2c7164905c650e27a61f19', '/detail/591fc0d8cd5e4abc8a344bb4c7cf7411', '/detail/0190ee78b3387026953d66779bda3056', '/detail/587a359bd5d34c5484737b565bad7cc7', '/detail/0190ee6c007771998daa67931326425f', '/detail/53af443259de4a0ab28627ed92b0eed3', '/detail/0190ee5921a372f7ad487570822c23fc', '/detail/309992f7f0a74ac29b6cece5cc949e98', '/detail/0190ee583c3072fa81f8f6cd786e11e7', '/detail/21b036b840cc408b9e8a679900772022', '/detail/0190ee57537a7070a6774515c4dad8d1', '/detail/1e68697660ec498fba71fd47925b9203', '/detail/0190ee566b2472ed981dd96deec41fe6', '/detail/1ba4cdd020e144eab26cd494395ba07d', '/detail/ea27895be7b546cebe0c8e25b4b10fa3', '/detail/0190ee0552c172c098fa3fedd915e664', '/detail/0953b66279f34d309d474f09fdf2ff2f', '/detail/e66de006e6674858a873b5a0afda9d44', '/detail/0190ee045b3773928b5215e7159bd63a', '/detail/029023dcb77e42068066e4c4454fb31c', '/detail/e5da5fdb124749e39f8dc2653ea68215', '/detail/0190ee0367587361aa07c94527a35034', '/detail/0191035ba95a72a69ba2ee6049e32199', '/detail/d8ccd33ee62b4fcaa4fd9da0367b15ed', '/detail/0190ee02704873a48588fb6bc7d54609', '/detail/0191035b601e73c38bed2d189f3a2136', '/detail/b31948f61dc84b0aa53b57cd33b60df6', '/detail/0190d9da42cd7389a6c7af139cb7e5a3', '/detail/0191035b17f572d1bbef0db3518d569a', '/detail/98cfc6a33ef24d208ce8d93a253f512e', '/detail/0191035a825e70239a61a270b7bbcedc', '/detail/8e1aeda23a294e9ba89cc9c35674049a', '/navigation/fd0a0e7a2bd644189e766a0e9c64692c', '/navigation/018a8c33617e7c70b93004f2162d2a12', '/navigation/f06497abd9564029aa5daa9a177f56b2', '/navigation/58b2fc9f64964d16bd48b5801f6e45da', '/navigation/1cbe9b95ee0044c585d3efca0cc1a911', '/navigation/5d4e67d1b8f4443a8389dab043736f48', '/navigation/e5854a44e17f4de0b3a4f2a21405510e')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0xC9A6F5BF098244B1B12678C36AED2C51 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);