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 
  custom_entity.name, 
  custom_entity.fields 
FROM 
  custom_entity 
  LEFT JOIN app ON app.id = custom_entity.app_id 
WHERE 
  custom_entity.app_id IS NULL 
  OR app.active = 1

SELECT custom_entity.name, custom_entity.fields 
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE custom_entity.app_id IS NULL OR app.active = 1
            ;

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_1611155140_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646397836_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605167857_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1584005462_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589800641_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589800704_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589882802_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589905764_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1591365484_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626082072_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675420139_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_160198215_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1634025013_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663601206_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616141231_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631631689_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636082647_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1662306139_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1662757955_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663039410_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1676830357_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572257501_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616477404_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1554708925_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1575569953_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1598204175_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594488930_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1661505236_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1665435663_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1666859263_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1673945260_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_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1584005462_IS_ACTIVE = TRUE;SET @MIGRATION_1589800641_IS_ACTIVE = TRUE;SET @MIGRATION_1589800704_IS_ACTIVE = TRUE;SET @MIGRATION_1589882802_IS_ACTIVE = TRUE;SET @MIGRATION_1589905764_IS_ACTIVE = TRUE;SET @MIGRATION_1591365484_IS_ACTIVE = TRUE;SET @MIGRATION_1626082072_IS_ACTIVE = TRUE;SET @MIGRATION_1675420139_IS_ACTIVE = TRUE;SET @MIGRATION_160198215_IS_ACTIVE = TRUE;SET @MIGRATION_1634025013_IS_ACTIVE = TRUE;SET @MIGRATION_1663601206_IS_ACTIVE = TRUE;SET @MIGRATION_1616141231_IS_ACTIVE = TRUE;SET @MIGRATION_1631631689_IS_ACTIVE = TRUE;SET @MIGRATION_1636082647_IS_ACTIVE = TRUE;SET @MIGRATION_1662306139_IS_ACTIVE = TRUE;SET @MIGRATION_1662757955_IS_ACTIVE = TRUE;SET @MIGRATION_1663039410_IS_ACTIVE = TRUE;SET @MIGRATION_1676830357_IS_ACTIVE = TRUE;SET @MIGRATION_1572257501_IS_ACTIVE = TRUE;SET @MIGRATION_1616477404_IS_ACTIVE = TRUE;SET @MIGRATION_1554708925_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1594488930_IS_ACTIVE = TRUE;SET @MIGRATION_1661505236_IS_ACTIVE = TRUE;SET @MIGRATION_1665435663_IS_ACTIVE = TRUE;SET @MIGRATION_1666859263_IS_ACTIVE = TRUE;SET @MIGRATION_1673945260_IS_ACTIVE = TRUE;

SELECT 
  configuration_key, 
  configuration_value 
FROM 
  system_config 
WHERE 
  sales_channel_id IS NULL 
ORDER BY 
  sales_channel_id ASC

SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC;