Symfony Profiler

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 (0x481DEB3EC7D04114BCDA7F245CBE14C5));

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

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

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

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

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

# 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/52d7d49d9b0b4386bfa2314e0eecee59', '/navigation/d06b5c68999a4346bc01e2a63273a57e', '/navigation/45b5981d3e2441139b5a553a4276492c', '/navigation/1dbc7b3c1b0e457e87aaab93da51f1f2', '/navigation/7c4fd551df154ab5a4a73da47b3dfa2c', '/navigation/df7df0d01dfe4e209e624eca2cfb51da', '/navigation/f9d486351b634f4fa21efc5be513076b', '/navigation/8e5270e2483d45da86297c26bc5902a2', '/navigation/b65743695fb643b19b95d67e9583c167', '/navigation/eab84563e99149eea0b7c873194bfda4', '/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/ad88fbd83e6143da95affdc5a387f6fa', '/navigation/947f8dbe945540c5ac9f5523caf7b27a', '/navigation/91579a2dad724147b0708299077d9b71', '/navigation/f72d98bab206474a93ead67e6df5123b', '/navigation/0dcc780a475542bbb6d1d46427d9e4f9', '/navigation/2836102dd05c4ff0bbbfa0eb545aea11', '/navigation/675ae359023546ea904e4028ffefa7e1', '/navigation/b0dcf7d23d044e8d961ac62607aed30b', '/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/02e7a556cb0241db81a44f3be9c7e42a', '/detail/3d732e8437944c569810c92ba78a4f16', '/detail/3d79148d7c3f48e1863dc52eda793767', '/detail/763e32d29674427abdace34f088688eb', '/detail/29f32d712aec478fadffb02e13dade09', '/detail/9a02fed7a531410883cab3bfed1a716e', '/detail/bf591e7753aa4bb78188c149b3c5efdf', '/detail/33bd1c86c4da49a4ad82a8a95c892d83', '/detail/71aaf6913b5345dabebffa54a894a9a8', '/detail/746d612f6cfc42059d14ddac528beda4', '/detail/d55534e086f140099b7036be2981e17d', '/detail/e340a908cf3142bfa3c9a2fb8da173ed', '/detail/5ffc9bfe225c45d88d4a9aea4d575be6', '/detail/68ed9dbe4d724ecbb825c5d40b12073e', '/detail/725462ae666d43c586e18fa3aaa37e3e', '/detail/a1b869fea9974526aa5dd08819af1d7a', '/detail/05f74dd56f5d4d34825b18a036445c97', '/detail/999ce085cc1241d3a130f2280da37aea', '/detail/a5fbba6e39264fc59121872fee347496', '/detail/f155654a28f74472a209fba4aea4002c', '/detail/fcde0caaaf494d279cb69c164abd949e', '/detail/fcfa289fc1a645c78fd3867f7b6e344f', '/detail/792cc417c92447458c7ab45dab092025', '/detail/79da8aca8eb04e58861f314d2f8665e5', '/detail/a8b78d795cee4d0ab797555b1c853353', '/detail/ae8f82c4cb4c4a6cbfb1f32446de6505', '/detail/b0b63e47e3834689a7cbfc5346ac4296', '/detail/b8fea62c589f435fb8b9cb928ace54a8', '/detail/cefd196b0f5749cbb311c4130908b4f5', '/detail/0c995c299be04b2c8354404d279e721c', '/detail/146e87a8f76f478387751ff928f6db6d', '/detail/5161080e5c6c4df69645ce06d23fdf6e', '/detail/c53613820fb146308db3252d3e832205', '/detail/44b95341d3ba4a579c292dce8f2b1b84', '/detail/5967954e06e14b4f8a072e4fe90c1301', '/detail/9d1e45ec3f664104b58de2ea648d2d40', '/detail/c2b6d885a52a4b58a59dbf0081a47ca8', '/detail/dd1e4388f3754a48b9a291698d493244', '/detail/27fd6848e620434c8d2e5631d71021cd', '/detail/97a62398e52249dcb97b76aede59cf21', '/detail/9e8e32b643564da4a6905d5ac6d51888', '/detail/a3200612f755430fa41f05230b742440', '/detail/d45c7e92d33c4fa4aa072bf7503f070e', '/detail/24c2c052c62541c695a556535b2165ea', '/detail/8c971da9e9f54b65a1170e2c89191998', '/detail/8dc40de081214c978fdb2e6cc88a412c', '/detail/e246bfce2f6c4c95b6bce37657803700', '/detail/5964b036335d436b8421ceac3d6f1b4f', '/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/999f52ef61324e18a57253b60bd41217', '/detail/bcabc9d10bf14f429ddc056e1e68f0e5', '/detail/e51976a0292f4edd9c339ca74e08a50f', '/detail/abfda18098b74347ab6709582837cd50', '/detail/34238f4d188c472eb5ce29d8348e0d9b', '/detail/909f91c262a944bc901638decc05887e', '/detail/bb4346f7cbac47b092fcf515b27c1dd0', '/detail/ed267503f36e4e3fbdb55f728d9c8b3e', '/detail/196f5ea23b404553bff5d48d75d09a9e', '/detail/5329ab65860948ba9846480037f09aa6', '/detail/8fcff2ed6776416cb64ec7b0bff8b96d', '/detail/3977bcb20b7b4a7eb6120e61f96f35c0', '/detail/479bc8ea7a2c4f939604027efe8b597a', '/detail/532ef70a62b34f4f8457249f950d4a0f', '/detail/895a0bca19f943b2b9464f4dd3b03114', '/detail/943fe5e31bbe45b08b2e0b9d8a392ea1', '/detail/bb39ff866a9240c99bebc1e646bce928', '/detail/e5be1f00fc8241b6bb6549432ca3ba89', '/detail/e04c858a3c0b43ee9075c91711401338', '/detail/5f85ba93047f49d0bacf8fef492e3a4c', '/detail/6db72ac5b09c44df8128b732b21cc78f', '/detail/9e09ef41298e40cf82d6de2e3745ab92', '/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
  `app`.`name`,
  `app`.`version`,
  `app`.`template_load_priority`
FROM
  `app`
  INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
WHERE
  `app`.`active` = 1
  AND `app_template`.`active` = 1

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

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

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

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
  *
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 = '6sZZkvvvIv3q2gwjjBZluZxj1rZe5Mhc') LIMIT 1;

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

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

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 = 'Furniture/Shelves' OR seo_path_info = 'Furniture/Shelves/'));

SELECT
  path
FROM
  category
WHERE
  id = ?

SELECT path FROM category WHERE id = 0x52D7D49D9B0B4386BFA2314E0EECEE59;