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` = 0xCF8C8986B9BB4DCAB0EE7D1CBE016EED 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` = 0xCF8C8986B9BB4DCAB0EE7D1CBE016EED));

# 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/eb1b57ea772f42f7bf4e6fd2e99c592e', '/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/981f632046524fdbba6c78f19c78e9d6', '/navigation/b7aebe47d5424b0ba1ceb45a79ad6484', '/navigation/d42fa89d580545278d7e6fc4a6c0e6ce', '/navigation/12ea8ec018a6410aaea00ac4c4beb418', '/navigation/691e6f5a832d48b1bd9a059916e51c5c', '/navigation/c096b6a7619f4e56bebd9e46c5a0319a', '/navigation/1892699ecc454ccd9fee9670f05d9dea', '/navigation/b8e468f6328c4f79bbb4d91c0362185d', '/navigation/a1da6f4b364c42afa8d8ddaf3450a4aa', '/navigation/c6ba40d7942740d2910fe391c65835cc', '/navigation/6d0670380aef4646a9d3a1ad53430a70', '/detail/f996d970d6474d43847d0a9d619f6168', '/detail/547a5938dce64e51a4dcfefd66ea7cf4', '/detail/29063a80a4704e8f867b96fee1d8aee1', '/detail/61eb92cd59db402781e30aef97157dcc', '/detail/e5bf1035d73d45b583001289b6504e41', '/detail/011e9c7a25fe4986b9e59b63ae4b4953', '/detail/f128d8598e4741e6ae830c2b142fdcb6', '/detail/b6e7e91d72d54ab6952eff071cf588e9', '/detail/c8946b4ebefc4bd3921cdfec4c202600', '/detail/91160bd8c5154339ac3c492b777348f1', '/detail/60724ba5350942f2bee1ce2af07c393e', '/detail/e50f04bda74d4a679229c1fe178523d7', '/detail/6e6725bc2ccd4e79aeb609d7b1afdf7f', '/detail/7b212fa523e14608a308f63f100234fc', '/detail/cb781e8b9a58473e9616ddfdbb7eef4b', '/detail/666cddcb082d4378a0b289bb747c13e6', '/detail/314ad842f31b41029b44595c202c53bf', '/detail/17810bc411f34d319a9d09680f74148a', '/detail/dc37adf075fb4328880c0a93838cb572', '/detail/d417cc9693654a4f8163a26b10fe0c53', '/detail/5922cd216506447e8306baa4318b3db0', '/detail/e3eb5e4cba9f4e1593cc8f5f73b78c5e', '/detail/996ac829972649dd9cd7836ae20b0c11', '/detail/a30f3d9b7f0e4a7d87f7880409eeee9a', '/detail/a79fe1d2b7a24cb6b6ffe04fd653d85b', '/detail/bf3a219bb76f4805b847e383cd245eea', '/detail/ac80d7fae3ea4ac9af22cec4895e8f46', '/detail/72b4864044624cd4af0f0ae7413b8115', '/detail/d30fa0a0e194431dae60c4988d09cacf', '/detail/73b297524e7944e78b225579a739ea9d', '/detail/fc6f68824db046519589dbc778e5367f', '/detail/71af066a1934468aa7c1a10c116d4077', '/detail/b93b83d98ff64e4fb312c42d0833e9c5', '/detail/09a20141503641ce8bb544d9a3bedaa9', '/detail/7947a3c01ba8469aa197b3b5fbf9ae1a', '/detail/b1911b15f6cf4c26bf1229e3cd1a3b34', '/detail/e4c43694f34540f8bb7758f4720861e2', '/detail/d321b10f538a42b8b3d53468c7e4ad43', '/detail/b2e7a3127e7347689cca3b87ea5e8581', '/detail/6a72bf4900bb41389ed49a1cad9dec30', '/detail/0ff5aad1954842e99f0ff42a38cf4b5d', '/detail/1850f4f63db647c38164790a41d25584', '/detail/443cfaa3c4cc443e9a323b73faf97168', '/detail/1ec9e1dde9b6480da7349472176f5347', '/detail/142dd1897b5d41fb929d97987f4ba3dc', '/detail/9dcf84e923654fbfa9410bc0e5ea7fb0', '/detail/50644e88ad344cec806ee297c7d284e8', '/detail/da96197d0928479cbe5e36c400152ec4', '/detail/f162301f8d31456f82311a27250e335e', '/detail/41eab18f79494ab9958a4619426bb01b', '/detail/37ee336103a4461f916f815eee8db8e1', '/detail/9f7715a07faa4177a24d25759e9affdc', '/detail/b7927035a8154ccf81d2e4208f4ffed1', '/detail/4946044f7cf644ef99238c0a35b375e8', '/detail/1a05486f565b4adf88e2bba43df00dee', '/detail/b2a64fa9d5c14b95bd662babaa78a0f3', '/detail/a2c6a7cdd248403ea5db4b22e321604f', '/detail/9cf62830a4384b768459caa8076e358a', '/detail/aa4b5b8768bc491c952340fa2ea44de7', '/detail/382c939aba2c45adaf4a12cb479e993e', '/detail/92f3a8462b104c86882eea941613a946', '/detail/32d09469ca904900ab57d973ef4a4060', '/detail/078e62c50fce4977929fa3726635d9e4', '/detail/94f524267bd344959afeeedb29380d20', '/detail/00ed8b371e0246168cac5874af7ad0cf', '/detail/d18c413983c448d8bfd2196edb5e32b8', '/detail/be7a9d68edee40aaaaa6da8fd6bc4f08', '/detail/7d94a133f1864a44bc5c5a1c95f74dcd', '/detail/eb1f369d3cc7449da4987d5b087f2543', '/detail/9a54d61d013a4fa2bfc654f4b10e8bc0', '/detail/d11c772e063f44b8aaae48dff043068f', '/detail/c88f5d0ea1f647e9b578f6093230335e', '/detail/1b5895fac7f548febb57ee6767cfc03b', '/detail/e8aea5fc4ab340c0b52ad5a8746ba56a', '/detail/ff584bf56ee148b4b08aa7e207353d3d', '/detail/78f5a6d8ee5b466989a4028a11c2cac7', '/detail/d9e5fa2a61bd4bb590c40470e67be574', '/detail/47a437857be6401daaf53276111c4885', '/detail/033cc663722a4291b6f6138f19061b61', '/detail/f4f0d8e118a74989ac686c35a0b0587e', '/detail/658864485d714d00ae6ed833802c2be8', '/detail/7943fc128dfd4f31b1d959d2a7d8a828', '/detail/08ea507bea6546c5b86ee85a70de6018', '/detail/b24e24ec4ecd4c7b9629eb40fdf58fd9', '/detail/05d75769d60c4d6a9d3131ec5df10be2', '/detail/28349ae4c3be4282acfcdfcee8a7e651', '/detail/dfc12de1e656444b8362a04c90e9b5e7', '/detail/03d46d4ffe354882934421fceb891811', '/detail/f3a9e3b8f832475aa9ec274c6ac1bb90', '/detail/8d7f302a7f8d40a88a2c277b60186681', '/detail/9c57d448846d43f3a7466c958f019cb7', '/detail/46c46b7c12694031a1053fc7da20cbd8', '/detail/05c47fafdd304e05be58e0ff5cca03c7', '/detail/fc2d0fd5cbe14420bb1a1f5036b80d50', '/detail/2f3d471dbdb94bd3ba0e1e954cac07aa', '/detail/b6797e74b071435d932914a881d5ab8e', '/detail/8407202e23114599a2f1809671407425', '/detail/ae381920de894891b6b7b44fbf932cad', '/detail/b3b66ec0f96240ffa8396a547276ebac', '/detail/5c3f7593f2174b6bb9927a69cc294113', '/detail/0d01454be56b408b8e1799a3c44862bf', '/detail/062d6e710f39478786c81f7449bb72b9', '/detail/84025a264e514f1688fd8858ba82e28c', '/detail/939ed178ca924c5a83d5f6f32b70e47f', '/detail/5312a5d6df1b4eaab61499a29e02c635', '/detail/dec7dcb82ab247a5aee0def1e2079f93', '/detail/a1f5b93481044eebb633d6d1f21a83d6', '/detail/d29c27afca4a48a1abc43fca37f06364', '/detail/2e2a68eac7d14870a687fee846b05039', '/detail/655c2ef18a5b4e51996651ada3588347', '/detail/0db572d5127d46eb9f71b2839b9889d7', '/detail/787d13a883dc495a9218db1839a7638c', '/detail/3f26d287b95a4260a937519fd4f87d1b', '/detail/9556de04df5a42a98c2c7dcf4f6bd86c', '/detail/1364053b92e94677a43cda681b986938', '/detail/6ffe38d6040b4a7c9c62a75f332d294a', '/detail/e9384c2311524790aee1a8c1ac46969b', '/detail/35772b837178404d95f37c8f2dc05275', '/detail/7dad70a7c5b34969a1e1de96975e818b', '/detail/21fe92feaedd4d8d823a5fcdfb1a0845', '/detail/98687bdaa9b842e7bf561110e4e929f7', '/detail/516af1bb381b4504b05950ad8c11f1c8', '/detail/cd5255c2a8ec4741918b4e845abe39c3', '/detail/494e24cb3b344d58a483ab328e893bfe', '/detail/f434646c3c644afd9a0d83e3fc56f7c3', '/detail/f31212b984114bc9bec1fa6eddf36319', '/detail/f8fca0d8a4f143f5920c2872ecaabc9f', '/detail/3bd7eadd18f749bf853f74b3c6d72284', '/detail/2cf6b917494543fbaa85ca1019e5e4b6', '/detail/88d85e20a01148299272969a71183f51', '/detail/adaeaca5261a4d62a03da29db22353c6', '/detail/dd6f8b106ef94dce8f7492ac645c7c79', '/detail/d7b393fe963a48a385a44d93a109fc54', '/detail/4dd62882a22d4566b6df24bd0c324265', '/detail/2d1e1475c8e748c0b72ae0f0d9fac92c', '/detail/d209c6321b1d4bb58ac375692946f244', '/detail/d3ad35a484d947e8ae8652b44a60d201', '/detail/711afd1837b44de0b293df431fe0f61e', '/detail/822d775cd8094e5c92ffbeb443e88c27', '/detail/17b798a6e86a4870bf01e18d9e316137', '/detail/00229ea6c5f448dbb8e5e287186404dc', '/detail/9020383983b64caeac97012613b2a16d', '/detail/5f0d2b1108e84127a5376b71b7f23161', '/detail/6ed3037a0cc541de893f8d98d2f325d5', '/detail/c6adbc29412941c1a423d3df531c2f17', '/detail/9c3d23a7eaa543f6af8c6b0eafd41168', '/detail/d6155e52cad04eaf8eaba60a9ae92d1a', '/detail/f10a0d1f09524998abb074bfbe836296', '/detail/f62f3cf415584a278ad6e22cea551112', '/detail/7b61f9e8760d4821abdb8f677c02179c', '/detail/af8c023be2774dd6843c17e78690bc8b', '/detail/63a3e0863604497d85afc9468e5e2c51', '/detail/893e12a532d3459fae3a37015e66ee89', '/detail/76a8764b58f34faa86642d2cc9902529', '/detail/f1ebd49c1bae48ecacb7d8bc730a2c73', '/detail/d02c6a54ec80411a85624ec22911b0eb', '/detail/a19ef25f5d214a4ab9d9850502f5f260', '/detail/9406cfbe69e24071a0bde3e7cff90a38', '/detail/c220f1fcbfee4c0a8b8220519c72df74', '/detail/0071652ea0ab4679affb5867488b4c11', '/detail/49b5725d53f44f9997d4471994b354a3', '/detail/ec1113a48f4147cdb985a6fbef643094', '/detail/06a7f0f9f6d743ad88f4592b302cd61d', '/detail/98689d27eb8443f4ab0b0cdc33a7d440', '/detail/45ed4b9c21004a04b0be36ce2d3b9f9d', '/detail/eb755468c35547c98feb2568173dbea2', '/detail/1044e5a78bc543218f3db509b08fe170', '/detail/0803711503b34107b6e10d044aab3590', '/detail/745d14d60cbd40439a83ba2dc15ed358', '/detail/e5ba5cdadda7443da89337ce39e5e85c', '/detail/cc45cc470bd14ac2aa33075bc6313434', '/detail/7d6302aa4e794624ba6727871292bd7e', '/detail/517f7fcba5824c54bdad2e34d9a2cfae', '/detail/928cf273d1f341aa94bbf6e589b99237', '/detail/cc2895d34d6948f4aaf06fd1c33ee643', '/detail/33bda5934db1411da046151c4439690a', '/detail/43383a8e8b5a4bd0b1a85246a6ead5d8', '/detail/097696adb2b14ed1bc5e7161c5612c2e', '/detail/dd44513ce569457eb707b2f1c87b2817', '/detail/faf3a231ffab4cea8475c92c4880fb81', '/detail/098ed3573ae642bc9474ee77d648e54d', '/detail/20d8c40b9ece4374ba0f279d5f7930e1', '/detail/da5a0cc0a0c548528763d0ced4804ad9', '/detail/1729e4c282354cc8b075dd22cc518d7e', '/detail/f2d9e5a1f8494cebb9d90ebd346dc2ff', '/detail/b772bbf39c034a589bbbd19f55aeea24', '/detail/b78150f99c534e06a2dad9fc79eb203e', '/detail/5b51a74354d9455b83be64a5dba64946', '/detail/ef2eca9fa7424c988f073b27283ac72c', '/detail/f6a8a87a43cd452f9ccbdf62fd07a5cc', '/detail/f4f09679c7d74979b44b93adda3ffddc', '/detail/0ce11d4942e04ab09f031cdd24129444', '/detail/19af3da08a424c028cd8fa0e79920513', '/detail/c13b65486b5340c3b53c17c0005c2771', '/detail/eca7f5b688ae440f8fff18bbaf955928', '/detail/f42795dd4de246c383c629b4599c5b4e', '/detail/0e595ab5a7db42f5b446cea9377ef970', '/detail/fd7f4c9e0555402980a8b637c7a550e0', '/detail/19c65a0017094b82a2a8af4c150fa48c', '/detail/77f96324ec374a80ab53c42bad06fa05', '/detail/15a1813066f9440a86c6f51bd5c11e5b', '/detail/ee3e4ff8584e4259b465fe4fa81e6c2a', '/detail/bcded52327bd4f9785076f359574e83f', '/detail/add8eb9a31514c5183b9cf1059aa2e8b', '/detail/9d2761d4056445f2a5fcc75cc10b4744', '/detail/787e7e1ec8074cacba2a5f3420f34d8b', '/detail/ae6aadd8358a4327a17d4939c35822bd', '/detail/7c3c4d3bc095497eaeac680f329e2120', '/detail/d1965693d1b94479923a8f69828c8820', '/detail/1dc101cc0b7a44b6a8e21c8980d25b25', '/detail/18dd8e332ff844568212628f0daed92e', '/detail/41d8d825232a46e79806a61072b225c0', '/detail/1cda4f5b6ee34a33b934177f65715c42', '/detail/431894846dc34516bfbda3e0a341fceb', '/detail/878e01f558d04e75addf72dae66584c1', '/detail/8f1cb3d5c0c74f928bb245f1b20caa9a', '/detail/c1ca2bf0a4c549bc951a3c3870c82205', '/detail/5084a9603826433caee1d0753840e08c', '/detail/d296747ba53e457a91b3f97cf19c8d80', '/detail/717b6bb16b444b87b8a70dacde17bc06', '/detail/fa97f35226564cbc9d91a33901a55b3d', '/detail/627e2f6efed64848b552786c0b8dcf3c', '/detail/55c757e7a95747c9b22040d814f172c6', '/detail/2cf84c975ad1459c96a49cd8bb963c1a', '/detail/4711929a05464ac58382f86a79c8a5ff', '/detail/794670d35a4c463d938692982642bb75', '/detail/94d47aaddffb42c29e76d9067134ab4a', '/detail/cc28e08c724245d7afc7615e92d937f1', '/detail/627a1385128848f9807f2a3edd68f6dd', '/detail/76ea14b74a9a43888ecea90b37517b56', '/detail/5d866188679d46f186f10519470967c9', '/detail/50f2e9d9c4c7412980bf84a18713192a', '/detail/acbe87d1b35b4d76a746682da39cfb47', '/detail/52c8bb5cc45149b1afc2ebe066de70a2', '/detail/b344ced8720940ad8860e9765bc68829', '/detail/6c555bd1672d4acc954929debc123353', '/detail/cfbbfeba71614772ae19461c22036574', '/detail/ff82346ba444419196c46c6c25f26f14', '/detail/8cc031e6bbf540a49cf0726c25875dd0', '/detail/a550ae0a9a804d13a972febca3ed7e7c', '/detail/8f0d7762dc384ba2acc244a1f2e52ac3', '/detail/5c6ed8ed59744dfda7a8756667126f76', '/detail/a94dacd372944b48a120b543f9995e6b', '/detail/fc9f96dfa03b49caab803c771ce2e28d', '/detail/7af1e37f3fc742aa909f3043dac926ba', '/detail/f6e759ad3f594cf5988351624041cbf8', '/detail/b69d029879664c21bf577bb8a4ae4ff0', '/detail/30ade0d7a51c4a6989d123b6014d3fad', '/detail/523b2312153b485ab6af3a093dc0bef2', '/detail/22bf926b769e47e0b3b17acc0bdf6442', '/detail/98416251d92f427fa01652f0dc58298b', '/detail/025afcbd49a54e7192f1fb65f98ccde9', '/detail/b9a365f38ca940cfb2e3f5d4e082cf25', '/detail/b36001c26aee47919e6efcf7c239785e', '/detail/b43a17217ab9492bb03efb9b3d683e04', '/detail/026b9b9d47de4019876f64d2c6eed9c7', '/detail/c453fae8af914a00bc5ff9700f1d7556', '/detail/67b273066f6d44e7b31b8a7b8bfc27a9', '/detail/6aa6a51095754a4aaa01899424f39c4d', '/detail/cab50c5081f14f99a55c33064eba2f78', '/detail/f9b3fb2d2eab4086b5713ea519e982a8', '/detail/9a62da6503054da0b77bdf1e92af2a7e', '/detail/0a4f1f04ff754ae18414981221c0ca48', '/detail/8178e2bf88634edfb8b58ec66672399e', '/detail/0d754bb20031429d821ac07338b73944', '/detail/5a66a28cdcbe46e58fe25d5d13b61540', '/detail/292f6e7adfe44ca18aec664db36dc4ee', '/detail/4dca80ddd2b347139e3feec770c40944', '/detail/77995ed26242406c8e733f2001ef66c4', '/detail/f04ef50af1cc4caa80c371b8fcbbc93d', '/detail/7432c66b783d46b1a89908e45336755b', '/detail/0fb656a119e147e89b595a0632cb0457', '/detail/8e07f37cb01243ac9f3dcc1b9eaa7ae3', '/detail/443cccaaaba64583b6d77907a622d265', '/detail/4be7cd9a3efb487b82b7bff4f21c4274', '/detail/afd6c32bd5914d458f8d6d9befe5cdf3', '/detail/e2c83b90b0214db4aa70549bdc16b385', '/detail/15279182346f404b86b4cd977ee76633', '/detail/57e2168087b14b3cbea5b60bb304973a', '/detail/855e3bc8978a4718b06b921f9b536ba8', '/detail/664c07e91b024ca3ad50082bad1958b6', '/detail/773a5719dbbc4e8ca306aa9df658ea1f', '/detail/8b6d3b5bfffb4fbab6bda732879a74a0', '/detail/fcd9e88a013f4c6e965d7fe1c8370e4d', '/detail/1b964ac7a5f445cb96162dff7f70a24e', '/detail/e03f3c1c8a494833b1ea0747b3de129c', '/detail/f8304fa894ea477a9011de162805e060', '/detail/a1b618bd508d4e01a4c967e334d1a684', '/detail/196e3138be8f41e798af0a28f9cfc189', '/detail/b9db46c6d91849068115925a9fa9c591', '/detail/2d7463d8716b42d5ad52bf921c7d1bce', '/detail/5a43b97b7d7d4e7f80bf8b8a11f149bc', '/detail/8847b841091f4741aee2fcf84e79295b', '/detail/7ab6abe086db43fe9126e48bf6ecf5de', '/detail/65551dd3c6234331a5bc043ab19b7d9f', '/detail/23ba471d97fa445880658d35de52499e', '/detail/e8fccaa4339849829aeb220e6f55b50d', '/detail/381640388b614a9fa17e7e49eeb018ef', '/detail/3048d0d942ba486d805a2fa6eb5a00c2', '/detail/e9d3c2c198ea4ebd8ccd6fc06b9610e1', '/detail/5776daf5664f40d08b9accf2612596dc', '/detail/a31d3fe0f0b949af9fa438477e587646', '/detail/6063e26bec3d4b1ebfc1e9fb4d2c7cdf', '/detail/f01d5b63debe4a3e885ce09cf1de4f48', '/detail/8635fbd01ec948da90df92476908d1a2', '/detail/6662931e44444d968a5af771e72d2664', '/detail/4d31dd99547546bf8a5e80713eacf91f', '/detail/62e08c72c75c4544b4d5065d26875ebd', '/detail/d79cc0d281e9488d89523e43b3382e43', '/detail/dd1559219eca47aaaba5b41f86734493', '/detail/e1a42fc902444f508790dd2bab851916', '/detail/beb87261122c4e8a903edd3947c445ff', '/detail/e5b5d9f0228f4a36b30ff5489c72766f', '/detail/c1bc0717fc874934887e93b035f31f6e', '/detail/d5ab1f565da840569738a10f94de2fac', '/detail/ea227d0d267d4052a91626cf724a02b9', '/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
  `product_media`.`id` AS `product_media.id`,
  `product_media`.`version_id` AS `product_media.versionId`,
  `product_media`.`product_id` AS `product_media.productId`,
  `product_media`.`product_version_id` AS `product_media.productVersionId`,
  `product_media`.`media_id` AS `product_media.mediaId`,
  `product_media`.`position` AS `product_media.position`,
  `product_media.media`.`id` AS `product_media.media.id`,
  `product_media.media`.`user_id` AS `product_media.media.userId`,
  `product_media.media`.`media_folder_id` AS `product_media.media.mediaFolderId`,
  `product_media.media`.`mime_type` AS `product_media.media.mimeType`,
  `product_media.media`.`file_extension` AS `product_media.media.fileExtension`,
  `product_media.media`.`uploaded_at` AS `product_media.media.uploadedAt`,
  `product_media.media`.`file_name` AS `product_media.media.fileName`,
  `product_media.media`.`file_size` AS `product_media.media.fileSize`,
  `product_media.media`.`media_type` AS `product_media.media.mediaTypeRaw`,
  `product_media.media`.`meta_data` AS `product_media.media.metaData`,
  `product_media.media`.`config` AS `product_media.media.config`,
  `product_media.media`.`path` AS `product_media.media.path`,
  `product_media.media`.`private` AS `product_media.media.private`,
  `product_media.media`.`thumbnails_ro` AS `product_media.media.thumbnailsRo`,
  `product_media.media`.`created_at` AS `product_media.media.createdAt`,
  `product_media.media`.`updated_at` AS `product_media.media.updatedAt`,
  `product_media.media.translation.title`,
  COALESCE(
    `product_media.media.translation.title`,
    `product_media.media.translation.title`
  ) AS `product_media.media.title`,
  `product_media.media.translation.alt`,
  COALESCE(
    `product_media.media.translation.alt`,
    `product_media.media.translation.alt`
  ) AS `product_media.media.alt`,
  `product_media.media.translation.customFields`,
  COALESCE(
    `product_media.media.translation.customFields`,
    `product_media.media.translation.customFields`
  ) AS `product_media.media.customFields`,
  `product_media.media.translation.createdAt`,
  `product_media.media.translation.updatedAt`,
  `product_media.media.translation.mediaId`,
  `product_media.media.translation.languageId`,
  `product_media`.`custom_fields` AS `product_media.customFields`,
  `product_media`.`created_at` AS `product_media.createdAt`,
  `product_media`.`updated_at` AS `product_media.updatedAt`,
  `product_media.solidPvVideoThumbnail`.`id` AS `product_media.solidPvVideoThumbnail.id`,
  `product_media.solidPvVideoThumbnail`.`product_media_id` AS `product_media.solidPvVideoThumbnail.productMediaId`,
  `product_media.solidPvVideoThumbnail`.`product_media_version_id` AS `product_media.solidPvVideoThumbnail.productMediaVersionId`,
  `product_media.solidPvVideoThumbnail`.`media_id` AS `product_media.solidPvVideoThumbnail.mediaId`,
  `product_media.solidPvVideoThumbnail.media`.`id` AS `product_media.solidPvVideoThumbnail.media.id`,
  `product_media.solidPvVideoThumbnail.media`.`user_id` AS `product_media.solidPvVideoThumbnail.media.userId`,
  `product_media.solidPvVideoThumbnail.media`.`media_folder_id` AS `product_media.solidPvVideoThumbnail.media.mediaFolderId`,
  `product_media.solidPvVideoThumbnail.media`.`mime_type` AS `product_media.solidPvVideoThumbnail.media.mimeType`,
  `product_media.solidPvVideoThumbnail.media`.`file_extension` AS `product_media.solidPvVideoThumbnail.media.fileExtension`,
  `product_media.solidPvVideoThumbnail.media`.`uploaded_at` AS `product_media.solidPvVideoThumbnail.media.uploadedAt`,
  `product_media.solidPvVideoThumbnail.media`.`file_name` AS `product_media.solidPvVideoThumbnail.media.fileName`,
  `product_media.solidPvVideoThumbnail.media`.`file_size` AS `product_media.solidPvVideoThumbnail.media.fileSize`,
  `product_media.solidPvVideoThumbnail.media`.`media_type` AS `product_media.solidPvVideoThumbnail.media.mediaTypeRaw`,
  `product_media.solidPvVideoThumbnail.media`.`meta_data` AS `product_media.solidPvVideoThumbnail.media.metaData`,
  `product_media.solidPvVideoThumbnail.media`.`config` AS `product_media.solidPvVideoThumbnail.media.config`,
  `product_media.solidPvVideoThumbnail.media`.`path` AS `product_media.solidPvVideoThumbnail.media.path`,
  `product_media.solidPvVideoThumbnail.media`.`private` AS `product_media.solidPvVideoThumbnail.media.private`,
  `product_media.solidPvVideoThumbnail.media`.`thumbnails_ro` AS `product_media.solidPvVideoThumbnail.media.thumbnailsRo`,
  `product_media.solidPvVideoThumbnail.media`.`created_at` AS `product_media.solidPvVideoThumbnail.media.createdAt`,
  `product_media.solidPvVideoThumbnail.media`.`updated_at` AS `product_media.solidPvVideoThumbnail.media.updatedAt`,
  `product_media.solidPvVideoThumbnail.media.translation.title`,
  COALESCE(
    `product_media.solidPvVideoThumbnail.media.translation.title`,
    `product_media.solidPvVideoThumbnail.media.translation.title`
  ) AS `product_media.solidPvVideoThumbnail.media.title`,
  `product_media.solidPvVideoThumbnail.media.translation.alt`,
  COALESCE(
    `product_media.solidPvVideoThumbnail.media.translation.alt`,
    `product_media.solidPvVideoThumbnail.media.translation.alt`
  ) AS `product_media.solidPvVideoThumbnail.media.alt`,
  `product_media.solidPvVideoThumbnail.media.translation.customFields`,
  COALESCE(
    `product_media.solidPvVideoThumbnail.media.translation.customFields`,
    `product_media.solidPvVideoThumbnail.media.translation.customFields`
  ) AS `product_media.solidPvVideoThumbnail.media.customFields`,
  `product_media.solidPvVideoThumbnail.media.translation.createdAt`,
  `product_media.solidPvVideoThumbnail.media.translation.updatedAt`,
  `product_media.solidPvVideoThumbnail.media.translation.mediaId`,
  `product_media.solidPvVideoThumbnail.media.translation.languageId`,
  `product_media.solidPvVideoThumbnail`.`created_at` AS `product_media.solidPvVideoThumbnail.createdAt`,
  `product_media.solidPvVideoThumbnail`.`updated_at` AS `product_media.solidPvVideoThumbnail.updatedAt`
