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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0xF5BD69415F6D4DC792187D326D7D944D OR sales_channel_id IS NULL)) AND ((seo_path_info = 'account/login' OR seo_path_info = 'account/login/'));

# seo-url::resolve-fallback
SELECT
  path_info pathInfo,
  seo_path_info seoPathInfo
FROM
  seo_url
WHERE
  (language_id = ?)
  AND (sales_channel_id = ?)
  AND (path_info = ?)
  AND (is_canonical = 1)
LIMIT
  1

# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (sales_channel_id = 0xF5BD69415F6D4DC792187D326D7D944D) AND (path_info = '/account/login') AND (is_canonical = 1) LIMIT 1;

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 = 'KRPICWe4vyw3kCCyenzIVShomUss8q9C') 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` = 'KRPICWe4vyw3kCCyenzIVShomUss8q9C';

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

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

SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = 'de-DE';

# 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` = '/account/login' 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 = 0x945147E8C7FF4F6FB9D033AA45C19409;

SELECT
  min_search_length
FROM
  product_search_config
WHERE
  language_id = ?

SELECT min_search_length FROM product_search_config WHERE language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B;

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.name`,
  `category.translation.name` as `category.name`,
  `category.translation.breadcrumb`,
  `category.translation.breadcrumb` as `category.breadcrumb`,
  `category.translation.slotConfig`,
  `category.translation.slotConfig` as `category.slotConfig`,
  `category.translation.linkType`,
  `category.translation.linkType` as `category.linkType`,
  `category.translation.internalLink`,
  `category.translation.internalLink` as `category.internalLink`,
  `category.translation.externalLink`,
  `category.translation.externalLink` as `category.externalLink`,
  `category.translation.linkNewTab`,
  `category.translation.linkNewTab` as `category.linkNewTab`,
  `category.translation.description`,
  `category.translation.description` as `category.description`,
  `category.translation.metaTitle`,
  `category.translation.metaTitle` as `category.metaTitle`,
  `category.translation.metaDescription`,
  `category.translation.metaDescription` as `category.metaDescription`,
  `category.translation.keywords`,
  `category.translation.keywords` as `category.keywords`,
  `category.translation.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`.`name` as `category.translation.name`,
      `category.translation`.`custom_fields` as `category.translation.customFields`,
      `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`
    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`
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.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.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`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `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` 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` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`category`.`id` IN (0x945147E8C7FF4F6FB9D033AA45C19409));

SELECT
  `name`,
  `type`
FROM
  `custom_field`
WHERE
  `active` = 1

SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1;

# seo_url::replacement
SELECT
  seo_path_info,
  path_info,
  sales_channel_id
FROM
  seo_url
WHERE
  (seo_url.is_canonical = 1)
  AND (
    seo_url.path_info IN (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
  )
  AND (seo_url.language_id = ?)
  AND (
    seo_url.sales_channel_id = ?
    OR seo_url.sales_channel_id IS NULL
  )
  AND (seo_url.is_deleted = 0)

# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN ('/navigation/a4eba85b194f484295e1db368487d998', '/navigation/6d6ee80f2700478598d2a2dd73db596c', '/navigation/019054bb2b5170a9a01d7c52f31f4ea9', '/navigation/fd83c2142ea34ff79f669fc3b470c847', '/navigation/4caf7ca43166417fbc51a18c8d3b35b5', '/navigation/4c3cb605bb5f46d0b8815e225822bb38', '/navigation/ec69130494f64dcda67f1b66ee15e944', '/navigation/1d01dbdb4fc341dc9a290a794584bb7c', '/navigation/047fa5566a90433099a68b4482400a3b', '/navigation/af1ada8ff50041b2a7d8214ab38073e7', '/navigation/223a73dedbd74d6f9e646bfb26c17644', '/navigation/cbe776f2f17445b5b71a4dcd1f17684d', '/navigation/df8b1327dc5b43f9bcd2a4acd91292bc', '/navigation/6fcab224d2624b1d878a27b23573a3b0', '/navigation/2c510ce953744e019e61d3c91a263630', '/navigation/a57540baf2404a14bea6b645e586a4bc', '/navigation/52860544a42142929223dc983f564868', '/navigation/6afcd0f2aa004fcf90e75d26804e6aba', '/navigation/ace73fce4a18439ca507e5ef8a621405', '/navigation/015cded59f9643cbbb9abe36fe26853c', '/navigation/682c3e125204499fbe42ab14ba4be8bc', '/navigation/a84134df514649299a5e74a135bd6202', '/navigation/2accf100594b4a18b86548e573816b54', '/navigation/5f0f26157e27471d975bc7cc1a376544', '/navigation/5c56e77c506e40839eb8e46fbe301a2f', '/navigation/8b7aa8324bbe4134af70d1498ffca82a', '/navigation/529080be909a4c99bdfd83bb642d3e5b', '/navigation/377741c87cbb4f81ada4bfa2263a9327', '/navigation/08597fcdfd33419eaa40edcee02e108d', '/navigation/54cbf57c7c84417291be74e20d339923', '/navigation/67137434aa8148c7ac9b6ad0c4e939d6', '/navigation/aa796c4af5074afda19790c91972c71c', '/navigation/53a4b9bc9c81421da0c93d1df0d30a05', '/navigation/61058fc42b244c1785b45c1035c66f56', '/navigation/031aa1700ccf4c48bcf1af4dfa1a1ed7', '/navigation/fc69b7e724e040889b0cf12da505d36c', '/navigation/1b84ab6c827b47fbb1bb3dc82c030e45', '/navigation/17830a0aef264dbfaa48994e6c56eab0', '/navigation/504b975fc2a14ef98defbebd48d4ce56', '/navigation/5d557a1e0e29406b81fe2e2486b6e11a', '/navigation/329dd51d6fd8423a960e7c8f26dd008a', '/navigation/e4babda014724d45b2a51362ada93000', '/navigation/31db06e32f474000b38b730ba8cb7a66', '/navigation/402848d7bfda40fa8cd123c23f90a3f2', '/navigation/706802a8b40d44c3a7cde9cec363bbea', '/navigation/8a7567c6c84542b3b512e66c878c42da', '/navigation/10abdfaa320f44e1a066e34e02694fed', '/navigation/96d703f3e5184525adea87d4f2a343b6', '/navigation/2c368932efa343a79f1c158fd6f9b74a', '/navigation/582d16fca3ae4dd6a1d642583f30e51f', '/navigation/4a7e5308a0d64685b8a7951ab335d636', '/navigation/200d6e2092f04ed78d93156f44c5dcc5', '/navigation/603938ad7d2841c4892e7a976d33f355', '/navigation/91aa4913710445719d928f4760cd5f72', '/navigation/e32c15534c54487d816306309ee3df79', '/navigation/f869c1b352984703842b46de65154eda', '/navigation/42a1b4a1be8347868a00a19c6f2fd1bd', '/navigation/b1cbc7b817624af78dbbcf136346dcb4', '/navigation/37456140c9fc4891be3d1d83976e25af', '/navigation/8851c6eabf8a45999b0c259c2291f956', '/navigation/6cd9878b596e4f08a1ad09f7295cf0bc', '/navigation/e78fe328b7d44b2db251867adaaf4d40', '/navigation/6a566dc5b6a1411da95731b89b5ecba7', '/navigation/04f4be699afa469a9858c79b02c14bd6', '/navigation/5fcca137c497482c971e528a59ac5682', '/navigation/3f4ea6ea8cc344c1b310990f899b406a', '/navigation/53eed4cc11874022b00d6c2224361cd9', '/navigation/ca189a3f460141de9513fd718ca02f92', '/navigation/ca8e5a5739fb4de5a0e027599b1fcc21', '/navigation/f21fde8bbc7d495b8201585439a0e053', '/navigation/ae25489caa554f64a962d59ec3614479', '/navigation/019150ed7c667a3999470ccbc1702a49', '/navigation/ba36106b03bd4fe0bb09f7b1ab699314', '/navigation/477404fd7e9d4ab78586e0d26e266f8b', '/navigation/019150eddab57d86bf4c4d5eafe6b157', '/navigation/5e15e148ad6a4ce189e00bcc6f037ec4', '/navigation/228b5086995b4797b2ca631844ba3d44', '/navigation/aafdb3c39e004c05850a51612e1875ac', '/navigation/7cb74b64b20941d7aafb19b42e5f2fe0', '/navigation/99f5ee3a5bd648279a1c28509736d8f7', '/navigation/fff53c4488b648a9b9dd095e53bb2440', '/navigation/0cdb9daa09fa4d65b8ea01e4559e4efd', '/navigation/3292be97c8de4e73b39e5a71e38fbab9', '/navigation/0190e90525ff70a89d17aed5e552d36d', '/navigation/0190e90565347ca2a4ddcde9c405a8f3', '/navigation/019150eba46674b985e95aedd2f28c4e', '/navigation/0190e9067f427309af029facda17e279', '/navigation/0190e9069c927eecb7b37cb70c885cf1', '/navigation/0190e90703467f05960cdf393d2b9334', '/navigation/0190e90838d67625a7019d87909e7d2e', '/navigation/0190e9106c9e77a2b56ffa46f769f08c', '/navigation/0190e94d44e47d94a7f205b85b155086', '/navigation/0190e94d5ce2740aa5a658ac5f68d3ce', '/navigation/0190e946c6977e1092a7739913a80511', '/navigation/0190e94b139e70d49f734c7f0d447eb1', '/navigation/0190e94b5379790eae0f4ba3d58d0aae', '/navigation/0190e94b72637cb0935dffb236ba6d9b', '/navigation/0190e94b83ed7159a7d08dc5864cae3c', '/navigation/0190e94b94517b20b9122a5b78be7897', '/navigation/b2d347310ba8447a9dac9a9f860a078f', '/navigation/0190e955be0472ef926b093587aeec25', '/navigation/0190e955d6d276de901444c4a12b4e8c', '/navigation/0190e95739267f8099ed81a69c5303e0', '/navigation/0190ee64a2637051a9c7c179a0aedc86', '/navigation/52eadbc235f2414b9f2abf92bc3d2745', '/navigation/164a96bd7d4342de881b37867c767677', '/navigation/019150d6e0a37a9787423845e973327a', '/navigation/019150d7032b79029708d471a8179169', '/navigation/01918eb5428779e5b343828a0c27999f', '/navigation/eb8c4e8c0eeb4d61a9cc948194d03837', '/navigation/3fca686965c44f0f8cc10d7deba98065', '/navigation/0191f155bf31719ba36094641801aa92', '/navigation/877581eca99543f69b6dd437d1e52231', '/navigation/2f23ce7a9fef421b8712a8398843a212', '/navigation/8539fa0bcf884fb6992d29526525b0c2', '/navigation/0190e958a3aa7c20af04eb97a5e7275b', '/navigation/86830b38338047ff81c4d6c99c3456e5', '/navigation/f60703628bef44eab3f8086b8446f142', '/navigation/0190e95890bf7becab53fd219c2e2a8c', '/navigation/9817a203826d462680aef526185a6e46', '/navigation/76f18a459ead4933a7c480f128884e2e', '/navigation/c23856d608f2427d8bf020df8c54dcc8', '/navigation/0190e9587cf777ce8abf5b0040dea2b7', '/navigation/2730b7df44e54f52a07f810653775d14', '/navigation/ae62acbe5c624ae1a6cb3aa14b229931', '/navigation/2c680d7edafb454eb68276ebf56e6c43', '/navigation/bee82e199aee43eebc458a57706362ca', '/navigation/0dcd561162fb416c9715b9d8c600dffc', '/navigation/7186ebfb563a410989dc3de99beec5ca', '/navigation/b8be3bb6650b459aa3192e395f4a80e1', '/navigation/38f7724f59454bc4a44e19924bd4a4cf', '/navigation/a903d001e82d4c709e2545176fc4afb6', '/navigation/cda2229891094652915ae7d767a6c2b4', '/navigation/01922a02bf21757caf06ceba1fc61d95', '/navigation/f19f9d07a7d34771bb004d673c4005ca', '/navigation/06e0851ac15549adb6a228a033ed3619', '/navigation/786f48a8e73747c29fd2887b74d9a5e2', '/navigation/29e040585255439c9e4fce9fc8e699b3', '/navigation/8f09f653a0df4381a2f532d833c5bc03', '/navigation/1fb05e61003e421d8dd8daaca863946f', '/navigation/3660c6ec7cbb4b51b472e3f17cb4a7eb', '/navigation/70afc5c43eed4d1ea4d2e38b3074b5dd', '/navigation/1217fc23af1649b68ef836300994a05e', '/navigation/019151070d8a74b09fe6479b1f54a5a3', '/navigation/89845eafc8b64f47ab81f17702eb537b', '/navigation/01915107ba82739ebe07e12fbc4746e7', '/navigation/01915107cd647ed5950ff40cfac4a32a', '/account/recover', '/navigation/0190de58b01475beb3663897fc94b575')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0xF5BD69415F6D4DC792187D326D7D944D OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

SELECT
  `rule`.`id` as `rule.id`,
  `rule`.`name` as `rule.name`,
  `rule`.`priority` as `rule.priority`,
  `rule`.`description` as `rule.description`,
  `rule`.`payload` as `rule.payload`,
  `rule`.`invalid` as `rule.invalid`,
  `rule`.`areas` as `rule.areas`,
  `rule`.`custom_fields` as `rule.customFields`,
  `rule`.`module_types` as `rule.moduleTypes`,
  `rule`.`created_at` as `rule.createdAt`,
  `rule`.`updated_at` as `rule.updatedAt`
FROM
  `rule`
WHERE
  `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?)