Symfony Profiler

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_1572516630_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636553555_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_1572516630_IS_ACTIVE = TRUE;SET @MIGRATION_1636553555_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 = 0x2A2A2CE3EA06463EAF3DE1B534158D15) AND ((sales_channel_id = 0xFE5F0E866A0F4C138311D4EA515FDEC5 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 = 0x2A2A2CE3EA06463EAF3DE1B534158D15) AND (sales_channel_id = 0xFE5F0E866A0F4C138311D4EA515FDEC5) 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_482154c70db647ae8d8e1ec74458a332
  ) 
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 (0x00DCD7670E7A4028BB40F793058DAF50, 0x01205A2FF42244108781D8F30EF6E980, 0x01288EE3597F497A9554252BA86EA1D3, 0x015091E5E44E418386AB70562753C581, 0x01C9A70F4994424EAF12C04299C796A1, 0x04350AC4DF734D33B1A57B5F2224282B, 0x046CF5110B324212A373ED47E29193DC, 0x08B6A2BA975B402CAD6BBAD6DFC2BA65, 0x0CF716B29517480AB0B17A4EFEDC1D92, 0x0FCED287AC2744A7B765B39EF411DBC2, 0x10D107F185F5475E808CB7E84AE1A272, 0x13FB83906091413397EAC10239FFE06E, 0x148726E30729443F87C9824396DC980A, 0x14A8C22386D748E793E6A6CBD78109F6, 0x14C8ECD179F047B7BC1373A7CC3731FD, 0x15B18AF0A370415DBCC71B124A905BA3, 0x1DA2E10D07044A38881BDB6CC49F822C, 0x22C319D1E06F4E73B6BCAFAABFF64473, 0x2880E2BCDF7F457EBA794E7A1029BD6A, 0x3502BBED8E744FABA5B19E684D5CC5EF, 0x3A0BDF7D000A4A2BB8F29BB016100EE0, 0x3ADCA8320B4C4338A30ED045AC6A98A2, 0x3DAED75AB9CD42819C7D2F0584D382CA, 0x4047865AA7F84016A868C19E2E3FC6CD, 0x42E2717B95EC4B3192F6C9E14097EBB4, 0x445A7C62232F4F50854CE59FA6052F5B, 0x4B524886FB9F4CD5B17652240F441FDC, 0x4C42080B90DC4C609CE03C6A4983DB75, 0x4D156FB681154ED4BDFE39B598CF351E, 0x4D7C666E10B649E3B1836F5DC48312F6, 0x524454451C3C4D8290F1CF728BEA57A9, 0x5948A0B039B449178720F898C22BCF7E, 0x5AE0E614850A419ABD3061F14EDEC935, 0x5BECBA0DB6A9487D99296C529C40E33F, 0x5F04B3C4A0114407AA53A1A77F318B20, 0x607C2FB23FA14EF48869D09EEA313D9E, 0x632023A68B7A486E8A779D53BCB59778, 0x6921D9E687904A2FA96F2099ACD6E1CD, 0x6CB0BCF964124F7896BAD92C3C23B603, 0x6E68DB46D41C48008996D8058C7D6107, 0x708BA09450B24E8DA20B09F487B2856E, 0x712AD6D90B55485D89505D3320214395, 0x725DC7B516B747959A80951B7830EA2E, 0x75F7D7DC5086497D9489669CD4E9FFBB, 0x7C1071F64F4540548F75C5630CBB45DD, 0x805D18A3305D4C898F5AC422A4B62D44, 0x8303230B2BEC4636B698A50B51FF10E4, 0x87A6E3B36BA0411880E1EB8DE9CD2B67, 0x883801A28050469EB282A649D310DF9B, 0x8AFD33903CFD4D4CB19D6ED46F13BECE, 0x93858CA5FAAF489CAEFE21E42D0313D9, 0x97FF544C6E1D453B85270E2FC69E0107, 0x9A7AF7BB4E1F48E8B1F0828AAEA9BF42, 0x9D5E6A4D3BBB49A0BD2A0B714E0BA248, 0xA014BB2991E548C68758C55AC1529364, 0xA0C0381FF28D4FD69F815823C8220479, 0xAB3BB3A557784B15808E292852CFDEE7, 0xAB6393029DDD4B758D1388510F2CA548, 0xAF72AD88E14C4D02A7EF89ED2C0D2BFC, 0xB27D27D961C64D5D9C5C788F4963CA73, 0xB2A3EE963B954D7CA8AA24BDBD203AFA, 0xB413B4D2A97B4DAD8E9E458F68D7C000, 0xB91EED157FD845F983E97000B350D73C, 0xC163D421F1574034B021E1ABEE41CE48, 0xC2BD58FAC903436B84DCCD751D262211, 0xC50997B1B3A642ACBF20FF3138376EA2, 0xC956950FA4464B5FBE8F5DB8B69863FB, 0xCFC4648D546A4ABDAD931BB4121DB537, 0xD205AAA5F52D42A9A4654719E6D80418, 0xD3FF132E489F45EAA6FA186A4028AD52, 0xD781F4BBA6104E968FA9B99951C3F4BC, 0xD9686AB4F6494DEA93AA2AF48588E039, 0xDCB67214B303426DAE0736F19B254E95, 0xDF9BC25C7B0046D7AC7204B92BBC4100, 0xE371123989054E83AF2CDC217ACEC25E, 0xE4ED3CF5CC3E4036B21186DAA4D7B0BF, 0xE81FCEEE3ADD4B129DA91A1319B13DEA, 0xED825CA61EBF4BB495977B0756D9DA3D, 0xEDF5E4A6AA4C4B33AFE3ABA36C51DA5E, 0xEE57EE2056B047F28EB89ED7CCD85177, 0xEEAF669B7F0649DEBA3796E8D46F1715, 0xEFD9D5A5F91C46E985FAE6FC95583ACE, 0xF8FDB08C0C444A809887E52CA6192C64, 0xFD8741CDC829408CA1B6990418BADDDF, 0xFE490AFB11E44EA9BB1AE18D224D5DF7, 0xFED98B6657794D96BCE1D1C11EFB18D7);

# system-config::load::search-ids
SELECT 
  `system_config`.`id` 
FROM 
  `system_config` 
WHERE 
  (
    `system_config`.`sales_channel_id` <=> : param_b78491dfd64542298ef260e61e347b27
  ) 
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.translation.label`, 
  COALESCE(
    `plugin.translation.label`, `plugin.translation.label`
  ) as `plugin.label`, 
  `plugin.translation.description`, 
  COALESCE(
    `plugin.translation.description`, 
    `plugin.translation.description`
  ) as `plugin.description`, 
  `plugin.translation.manufacturerLink`, 
  COALESCE(
    `plugin.translation.manufacturerLink`, 
    `plugin.translation.manufacturerLink`
  ) as `plugin.manufacturerLink`, 
  `plugin.translation.supportLink`, 
  COALESCE(
    `plugin.translation.supportLink`, 
    `plugin.translation.supportLink`
  ) as `plugin.supportLink`, 
  `plugin.translation.changelog`, 
  COALESCE(
    `plugin.translation.changelog`, 
    `plugin.translation.changelog`
  ) as `plugin.changelog`, 
  `plugin.translation.customFields`, 
  COALESCE(
    `plugin.translation.customFields`, 
    `plugin.translation.customFields`
  ) as `plugin.customFields`, 
  `plugin.translation.createdAt`, 
  `plugin.translation.updatedAt`, 
  `plugin.translation.pluginId`, 
  `plugin.translation.languageId` 
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_317ecc08c66641ccb0b0d3d9ef8274bd
  )

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.translation.label`, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, `plugin.translation.description`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, `plugin.translation.manufacturerLink`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, `plugin.translation.supportLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, `plugin.translation.changelog`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, `plugin.translation.customFields`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields`, `plugin.translation.createdAt`, `plugin.translation.updatedAt`, `plugin.translation.pluginId`, `plugin.translation.languageId` 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);