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_1601388975_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602745374_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602822727_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605609309_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605861407_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1606310257_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607415095_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607500561_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607514878_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607581275_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607581276_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608624028_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609125144_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609857999_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610531188_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610965670_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610974673_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1611155140_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614240671_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594104496_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604585230_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609140710_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610337444_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610439375_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610448012_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610523204_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610523548_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610616655_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610621999_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610625925_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610634383_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610904608_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1611732852_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1611817467_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612184092_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612442685_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612442686_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612442786_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612851765_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612865237_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612970642_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612980753_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1613665555_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614249488_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614691876_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614765170_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614765785_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615359964_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615366708_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615452749_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615802866_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615819992_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616076922_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616496610_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616555956_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617000878_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617356092_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617784658_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617864895_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617868381_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617877887_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617896006_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617935350_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617953690_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617960456_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617974402_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618218491_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618389817_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618476427_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618569201_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618900427_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618989442_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619070236_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619428555_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619604605_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619703075_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620146632_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620147234_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620201616_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620215586_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620374229_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620376945_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620632460_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620634856_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620733405_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620733405_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620820321_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621845357_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621845370_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622010069_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622104463_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622782058_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1623305620_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1623391399_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1623828962_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624262862_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624884801_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624967118_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625304609_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625465756_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625505190_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625554302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625569667_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625583596_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625583619_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625816310_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625819412_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625831469_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626241110_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626442868_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626696809_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626785125_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627292049_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627540693_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627541488_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627562945_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627650101_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627929168_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627983652_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1628519513_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1628749113_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629204538_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629700169_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629877210_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1630074081_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1630485317_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631625055_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631703921_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631790054_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631863869_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632111590_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632215760_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632721037_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1633347511_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1633358879_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1633422057_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1634735841_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635147952_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635230747_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635237551_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635388654_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635936029_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636014089_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636018970_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636362839_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636449347_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636964297_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636971615_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638195971_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638365464_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638514913_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638993987_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639122665_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639139581_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639992771_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1641289204_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642517958_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642732351_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642757286_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643366069_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643386819_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643724178_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643878976_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643892702_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645019769_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645453538_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646125417_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646397836_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646817331_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647260673_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647443222_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647511158_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648031611_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648031636_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648543185_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648709176_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648803451_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649040981_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649315608_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650249241_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650444800_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650548599_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650620993_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650872291_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650981517_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652166447_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652345915_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652441129_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652864153_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653376989_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653385302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1655730949_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656397126_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656928097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657011337_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657027979_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660814397_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1661759290_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1661771388_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632281097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636121186_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660813696_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1641476963_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632281097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636121186_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660813696_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1598270975_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622104591_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660034505_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_1601388975_IS_ACTIVE = TRUE;SET @MIGRATION_1602745374_IS_ACTIVE = TRUE;SET @MIGRATION_1602822727_IS_ACTIVE = TRUE;SET @MIGRATION_1605609309_IS_ACTIVE = TRUE;SET @MIGRATION_1605861407_IS_ACTIVE = TRUE;SET @MIGRATION_1606310257_IS_ACTIVE = TRUE;SET @MIGRATION_1607415095_IS_ACTIVE = TRUE;SET @MIGRATION_1607500561_IS_ACTIVE = TRUE;SET @MIGRATION_1607514878_IS_ACTIVE = TRUE;SET @MIGRATION_1607581275_IS_ACTIVE = TRUE;SET @MIGRATION_1607581276_IS_ACTIVE = TRUE;SET @MIGRATION_1608624028_IS_ACTIVE = TRUE;SET @MIGRATION_1609125144_IS_ACTIVE = TRUE;SET @MIGRATION_1609857999_IS_ACTIVE = TRUE;SET @MIGRATION_1610531188_IS_ACTIVE = TRUE;SET @MIGRATION_1610965670_IS_ACTIVE = TRUE;SET @MIGRATION_1610974673_IS_ACTIVE = TRUE;SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1614240671_IS_ACTIVE = TRUE;SET @MIGRATION_1594104496_IS_ACTIVE = TRUE;SET @MIGRATION_1604585230_IS_ACTIVE = TRUE;SET @MIGRATION_1609140710_IS_ACTIVE = TRUE;SET @MIGRATION_1610337444_IS_ACTIVE = TRUE;SET @MIGRATION_1610439375_IS_ACTIVE = TRUE;SET @MIGRATION_1610448012_IS_ACTIVE = TRUE;SET @MIGRATION_1610523204_IS_ACTIVE = TRUE;SET @MIGRATION_1610523548_IS_ACTIVE = TRUE;SET @MIGRATION_1610616655_IS_ACTIVE = TRUE;SET @MIGRATION_1610621999_IS_ACTIVE = TRUE;SET @MIGRATION_1610625925_IS_ACTIVE = TRUE;SET @MIGRATION_1610634383_IS_ACTIVE = TRUE;SET @MIGRATION_1610904608_IS_ACTIVE = TRUE;SET @MIGRATION_1611732852_IS_ACTIVE = TRUE;SET @MIGRATION_1611817467_IS_ACTIVE = TRUE;SET @MIGRATION_1612184092_IS_ACTIVE = TRUE;SET @MIGRATION_1612442685_IS_ACTIVE = TRUE;SET @MIGRATION_1612442686_IS_ACTIVE = TRUE;SET @MIGRATION_1612442786_IS_ACTIVE = TRUE;SET @MIGRATION_1612851765_IS_ACTIVE = TRUE;SET @MIGRATION_1612865237_IS_ACTIVE = TRUE;SET @MIGRATION_1612970642_IS_ACTIVE = TRUE;SET @MIGRATION_1612980753_IS_ACTIVE = TRUE;SET @MIGRATION_1613665555_IS_ACTIVE = TRUE;SET @MIGRATION_1614249488_IS_ACTIVE = TRUE;SET @MIGRATION_1614691876_IS_ACTIVE = TRUE;SET @MIGRATION_1614765170_IS_ACTIVE = TRUE;SET @MIGRATION_1614765785_IS_ACTIVE = TRUE;SET @MIGRATION_1615359964_IS_ACTIVE = TRUE;SET @MIGRATION_1615366708_IS_ACTIVE = TRUE;SET @MIGRATION_1615452749_IS_ACTIVE = TRUE;SET @MIGRATION_1615802866_IS_ACTIVE = TRUE;SET @MIGRATION_1615819992_IS_ACTIVE = TRUE;SET @MIGRATION_1616076922_IS_ACTIVE = TRUE;SET @MIGRATION_1616496610_IS_ACTIVE = TRUE;SET @MIGRATION_1616555956_IS_ACTIVE = TRUE;SET @MIGRATION_1617000878_IS_ACTIVE = TRUE;SET @MIGRATION_1617356092_IS_ACTIVE = TRUE;SET @MIGRATION_1617784658_IS_ACTIVE = TRUE;SET @MIGRATION_1617864895_IS_ACTIVE = TRUE;SET @MIGRATION_1617868381_IS_ACTIVE = TRUE;SET @MIGRATION_1617877887_IS_ACTIVE = TRUE;SET @MIGRATION_1617896006_IS_ACTIVE = TRUE;SET @MIGRATION_1617935350_IS_ACTIVE = TRUE;SET @MIGRATION_1617953690_IS_ACTIVE = TRUE;SET @MIGRATION_1617960456_IS_ACTIVE = TRUE;SET @MIGRATION_1617974402_IS_ACTIVE = TRUE;SET @MIGRATION_1618218491_IS_ACTIVE = TRUE;SET @MIGRATION_1618389817_IS_ACTIVE = TRUE;SET @MIGRATION_1618476427_IS_ACTIVE = TRUE;SET @MIGRATION_1618569201_IS_ACTIVE = TRUE;SET @MIGRATION_1618900427_IS_ACTIVE = TRUE;SET @MIGRATION_1618989442_IS_ACTIVE = TRUE;SET @MIGRATION_1619070236_IS_ACTIVE = TRUE;SET @MIGRATION_1619428555_IS_ACTIVE = TRUE;SET @MIGRATION_1619604605_IS_ACTIVE = TRUE;SET @MIGRATION_1619703075_IS_ACTIVE = TRUE;SET @MIGRATION_1620146632_IS_ACTIVE = TRUE;SET @MIGRATION_1620147234_IS_ACTIVE = TRUE;SET @MIGRATION_1620201616_IS_ACTIVE = TRUE;SET @MIGRATION_1620215586_IS_ACTIVE = TRUE;SET @MIGRATION_1620374229_IS_ACTIVE = TRUE;SET @MIGRATION_1620376945_IS_ACTIVE = TRUE;SET @MIGRATION_1620632460_IS_ACTIVE = TRUE;SET @MIGRATION_1620634856_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620820321_IS_ACTIVE = TRUE;SET @MIGRATION_1621845357_IS_ACTIVE = TRUE;SET @MIGRATION_1621845370_IS_ACTIVE = TRUE;SET @MIGRATION_1622010069_IS_ACTIVE = TRUE;SET @MIGRATION_1622104463_IS_ACTIVE = TRUE;SET @MIGRATION_1622782058_IS_ACTIVE = TRUE;SET @MIGRATION_1623305620_IS_ACTIVE = TRUE;SET @MIGRATION_1623391399_IS_ACTIVE = TRUE;SET @MIGRATION_1623828962_IS_ACTIVE = TRUE;SET @MIGRATION_1624262862_IS_ACTIVE = TRUE;SET @MIGRATION_1624884801_IS_ACTIVE = TRUE;SET @MIGRATION_1624967118_IS_ACTIVE = TRUE;SET @MIGRATION_1625304609_IS_ACTIVE = TRUE;SET @MIGRATION_1625465756_IS_ACTIVE = TRUE;SET @MIGRATION_1625505190_IS_ACTIVE = TRUE;SET @MIGRATION_1625554302_IS_ACTIVE = TRUE;SET @MIGRATION_1625569667_IS_ACTIVE = TRUE;SET @MIGRATION_1625583596_IS_ACTIVE = TRUE;SET @MIGRATION_1625583619_IS_ACTIVE = TRUE;SET @MIGRATION_1625816310_IS_ACTIVE = TRUE;SET @MIGRATION_1625819412_IS_ACTIVE = TRUE;SET @MIGRATION_1625831469_IS_ACTIVE = TRUE;SET @MIGRATION_1626241110_IS_ACTIVE = TRUE;SET @MIGRATION_1626442868_IS_ACTIVE = TRUE;SET @MIGRATION_1626696809_IS_ACTIVE = TRUE;SET @MIGRATION_1626785125_IS_ACTIVE = TRUE;SET @MIGRATION_1627292049_IS_ACTIVE = TRUE;SET @MIGRATION_1627540693_IS_ACTIVE = TRUE;SET @MIGRATION_1627541488_IS_ACTIVE = TRUE;SET @MIGRATION_1627562945_IS_ACTIVE = TRUE;SET @MIGRATION_1627650101_IS_ACTIVE = TRUE;SET @MIGRATION_1627929168_IS_ACTIVE = TRUE;SET @MIGRATION_1627983652_IS_ACTIVE = TRUE;SET @MIGRATION_1628519513_IS_ACTIVE = TRUE;SET @MIGRATION_1628749113_IS_ACTIVE = TRUE;SET @MIGRATION_1629204538_IS_ACTIVE = TRUE;SET @MIGRATION_1629700169_IS_ACTIVE = TRUE;SET @MIGRATION_1629877210_IS_ACTIVE = TRUE;SET @MIGRATION_1630074081_IS_ACTIVE = TRUE;SET @MIGRATION_1630485317_IS_ACTIVE = TRUE;SET @MIGRATION_1631625055_IS_ACTIVE = TRUE;SET @MIGRATION_1631703921_IS_ACTIVE = TRUE;SET @MIGRATION_1631790054_IS_ACTIVE = TRUE;SET @MIGRATION_1631863869_IS_ACTIVE = TRUE;SET @MIGRATION_1632111590_IS_ACTIVE = TRUE;SET @MIGRATION_1632215760_IS_ACTIVE = TRUE;SET @MIGRATION_1632721037_IS_ACTIVE = TRUE;SET @MIGRATION_1633347511_IS_ACTIVE = TRUE;SET @MIGRATION_1633358879_IS_ACTIVE = TRUE;SET @MIGRATION_1633422057_IS_ACTIVE = TRUE;SET @MIGRATION_1634735841_IS_ACTIVE = TRUE;SET @MIGRATION_1635147952_IS_ACTIVE = TRUE;SET @MIGRATION_1635230747_IS_ACTIVE = TRUE;SET @MIGRATION_1635237551_IS_ACTIVE = TRUE;SET @MIGRATION_1635388654_IS_ACTIVE = TRUE;SET @MIGRATION_1635936029_IS_ACTIVE = TRUE;SET @MIGRATION_1636014089_IS_ACTIVE = TRUE;SET @MIGRATION_1636018970_IS_ACTIVE = TRUE;SET @MIGRATION_1636362839_IS_ACTIVE = TRUE;SET @MIGRATION_1636449347_IS_ACTIVE = TRUE;SET @MIGRATION_1636964297_IS_ACTIVE = TRUE;SET @MIGRATION_1636971615_IS_ACTIVE = TRUE;SET @MIGRATION_1638195971_IS_ACTIVE = TRUE;SET @MIGRATION_1638365464_IS_ACTIVE = TRUE;SET @MIGRATION_1638514913_IS_ACTIVE = TRUE;SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1639122665_IS_ACTIVE = TRUE;SET @MIGRATION_1639139581_IS_ACTIVE = TRUE;SET @MIGRATION_1639992771_IS_ACTIVE = TRUE;SET @MIGRATION_1641289204_IS_ACTIVE = TRUE;SET @MIGRATION_1642517958_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1642757286_IS_ACTIVE = TRUE;SET @MIGRATION_1643366069_IS_ACTIVE = TRUE;SET @MIGRATION_1643386819_IS_ACTIVE = TRUE;SET @MIGRATION_1643724178_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1645019769_IS_ACTIVE = TRUE;SET @MIGRATION_1645453538_IS_ACTIVE = TRUE;SET @MIGRATION_1646125417_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1646817331_IS_ACTIVE = TRUE;SET @MIGRATION_1647260673_IS_ACTIVE = TRUE;SET @MIGRATION_1647443222_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648031611_IS_ACTIVE = TRUE;SET @MIGRATION_1648031636_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1648803451_IS_ACTIVE = TRUE;SET @MIGRATION_1649040981_IS_ACTIVE = TRUE;SET @MIGRATION_1649315608_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650620993_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_IS_ACTIVE = TRUE;SET @MIGRATION_1652166447_IS_ACTIVE = TRUE;SET @MIGRATION_1652345915_IS_ACTIVE = TRUE;SET @MIGRATION_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1655730949_IS_ACTIVE = TRUE;SET @MIGRATION_1656397126_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;SET @MIGRATION_1657027979_IS_ACTIVE = TRUE;SET @MIGRATION_1660814397_IS_ACTIVE = TRUE;SET @MIGRATION_1661759290_IS_ACTIVE = TRUE;SET @MIGRATION_1661771388_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1641476963_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1598270975_IS_ACTIVE = TRUE;SET @MIGRATION_1622104591_IS_ACTIVE = TRUE;SET @MIGRATION_1660034505_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 
  last_updated_password_at 
FROM 
  user 
WHERE 
  id = : userId

SELECT last_updated_password_at FROM user WHERE id = 0x7716B870D6C045B385FFA7BCD77F0231;

SELECT 
  item_rounding 
FROM 
  currency 
WHERE 
  id = : id

SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;

SELECT 
  role.privileges 
FROM 
  acl_user_role mapping 
  INNER JOIN acl_role role ON mapping.acl_role_id = role.id 
WHERE 
  mapping.user_id = : userId

SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = 0x7716B870D6C045B385FFA7BCD77F0231;

SELECT 
  admin 
FROM 
  `user` 
WHERE 
  id = : id

SELECT admin FROM `user` WHERE id = 0x7716B870D6C045B385FFA7BCD77F0231;

SELECT 
  `scheduled_task`.`id` as `scheduled_task.id`, 
  `scheduled_task`.`name` as `scheduled_task.name`, 
  `scheduled_task`.`scheduled_task_class` as `scheduled_task.scheduledTaskClass`, 
  `scheduled_task`.`run_interval` as `scheduled_task.runInterval`, 
  `scheduled_task`.`status` as `scheduled_task.status`, 
  `scheduled_task`.`last_execution_time` as `scheduled_task.lastExecutionTime`, 
  `scheduled_task`.`next_execution_time` as `scheduled_task.nextExecutionTime`, 
  `scheduled_task`.`created_at` as `scheduled_task.createdAt`, 
  `scheduled_task`.`updated_at` as `scheduled_task.updatedAt` 
FROM 
  `scheduled_task` 
WHERE 
  (
    (
      `scheduled_task`.`next_execution_time` < : param_28c454900a514150a545d522450de845
    ) 
    AND `scheduled_task`.`status` = : param_25ee47843e7c4662b3902423c4021cc5
  )

SELECT `scheduled_task`.`id` as `scheduled_task.id`, `scheduled_task`.`name` as `scheduled_task.name`, `scheduled_task`.`scheduled_task_class` as `scheduled_task.scheduledTaskClass`, `scheduled_task`.`run_interval` as `scheduled_task.runInterval`, `scheduled_task`.`status` as `scheduled_task.status`, `scheduled_task`.`last_execution_time` as `scheduled_task.lastExecutionTime`, `scheduled_task`.`next_execution_time` as `scheduled_task.nextExecutionTime`, `scheduled_task`.`created_at` as `scheduled_task.createdAt`, `scheduled_task`.`updated_at` as `scheduled_task.updatedAt` FROM `scheduled_task` WHERE ((`scheduled_task`.`next_execution_time` < '2024-11-22 10:58:54.578') AND `scheduled_task`.`status` = 'scheduled');

SELECT 
  LOWER(
    HEX(language.id)
  ) AS array_key, 
  LOWER(
    HEX(language.id)
  ) AS id, 
  locale.code, 
  LOWER(
    HEX(language.parent_id)
  ) parentId 
FROM 
  language 
  LEFT JOIN locale locale ON language.translation_code_id = locale.id

SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id;

SELECT 
  1 as `exists`, 
  `id` 
FROM 
  `scheduled_task` 
WHERE 
  `id` IN (?)

SELECT 1 as `exists`, `id` FROM `scheduled_task` WHERE `id` IN (0x05C1429C56D14E8A927834E01D7CE657);

"START TRANSACTION"

"START TRANSACTION";

UPDATE 
  `scheduled_task` 
SET 
  `status` = ?, 
  `updated_at` = ? 
WHERE 
  id = ?

UPDATE `scheduled_task` SET `status` = 'queued', `updated_at` = '2024-11-22 10:58:54.587' WHERE id = 0x05C1429C56D14E8A927834E01D7CE657;

"COMMIT"

"COMMIT";

# app-scripts::refresh::read
SELECT 
  `app`.`id` as `app.id`, 
  `app`.`name` as `app.name`, 
  `app`.`path` as `app.path`, 
  `app`.`author` as `app.author`, 
  `app`.`copyright` as `app.copyright`, 
  `app`.`license` as `app.license`, 
  `app`.`active` as `app.active`, 
  `app`.`configurable` as `app.configurable`, 
  `app`.`privacy` as `app.privacy`, 
  `app`.`version` as `app.version`, 
  `app`.`icon` as `app.iconRaw`, 
  `app`.`app_secret` as `app.appSecret`, 
  `app`.`modules` as `app.modules`, 
  `app`.`main_module` as `app.mainModule`, 
  `app`.`cookies` as `app.cookies`, 
  `app`.`allow_disable` as `app.allowDisable`, 
  `app`.`base_app_url` as `app.baseAppUrl`, 
  `app`.`allowed_hosts` as `app.allowedHosts`, 
  `app`.`template_load_priority` as `app.templateLoadPriority`, 
  `app`.`integration_id` as `app.integrationId`, 
  `app.integration`.`id` as `app.integration.id`, 
  `app.integration`.`label` as `app.integration.label`, 
  `app.integration`.`access_key` as `app.integration.accessKey`, 
  `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, 
  `app.integration`.`write_access` as `app.integration.writeAccess`, 
  `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, 
  `app.integration`.`admin` as `app.integration.admin`, 
  `app.integration`.`custom_fields` as `app.integration.customFields`, 
  `app.integration`.`deleted_at` as `app.integration.deletedAt`, 
  `app.integration`.`created_at` as `app.integration.createdAt`, 
  `app.integration`.`updated_at` as `app.integration.updatedAt`, 
  `app`.`acl_role_id` as `app.aclRoleId`, 
  `app.aclRole`.`id` as `app.aclRole.id`, 
  `app.aclRole`.`name` as `app.aclRole.name`, 
  `app.aclRole`.`description` as `app.aclRole.description`, 
  `app.aclRole`.`privileges` as `app.aclRole.privileges`, 
  `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, 
  `app.aclRole`.`created_at` as `app.aclRole.createdAt`, 
  `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, 
  `app`.`created_at` as `app.createdAt`, 
  `app`.`updated_at` as `app.updatedAt`, 
  `app.translation.label`, 
  COALESCE(
    `app.translation.label`, `app.translation.label`
  ) as `app.label`, 
  `app.translation.description`, 
  COALESCE(
    `app.translation.description`, `app.translation.description`
  ) as `app.description`, 
  `app.translation.privacyPolicyExtensions`, 
  COALESCE(
    `app.translation.privacyPolicyExtensions`, 
    `app.translation.privacyPolicyExtensions`
  ) as `app.privacyPolicyExtensions`, 
  `app.translation.customFields`, 
  COALESCE(
    `app.translation.customFields`, 
    `app.translation.customFields`
  ) as `app.customFields`, 
  `app.translation.createdAt`, 
  `app.translation.updatedAt`, 
  `app.translation.appId`, 
  `app.translation.languageId` 
