Symfony Profiler

# header::navigation::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.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.title`,
  COALESCE(
    `category.media.translation.title`,
    `category.media.translation.title`
  ) AS `category.media.title`,
  `category.media.translation.alt`,
  COALESCE(
    `category.media.translation.alt`,
    `category.media.translation.alt`
  ) AS `category.media.alt`,
  `category.media.translation.customFields`,
  COALESCE(
    `category.media.translation.customFields`,
    `category.media.translation.customFields`
  ) AS `category.media.customFields`,
  `category.media.translation.createdAt`,
  `category.media.translation.updatedAt`,
  `category.media.translation.mediaId`,
  `category.media.translation.languageId`,
  `category.translation.name`,
  COALESCE(
    `category.translation.name`, `category.translation.name`
  ) AS `category.name`,
  `category.translation.breadcrumb`,
  COALESCE(
    `category.translation.breadcrumb`,
    `category.translation.breadcrumb`
  ) AS `category.breadcrumb`,
  `category.translation.slotConfig`,
  COALESCE(
    `category.translation.slotConfig`,
    `category.translation.slotConfig`
  ) AS `category.slotConfig`,
  `category.translation.linkType`,
  COALESCE(
    `category.translation.linkType`,
    `category.translation.linkType`
  ) AS `category.linkType`,
  `category.translation.internalLink`,
  COALESCE(
    `category.translation.internalLink`,
    `category.translation.internalLink`
  ) AS `category.internalLink`,
  `category.translation.externalLink`,
  COALESCE(
    `category.translation.externalLink`,
    `category.translation.externalLink`
  ) AS `category.externalLink`,
  `category.translation.linkNewTab`,
  COALESCE(
    `category.translation.linkNewTab`,
    `category.translation.linkNewTab`
  ) AS `category.linkNewTab`,
  `category.translation.description`,
  COALESCE(
    `category.translation.description`,
    `category.translation.description`
  ) AS `category.description`,
  `category.translation.metaTitle`,
  COALESCE(
    `category.translation.metaTitle`,
    `category.translation.metaTitle`
  ) AS `category.metaTitle`,
  `category.translation.metaDescription`,
  COALESCE(
    `category.translation.metaDescription`,
    `category.translation.metaDescription`
  ) AS `category.metaDescription`,
  `category.translation.keywords`,
  COALESCE(
    `category.translation.keywords`,
    `category.translation.keywords`
  ) AS `category.keywords`,
  `category.translation.customFields`,
  COALESCE(
    `category.translation.customFields`,
    `category.translation.customFields`
  ) AS `category.customFields`,
  `category.translation.createdAt`,
  `category.translation.updatedAt`,
  `category.translation.categoryId`,
  `category.translation.languageId`,
  `category.translation.categoryVersionId`
FROM
  `category`
  LEFT JOIN (
    SELECT
      `category.translation`.category_id,
      `category.translation`.category_version_id,
      `category.translation`.name AS `category.translation.name`,
      `category.translation`.breadcrumb AS `category.translation.breadcrumb`,
      `category.translation`.slot_config AS `category.translation.slotConfig`,
      `category.translation`.link_type AS `category.translation.linkType`,
      `category.translation`.internal_link AS `category.translation.internalLink`,
      `category.translation`.external_link AS `category.translation.externalLink`,
      `category.translation`.link_new_tab AS `category.translation.linkNewTab`,
      `category.translation`.description AS `category.translation.description`,
      `category.translation`.meta_title AS `category.translation.metaTitle`,
      `category.translation`.meta_description AS `category.translation.metaDescription`,
      `category.translation`.keywords AS `category.translation.keywords`,
      `category.translation`.custom_fields AS `category.translation.customFields`,
      `category.translation`.created_at AS `category.translation.createdAt`,
      `category.translation`.updated_at AS `category.translation.updatedAt`,
      `category.translation`.category_id AS `category.translation.categoryId`,
      `category.translation`.language_id AS `category.translation.languageId`,
      `category.translation`.category_version_id AS `category.translation.categoryVersionId`
    FROM
      `category_translation` `category.translation`
    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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id`
  LEFT JOIN (
    SELECT
      `category.media.translation`.media_id,
      `category.media.translation`.title AS `category.media.translation.title`,
      `category.media.translation`.alt AS `category.media.translation.alt`,
      `category.media.translation`.custom_fields AS `category.media.translation.customFields`,
      `category.media.translation`.created_at AS `category.media.translation.createdAt`,
      `category.media.translation`.updated_at AS `category.media.translation.updatedAt`,
      `category.media.translation`.media_id AS `category.media.translation.mediaId`,
      `category.media.translation`.language_id AS `category.media.translation.languageId`
    FROM
      `media_translation` `category.media.translation`
    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`.`path` LIKE ?
      AND (
        `category`.`level` > ?
        AND `category`.`level` <= ?
      )
    )
  )

