Symfony Profiler

# 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/1b0714ca79e4496cae0022013bd2ad17', '/navigation/d06b5c68999a4346bc01e2a63273a57e', '/navigation/45b5981d3e2441139b5a553a4276492c', '/navigation/1dbc7b3c1b0e457e87aaab93da51f1f2', '/navigation/7c4fd551df154ab5a4a73da47b3dfa2c', '/navigation/df7df0d01dfe4e209e624eca2cfb51da', '/navigation/f9d486351b634f4fa21efc5be513076b', '/navigation/8e5270e2483d45da86297c26bc5902a2', '/navigation/b65743695fb643b19b95d67e9583c167', '/navigation/eab84563e99149eea0b7c873194bfda4', '/navigation/52d7d49d9b0b4386bfa2314e0eecee59', '/navigation/ca5af1233b084da6b4407c94e0dedae6', '/navigation/2c447b9ef82a4bc38f17e9a4e125b351', '/navigation/30ea8b0cfce04885a87bc0b2238df4fa', '/navigation/2eb6148675a84d708d69dbc351d64e6e', '/navigation/326b8e4f0422458e939ec42271f10659', '/navigation/b652523fc30f48b181619630f7ec0446', '/navigation/4a3fcb793d884026ab8e5f333d573c59', '/navigation/ffa8ca8fba734fb0a3d31f81d1e3d194', '/navigation/5fdd4acdd4c64eebb30c5b44e7ebbb7e', '/navigation/6f7bf10e67e14b47b30d3f7450c56529', '/navigation/3fa586de94c84c26bdbd7e2ad604884c', '/navigation/db0c6a3b132f4466a46f42456b6c6164', '/navigation/874eafa3cf434f568cd104f9b36218d8', '/navigation/a0a5e39bc69144d0bb00f86e276dbcac', '/navigation/4e19b5b7445c44f2902b5baa63bd4d6a', '/navigation/4419a6a20a4b48b9b759fd05765e1426', '/navigation/5243b4c4c3cb414785b33b0badf2b5e9', '/navigation/8561c09d079043909819996b869ca219', '/navigation/297d29069baf4792b58dd663bed97961', '/navigation/ad88fbd83e6143da95affdc5a387f6fa', '/navigation/947f8dbe945540c5ac9f5523caf7b27a', '/navigation/91579a2dad724147b0708299077d9b71', '/navigation/f72d98bab206474a93ead67e6df5123b', '/navigation/0dcc780a475542bbb6d1d46427d9e4f9', '/navigation/2836102dd05c4ff0bbbfa0eb545aea11', '/navigation/675ae359023546ea904e4028ffefa7e1', '/navigation/b0dcf7d23d044e8d961ac62607aed30b', '/detail/05a74e73037640ad8cf50a836a4d8016', '/detail/24d119e38655413cbcb4fac82c974a7e', '/detail/36df18004e724f5ca0645df8aea03e8e', '/detail/380d90e0a45a4c9e84edab1bff55af14', '/detail/44fab90b01794818b75a59ee394d5a01', '/detail/743a7718f8064eb283adb89fed5d6d04', '/detail/90dfa5566e24468f817a12204ea9c3e7', '/detail/9bbcac1748324632b08e2d1556a4992b', '/detail/af1ab6d7ae80443abe2b47fa02f9f877', '/detail/afc43fe52dd44610b14220d916916a8c', '/detail/b0b3effc9ac94de8a097d3c08fed51fa', '/detail/caf8267eb9f14b33946785aeeed3c0f5', '/detail/daf6683aa9394060815349058b239471', '/detail/f63c6a129db24f19bfe1d0d46d89663e', '/detail/2bd7ccfc182f4c9da77ceee679b741b0', '/detail/b3f6998121674ae69baf49f2a66a8b03', '/detail/c0cd59948eb4472a95abb69b9a809e80', '/detail/0237b75b9dc84210afbf976d017c9d91', '/detail/1ffe447255b54a52a61599ac7224de40', '/detail/4778ff7cc4d24eb1b8262e451f6ae7bb', '/detail/53ff7c1864fa4c66badb83371e7441af', '/detail/7b01f49a88cd4763a40e8ee80ca1dd54', '/detail/86317995e1314d03a1b49a8fdab71aa0', '/detail/ac99918390c141fe863f0b7ebf6ee7f6', '/detail/bc1d4426923646ff8f0fe22176e259ed', '/detail/cce0f645594641b7972c4f73fe3d4466', '/detail/dd689276c0de419da5a38da7034aa078', '/detail/f2247f1d600b453cb4d4fef6831220b0', '/detail/2a491279b57f4a218282890df4db70e7', '/detail/37043a6bef4b452aa7aa13e0a971a361', '/detail/42a95c6c14e745f5920f3ebe99210d38', '/detail/47027d4bde08413a8f1c90ec976ce6e8', '/detail/597cf23c9dbd4e94b3ebe54ebd1d9237', '/detail/71383fd3cf164940a63f5132885dafbd', '/detail/88e5e28c62a1441ea87b3ea8a317cf85', '/detail/9484ef13503746a19dae412afa5ad5b4', '/detail/a39b4cc286dd4a209c7d15537096f2a9', '/detail/a8f8f08c011d4e55bd0a78912c55eaab', '/detail/cd52719f05c542d1b31a956442076ece', '/detail/d453d3f110244ee2b05642046d73dd27', '/detail/d7334493d2e04ee086c738389d1560d9', '/detail/e23f5c03e80e43348b5a389f45045de3', '/detail/1513815fc946438c98179a33c6a1ca3d', '/detail/343fe1ab86b04b52962c589af612516e', '/detail/353623f3a6c34e3db2d6da0a9f164ff5', '/detail/36393b3a68e648f299925f136288c768', '/detail/44a399730c6f4ef8bd0058a1821799b9', '/detail/56e83cde0b7e48b886738dd2594f6962', '/detail/6a93236e8c084d78947b44c78aa5848f', '/detail/84cea423b6cf41ccbc0a35476a0038d8', '/detail/b34a6b0a76e64216aab503a72ce23356', '/detail/b745c46c55544a7db8ef2d7db37eec8d', '/detail/c0083264f3f844259fd605a63d29f962', '/detail/d15ccaf191744237ba585807819da2ea', '/detail/da1e9b62e15440258d0b3642c19f1ead', '/detail/dc342f2d356140f3a49651ed69992a03', '/detail/0df167a9b130406bb624995fa5851885', '/detail/616af10fdb264d068a0be884754eb534', '/detail/9fb9e49ca2654621998cf7e82af2c034', '/detail/d133908efb2e4daf97947faa5c772956', '/detail/d1421d4ffee145a795d4bc39ce9da769', '/detail/e36bd4eb17514a53adbef6f250e4447e', '/detail/e6faaadda86b4751ba4d2bc567bb525f', '/detail/f6dfde838ebd42059bff1d71a01f5a2d', '/detail/fbb544e651214898a3b0f5aa8ffe8823', '/detail/3e5d6fcfa0094927a7312b2dd03720ba', '/detail/9067457cf83e43058717a0c90fd91b0c', '/detail/83650608f8814f5784f98281a4195939', '/detail/369375be046e4c94ab8ddce736211d92', '/detail/5fa0b97e1f0d4990bb0d212fb399e07d', '/detail/6db69fc614e242c0aa404f6b9e995b6d', '/detail/0654dde89f6c4eb3a25f1c063354897e', '/detail/08fb37796f1843629741e6b6823d46d5', '/detail/2f768afc9e9946ca916e0df6a75c1dad', '/detail/3637bcb95e5a4816b4289f677f0d54c1', '/detail/48d3308252274bb88f73bcdf82c81d3b', '/detail/6df092d97f7d409dbbe75b73643eef9a', '/detail/9f816949b9ff4362a9db59a00c5caeaf', '/detail/a3a26cbaac824ddf98545bab722c7cf8', '/detail/a9b6496f1fdf415ca0c74f1c02f10996', '/detail/acd1c68265a744b88c73a38fb4086908', '/detail/b4ba4c03a43e4ca29390dab7531632de', '/detail/c71b92267ec145c98e0bbf33f0a10810', '/detail/cf26d9ad6055402bad04132375e5ae9f', '/detail/e17f65b9350f47aca1c090bedae7690e', '/detail/29f32d712aec478fadffb02e13dade09', '/detail/9a02fed7a531410883cab3bfed1a716e', '/detail/bf591e7753aa4bb78188c149b3c5efdf', '/detail/999f52ef61324e18a57253b60bd41217', '/detail/bcabc9d10bf14f429ddc056e1e68f0e5', '/detail/e51976a0292f4edd9c339ca74e08a50f', '/detail/196f5ea23b404553bff5d48d75d09a9e', '/detail/5329ab65860948ba9846480037f09aa6', '/detail/8fcff2ed6776416cb64ec7b0bff8b96d', '/detail/02d5e696cd7b495ea90587a5b569ffbc', '/detail/04f1b9ce08e84edb8eef9a49a1d7aace', '/detail/218709086cf448b2ae0383a1aba49669', '/detail/29e472845c4f4858b4d306ee96326136', '/detail/3d158966a552435b95f46a9fc76ddcd0', '/detail/4733cc239bdc404b8ca0904df98a96b0', '/detail/817348050044485284e22c341c0d3ab5', '/detail/88df35d07a5a4a53ab2bc0c0b4fc5b07', '/detail/a5bb792afe3c44a59278a6b96f6394aa', '/detail/ac57a8168d2041bbb8144e1edee193d6', '/detail/c435e260e3f34fcbafc62b83439c7fc7', '/detail/c57f0fab2a4741409d29b6bbccbf5659', '/detail/c6a4631c3606454fb9e647032c96701a', '/detail/efb3ec4e29a94bc789dcb6370b37d5c7', '/detail/06b2baa3af3446159cae10306da2125e', '/navigation/e4a89656569f4b4e907b16c3f1e110c8', '/navigation/dcdb156c097142229355aa12c32f17fd', '/navigation/ca4ffcae39324aa2b24591e8b687b24c', '/navigation/13c22f060bc043dcbfb77457f9a4a9bb', '/navigation/d4c52cad4082490d8b8ea3bcb684fb52', '/navigation/bf6901bd79954743a5cafc8ee4932b1d', '/navigation/f3e58d776ca1406299b50b9e4ee22924', '/navigation/9dc2682bee1645878578161f1e27a206', '/navigation/ad12c6e9eea44369a29190a4662d01e3', '/navigation/b527c8edfc0b4905830d07718a7a85b1', '/navigation/db0567f46da745bca8822c8ffa6a440c', '/navigation/5e4174eb13f7469790561d664e357685', '/navigation/2cc7f33c2cac4c52a2723c4da0015464', '/navigation/e47c07119ccf46589296efdfb2143449', '/navigation/8a3d68e229694a0281bae9abfc6d43bb')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0xC7B7F9F6CC1D4E0B8705FD682434397E OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

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

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

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

SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE (`app`.`name` = 'SwagGmvReporting');

SELECT
  `s4_payment_icons`.`id` as `s4_payment_icons.id`,
  `s4_payment_icons`.`title` as `s4_payment_icons.title`,
  `s4_payment_icons`.`link` as `s4_payment_icons.link`,
  `s4_payment_icons`.`alt` as `s4_payment_icons.alt`,
  `s4_payment_icons`.`position` as `s4_payment_icons.position`,
  `s4_payment_icons`.`active` as `s4_payment_icons.active`,
  `s4_payment_icons`.`created_at` as `s4_payment_icons.createdAt`,
  `s4_payment_icons`.`media_id` as `s4_payment_icons.mediaId`,
  `s4_payment_icons.media`.`id` as `s4_payment_icons.media.id`,
  `s4_payment_icons.media`.`user_id` as `s4_payment_icons.media.userId`,
  `s4_payment_icons.media`.`media_folder_id` as `s4_payment_icons.media.mediaFolderId`,
  `s4_payment_icons.media`.`mime_type` as `s4_payment_icons.media.mimeType`,
  `s4_payment_icons.media`.`file_extension` as `s4_payment_icons.media.fileExtension`,
  `s4_payment_icons.media`.`uploaded_at` as `s4_payment_icons.media.uploadedAt`,
  `s4_payment_icons.media`.`file_name` as `s4_payment_icons.media.fileName`,
  `s4_payment_icons.media`.`file_size` as `s4_payment_icons.media.fileSize`,
  `s4_payment_icons.media`.`media_type` as `s4_payment_icons.media.mediaTypeRaw`,
  `s4_payment_icons.media`.`meta_data` as `s4_payment_icons.media.metaData`,
  `s4_payment_icons.media`.`config` as `s4_payment_icons.media.config`,
  `s4_payment_icons.media`.`path` as `s4_payment_icons.media.path`,
  `s4_payment_icons.media`.`private` as `s4_payment_icons.media.private`,
  `s4_payment_icons.media`.`thumbnails_ro` as `s4_payment_icons.media.thumbnailsRo`,
  `s4_payment_icons.media`.`file_hash` as `s4_payment_icons.media.fileHash`,
  `s4_payment_icons.media`.`created_at` as `s4_payment_icons.media.createdAt`,
  `s4_payment_icons.media`.`updated_at` as `s4_payment_icons.media.updatedAt`,
  `s4_payment_icons.media.translation.title`,
  `s4_payment_icons.media.translation.title` as `s4_payment_icons.media.title`,
  `s4_payment_icons.media.translation.alt`,
  `s4_payment_icons.media.translation.alt` as `s4_payment_icons.media.alt`,
  `s4_payment_icons.media.translation.customFields`,
  `s4_payment_icons.media.translation.customFields` as `s4_payment_icons.media.customFields`,
  `s4_payment_icons`.`updated_at` as `s4_payment_icons.updatedAt`
