Symfony Profiler

SELECT
  `key`,
  `value`
FROM
  `app_config`

SELECT `key`, `value` FROM `app_config`;

SET
  @@group_concat_max_len = CAST(
    IF(
      @@group_concat_max_len > 320000, @@group_concat_max_len,
      320000
    ) AS UNSIGNED
  );

SET
  sql_mode =(
    SELECT
      REPLACE(
        @@sql_mode, 'ONLY_FULL_GROUP_BY',
        ''
      )
  )

SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

SELECT
  `key`,
  `value`
FROM
  `app_config`

SELECT `key`, `value` FROM `app_config`;

SELECT
  custom_entity.name,
  custom_entity.fields,
  custom_entity.flags
FROM
  custom_entity
  LEFT JOIN app ON app.id = custom_entity.app_id
WHERE
  (
    custom_entity.app_id IS NULL
    OR app.active = 1
  )
  AND custom_entity.deleted_at IS NULL;

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
            ;

# seo-url::resolve
SELECT
  id,
  path_info pathInfo,
  is_canonical isCanonical,
  sales_channel_id salesChannelId
FROM
  seo_url
WHERE
  (language_id = ?)
  AND (
    (
      sales_channel_id = ?
      OR sales_channel_id IS NULL
    )
  )
  AND (
    (
      seo_path_info = ?
      OR seo_path_info = ?
    )
  )

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x8E059FD029F94868BCB5B3BC85EC4F38) AND ((sales_channel_id = 0xF5BD69415F6D4DC792187D326D7D944D OR sales_channel_id IS NULL)) AND ((seo_path_info = 'produits/occasions/scene-rigging' OR seo_path_info = 'produits/occasions/scene-rigging/'));

SELECT
  `name`,
  `path`,
  `author`,
  `self_managed`
FROM
  `app`
WHERE
  `active` = 1

SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
            ;

SELECT
  *
FROM
  sales_channel_api_context
WHERE
  (sales_channel_id = ?)
  AND (token = ?)
LIMIT
  1

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0xF5BD69415F6D4DC792187D326D7D944D) AND (token = 'X0UDUAI2eR1W1AjrFUa9WfIIQsMD6KoG') LIMIT 1;

#cart-persister::load
SELECT
  `cart`.`payload`,
  `cart`.`rule_ids`,
  `cart`.`compressed`
FROM
  cart
WHERE
  `token` = ?

#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = 'X0UDUAI2eR1W1AjrFUa9WfIIQsMD6KoG';

SELECT
  `sales_channel_country`.`sales_channel_id`,
  `sales_channel_country`.`country_id`
FROM
  `sales_channel_country`
WHERE
  (
    `sales_channel_country`.`sales_channel_id` = ?
    AND `sales_channel_country`.`country_id` = ?
  )

SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = 0xF5BD69415F6D4DC792187D326D7D944D AND `sales_channel_country`.`country_id` = 0x71019CBEA00748C88739045B058BA701);

# sales-channel::load-analytics::read
SELECT
  `sales_channel_analytics`.`id` as `sales_channel_analytics.id`,
  `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`,
  `sales_channel_analytics`.`active` as `sales_channel_analytics.active`,
  `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`,
  `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`,
  `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`,
  `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt`
FROM
  `sales_channel_analytics`
WHERE
  `sales_channel_analytics`.`id` IN (?)

# sales-channel::load-analytics::read
SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (0x0191D76A6B117A12BD80E01E1E651825);

SELECT
  `domain`.`language_id` AS languageId,
  `domain`.`id` AS id,
  `domain`.`url` AS url,
  `domain`.`hreflang_use_only_locale` AS onlyLocale,
  `locale`.`code` AS locale
FROM
  `sales_channel_domain` AS `domain`
  INNER JOIN `language` ON `language`.`id` = `domain`.`language_id`
  INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id`
WHERE
  `domain`.`sales_channel_id` = ?

SELECT `domain`.`language_id` AS languageId,
                          `domain`.`id` AS id,
                          `domain`.`url` AS url,
                          `domain`.`hreflang_use_only_locale` AS onlyLocale,
                          `locale`.`code` AS locale
            FROM `sales_channel_domain` AS `domain`
            INNER JOIN `language` ON `language`.`id` = `domain`.`language_id`
            INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id`
            WHERE `domain`.`sales_channel_id` = 0xF5BD69415F6D4DC792187D326D7D944D;

SELECT
  `seo_path_info` AS seoPathInfo,
  `language_id` AS languageId
FROM
  `seo_url`
WHERE
  `path_info` = ?
  AND `is_canonical` = 1
  AND `sales_channel_id` = ?
  AND `language_id` IN (?, ?)

SELECT `seo_path_info` AS seoPathInfo, `language_id` AS languageId
            FROM `seo_url`
            WHERE `path_info` = '/navigation/019151070d8a74b09fe6479b1f54a5a3' AND `is_canonical` = 1 AND
                  `sales_channel_id` = 0xF5BD69415F6D4DC792187D326D7D944D AND `language_id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B, 0x8E059FD029F94868BCB5B3BC85EC4F38);

SELECT
  active
FROM
  `app`
WHERE
  name = ?

SELECT active FROM `app` WHERE name = 'ReqserApp';

SELECT
  `app`.`name`,
  `app`.`version`,
  `app`.`template_load_priority`
FROM
  `app`
  INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
WHERE
  `app`.`active` = 1
  AND `app_template`.`active` = 1

SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1;

SELECT
  path
FROM
  category
WHERE
  id = ?

SELECT path FROM category WHERE id = 0x019151070D8A74B09FE6479B1F54A5A3;

SELECT
  min_search_length
FROM
  product_search_config
WHERE
  language_id = ?

SELECT min_search_length FROM product_search_config WHERE language_id = 0x8E059FD029F94868BCB5B3BC85EC4F38;

SELECT
  LOWER(
    HEX(id)
  )
FROM
  snippet_set
WHERE
  iso = ?

SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = 'fr-FR';

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.translation.override_1.name`,
  `category.translation.name`,
  COALESCE(
    `category.translation.override_1.name`,
    `category.translation.name`
  ) as `category.name`,
  `category.translation.override_1.breadcrumb`,
  `category.translation.breadcrumb`,
  COALESCE(
    `category.translation.override_1.breadcrumb`,
    `category.translation.breadcrumb`
  ) as `category.breadcrumb`,
  `category.translation.override_1.slotConfig`,
  `category.translation.slotConfig`,
  COALESCE(
    `category.translation.override_1.slotConfig`,
    `category.translation.slotConfig`
  ) as `category.slotConfig`,
  `category.translation.override_1.linkType`,
  `category.translation.linkType`,
  COALESCE(
    `category.translation.override_1.linkType`,
    `category.translation.linkType`
  ) as `category.linkType`,
  `category.translation.override_1.internalLink`,
  `category.translation.internalLink`,
  COALESCE(
    `category.translation.override_1.internalLink`,
    `category.translation.internalLink`
  ) as `category.internalLink`,
  `category.translation.override_1.externalLink`,
  `category.translation.externalLink`,
  COALESCE(
    `category.translation.override_1.externalLink`,
    `category.translation.externalLink`
  ) as `category.externalLink`,
  `category.translation.override_1.linkNewTab`,
  `category.translation.linkNewTab`,
  COALESCE(
    `category.translation.override_1.linkNewTab`,
    `category.translation.linkNewTab`
  ) as `category.linkNewTab`,
  `category.translation.override_1.description`,
  `category.translation.description`,
  COALESCE(
    `category.translation.override_1.description`,
    `category.translation.description`
  ) as `category.description`,
  `category.translation.override_1.metaTitle`,
  `category.translation.metaTitle`,
  COALESCE(
    `category.translation.override_1.metaTitle`,
    `category.translation.metaTitle`
  ) as `category.metaTitle`,
  `category.translation.override_1.metaDescription`,
  `category.translation.metaDescription`,
  COALESCE(
    `category.translation.override_1.metaDescription`,
    `category.translation.metaDescription`
  ) as `category.metaDescription`,
  `category.translation.override_1.keywords`,
  `category.translation.keywords`,
  COALESCE(
    `category.translation.override_1.keywords`,
    `category.translation.keywords`
  ) as `category.keywords`,
  `category.translation.override_1.customFields`,
  `category.translation.customFields`,
  COALESCE(
    `category.translation.override_1.customFields`,
    `category.translation.customFields`
  ) as `category.customFields`
FROM
  `category`
  LEFT JOIN (
    SELECT
      `category.translation`.`category_id`,
      `category.translation`.`category_version_id`,
      `category.translation`.`breadcrumb` as `category.translation.breadcrumb`,
      `category.translation.override_1`.`breadcrumb` as `category.translation.override_1.breadcrumb`,
      `category.translation`.`name` as `category.translation.name`,
      `category.translation.override_1`.`name` as `category.translation.override_1.name`,
      `category.translation`.`custom_fields` as `category.translation.customFields`,
      `category.translation.override_1`.`custom_fields` as `category.translation.override_1.customFields`,
      `category.translation`.`slot_config` as `category.translation.slotConfig`,
      `category.translation.override_1`.`slot_config` as `category.translation.override_1.slotConfig`,
      `category.translation`.`link_type` as `category.translation.linkType`,
      `category.translation.override_1`.`link_type` as `category.translation.override_1.linkType`,
      `category.translation`.`internal_link` as `category.translation.internalLink`,
      `category.translation.override_1`.`internal_link` as `category.translation.override_1.internalLink`,
      `category.translation`.`external_link` as `category.translation.externalLink`,
      `category.translation.override_1`.`external_link` as `category.translation.override_1.externalLink`,
      `category.translation`.`link_new_tab` as `category.translation.linkNewTab`,
      `category.translation.override_1`.`link_new_tab` as `category.translation.override_1.linkNewTab`,
      `category.translation`.`description` as `category.translation.description`,
      `category.translation.override_1`.`description` as `category.translation.override_1.description`,
      `category.translation`.`meta_title` as `category.translation.metaTitle`,
      `category.translation.override_1`.`meta_title` as `category.translation.override_1.metaTitle`,
      `category.translation`.`meta_description` as `category.translation.metaDescription`,
      `category.translation.override_1`.`meta_description` as `category.translation.override_1.metaDescription`,
      `category.translation`.`keywords` as `category.translation.keywords`,
      `category.translation.override_1`.`keywords` as `category.translation.override_1.keywords`
    FROM
      `category_translation` `category.translation`
      LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation`.`category_id` = `category.translation.override_1`.`category_id`
      AND `category.translation.override_1`.`language_id` = ?
      AND `category.translation`.`category_version_id` = `category.translation.override_1`.`category_version_id`
    WHERE
      `category.translation`.`language_id` = ?
  ) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id`
  AND `category.category_translation`.`category_version_id` = `category`.`version_id`
WHERE
  (`category`.`version_id` = ?)
  AND (
    `category`.`id` IN (?)
  )

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.translation.override_1.name`, `category.translation.name`, COALESCE(`category.translation.override_1.name`,`category.translation.name`) as `category.name`, `category.translation.override_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.override_1.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.override_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.override_1.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.override_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.override_1.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.override_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.override_1.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.override_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.override_1.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.override_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.override_1.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.override_1.description`, `category.translation.description`, COALESCE(`category.translation.override_1.description`,`category.translation.description`) as `category.description`, `category.translation.override_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.override_1.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.override_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.override_1.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.override_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.override_1.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.override_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.override_1.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation.override_1`.`breadcrumb` as `category.translation.override_1.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation.override_1`.`name` as `category.translation.override_1.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation.override_1`.`custom_fields` as `category.translation.override_1.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation.override_1`.`slot_config` as `category.translation.override_1.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation.override_1`.`link_type` as `category.translation.override_1.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation.override_1`.`internal_link` as `category.translation.override_1.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation.override_1`.`external_link` as `category.translation.override_1.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation.override_1`.`link_new_tab` as `category.translation.override_1.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation.override_1`.`description` as `category.translation.override_1.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation.override_1`.`meta_title` as `category.translation.override_1.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation.override_1`.`meta_description` as `category.translation.override_1.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords`, `category.translation.override_1`.`keywords` as `category.translation.override_1.keywords` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation`.`category_id` = `category.translation.override_1`.`category_id` AND `category.translation.override_1`.`language_id` = 0x8E059FD029F94868BCB5B3BC85EC4F38 AND `category.translation`.`category_version_id` = `category.translation.override_1`.`category_version_id` WHERE `category.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`category`.`id` IN (0x019151070D8A74B09FE6479B1F54A5A3));

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

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