Symfony Profiler

# cache-id-loader
SELECT 
  `value` 
FROM 
  app_config 
WHERE 
  `key` = : key

# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = 'cache-id';

# 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 
  `creation_timestamp` 
FROM 
  `migration` 
WHERE 
  `update` IS NOT NULL 
  AND `update_destructive` IS NULL

SELECT `creation_timestamp`
            FROM `migration`
            WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
        ;

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 
  @MIGRATION_1653402244_IS_ACTIVE = TRUE

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 @MIGRATION_1653402244_IS_ACTIVE = TRUE;

SELECT 
  CONCAT(
    TRIM(
      TRAILING '/' 
      FROM 
        domain.url
    ), 
    '/'
  ) `key`, 
  CONCAT(
    TRIM(
      TRAILING '/' 
      FROM 
        domain.url
    ), 
    '/'
  ) url, 
  LOWER(
    HEX(domain.id)
  ) id, 
  LOWER(
    HEX(sales_channel.id)
  ) salesChannelId, 
  LOWER(
    HEX(sales_channel.type_id)
  ) typeId, 
  LOWER(
    HEX(domain.snippet_set_id)
  ) snippetSetId, 
  LOWER(
    HEX(domain.currency_id)
  ) currencyId, 
  LOWER(
    HEX(domain.language_id)
  ) languageId, 
  LOWER(
    HEX(theme.id)
  ) themeId, 
  sales_channel.maintenance maintenance, 
  sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, 
  snippet_set.iso as locale, 
  theme.technical_name as themeName, 
  parentTheme.technical_name as parentThemeName 
FROM 
  sales_channel 
  INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id 
  LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id 
  INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id 
  LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id 
  LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id 
WHERE 
  (
    sales_channel.type_id = UNHEX(: typeId)
  ) 
  AND (sales_channel.active)

SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX('8a243080f92e4c719546314b577cf82b')) AND (sales_channel.active);

# seo-url::resolve
SELECT 
  id, 
  path_info pathInfo, 
  is_canonical isCanonical 
FROM 
  seo_url 
WHERE 
  (language_id = : language_id) 
  AND (
    (
      sales_channel_id = : sales_channel_id 
      OR sales_channel_id IS NULL
    )
  ) 
  AND (seo_path_info = : seoPath) 
ORDER BY 
  seo_path_info ASC, 
  sales_channel_id IS NULL ASC 
LIMIT 
  1

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = 0xB35D8497667842B1969D504ECEC3F4BA) AND ((sales_channel_id = 0x14B5F97A7F1943B7AC95474B425E8286 OR sales_channel_id IS NULL)) AND (seo_path_info = 'robots.txt') ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1;

SELECT 
  path_info pathInfo, 
  seo_path_info seoPathInfo 
FROM 
  seo_url 
WHERE 
  (language_id = : language_id) 
  AND (
    sales_channel_id = : sales_channel_id
  ) 
  AND (id != : id) 
  AND (path_info = : pathInfo) 
  AND (is_canonical = 1) 
LIMIT 
  1

SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0xB35D8497667842B1969D504ECEC3F4BA) AND (sales_channel_id = 0x14B5F97A7F1943B7AC95474B425E8286) AND (id != '') AND (path_info = '/robots.txt') AND (is_canonical = 1) LIMIT 1;

# system-config::load::search-ids
SELECT 
  `system_config`.`id` 
FROM 
  `system_config` 
WHERE 
  (
    `system_config`.`sales_channel_id` <=> : param_571cba5cb93042e590e5735d757d0866
  ) 
ORDER BY 
  `system_config`.`sales_channel_id` ASC, 
  `system_config`.`id` ASC 
LIMIT 
  500

# system-config::load::search-ids
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500;

