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_1652441129_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653376989_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653385302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656928097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657011337_IS_ACTIVE = TRUE; 
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 
  @MIGRATION_1625566312_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059645_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059646_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059647_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059648_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059650_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059651_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1565933910_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568640060_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568640070_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568640076_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580300846_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582119202_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582281362_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583477457_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583486528_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583486534_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583489755_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583489757_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583737095_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1588252518_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594288127_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594373672_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594727519_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583737095_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602060888_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602675838_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609233961_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1579114486_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622461524_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1623052558_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632158551_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1634759880_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1637341838_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1640548412_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645557087_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645882069_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647778651_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648822579_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572257501_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616477404_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592415758_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647181771_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_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;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 @MIGRATION_1625566312_IS_ACTIVE = TRUE;SET @MIGRATION_1564059645_IS_ACTIVE = TRUE;SET @MIGRATION_1564059646_IS_ACTIVE = TRUE;SET @MIGRATION_1564059647_IS_ACTIVE = TRUE;SET @MIGRATION_1564059648_IS_ACTIVE = TRUE;SET @MIGRATION_1564059650_IS_ACTIVE = TRUE;SET @MIGRATION_1564059651_IS_ACTIVE = TRUE;SET @MIGRATION_1565933910_IS_ACTIVE = TRUE;SET @MIGRATION_1568640060_IS_ACTIVE = TRUE;SET @MIGRATION_1568640070_IS_ACTIVE = TRUE;SET @MIGRATION_1568640076_IS_ACTIVE = TRUE;SET @MIGRATION_1580300846_IS_ACTIVE = TRUE;SET @MIGRATION_1582119202_IS_ACTIVE = TRUE;SET @MIGRATION_1582281362_IS_ACTIVE = TRUE;SET @MIGRATION_1583477457_IS_ACTIVE = TRUE;SET @MIGRATION_1583486528_IS_ACTIVE = TRUE;SET @MIGRATION_1583486534_IS_ACTIVE = TRUE;SET @MIGRATION_1583489755_IS_ACTIVE = TRUE;SET @MIGRATION_1583489757_IS_ACTIVE = TRUE;SET @MIGRATION_1583737095_IS_ACTIVE = TRUE;SET @MIGRATION_1588252518_IS_ACTIVE = TRUE;SET @MIGRATION_1594288127_IS_ACTIVE = TRUE;SET @MIGRATION_1594373672_IS_ACTIVE = TRUE;SET @MIGRATION_1594727519_IS_ACTIVE = TRUE;SET @MIGRATION_1583737095_IS_ACTIVE = TRUE;SET @MIGRATION_1602060888_IS_ACTIVE = TRUE;SET @MIGRATION_1602675838_IS_ACTIVE = TRUE;SET @MIGRATION_1609233961_IS_ACTIVE = TRUE;SET @MIGRATION_1579114486_IS_ACTIVE = TRUE;SET @MIGRATION_1622461524_IS_ACTIVE = TRUE;SET @MIGRATION_1623052558_IS_ACTIVE = TRUE;SET @MIGRATION_1632158551_IS_ACTIVE = TRUE;SET @MIGRATION_1634759880_IS_ACTIVE = TRUE;SET @MIGRATION_1637341838_IS_ACTIVE = TRUE;SET @MIGRATION_1640548412_IS_ACTIVE = TRUE;SET @MIGRATION_1645557087_IS_ACTIVE = TRUE;SET @MIGRATION_1645882069_IS_ACTIVE = TRUE;SET @MIGRATION_1647778651_IS_ACTIVE = TRUE;SET @MIGRATION_1648822579_IS_ACTIVE = TRUE;SET @MIGRATION_1572257501_IS_ACTIVE = TRUE;SET @MIGRATION_1616477404_IS_ACTIVE = TRUE;SET @MIGRATION_1592415758_IS_ACTIVE = TRUE;SET @MIGRATION_1647181771_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);