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

# 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/d42fa89d580545278d7e6fc4a6c0e6ce', '/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/12ea8ec018a6410aaea00ac4c4beb418', '/navigation/eb1b57ea772f42f7bf4e6fd2e99c592e', '/navigation/691e6f5a832d48b1bd9a059916e51c5c', '/navigation/c096b6a7619f4e56bebd9e46c5a0319a', '/navigation/1892699ecc454ccd9fee9670f05d9dea', '/navigation/b8e468f6328c4f79bbb4d91c0362185d', '/navigation/a1da6f4b364c42afa8d8ddaf3450a4aa', '/navigation/c6ba40d7942740d2910fe391c65835cc', '/navigation/6d0670380aef4646a9d3a1ad53430a70', '/detail/d0f5129765ee4279b7179255c0d59fd5', '/detail/f80ab3202b5b444eac3728b2e2b788e3', '/detail/45fe85f0050b44bb82915230f5e352b4', '/detail/23691f0aa3d04a34bfc66cfdd7e4680e', '/detail/1a44958f1a5b4a878ffbb032b9298c59', '/detail/2ab66eaed07f473ab8d43f1c11855993', '/detail/50e6aa06a7af4de9bfc198d3af8a613c', '/detail/80649b94053a4015b069d023b2ebcddf', '/detail/0d8b17ef558e4c1ab066e7ccae1449e8', '/detail/a8ca6046e2454e89b2e42d6e6690101b', '/detail/785a569e81674e6aa5b450d778a06448', '/detail/0a60768d868644ad8711c975824d186c', '/detail/959ffde042c64e5fbcd9ead632bc104b', '/detail/af56a1bccb764cf7b0059303d5490819', '/detail/8eced72c2e80426d94fce3b596034ea8', '/detail/13a06101c9184064b9a3992d1ba23413', '/detail/8a71f44094f142b58b4de325919f3daf', '/detail/7e46e2a7bb4a4262b90e58a1c01749bf', '/detail/9d9d07fc8f5443758874400ec8b22879', '/detail/98c89e0c0f1f446291f7a0e33e4a29ee', '/detail/b31fd258b55d401b8e674ab7407b7fff', '/detail/6a80604953f141a495b717b94d17386a', '/detail/b0b8ffe4d61342dc9f672c2d65e40066', '/detail/37f7f237b2744996872441b4ddf407b4', '/detail/edbf191513b844298c88bb2d87aa0bb2', '/detail/d3d0b06f0d3e44a490b5e4ab390bc924', '/detail/82716594d6254abd9425044a014d67c7', '/detail/9e8bde908c69414b960fccb8c7560763', '/detail/ee5e415d28304befb37f9572e09d6ffd', '/detail/734fb65d4614448182382a3e05c529df', '/detail/9f85e6db31e049efb9314b525b329008', '/detail/b573e71776c44fad882693ee092fc277', '/detail/8de59c1ad0a84c3f81271e6fa3595c4d', '/detail/672a5dd21b0c4f4eac0fdd5ec288d84c', '/detail/a3a8774fc54b42bc93183f6fe4e947e1', '/detail/2ea78823257a4f5fa855638ad879bd17', '/detail/8a63cf72f77d46baa8369da857025ddf', '/detail/a3329fdc4c9c455abf5e970b52ed31e6', '/detail/70c7a53dbad14a59b577996f0441c779', '/detail/03789e07e97b409f95239ac2995c38df', '/detail/11488c67cbbf4a65b99381e4dc16eb1b', '/detail/b8f722e8271c458a907fad4c085ea70d', '/detail/2f9cf3aa756c4141b4798c0457b22c8c', '/detail/60ffbee38ddc461bb2df4f66efd28feb', '/detail/22e47ce98a974ad398a05603459050c6', '/detail/a714efb1c90e41f1bf4fb9e3ab4d5086', '/detail/5706b5a90cff4b7f8e46774ae98f4e75', '/detail/1a5c2547ee7f4d1c90fa1e627553e85f', '/detail/51c9d288ea584c7d8f21dd2b9b1815f2', '/detail/6953b1a6c6d4483f9b48f04a1610b3bc', '/detail/ab2809c0f39f4ad2ad0817cab91e7fdb', '/detail/c66018a720a348f1beea0f359781cb24', '/detail/7e8ae2581efb4a5585d354d89239f5c6', '/detail/670026851eaa4b9ba4e597aa8552fc72', '/detail/255586035cbb4916aa48ccb514197d98', '/detail/f4a4cd03c8a14f7a9c92764bd222ae03', '/detail/482f074011bb49c8a7e579d5ff5ea1f4', '/detail/2a79a86997b347b6b260b3581b0ecb2f', '/detail/aaa473cda9134d9b9f13629810672db9', '/detail/ad6000fdcb8b4c79aa3bf425236cc0d0', '/detail/ac358bb2c8704396b0b81360038b2bab', '/detail/fcefa8edc3344b20848b9a9689481089', '/detail/5a1ba8a78bd24361828055c259522d0d', '/detail/4a0a2c27606e4868bb783a3c82a293e2', '/detail/783390affd0a40ca85302269fdba680b', '/detail/b28c246c8be744028f6571b9587b0c86', '/detail/cb7c7e4f3b4a4808ab5483bc8346c609', '/detail/b1d371812ae64bddb49781e7c10922e1', '/detail/7374640c599546989175f7fbda0a9f4f', '/detail/cc376c9f2be24cac9a95a9e50673310a', '/detail/07c1092be8df43e881b1e9dd2b5eae3c', '/detail/00b0e016453d41f0ae7e7c61954b5692', '/detail/e3b58649733d403b8fc10b4d7c084eca', '/detail/661f4a2a8ebc4425882f570ea0b8f5bc', '/detail/4d6f379a7e224cf287b653e784ab63c6', '/detail/e8280edfe1e3462ca7bc6db4d6c0f041', '/detail/096fd28ae1ff48159b1de24a8283d3bd', '/detail/e43d557029d94df49b35564c1153d56b', '/detail/1ec6f143fd624154b9dec5d62f23f3d1', '/detail/7d240669a30a48dbac2c3b6873ca1818', '/detail/334a36804d1a4f05a66198cb09f3b36a', '/detail/fa867f6ec8694876965c0a757bc93e62', '/detail/9e6874d8440740c684314d5e25edea7a', '/detail/111a834dcc9641d986844cb1bc446bea', '/detail/f85d34cc31d9432abe9125077e0f8b01', '/detail/78cc1e038077460b857e8487f728c32a', '/detail/d59868874ad54602b148de206b9bd7e9', '/detail/71afa460a3624d77816947d17dacd0b3', '/detail/afd5cce52f1d442892b4cdc372db8dac', '/detail/857b1b72b70d4e1ca4b653b613a3c987', '/detail/12cfc1b1af0c4d4aaff4054fa7bf72cd', '/detail/cd832bbb410a48788a7e4845176b2900', '/detail/aeda470cc5b948bc97a2393f9f2239eb', '/detail/f9fbb68ebb3a4d3da95256014c66a02a', '/detail/3d715ed329d74e3e847bbc7b4f555856', '/detail/f8545333f1434f6791a2ca520a526545', '/detail/a42a3f67b9e046efad9559531f0d6e34', '/detail/d55674bde74245388d49255ca0cdd130', '/detail/535c0af42a6d4455b8abbf000ca21d11', '/detail/2eb4959eb30a492aaa78a4a88f0e9f48', '/detail/901c84b4f8934f9c8baa22899d2856b6', '/detail/31ec26886b9041ffa4495539b4970bc1', '/detail/e7eeeee1ef9743acb22fd7b5c1bb92ab', '/detail/3509148d65dc416c92af4bea924afb52', '/detail/ff7e84963c7242ae8849ddd83eaf6063', '/detail/ce4765c39ebb4d50aeedbd9fcb376577', '/detail/dc09cb2631774c4a8be6d7820d68405d', '/detail/613e1e7cdafe4bed81c164e9d37d7e40', '/detail/40959e50e9d34506b17e0cfbf97604ea', '/detail/b0b212b2978b4f45bb78618e31049af0', '/detail/a83486106cf84e6f82168131f7964110', '/detail/752a22f41c594e12bfbce559c3448c52', '/detail/8ea96738c77348e7abe81c0b045b593c', '/detail/f65e0a2c28944015b077622f0c6442ab', '/detail/e99710f797fa445bb50e9b51221fbf52', '/detail/516a94ea4d5b4af58d38bfd62a079ef8', '/detail/6c87251767cc46c1b762562f9e618933', '/detail/a415239629b6414ca6b0e833ff6c03cd', '/detail/aae6785f908e48009c7eb26b3774c007', '/detail/a37ec34357c94981b5acbddb75f7beb6', '/detail/8bc0a35af7ac417a96b10b485655fdc4', '/detail/0a693b78b3564969abd50c21d788bede', '/detail/c4717e459f82491d89ea88f4d8d2c92e', '/detail/a36bfee345654800877cd2de04ac4d9f', '/detail/d9e6de1af655479bb5de887041b50697', '/detail/2434569a93074ae19f394d676d94a460', '/detail/638ff24befeb482dad1e66cd523f389f', '/detail/d428debf93d74c8a80237d100b48afc5', '/detail/7f8053dc48f244e483ba32421e114bd4', '/detail/7183c2d6f2fc43a79e8558fcb55a871b', '/detail/1114feee84784ddebc42223ec218e9b0', '/detail/b94bf9f091164cd39841d4a35d327ef9', '/detail/6e9c69b60a39430da32e44fc401e58e9', '/detail/c76de4d3ac444475b6b72454770b25c1', '/detail/74dbe35bbb51490ca242ca4a4ccc2a72', '/detail/b09231336e3c443aaced8e291d461f80', '/detail/44d89716fc3d4662a021f57339c79e95', '/detail/78c9daed1b95471482002dfc34e216d3', '/detail/6bf7fa0d1218416381d91627ca70d4a2', '/detail/1fe7bf5c6f65484791856c52b397966a', '/detail/aaa18b1d19434dcd83e86d16dbb2bbca', '/detail/97a874c1ad1e4ea6bd77898c82a95561', '/detail/705cfcbf6e5c4ee49af5c44ee98b0d90', '/detail/5a892c721de140eea3f4dac624a4dd94', '/detail/db6ebe8055f04b5b894f7cd450154d29', '/detail/28db0150d91147fd862075f309f9c637', '/detail/c7ccd140ec2f4286b6bb209459d9eeca', '/detail/f3469b71b9ac415f9d9805c6699e9a3a', '/detail/e157f73f44cc443b9916dd9a7d4f566b', '/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 = 0xD43E6708F5CE421CBDD374F52F34C18D) 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);

