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/ad88fbd83e6143da95affdc5a387f6fa', '/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/1b0714ca79e4496cae0022013bd2ad17', '/navigation/5243b4c4c3cb414785b33b0badf2b5e9', '/navigation/8561c09d079043909819996b869ca219', '/navigation/297d29069baf4792b58dd663bed97961', '/navigation/947f8dbe945540c5ac9f5523caf7b27a', '/navigation/91579a2dad724147b0708299077d9b71', '/navigation/f72d98bab206474a93ead67e6df5123b', '/navigation/0dcc780a475542bbb6d1d46427d9e4f9', '/navigation/2836102dd05c4ff0bbbfa0eb545aea11', '/navigation/675ae359023546ea904e4028ffefa7e1', '/navigation/b0dcf7d23d044e8d961ac62607aed30b', '/detail/03f79e1b0c0a43b391d750e71eda1422', '/detail/0affefaee2a04081bafc63b07d509323', '/detail/1efb062b8e594429a80a9ccee270ecd6', '/detail/26b62c9d54714036a14f3b139f6fb916', '/detail/2c93126f36a64f96bcbceab4cbad11c8', '/detail/3219588ab7994edf9aa401737e270fa9', '/detail/520cc15abd7f45978bfc6ce3b06c69a6', '/detail/59e6dc1dfa6043c8a8aaad9204116602', '/detail/6d73f94356c947a58eb5cfda94b7d9e7', '/detail/8304d51619ad4b66a23565e6c4acc248', '/detail/9722183fd79e459ca536831ee1455f17', '/detail/c3ca5714eba24ed38d57b11e3aaa78fa', '/detail/eaee1c17139f4aafb222d123656fe7d0', '/detail/f99bd534c0c346cd97a6c1c5104dd2ca', '/detail/0baf6b09c42b4f38aa2278334ef22cf0', '/detail/155a8092724c4079a482984c0a6ce550', '/detail/21822814b1804072ae561b919bf5440c', '/detail/34619590e731462992d1f11a49e5d3c0', '/detail/5caeccceee9d44a9a6806a8648104e75', '/detail/5d468f614e6046a9ab4fbf7a9c9b99e0', '/detail/6038e39af3ed4483b424b603574eef18', '/detail/6ba3c4cc0d1d4ff6b59d03e82a6a8b34', '/detail/a9da592ce5634bdaa0911862f6e261a2', '/detail/ad63c115b7ac4896abe606ffce3e00a6', '/detail/ceeb1f9e8082402585260bb349907473', '/detail/d40882002cb54bec9a0d3d6d53a912d9', '/detail/d745e9104df64b2fa76f501b95bea6b5', '/detail/f6ced1a329a64374ade176d74e4802bc', '/detail/583f243fbb8a4cd18372e8c61a16a745', '/detail/b2aa099493c74d979c27ef765901c419', '/detail/c4a75a475de54b7fa6468ad821de4772', '/detail/f3ac03c7835140e789a23323cfe3206d', '/detail/197e59b18f2643f88c831622eac229ac', '/detail/1b7cc58650bb41a1b6f5d04ecea53b73', '/detail/259ea5f614ff4e4b9b4c71cc229327e7', '/detail/3293db398d064a9180670ea6caa128b0', '/detail/3c3c09db103f4e0388b0b1e833364e1a', '/detail/406a51a7606d4e2d9ab3d37121e34cd3', '/detail/4b5dd62fae6043ee8b4d4f2f72180c84', '/detail/5c22b5a8dd294bd4988e94ba01a1b713', '/detail/a509250db25643489b4e5e3869854e03', '/detail/bf1f800de1dc4fdaad750cb5ca93cf1f', '/detail/0312c6b8ac7d4f6f85793c426dd4939c', '/detail/0da8f2d3a81e436e808dbd17dd71ded6', '/detail/180956e9f5184c11ac74417cb365a7f3', '/detail/2fb5ec1f799a493ebbb64199ba78ce7d', '/detail/41ff3d6f493549bb8ce87f026f9749b4', '/detail/69ef382361bd429092ae9eb673a694c2', '/detail/827ed1a917064aab9818770329b1db22', '/detail/962494da52f94f8086a508f0c586c480', '/detail/c42753dba73444a2bceaf599ad5c145f', '/detail/c5c3c9117fed4d3c9fdd1ce81ff8de86', '/detail/c935999339104797828b689bcd2956ea', '/detail/d2cae58f49ac48729b5c670a8194df8b', '/detail/db1bf2302dfa4548a6220317407040fc', '/detail/e9bfefdd5ac042c28f6c2785a96bc54b', '/detail/f2463a043a934571bfd8aae047eb1df7', '/detail/098fea42b75d41168d60b254ad261453', '/detail/18569f00c9e34d41bca746088cf00d45', '/detail/69245c45d6a64d80975ad84a1246abda', '/detail/723195705ed843bba5205b650c14f20d', '/detail/192f944e29b4465c86e048fdb3a43c85', '/detail/792cc417c92447458c7ab45dab092025', '/detail/79da8aca8eb04e58861f314d2f8665e5', '/detail/a8b78d795cee4d0ab797555b1c853353', '/detail/ae8f82c4cb4c4a6cbfb1f32446de6505', '/detail/b0b63e47e3834689a7cbfc5346ac4296', '/detail/b8fea62c589f435fb8b9cb928ace54a8', '/detail/cefd196b0f5749cbb311c4130908b4f5', '/detail/0f44ce58e3d84780b5e0260085435e99', '/detail/1f904ecc6b7d49048a08fba155aa1e8a', '/detail/2063d12d0a324d04aac586b1927b0d2f', '/detail/328b343818cd405dbebfee1c739e652e', '/detail/3f46c66712db49cb8bbe81ecb4fffc85', '/detail/4fdfd568cd614d8497c9c27202547af1', '/detail/57b218c44ca145ed9aef00b54c3dc63c', '/detail/5a47600f922541a1915468de0040d7d8', '/detail/850aa0d06f7840de8806d18c76321cdf', '/detail/a41f83fea1a14274a2eb44554ae4292b', '/detail/aa94358db22a4bbbba4903f82cfc9e9a', '/detail/ac9cc43995d742ee936c311e80ad541f', '/detail/cc23e28325d44021b0b07980e2be4ddd', '/detail/d10662885f054b07bd2ef6255cd15cf0', '/detail/01563112a5394f0b91c2e0113ab6470e', '/detail/2955d1cb652a45dfa84f8d8b766d7a76', '/detail/47778e73cd5c4c308e8516bf7a2985bd', '/detail/4b79835b710e4a6db08219a7c5729ea4', '/detail/559b1d3407924a3bb48709165af06cd7', '/detail/601f6a675c2c4ae0817f68c3c44734e7', '/detail/6d5f0aa0002c4bc7865d6e65024ad4fd', '/detail/722b90355eab4777bd28c63a34cea707', '/detail/7529df7209934b25b505f80dda5fa54c', '/detail/80ac6281b2b24591867966d4d4346114', '/detail/96535164f1154c1cb2e8ba99ddf683c7', '/detail/9e1f7cbc3a4e41c595e76095abd20cea', '/detail/a0cee2a980a642b78e85d430f3baeff0', '/detail/c37252aa40734f9fa2b01427c518a12d', '/detail/1b1a1b25327a4dfe9c8f5836810326ee', '/detail/1f99d6ab20ac40e8baf5f0a92f8f3f3d', '/detail/4143e70f8aa544f0af7488a2d1f27ec9', '/detail/42bfb412247545848715b858b8118085', '/detail/5089c7d6290741d38d41b4106d4c0cdd', '/detail/5c8b61a62d9f4c6a90359990d407613c', '/detail/6558192e688e489d9e5d6d19d2c21450', '/detail/6ed0dc8f035c442eb7221f2e3dcd78ca', '/detail/75d0f97305774b7a80624c93d2784d3e', '/detail/7dfe7f08a1034230950cee7d379912a7', '/detail/9c30bd2030214d8b92c9811792e1f935', '/detail/9f52d96a009247468b4d1953ff4cb45b', '/detail/d621113c11cb4aec87f481dff3746505', '/detail/f692731749684807bbfb91e08ec5cecb', '/detail/3977bcb20b7b4a7eb6120e61f96f35c0', '/detail/479bc8ea7a2c4f939604027efe8b597a', '/detail/532ef70a62b34f4f8457249f950d4a0f', '/detail/895a0bca19f943b2b9464f4dd3b03114', '/detail/943fe5e31bbe45b08b2e0b9d8a392ea1', '/detail/bb39ff866a9240c99bebc1e646bce928', '/detail/e5be1f00fc8241b6bb6549432ca3ba89', '/detail/e04c858a3c0b43ee9075c91711401338', '/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 (0xC609EBE751684E8E922EFD88A1850B67));

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
  `key`,
  `value`
FROM
  `app_config`

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

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

# 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 = 'Inspiration/Welcome-Home' OR seo_path_info = 'Inspiration/Welcome-Home/'));

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, 0x4712B0ABDE13450789672DACB7864A9C, 0x6B8DB4B5D42D4E8195C64073A3E6AA9C, 0x95C3D16C891F4ED68D06352D893B006D, 0xA1F3643482BE416DBD70ADD87D07CC44, 0xAB415488C86F4494803369C9E6E76AA1, 0xC1145F73D5C2450E97ACA5FA3D5F08AA, 0xF01A3CA4EA264CF78D1A52246AABFAC5);

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 = 'N1kWEp0MhgrTqKsmnOfcoZ97L8tpIiaL') LIMIT 1;

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

# 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`;;

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

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

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

SELECT
  path
FROM
  category
WHERE
  id = ?

SELECT path FROM category WHERE id = 0xAD88FBD83E6143DA95AFFDC5A387F6FA;