Symfony Profiler

# header::navigation::read
SELECT
  `category`.`id` as `category.id`,
  `category`.`version_id` as `category.versionId`,
  `category`.`parent_id` as `category.parentId`,
  `category`.`parent_version_id` as `category.parentVersionId`,
  `category`.`after_category_id` as `category.afterCategoryId`,
  `category`.`after_category_version_id` as `category.afterCategoryVersionId`,
  `category`.`media_id` as `category.mediaId`,
  `category`.`display_nested_products` as `category.displayNestedProducts`,
  `category`.`auto_increment` as `category.autoIncrement`,
  `category`.`level` as `category.level`,
  `category`.`path` as `category.path`,
  `category`.`child_count` as `category.childCount`,
  `category`.`type` as `category.type`,
  `category`.`product_assignment_type` as `category.productAssignmentType`,
  `category`.`visible` as `category.visible`,
  `category`.`active` as `category.active`,
  `category`.`cms_page_id` as `category.cmsPageId`,
  `category`.`cms_page_version_id` as `category.cmsPageVersionId`,
  `category`.`product_stream_id` as `category.productStreamId`,
  `category`.`custom_entity_type_id` as `category.customEntityTypeId`,
  `category`.`created_at` as `category.createdAt`,
  `category`.`updated_at` as `category.updatedAt`,
  `category.media`.`id` as `category.media.id`,
  `category.media`.`user_id` as `category.media.userId`,
  `category.media`.`media_folder_id` as `category.media.mediaFolderId`,
  `category.media`.`mime_type` as `category.media.mimeType`,
  `category.media`.`file_extension` as `category.media.fileExtension`,
  `category.media`.`uploaded_at` as `category.media.uploadedAt`,
  `category.media`.`file_name` as `category.media.fileName`,
  `category.media`.`file_size` as `category.media.fileSize`,
  `category.media`.`media_type` as `category.media.mediaTypeRaw`,
  `category.media`.`meta_data` as `category.media.metaData`,
  `category.media`.`config` as `category.media.config`,
  `category.media`.`path` as `category.media.path`,
  `category.media`.`private` as `category.media.private`,
  `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`,
  `category.media`.`created_at` as `category.media.createdAt`,
  `category.media`.`updated_at` as `category.media.updatedAt`,
  `category.media.translation.title`,
  `category.media.translation.title` as `category.media.title`,
  `category.media.translation.alt`,
  `category.media.translation.alt` as `category.media.alt`,
  `category.media.translation.customFields`,
  `category.media.translation.customFields` as `category.media.customFields`,
  `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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id`
  LEFT JOIN (
    SELECT
      `category.translation`.`category_id`,
      `category.translation`.`category_version_id`,
      `category.translation`.`breadcrumb` as `category.translation.breadcrumb`,
      `category.translation`.`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`
  LEFT JOIN (
    SELECT
      `category.media.translation`.`media_id`,
      `category.media.translation`.`alt` as `category.media.translation.alt`,
      `category.media.translation`.`title` as `category.media.translation.title`,
      `category.media.translation`.`custom_fields` as `category.media.translation.customFields`
    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`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`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` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` 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 '%|0196e651fba773ee899c3404bd3582b9|%' AND (`category`.`level` > 1 AND `category`.`level` <= 5)));

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

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

# 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/0196e65307ce719fab57a434fee61759', '/navigation/0196e65307d972d8a721378dcb4ff888', '/navigation/0196e65307e7720697a08d4ca0f081c0', '/navigation/0196e65307f672818699342c2ee93be1', '/navigation/0196e65307f87279953e02199ec2ca69', '/navigation/0196e65307fe720cb60feb38fcca3731', '/navigation/0196e65307ff714caaf4e1a6decf69c6', '/navigation/0196e653080370108efe5b9f8bb748f9', '/navigation/0196e65308047001a12c3038cb5fd1e5', '/navigation/0196e653080673ae9376c87f580b6d7b', '/navigation/0196e65307cf71ffb8bf40af8caebd5f', '/navigation/0196e65307cf71ffb8bf40af8d520fdf', '/navigation/0196e65307cf71ffb8bf40af8e1692a7', '/navigation/0196e65307cf71ffb8bf40af8ff5209f', '/navigation/0196e65307cf71ffb8bf40af92c9ea82', '/navigation/0196e65307d071b6a98e0ad2a71acc2a', '/navigation/0196e65307d071b6a98e0ad2a9d56fe3', '/navigation/0196e65307d071b6a98e0ad2ac00d1d5', '/navigation/0196e65307d071b6a98e0ad2ac20bb28', '/navigation/0196e65307d171e48cc33480636f40d3', '/navigation/0196e65307d171e48cc3348065541e76', '/navigation/0196e65307d171e48cc3348065dec82f', '/navigation/0196e65307d171e48cc3348066732110', '/navigation/0196e65307d171e48cc3348068db8994', '/navigation/0196e65307d171e48cc3348068dbfc2f', '/navigation/0196e65307d171e48cc33480690e99c0', '/navigation/0196e65307d171e48cc334806b1551b9', '/navigation/0196e65307d2707d80d0320f4eb16d57', '/navigation/0196e65307d2707d80d0320f4f4211db', '/navigation/0196e65307d2707d80d0320f517b25de', '/navigation/0196e65307d2707d80d0320f53a9025f', '/navigation/0196e65307d2707d80d0320f56243900', '/navigation/0196e65307d2707d80d0320f56a570ac', '/navigation/0196e65307d3711ea396251145ed92b2', '/navigation/0196e65307d3711ea3962511484aeddb', '/navigation/0196e65307d3711ea39625114b5e8f08', '/navigation/0196e65307d47088943d7aee444ea847', '/navigation/0196e65307d47088943d7aee4462ff1a', '/navigation/0196e65307d47088943d7aee46a76b54', '/navigation/0196e65307d47088943d7aee48e3fdbe', '/navigation/0196e65307d571c6a9ad152164f223cc', '/navigation/0196e65307d571c6a9ad152167854804', '/navigation/0196e65307d571c6a9ad152167de6b8c', '/navigation/0196e65307d571c6a9ad15216961efe9', '/navigation/0196e65307d6724780d7a11bb10dec13', '/navigation/0196e65307d6724780d7a11bb350163e', '/navigation/0196e65307d6724780d7a11bb4ff0427', '/navigation/0196e65307d6724780d7a11bb795514e', '/navigation/0196e65307d6724780d7a11bb8096759', '/navigation/0196e65307d6724780d7a11bb81fb703', '/navigation/0196e65307d7717cb20579cf008ad0f1', '/navigation/0196e65307d7717cb20579cf032bddba', '/navigation/0196e65307d7717cb20579cf05f78a97', '/navigation/0196e65307d7717cb20579cf06ee373a', '/navigation/0196e65307d87256b6f2ea305e226769', '/navigation/0196e65307d87256b6f2ea305efc7b21', '/navigation/0196e65307d87256b6f2ea305fd13aec', '/navigation/0196e65307d87256b6f2ea306458425c', '/navigation/0196e65307d87256b6f2ea3066441dde', '/navigation/0196e65307d972d8a721378dcbe1bf3d', '/navigation/0196e65307d972d8a721378dcc73b3a0', '/navigation/0196e65307d972d8a721378dcd0bfc90', '/navigation/0196e65307d972d8a721378dceeaab78', '/navigation/0196e65307d972d8a721378dd0b91809', '/navigation/0196e65307d972d8a721378dd101222c', '/navigation/0196e65307da7277a6ad4a22dcf9bee4', '/navigation/0196e65307da7277a6ad4a22dfed4271', '/navigation/0196e65307da7277a6ad4a22e1be45f5', '/navigation/0196e65307da7277a6ad4a22e41f8949', '/navigation/0196e65307da7277a6ad4a22e4d29cac', '/navigation/0196e65307da7277a6ad4a22e587b21b', '/navigation/0196e65307db73728cd54e819db5e890', '/navigation/0196e65307db73728cd54e81a05ba9c0', '/navigation/0196e65307db73728cd54e81a06b2ac1', '/navigation/0196e65307db73728cd54e81a416d560', '/navigation/0196e65307db73728cd54e81a5799af9', '/navigation/0196e65307dc715dad24cf24f80ebb93', '/navigation/0196e65307dc715dad24cf24fbba56c0', '/navigation/0196e65307dc715dad24cf24fc83e634', '/navigation/0196e65307dc715dad24cf24fff8a0cf', '/navigation/0196e65307dd71739f3539739b700ff9', '/navigation/0196e65307dd71739f3539739e86cbfd', '/navigation/0196e65307dd71739f353973a0da7f13', '/navigation/0196e65307de732b8e2b0e54de34d3b9', '/navigation/0196e65307de732b8e2b0e54de512c51', '/navigation/0196e65307de732b8e2b0e54e1d70d14', '/navigation/0196e65307de732b8e2b0e54e3cf72bf', '/navigation/0196e65307df707986e777bab66432c3', '/navigation/0196e65307df707986e777bab77c3a3f', '/navigation/0196e65307df707986e777bab7b3cadf', '/navigation/0196e65307df707986e777bab7c2de3b', '/navigation/0196e65307df707986e777baba5470af', '/navigation/0196e65307e070448991d18c16b262c1', '/navigation/0196e65307e070448991d18c18b6f02c', '/navigation/0196e65307e070448991d18c1aa8f884', '/navigation/0196e65307e070448991d18c1d3fcd05', '/navigation/0196e65307e070448991d18c1df0ab18', '/navigation/0196e65307e1704392a7b4139e15cc65', '/navigation/0196e65307e1704392a7b4139fcabbd0', '/navigation/0196e65307e1704392a7b413a0cf9b7d', '/navigation/0196e65307e1704392a7b413a3374e11', '/navigation/0196e65307e273ebb2728894f2e0287a', '/navigation/0196e65307e273ebb2728894f3db1241', '/navigation/0196e65307e273ebb2728894f82de29b', '/navigation/0196e65307e273ebb2728894fb4f3c47', '/navigation/0196e65307e370c4b0d2503eadd1e260', '/navigation/0196e65307e370c4b0d2503eae4f91d0', '/navigation/0196e65307e370c4b0d2503eaf4c88ea', '/navigation/0196e65307e370c4b0d2503eb3683616', '/navigation/0196e65307e370c4b0d2503eb5e7b460', '/navigation/0196e65307e471e386b3f5a0af869707', '/navigation/0196e65307e471e386b3f5a0aff54c83', '/navigation/0196e65307e471e386b3f5a0b3d6b120', '/navigation/0196e65307e471e386b3f5a0b6acaf31', '/navigation/0196e65307e471e386b3f5a0b8abeb73', '/navigation/0196e65307e471e386b3f5a0b910fa09', '/navigation/0196e65307e572b9ae0a2bab743a2cc3', '/navigation/0196e65307e572b9ae0a2bab7701df81', '/navigation/0196e65307e572b9ae0a2bab782e3dbc', '/navigation/0196e65307e572b9ae0a2bab7ab6065a', '/navigation/0196e65307e6734382ccef728ec78b9d', '/navigation/0196e65307e6734382ccef728fb35332', '/navigation/0196e65307e6734382ccef7293493adb', '/navigation/0196e65307e6734382ccef7295d59538', '/navigation/0196e65307e7720697a08d4ca16cd72a', '/navigation/0196e65307e7720697a08d4ca232ace7', '/navigation/0196e65307e7720697a08d4ca262a1b6', '/navigation/0196e65307e7720697a08d4ca555a8ff', '/navigation/0196e65307e870fa93ccb2511c4c6cbd', '/navigation/0196e65307e870fa93ccb2511c7cc63c', '/navigation/0196e65307e870fa93ccb2511dff0af6', '/navigation/0196e65307e870fa93ccb2511fad1c55', '/navigation/0196e65307e870fa93ccb2512288107e', '/navigation/0196e65307e970a3a84d6dd7a2391074', '/navigation/0196e65307e970a3a84d6dd7a5790254', '/navigation/0196e65307e970a3a84d6dd7a5c3fb04', '/navigation/0196e65307e970a3a84d6dd7a6772c0b', '/navigation/0196e65307e970a3a84d6dd7a82d8bd6', '/navigation/0196e65307ea711985c4190679bef5bb', '/navigation/0196e65307ea711985c419067c1e42ba', '/navigation/0196e65307ea711985c419067f7fae4c', '/navigation/0196e65307ea711985c41906800e18d6', '/navigation/0196e65307eb713b96dad710930a690f', '/navigation/0196e65307eb713b96dad71096063807', '/navigation/0196e65307eb713b96dad710986b967e', '/navigation/0196e65307ec708791d6366a28ba2c44', '/navigation/0196e65307ec708791d6366a2ab583d4', '/navigation/0196e65307ec708791d6366a2b03f0ba', '/navigation/0196e65307ec708791d6366a2d7e103c', '/navigation/0196e65307ec708791d6366a30101623', '/navigation/0196e65307ed73ee92063c8f3b7841d6', '/navigation/0196e65307ed73ee92063c8f3e5d5c2e', '/navigation/0196e65307ed73ee92063c8f4160b7cc', '/navigation/0196e65307ed73ee92063c8f416ca0fd', '/navigation/0196e65307ee7254973c861721552ba1', '/navigation/0196e65307ee7254973c8617248f319d', '/navigation/0196e65307ee7254973c861727665a8c', '/navigation/0196e65307ee7254973c8617277bf685', '/navigation/0196e65307ef715784865c4071e50dd6', '/navigation/0196e65307ef715784865c40742042cb', '/navigation/0196e65307ef715784865c4075dd65d6', '/navigation/0196e65307ef715784865c40761bbc45', '/navigation/0196e65307ef715784865c40768fdb5b', '/navigation/0196e65307ef715784865c4077d4ccc2', '/navigation/0196e65307f070978fc582e7e8c2b082', '/navigation/0196e65307f070978fc582e7eb42738d', '/navigation/0196e65307f070978fc582e7ef2128eb', '/navigation/0196e65307f171f3841bf66c58d25116', '/navigation/0196e65307f171f3841bf66c5914211f', '/navigation/0196e65307f171f3841bf66c5c907b67', '/navigation/0196e65307f171f3841bf66c5ec51e50', '/navigation/0196e65307f272fab9a83858f9b543eb', '/navigation/0196e65307f272fab9a83858fc4a42af', '/navigation/0196e65307f272fab9a83858ff4b1da1', '/navigation/0196e65307f272fab9a83858ffb0e26d', '/navigation/0196e65307f371a68cd34a1125540a9a', '/navigation/0196e65307f371a68cd34a1127c77823', '/navigation/0196e65307f371a68cd34a11288f11b1', '/navigation/0196e65307f371a68cd34a112b6fefba', '/navigation/0196e65307f371a68cd34a112d19f96e', '/navigation/0196e65307f371a68cd34a112d2953a4', '/navigation/0196e65307f47302942bed97fc0cb310', '/navigation/0196e65307f47302942bed97fe242914', '/navigation/0196e65307f47302942bed97ffedf268', '/navigation/0196e65307f47302942bed980378dfb1', '/navigation/0196e65307f570f3a1ec37c3c18eb3c2', '/navigation/0196e65307f570f3a1ec37c3c1c7a8d2', '/navigation/0196e65307f570f3a1ec37c3c5213eac', '/navigation/0196e65307f570f3a1ec37c3c6e2beb4', '/navigation/0196e65307f570f3a1ec37c3c7515338', '/navigation/0196e65307f672818699342c2c8de04d', '/navigation/0196e65307f672818699342c2facb5d1', '/navigation/0196e65307f672818699342c2ffdb46e', '/navigation/0196e65307f672818699342c300a288b', '/navigation/0196e65307f672818699342c30ab1592', '/navigation/0196e65307f672818699342c30f91f52', '/navigation/0196e65307f672818699342c31a2dcbe', '/navigation/0196e65307f770a8ac4acd1d90c6030c', '/navigation/0196e65307f770a8ac4acd1d91aedda4', '/navigation/0196e65307f770a8ac4acd1d920786f1', '/navigation/0196e65307f770a8ac4acd1d92da6279', '/navigation/0196e65307f770a8ac4acd1d933b4f47', '/navigation/0196e65307f770a8ac4acd1d93e20822', '/navigation/0196e65307f770a8ac4acd1d94456fd4', '/navigation/0196e65307f770a8ac4acd1d94a5a943', '/navigation/0196e65307f770a8ac4acd1d952bd7dd', '/navigation/0196e65307f770a8ac4acd1d95959eeb', '/navigation/0196e65307f770a8ac4acd1d95bfd1ca', '/navigation/0196e65307f770a8ac4acd1d95d30245', '/navigation/0196e65307f770a8ac4acd1d9694ea94', '/navigation/0196e65307f770a8ac4acd1d97798638', '/navigation/0196e65307f770a8ac4acd1d97ff502d', '/navigation/0196e65307f770a8ac4acd1d9856c372', '/navigation/0196e65307f87279953e021998e675bb', '/navigation/0196e65307f87279953e021998eebe4f', '/navigation/0196e65307f87279953e02199980f561', '/navigation/0196e65307f87279953e0219999edec1', '/navigation/0196e65307f87279953e021999d8640d', '/navigation/0196e65307f87279953e02199a4e50c3', '/navigation/0196e65307f87279953e02199ab0d3cb', '/navigation/0196e65307f87279953e02199b20d564', '/navigation/0196e65307f87279953e02199b6aaba5', '/navigation/0196e65307f87279953e02199c2ee132', '/navigation/0196e65307f87279953e02199c6b6245', '/navigation/0196e65307f87279953e02199cabcb53', '/navigation/0196e65307f87279953e02199d88470c', '/navigation/0196e65307f87279953e02199e4db582', '/navigation/0196e65307f970308c5dfcdcd81db73c', '/navigation/0196e65307f970308c5dfcdcd8499434', '/navigation/0196e65307f970308c5dfcdcd8ae70de', '/navigation/0196e65307f970308c5dfcdcd8fe72d5', '/navigation/0196e65307f970308c5dfcdcd92e90c9', '/navigation/0196e65307f970308c5dfcdcd9c0651d', '/navigation/0196e65307f970308c5dfcdcda8b2392', '/navigation/0196e65307f970308c5dfcdcdb82db46', '/navigation/0196e65307f970308c5dfcdcdc2f8b68', '/navigation/0196e65307f970308c5dfcdcdc9c3c26', '/navigation/0196e65307f970308c5dfcdcdd161905', '/navigation/0196e65307f970308c5dfcdcdda943d6', '/navigation/0196e65307f970308c5dfcdcde3e82dc', '/navigation/0196e65307f970308c5dfcdcdee5f662', '/navigation/0196e65307f970308c5dfcdcdfad1d33', '/navigation/0196e65307f970308c5dfcdce06b6ceb', '/navigation/0196e65307f970308c5dfcdce0dd2e94', '/navigation/0196e65307fa7399bee979bb7c02e29a', '/navigation/0196e65307fa7399bee979bb7c5a3ac5', '/navigation/0196e65307fa7399bee979bb7cb00a90', '/navigation/0196e65307fa7399bee979bb7ce1bb48', '/navigation/0196e65307fa7399bee979bb7dceb185', '/navigation/0196e65307fa7399bee979bb7e06e2f8', '/navigation/0196e65307fa7399bee979bb7e390083', '/navigation/0196e65307fa7399bee979bb7ec6e782', '/navigation/0196e65307fa7399bee979bb7ee8d0f7', '/navigation/0196e65307fa7399bee979bb7f4937dc', '/navigation/0196e65307fa7399bee979bb7f5c66a6', '/navigation/0196e65307fa7399bee979bb7fba8f91', '/navigation/0196e65307fa7399bee979bb80012178', '/navigation/0196e65307fa7399bee979bb805978a3', '/navigation/0196e65307fa7399bee979bb8144aa00', '/navigation/0196e65307fa7399bee979bb81bf73f4', '/navigation/0196e65307fb72619d8ba4d70ab684ee', '/navigation/0196e65307fb72619d8ba4d70aca62dd', '/navigation/0196e65307fb72619d8ba4d70bc7a0d1', '/navigation/0196e65307fb72619d8ba4d70c08845b', '/navigation/0196e65307fb72619d8ba4d70c9d91c0', '/navigation/0196e65307fb72619d8ba4d70cbff95e', '/navigation/0196e65307fb72619d8ba4d70d6e8694', '/navigation/0196e65307fb72619d8ba4d70dff76f2', '/navigation/0196e65307fb72619d8ba4d70e1e9084', '/navigation/0196e65307fb72619d8ba4d70e8333d9', '/navigation/0196e65307fb72619d8ba4d70f31fcfb', '/navigation/0196e65307fb72619d8ba4d7100a2725', '/navigation/0196e65307fb72619d8ba4d710dba124', '/navigation/0196e65307fb72619d8ba4d7118ce853', '/navigation/0196e65307fb72619d8ba4d71256b1c3', '/navigation/0196e65307fb72619d8ba4d712941496', '/navigation/0196e65307fc7145a4520bf0a69c387d', '/navigation/0196e65307fc7145a4520bf0a78669d0', '/navigation/0196e65307fc7145a4520bf0a78a3ec6', '/navigation/0196e65307fc7145a4520bf0a7ce0399', '/navigation/0196e65307fc7145a4520bf0a7e3f7ef', '/navigation/0196e65307fc7145a4520bf0a8062e4b', '/navigation/0196e65307fc7145a4520bf0a8ed0c5b', '/navigation/0196e65307fc7145a4520bf0a98e76b4', '/navigation/0196e65307fc7145a4520bf0aa4b56af', '/navigation/0196e65307fc7145a4520bf0aaad9ac5', '/navigation/0196e65307fc7145a4520bf0aadf5e4d', '/navigation/0196e65307fc7145a4520bf0abd2ba76', '/navigation/0196e65307fc7145a4520bf0abe35d22', '/navigation/0196e65307fc7145a4520bf0acbbe629', '/navigation/0196e65307fc7145a4520bf0acde933b', '/navigation/0196e65307fd711080c4b6e3d4544f2a', '/navigation/0196e65307fd711080c4b6e3d49c3e59', '/navigation/0196e65307fd711080c4b6e3d569f656', '/navigation/0196e65307fd711080c4b6e3d626ae17', '/navigation/0196e65307fd711080c4b6e3d6a3d15e', '/navigation/0196e65307fd711080c4b6e3d7779647', '/navigation/0196e65307fd711080c4b6e3d83acfa8', '/navigation/0196e65307fd711080c4b6e3d885ebb6', '/navigation/0196e65307fd711080c4b6e3d8b78a96', '/navigation/0196e65307fd711080c4b6e3d9227524', '/navigation/0196e65307fd711080c4b6e3d9f382a0', '/navigation/0196e65307fd711080c4b6e3da10495f', '/navigation/0196e65307fd711080c4b6e3dae225b9', '/navigation/0196e65307fd711080c4b6e3db1f1796', '/navigation/0196e65307fd711080c4b6e3dc021959', '/navigation/0196e65307fe720cb60feb38f83b1bac', '/navigation/0196e65307fe720cb60feb38f86962ae', '/navigation/0196e65307fe720cb60feb38f8ef8742', '/navigation/0196e65307fe720cb60feb38f9dd95bb', '/navigation/0196e65307fe720cb60feb38fa1dcf83', '/navigation/0196e65307fe720cb60feb38fa992d49', '/navigation/0196e65307fe720cb60feb38fae4fa82', '/navigation/0196e65307fe720cb60feb38fbdb1cb3', '/navigation/0196e65307fe720cb60feb38fc1fb346', '/navigation/0196e65307fe720cb60feb38fd5e8433', '/navigation/0196e65307fe720cb60feb38fdf82e21', '/navigation/0196e65307fe720cb60feb38fe2b3b1f', '/navigation/0196e65307fe720cb60feb38fe4441e9', '/navigation/0196e65307fe720cb60feb38fed9d47d', '/navigation/0196e65307ff714caaf4e1a6dcbf2664', '/navigation/0196e65307ff714caaf4e1a6dcd58471', '/navigation/0196e65307ff714caaf4e1a6dd56f8d1', '/navigation/0196e65307ff714caaf4e1a6de0eea7e', '/navigation/0196e65307ff714caaf4e1a6de143e00', '/navigation/0196e65307ff714caaf4e1a6dec3552f', '/navigation/0196e65307ff714caaf4e1a6df57304b', '/navigation/0196e65307ff714caaf4e1a6dfb1d93b', '/navigation/0196e65307ff714caaf4e1a6e0991d48', '/navigation/0196e65307ff714caaf4e1a6e13cd979', '/navigation/0196e65307ff714caaf4e1a6e18aeca1', '/navigation/0196e65307ff714caaf4e1a6e1bbfa0a', '/navigation/0196e65307ff714caaf4e1a6e212cfd4', '/navigation/0196e65307ff714caaf4e1a6e251d30e', '/navigation/0196e65307ff714caaf4e1a6e2d6f941', '/navigation/0196e65307ff714caaf4e1a6e3373676', '/navigation/0196e6530800709b918fe479b366be2f', '/navigation/0196e6530800709b918fe479b41eb90f', '/navigation/0196e6530800709b918fe479b42c3b95', '/navigation/0196e6530800709b918fe479b5050458', '/navigation/0196e6530800709b918fe479b5efdbe1', '/navigation/0196e6530800709b918fe479b629f62e', '/navigation/0196e6530800709b918fe479b6d6996e', '/navigation/0196e6530800709b918fe479b77b465b', '/navigation/0196e6530800709b918fe479b77db3b9', '/navigation/0196e6530800709b918fe479b7ae3428', '/navigation/0196e6530800709b918fe479b7e220db', '/navigation/0196e6530800709b918fe479b8b72916', '/navigation/0196e6530800709b918fe479b8d6f813', '/navigation/0196e6530800709b918fe479b9290bba', '/navigation/0196e6530800709b918fe479b99388f3', '/navigation/0196e6530800709b918fe479ba3e0321', '/navigation/0196e6530800709b918fe479bb3c2517', '/navigation/0196e653080173a58831fba67978fd1a', '/navigation/0196e653080173a58831fba679c44d3d', '/navigation/0196e653080173a58831fba67aa9f56a', '/navigation/0196e653080173a58831fba67b6f0f58', '/navigation/0196e653080173a58831fba67bbcafe5', '/navigation/0196e653080173a58831fba67be4cad9', '/navigation/0196e653080173a58831fba67c6be7ce', '/navigation/0196e653080173a58831fba67cb26979', '/navigation/0196e653080173a58831fba67d7882aa', '/navigation/0196e653080173a58831fba67d82a8d6', '/navigation/0196e653080173a58831fba67dd458e2', '/navigation/0196e653080173a58831fba67e85ba8b', '/navigation/0196e653080173a58831fba67f03ef76', '/navigation/0196e653080173a58831fba67f801542', '/navigation/0196e653080273cfbcb93b4adf79a492', '/navigation/0196e653080273cfbcb93b4adfe6ec27', '/navigation/0196e653080273cfbcb93b4ae031df5d', '/navigation/0196e653080273cfbcb93b4ae1133cb9', '/navigation/0196e653080273cfbcb93b4ae20dece1', '/navigation/0196e653080273cfbcb93b4ae2da0fa0', '/navigation/0196e653080273cfbcb93b4ae3b3f5c6', '/navigation/0196e653080273cfbcb93b4ae44aee90', '/navigation/0196e653080273cfbcb93b4ae46d5f76', '/navigation/0196e653080273cfbcb93b4ae54a8d16', '/navigation/0196e653080273cfbcb93b4ae623acc7', '/navigation/0196e653080273cfbcb93b4ae687f680', '/navigation/0196e653080273cfbcb93b4ae783edb8', '/navigation/0196e653080273cfbcb93b4ae7b25209', '/navigation/0196e653080273cfbcb93b4ae886b750', '/navigation/0196e653080273cfbcb93b4ae8a988d1', '/navigation/0196e653080370108efe5b9f8b7a5797', '/navigation/0196e653080370108efe5b9f8c433391', '/navigation/0196e653080370108efe5b9f8ce7852c', '/navigation/0196e653080370108efe5b9f8d3621d6', '/navigation/0196e653080370108efe5b9f8d8de1b7', '/navigation/0196e653080370108efe5b9f8e46fcfe', '/navigation/0196e653080370108efe5b9f8e762077', '/navigation/0196e653080370108efe5b9f8f239562', '/navigation/0196e653080370108efe5b9f901aab5b', '/navigation/0196e653080370108efe5b9f902ea422', '/navigation/0196e653080370108efe5b9f905351e7', '/navigation/0196e653080370108efe5b9f90a2e957', '/navigation/0196e653080370108efe5b9f90b4a716', '/navigation/0196e65308047001a12c3038c6bcb813', '/navigation/0196e65308047001a12c3038c6f6e098', '/navigation/0196e65308047001a12c3038c7e11b6f', '/navigation/0196e65308047001a12c3038c83af77d', '/navigation/0196e65308047001a12c3038c89bd8e1', '/navigation/0196e65308047001a12c3038c8c67d00', '/navigation/0196e65308047001a12c3038c96d2290', '/navigation/0196e65308047001a12c3038c9abcdf4', '/navigation/0196e65308047001a12c3038ca5d7e1e', '/navigation/0196e65308047001a12c3038caf5e912', '/navigation/0196e65308047001a12c3038cb64d8c5', '/navigation/0196e65308047001a12c3038cc573b67', '/navigation/0196e65308047001a12c3038cd24250a', '/navigation/0196e65308047001a12c3038cd765b72', '/navigation/0196e653080571548d1213ba20f0b60a', '/navigation/0196e653080571548d1213ba213ee40b', '/navigation/0196e653080571548d1213ba218fb462', '/navigation/0196e653080571548d1213ba21d7d17c', '/navigation/0196e653080571548d1213ba22828d76', '/navigation/0196e653080571548d1213ba228c00f8', '/navigation/0196e653080571548d1213ba22f36e25', '/navigation/0196e653080571548d1213ba23f1e52e', '/navigation/0196e653080571548d1213ba24a0f9b3', '/navigation/0196e653080571548d1213ba24e8a620', '/navigation/0196e653080571548d1213ba24e90e28', '/navigation/0196e653080571548d1213ba25918b95', '/navigation/0196e653080571548d1213ba2621472b', '/navigation/0196e653080571548d1213ba26a73fc3', '/navigation/0196e653080571548d1213ba26c584dc', '/navigation/0196e653080571548d1213ba272b2553', '/navigation/0196e653080673ae9376c87f57738911', '/navigation/0196e653080673ae9376c87f5899d9c2', '/navigation/0196e653080673ae9376c87f591a9859', '/navigation/0196e653080673ae9376c87f59ee7237', '/navigation/0196e653080673ae9376c87f5a14d71d', '/navigation/0196e653080673ae9376c87f5a4ca1d2', '/navigation/0196e653080673ae9376c87f5b027923', '/navigation/0196e653080673ae9376c87f5b194c27', '/navigation/0196e653080673ae9376c87f5b79bf81', '/navigation/0196e653080673ae9376c87f5bc95624', '/navigation/0196e653080673ae9376c87f5c9da377', '/navigation/0196e653080673ae9376c87f5d3195e8', '/navigation/0196e653080673ae9376c87f5db983ea', '/navigation/0196e653080673ae9376c87f5e617764', '/navigation/0196e653080773f580b50e053af8cacc', '/navigation/0196e653080773f580b50e053bd170cc', '/navigation/0196e653080773f580b50e053c4cbf9f', '/navigation/0196e653080773f580b50e053cb11b78', '/navigation/0196e653080773f580b50e053d5ddca9', '/navigation/0196e653080773f580b50e053d8954fe', '/navigation/0196e653080773f580b50e053df299be', '/navigation/0196e653080773f580b50e053e39e071', '/navigation/0196e653080773f580b50e053f04b244', '/navigation/0196e653080773f580b50e053f4090b0', '/navigation/0196e653080773f580b50e05401c8b39', '/navigation/0196e653080773f580b50e05404b8ff1', '/navigation/0196e653080773f580b50e0540e3f89d', '/account/recover')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x0196E652B72872D483D0DE57DD989B24 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