# product-listing-route::loading::aggregation::price
SELECT
  MIN(
    IFNULL(
      COALESCE(
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruleaac9775552ee4873982a0c89587ccbf3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulecd7ca2d7448e463fa158caacf4edd47d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulee780564bad104a56aa4601d37db480b0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule80099d5270fb4ea8a6d551bed82513d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        )
      ),
      COALESCE(
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruleaac9775552ee4873982a0c89587ccbf3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulecd7ca2d7448e463fa158caacf4edd47d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulee780564bad104a56aa4601d37db480b0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule80099d5270fb4ea8a6d551bed82513d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        )
      )
    )
  ) AS `price.min`,
  MAX(
    IFNULL(
      COALESCE(
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruleaac9775552ee4873982a0c89587ccbf3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulecd7ca2d7448e463fa158caacf4edd47d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulee780564bad104a56aa4601d37db480b0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule80099d5270fb4ea8a6d551bed82513d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        )
      ),
      COALESCE(
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruleaac9775552ee4873982a0c89587ccbf3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulecd7ca2d7448e463fa158caacf4edd47d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulee780564bad104a56aa4601d37db480b0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule80099d5270fb4ea8a6d551bed82513d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) AS DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        )
      )
    )
  ) AS `price.max`
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
  LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`
  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id`
  LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`
  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
      AND `product.categoriesRo`.`id` = ?
      AND NOT (`product`.`display_group` <=> ?)
      AND NOT (
        IFNULL(
          `product`.`is_closeout`, `product.parent`.`is_closeout`
        ) <=> ?
        AND `product`.`available` <=> ?
      )
    )
  )

# product-listing-route::loading::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaac9775552ee4873982a0c89587ccbf3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulecd7ca2d7448e463fa158caacf4edd47d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee780564bad104a56aa4601d37db480b0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule80099d5270fb4ea8a6d551bed82513d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleaac9775552ee4873982a0c89587ccbf3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulecd7ca2d7448e463fa158caacf4edd47d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee780564bad104a56aa4601d37db480b0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule80099d5270fb4ea8a6d551bed82513d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) AS `price.min`, MAX(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaac9775552ee4873982a0c89587ccbf3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulecd7ca2d7448e463fa158caacf4edd47d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee780564bad104a56aa4601d37db480b0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule80099d5270fb4ea8a6d551bed82513d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleaac9775552ee4873982a0c89587ccbf3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulecd7ca2d7448e463fa158caacf4edd47d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee780564bad104a56aa4601d37db480b0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulee44e6782c64247b796b891cf25ae38f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule80099d5270fb4ea8a6d551bed82513d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) AS `price.max` 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 LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 30) AND `product.visibilities`.`sales_channel_id` = 0x67D79825561D4007A766D27CBBF1BDF6 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1) AND `product.categoriesRo`.`id` = 0xD42FA89D580545278D7E6FC4A6C0E6CE AND NOT (`product`.`display_group` <=> NULL) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> 1 AND `product`.`available` <=> 0)));