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_1620306767_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620308350_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1613492839_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1613493472_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1613496348_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621510875_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622207125_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631691913_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1633948279_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1637145145_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667481867_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1677064840_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1677078498_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1679046988_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657615865_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660643832_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1644753635_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652444730_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669117848_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669796049_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1678106061_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_1606378923_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607952506_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608034991_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612945522_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620808652_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631192197_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1677050041_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1690444895_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1554708925_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604593154_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616299405_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619537490_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1651208032_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663787515_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_1620306767_IS_ACTIVE = TRUE;SET @MIGRATION_1620308350_IS_ACTIVE = TRUE;SET @MIGRATION_1613492839_IS_ACTIVE = TRUE;SET @MIGRATION_1613493472_IS_ACTIVE = TRUE;SET @MIGRATION_1613496348_IS_ACTIVE = TRUE;SET @MIGRATION_1621510875_IS_ACTIVE = TRUE;SET @MIGRATION_1622207125_IS_ACTIVE = TRUE;SET @MIGRATION_1631691913_IS_ACTIVE = TRUE;SET @MIGRATION_1633948279_IS_ACTIVE = TRUE;SET @MIGRATION_1637145145_IS_ACTIVE = TRUE;SET @MIGRATION_1667481867_IS_ACTIVE = TRUE;SET @MIGRATION_1677064840_IS_ACTIVE = TRUE;SET @MIGRATION_1677078498_IS_ACTIVE = TRUE;SET @MIGRATION_1679046988_IS_ACTIVE = TRUE;SET @MIGRATION_1657615865_IS_ACTIVE = TRUE;SET @MIGRATION_1660643832_IS_ACTIVE = TRUE;SET @MIGRATION_1644753635_IS_ACTIVE = TRUE;SET @MIGRATION_1652444730_IS_ACTIVE = TRUE;SET @MIGRATION_1669117848_IS_ACTIVE = TRUE;SET @MIGRATION_1669796049_IS_ACTIVE = TRUE;SET @MIGRATION_1678106061_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_1606378923_IS_ACTIVE = TRUE;SET @MIGRATION_1607952506_IS_ACTIVE = TRUE;SET @MIGRATION_1608034991_IS_ACTIVE = TRUE;SET @MIGRATION_1612945522_IS_ACTIVE = TRUE;SET @MIGRATION_1620808652_IS_ACTIVE = TRUE;SET @MIGRATION_1631192197_IS_ACTIVE = TRUE;SET @MIGRATION_1677050041_IS_ACTIVE = TRUE;SET @MIGRATION_1690444895_IS_ACTIVE = TRUE;SET @MIGRATION_1554708925_IS_ACTIVE = TRUE;SET @MIGRATION_1604593154_IS_ACTIVE = TRUE;SET @MIGRATION_1616299405_IS_ACTIVE = TRUE;SET @MIGRATION_1619537490_IS_ACTIVE = TRUE;SET @MIGRATION_1651208032_IS_ACTIVE = TRUE;SET @MIGRATION_1663787515_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;

SELECT 
  configuration_key, 
  configuration_value 
FROM 
  system_config 
WHERE 
  (
    sales_channel_id IS NULL 
    OR sales_channel_id = : salesChannelId
  ) 
  AND (configuration_key LIKE : prefix) 
ORDER BY 
  sales_channel_id ASC

SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = NULL) AND (configuration_key LIKE 'MolliePayments.config.%') ORDER BY sales_channel_id ASC;