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`.`parent_id` = ?
      AND `product`.`available` = ?
      AND JSON_CONTAINS(
        IFNULL(
          `product`.`option_ids`, `product.parent`.`option_ids`
        ),
        JSON_ARRAY(?)
      )
      AND (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
    )
  )
LIMIT
  1

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`.`parent_id` = 0xA9BDD10EC07A43E3BD9FD666F678F06B AND `product`.`available` = 1 AND JSON_CONTAINS(IFNULL(`product`.`option_ids`, `product.parent`.`option_ids`), JSON_ARRAY('5aa3475b1c53451eb7f92bf850880594')) AND ((`product.visibilities`.`visibility` >= 10) AND `product.visibilities`.`sales_channel_id` = 0x67D79825561D4007A766D27CBBF1BDF6 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1))) LIMIT 1;

SELECT
  `product_configurator_setting`.`id` AS `product_configurator_setting.id`,
  `product_configurator_setting`.`version_id` AS `product_configurator_setting.versionId`,
  `product_configurator_setting`.`product_id` AS `product_configurator_setting.productId`,
  `product_configurator_setting`.`product_version_id` AS `product_configurator_setting.productVersionId`,
  `product_configurator_setting`.`media_id` AS `product_configurator_setting.mediaId`,
  `product_configurator_setting`.`property_group_option_id` AS `product_configurator_setting.optionId`,
  `product_configurator_setting`.`price` AS `product_configurator_setting.price`,
  `product_configurator_setting`.`position` AS `product_configurator_setting.position`,
  `product_configurator_setting`.`custom_fields` AS `product_configurator_setting.customFields`,
  `product_configurator_setting`.`created_at` AS `product_configurator_setting.createdAt`,
  `product_configurator_setting`.`updated_at` AS `product_configurator_setting.updatedAt`,
  `product_configurator_setting.option`.`id` AS `product_configurator_setting.option.id`,
  `product_configurator_setting.option`.`property_group_id` AS `product_configurator_setting.option.groupId`,
  `product_configurator_setting.option`.`color_hex_code` AS `product_configurator_setting.option.colorHexCode`,
  `product_configurator_setting.option`.`media_id` AS `product_configurator_setting.option.mediaId`,
  `product_configurator_setting.option`.`created_at` AS `product_configurator_setting.option.createdAt`,
  `product_configurator_setting.option`.`updated_at` AS `product_configurator_setting.option.updatedAt`,
  `product_configurator_setting.option.group`.`id` AS `product_configurator_setting.option.group.id`,
  `product_configurator_setting.option.group`.`display_type` AS `product_configurator_setting.option.group.displayType`,
  `product_configurator_setting.option.group`.`sorting_type` AS `product_configurator_setting.option.group.sortingType`,
  `product_configurator_setting.option.group`.`filterable` AS `product_configurator_setting.option.group.filterable`,
  `product_configurator_setting.option.group`.`visible_on_product_detail_page` AS `product_configurator_setting.option.group.visibleOnProductDetailPage`,
  `product_configurator_setting.option.group`.`created_at` AS `product_configurator_setting.option.group.createdAt`,
  `product_configurator_setting.option.group`.`updated_at` AS `product_configurator_setting.option.group.updatedAt`,
  `product_configurator_setting.option.group.translation.name`,
  COALESCE(
    `product_configurator_setting.option.group.translation.name`,
    `product_configurator_setting.option.group.translation.name`
  ) AS `product_configurator_setting.option.group.name`,
  `product_configurator_setting.option.group.translation.description`,
  COALESCE(
    `product_configurator_setting.option.group.translation.description`,
    `product_configurator_setting.option.group.translation.description`
  ) AS `product_configurator_setting.option.group.description`,
  `product_configurator_setting.option.group.translation.position`,
  COALESCE(
    `product_configurator_setting.option.group.translation.position`,
    `product_configurator_setting.option.group.translation.position`
  ) AS `product_configurator_setting.option.group.position`,
  `product_configurator_setting.option.group.translation.customFields`,
  COALESCE(
    `product_configurator_setting.option.group.translation.customFields`,
    `product_configurator_setting.option.group.translation.customFields`
  ) AS `product_configurator_setting.option.group.customFields`,
  `product_configurator_setting.option.group.translation.createdAt`,
  `product_configurator_setting.option.group.translation.updatedAt`,
  `product_configurator_setting.option.group.translation.propertyGroupId`,
  `product_configurator_setting.option.group.translation.languageId`,
  `product_configurator_setting.option.media`.`id` AS `product_configurator_setting.option.media.id`,
  `product_configurator_setting.option.media`.`user_id` AS `product_configurator_setting.option.media.userId`,
  `product_configurator_setting.option.media`.`media_folder_id` AS `product_configurator_setting.option.media.mediaFolderId`,
  `product_configurator_setting.option.media`.`mime_type` AS `product_configurator_setting.option.media.mimeType`,
  `product_configurator_setting.option.media`.`file_extension` AS `product_configurator_setting.option.media.fileExtension`,
  `product_configurator_setting.option.media`.`uploaded_at` AS `product_configurator_setting.option.media.uploadedAt`,
  `product_configurator_setting.option.media`.`file_name` AS `product_configurator_setting.option.media.fileName`,
  `product_configurator_setting.option.media`.`file_size` AS `product_configurator_setting.option.media.fileSize`,
  `product_configurator_setting.option.media`.`media_type` AS `product_configurator_setting.option.media.mediaTypeRaw`,
  `product_configurator_setting.option.media`.`meta_data` AS `product_configurator_setting.option.media.metaData`,
  `product_configurator_setting.option.media`.`config` AS `product_configurator_setting.option.media.config`,
  `product_configurator_setting.option.media`.`path` AS `product_configurator_setting.option.media.path`,
  `product_configurator_setting.option.media`.`private` AS `product_configurator_setting.option.media.private`,
  `product_configurator_setting.option.media`.`thumbnails_ro` AS `product_configurator_setting.option.media.thumbnailsRo`,
  `product_configurator_setting.option.media`.`created_at` AS `product_configurator_setting.option.media.createdAt`,
  `product_configurator_setting.option.media`.`updated_at` AS `product_configurator_setting.option.media.updatedAt`,
  `product_configurator_setting.option.media.translation.title`,
  COALESCE(
    `product_configurator_setting.option.media.translation.title`,
    `product_configurator_setting.option.media.translation.title`
  ) AS `product_configurator_setting.option.media.title`,
  `product_configurator_setting.option.media.translation.alt`,
  COALESCE(
    `product_configurator_setting.option.media.translation.alt`,
    `product_configurator_setting.option.media.translation.alt`
  ) AS `product_configurator_setting.option.media.alt`,
  `product_configurator_setting.option.media.translation.customFields`,
  COALESCE(
    `product_configurator_setting.option.media.translation.customFields`,
    `product_configurator_setting.option.media.translation.customFields`
  ) AS `product_configurator_setting.option.media.customFields`,
  `product_configurator_setting.option.media.translation.createdAt`,
  `product_configurator_setting.option.media.translation.updatedAt`,
  `product_configurator_setting.option.media.translation.mediaId`,
  `product_configurator_setting.option.media.translation.languageId`,
  `product_configurator_setting.option.translation.name`,
  COALESCE(
    `product_configurator_setting.option.translation.name`,
    `product_configurator_setting.option.translation.name`
  ) AS `product_configurator_setting.option.name`,
  `product_configurator_setting.option.translation.position`,
  COALESCE(
    `product_configurator_setting.option.translation.position`,
    `product_configurator_setting.option.translation.position`
  ) AS `product_configurator_setting.option.position`,
  `product_configurator_setting.option.translation.customFields`,
  COALESCE(
    `product_configurator_setting.option.translation.customFields`,
    `product_configurator_setting.option.translation.customFields`
  ) AS `product_configurator_setting.option.customFields`,
  `product_configurator_setting.option.translation.createdAt`,
  `product_configurator_setting.option.translation.updatedAt`,
  `product_configurator_setting.option.translation.propertyGroupOptionId`,
  `product_configurator_setting.option.translation.languageId`,
  `product_configurator_setting.media`.`id` AS `product_configurator_setting.media.id`,
  `product_configurator_setting.media`.`user_id` AS `product_configurator_setting.media.userId`,
  `product_configurator_setting.media`.`media_folder_id` AS `product_configurator_setting.media.mediaFolderId`,
  `product_configurator_setting.media`.`mime_type` AS `product_configurator_setting.media.mimeType`,
  `product_configurator_setting.media`.`file_extension` AS `product_configurator_setting.media.fileExtension`,
  `product_configurator_setting.media`.`uploaded_at` AS `product_configurator_setting.media.uploadedAt`,
  `product_configurator_setting.media`.`file_name` AS `product_configurator_setting.media.fileName`,
  `product_configurator_setting.media`.`file_size` AS `product_configurator_setting.media.fileSize`,
  `product_configurator_setting.media`.`media_type` AS `product_configurator_setting.media.mediaTypeRaw`,
  `product_configurator_setting.media`.`meta_data` AS `product_configurator_setting.media.metaData`,
  `product_configurator_setting.media`.`config` AS `product_configurator_setting.media.config`,
  `product_configurator_setting.media`.`path` AS `product_configurator_setting.media.path`,
  `product_configurator_setting.media`.`private` AS `product_configurator_setting.media.private`,
  `product_configurator_setting.media`.`thumbnails_ro` AS `product_configurator_setting.media.thumbnailsRo`,
  `product_configurator_setting.media`.`created_at` AS `product_configurator_setting.media.createdAt`,
  `product_configurator_setting.media`.`updated_at` AS `product_configurator_setting.media.updatedAt`,
  `product_configurator_setting.media.translation.title`,
  COALESCE(
    `product_configurator_setting.media.translation.title`,
    `product_configurator_setting.media.translation.title`
  ) AS `product_configurator_setting.media.title`,
  `product_configurator_setting.media.translation.alt`,
  COALESCE(
    `product_configurator_setting.media.translation.alt`,
    `product_configurator_setting.media.translation.alt`
  ) AS `product_configurator_setting.media.alt`,
  `product_configurator_setting.media.translation.customFields`,
  COALESCE(
    `product_configurator_setting.media.translation.customFields`,
    `product_configurator_setting.media.translation.customFields`
  ) AS `product_configurator_setting.media.customFields`,
  `product_configurator_setting.media.translation.createdAt`,
  `product_configurator_setting.media.translation.updatedAt`,
  `product_configurator_setting.media.translation.mediaId`,
  `product_configurator_setting.media.translation.languageId`
FROM
  `product_configurator_setting`
  LEFT JOIN `property_group_option` `product_configurator_setting.option` ON `product_configurator_setting`.`property_group_option_id` = `product_configurator_setting.option`.`id`
  LEFT JOIN `media` `product_configurator_setting.media` ON `product_configurator_setting`.`media_id` = `product_configurator_setting.media`.`id`
  LEFT JOIN (
    SELECT
      `product_configurator_setting.option.translation`.property_group_option_id,
      `product_configurator_setting.option.translation`.name AS `product_configurator_setting.option.translation.name`,
      `product_configurator_setting.option.translation`.position AS `product_configurator_setting.option.translation.position`,
      `product_configurator_setting.option.translation`.custom_fields AS `product_configurator_setting.option.translation.customFields`,
      `product_configurator_setting.option.translation`.created_at AS `product_configurator_setting.option.translation.createdAt`,
      `product_configurator_setting.option.translation`.updated_at AS `product_configurator_setting.option.translation.updatedAt`,
      `product_configurator_setting.option.translation`.property_group_option_id AS `product_configurator_setting.option.translation.propertyGroupOptionId`,
      `product_configurator_setting.option.translation`.language_id AS `product_configurator_setting.option.translation.languageId`
    FROM
      `property_group_option_translation` `product_configurator_setting.option.translation`
    WHERE
      `product_configurator_setting.option.translation`.language_id = ?
  ) `product_configurator_setting.option.property_group_option_translation` ON `product_configurator_setting.option.property_group_option_translation`.`property_group_option_id` = `product_configurator_setting.option`.`id`
  LEFT JOIN `property_group` `product_configurator_setting.option.group` ON `product_configurator_setting.option`.`property_group_id` = `product_configurator_setting.option.group`.`id`
  LEFT JOIN `media` `product_configurator_setting.option.media` ON `product_configurator_setting.option`.`media_id` = `product_configurator_setting.option.media`.`id`
  LEFT JOIN (
    SELECT
      `product_configurator_setting.option.group.translation`.property_group_id,
      `product_configurator_setting.option.group.translation`.name AS `product_configurator_setting.option.group.translation.name`,
      `product_configurator_setting.option.group.translation`.description AS `product_configurator_setting.option.group.translation.description`,
      `product_configurator_setting.option.group.translation`.position AS `product_configurator_setting.option.group.translation.position`,
      `product_configurator_setting.option.group.translation`.custom_fields AS `product_configurator_setting.option.group.translation.customFields`,
      `product_configurator_setting.option.group.translation`.created_at AS `product_configurator_setting.option.group.translation.createdAt`,
      `product_configurator_setting.option.group.translation`.updated_at AS `product_configurator_setting.option.group.translation.updatedAt`,
      `product_configurator_setting.option.group.translation`.property_group_id AS `product_configurator_setting.option.group.translation.propertyGroupId`,
      `product_configurator_setting.option.group.translation`.language_id AS `product_configurator_setting.option.group.translation.languageId`
    FROM
      `property_group_translation` `product_configurator_setting.option.group.translation`
    WHERE
      `product_configurator_setting.option.group.translation`.language_id = ?
  ) `product_configurator_setting.option.group.property_group_translation` ON `product_configurator_setting.option.group.property_group_translation`.`property_group_id` = `product_configurator_setting.option.group`.`id`
  LEFT JOIN (
    SELECT
      `product_configurator_setting.option.media.translation`.media_id,
      `product_configurator_setting.option.media.translation`.title AS `product_configurator_setting.option.media.translation.title`,
      `product_configurator_setting.option.media.translation`.alt AS `product_configurator_setting.option.media.translation.alt`,
      `product_configurator_setting.option.media.translation`.custom_fields AS `product_configurator_setting.option.media.translation.customFields`,
      `product_configurator_setting.option.media.translation`.created_at AS `product_configurator_setting.option.media.translation.createdAt`,
      `product_configurator_setting.option.media.translation`.updated_at AS `product_configurator_setting.option.media.translation.updatedAt`,
      `product_configurator_setting.option.media.translation`.media_id AS `product_configurator_setting.option.media.translation.mediaId`,
      `product_configurator_setting.option.media.translation`.language_id AS `product_configurator_setting.option.media.translation.languageId`
    FROM
      `media_translation` `product_configurator_setting.option.media.translation`
    WHERE
      `product_configurator_setting.option.media.translation`.language_id = ?
  ) `product_configurator_setting.option.media.media_translation` ON `product_configurator_setting.option.media.media_translation`.`media_id` = `product_configurator_setting.option.media`.`id`
  LEFT JOIN (
    SELECT
      `product_configurator_setting.media.translation`.media_id,
      `product_configurator_setting.media.translation`.title AS `product_configurator_setting.media.translation.title`,
      `product_configurator_setting.media.translation`.alt AS `product_configurator_setting.media.translation.alt`,
      `product_configurator_setting.media.translation`.custom_fields AS `product_configurator_setting.media.translation.customFields`,
      `product_configurator_setting.media.translation`.created_at AS `product_configurator_setting.media.translation.createdAt`,
      `product_configurator_setting.media.translation`.updated_at AS `product_configurator_setting.media.translation.updatedAt`,
      `product_configurator_setting.media.translation`.media_id AS `product_configurator_setting.media.translation.mediaId`,
      `product_configurator_setting.media.translation`.language_id AS `product_configurator_setting.media.translation.languageId`
    FROM
      `media_translation` `product_configurator_setting.media.translation`
    WHERE
      `product_configurator_setting.media.translation`.language_id = ?
  ) `product_configurator_setting.media.media_translation` ON `product_configurator_setting.media.media_translation`.`media_id` = `product_configurator_setting.media`.`id`