# 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 = 0x0196E652B72872D483D0DE57DD989B24 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 = 0x0196E652B72872D483D0DE57DD989B24) AND (path_info = '/account/login') AND (is_canonical = 1) LIMIT 1;

SELECT
  `country`.`id` as `country.id`,
  `country`.`iso` as `country.iso`,
  `country`.`position` as `country.position`,
  `country`.`active` as `country.active`,
  `country`.`shipping_available` as `country.shippingAvailable`,
  `country`.`iso3` as `country.iso3`,
  `country`.`display_state_in_registration` as `country.displayStateInRegistration`,
  `country`.`force_state_in_registration` as `country.forceStateInRegistration`,
  `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`,
  `country`.`vat_id_required` as `country.vatIdRequired`,
  `country`.`vat_id_pattern` as `country.vatIdPattern`,
  `country`.`customer_tax` as `country.customerTax`,
  `country`.`company_tax` as `country.companyTax`,
  `country`.`postal_code_required` as `country.postalCodeRequired`,
  `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`,
  `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`,
  `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`,
  `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`,
  `country`.`is_eu` as `country.isEu`,
  `country`.`created_at` as `country.createdAt`,
  `country`.`updated_at` as `country.updatedAt`,
  `country.translation.name`,
  `country.translation.name` as `country.name`,
  `country.translation.addressFormat`,
  `country.translation.addressFormat` as `country.addressFormat`,
  `country.translation.customFields`,
  `country.translation.customFields` as `country.customFields`
FROM
  `country`
  LEFT JOIN (
    SELECT
      `country.translation`.`country_id`,
      `country.translation`.`name` as `country.translation.name`,
      `country.translation`.`custom_fields` as `country.translation.customFields`,
      `country.translation`.`address_format` as `country.translation.addressFormat`
    FROM
      `country_translation` `country.translation`
    WHERE
      `country.translation`.`language_id` = ?
  ) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id`
WHERE
  `country`.`id` IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )