Symfony Profiler

SELECT
  `product_review`.`id` as `product_review.id`,
  `product_review`.`product_id` as `product_review.productId`,
  `product_review`.`product_version_id` as `product_review.productVersionId`,
  `product_review`.`customer_id` as `product_review.customerId`,
  `product_review`.`sales_channel_id` as `product_review.salesChannelId`,
  `product_review`.`language_id` as `product_review.languageId`,
  `product_review`.`external_user` as `product_review.externalUser`,
  `product_review`.`external_email` as `product_review.externalEmail`,
  `product_review`.`title` as `product_review.title`,
  `product_review`.`content` as `product_review.content`,
  `product_review`.`points` as `product_review.points`,
  `product_review`.`status` as `product_review.status`,
  `product_review`.`comment` as `product_review.comment`,
  `product_review`.`custom_fields` as `product_review.customFields`,
  `product_review`.`created_at` as `product_review.createdAt`,
  `product_review`.`updated_at` as `product_review.updatedAt`,
  `product_review.reviewExtension`.`id` as `product_review.reviewExtension.id`,
  `product_review.reviewExtension`.`review_id` as `product_review.reviewExtension.reviewId`,
  `product_review.reviewExtension`.`order_id` as `product_review.reviewExtension.orderId`,
  `product_review.reviewExtension`.`media_id` as `product_review.reviewExtension.mediaId`,
  `product_review.reviewExtension.order`.`id` as `product_review.reviewExtension.order.id`,
  `product_review.reviewExtension.order`.`version_id` as `product_review.reviewExtension.order.versionId`,
  `product_review.reviewExtension.order`.`auto_increment` as `product_review.reviewExtension.order.autoIncrement`,
  `product_review.reviewExtension.order`.`order_number` as `product_review.reviewExtension.order.orderNumber`,
  `product_review.reviewExtension.order`.`billing_address_id` as `product_review.reviewExtension.order.billingAddressId`,
  `product_review.reviewExtension.order`.`billing_address_version_id` as `product_review.reviewExtension.order.billingAddressVersionId`,
  `product_review.reviewExtension.order`.`currency_id` as `product_review.reviewExtension.order.currencyId`,
  `product_review.reviewExtension.order`.`language_id` as `product_review.reviewExtension.order.languageId`,
  `product_review.reviewExtension.order`.`sales_channel_id` as `product_review.reviewExtension.order.salesChannelId`,
  `product_review.reviewExtension.order`.`order_date_time` as `product_review.reviewExtension.order.orderDateTime`,
  `product_review.reviewExtension.order`.`order_date` as `product_review.reviewExtension.order.orderDate`,
  `product_review.reviewExtension.order`.`price` as `product_review.reviewExtension.order.price`,
  `product_review.reviewExtension.order`.`amount_total` as `product_review.reviewExtension.order.amountTotal`,
  `product_review.reviewExtension.order`.`amount_net` as `product_review.reviewExtension.order.amountNet`,
  `product_review.reviewExtension.order`.`position_price` as `product_review.reviewExtension.order.positionPrice`,
  `product_review.reviewExtension.order`.`tax_status` as `product_review.reviewExtension.order.taxStatus`,
  `product_review.reviewExtension.order`.`shipping_costs` as `product_review.reviewExtension.order.shippingCosts`,
  `product_review.reviewExtension.order`.`shipping_total` as `product_review.reviewExtension.order.shippingTotal`,
  `product_review.reviewExtension.order`.`currency_factor` as `product_review.reviewExtension.order.currencyFactor`,
  `product_review.reviewExtension.order`.`deep_link_code` as `product_review.reviewExtension.order.deepLinkCode`,
  `product_review.reviewExtension.order`.`affiliate_code` as `product_review.reviewExtension.order.affiliateCode`,
  `product_review.reviewExtension.order`.`campaign_code` as `product_review.reviewExtension.order.campaignCode`,
  `product_review.reviewExtension.order`.`customer_comment` as `product_review.reviewExtension.order.customerComment`,
  `product_review.reviewExtension.order`.`source` as `product_review.reviewExtension.order.source`,
  `product_review.reviewExtension.order`.`state_id` as `product_review.reviewExtension.order.stateId`,
  `product_review.reviewExtension.order`.`rule_ids` as `product_review.reviewExtension.order.ruleIds`,
  `product_review.reviewExtension.order`.`custom_fields` as `product_review.reviewExtension.order.customFields`,
  `product_review.reviewExtension.order`.`created_by_id` as `product_review.reviewExtension.order.createdById`,
  `product_review.reviewExtension.order`.`updated_by_id` as `product_review.reviewExtension.order.updatedById`,
  `product_review.reviewExtension.order.orderCustomer`.`id` as `product_review.reviewExtension.order.orderCustomer.id`,
  `product_review.reviewExtension.order.orderCustomer`.`version_id` as `product_review.reviewExtension.order.orderCustomer.versionId`,
  `product_review.reviewExtension.order.orderCustomer`.`customer_id` as `product_review.reviewExtension.order.orderCustomer.customerId`,
  `product_review.reviewExtension.order.orderCustomer`.`order_id` as `product_review.reviewExtension.order.orderCustomer.orderId`,
  `product_review.reviewExtension.order.orderCustomer`.`order_version_id` as `product_review.reviewExtension.order.orderCustomer.orderVersionId`,
  `product_review.reviewExtension.order.orderCustomer`.`email` as `product_review.reviewExtension.order.orderCustomer.email`,
  `product_review.reviewExtension.order.orderCustomer`.`salutation_id` as `product_review.reviewExtension.order.orderCustomer.salutationId`,
  `product_review.reviewExtension.order.orderCustomer`.`first_name` as `product_review.reviewExtension.order.orderCustomer.firstName`,
  `product_review.reviewExtension.order.orderCustomer`.`last_name` as `product_review.reviewExtension.order.orderCustomer.lastName`,
  `product_review.reviewExtension.order.orderCustomer`.`company` as `product_review.reviewExtension.order.orderCustomer.company`,
  `product_review.reviewExtension.order.orderCustomer`.`title` as `product_review.reviewExtension.order.orderCustomer.title`,
  `product_review.reviewExtension.order.orderCustomer`.`vat_ids` as `product_review.reviewExtension.order.orderCustomer.vatIds`,
  `product_review.reviewExtension.order.orderCustomer`.`customer_number` as `product_review.reviewExtension.order.orderCustomer.customerNumber`,
  `product_review.reviewExtension.order.orderCustomer`.`custom_fields` as `product_review.reviewExtension.order.orderCustomer.customFields`,
  `product_review.reviewExtension.order.orderCustomer`.`remote_address` as `product_review.reviewExtension.order.orderCustomer.remoteAddress`,
  `product_review.reviewExtension.order.orderCustomer`.`created_at` as `product_review.reviewExtension.order.orderCustomer.createdAt`,
  `product_review.reviewExtension.order.orderCustomer`.`updated_at` as `product_review.reviewExtension.order.orderCustomer.updatedAt`,
  `product_review.reviewExtension.order`.`item_rounding` as `product_review.reviewExtension.order.itemRounding`,
  `product_review.reviewExtension.order`.`total_rounding` as `product_review.reviewExtension.order.totalRounding`,
  `product_review.reviewExtension.order`.`created_at` as `product_review.reviewExtension.order.createdAt`,
  `product_review.reviewExtension.order`.`updated_at` as `product_review.reviewExtension.order.updatedAt`,
  `product_review.reviewExtension.media`.`id` as `product_review.reviewExtension.media.id`,
  `product_review.reviewExtension.media`.`user_id` as `product_review.reviewExtension.media.userId`,
  `product_review.reviewExtension.media`.`media_folder_id` as `product_review.reviewExtension.media.mediaFolderId`,
  `product_review.reviewExtension.media`.`mime_type` as `product_review.reviewExtension.media.mimeType`,
  `product_review.reviewExtension.media`.`file_extension` as `product_review.reviewExtension.media.fileExtension`,
  `product_review.reviewExtension.media`.`uploaded_at` as `product_review.reviewExtension.media.uploadedAt`,
  `product_review.reviewExtension.media`.`file_name` as `product_review.reviewExtension.media.fileName`,
  `product_review.reviewExtension.media`.`file_size` as `product_review.reviewExtension.media.fileSize`,
  `product_review.reviewExtension.media`.`media_type` as `product_review.reviewExtension.media.mediaTypeRaw`,
  `product_review.reviewExtension.media`.`meta_data` as `product_review.reviewExtension.media.metaData`,
  `product_review.reviewExtension.media`.`config` as `product_review.reviewExtension.media.config`,
  `product_review.reviewExtension.media`.`path` as `product_review.reviewExtension.media.path`,
  `product_review.reviewExtension.media`.`private` as `product_review.reviewExtension.media.private`,
  `product_review.reviewExtension.media`.`thumbnails_ro` as `product_review.reviewExtension.media.thumbnailsRo`,
  `product_review.reviewExtension.media`.`created_at` as `product_review.reviewExtension.media.createdAt`,
  `product_review.reviewExtension.media`.`updated_at` as `product_review.reviewExtension.media.updatedAt`,
  `product_review.reviewExtension.media.translation.override_2.title`,
  `product_review.reviewExtension.media.translation.override_1.title`,
  `product_review.reviewExtension.media.translation.title`,
  COALESCE(
    `product_review.reviewExtension.media.translation.override_2.title`,
    `product_review.reviewExtension.media.translation.override_1.title`,
    `product_review.reviewExtension.media.translation.title`
  ) as `product_review.reviewExtension.media.title`,
  `product_review.reviewExtension.media.translation.override_2.alt`,
  `product_review.reviewExtension.media.translation.override_1.alt`,
  `product_review.reviewExtension.media.translation.alt`,
  COALESCE(
    `product_review.reviewExtension.media.translation.override_2.alt`,
    `product_review.reviewExtension.media.translation.override_1.alt`,
    `product_review.reviewExtension.media.translation.alt`
  ) as `product_review.reviewExtension.media.alt`,
  `product_review.reviewExtension.media.translation.override_2.customFields`,
  `product_review.reviewExtension.media.translation.override_1.customFields`,
  `product_review.reviewExtension.media.translation.customFields`,
  COALESCE(
    `product_review.reviewExtension.media.translation.override_2.customFields`,
    `product_review.reviewExtension.media.translation.override_1.customFields`,
    `product_review.reviewExtension.media.translation.customFields`
  ) as `product_review.reviewExtension.media.customFields`,
  `product_review.reviewExtension`.`created_at` as `product_review.reviewExtension.createdAt`,
  `product_review.reviewExtension`.`updated_at` as `product_review.reviewExtension.updatedAt`
