Symfony Profiler

SELECT
  `moorl_fb_form`.`id` AS `moorl_fb_form.id`,
  `moorl_fb_form`.`tax_id` AS `moorl_fb_form.taxId`,
  `moorl_fb_form`.`user_id` AS `moorl_fb_form.userId`,
  `moorl_fb_form`.`media_id` AS `moorl_fb_form.mediaId`,
  `moorl_fb_form`.`sales_channel_id` AS `moorl_fb_form.salesChannelId`,
  `moorl_fb_form`.`product_stream_id` AS `moorl_fb_form.productStreamId`,
  `moorl_fb_form`.`customer_group_id` AS `moorl_fb_form.customerGroupId`,
  `moorl_fb_form`.`shipping_method_id` AS `moorl_fb_form.shippingMethodId`,
  `moorl_fb_form`.`payment_method_id` AS `moorl_fb_form.paymentMethodId`,
  `moorl_fb_form`.`country_id` AS `moorl_fb_form.countryId`,
  `moorl_fb_form`.`language_id` AS `moorl_fb_form.languageId`,
  `moorl_fb_form`.`show_from` AS `moorl_fb_form.showFrom`,
  `moorl_fb_form`.`show_until` AS `moorl_fb_form.showUntil`,
  `moorl_fb_form`.`media_folder_id` AS `moorl_fb_form.mediaFolderId`,
  `moorl_fb_form`.`type` AS `moorl_fb_form.type`,
  `moorl_fb_form`.`active` AS `moorl_fb_form.active`,
  `moorl_fb_form`.`use_captcha` AS `moorl_fb_form.useCaptcha`,
  `moorl_fb_form`.`send_mail` AS `moorl_fb_form.sendMail`,
  `moorl_fb_form`.`insert_database` AS `moorl_fb_form.insertDatabase`,
  `moorl_fb_form`.`locked` AS `moorl_fb_form.locked`,
  `moorl_fb_form`.`technical_name` AS `moorl_fb_form.technicalName`,
  `moorl_fb_form`.`redirect_to` AS `moorl_fb_form.redirectTo`,
  `moorl_fb_form`.`related_entity` AS `moorl_fb_form.relatedEntity`,
  `moorl_fb_form`.`send_copy_type` AS `moorl_fb_form.sendCopyType`,
  `moorl_fb_form`.`config` AS `moorl_fb_form.config`,
  `moorl_fb_form`.`actions` AS `moorl_fb_form.actions`,
  `moorl_fb_form`.`custom_fields` AS `moorl_fb_form.customFields`,
  `moorl_fb_form.tax`.`id` AS `moorl_fb_form.tax.id`,
  `moorl_fb_form.tax`.`tax_rate` AS `moorl_fb_form.tax.taxRate`,
  `moorl_fb_form.tax`.`name` AS `moorl_fb_form.tax.name`,
  `moorl_fb_form.tax`.`position` AS `moorl_fb_form.tax.position`,
  `moorl_fb_form.tax`.`custom_fields` AS `moorl_fb_form.tax.customFields`,
  `moorl_fb_form.tax`.`created_at` AS `moorl_fb_form.tax.createdAt`,
  `moorl_fb_form.tax`.`updated_at` AS `moorl_fb_form.tax.updatedAt`,
  `moorl_fb_form.media`.`id` AS `moorl_fb_form.media.id`,
  `moorl_fb_form.media`.`user_id` AS `moorl_fb_form.media.userId`,
  `moorl_fb_form.media`.`media_folder_id` AS `moorl_fb_form.media.mediaFolderId`,
  `moorl_fb_form.media`.`mime_type` AS `moorl_fb_form.media.mimeType`,
  `moorl_fb_form.media`.`file_extension` AS `moorl_fb_form.media.fileExtension`,
  `moorl_fb_form.media`.`uploaded_at` AS `moorl_fb_form.media.uploadedAt`,
  `moorl_fb_form.media`.`file_name` AS `moorl_fb_form.media.fileName`,
  `moorl_fb_form.media`.`file_size` AS `moorl_fb_form.media.fileSize`,
  `moorl_fb_form.media`.`media_type` AS `moorl_fb_form.media.mediaTypeRaw`,
  `moorl_fb_form.media`.`meta_data` AS `moorl_fb_form.media.metaData`,
  `moorl_fb_form.media`.`config` AS `moorl_fb_form.media.config`,
  `moorl_fb_form.media`.`path` AS `moorl_fb_form.media.path`,
  `moorl_fb_form.media`.`private` AS `moorl_fb_form.media.private`,
  `moorl_fb_form.media`.`thumbnails_ro` AS `moorl_fb_form.media.thumbnailsRo`,
  `moorl_fb_form.media`.`created_at` AS `moorl_fb_form.media.createdAt`,
  `moorl_fb_form.media`.`updated_at` AS `moorl_fb_form.media.updatedAt`,
  `moorl_fb_form.media.translation.title`,
  COALESCE(
    `moorl_fb_form.media.translation.title`,
    `moorl_fb_form.media.translation.title`
  ) AS `moorl_fb_form.media.title`,
  `moorl_fb_form.media.translation.alt`,
  COALESCE(
    `moorl_fb_form.media.translation.alt`,
    `moorl_fb_form.media.translation.alt`
  ) AS `moorl_fb_form.media.alt`,
  `moorl_fb_form.media.translation.customFields`,
  COALESCE(
    `moorl_fb_form.media.translation.customFields`,
    `moorl_fb_form.media.translation.customFields`
  ) AS `moorl_fb_form.media.customFields`,
  `moorl_fb_form.media.translation.createdAt`,
  `moorl_fb_form.media.translation.updatedAt`,
  `moorl_fb_form.media.translation.mediaId`,
  `moorl_fb_form.media.translation.languageId`,
  `moorl_fb_form`.`created_at` AS `moorl_fb_form.createdAt`,
  `moorl_fb_form`.`updated_at` AS `moorl_fb_form.updatedAt`,
  `moorl_fb_form.translation.name`,
  COALESCE(
    `moorl_fb_form.translation.name`,
    `moorl_fb_form.translation.name`
  ) AS `moorl_fb_form.name`,
  `moorl_fb_form.translation.successMessage`,
  COALESCE(
    `moorl_fb_form.translation.successMessage`,
    `moorl_fb_form.translation.successMessage`
  ) AS `moorl_fb_form.successMessage`,
  `moorl_fb_form.translation.errorMessage`,
  COALESCE(
    `moorl_fb_form.translation.errorMessage`,
    `moorl_fb_form.translation.errorMessage`
  ) AS `moorl_fb_form.errorMessage`,
  `moorl_fb_form.translation.custom1`,
  COALESCE(
    `moorl_fb_form.translation.custom1`,
    `moorl_fb_form.translation.custom1`
  ) AS `moorl_fb_form.custom1`,
  `moorl_fb_form.translation.custom2`,
  COALESCE(
    `moorl_fb_form.translation.custom2`,
    `moorl_fb_form.translation.custom2`
  ) AS `moorl_fb_form.custom2`,
  `moorl_fb_form.translation.mailReceiver`,
  COALESCE(
    `moorl_fb_form.translation.mailReceiver`,
    `moorl_fb_form.translation.mailReceiver`
  ) AS `moorl_fb_form.mailReceiver`,
  `moorl_fb_form.translation.storefrontTemplate`,
  COALESCE(
    `moorl_fb_form.translation.storefrontTemplate`,
    `moorl_fb_form.translation.storefrontTemplate`
  ) AS `moorl_fb_form.storefrontTemplate`,
  `moorl_fb_form.translation.createdAt`,
  `moorl_fb_form.translation.updatedAt`,
  `moorl_fb_form.translation.moorlFbFormId`,
  `moorl_fb_form.translation.languageId`
FROM
  `moorl_fb_form`
  LEFT JOIN (
    SELECT
      `moorl_fb_form.translation`.moorl_fb_form_id,
      `moorl_fb_form.translation`.name AS `moorl_fb_form.translation.name`,
      `moorl_fb_form.translation`.success_message AS `moorl_fb_form.translation.successMessage`,
      `moorl_fb_form.translation`.error_message AS `moorl_fb_form.translation.errorMessage`,
      `moorl_fb_form.translation`.custom1 AS `moorl_fb_form.translation.custom1`,
      `moorl_fb_form.translation`.custom2 AS `moorl_fb_form.translation.custom2`,
      `moorl_fb_form.translation`.mail_receiver AS `moorl_fb_form.translation.mailReceiver`,
      `moorl_fb_form.translation`.storefront_template AS `moorl_fb_form.translation.storefrontTemplate`,
      `moorl_fb_form.translation`.created_at AS `moorl_fb_form.translation.createdAt`,
      `moorl_fb_form.translation`.updated_at AS `moorl_fb_form.translation.updatedAt`,
      `moorl_fb_form.translation`.moorl_fb_form_id AS `moorl_fb_form.translation.moorlFbFormId`,
      `moorl_fb_form.translation`.language_id AS `moorl_fb_form.translation.languageId`
    FROM
      `moorl_fb_form_translation` `moorl_fb_form.translation`
    WHERE
      `moorl_fb_form.translation`.language_id = ?
  ) `moorl_fb_form.moorl_fb_form_translation` ON `moorl_fb_form.moorl_fb_form_translation`.`moorl_fb_form_id` = `moorl_fb_form`.`id`
  LEFT JOIN `tax` `moorl_fb_form.tax` ON `moorl_fb_form`.`tax_id` = `moorl_fb_form.tax`.`id`
  LEFT JOIN `media` `moorl_fb_form.media` ON `moorl_fb_form`.`media_id` = `moorl_fb_form.media`.`id`
  LEFT JOIN (
    SELECT
      `moorl_fb_form.media.translation`.media_id,
      `moorl_fb_form.media.translation`.title AS `moorl_fb_form.media.translation.title`,
      `moorl_fb_form.media.translation`.alt AS `moorl_fb_form.media.translation.alt`,
      `moorl_fb_form.media.translation`.custom_fields AS `moorl_fb_form.media.translation.customFields`,
      `moorl_fb_form.media.translation`.created_at AS `moorl_fb_form.media.translation.createdAt`,
      `moorl_fb_form.media.translation`.updated_at AS `moorl_fb_form.media.translation.updatedAt`,
      `moorl_fb_form.media.translation`.media_id AS `moorl_fb_form.media.translation.mediaId`,
      `moorl_fb_form.media.translation`.language_id AS `moorl_fb_form.media.translation.languageId`
    FROM
      `media_translation` `moorl_fb_form.media.translation`
    WHERE
      `moorl_fb_form.media.translation`.language_id = ?
  ) `moorl_fb_form.media.media_translation` ON `moorl_fb_form.media.media_translation`.`media_id` = `moorl_fb_form.media`.`id`
WHERE
  `moorl_fb_form`.`id` IN (?)

SELECT `moorl_fb_form`.`id` AS `moorl_fb_form.id`, `moorl_fb_form`.`tax_id` AS `moorl_fb_form.taxId`, `moorl_fb_form`.`user_id` AS `moorl_fb_form.userId`, `moorl_fb_form`.`media_id` AS `moorl_fb_form.mediaId`, `moorl_fb_form`.`sales_channel_id` AS `moorl_fb_form.salesChannelId`, `moorl_fb_form`.`product_stream_id` AS `moorl_fb_form.productStreamId`, `moorl_fb_form`.`customer_group_id` AS `moorl_fb_form.customerGroupId`, `moorl_fb_form`.`shipping_method_id` AS `moorl_fb_form.shippingMethodId`, `moorl_fb_form`.`payment_method_id` AS `moorl_fb_form.paymentMethodId`, `moorl_fb_form`.`country_id` AS `moorl_fb_form.countryId`, `moorl_fb_form`.`language_id` AS `moorl_fb_form.languageId`, `moorl_fb_form`.`show_from` AS `moorl_fb_form.showFrom`, `moorl_fb_form`.`show_until` AS `moorl_fb_form.showUntil`, `moorl_fb_form`.`media_folder_id` AS `moorl_fb_form.mediaFolderId`, `moorl_fb_form`.`type` AS `moorl_fb_form.type`, `moorl_fb_form`.`active` AS `moorl_fb_form.active`, `moorl_fb_form`.`use_captcha` AS `moorl_fb_form.useCaptcha`, `moorl_fb_form`.`send_mail` AS `moorl_fb_form.sendMail`, `moorl_fb_form`.`insert_database` AS `moorl_fb_form.insertDatabase`, `moorl_fb_form`.`locked` AS `moorl_fb_form.locked`, `moorl_fb_form`.`technical_name` AS `moorl_fb_form.technicalName`, `moorl_fb_form`.`redirect_to` AS `moorl_fb_form.redirectTo`, `moorl_fb_form`.`related_entity` AS `moorl_fb_form.relatedEntity`, `moorl_fb_form`.`send_copy_type` AS `moorl_fb_form.sendCopyType`, `moorl_fb_form`.`config` AS `moorl_fb_form.config`, `moorl_fb_form`.`actions` AS `moorl_fb_form.actions`, `moorl_fb_form`.`custom_fields` AS `moorl_fb_form.customFields`, `moorl_fb_form.tax`.`id` AS `moorl_fb_form.tax.id`, `moorl_fb_form.tax`.`tax_rate` AS `moorl_fb_form.tax.taxRate`, `moorl_fb_form.tax`.`name` AS `moorl_fb_form.tax.name`, `moorl_fb_form.tax`.`position` AS `moorl_fb_form.tax.position`, `moorl_fb_form.tax`.`custom_fields` AS `moorl_fb_form.tax.customFields`, `moorl_fb_form.tax`.`created_at` AS `moorl_fb_form.tax.createdAt`, `moorl_fb_form.tax`.`updated_at` AS `moorl_fb_form.tax.updatedAt`, `moorl_fb_form.media`.`id` AS `moorl_fb_form.media.id`, `moorl_fb_form.media`.`user_id` AS `moorl_fb_form.media.userId`, `moorl_fb_form.media`.`media_folder_id` AS `moorl_fb_form.media.mediaFolderId`, `moorl_fb_form.media`.`mime_type` AS `moorl_fb_form.media.mimeType`, `moorl_fb_form.media`.`file_extension` AS `moorl_fb_form.media.fileExtension`, `moorl_fb_form.media`.`uploaded_at` AS `moorl_fb_form.media.uploadedAt`, `moorl_fb_form.media`.`file_name` AS `moorl_fb_form.media.fileName`, `moorl_fb_form.media`.`file_size` AS `moorl_fb_form.media.fileSize`, `moorl_fb_form.media`.`media_type` AS `moorl_fb_form.media.mediaTypeRaw`, `moorl_fb_form.media`.`meta_data` AS `moorl_fb_form.media.metaData`, `moorl_fb_form.media`.`config` AS `moorl_fb_form.media.config`, `moorl_fb_form.media`.`path` AS `moorl_fb_form.media.path`, `moorl_fb_form.media`.`private` AS `moorl_fb_form.media.private`, `moorl_fb_form.media`.`thumbnails_ro` AS `moorl_fb_form.media.thumbnailsRo`, `moorl_fb_form.media`.`created_at` AS `moorl_fb_form.media.createdAt`, `moorl_fb_form.media`.`updated_at` AS `moorl_fb_form.media.updatedAt`, `moorl_fb_form.media.translation.title`, COALESCE(`moorl_fb_form.media.translation.title`,`moorl_fb_form.media.translation.title`) AS `moorl_fb_form.media.title`, `moorl_fb_form.media.translation.alt`, COALESCE(`moorl_fb_form.media.translation.alt`,`moorl_fb_form.media.translation.alt`) AS `moorl_fb_form.media.alt`, `moorl_fb_form.media.translation.customFields`, COALESCE(`moorl_fb_form.media.translation.customFields`,`moorl_fb_form.media.translation.customFields`) AS `moorl_fb_form.media.customFields`, `moorl_fb_form.media.translation.createdAt`, `moorl_fb_form.media.translation.updatedAt`, `moorl_fb_form.media.translation.mediaId`, `moorl_fb_form.media.translation.languageId`, `moorl_fb_form`.`created_at` AS `moorl_fb_form.createdAt`, `moorl_fb_form`.`updated_at` AS `moorl_fb_form.updatedAt`, `moorl_fb_form.translation.name`, COALESCE(`moorl_fb_form.translation.name`,`moorl_fb_form.translation.name`) AS `moorl_fb_form.name`, `moorl_fb_form.translation.successMessage`, COALESCE(`moorl_fb_form.translation.successMessage`,`moorl_fb_form.translation.successMessage`) AS `moorl_fb_form.successMessage`, `moorl_fb_form.translation.errorMessage`, COALESCE(`moorl_fb_form.translation.errorMessage`,`moorl_fb_form.translation.errorMessage`) AS `moorl_fb_form.errorMessage`, `moorl_fb_form.translation.custom1`, COALESCE(`moorl_fb_form.translation.custom1`,`moorl_fb_form.translation.custom1`) AS `moorl_fb_form.custom1`, `moorl_fb_form.translation.custom2`, COALESCE(`moorl_fb_form.translation.custom2`,`moorl_fb_form.translation.custom2`) AS `moorl_fb_form.custom2`, `moorl_fb_form.translation.mailReceiver`, COALESCE(`moorl_fb_form.translation.mailReceiver`,`moorl_fb_form.translation.mailReceiver`) AS `moorl_fb_form.mailReceiver`, `moorl_fb_form.translation.storefrontTemplate`, COALESCE(`moorl_fb_form.translation.storefrontTemplate`,`moorl_fb_form.translation.storefrontTemplate`) AS `moorl_fb_form.storefrontTemplate`, `moorl_fb_form.translation.createdAt`, `moorl_fb_form.translation.updatedAt`, `moorl_fb_form.translation.moorlFbFormId`, `moorl_fb_form.translation.languageId` FROM `moorl_fb_form` LEFT JOIN (SELECT `moorl_fb_form.translation`.moorl_fb_form_id, `moorl_fb_form.translation`.name AS `moorl_fb_form.translation.name`, `moorl_fb_form.translation`.success_message AS `moorl_fb_form.translation.successMessage`, `moorl_fb_form.translation`.error_message AS `moorl_fb_form.translation.errorMessage`, `moorl_fb_form.translation`.custom1 AS `moorl_fb_form.translation.custom1`, `moorl_fb_form.translation`.custom2 AS `moorl_fb_form.translation.custom2`, `moorl_fb_form.translation`.mail_receiver AS `moorl_fb_form.translation.mailReceiver`, `moorl_fb_form.translation`.storefront_template AS `moorl_fb_form.translation.storefrontTemplate`, `moorl_fb_form.translation`.created_at AS `moorl_fb_form.translation.createdAt`, `moorl_fb_form.translation`.updated_at AS `moorl_fb_form.translation.updatedAt`, `moorl_fb_form.translation`.moorl_fb_form_id AS `moorl_fb_form.translation.moorlFbFormId`, `moorl_fb_form.translation`.language_id AS `moorl_fb_form.translation.languageId` FROM `moorl_fb_form_translation` `moorl_fb_form.translation` WHERE `moorl_fb_form.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `moorl_fb_form.moorl_fb_form_translation` ON `moorl_fb_form.moorl_fb_form_translation`.`moorl_fb_form_id` = `moorl_fb_form`.`id` LEFT JOIN `tax` `moorl_fb_form.tax` ON `moorl_fb_form`.`tax_id` = `moorl_fb_form.tax`.`id` LEFT JOIN `media` `moorl_fb_form.media` ON `moorl_fb_form`.`media_id` = `moorl_fb_form.media`.`id` LEFT JOIN (SELECT `moorl_fb_form.media.translation`.media_id, `moorl_fb_form.media.translation`.title AS `moorl_fb_form.media.translation.title`, `moorl_fb_form.media.translation`.alt AS `moorl_fb_form.media.translation.alt`, `moorl_fb_form.media.translation`.custom_fields AS `moorl_fb_form.media.translation.customFields`, `moorl_fb_form.media.translation`.created_at AS `moorl_fb_form.media.translation.createdAt`, `moorl_fb_form.media.translation`.updated_at AS `moorl_fb_form.media.translation.updatedAt`, `moorl_fb_form.media.translation`.media_id AS `moorl_fb_form.media.translation.mediaId`, `moorl_fb_form.media.translation`.language_id AS `moorl_fb_form.media.translation.languageId` FROM `media_translation` `moorl_fb_form.media.translation` WHERE `moorl_fb_form.media.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `moorl_fb_form.media.media_translation` ON `moorl_fb_form.media.media_translation`.`media_id` = `moorl_fb_form.media`.`id` WHERE `moorl_fb_form`.`id` IN (0xFE5790D6B16C426183BCE7FADD8FB560);

# 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
  `country`.`id`
FROM
  `country`
  LEFT JOIN (
    SELECT
      `country.translation`.country_id,
      `country.translation`.name AS `country.translation.name`,
      `country.translation`.address_format AS `country.translation.addressFormat`,
      `country.translation`.custom_fields AS `country.translation.customFields`,
      `country.translation`.created_at AS `country.translation.createdAt`,
      `country.translation`.updated_at AS `country.translation.updatedAt`,
      `country.translation`.country_id AS `country.translation.countryId`,
      `country.translation`.language_id AS `country.translation.languageId`
    FROM
      `country_translation` `country.translation`
    WHERE
      `country.translation`.language_id = ?
  ) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id`
ORDER BY
  `country`.`position` ASC,
  COALESCE(`country.translation.name`) ASC

SELECT `country`.`id` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name AS `country.translation.name`, `country.translation`.address_format AS `country.translation.addressFormat`, `country.translation`.custom_fields AS `country.translation.customFields`, `country.translation`.created_at AS `country.translation.createdAt`, `country.translation`.updated_at AS `country.translation.updatedAt`, `country.translation`.country_id AS `country.translation.countryId`, `country.translation`.language_id AS `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` ORDER BY `country`.`position` ASC, COALESCE(`country.translation.name`) ASC;

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 (0x668BE72361EA41249F975168E3710F80));

SELECT
  LOWER(
    HEX(`script`.`app_id`)
  ) AS `app_id`,
  `script`.`name` AS scriptName,
  `script`.`script` AS script,
  `script`.`hook` AS hook,
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified,
  `app`.`name` AS appName,
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId,
  `app`.`version` AS appVersion,
  `script`.`active` AS active
FROM
  `script`
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE
  `script`.`hook` != 'include'
ORDER BY
  `app`.`created_at`,
  `app`.`id`,
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) AS `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;

SELECT
  LOWER(
    HEX(`category`.`parent_id`)
  ) AS `category-ids.key`,
  COUNT(`category`.`id`) AS `category-ids.count`,
  COUNT(DISTINCT `category`.`id`) AS `visible-children-count`
FROM
  `category`
WHERE
  (`category`.`version_id` = ?)
  AND (
    (
      `category`.`path` LIKE ?
      AND `category`.`level` = ?
      AND `category`.`active` = ?
      AND `category`.`visible` = ?
    )
  )
GROUP BY
  `category`.`parent_id`

SELECT LOWER(HEX(`category`.`parent_id`)) AS `category-ids.key`, COUNT(`category`.`id`) AS `category-ids.count`, COUNT(DISTINCT `category`.`id`) AS `visible-children-count` FROM `category` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category`.`path` LIKE '%|3a3e990c6a524fdd8eeb5b329270352e|%' AND `category`.`level` = 4 AND `category`.`active` = 1 AND `category`.`visible` = 1)) GROUP BY `category`.`parent_id`;

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 (?)