FROM 
  `app` 
  LEFT JOIN (
    SELECT 
      `app.translation`.app_id, 
      `app.translation`.label as `app.translation.label`, 
      `app.translation`.description as `app.translation.description`, 
      `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, 
      `app.translation`.custom_fields as `app.translation.customFields`, 
      `app.translation`.created_at as `app.translation.createdAt`, 
      `app.translation`.updated_at as `app.translation.updatedAt`, 
      `app.translation`.app_id as `app.translation.appId`, 
      `app.translation`.language_id as `app.translation.languageId` 
    FROM 
      `app_translation` `app.translation` 
    WHERE 
      `app.translation`.language_id = : languageId
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` 
  LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` 
  LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` 
WHERE 
  (
    `app`.`active` = : param_6baf91fbf7134b6291450bc497b897a3
  )

# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = 1);

SELECT 
  LOWER(
    HEX(`script`.`app_id`)
  ) as `app_id`, 
  `script`.`name` AS scriptName, 
  `script`.`script` AS script, 
  `script`.`hook` AS hook, 
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified, 
  `app`.`name` AS appName, 
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId, 
  `app`.`version` AS appVersion, 
  `script`.`active` AS active 
FROM 
  `script` 
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` 
WHERE 
  `script`.`hook` != 'include' 
ORDER BY 
  `app`.`created_at`, 
  `app`.`id`, 
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;

SELECT 
  LOWER(
    HEX(`script`.`app_id`)
  ) as `app_id`, 
  `script`.`name` AS name, 
  `script`.`script` AS script, 
  `app`.`name` AS appName, 
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId, 
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified 
FROM 
  `script` 
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` 
WHERE 
  `script`.`hook` = 'include' 
ORDER BY 
  `app`.`created_at`, 
  `app`.`id`, 
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;

INSERT INTO enqueue (
  id, published_at, body, headers, properties, 
  priority, queue, redelivered, delivery_id, 
  redeliver_after
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO enqueue (id, published_at, body, headers, properties, priority, queue, redelivered, delivery_id, redeliver_after) VALUES ('/* Object(Ramsey\\Uuid\\Lazy\\LazyUuidFromString): */\"8c0a29cc-e457-4eeb-bd63-7b485bea3773\"', 17322731346242, 'O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:22:\\\"messenger.bus.shopware\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:75:\\\"Shopware\\\\Core\\\\Content\\\\ProductExport\\\\ScheduledTask\\\\ProductExportGenerateTask\\\":1:{s:9:\\\"\\0*\\0taskId\\\";s:32:\\\"05c1429c56d14e8a927834e01d7ce657\\\";}}', '[]', '[]', 0, 'messages', 0, NULL, NULL);

INSERT INTO `increment` (
  `pool`, `cluster`, `key`, `count`, 
  `created_at`
) 
VALUES 
  (
    : pool, : cluster, : key, 1, : createdAt
  ) ON DUPLICATE KEY 
UPDATE 
  `count` = `count` + 1, 
  `updated_at` = : createdAt

INSERT INTO `increment` (`pool`, `cluster`, `key`, `count`, `created_at`)
            VALUES ('message_queue', 'message_queue_stats', 'Shopware\\Core\\Content\\ProductExport\\ScheduledTask\\ProductExportGenerateTask', 1, '2024-11-22 10:58:54.632')
            ON DUPLICATE KEY UPDATE `count` = `count` + 1, `updated_at` = '2024-11-22 10:58:54.632'
        ;