FROM
  `s4_payment_icons`
  LEFT JOIN `media` `s4_payment_icons.media` ON `s4_payment_icons`.`media_id` = `s4_payment_icons.media`.`id`
  LEFT JOIN (
    SELECT
      `s4_payment_icons.media.translation`.`media_id`,
      `s4_payment_icons.media.translation`.`alt` as `s4_payment_icons.media.translation.alt`,
      `s4_payment_icons.media.translation`.`title` as `s4_payment_icons.media.translation.title`,
      `s4_payment_icons.media.translation`.`custom_fields` as `s4_payment_icons.media.translation.customFields`
    FROM
      `media_translation` `s4_payment_icons.media.translation`
    WHERE
      `s4_payment_icons.media.translation`.`language_id` = ?
  ) `s4_payment_icons.media.media_translation` ON `s4_payment_icons.media.media_translation`.`media_id` = `s4_payment_icons.media`.`id`
WHERE
  `s4_payment_icons`.`id` IN (?, ?, ?, ?, ?, ?, ?)

SELECT `s4_payment_icons`.`id` as `s4_payment_icons.id`, `s4_payment_icons`.`title` as `s4_payment_icons.title`, `s4_payment_icons`.`link` as `s4_payment_icons.link`, `s4_payment_icons`.`alt` as `s4_payment_icons.alt`, `s4_payment_icons`.`position` as `s4_payment_icons.position`, `s4_payment_icons`.`active` as `s4_payment_icons.active`, `s4_payment_icons`.`created_at` as `s4_payment_icons.createdAt`, `s4_payment_icons`.`media_id` as `s4_payment_icons.mediaId`, `s4_payment_icons.media`.`id` as `s4_payment_icons.media.id`, `s4_payment_icons.media`.`user_id` as `s4_payment_icons.media.userId`, `s4_payment_icons.media`.`media_folder_id` as `s4_payment_icons.media.mediaFolderId`, `s4_payment_icons.media`.`mime_type` as `s4_payment_icons.media.mimeType`, `s4_payment_icons.media`.`file_extension` as `s4_payment_icons.media.fileExtension`, `s4_payment_icons.media`.`uploaded_at` as `s4_payment_icons.media.uploadedAt`, `s4_payment_icons.media`.`file_name` as `s4_payment_icons.media.fileName`, `s4_payment_icons.media`.`file_size` as `s4_payment_icons.media.fileSize`, `s4_payment_icons.media`.`media_type` as `s4_payment_icons.media.mediaTypeRaw`, `s4_payment_icons.media`.`meta_data` as `s4_payment_icons.media.metaData`, `s4_payment_icons.media`.`config` as `s4_payment_icons.media.config`, `s4_payment_icons.media`.`path` as `s4_payment_icons.media.path`, `s4_payment_icons.media`.`private` as `s4_payment_icons.media.private`, `s4_payment_icons.media`.`thumbnails_ro` as `s4_payment_icons.media.thumbnailsRo`, `s4_payment_icons.media`.`file_hash` as `s4_payment_icons.media.fileHash`, `s4_payment_icons.media`.`created_at` as `s4_payment_icons.media.createdAt`, `s4_payment_icons.media`.`updated_at` as `s4_payment_icons.media.updatedAt`, `s4_payment_icons.media.translation.title`, `s4_payment_icons.media.translation.title` as `s4_payment_icons.media.title`, `s4_payment_icons.media.translation.alt`, `s4_payment_icons.media.translation.alt` as `s4_payment_icons.media.alt`, `s4_payment_icons.media.translation.customFields`, `s4_payment_icons.media.translation.customFields` as `s4_payment_icons.media.customFields`, `s4_payment_icons`.`updated_at` as `s4_payment_icons.updatedAt` FROM `s4_payment_icons` LEFT JOIN `media` `s4_payment_icons.media` ON `s4_payment_icons`.`media_id` = `s4_payment_icons.media`.`id` LEFT JOIN (SELECT `s4_payment_icons.media.translation`.`media_id`, `s4_payment_icons.media.translation`.`alt` as `s4_payment_icons.media.translation.alt`, `s4_payment_icons.media.translation`.`title` as `s4_payment_icons.media.translation.title`, `s4_payment_icons.media.translation`.`custom_fields` as `s4_payment_icons.media.translation.customFields` FROM `media_translation` `s4_payment_icons.media.translation` WHERE `s4_payment_icons.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `s4_payment_icons.media.media_translation` ON `s4_payment_icons.media.media_translation`.`media_id` = `s4_payment_icons.media`.`id` WHERE `s4_payment_icons`.`id` IN (0xEEB800CCEAD2455883460C118AB25276, 0x0D66730E553F4222BCFA01F3464AA64D, 0x8884EEAD688B4B1886F49BD41FD7C280, 0xAE77BCB099814A31A888F795CA5CC804, 0xA78FC19916564259927463760017E6B1, 0xAD3D7AE1C8C0419DA657CFE632A22F36, 0x53BB9E875EC0403B87C1A261A7AF4088);

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

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 (0x4A9217F95C68413EAA21544EC53E5482, 0x943F79F0E9DA46258B8491E5BAB9DAB7, 0xAFAF48C4C3C54EF1ACF5664EBB345D05, 0x0FA01B6273D64AE2BA85181D9005170A, 0x4712B0ABDE13450789672DACB7864A9C, 0x6B8DB4B5D42D4E8195C64073A3E6AA9C, 0x95C3D16C891F4ED68D06352D893B006D, 0xA1F3643482BE416DBD70ADD87D07CC44, 0xAB415488C86F4494803369C9E6E76AA1, 0xC1145F73D5C2450E97ACA5FA3D5F08AA, 0xF01A3CA4EA264CF78D1A52246AABFAC5);

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

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

# 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 = 0xC7B7F9F6CC1D4E0B8705FD682434397E OR sales_channel_id IS NULL)) AND ((seo_path_info = 'Spaces/Medical-facilities' OR seo_path_info = 'Spaces/Medical-facilities/'));

SELECT
  `s4_payment_icons`.`id`
FROM
  `s4_payment_icons`
WHERE
  (`s4_payment_icons`.`active` = ?)
ORDER BY
  `s4_payment_icons`.`position` ASC

SELECT `s4_payment_icons`.`id` FROM `s4_payment_icons` WHERE (`s4_payment_icons`.`active` = 1) ORDER BY `s4_payment_icons`.`position` ASC;

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

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0xC7B7F9F6CC1D4E0B8705FD682434397E) AND (token = '2CADSHmJryzeoJtuc1pitGx9RQ0MJzeR') LIMIT 1;

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` = 0xC7B7F9F6CC1D4E0B8705FD682434397E AND `sales_channel_country`.`country_id` = 0x265D775B6B904556921F52C65B3386DB);

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;

#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` = '2CADSHmJryzeoJtuc1pitGx9RQ0MJzeR';

SELECT
  path
FROM
  category
WHERE
  id = ?

SELECT path FROM category WHERE id = 0x1B0714CA79E4496CAE0022013BD2AD17;

# dbal-plugin-loader
SELECT
  `name`,
  `base_class` AS baseClass,
  IF(
    `active` = 1
    AND `installed_at` IS NOT NULL,
    1,
    0
  ) AS active,
  `path`,
  `version`,
  `autoload`,
  `managed_by_composer` AS managedByComposer,
  composer_name as composerName
FROM
  `plugin`
ORDER BY
  `installed_at`;

# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;;