Symfony Profiler

# 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_1649858046_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1651118773_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654839361_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654839361_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654839361_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657173907_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1658786605_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659256999_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659257296_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659257396_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659257496_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663238480_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664512574_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664541794_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664894872_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1665064823_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1665267882_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667731399_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667806582_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667983492_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1668677456_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669316067_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1672164687_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1672743034_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1673001912_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1673966228_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675218708_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675827655_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1575569953_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1598204175_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624100471_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624108754_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635435811_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645716876_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659972444_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589892467_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594381360_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595336256_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603384890_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607529255_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609373668_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626331358_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646742586_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669129247_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1681716164_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1705588547_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 @@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_1649858046_IS_ACTIVE = TRUE;SET @MIGRATION_1651118773_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1657173907_IS_ACTIVE = TRUE;SET @MIGRATION_1658786605_IS_ACTIVE = TRUE;SET @MIGRATION_1659256999_IS_ACTIVE = TRUE;SET @MIGRATION_1659257296_IS_ACTIVE = TRUE;SET @MIGRATION_1659257396_IS_ACTIVE = TRUE;SET @MIGRATION_1659257496_IS_ACTIVE = TRUE;SET @MIGRATION_1663238480_IS_ACTIVE = TRUE;SET @MIGRATION_1664512574_IS_ACTIVE = TRUE;SET @MIGRATION_1664541794_IS_ACTIVE = TRUE;SET @MIGRATION_1664894872_IS_ACTIVE = TRUE;SET @MIGRATION_1665064823_IS_ACTIVE = TRUE;SET @MIGRATION_1665267882_IS_ACTIVE = TRUE;SET @MIGRATION_1667731399_IS_ACTIVE = TRUE;SET @MIGRATION_1667806582_IS_ACTIVE = TRUE;SET @MIGRATION_1667983492_IS_ACTIVE = TRUE;SET @MIGRATION_1668677456_IS_ACTIVE = TRUE;SET @MIGRATION_1669316067_IS_ACTIVE = TRUE;SET @MIGRATION_1672164687_IS_ACTIVE = TRUE;SET @MIGRATION_1672743034_IS_ACTIVE = TRUE;SET @MIGRATION_1673001912_IS_ACTIVE = TRUE;SET @MIGRATION_1673966228_IS_ACTIVE = TRUE;SET @MIGRATION_1675218708_IS_ACTIVE = TRUE;SET @MIGRATION_1675827655_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1624100471_IS_ACTIVE = TRUE;SET @MIGRATION_1624108754_IS_ACTIVE = TRUE;SET @MIGRATION_1635435811_IS_ACTIVE = TRUE;SET @MIGRATION_1645716876_IS_ACTIVE = TRUE;SET @MIGRATION_1659972444_IS_ACTIVE = TRUE;SET @MIGRATION_1589892467_IS_ACTIVE = TRUE;SET @MIGRATION_1594381360_IS_ACTIVE = TRUE;SET @MIGRATION_1595336256_IS_ACTIVE = TRUE;SET @MIGRATION_1603384890_IS_ACTIVE = TRUE;SET @MIGRATION_1607529255_IS_ACTIVE = TRUE;SET @MIGRATION_1609373668_IS_ACTIVE = TRUE;SET @MIGRATION_1626331358_IS_ACTIVE = TRUE;SET @MIGRATION_1646742586_IS_ACTIVE = TRUE;SET @MIGRATION_1669129247_IS_ACTIVE = TRUE;SET @MIGRATION_1681716164_IS_ACTIVE = TRUE;SET @MIGRATION_1705588547_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;

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 
  item_rounding 
FROM 
  currency 
WHERE 
  id = : id

SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;

SELECT 
  `app`.`name`, 
  `app`.`version`, 
  `app`.`template_load_priority` 
FROM 
  `app` 
  INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id` 
WHERE 
  `app`.`active` = 1 
  AND `app_template`.`active` = 1

SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1;

SELECT 
  `currency`.`id` as `currency.id`, 
  `currency`.`factor` as `currency.factor`, 
  `currency`.`symbol` as `currency.symbol`, 
  `currency`.`iso_code` as `currency.isoCode`, 
  `currency`.`position` as `currency.position`, 
  `currency`.`item_rounding` as `currency.itemRounding`, 
  `currency`.`total_rounding` as `currency.totalRounding`, 
  `currency`.`tax_free_from` as `currency.taxFreeFrom`, 
  `currency`.`created_at` as `currency.createdAt`, 
  `currency`.`updated_at` as `currency.updatedAt`, 
  `currency.translation.shortName`, 
  COALESCE(
    `currency.translation.shortName`, 
    `currency.translation.shortName`
  ) as `currency.shortName`, 
  `currency.translation.name`, 
  COALESCE(
    `currency.translation.name`, `currency.translation.name`
  ) as `currency.name`, 
  `currency.translation.customFields`, 
  COALESCE(
    `currency.translation.customFields`, 
    `currency.translation.customFields`
  ) as `currency.customFields`, 
  `currency.translation.createdAt`, 
  `currency.translation.updatedAt`, 
  `currency.translation.currencyId`, 
  `currency.translation.languageId` 
FROM 
  `currency` 
  LEFT JOIN (
    SELECT 
      `currency.translation`.currency_id, 
      `currency.translation`.short_name as `currency.translation.shortName`, 
      `currency.translation`.name as `currency.translation.name`, 
      `currency.translation`.custom_fields as `currency.translation.customFields`, 
      `currency.translation`.created_at as `currency.translation.createdAt`, 
      `currency.translation`.updated_at as `currency.translation.updatedAt`, 
      `currency.translation`.currency_id as `currency.translation.currencyId`, 
      `currency.translation`.language_id as `currency.translation.languageId` 
    FROM 
      `currency_translation` `currency.translation` 
    WHERE 
      `currency.translation`.language_id = : languageId
  ) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` 
WHERE 
  `currency`.`id` IN (: ids)

SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) as `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) as `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation`.currency_id, `currency.translation`.short_name as `currency.translation.shortName`, `currency.translation`.name as `currency.translation.name`, `currency.translation`.custom_fields as `currency.translation.customFields`, `currency.translation`.created_at as `currency.translation.createdAt`, `currency.translation`.updated_at as `currency.translation.updatedAt`, `currency.translation`.currency_id as `currency.translation.currencyId`, `currency.translation`.language_id as `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (0xB7D2554B0CE847CD82F3AC9BD1C0DFCA);