FROM
  `product_review`
  LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id`
  AND `product_review`.`product_version_id` = `product_review.product`.`version_id`
  LEFT JOIN `fourtwosix_review_extension` `product_review.reviewExtension` ON `product_review`.`id` = `product_review.reviewExtension`.`review_id`
  LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id`
  AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id`
  LEFT JOIN `order` `product_review.reviewExtension.order` ON `product_review.reviewExtension`.`order_id` = `product_review.reviewExtension.order`.`id`
  AND `product_review.reviewExtension.order`.`version_id` = UNHEX(
    "0fa91ce3e96a4bc2be4bd9ce752c3425"
  )
  LEFT JOIN `media` `product_review.reviewExtension.media` ON `product_review.reviewExtension`.`media_id` = `product_review.reviewExtension.media`.`id`
  LEFT JOIN `order_customer` `product_review.reviewExtension.order.orderCustomer` ON `product_review.reviewExtension.order`.`id` = `product_review.reviewExtension.order.orderCustomer`.`order_id`
  AND `product_review.reviewExtension.order`.`version_id` = `product_review.reviewExtension.order.orderCustomer`.`order_version_id`
  LEFT JOIN (
    SELECT
      `product_review.reviewExtension.media.translation`.`media_id`,
      `product_review.reviewExtension.media.translation`.`alt` as `product_review.reviewExtension.media.translation.alt`,
      `product_review.reviewExtension.media.translation.override_1`.`alt` as `product_review.reviewExtension.media.translation.override_1.alt`,
      `product_review.reviewExtension.media.translation.override_2`.`alt` as `product_review.reviewExtension.media.translation.override_2.alt`,
      `product_review.reviewExtension.media.translation`.`title` as `product_review.reviewExtension.media.translation.title`,
      `product_review.reviewExtension.media.translation.override_1`.`title` as `product_review.reviewExtension.media.translation.override_1.title`,
      `product_review.reviewExtension.media.translation.override_2`.`title` as `product_review.reviewExtension.media.translation.override_2.title`,
      `product_review.reviewExtension.media.translation`.`custom_fields` as `product_review.reviewExtension.media.translation.customFields`,
      `product_review.reviewExtension.media.translation.override_1`.`custom_fields` as `product_review.reviewExtension.media.translation.override_1.customFields`,
      `product_review.reviewExtension.media.translation.override_2`.`custom_fields` as `product_review.reviewExtension.media.translation.override_2.customFields`
    FROM
      `media_translation` `product_review.reviewExtension.media.translation`
      LEFT JOIN `media_translation` `product_review.reviewExtension.media.translation.override_1` ON `product_review.reviewExtension.media.translation`.`media_id` = `product_review.reviewExtension.media.translation.override_1`.`media_id`
      AND `product_review.reviewExtension.media.translation.override_1`.`language_id` = ?
      LEFT JOIN `media_translation` `product_review.reviewExtension.media.translation.override_2` ON `product_review.reviewExtension.media.translation`.`media_id` = `product_review.reviewExtension.media.translation.override_2`.`media_id`
      AND `product_review.reviewExtension.media.translation.override_2`.`language_id` = ?
    WHERE
      `product_review.reviewExtension.media.translation`.`language_id` = ?
  ) `product_review.reviewExtension.media.media_translation` ON `product_review.reviewExtension.media.media_translation`.`media_id` = `product_review.reviewExtension.media`.`id`
WHERE
  (
    (
      (`product_review`.`status` = ?)
      AND (
        `product_review.product`.`id` = ?
        OR `product_review.product`.`parent_id` = ?
      )
    )
  )

SELECT `product_review`.`id` as `product_review.id`, `product_review`.`product_id` as `product_review.productId`, `product_review`.`product_version_id` as `product_review.productVersionId`, `product_review`.`customer_id` as `product_review.customerId`, `product_review`.`sales_channel_id` as `product_review.salesChannelId`, `product_review`.`language_id` as `product_review.languageId`, `product_review`.`external_user` as `product_review.externalUser`, `product_review`.`external_email` as `product_review.externalEmail`, `product_review`.`title` as `product_review.title`, `product_review`.`content` as `product_review.content`, `product_review`.`points` as `product_review.points`, `product_review`.`status` as `product_review.status`, `product_review`.`comment` as `product_review.comment`, `product_review`.`custom_fields` as `product_review.customFields`, `product_review`.`created_at` as `product_review.createdAt`, `product_review`.`updated_at` as `product_review.updatedAt`, `product_review.reviewExtension`.`id` as `product_review.reviewExtension.id`, `product_review.reviewExtension`.`review_id` as `product_review.reviewExtension.reviewId`, `product_review.reviewExtension`.`order_id` as `product_review.reviewExtension.orderId`, `product_review.reviewExtension`.`media_id` as `product_review.reviewExtension.mediaId`, `product_review.reviewExtension.order`.`id` as `product_review.reviewExtension.order.id`, `product_review.reviewExtension.order`.`version_id` as `product_review.reviewExtension.order.versionId`, `product_review.reviewExtension.order`.`auto_increment` as `product_review.reviewExtension.order.autoIncrement`, `product_review.reviewExtension.order`.`order_number` as `product_review.reviewExtension.order.orderNumber`, `product_review.reviewExtension.order`.`billing_address_id` as `product_review.reviewExtension.order.billingAddressId`, `product_review.reviewExtension.order`.`billing_address_version_id` as `product_review.reviewExtension.order.billingAddressVersionId`, `product_review.reviewExtension.order`.`currency_id` as `product_review.reviewExtension.order.currencyId`, `product_review.reviewExtension.order`.`language_id` as `product_review.reviewExtension.order.languageId`, `product_review.reviewExtension.order`.`sales_channel_id` as `product_review.reviewExtension.order.salesChannelId`, `product_review.reviewExtension.order`.`order_date_time` as `product_review.reviewExtension.order.orderDateTime`, `product_review.reviewExtension.order`.`order_date` as `product_review.reviewExtension.order.orderDate`, `product_review.reviewExtension.order`.`price` as `product_review.reviewExtension.order.price`, `product_review.reviewExtension.order`.`amount_total` as `product_review.reviewExtension.order.amountTotal`, `product_review.reviewExtension.order`.`amount_net` as `product_review.reviewExtension.order.amountNet`, `product_review.reviewExtension.order`.`position_price` as `product_review.reviewExtension.order.positionPrice`, `product_review.reviewExtension.order`.`tax_status` as `product_review.reviewExtension.order.taxStatus`, `product_review.reviewExtension.order`.`shipping_costs` as `product_review.reviewExtension.order.shippingCosts`, `product_review.reviewExtension.order`.`shipping_total` as `product_review.reviewExtension.order.shippingTotal`, `product_review.reviewExtension.order`.`currency_factor` as `product_review.reviewExtension.order.currencyFactor`, `product_review.reviewExtension.order`.`deep_link_code` as `product_review.reviewExtension.order.deepLinkCode`, `product_review.reviewExtension.order`.`affiliate_code` as `product_review.reviewExtension.order.affiliateCode`, `product_review.reviewExtension.order`.`campaign_code` as `product_review.reviewExtension.order.campaignCode`, `product_review.reviewExtension.order`.`customer_comment` as `product_review.reviewExtension.order.customerComment`, `product_review.reviewExtension.order`.`source` as `product_review.reviewExtension.order.source`, `product_review.reviewExtension.order`.`state_id` as `product_review.reviewExtension.order.stateId`, `product_review.reviewExtension.order`.`rule_ids` as `product_review.reviewExtension.order.ruleIds`, `product_review.reviewExtension.order`.`custom_fields` as `product_review.reviewExtension.order.customFields`, `product_review.reviewExtension.order`.`created_by_id` as `product_review.reviewExtension.order.createdById`, `product_review.reviewExtension.order`.`updated_by_id` as `product_review.reviewExtension.order.updatedById`, `product_review.reviewExtension.order.orderCustomer`.`id` as `product_review.reviewExtension.order.orderCustomer.id`, `product_review.reviewExtension.order.orderCustomer`.`version_id` as `product_review.reviewExtension.order.orderCustomer.versionId`, `product_review.reviewExtension.order.orderCustomer`.`customer_id` as `product_review.reviewExtension.order.orderCustomer.customerId`, `product_review.reviewExtension.order.orderCustomer`.`order_id` as `product_review.reviewExtension.order.orderCustomer.orderId`, `product_review.reviewExtension.order.orderCustomer`.`order_version_id` as `product_review.reviewExtension.order.orderCustomer.orderVersionId`, `product_review.reviewExtension.order.orderCustomer`.`email` as `product_review.reviewExtension.order.orderCustomer.email`, `product_review.reviewExtension.order.orderCustomer`.`salutation_id` as `product_review.reviewExtension.order.orderCustomer.salutationId`, `product_review.reviewExtension.order.orderCustomer`.`first_name` as `product_review.reviewExtension.order.orderCustomer.firstName`, `product_review.reviewExtension.order.orderCustomer`.`last_name` as `product_review.reviewExtension.order.orderCustomer.lastName`, `product_review.reviewExtension.order.orderCustomer`.`company` as `product_review.reviewExtension.order.orderCustomer.company`, `product_review.reviewExtension.order.orderCustomer`.`title` as `product_review.reviewExtension.order.orderCustomer.title`, `product_review.reviewExtension.order.orderCustomer`.`vat_ids` as `product_review.reviewExtension.order.orderCustomer.vatIds`, `product_review.reviewExtension.order.orderCustomer`.`customer_number` as `product_review.reviewExtension.order.orderCustomer.customerNumber`, `product_review.reviewExtension.order.orderCustomer`.`custom_fields` as `product_review.reviewExtension.order.orderCustomer.customFields`, `product_review.reviewExtension.order.orderCustomer`.`remote_address` as `product_review.reviewExtension.order.orderCustomer.remoteAddress`, `product_review.reviewExtension.order.orderCustomer`.`created_at` as `product_review.reviewExtension.order.orderCustomer.createdAt`, `product_review.reviewExtension.order.orderCustomer`.`updated_at` as `product_review.reviewExtension.order.orderCustomer.updatedAt`, `product_review.reviewExtension.order`.`item_rounding` as `product_review.reviewExtension.order.itemRounding`, `product_review.reviewExtension.order`.`total_rounding` as `product_review.reviewExtension.order.totalRounding`, `product_review.reviewExtension.order`.`created_at` as `product_review.reviewExtension.order.createdAt`, `product_review.reviewExtension.order`.`updated_at` as `product_review.reviewExtension.order.updatedAt`, `product_review.reviewExtension.media`.`id` as `product_review.reviewExtension.media.id`, `product_review.reviewExtension.media`.`user_id` as `product_review.reviewExtension.media.userId`, `product_review.reviewExtension.media`.`media_folder_id` as `product_review.reviewExtension.media.mediaFolderId`, `product_review.reviewExtension.media`.`mime_type` as `product_review.reviewExtension.media.mimeType`, `product_review.reviewExtension.media`.`file_extension` as `product_review.reviewExtension.media.fileExtension`, `product_review.reviewExtension.media`.`uploaded_at` as `product_review.reviewExtension.media.uploadedAt`, `product_review.reviewExtension.media`.`file_name` as `product_review.reviewExtension.media.fileName`, `product_review.reviewExtension.media`.`file_size` as `product_review.reviewExtension.media.fileSize`, `product_review.reviewExtension.media`.`media_type` as `product_review.reviewExtension.media.mediaTypeRaw`, `product_review.reviewExtension.media`.`meta_data` as `product_review.reviewExtension.media.metaData`, `product_review.reviewExtension.media`.`config` as `product_review.reviewExtension.media.config`, `product_review.reviewExtension.media`.`path` as `product_review.reviewExtension.media.path`, `product_review.reviewExtension.media`.`private` as `product_review.reviewExtension.media.private`, `product_review.reviewExtension.media`.`thumbnails_ro` as `product_review.reviewExtension.media.thumbnailsRo`, `product_review.reviewExtension.media`.`created_at` as `product_review.reviewExtension.media.createdAt`, `product_review.reviewExtension.media`.`updated_at` as `product_review.reviewExtension.media.updatedAt`, `product_review.reviewExtension.media.translation.override_2.title`, `product_review.reviewExtension.media.translation.override_1.title`, `product_review.reviewExtension.media.translation.title`, COALESCE(`product_review.reviewExtension.media.translation.override_2.title`,`product_review.reviewExtension.media.translation.override_1.title`,`product_review.reviewExtension.media.translation.title`) as `product_review.reviewExtension.media.title`, `product_review.reviewExtension.media.translation.override_2.alt`, `product_review.reviewExtension.media.translation.override_1.alt`, `product_review.reviewExtension.media.translation.alt`, COALESCE(`product_review.reviewExtension.media.translation.override_2.alt`,`product_review.reviewExtension.media.translation.override_1.alt`,`product_review.reviewExtension.media.translation.alt`) as `product_review.reviewExtension.media.alt`, `product_review.reviewExtension.media.translation.override_2.customFields`, `product_review.reviewExtension.media.translation.override_1.customFields`, `product_review.reviewExtension.media.translation.customFields`, COALESCE(`product_review.reviewExtension.media.translation.override_2.customFields`,`product_review.reviewExtension.media.translation.override_1.customFields`,`product_review.reviewExtension.media.translation.customFields`) as `product_review.reviewExtension.media.customFields`, `product_review.reviewExtension`.`created_at` as `product_review.reviewExtension.createdAt`, `product_review.reviewExtension`.`updated_at` as `product_review.reviewExtension.updatedAt` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `fourtwosix_review_extension` `product_review.reviewExtension` ON `product_review`.`id` = `product_review.reviewExtension`.`review_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` LEFT JOIN `order` `product_review.reviewExtension.order` ON `product_review.reviewExtension`.`order_id` = `product_review.reviewExtension.order`.`id` AND `product_review.reviewExtension.order`.`version_id` = UNHEX("0fa91ce3e96a4bc2be4bd9ce752c3425") LEFT JOIN `media` `product_review.reviewExtension.media` ON `product_review.reviewExtension`.`media_id` = `product_review.reviewExtension.media`.`id` LEFT JOIN `order_customer` `product_review.reviewExtension.order.orderCustomer` ON `product_review.reviewExtension.order`.`id` = `product_review.reviewExtension.order.orderCustomer`.`order_id` AND `product_review.reviewExtension.order`.`version_id` = `product_review.reviewExtension.order.orderCustomer`.`order_version_id` LEFT JOIN (SELECT `product_review.reviewExtension.media.translation`.`media_id`, `product_review.reviewExtension.media.translation`.`alt` as `product_review.reviewExtension.media.translation.alt`, `product_review.reviewExtension.media.translation.override_1`.`alt` as `product_review.reviewExtension.media.translation.override_1.alt`, `product_review.reviewExtension.media.translation.override_2`.`alt` as `product_review.reviewExtension.media.translation.override_2.alt`, `product_review.reviewExtension.media.translation`.`title` as `product_review.reviewExtension.media.translation.title`, `product_review.reviewExtension.media.translation.override_1`.`title` as `product_review.reviewExtension.media.translation.override_1.title`, `product_review.reviewExtension.media.translation.override_2`.`title` as `product_review.reviewExtension.media.translation.override_2.title`, `product_review.reviewExtension.media.translation`.`custom_fields` as `product_review.reviewExtension.media.translation.customFields`, `product_review.reviewExtension.media.translation.override_1`.`custom_fields` as `product_review.reviewExtension.media.translation.override_1.customFields`, `product_review.reviewExtension.media.translation.override_2`.`custom_fields` as `product_review.reviewExtension.media.translation.override_2.customFields` FROM `media_translation` `product_review.reviewExtension.media.translation` LEFT JOIN `media_translation` `product_review.reviewExtension.media.translation.override_1` ON `product_review.reviewExtension.media.translation`.`media_id` = `product_review.reviewExtension.media.translation.override_1`.`media_id` AND `product_review.reviewExtension.media.translation.override_1`.`language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 LEFT JOIN `media_translation` `product_review.reviewExtension.media.translation.override_2` ON `product_review.reviewExtension.media.translation`.`media_id` = `product_review.reviewExtension.media.translation.override_2`.`media_id` AND `product_review.reviewExtension.media.translation.override_2`.`language_id` = 0x2F37BFD0F23F482BAD9D34A02199499B WHERE `product_review.reviewExtension.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_review.reviewExtension.media.media_translation` ON `product_review.reviewExtension.media.media_translation`.`media_id` = `product_review.reviewExtension.media`.`id` WHERE (((`product_review`.`status` = 1) AND (`product_review.product`.`id` = 0xB5AD2599289D43A89FEC2CDDB7EBEEFF OR `product_review.product`.`parent_id` = 0xB5AD2599289D43A89FEC2CDDB7EBEEFF)));