# system-config::load::read
SELECT 
  `system_config`.`id` as `system_config.id`, 
  `system_config`.`configuration_key` as `system_config.configurationKey`, 
  `system_config`.`configuration_value` as `system_config.configurationValue`, 
  `system_config`.`sales_channel_id` as `system_config.salesChannelId`, 
  `system_config`.`created_at` as `system_config.createdAt`, 
  `system_config`.`updated_at` as `system_config.updatedAt` 
FROM 
  `system_config` 
WHERE 
  `system_config`.`id` IN (: ids)

# system-config::load::read
SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE `system_config`.`id` IN (0x00A127054F8B450A830E120302E55F10, 0x00E3362C82D6453885291A4EF6E1BC03, 0x0EF412D8460C479A88BA6CD011A9C511, 0x1630E3006C0B4DD6A2EFCB5133CB1D66, 0x16D1C47D4F4A4CA5BDC1A0F9D789EE36, 0x16E8BEA9C4734F5F8F3C4468160E841E, 0x180891F2C65848C4B280A0A6F09B7371, 0x2369D50D8FA24F85B57BEDD17F77D2C6, 0x256EE9D80A5E44479763EFFEB622AB08, 0x29D88B55D7A44403915E66D98ADB9007, 0x2A8D55E3B47A4EC5BF71BFADD04A1759, 0x2B089AEBC7B242109CCB2FF32513CA58, 0x33D9F821F11A43A5ADDBD200EF0DA4D6, 0x361A3C994885420BB143C47DDE46C67D, 0x3AA6064AEB5A4C5BA148874BD81CF8FD, 0x3B901E3DF44D4DD79A67C2901E7EAEB0, 0x3BE3A35E472D43C1B1BFC32DCEB889A1, 0x3D9F0A22C51C4CC5B4AA63AF4749246D, 0x433F67BCB11146ACB2F670A428869FDC, 0x4D4A4B04B2794C94888D6C2E60C3B444, 0x4F59240DAA9D498F8782B5874EE32BF7, 0x4FB064E50D0840C88F9494B2F5DCEC6C, 0x53D318064F584298AD3415616A65039B, 0x589E53901E13436F9436B5093358EE72, 0x65EE8B48CE67408BBFE2A3CA8C811577, 0x66621362E4F9426195787389A67767DB, 0x66C3075459A3456DA3F4742270A1BCA7, 0x71530007CC5D4DAEA5D36A5B0C692568, 0x7817D643DE164E9382368204D58AE0C6, 0x7882474153DE4BB7865687732AB7DEAE, 0x7B2610F42E5846FDA9A495DCE306CF8D, 0x7D20A9CE8CD247E4A26B9B5066C391B7, 0x7FF3D0D8FA674942838349C671035236, 0x812DAC3F4B99444EBF5883C58B0F4484, 0x81FFC237B17C473D987D2BBA6129D610, 0x82309D0E7CB04788AEB9FFB8C8BAB16A, 0x8A0A2E28A12840A89CF36016FDB41644, 0x8A1C87FEA17B49B0B4541EE6EAE79201, 0x8D1B9EF8C8054F46976CAC12E3B8F26A, 0x96119E3C6F9842698A86DB2E59F427C2, 0x9C0A399C99F34F78A8F16C45B8D92224, 0x9D692B8E36F94EA58EB5D21D98B7F96F, 0x9E3DF3FF8F2C40B9B8DAE03BEF69423A, 0xA4ECB8D57DA9465CB33692F4D08356CE, 0xB1EDF304442545C994D31A4223E29BFD, 0xD2A39D85C7EF4CBBB8FBE81DF7A099CF, 0xD95A90732C37408FA6D18FA9315CCFA6, 0xDA6B47F2596348FBBB62CD5AF879C762, 0xDDB07DC158F64FCBB96F32BACDCCB947, 0xDE928CF430CD446BAD9BF7E1BDEB4A6E, 0xDF00F1C44DF94F238DA590B13DBE70FF, 0xE25D18A2E7184139BF933AF109C71141, 0xE4350B22C8A94CADA550C7F2704B3910, 0xE5E5AA8EA108489987CFB917B2FBDA95, 0xEC5E91F0160B4895AB9E65AF4FFA7508, 0xF8A169B657834FA6A4791D64941817AB, 0xFA14D03511CB4A7B909FC6F2F512889B, 0xFEB38E2AEB714680851EE71B4AC44A6C);

# system-config::load::search-ids
SELECT 
  `system_config`.`id` 
FROM 
  `system_config` 
WHERE 
  (
    `system_config`.`sales_channel_id` <=> : param_b7f4f33a4ebb482e955c80bd38f416ea
  ) 
ORDER BY 
  `system_config`.`sales_channel_id` ASC, 
  `system_config`.`id` ASC 
LIMIT 
  500 OFFSET 500

# system-config::load::search-ids
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500;

SELECT 
  `plugin`.`id` as `plugin.id`, 
  `plugin`.`base_class` as `plugin.baseClass`, 
  `plugin`.`name` as `plugin.name`, 
  `plugin`.`composer_name` as `plugin.composerName`, 
  `plugin`.`autoload` as `plugin.autoload`, 
  `plugin`.`active` as `plugin.active`, 
  `plugin`.`managed_by_composer` as `plugin.managedByComposer`, 
  `plugin`.`path` as `plugin.path`, 
  `plugin`.`author` as `plugin.author`, 
  `plugin`.`copyright` as `plugin.copyright`, 
  `plugin`.`license` as `plugin.license`, 
  `plugin`.`version` as `plugin.version`, 
  `plugin`.`upgrade_version` as `plugin.upgradeVersion`, 
  `plugin`.`installed_at` as `plugin.installedAt`, 
  `plugin`.`upgraded_at` as `plugin.upgradedAt`, 
  `plugin`.`icon` as `plugin.iconRaw`, 
  `plugin`.`created_at` as `plugin.createdAt`, 
  `plugin`.`updated_at` as `plugin.updatedAt`, 
  `plugin.plugin_translation`.*, 
  COALESCE(
    `plugin.translation.label`, `plugin.translation.label`
  ) as `plugin.label`, 
  COALESCE(
    `plugin.translation.description`, 
    `plugin.translation.description`
  ) as `plugin.description`, 
  COALESCE(
    `plugin.translation.manufacturerLink`, 
    `plugin.translation.manufacturerLink`
  ) as `plugin.manufacturerLink`, 
  COALESCE(
    `plugin.translation.supportLink`, 
    `plugin.translation.supportLink`
  ) as `plugin.supportLink`, 
  COALESCE(
    `plugin.translation.changelog`, 
    `plugin.translation.changelog`
  ) as `plugin.changelog`, 
  COALESCE(
    `plugin.translation.customFields`, 
    `plugin.translation.customFields`
  ) as `plugin.customFields` 
FROM 
  `plugin` 
  LEFT JOIN (
    SELECT 
      `plugin.translation`.plugin_id, 
      `plugin.translation`.label as `plugin.translation.label`, 
      `plugin.translation`.description as `plugin.translation.description`, 
      `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, 
      `plugin.translation`.support_link as `plugin.translation.supportLink`, 
      `plugin.translation`.changelog as `plugin.translation.changelog`, 
      `plugin.translation`.custom_fields as `plugin.translation.customFields`, 
      `plugin.translation`.created_at as `plugin.translation.createdAt`, 
      `plugin.translation`.updated_at as `plugin.translation.updatedAt`, 
      `plugin.translation`.plugin_id as `plugin.translation.pluginId`, 
      `plugin.translation`.language_id as `plugin.translation.languageId` 
    FROM 
      `plugin_translation` `plugin.translation` 
    WHERE 
      `plugin.translation`.language_id = : languageId
  ) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` 
WHERE 
  (
    `plugin`.`active` <=> : param_e9f49ef2bf8a4217bf9bb94cf575edbb
  )

SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.plugin_translation`.*, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` <=> 0);