# header::navigation::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.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.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) AS `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) AS `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) AS `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name AS `category.translation.name`, `category.translation`.breadcrumb AS `category.translation.breadcrumb`, `category.translation`.slot_config AS `category.translation.slotConfig`, `category.translation`.link_type AS `category.translation.linkType`, `category.translation`.internal_link AS `category.translation.internalLink`, `category.translation`.external_link AS `category.translation.externalLink`, `category.translation`.link_new_tab AS `category.translation.linkNewTab`, `category.translation`.description AS `category.translation.description`, `category.translation`.meta_title AS `category.translation.metaTitle`, `category.translation`.meta_description AS `category.translation.metaDescription`, `category.translation`.keywords AS `category.translation.keywords`, `category.translation`.custom_fields AS `category.translation.customFields`, `category.translation`.created_at AS `category.translation.createdAt`, `category.translation`.updated_at AS `category.translation.updatedAt`, `category.translation`.category_id AS `category.translation.categoryId`, `category.translation`.language_id AS `category.translation.languageId`, `category.translation`.category_version_id AS `category.translation.categoryVersionId` FROM `category_translation` `category.translation` 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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title AS `category.media.translation.title`, `category.media.translation`.alt AS `category.media.translation.alt`, `category.media.translation`.custom_fields AS `category.media.translation.customFields`, `category.media.translation`.created_at AS `category.media.translation.createdAt`, `category.media.translation`.updated_at AS `category.media.translation.updatedAt`, `category.media.translation`.media_id AS `category.media.translation.mediaId`, `category.media.translation`.language_id AS `category.media.translation.languageId` FROM `media_translation` `category.media.translation` 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`.`path` LIKE '%|3a3e990c6a524fdd8eeb5b329270352e|%' AND (`category`.`level` > 1 AND `category`.`level` <= 4)));

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

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

