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_1582718994_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586345021_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586345049_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586345063_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1587126585_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_1582718994_IS_ACTIVE = TRUE;SET @MIGRATION_1586345021_IS_ACTIVE = TRUE;SET @MIGRATION_1586345049_IS_ACTIVE = TRUE;SET @MIGRATION_1586345063_IS_ACTIVE = TRUE;SET @MIGRATION_1587126585_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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0xDD0A402C343F4561A6A2100CD5D17F74 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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (sales_channel_id = 0xDD0A402C343F4561A6A2100CD5D17F74) 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_bc351de534d7494ca333dc00ecfa1025
  ) 
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 (0x03E536C5931B473795C2CBFE8AF2F907, 0x041133ADB27748B6A4B3FEBAC3D66F31, 0x04DD0A6715934E62B399EF5D128561D8, 0x0D4ED48B80F74B819D8AB3F8FEBCF996, 0x0D83DF985EB8482DAE59C33A1E3E9761, 0x190A700477AF48A1ADC0ADDF5D171418, 0x1AC621E394CA40049C09BDEFE900FBD9, 0x1C62A900F42E44B2AE72A0065CCB98DF, 0x288ACD05FD914E8BA4909DC6E313BC44, 0x2CE8E030138548409ECD0725033DC0D4, 0x2D48B8FDAA7E4939BB617E315036A45E, 0x300D581083094959BC2AB355FD3A5D90, 0x3AFD0A673F7F451284844C949C532A75, 0x3BEF1F38347F4E06B30A0A9A87557692, 0x479BD8AEB4584811B1D256902CF73E48, 0x5D7140569D3D4CC49B591416E8C250D1, 0x5F86EB19C0434A558895E2BB191EC44B, 0x60DEE06D47A7409B8C7D3C08B06682F5, 0x69B724069AAB4A838BAE205942D1698F, 0x6BDCD439B4FB4ABAA04ED01A7E77276A, 0x6DA0C116EC3749B0B5CC07F234AF7A86, 0x72CBDA0BCE2041E68B1DD1567A6BCF94, 0x7DD3BC1DAB7F44D8B26CAC8A54FC286D, 0x7E3CAA5D8F8D4EDF9A56D80A8AD41EE0, 0x84F74E2312EB4420BA0B425E0BD17F72, 0x87C1B7C621274C8987F7A783775A7C62, 0x8A54ED16231E4132822D0F3C343D953C, 0x900DEA0AD7454B7585BD473A85113004, 0x936A2FA43C374EA3BE9BDB46AF8DBECA, 0x937FCF51FBD64782BB8F847D248BC58B, 0x95614BAF45324C3F91641D0B89835EA6, 0x991E42C8C57B45E48C42D8AFB58449DD, 0x9EA0F7FEF5AA4812A13043A982B04AEF, 0xA1B9091B90C7492DA4B8192E624C1751, 0xA1CDD1A1EC8848C4A03F01924E2018AE, 0xA94BB66394FE49C8B0F9ED85A98D38B9, 0xB3CAF94B32804DC7A3EE0E62683AA43C, 0xB4675736996E42A9B73E046CD81F557E, 0xB5F2D399FD86488CBE1A3F13ABA3D91E, 0xB5F937246A384AD1AD79E2EC061FCF68, 0xB862C1BC7C554DFAA3081B8922FAF9E5, 0xB96AE36AEB1E484D9EF7724219D1E6EE, 0xBD8ACEA24B2B4EBBB5049561A96770F6, 0xC6B52484630F42259AFECD4BDCA827F8, 0xCAF45FB0904046C6BC3ED3D00FDEBB5A, 0xCB9C4834FEF04681A7BE0B7A2636AE67, 0xD56526AD66D94775863E35F61D974B93, 0xDD23E3C9140C4E5A881831B4053E4873, 0xDD977C7C5A2242AF8A800FF572325949, 0xE09DCBA665254618A5602A323966CAC5, 0xE92D892B8104426BA0FEDF0DE6C8A3F9, 0xF00C086BE597491390C8E26515355C66, 0xF0F86E1080D34F79AD5A0F556953D693, 0xFA139E8785F8482E8CB254C0FA8A89F5, 0xFD05DF3E77E741348180487792BA1B57, 0xFD5980506ED94326AD01A8CCBC0424E6, 0xFE40DBFC5D454C53B53EFC543FB6EE49, 0xFF86C579BD814AA5B907D7015189C516);

# system-config::load::search-ids
SELECT 
  `system_config`.`id` 
FROM 
  `system_config` 
WHERE 
  (
    `system_config`.`sales_channel_id` <=> : param_784608e426c3423bb2293ac7d004d9a2
  ) 
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_c71146b7e9574130b9eadce73e71cb35
  )

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