WHERE
  (
    `product_configurator_setting`.`version_id` = ?
  )
  AND (
    (
      `product_configurator_setting`.`product_id` = ?
    )
  )

SELECT `product_configurator_setting`.`id` AS `product_configurator_setting.id`, `product_configurator_setting`.`version_id` AS `product_configurator_setting.versionId`, `product_configurator_setting`.`product_id` AS `product_configurator_setting.productId`, `product_configurator_setting`.`product_version_id` AS `product_configurator_setting.productVersionId`, `product_configurator_setting`.`media_id` AS `product_configurator_setting.mediaId`, `product_configurator_setting`.`property_group_option_id` AS `product_configurator_setting.optionId`, `product_configurator_setting`.`price` AS `product_configurator_setting.price`, `product_configurator_setting`.`position` AS `product_configurator_setting.position`, `product_configurator_setting`.`custom_fields` AS `product_configurator_setting.customFields`, `product_configurator_setting`.`created_at` AS `product_configurator_setting.createdAt`, `product_configurator_setting`.`updated_at` AS `product_configurator_setting.updatedAt`, `product_configurator_setting.option`.`id` AS `product_configurator_setting.option.id`, `product_configurator_setting.option`.`property_group_id` AS `product_configurator_setting.option.groupId`, `product_configurator_setting.option`.`color_hex_code` AS `product_configurator_setting.option.colorHexCode`, `product_configurator_setting.option`.`media_id` AS `product_configurator_setting.option.mediaId`, `product_configurator_setting.option`.`created_at` AS `product_configurator_setting.option.createdAt`, `product_configurator_setting.option`.`updated_at` AS `product_configurator_setting.option.updatedAt`, `product_configurator_setting.option.group`.`id` AS `product_configurator_setting.option.group.id`, `product_configurator_setting.option.group`.`display_type` AS `product_configurator_setting.option.group.displayType`, `product_configurator_setting.option.group`.`sorting_type` AS `product_configurator_setting.option.group.sortingType`, `product_configurator_setting.option.group`.`filterable` AS `product_configurator_setting.option.group.filterable`, `product_configurator_setting.option.group`.`visible_on_product_detail_page` AS `product_configurator_setting.option.group.visibleOnProductDetailPage`, `product_configurator_setting.option.group`.`created_at` AS `product_configurator_setting.option.group.createdAt`, `product_configurator_setting.option.group`.`updated_at` AS `product_configurator_setting.option.group.updatedAt`, `product_configurator_setting.option.group.translation.name`, COALESCE(`product_configurator_setting.option.group.translation.name`,`product_configurator_setting.option.group.translation.name`) AS `product_configurator_setting.option.group.name`, `product_configurator_setting.option.group.translation.description`, COALESCE(`product_configurator_setting.option.group.translation.description`,`product_configurator_setting.option.group.translation.description`) AS `product_configurator_setting.option.group.description`, `product_configurator_setting.option.group.translation.position`, COALESCE(`product_configurator_setting.option.group.translation.position`,`product_configurator_setting.option.group.translation.position`) AS `product_configurator_setting.option.group.position`, `product_configurator_setting.option.group.translation.customFields`, COALESCE(`product_configurator_setting.option.group.translation.customFields`,`product_configurator_setting.option.group.translation.customFields`) AS `product_configurator_setting.option.group.customFields`, `product_configurator_setting.option.group.translation.createdAt`, `product_configurator_setting.option.group.translation.updatedAt`, `product_configurator_setting.option.group.translation.propertyGroupId`, `product_configurator_setting.option.group.translation.languageId`, `product_configurator_setting.option.media`.`id` AS `product_configurator_setting.option.media.id`, `product_configurator_setting.option.media`.`user_id` AS `product_configurator_setting.option.media.userId`, `product_configurator_setting.option.media`.`media_folder_id` AS `product_configurator_setting.option.media.mediaFolderId`, `product_configurator_setting.option.media`.`mime_type` AS `product_configurator_setting.option.media.mimeType`, `product_configurator_setting.option.media`.`file_extension` AS `product_configurator_setting.option.media.fileExtension`, `product_configurator_setting.option.media`.`uploaded_at` AS `product_configurator_setting.option.media.uploadedAt`, `product_configurator_setting.option.media`.`file_name` AS `product_configurator_setting.option.media.fileName`, `product_configurator_setting.option.media`.`file_size` AS `product_configurator_setting.option.media.fileSize`, `product_configurator_setting.option.media`.`media_type` AS `product_configurator_setting.option.media.mediaTypeRaw`, `product_configurator_setting.option.media`.`meta_data` AS `product_configurator_setting.option.media.metaData`, `product_configurator_setting.option.media`.`config` AS `product_configurator_setting.option.media.config`, `product_configurator_setting.option.media`.`path` AS `product_configurator_setting.option.media.path`, `product_configurator_setting.option.media`.`private` AS `product_configurator_setting.option.media.private`, `product_configurator_setting.option.media`.`thumbnails_ro` AS `product_configurator_setting.option.media.thumbnailsRo`, `product_configurator_setting.option.media`.`created_at` AS `product_configurator_setting.option.media.createdAt`, `product_configurator_setting.option.media`.`updated_at` AS `product_configurator_setting.option.media.updatedAt`, `product_configurator_setting.option.media.translation.title`, COALESCE(`product_configurator_setting.option.media.translation.title`,`product_configurator_setting.option.media.translation.title`) AS `product_configurator_setting.option.media.title`, `product_configurator_setting.option.media.translation.alt`, COALESCE(`product_configurator_setting.option.media.translation.alt`,`product_configurator_setting.option.media.translation.alt`) AS `product_configurator_setting.option.media.alt`, `product_configurator_setting.option.media.translation.customFields`, COALESCE(`product_configurator_setting.option.media.translation.customFields`,`product_configurator_setting.option.media.translation.customFields`) AS `product_configurator_setting.option.media.customFields`, `product_configurator_setting.option.media.translation.createdAt`, `product_configurator_setting.option.media.translation.updatedAt`, `product_configurator_setting.option.media.translation.mediaId`, `product_configurator_setting.option.media.translation.languageId`, `product_configurator_setting.option.translation.name`, COALESCE(`product_configurator_setting.option.translation.name`,`product_configurator_setting.option.translation.name`) AS `product_configurator_setting.option.name`, `product_configurator_setting.option.translation.position`, COALESCE(`product_configurator_setting.option.translation.position`,`product_configurator_setting.option.translation.position`) AS `product_configurator_setting.option.position`, `product_configurator_setting.option.translation.customFields`, COALESCE(`product_configurator_setting.option.translation.customFields`,`product_configurator_setting.option.translation.customFields`) AS `product_configurator_setting.option.customFields`, `product_configurator_setting.option.translation.createdAt`, `product_configurator_setting.option.translation.updatedAt`, `product_configurator_setting.option.translation.propertyGroupOptionId`, `product_configurator_setting.option.translation.languageId`, `product_configurator_setting.media`.`id` AS `product_configurator_setting.media.id`, `product_configurator_setting.media`.`user_id` AS `product_configurator_setting.media.userId`, `product_configurator_setting.media`.`media_folder_id` AS `product_configurator_setting.media.mediaFolderId`, `product_configurator_setting.media`.`mime_type` AS `product_configurator_setting.media.mimeType`, `product_configurator_setting.media`.`file_extension` AS `product_configurator_setting.media.fileExtension`, `product_configurator_setting.media`.`uploaded_at` AS `product_configurator_setting.media.uploadedAt`, `product_configurator_setting.media`.`file_name` AS `product_configurator_setting.media.fileName`, `product_configurator_setting.media`.`file_size` AS `product_configurator_setting.media.fileSize`, `product_configurator_setting.media`.`media_type` AS `product_configurator_setting.media.mediaTypeRaw`, `product_configurator_setting.media`.`meta_data` AS `product_configurator_setting.media.metaData`, `product_configurator_setting.media`.`config` AS `product_configurator_setting.media.config`, `product_configurator_setting.media`.`path` AS `product_configurator_setting.media.path`, `product_configurator_setting.media`.`private` AS `product_configurator_setting.media.private`, `product_configurator_setting.media`.`thumbnails_ro` AS `product_configurator_setting.media.thumbnailsRo`, `product_configurator_setting.media`.`created_at` AS `product_configurator_setting.media.createdAt`, `product_configurator_setting.media`.`updated_at` AS `product_configurator_setting.media.updatedAt`, `product_configurator_setting.media.translation.title`, COALESCE(`product_configurator_setting.media.translation.title`,`product_configurator_setting.media.translation.title`) AS `product_configurator_setting.media.title`, `product_configurator_setting.media.translation.alt`, COALESCE(`product_configurator_setting.media.translation.alt`,`product_configurator_setting.media.translation.alt`) AS `product_configurator_setting.media.alt`, `product_configurator_setting.media.translation.customFields`, COALESCE(`product_configurator_setting.media.translation.customFields`,`product_configurator_setting.media.translation.customFields`) AS `product_configurator_setting.media.customFields`, `product_configurator_setting.media.translation.createdAt`, `product_configurator_setting.media.translation.updatedAt`, `product_configurator_setting.media.translation.mediaId`, `product_configurator_setting.media.translation.languageId` FROM `product_configurator_setting` LEFT JOIN `property_group_option` `product_configurator_setting.option` ON `product_configurator_setting`.`property_group_option_id` = `product_configurator_setting.option`.`id` LEFT JOIN `media` `product_configurator_setting.media` ON `product_configurator_setting`.`media_id` = `product_configurator_setting.media`.`id` LEFT JOIN (SELECT `product_configurator_setting.option.translation`.property_group_option_id, `product_configurator_setting.option.translation`.name AS `product_configurator_setting.option.translation.name`, `product_configurator_setting.option.translation`.position AS `product_configurator_setting.option.translation.position`, `product_configurator_setting.option.translation`.custom_fields AS `product_configurator_setting.option.translation.customFields`, `product_configurator_setting.option.translation`.created_at AS `product_configurator_setting.option.translation.createdAt`, `product_configurator_setting.option.translation`.updated_at AS `product_configurator_setting.option.translation.updatedAt`, `product_configurator_setting.option.translation`.property_group_option_id AS `product_configurator_setting.option.translation.propertyGroupOptionId`, `product_configurator_setting.option.translation`.language_id AS `product_configurator_setting.option.translation.languageId` FROM `property_group_option_translation` `product_configurator_setting.option.translation` WHERE `product_configurator_setting.option.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_configurator_setting.option.property_group_option_translation` ON `product_configurator_setting.option.property_group_option_translation`.`property_group_option_id` = `product_configurator_setting.option`.`id` LEFT JOIN `property_group` `product_configurator_setting.option.group` ON `product_configurator_setting.option`.`property_group_id` = `product_configurator_setting.option.group`.`id` LEFT JOIN `media` `product_configurator_setting.option.media` ON `product_configurator_setting.option`.`media_id` = `product_configurator_setting.option.media`.`id` LEFT JOIN (SELECT `product_configurator_setting.option.group.translation`.property_group_id, `product_configurator_setting.option.group.translation`.name AS `product_configurator_setting.option.group.translation.name`, `product_configurator_setting.option.group.translation`.description AS `product_configurator_setting.option.group.translation.description`, `product_configurator_setting.option.group.translation`.position AS `product_configurator_setting.option.group.translation.position`, `product_configurator_setting.option.group.translation`.custom_fields AS `product_configurator_setting.option.group.translation.customFields`, `product_configurator_setting.option.group.translation`.created_at AS `product_configurator_setting.option.group.translation.createdAt`, `product_configurator_setting.option.group.translation`.updated_at AS `product_configurator_setting.option.group.translation.updatedAt`, `product_configurator_setting.option.group.translation`.property_group_id AS `product_configurator_setting.option.group.translation.propertyGroupId`, `product_configurator_setting.option.group.translation`.language_id AS `product_configurator_setting.option.group.translation.languageId` FROM `property_group_translation` `product_configurator_setting.option.group.translation` WHERE `product_configurator_setting.option.group.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_configurator_setting.option.group.property_group_translation` ON `product_configurator_setting.option.group.property_group_translation`.`property_group_id` = `product_configurator_setting.option.group`.`id` LEFT JOIN (SELECT `product_configurator_setting.option.media.translation`.media_id, `product_configurator_setting.option.media.translation`.title AS `product_configurator_setting.option.media.translation.title`, `product_configurator_setting.option.media.translation`.alt AS `product_configurator_setting.option.media.translation.alt`, `product_configurator_setting.option.media.translation`.custom_fields AS `product_configurator_setting.option.media.translation.customFields`, `product_configurator_setting.option.media.translation`.created_at AS `product_configurator_setting.option.media.translation.createdAt`, `product_configurator_setting.option.media.translation`.updated_at AS `product_configurator_setting.option.media.translation.updatedAt`, `product_configurator_setting.option.media.translation`.media_id AS `product_configurator_setting.option.media.translation.mediaId`, `product_configurator_setting.option.media.translation`.language_id AS `product_configurator_setting.option.media.translation.languageId` FROM `media_translation` `product_configurator_setting.option.media.translation` WHERE `product_configurator_setting.option.media.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_configurator_setting.option.media.media_translation` ON `product_configurator_setting.option.media.media_translation`.`media_id` = `product_configurator_setting.option.media`.`id` LEFT JOIN (SELECT `product_configurator_setting.media.translation`.media_id, `product_configurator_setting.media.translation`.title AS `product_configurator_setting.media.translation.title`, `product_configurator_setting.media.translation`.alt AS `product_configurator_setting.media.translation.alt`, `product_configurator_setting.media.translation`.custom_fields AS `product_configurator_setting.media.translation.customFields`, `product_configurator_setting.media.translation`.created_at AS `product_configurator_setting.media.translation.createdAt`, `product_configurator_setting.media.translation`.updated_at AS `product_configurator_setting.media.translation.updatedAt`, `product_configurator_setting.media.translation`.media_id AS `product_configurator_setting.media.translation.mediaId`, `product_configurator_setting.media.translation`.language_id AS `product_configurator_setting.media.translation.languageId` FROM `media_translation` `product_configurator_setting.media.translation` WHERE `product_configurator_setting.media.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_configurator_setting.media.media_translation` ON `product_configurator_setting.media.media_translation`.`media_id` = `product_configurator_setting.media`.`id` WHERE (`product_configurator_setting`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_configurator_setting`.`product_id` = 0xA9BDD10EC07A43E3BD9FD666F678F06B));

# 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 ('/navigation/981f632046524fdbba6c78f19c78e9d6', '/navigation/a9e95c37394f4e5c8377de8c19ccefc7', '/navigation/6d88bc907b2d4d88aaa052f2a4ae6540', '/navigation/59edea3fa59743af8b5053a83b7a10b2', '/navigation/fe1651a24c7c48298f276eba2f8dd4d2', '/navigation/dab20c9e06b7430d8596275f0e586e19', '/navigation/7e4c968a77a44ac590e3c2123aafc939', '/navigation/89a0cffd122845639c794f46e722248f', '/navigation/bea4e1b0f6fb450593bce85864a469c8', '/navigation/a0c8ec422d2b4a029c221f6a302d18f6', '/navigation/15631507fdfd4213bb33307354bfa8f9', '/navigation/d7504c8dc70b47809302e5a183d21409', '/navigation/b9b2d1d357de49f5b2f4655bd3ed74d8', '/navigation/3f7546e699144d25a313cd069e5a035a', '/navigation/04c3bf7f62874d76b3a94c8a4caa671b', '/navigation/2c96c60fa41d412f9d11483b04855a7a', '/navigation/43a21a760caf46518424e69c58729548', '/navigation/47b7b344a6684aedb1efc363ea2e65f8', '/navigation/8d6fade9808f4b5e9847c5da21687ce1', '/navigation/c3835e5ffd984cfea46b72ba101830a8', '/navigation/78102a3e26894562a57e29a85937164d', '/navigation/b054253d02124f909967f453b2910286', '/navigation/b61c937e752b4f5188b057f0f2e664ac', '/navigation/69204ee08c9441d494d6cc94b92ff990', '/navigation/093a003c37894720843d44e1d973a82b', '/navigation/12f7ef929e684351b161bf186031d0ea', '/navigation/7e267daf3cd548cdb10ce0f0658b5351', '/navigation/57246dad15d1489294125a7ca591626f', '/navigation/262b0977ac63450aad07c7994eb2d5b0', '/navigation/91c69da68ddd4a598e8932fb138d8d46', '/navigation/ff856e894edd4837ad52df80c4c33e86', '/navigation/0e1f30bad4f04ff1994f670d5faaac21', '/navigation/791ceda9afa548e1af9f23ed3bf3fdd0', '/navigation/6ac2a0c74c3949808023e96576ab00e7', '/navigation/0f45691e5e424faba8db5b0201613e67', '/navigation/cf70d2e92dff4d608e8882d86be6a0b5', '/navigation/915d7fecd88143dc90c2e3009d920433', '/navigation/6baf36fdfa6d4054bb9125d581746744', '/navigation/fb59a860dd7f49c18436609ffdb27490', '/navigation/516af5753f934284a2ac88ef1e8fc8d0', '/navigation/aff24a18fb95481db2cace5f6577d7a3', '/navigation/eba7f96c66904e3bb73bcea188e4e64d', '/navigation/338af4c3417741ba831df68dc3e6d18a', '/navigation/70d34363940d488992fdf8be6f19a86f', '/navigation/ec321e24703d4e90b98a311a1ed4e492', '/navigation/562f1e4867964e1182f20172c6518be5', '/navigation/57f5d2f7613d43f2bdec11e8debe251b', '/navigation/b7aebe47d5424b0ba1ceb45a79ad6484', '/navigation/d42fa89d580545278d7e6fc4a6c0e6ce', '/navigation/12ea8ec018a6410aaea00ac4c4beb418', '/navigation/eb1b57ea772f42f7bf4e6fd2e99c592e', '/navigation/691e6f5a832d48b1bd9a059916e51c5c', '/navigation/c096b6a7619f4e56bebd9e46c5a0319a', '/navigation/1892699ecc454ccd9fee9670f05d9dea', '/navigation/b8e468f6328c4f79bbb4d91c0362185d', '/navigation/a1da6f4b364c42afa8d8ddaf3450a4aa', '/navigation/c6ba40d7942740d2910fe391c65835cc', '/navigation/6d0670380aef4646a9d3a1ad53430a70', '/detail/a74c7eb204fc464bbf7d7476d0cd2e6d', '/detail/7da715f9a393438b8da1282c72a248f6', '/detail/0e66d5e640384901b562f97fe54fbfbe', '/detail/12abe0916d364d73929e47026f1d98a6', '/detail/e28fa50d94964551bf754e09c4bb338b', '/detail/72a2b521c79d4e44b994dbd80dfc9bb9', '/detail/9e829b549990495b80b18d88d26ab6df', '/detail/f3d35cadd097415e8f7a1c6422cbf102', '/detail/2fbd491b821d4292a610d069e034e56a', '/detail/3cfa41f0192c4086a29de6aac163877f', '/detail/71b430dd08a7480395713450b2c5affa', '/detail/915ae6a8a9ab4d248c48ecab11b99080', '/detail/f3013e5db1e64f87b79595eb6387698a', '/detail/a8ef9e1d14ab49739460ee9089f76a84', '/detail/7810a2d0e06d415d909e20ece828924e', '/detail/9e69506cceca4754ab6eececf22e039d', '/detail/00ecb2d1b6474aa5b2d4ce806f402513', '/detail/403d10503ba041dcb0d20cca5e9f36f4', '/detail/144fa85e990d484596c53b5728a87eb3', '/detail/53e47c7107be4009b09c37d00d271e5c', '/detail/974c6792900f42ed8f683ebf02ef9c8b', '/detail/4f788181a66f4592b6439262130727bc', '/detail/53cb89c964ee45cfb2d08a4cf94b434b', '/detail/209125446911408393273f407eb84a82', '/detail/aaddff6e2abd4c7bbd2034b342e437af', '/detail/0f7e2a8f469a40aa806eb1e6dc298ee3', '/detail/f9dd58168f8d416ca2a33817049679b6', '/detail/28f8bebe6084402facc5ba9d6162875a', '/detail/df4267125c4a4354bba0c3a766eaf7e9', '/detail/331ff5bdf3b5446e91ce3878870caa9f', '/detail/058fe7c98e06469cbcbabff62399cfcf', '/detail/47ec7320207c479096b8a8e5af6d60a3', '/detail/6f04fcce132340aa995ba448ccd80f4a', '/detail/a6a649f73e924d73a322bf7de87c9b50', '/detail/73e488768de14cf9a2c352c171bdda06', '/detail/e9479adf75dd42b2873c8046146065d3', '/detail/e70a6db7a9494f4bab19045d257e6097', '/detail/d06c2e57ded7452799fd92f977b0e235', '/detail/aefb4ace739f40b5a7b843fef55255a3', '/detail/bec7011f742e4522bd0725eef3ca7991', '/detail/8eaa62e32b3a4e4f93d6e0f0839e5b11', '/detail/da3f9e68f52a4f5da1bda7d686bf1fed', '/detail/1bea3ab224414846b2f6412bd157d1c3', '/detail/bf7c26eb32984c5b995532925ded3c2a', '/detail/729f0803730942a5bc7385c71d6e97db', '/detail/f9baa44add6b4e038581b449cd9b5048', '/detail/f93d6ed062a24dd7bc351a37c4d900da', '/detail/b0f58f3327e441e9a3426c790ac88c3c', '/detail/afb53509a5144d51af1a84c50b8a9a3c', '/detail/2c25e169fb7c48d89ae9853cc1b9c322', '/detail/7356d60762e346e9b50cc866ac7c6aac', '/detail/967b24d556dc4b3aa1f2b65b188d9e8e', '/detail/432fcdf76797413283cd821c89e525e4', '/detail/817a40dfe5c9471eabef5f8484a9f95b', '/detail/00fc3558c09a409f99d56f2f3cd47182', '/detail/296eff2105434211bb830c218a11469a', '/detail/5c4a57ba375c4dd28e86e23e222cdb43', '/detail/9dd23b5dd21b4269afa2d6d9f90e723e', '/detail/3fc4d2402fee4b659263216f9efe894c', '/detail/9e5f86f71a4c4514b7d6b780b21a7f0d', '/detail/55cdfa089c314a0a88efa7dd3755178e', '/detail/19c09aca85b94f50a62b26a14a586a39', '/detail/feb93b0c57e44cc99b2a87bdc75e5ac9', '/detail/27e8e6c6015343bda92cbcb103c3342d', '/detail/12e348203572487c9b6bfcfe442bbe23', '/detail/65cbc085265a47ad99e56a7d192ec299', '/detail/c484278317df42fbbce8f6660cbc33ad', '/detail/b702df89a54c48d5b4686f63431b889f', '/detail/56cb10f894c84f78a14604870c92e6b9', '/detail/18550dea315043b8a99adbf9a50f0341', '/detail/5161bcc0c61e41c59993cd8ffcf34644', '/detail/3ec2a280b26e430390069fd6aaa084ab', '/detail/d16147f25d644dcbbe0da6889e961c44', '/detail/c0b405eb8c5d4683a5befda34885f438', '/detail/f62778f55ca7479b86342b23d4acc11e', '/detail/52cbad5b99434d97b6171f833b1e3026', '/detail/257fa6a1ac8c42e999b05f2c9fad0c73', '/detail/27333d01e5a54938ab9f1ddfd8a4522c', '/detail/44021987c6e5403ea03664657f216f5b', '/detail/e2b03be456ac4ab3a2db55d531603f31', '/detail/8f9257d95eca4a8caac9883ddba1eecb', '/detail/2ffe491837224756b965834815cb780c', '/detail/48d6ed44a5f0477e9f004ca89b0524de', '/detail/735a5b47dae64707bfc2d72658f29b14', '/detail/da76e2bb94af40d89c8141e0a821b83c', '/detail/ecf1d37d616c4422b6abe97e41352378', '/detail/e27c067320294c9889382a6cd697dac0', '/detail/39ee722f316844a790e6a13210d1c0b7', '/detail/c78087efe7334c7a8cf4a597194ed743', '/detail/1714b701fa13409995fd032cfd7d455f', '/detail/07f1f4bafeb447ea86a90bdef708a330', '/detail/e5a9aeb898f545988e254d667e62a70c', '/detail/eb81b4cbf3f34903aa2e37a225a9e941', '/detail/0a158795c8ad494083fa784c62b39500', '/detail/5ae4d61bc7e449f89874def4508afc84', '/detail/d5ec776ccbc244f19abf1392892ba769', '/detail/23c4536d2b0547c4abe26ffed2bedfa6', '/detail/b5c7fe98c28e4d92b5401fad0e435319', '/detail/8c75073e84304c139980d049b9762b8f', '/detail/3a79ea44acd048ffb37ddece60c547ed', '/detail/ae0fd9213d48410f9d2f9f726650e6f4', '/detail/babe99b35a09488facbc4b6586d536f0', '/detail/3138ca7ed3974608921ceef8c69b7d9b', '/detail/c139a7becfc94718b9ba07ae9079f250', '/detail/51bba002d2e2489a8a19b2051a8913df', '/detail/a3cd87a7b77f41238f3a072550cd2e05', '/detail/36b05092614b428eb0c9f0ac9fff1530', '/detail/7eac1524cebf418ab67987e5612c19af', '/detail/db6a407a30db40fbb185bc3dcdd932b7', '/detail/5b845fd29b2445d99421ac8ad3578f94', '/detail/51854a30de2b44d28954fbfadf7a02a4', '/detail/e0fdb66d65ed406a8dbdd612560e4fa4', '/detail/5391b2ae8148403ebb40cc1faa61b86e', '/detail/cdd2ffc0ddfd4825bca0f96d13d82dc6', '/detail/9030c8e4241b458f9e548b5c4d4289ed', '/detail/ce509466a8cc409fa7956f7c3934db12', '/detail/029347b8049f4885abfe0274a0385ad5', '/detail/3ccd9f392a0246589d4658310fb282e8', '/detail/bb21185ee1c046188fd108949c065522', '/detail/b99dfd2fece94b95beaeeffd818097b8', '/detail/6bdd29649b8744d183cb3a9f0973fbca', '/detail/db91d62970ce46bbb9ddc683129ed27d', '/detail/06e0f033951a48cc93762f2de94bc607', '/detail/8503255937a443e2932820449a6e1fbf', '/detail/9dcfb3428a7f4640895d22c73a8893ea', '/detail/0fb820ae0d4944b581ae8adf9196e71d', '/detail/6c009b78d8554832996900203fd64d76', '/detail/90609e01e6674421a496d0f70c52dce2', '/detail/4bb3b77cb4be40d4be0c5fd92c1b606d', '/detail/df6fa5e7f52144f3ac67c0cccc71251e', '/detail/bff55f64e4a24d6fa00d4603e2135dc6', '/detail/490838eb3f9c4a858a4da6be612b5acc', '/detail/dd2dfadc01904f0f862a0185838233c0', '/detail/c0801eeedcab4190bc4692089bcbe25e', '/detail/078f4dfa7e184524bc1035ca3a1e4a2a', '/detail/e2b1f7d3c2824e66badd2b9e2dd0beb3', '/detail/6b9ba1f93c88425daebfc6bbdae00f31', '/detail/9989a29dded4458fa1bda66e75eddf4b', '/detail/96cecb64b256493ea55524c4490286cf', '/detail/5b3539a4a07e4f868ce4fdcfa55739fc', '/detail/6de3310a7f26421dbe70af7d05294be7', '/detail/227fdf86e54f46238d2171e316df0c53', '/detail/07c21aa6a55e4167b3a5ccb578feb7c8', '/detail/e3ede345f5bc4bcd8e6ed48ceb3e8334', '/detail/3cdc75ccef69477cab255844c42d55dd', '/detail/fd772ed4483940df8611df189d9ea838', '/detail/e6f597387c6a4d9b99a76d6b937de9e5', '/detail/0ed006ae28074cdf9114893cf821b2e3', '/detail/d3d1aa40b92741739d96ba20d8707ca4', '/detail/7493f634e31a4cf699a592704945ba97', '/detail/16a82cd0bb8b4bf59f842dffd19ee3f6', '/detail/a5636a3ccbab438199d9007de68af6ac', '/detail/36be015bbb554e96aa402adaba9275bb', '/detail/8b5d762ad6fc4195be2cb2c492ecfe4f', '/detail/5eb0d0eed2ae43a9a42dec1dd4ad887c', '/detail/53326f70872c4ab1b9c78715a40d4077', '/detail/b72b1ac86daf47a194dd778dec913e76', '/detail/a386342375ea4d54b93c1bf99282eb80', '/detail/a8e139e1a3b24451987b3cf8c4c76eb4', '/detail/d1f202530a0e49a7a417d80ec9d8fe11', '/detail/88ad6909a200423980a69b3137a92403', '/detail/a15b55220bbd4bbb876ee25fe86e4692', '/detail/39e2397905a84bb1a0af30557c5833d5', '/detail/7d38ba12869d46669cab2c68230a4bfd', '/detail/3ee63832c3844b83a23d02d5c005b107', '/detail/e901682a8b974cf6b41093c582733119', '/detail/db31044127d74c66b16003d5f7ffab01', '/detail/3e6451d144664b8a88f0d15dc3a69ad7', '/detail/d25f8eb7b63e4ebaa7309cc48a8e7317', '/detail/65b0c50cf51e4ea3809b2a9e42fbbfde', '/detail/61a9d32949bf4d958fabdfd539863bc0', '/detail/d23b1d461dd84fd6b6803e39e0db3019', '/detail/e3f947762bdf4ca088372307332347b7', '/detail/a4dabb1f649d4e2c90cf3e2d5b4eb40d', '/detail/79d9260d9ee640d684764514b13d85de', '/detail/a0e3b520f86f4f2790582063462b988a', '/detail/d4b90737b35d4dcc8f16938c2a3063e9', '/detail/f8ff4a3028ac4cd0881497310623312e', '/detail/eafb6b054ae8484bacb7d39565147255', '/detail/f2dcfb87ef4d404c85986a493d5275ed', '/detail/92cc47fff898469d84f9d1eedc86ac56', '/detail/d9b2808ffc134a3da26f631fa646eb2e', '/detail/e6e970c4140e469fb8c57c859eb4c780', '/detail/83bbbed2e4214e93b7d87ee5c0df3820', '/detail/96f12ad446fc4c248e69d21292bb3744', '/detail/252423c2ef344b0ba6aa6ee7ae30d753', '/detail/f37525771e444954802de143b623d681', '/detail/05f8cdb57bb14f85b31261656b726aa4', '/detail/dfe20c6a1dec495aade966fba9e8e77b', '/detail/fa53f6f03f7f4be695b7427ec073b1b0', '/detail/1323fd226c3b4cb68c09674808a77ec7', '/detail/3379d143f03a4fbe850613ed7d090cf1', '/detail/07ea0da0379e429f8d87cd9acf9dc4ec', '/detail/ff9d445c8f0447048444fae96a669186', '/detail/20fe2d0d6a2e40f9b41f64d5119f9ee5', '/detail/0fb806bcefec469892c48d50c03ca068', '/detail/598ce1d62eb0404a91751fae57ff307c', '/detail/151b45807dc844b8a497074d6d3af73c', '/detail/8d4c7aa91cf0444d908d2c31bc68e9d3', '/detail/7aba848745994e42ba16785206e1a02a', '/detail/1bc4b469ca904afbbcf0cf2e3cc607a4', '/detail/c7caaacc35284f24a636e5c008c31924', '/detail/15bea8b02bde4bf69d202b975511573e', '/detail/f4646ded8eaf4ae0b0e53a35e8726891', '/detail/8ea00367283c4da885347628c6bc0436', '/detail/512eb8fd00bd4f03964da71e7efbd4b2', '/detail/3961ea9565c5439db6258c083ad2bae2', '/detail/9d6bd2d6606a4bec84974017cbf1e1ab', '/detail/5a3f5d7fb09c483fb47f450abc1e2ef9', '/detail/d92cd8957f6b48918895b3c807f83f64', '/detail/c52792bec7a546699410e2c221a7f670', '/detail/1899d92e82214a8db9b2c4d2145cc075', '/detail/697e51ff4bc448799ec931d085606be0', '/detail/804656d3dfcb4a4b8f7e29935e44d63d', '/detail/e62bf308f4d54436820e22e80c98570e', '/detail/e4e3e88416214e018e110adbb4a8108c', '/detail/e7f6fa6ef87249b39b2e6699e54094ba', '/detail/4c2dcb005cea48f58e451ad040f17456', '/detail/4ea2123ca84f4d26b6af911709fb50ec', '/detail/43b69e1347314843805a231afbd49bcf', '/detail/3950efa188474d4284e5422d9cba6a0f', '/detail/b8dcb2b85a7c4875b11af2b3c7cd8f4f', '/detail/6c414ffcb50e46f498b491d304c41425', '/detail/bf9de3f6fec746b981251a0d7f67f565', '/detail/c13c5ed4cceb44d28b79f7003948cc6e', '/detail/3f4ac5e1aa3e419fbe2447cfa7ee58fa', '/detail/6585dd0d04744cbdb0f12b7a20bebbf7', '/detail/5b2be62fc3e74ca4afacef4ff34df4e3', '/detail/cfad74f6f91b4e3eab706f1efcc55014', '/detail/97612478b36447aca92c4b3fd9cc7582', '/detail/7c690a48642e4849b3752cad13c26519', '/detail/9b65c8dbb69a4011b69874517d43a307', '/detail/605a8a9ae858441995a587db4cdea0cd', '/detail/d1b27e25ab1646888d7a67597e57cb73', '/detail/47662f4e03fe483f920bb545b10d7723', '/detail/9f38bc5b725942ee80181d67e2cd41d5', '/detail/d161a628a9604326bfceb121f5fd3253', '/detail/0f213e571b984c62918c9687ca431908', '/detail/514269928a5d43a49d8215cc472f6aca', '/detail/caa68b4420184d78b43979f3f2790b73', '/detail/f960ac039afb46dc8cc0df3005a85ca9', '/detail/546244ffc1784a11933962476aff1708', '/detail/bda17e5a96a94df2a6fb4578ba37c604', '/detail/825d4f18240b4edcb1773fd4f3d097ef', '/detail/2d12bc2c63c94d46b9dbda069ed91517', '/detail/11cd227cec554959b4716cd83576e210', '/detail/8e1ec114393d4c159520de36e7b06209', '/detail/45936c7f6d974270bba5700e30876e5e', '/detail/3a34306f6da2432e925c843678320e5a', '/detail/9bf131b1f79e445fb1a908d0d2df8149', '/detail/35b597a18f094947a94bac869ccf3b45', '/detail/19f296869cf04763846acc20f07c55f5', '/detail/421f936f3fd74cc8a1bdfa50bb55b9da', '/detail/fa5664937f6f413ea50ef88ba2d93dae', '/detail/b578d8fd80c04b8dbd7bceda54bc3354', '/detail/6ae8edd62aae44e4b6be20ccf7b069ee', '/detail/7300d4f11ee14c2a860d74743e8c3e7f', '/detail/3368eef0820f4784a5ed20eb253c87e8', '/detail/29e60c79036c43359aa0af592d728d15', '/detail/c64d247ef53943e78379d28969cf98a6', '/detail/62306c69d13c4654a6cd5f780b928e35', '/detail/b222d9c3838945e89bb2d5b3fc4d15da', '/detail/fbad50f1f4c8483bb48479cb498b8d3a', '/detail/36f8a2ccb7464006aa2d1f6b227bca17', '/detail/32ae3e99158344f99b1a67b82ae55cbb', '/detail/d5c991b97bee46fdb8e06015c3f77935', '/detail/e078e3f0e3214f39bdd5efa885c33e1e', '/detail/6a8a4d092ea1499eb64efc4031e230be', '/detail/8d3287614c7745dda9287441c19232bb', '/detail/889757f5a75d45ce93ebc744a6337138', '/detail/347b4c132a01423cb4ad4f597d56d237', '/detail/966765479be04fb59cfe0dd661d7b88c', '/detail/8b3ffedb30164ab4acc57e41a3136209', '/detail/ee468fea672644df8bfca8da7752ad49', '/detail/4976d26b4d144ff58b9f16c426810798', '/detail/473876a37d7b4940a71b34f618ba3899', '/detail/e1436c23d5cb41ffbb7fd938a6224a6e', '/detail/828826d9f765411fb3f688a28dfaf7e9', '/detail/5c012670b535441fb86be7509aa5ed92', '/detail/826721d3d46a44648cee6c09cd94aa87', '/detail/e0f94780df1f425fa6be49a89eda1aca', '/detail/8d27a9dcb1ff46a5be5fa58f1b2b59f5', '/detail/c72a81653d364a87babb3063a95dd3a6', '/detail/b8ac5275571b4ad6b8f02251bfff924f', '/detail/92a710c9446d4bc7ac64d3934c333295', '/detail/0e9cabd9deb94cb8b7ad99002b5b7d4a', '/detail/e4e9c0420c814af1b8f77b4dcfdddece', '/detail/92ddf1a3d62444abb8dad3c8d1d2ee2c', '/detail/685fb5db70344659b21f60c39eb491f5', '/detail/b9c0cc197fdd464eb6bdbe2c0574f474', '/detail/ac56940a1e834728b3c4bfaea033c870', '/detail/a9d8f1197d49418885969c99621b47c1', '/detail/f1721dc38b9547a79ef8ba89d57ab8a4', '/detail/43ea99ee7eef4a1aa3eb1d323fc2cd57', '/detail/5a147f1fcc6449c7b622daf2e0da0029', '/detail/60b8fc9278984234a143eaf0be34feaa', '/navigation/4a35fb5a1b5948f281b932808add75e4', '/navigation/28bdc9a4ed444216a3dacc55c1318f34', '/navigation/cf86d26362ad4169a6aa424f9db5b901', '/navigation/960cf93686cd423183d2e2a339b4990e', '/navigation/6476605ef9eb4d3fad0c9e83c2d06518', '/navigation/0d14a7d404de4c4390a801d38b4651e3', '/navigation/78f65084c61a406c83b98dd25bdb041d')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x67D79825561D4007A766D27CBBF1BDF6 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

SELECT
  LOWER(
    HEX(product.id)
  ),
  product.option_ids AS options,
  product.product_number AS productNumber,
  product.available
FROM
  product
  LEFT JOIN product parent ON product.parent_id = parent.id
  INNER JOIN product_visibility visibilities ON product.visibilities = visibilities.product_id
WHERE
  (product.parent_id = ?)
  AND (product.version_id = ?)
  AND (
    IFNULL(product.active, parent.active) = ?
  )
  AND (product.option_ids IS NOT NULL)
  AND (
    visibilities.sales_channel_id = ?
  )

SELECT LOWER(HEX(product.id)), product.option_ids AS options, product.product_number AS productNumber, product.available FROM product LEFT JOIN product parent ON product.parent_id = parent.id INNER JOIN product_visibility visibilities ON product.visibilities = visibilities.product_id WHERE (product.parent_id = 0xA9BDD10EC07A43E3BD9FD666F678F06B) AND (product.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (IFNULL(product.active, parent.active) = 1) AND (product.option_ids IS NOT NULL) AND (visibilities.sales_channel_id = 0x67D79825561D4007A766D27CBBF1BDF6);