SELECT
  `app`.`id` AS `app.id`,
  `app`.`name` AS `app.name`,
  `app`.`path` AS `app.path`,
  `app`.`author` AS `app.author`,
  `app`.`copyright` AS `app.copyright`,
  `app`.`license` AS `app.license`,
  `app`.`active` AS `app.active`,
  `app`.`configurable` AS `app.configurable`,
  `app`.`privacy` AS `app.privacy`,
  `app`.`version` AS `app.version`,
  `app`.`icon` AS `app.iconRaw`,
  `app`.`app_secret` AS `app.appSecret`,
  `app`.`modules` AS `app.modules`,
  `app`.`main_module` AS `app.mainModule`,
  `app`.`cookies` AS `app.cookies`,
  `app`.`allow_disable` AS `app.allowDisable`,
  `app`.`base_app_url` AS `app.baseAppUrl`,
  `app`.`allowed_hosts` AS `app.allowedHosts`,
  `app`.`template_load_priority` AS `app.templateLoadPriority`,
  `app`.`integration_id` AS `app.integrationId`,
  `app.integration`.`id` AS `app.integration.id`,
  `app.integration`.`label` AS `app.integration.label`,
  `app.integration`.`access_key` AS `app.integration.accessKey`,
  `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`,
  `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`,
  `app.integration`.`admin` AS `app.integration.admin`,
  `app.integration`.`custom_fields` AS `app.integration.customFields`,
  `app.integration`.`deleted_at` AS `app.integration.deletedAt`,
  `app.integration`.`created_at` AS `app.integration.createdAt`,
  `app.integration`.`updated_at` AS `app.integration.updatedAt`,
  `app`.`acl_role_id` AS `app.aclRoleId`,
  `app.aclRole`.`id` AS `app.aclRole.id`,
  `app.aclRole`.`name` AS `app.aclRole.name`,
  `app.aclRole`.`description` AS `app.aclRole.description`,
  `app.aclRole`.`privileges` AS `app.aclRole.privileges`,
  `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`,
  `app.aclRole`.`created_at` AS `app.aclRole.createdAt`,
  `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`,
  `app`.`created_at` AS `app.createdAt`,
  `app`.`updated_at` AS `app.updatedAt`,
  `app.translation.label`,
  COALESCE(
    `app.translation.label`, `app.translation.label`
  ) AS `app.label`,
  `app.translation.description`,
  COALESCE(
    `app.translation.description`, `app.translation.description`
  ) AS `app.description`,
  `app.translation.privacyPolicyExtensions`,
  COALESCE(
    `app.translation.privacyPolicyExtensions`,
    `app.translation.privacyPolicyExtensions`
  ) AS `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  COALESCE(
    `app.translation.customFields`,
    `app.translation.customFields`
  ) AS `app.customFields`,
  `app.translation.createdAt`,
  `app.translation.updatedAt`,
  `app.translation.appId`,
  `app.translation.languageId`
FROM
  `app`
  LEFT JOIN (
    SELECT
      `app.translation`.app_id,
      `app.translation`.label AS `app.translation.label`,
      `app.translation`.description AS `app.translation.description`,
      `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`,
      `app.translation`.custom_fields AS `app.translation.customFields`,
      `app.translation`.created_at AS `app.translation.createdAt`,
      `app.translation`.updated_at AS `app.translation.updatedAt`,
      `app.translation`.app_id AS `app.translation.appId`,
      `app.translation`.language_id AS `app.translation.languageId`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.language_id = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
  LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
  LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
  `app`.`id` IN (?)

SELECT `app`.`id` AS `app.id`, `app`.`name` AS `app.name`, `app`.`path` AS `app.path`, `app`.`author` AS `app.author`, `app`.`copyright` AS `app.copyright`, `app`.`license` AS `app.license`, `app`.`active` AS `app.active`, `app`.`configurable` AS `app.configurable`, `app`.`privacy` AS `app.privacy`, `app`.`version` AS `app.version`, `app`.`icon` AS `app.iconRaw`, `app`.`app_secret` AS `app.appSecret`, `app`.`modules` AS `app.modules`, `app`.`main_module` AS `app.mainModule`, `app`.`cookies` AS `app.cookies`, `app`.`allow_disable` AS `app.allowDisable`, `app`.`base_app_url` AS `app.baseAppUrl`, `app`.`allowed_hosts` AS `app.allowedHosts`, `app`.`template_load_priority` AS `app.templateLoadPriority`, `app`.`integration_id` AS `app.integrationId`, `app.integration`.`id` AS `app.integration.id`, `app.integration`.`label` AS `app.integration.label`, `app.integration`.`access_key` AS `app.integration.accessKey`, `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`, `app.integration`.`admin` AS `app.integration.admin`, `app.integration`.`custom_fields` AS `app.integration.customFields`, `app.integration`.`deleted_at` AS `app.integration.deletedAt`, `app.integration`.`created_at` AS `app.integration.createdAt`, `app.integration`.`updated_at` AS `app.integration.updatedAt`, `app`.`acl_role_id` AS `app.aclRoleId`, `app.aclRole`.`id` AS `app.aclRole.id`, `app.aclRole`.`name` AS `app.aclRole.name`, `app.aclRole`.`description` AS `app.aclRole.description`, `app.aclRole`.`privileges` AS `app.aclRole.privileges`, `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`, `app.aclRole`.`created_at` AS `app.aclRole.createdAt`, `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`, `app`.`created_at` AS `app.createdAt`, `app`.`updated_at` AS `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) AS `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) AS `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) AS `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) AS `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label AS `app.translation.label`, `app.translation`.description AS `app.translation.description`, `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields AS `app.translation.customFields`, `app.translation`.created_at AS `app.translation.createdAt`, `app.translation`.updated_at AS `app.translation.updatedAt`, `app.translation`.app_id AS `app.translation.appId`, `app.translation`.language_id AS `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE `app`.`id` IN (0x019054680F9073319F6E4D4F59612F86);