SELECT
  `dreisc_seo_setting`.`id` as `dreisc_seo_setting.id`,
  `dreisc_seo_setting`.`key` as `dreisc_seo_setting.key`,
  `dreisc_seo_setting`.`value` as `dreisc_seo_setting.value`,
  `dreisc_seo_setting`.`sales_channel_id` as `dreisc_seo_setting.salesChannelId`,
  `dreisc_seo_setting`.`created_at` as `dreisc_seo_setting.createdAt`,
  `dreisc_seo_setting`.`updated_at` as `dreisc_seo_setting.updatedAt`
FROM
  `dreisc_seo_setting`
WHERE
  (
    `dreisc_seo_setting`.`sales_channel_id` <=> ?
  )

SELECT `dreisc_seo_setting`.`id` as `dreisc_seo_setting.id`, `dreisc_seo_setting`.`key` as `dreisc_seo_setting.key`, `dreisc_seo_setting`.`value` as `dreisc_seo_setting.value`, `dreisc_seo_setting`.`sales_channel_id` as `dreisc_seo_setting.salesChannelId`, `dreisc_seo_setting`.`created_at` as `dreisc_seo_setting.createdAt`, `dreisc_seo_setting`.`updated_at` as `dreisc_seo_setting.updatedAt` FROM `dreisc_seo_setting` WHERE (`dreisc_seo_setting`.`sales_channel_id` <=> NULL);

# breadcrumb-extension::read
SELECT
  `category`.`id` as `category.id`,
  `category`.`version_id` as `category.versionId`,
  `category`.`parent_id` as `category.parentId`,
  `category`.`parent_version_id` as `category.parentVersionId`,
  `category`.`after_category_id` as `category.afterCategoryId`,
  `category`.`after_category_version_id` as `category.afterCategoryVersionId`,
  `category`.`media_id` as `category.mediaId`,
  `category`.`display_nested_products` as `category.displayNestedProducts`,
  `category`.`auto_increment` as `category.autoIncrement`,
  `category`.`level` as `category.level`,
  `category`.`path` as `category.path`,
  `category`.`child_count` as `category.childCount`,
  `category`.`type` as `category.type`,
  `category`.`product_assignment_type` as `category.productAssignmentType`,
  `category`.`visible` as `category.visible`,
  `category`.`active` as `category.active`,
  `category`.`cms_page_id` as `category.cmsPageId`,
  `category`.`cms_page_version_id` as `category.cmsPageVersionId`,
  `category`.`product_stream_id` as `category.productStreamId`,
  `category`.`custom_entity_type_id` as `category.customEntityTypeId`,
  `category`.`created_at` as `category.createdAt`,
  `category`.`updated_at` as `category.updatedAt`,
  `category.productCountExtension`.`category_id` as `category.productCountExtension.categoryId`,
  `category.productCountExtension`.`count` as `category.productCountExtension.count`,
  `category.productCountExtension`.`created_at` as `category.productCountExtension.createdAt`,
  `category.productCountExtension`.`updated_at` as `category.productCountExtension.updatedAt`,
  `category.translation.override_2.name`,
  `category.translation.override_1.name`,
  `category.translation.name`,
  COALESCE(
    `category.translation.override_2.name`,
    `category.translation.override_1.name`,
    `category.translation.name`
  ) as `category.name`,
  `category.translation.override_2.breadcrumb`,
  `category.translation.override_1.breadcrumb`,
  `category.translation.breadcrumb`,
  COALESCE(
    `category.translation.override_2.breadcrumb`,
    `category.translation.override_1.breadcrumb`,
    `category.translation.breadcrumb`
  ) as `category.breadcrumb`,
  `category.translation.override_2.slotConfig`,
  `category.translation.override_1.slotConfig`,
  `category.translation.slotConfig`,
  COALESCE(
    `category.translation.override_2.slotConfig`,
    `category.translation.override_1.slotConfig`,
    `category.translation.slotConfig`
  ) as `category.slotConfig`,
  `category.translation.override_2.linkType`,
  `category.translation.override_1.linkType`,
  `category.translation.linkType`,
  COALESCE(
    `category.translation.override_2.linkType`,
    `category.translation.override_1.linkType`,
    `category.translation.linkType`
  ) as `category.linkType`,
  `category.translation.override_2.internalLink`,
  `category.translation.override_1.internalLink`,
  `category.translation.internalLink`,
  COALESCE(
    `category.translation.override_2.internalLink`,
    `category.translation.override_1.internalLink`,
    `category.translation.internalLink`
  ) as `category.internalLink`,
  `category.translation.override_2.externalLink`,
  `category.translation.override_1.externalLink`,
  `category.translation.externalLink`,
  COALESCE(
    `category.translation.override_2.externalLink`,
    `category.translation.override_1.externalLink`,
    `category.translation.externalLink`
  ) as `category.externalLink`,
  `category.translation.override_2.linkNewTab`,
  `category.translation.override_1.linkNewTab`,
  `category.translation.linkNewTab`,
  COALESCE(
    `category.translation.override_2.linkNewTab`,
    `category.translation.override_1.linkNewTab`,
    `category.translation.linkNewTab`
  ) as `category.linkNewTab`,
  `category.translation.override_2.description`,
  `category.translation.override_1.description`,
  `category.translation.description`,
  COALESCE(
    `category.translation.override_2.description`,
    `category.translation.override_1.description`,
    `category.translation.description`
  ) as `category.description`,
  `category.translation.override_2.metaTitle`,
  `category.translation.override_1.metaTitle`,
  `category.translation.metaTitle`,
  COALESCE(
    `category.translation.override_2.metaTitle`,
    `category.translation.override_1.metaTitle`,
    `category.translation.metaTitle`
  ) as `category.metaTitle`,
  `category.translation.override_2.metaDescription`,
  `category.translation.override_1.metaDescription`,
  `category.translation.metaDescription`,
  COALESCE(
    `category.translation.override_2.metaDescription`,
    `category.translation.override_1.metaDescription`,
    `category.translation.metaDescription`
  ) as `category.metaDescription`,
  `category.translation.override_2.keywords`,
  `category.translation.override_1.keywords`,
  `category.translation.keywords`,
  COALESCE(
    `category.translation.override_2.keywords`,
    `category.translation.override_1.keywords`,
    `category.translation.keywords`
  ) as `category.keywords`,
  `category.translation.override_2.customFields`,
  `category.translation.override_1.customFields`,
  `category.translation.customFields`,
  COALESCE(
    `category.translation.override_2.customFields`,
    `category.translation.override_1.customFields`,
    `category.translation.customFields`
  ) as `category.customFields`
FROM
  `category`
  LEFT JOIN `category_product_count_extension` `category.productCountExtension` ON `category`.`id` = `category.productCountExtension`.`category_id`
  LEFT JOIN (
    SELECT
      `category.translation`.`category_id`,
      `category.translation`.`category_version_id`,
      `category.translation`.`breadcrumb` as `category.translation.breadcrumb`,
      `category.translation.override_1`.`breadcrumb` as `category.translation.override_1.breadcrumb`,
      `category.translation.override_2`.`breadcrumb` as `category.translation.override_2.breadcrumb`,
      `category.translation`.`name` as `category.translation.name`,
      `category.translation.override_1`.`name` as `category.translation.override_1.name`,
      `category.translation.override_2`.`name` as `category.translation.override_2.name`,
      `category.translation`.`custom_fields` as `category.translation.customFields`,
      `category.translation.override_1`.`custom_fields` as `category.translation.override_1.customFields`,
      `category.translation.override_2`.`custom_fields` as `category.translation.override_2.customFields`,
      `category.translation`.`slot_config` as `category.translation.slotConfig`,
      `category.translation.override_1`.`slot_config` as `category.translation.override_1.slotConfig`,
      `category.translation.override_2`.`slot_config` as `category.translation.override_2.slotConfig`,
      `category.translation`.`link_type` as `category.translation.linkType`,
      `category.translation.override_1`.`link_type` as `category.translation.override_1.linkType`,
      `category.translation.override_2`.`link_type` as `category.translation.override_2.linkType`,
      `category.translation`.`internal_link` as `category.translation.internalLink`,
      `category.translation.override_1`.`internal_link` as `category.translation.override_1.internalLink`,
      `category.translation.override_2`.`internal_link` as `category.translation.override_2.internalLink`,
      `category.translation`.`external_link` as `category.translation.externalLink`,
      `category.translation.override_1`.`external_link` as `category.translation.override_1.externalLink`,
      `category.translation.override_2`.`external_link` as `category.translation.override_2.externalLink`,
      `category.translation`.`link_new_tab` as `category.translation.linkNewTab`,
      `category.translation.override_1`.`link_new_tab` as `category.translation.override_1.linkNewTab`,
      `category.translation.override_2`.`link_new_tab` as `category.translation.override_2.linkNewTab`,
      `category.translation`.`description` as `category.translation.description`,
      `category.translation.override_1`.`description` as `category.translation.override_1.description`,
      `category.translation.override_2`.`description` as `category.translation.override_2.description`,
      `category.translation`.`meta_title` as `category.translation.metaTitle`,
      `category.translation.override_1`.`meta_title` as `category.translation.override_1.metaTitle`,
      `category.translation.override_2`.`meta_title` as `category.translation.override_2.metaTitle`,
      `category.translation`.`meta_description` as `category.translation.metaDescription`,
      `category.translation.override_1`.`meta_description` as `category.translation.override_1.metaDescription`,
      `category.translation.override_2`.`meta_description` as `category.translation.override_2.metaDescription`,
      `category.translation`.`keywords` as `category.translation.keywords`,
      `category.translation.override_1`.`keywords` as `category.translation.override_1.keywords`,
      `category.translation.override_2`.`keywords` as `category.translation.override_2.keywords`
    FROM
      `category_translation` `category.translation`
      LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation`.`category_id` = `category.translation.override_1`.`category_id`
      AND `category.translation.override_1`.`language_id` = ?
      AND `category.translation`.`category_version_id` = `category.translation.override_1`.`category_version_id`
      LEFT JOIN `category_translation` `category.translation.override_2` ON `category.translation`.`category_id` = `category.translation.override_2`.`category_id`
      AND `category.translation.override_2`.`language_id` = ?
      AND `category.translation`.`category_version_id` = `category.translation.override_2`.`category_version_id`
    WHERE
      `category.translation`.`language_id` = ?
  ) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id`
  AND `category.category_translation`.`category_version_id` = `category`.`version_id`
WHERE
  (`category`.`version_id` = ?)
  AND (
    `category`.`id` IN (?, ?)
  )

# breadcrumb-extension::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.productCountExtension`.`category_id` as `category.productCountExtension.categoryId`, `category.productCountExtension`.`count` as `category.productCountExtension.count`, `category.productCountExtension`.`created_at` as `category.productCountExtension.createdAt`, `category.productCountExtension`.`updated_at` as `category.productCountExtension.updatedAt`, `category.translation.override_2.name`, `category.translation.override_1.name`, `category.translation.name`, COALESCE(`category.translation.override_2.name`,`category.translation.override_1.name`,`category.translation.name`) as `category.name`, `category.translation.override_2.breadcrumb`, `category.translation.override_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.override_2.breadcrumb`,`category.translation.override_1.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.override_2.slotConfig`, `category.translation.override_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.override_2.slotConfig`,`category.translation.override_1.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.override_2.linkType`, `category.translation.override_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.override_2.linkType`,`category.translation.override_1.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.override_2.internalLink`, `category.translation.override_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.override_2.internalLink`,`category.translation.override_1.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.override_2.externalLink`, `category.translation.override_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.override_2.externalLink`,`category.translation.override_1.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.override_2.linkNewTab`, `category.translation.override_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.override_2.linkNewTab`,`category.translation.override_1.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.override_2.description`, `category.translation.override_1.description`, `category.translation.description`, COALESCE(`category.translation.override_2.description`,`category.translation.override_1.description`,`category.translation.description`) as `category.description`, `category.translation.override_2.metaTitle`, `category.translation.override_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.override_2.metaTitle`,`category.translation.override_1.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.override_2.metaDescription`, `category.translation.override_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.override_2.metaDescription`,`category.translation.override_1.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.override_2.keywords`, `category.translation.override_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.override_2.keywords`,`category.translation.override_1.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.override_2.customFields`, `category.translation.override_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.override_2.customFields`,`category.translation.override_1.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN `category_product_count_extension` `category.productCountExtension` ON `category`.`id` = `category.productCountExtension`.`category_id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation.override_1`.`breadcrumb` as `category.translation.override_1.breadcrumb`, `category.translation.override_2`.`breadcrumb` as `category.translation.override_2.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation.override_1`.`name` as `category.translation.override_1.name`, `category.translation.override_2`.`name` as `category.translation.override_2.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation.override_1`.`custom_fields` as `category.translation.override_1.customFields`, `category.translation.override_2`.`custom_fields` as `category.translation.override_2.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation.override_1`.`slot_config` as `category.translation.override_1.slotConfig`, `category.translation.override_2`.`slot_config` as `category.translation.override_2.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation.override_1`.`link_type` as `category.translation.override_1.linkType`, `category.translation.override_2`.`link_type` as `category.translation.override_2.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation.override_1`.`internal_link` as `category.translation.override_1.internalLink`, `category.translation.override_2`.`internal_link` as `category.translation.override_2.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation.override_1`.`external_link` as `category.translation.override_1.externalLink`, `category.translation.override_2`.`external_link` as `category.translation.override_2.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation.override_1`.`link_new_tab` as `category.translation.override_1.linkNewTab`, `category.translation.override_2`.`link_new_tab` as `category.translation.override_2.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation.override_1`.`description` as `category.translation.override_1.description`, `category.translation.override_2`.`description` as `category.translation.override_2.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation.override_1`.`meta_title` as `category.translation.override_1.metaTitle`, `category.translation.override_2`.`meta_title` as `category.translation.override_2.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation.override_1`.`meta_description` as `category.translation.override_1.metaDescription`, `category.translation.override_2`.`meta_description` as `category.translation.override_2.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords`, `category.translation.override_1`.`keywords` as `category.translation.override_1.keywords`, `category.translation.override_2`.`keywords` as `category.translation.override_2.keywords` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation`.`category_id` = `category.translation.override_1`.`category_id` AND `category.translation.override_1`.`language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 AND `category.translation`.`category_version_id` = `category.translation.override_1`.`category_version_id` LEFT JOIN `category_translation` `category.translation.override_2` ON `category.translation`.`category_id` = `category.translation.override_2`.`category_id` AND `category.translation.override_2`.`language_id` = 0x2F37BFD0F23F482BAD9D34A02199499B AND `category.translation`.`category_version_id` = `category.translation.override_2`.`category_version_id` WHERE `category.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`category`.`id` IN (0x7BA1EB3B29AD4E5E8823FADE26C3DB38, 0x018D8E9493A37811883BB2F2AF9A795F));

# Load bundle product contents::association::zeobvBundleContents::association::options::read
SELECT
  `property_group_option`.`id` as `property_group_option.id`,
  `property_group_option`.`property_group_id` as `property_group_option.groupId`,
  `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`,
  `property_group_option`.`media_id` as `property_group_option.mediaId`,
  `property_group_option`.`created_at` as `property_group_option.createdAt`,
  `property_group_option`.`updated_at` as `property_group_option.updatedAt`,
  `property_group_option.group`.`id` as `property_group_option.group.id`,
  `property_group_option.group`.`display_type` as `property_group_option.group.displayType`,
  `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`,
  `property_group_option.group`.`filterable` as `property_group_option.group.filterable`,
  `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`,
  `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`,
  `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`,
  `property_group_option.group.translation.override_2.name`,
  `property_group_option.group.translation.override_1.name`,
  `property_group_option.group.translation.name`,
  COALESCE(
    `property_group_option.group.translation.override_2.name`,
    `property_group_option.group.translation.override_1.name`,
    `property_group_option.group.translation.name`
  ) as `property_group_option.group.name`,
  `property_group_option.group.translation.override_2.description`,
  `property_group_option.group.translation.override_1.description`,
  `property_group_option.group.translation.description`,
  COALESCE(
    `property_group_option.group.translation.override_2.description`,
    `property_group_option.group.translation.override_1.description`,
    `property_group_option.group.translation.description`
  ) as `property_group_option.group.description`,
  `property_group_option.group.translation.override_2.position`,
  `property_group_option.group.translation.override_1.position`,
  `property_group_option.group.translation.position`,
  COALESCE(
    `property_group_option.group.translation.override_2.position`,
    `property_group_option.group.translation.override_1.position`,
    `property_group_option.group.translation.position`
  ) as `property_group_option.group.position`,
  `property_group_option.group.translation.override_2.customFields`,
  `property_group_option.group.translation.override_1.customFields`,
  `property_group_option.group.translation.customFields`,
  COALESCE(
    `property_group_option.group.translation.override_2.customFields`,
    `property_group_option.group.translation.override_1.customFields`,
    `property_group_option.group.translation.customFields`
  ) as `property_group_option.group.customFields`,
  `property_group_option.translation.override_2.name`,
  `property_group_option.translation.override_1.name`,
  `property_group_option.translation.name`,
  COALESCE(
    `property_group_option.translation.override_2.name`,
    `property_group_option.translation.override_1.name`,
    `property_group_option.translation.name`
  ) as `property_group_option.name`,
  `property_group_option.translation.override_2.position`,
  `property_group_option.translation.override_1.position`,
  `property_group_option.translation.position`,
  COALESCE(
    `property_group_option.translation.override_2.position`,
    `property_group_option.translation.override_1.position`,
    `property_group_option.translation.position`
  ) as `property_group_option.position`,
  `property_group_option.translation.override_2.customFields`,
  `property_group_option.translation.override_1.customFields`,
  `property_group_option.translation.customFields`,
  COALESCE(
    `property_group_option.translation.override_2.customFields`,
    `property_group_option.translation.override_1.customFields`,
    `property_group_option.translation.customFields`
  ) as `property_group_option.customFields`
FROM
  `property_group_option`
  LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id`
  LEFT JOIN (
    SELECT
      `property_group_option.translation`.`property_group_option_id`,
      `property_group_option.translation`.`name` as `property_group_option.translation.name`,
      `property_group_option.translation.override_1`.`name` as `property_group_option.translation.override_1.name`,
      `property_group_option.translation.override_2`.`name` as `property_group_option.translation.override_2.name`,
      `property_group_option.translation`.`position` as `property_group_option.translation.position`,
      `property_group_option.translation.override_1`.`position` as `property_group_option.translation.override_1.position`,
      `property_group_option.translation.override_2`.`position` as `property_group_option.translation.override_2.position`,
      `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields`,
      `property_group_option.translation.override_1`.`custom_fields` as `property_group_option.translation.override_1.customFields`,
      `property_group_option.translation.override_2`.`custom_fields` as `property_group_option.translation.override_2.customFields`
    FROM
      `property_group_option_translation` `property_group_option.translation`
      LEFT JOIN `property_group_option_translation` `property_group_option.translation.override_1` ON `property_group_option.translation`.`property_group_option_id` = `property_group_option.translation.override_1`.`property_group_option_id`
      AND `property_group_option.translation.override_1`.`language_id` = ?
      LEFT JOIN `property_group_option_translation` `property_group_option.translation.override_2` ON `property_group_option.translation`.`property_group_option_id` = `property_group_option.translation.override_2`.`property_group_option_id`
      AND `property_group_option.translation.override_2`.`language_id` = ?
    WHERE
      `property_group_option.translation`.`language_id` = ?
  ) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id`
  LEFT JOIN (
    SELECT
      `property_group_option.group.translation`.`property_group_id`,
      `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`,
      `property_group_option.group.translation.override_1`.`name` as `property_group_option.group.translation.override_1.name`,
      `property_group_option.group.translation.override_2`.`name` as `property_group_option.group.translation.override_2.name`,
      `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`,
      `property_group_option.group.translation.override_1`.`description` as `property_group_option.group.translation.override_1.description`,
      `property_group_option.group.translation.override_2`.`description` as `property_group_option.group.translation.override_2.description`,
      `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`,
      `property_group_option.group.translation.override_1`.`position` as `property_group_option.group.translation.override_1.position`,
      `property_group_option.group.translation.override_2`.`position` as `property_group_option.group.translation.override_2.position`,
      `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields`,
      `property_group_option.group.translation.override_1`.`custom_fields` as `property_group_option.group.translation.override_1.customFields`,
      `property_group_option.group.translation.override_2`.`custom_fields` as `property_group_option.group.translation.override_2.customFields`
    FROM
      `property_group_translation` `property_group_option.group.translation`
      LEFT JOIN `property_group_translation` `property_group_option.group.translation.override_1` ON `property_group_option.group.translation`.`property_group_id` = `property_group_option.group.translation.override_1`.`property_group_id`
      AND `property_group_option.group.translation.override_1`.`language_id` = ?
      LEFT JOIN `property_group_translation` `property_group_option.group.translation.override_2` ON `property_group_option.group.translation`.`property_group_id` = `property_group_option.group.translation.override_2`.`property_group_id`
      AND `property_group_option.group.translation.override_2`.`language_id` = ?
    WHERE
      `property_group_option.group.translation`.`language_id` = ?
  ) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id`
WHERE
  `property_group_option`.`id` IN (?, ?, ?)

# Load bundle product contents::association::zeobvBundleContents::association::options::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.override_2.name`, `property_group_option.group.translation.override_1.name`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.override_2.name`,`property_group_option.group.translation.override_1.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.override_2.description`, `property_group_option.group.translation.override_1.description`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.override_2.description`,`property_group_option.group.translation.override_1.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.override_2.position`, `property_group_option.group.translation.override_1.position`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.override_2.position`,`property_group_option.group.translation.override_1.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.override_2.customFields`, `property_group_option.group.translation.override_1.customFields`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.override_2.customFields`,`property_group_option.group.translation.override_1.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.translation.override_2.name`, `property_group_option.translation.override_1.name`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.override_2.name`,`property_group_option.translation.override_1.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.override_2.position`, `property_group_option.translation.override_1.position`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.override_2.position`,`property_group_option.translation.override_1.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.override_2.customFields`, `property_group_option.translation.override_1.customFields`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.override_2.customFields`,`property_group_option.translation.override_1.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation.override_1`.`name` as `property_group_option.translation.override_1.name`, `property_group_option.translation.override_2`.`name` as `property_group_option.translation.override_2.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation.override_1`.`position` as `property_group_option.translation.override_1.position`, `property_group_option.translation.override_2`.`position` as `property_group_option.translation.override_2.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields`, `property_group_option.translation.override_1`.`custom_fields` as `property_group_option.translation.override_1.customFields`, `property_group_option.translation.override_2`.`custom_fields` as `property_group_option.translation.override_2.customFields` FROM `property_group_option_translation` `property_group_option.translation` LEFT JOIN `property_group_option_translation` `property_group_option.translation.override_1` ON `property_group_option.translation`.`property_group_option_id` = `property_group_option.translation.override_1`.`property_group_option_id` AND `property_group_option.translation.override_1`.`language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 LEFT JOIN `property_group_option_translation` `property_group_option.translation.override_2` ON `property_group_option.translation`.`property_group_option_id` = `property_group_option.translation.override_2`.`property_group_option_id` AND `property_group_option.translation.override_2`.`language_id` = 0x2F37BFD0F23F482BAD9D34A02199499B WHERE `property_group_option.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation.override_1`.`name` as `property_group_option.group.translation.override_1.name`, `property_group_option.group.translation.override_2`.`name` as `property_group_option.group.translation.override_2.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation.override_1`.`description` as `property_group_option.group.translation.override_1.description`, `property_group_option.group.translation.override_2`.`description` as `property_group_option.group.translation.override_2.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation.override_1`.`position` as `property_group_option.group.translation.override_1.position`, `property_group_option.group.translation.override_2`.`position` as `property_group_option.group.translation.override_2.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields`, `property_group_option.group.translation.override_1`.`custom_fields` as `property_group_option.group.translation.override_1.customFields`, `property_group_option.group.translation.override_2`.`custom_fields` as `property_group_option.group.translation.override_2.customFields` FROM `property_group_translation` `property_group_option.group.translation` LEFT JOIN `property_group_translation` `property_group_option.group.translation.override_1` ON `property_group_option.group.translation`.`property_group_id` = `property_group_option.group.translation.override_1`.`property_group_id` AND `property_group_option.group.translation.override_1`.`language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 LEFT JOIN `property_group_translation` `property_group_option.group.translation.override_2` ON `property_group_option.group.translation`.`property_group_id` = `property_group_option.group.translation.override_2`.`property_group_id` AND `property_group_option.group.translation.override_2`.`language_id` = 0x2F37BFD0F23F482BAD9D34A02199499B WHERE `property_group_option.group.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE `property_group_option`.`id` IN (0x050D960A3E934D1F8FAD37F405556801, 0x1194F12EF6534E0C95CECDE859FA2257, 0xB63B2AD2A8EF4ED99E177AF6C111676C);