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` = 0x81D02D9B9F794014B8109642D318DB72 OR `product_review.product`.`parent_id` = 0x81D02D9B9F794014B8109642D318DB72)));

# category::data::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.media`.`id` as `category.media.id`,
  `category.media`.`user_id` as `category.media.userId`,
  `category.media`.`media_folder_id` as `category.media.mediaFolderId`,
  `category.media`.`mime_type` as `category.media.mimeType`,
  `category.media`.`file_extension` as `category.media.fileExtension`,
  `category.media`.`uploaded_at` as `category.media.uploadedAt`,
  `category.media`.`file_name` as `category.media.fileName`,
  `category.media`.`file_size` as `category.media.fileSize`,
  `category.media`.`media_type` as `category.media.mediaTypeRaw`,
  `category.media`.`meta_data` as `category.media.metaData`,
  `category.media`.`config` as `category.media.config`,
  `category.media`.`path` as `category.media.path`,
  `category.media`.`private` as `category.media.private`,
  `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`,
  `category.media`.`created_at` as `category.media.createdAt`,
  `category.media`.`updated_at` as `category.media.updatedAt`,
  `category.media.translation.override_2.title`,
  `category.media.translation.override_1.title`,
  `category.media.translation.title`,
  COALESCE(
    `category.media.translation.override_2.title`,
    `category.media.translation.override_1.title`,
    `category.media.translation.title`
  ) as `category.media.title`,
  `category.media.translation.override_2.alt`,
  `category.media.translation.override_1.alt`,
  `category.media.translation.alt`,
  COALESCE(
    `category.media.translation.override_2.alt`,
    `category.media.translation.override_1.alt`,
    `category.media.translation.alt`
  ) as `category.media.alt`,
  `category.media.translation.override_2.customFields`,
  `category.media.translation.override_1.customFields`,
  `category.media.translation.customFields`,
  COALESCE(
    `category.media.translation.override_2.customFields`,
    `category.media.translation.override_1.customFields`,
    `category.media.translation.customFields`
  ) as `category.media.customFields`,
  `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 `media` `category.media` ON `category`.`media_id` = `category.media`.`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`
  LEFT JOIN (
    SELECT
      `category.media.translation`.`media_id`,
      `category.media.translation`.`alt` as `category.media.translation.alt`,
      `category.media.translation.override_1`.`alt` as `category.media.translation.override_1.alt`,
      `category.media.translation.override_2`.`alt` as `category.media.translation.override_2.alt`,
      `category.media.translation`.`title` as `category.media.translation.title`,
      `category.media.translation.override_1`.`title` as `category.media.translation.override_1.title`,
      `category.media.translation.override_2`.`title` as `category.media.translation.override_2.title`,
      `category.media.translation`.`custom_fields` as `category.media.translation.customFields`,
      `category.media.translation.override_1`.`custom_fields` as `category.media.translation.override_1.customFields`,
      `category.media.translation.override_2`.`custom_fields` as `category.media.translation.override_2.customFields`
    FROM
      `media_translation` `category.media.translation`
      LEFT JOIN `media_translation` `category.media.translation.override_1` ON `category.media.translation`.`media_id` = `category.media.translation.override_1`.`media_id`
      AND `category.media.translation.override_1`.`language_id` = ?
      LEFT JOIN `media_translation` `category.media.translation.override_2` ON `category.media.translation`.`media_id` = `category.media.translation.override_2`.`media_id`
      AND `category.media.translation.override_2`.`language_id` = ?
    WHERE
      `category.media.translation`.`language_id` = ?
  ) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id`
WHERE
  (`category`.`version_id` = ?)
  AND (
    `category`.`id` IN (?)
  )

# category::data::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.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.override_2.title`, `category.media.translation.override_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.override_2.title`,`category.media.translation.override_1.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.override_2.alt`, `category.media.translation.override_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.override_2.alt`,`category.media.translation.override_1.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.override_2.customFields`, `category.media.translation.override_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.override_2.customFields`,`category.media.translation.override_1.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `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 `media` `category.media` ON `category`.`media_id` = `category.media`.`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` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation.override_1`.`alt` as `category.media.translation.override_1.alt`, `category.media.translation.override_2`.`alt` as `category.media.translation.override_2.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation.override_1`.`title` as `category.media.translation.override_1.title`, `category.media.translation.override_2`.`title` as `category.media.translation.override_2.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields`, `category.media.translation.override_1`.`custom_fields` as `category.media.translation.override_1.customFields`, `category.media.translation.override_2`.`custom_fields` as `category.media.translation.override_2.customFields` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.override_1` ON `category.media.translation`.`media_id` = `category.media.translation.override_1`.`media_id` AND `category.media.translation.override_1`.`language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 LEFT JOIN `media_translation` `category.media.translation.override_2` ON `category.media.translation`.`media_id` = `category.media.translation.override_2`.`media_id` AND `category.media.translation.override_2`.`language_id` = 0x2F37BFD0F23F482BAD9D34A02199499B WHERE `category.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`category`.`id` IN (0x7B61F1C673A14BA7A90EA1AED2F7A74A));

# 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)