SELECT
  `media`.`id` AS `media.id`,
  `media`.`user_id` AS `media.userId`,
  `media`.`media_folder_id` AS `media.mediaFolderId`,
  `media`.`mime_type` AS `media.mimeType`,
  `media`.`file_extension` AS `media.fileExtension`,
  `media`.`uploaded_at` AS `media.uploadedAt`,
  `media`.`file_name` AS `media.fileName`,
  `media`.`file_size` AS `media.fileSize`,
  `media`.`media_type` AS `media.mediaTypeRaw`,
  `media`.`meta_data` AS `media.metaData`,
  `media`.`config` AS `media.config`,
  `media`.`path` AS `media.path`,
  `media`.`private` AS `media.private`,
  `media`.`thumbnails_ro` AS `media.thumbnailsRo`,
  `media`.`created_at` AS `media.createdAt`,
  `media`.`updated_at` AS `media.updatedAt`,
  `media.translation.title`,
  COALESCE(
    `media.translation.title`, `media.translation.title`
  ) AS `media.title`,
  `media.translation.alt`,
  COALESCE(
    `media.translation.alt`, `media.translation.alt`
  ) AS `media.alt`,
  `media.translation.customFields`,
  COALESCE(
    `media.translation.customFields`,
    `media.translation.customFields`
  ) AS `media.customFields`,
  `media.translation.createdAt`,
  `media.translation.updatedAt`,
  `media.translation.mediaId`,
  `media.translation.languageId`
FROM
  `media`
  LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id`
  LEFT JOIN (
    SELECT
      `media.translation`.media_id,
      `media.translation`.title AS `media.translation.title`,
      `media.translation`.alt AS `media.translation.alt`,
      `media.translation`.custom_fields AS `media.translation.customFields`,
      `media.translation`.created_at AS `media.translation.createdAt`,
      `media.translation`.updated_at AS `media.translation.updatedAt`,
      `media.translation`.media_id AS `media.translation.mediaId`,
      `media.translation`.language_id AS `media.translation.languageId`
    FROM
      `media_translation` `media.translation`
    WHERE
      `media.translation`.language_id = ?
  ) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id`
  LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id`
WHERE
  (
    (
      (
        `media`.`private` = ?
        OR (
          `media`.`private` = ?
          AND `media.mediaFolder.defaultFolder`.`entity` = ?
        )
      )
    )
  )
  AND (
    `media`.`id` IN (?)
  )

SELECT `media`.`id` AS `media.id`, `media`.`user_id` AS `media.userId`, `media`.`media_folder_id` AS `media.mediaFolderId`, `media`.`mime_type` AS `media.mimeType`, `media`.`file_extension` AS `media.fileExtension`, `media`.`uploaded_at` AS `media.uploadedAt`, `media`.`file_name` AS `media.fileName`, `media`.`file_size` AS `media.fileSize`, `media`.`media_type` AS `media.mediaTypeRaw`, `media`.`meta_data` AS `media.metaData`, `media`.`config` AS `media.config`, `media`.`path` AS `media.path`, `media`.`private` AS `media.private`, `media`.`thumbnails_ro` AS `media.thumbnailsRo`, `media`.`created_at` AS `media.createdAt`, `media`.`updated_at` AS `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) AS `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) AS `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) AS `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title AS `media.translation.title`, `media.translation`.alt AS `media.translation.alt`, `media.translation`.custom_fields AS `media.translation.customFields`, `media.translation`.created_at AS `media.translation.createdAt`, `media.translation`.updated_at AS `media.translation.updatedAt`, `media.translation`.media_id AS `media.translation.mediaId`, `media.translation`.language_id AS `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = 0 OR (`media`.`private` = 1 AND `media.mediaFolder.defaultFolder`.`entity` = 'product_download')))) AND (`media`.`id` IN (0xD4E632B7C406460992D957F68E6752B6));