FROM
  `product_media`
  LEFT JOIN `media` `product_media.media` ON `product_media`.`media_id` = `product_media.media`.`id`
  LEFT JOIN `solid_pv_product_media_video_thumbnail` `product_media.solidPvVideoThumbnail` ON `product_media`.`id` = `product_media.solidPvVideoThumbnail`.`product_media_id`
  LEFT JOIN (
    SELECT
      `product_media.media.translation`.media_id,
      `product_media.media.translation`.title AS `product_media.media.translation.title`,
      `product_media.media.translation`.alt AS `product_media.media.translation.alt`,
      `product_media.media.translation`.custom_fields AS `product_media.media.translation.customFields`,
      `product_media.media.translation`.created_at AS `product_media.media.translation.createdAt`,
      `product_media.media.translation`.updated_at AS `product_media.media.translation.updatedAt`,
      `product_media.media.translation`.media_id AS `product_media.media.translation.mediaId`,
      `product_media.media.translation`.language_id AS `product_media.media.translation.languageId`
    FROM
      `media_translation` `product_media.media.translation`
    WHERE
      `product_media.media.translation`.language_id = ?
  ) `product_media.media.media_translation` ON `product_media.media.media_translation`.`media_id` = `product_media.media`.`id`
  LEFT JOIN `media` `product_media.solidPvVideoThumbnail.media` ON `product_media.solidPvVideoThumbnail`.`media_id` = `product_media.solidPvVideoThumbnail.media`.`id`
  LEFT JOIN (
    SELECT
      `product_media.solidPvVideoThumbnail.media.translation`.media_id,
      `product_media.solidPvVideoThumbnail.media.translation`.title AS `product_media.solidPvVideoThumbnail.media.translation.title`,
      `product_media.solidPvVideoThumbnail.media.translation`.alt AS `product_media.solidPvVideoThumbnail.media.translation.alt`,
      `product_media.solidPvVideoThumbnail.media.translation`.custom_fields AS `product_media.solidPvVideoThumbnail.media.translation.customFields`,
      `product_media.solidPvVideoThumbnail.media.translation`.created_at AS `product_media.solidPvVideoThumbnail.media.translation.createdAt`,
      `product_media.solidPvVideoThumbnail.media.translation`.updated_at AS `product_media.solidPvVideoThumbnail.media.translation.updatedAt`,
      `product_media.solidPvVideoThumbnail.media.translation`.media_id AS `product_media.solidPvVideoThumbnail.media.translation.mediaId`,
      `product_media.solidPvVideoThumbnail.media.translation`.language_id AS `product_media.solidPvVideoThumbnail.media.translation.languageId`
    FROM
      `media_translation` `product_media.solidPvVideoThumbnail.media.translation`
    WHERE
      `product_media.solidPvVideoThumbnail.media.translation`.language_id = ?
  ) `product_media.solidPvVideoThumbnail.media.media_translation` ON `product_media.solidPvVideoThumbnail.media.media_translation`.`media_id` = `product_media.solidPvVideoThumbnail.media`.`id`
WHERE
  (`product_media`.`version_id` = ?)
  AND (
    (
      `product_media`.`product_id` IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?
      )
    )
  )