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_1638993987_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642732351_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643878976_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643892702_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647511158_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648543185_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648709176_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650249241_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650444800_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650548599_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_1656397126_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656928097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657011337_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605167857_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346372_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346372_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346374_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346375_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_1603810036_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607423732_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603810036_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616412445_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616413078_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622039002_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629280389_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642507826_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1685001455_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1571303196_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1575555505_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582193703_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1591277478_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603289196_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608533666_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614761861_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617969653_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346371_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346372_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_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_1607346372_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346372_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346374_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346405_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346405_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346406_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346406_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346407_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346407_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346407_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346407_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346408_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346409_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346410_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1681820337_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1558500331_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615911875_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646211291_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667812857_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589874100_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589874100_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589874110_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589874120_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589889217_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589889230_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589889270_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593762780_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594368835_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595512263_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1599142075_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632494010_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1633079483_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647342007_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647342008_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657031888_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1677657367_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1677657400_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589874100_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589874100_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594718000_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346372_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607346372_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_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_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_1656397126_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1607346372_IS_ACTIVE = TRUE;SET @MIGRATION_1607346372_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346374_IS_ACTIVE = TRUE;SET @MIGRATION_1607346375_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_1603810036_IS_ACTIVE = TRUE;SET @MIGRATION_1607423732_IS_ACTIVE = TRUE;SET @MIGRATION_1603810036_IS_ACTIVE = TRUE;SET @MIGRATION_1616412445_IS_ACTIVE = TRUE;SET @MIGRATION_1616413078_IS_ACTIVE = TRUE;SET @MIGRATION_1622039002_IS_ACTIVE = TRUE;SET @MIGRATION_1629280389_IS_ACTIVE = TRUE;SET @MIGRATION_1642507826_IS_ACTIVE = TRUE;SET @MIGRATION_1685001455_IS_ACTIVE = TRUE;SET @MIGRATION_1571303196_IS_ACTIVE = TRUE;SET @MIGRATION_1575555505_IS_ACTIVE = TRUE;SET @MIGRATION_1582193703_IS_ACTIVE = TRUE;SET @MIGRATION_1591277478_IS_ACTIVE = TRUE;SET @MIGRATION_1603289196_IS_ACTIVE = TRUE;SET @MIGRATION_1608533666_IS_ACTIVE = TRUE;SET @MIGRATION_1614761861_IS_ACTIVE = TRUE;SET @MIGRATION_1617969653_IS_ACTIVE = TRUE;SET @MIGRATION_1607346371_IS_ACTIVE = TRUE;SET @MIGRATION_1607346372_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_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_1607346372_IS_ACTIVE = TRUE;SET @MIGRATION_1607346372_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346373_IS_ACTIVE = TRUE;SET @MIGRATION_1607346374_IS_ACTIVE = TRUE;SET @MIGRATION_1607346405_IS_ACTIVE = TRUE;SET @MIGRATION_1607346405_IS_ACTIVE = TRUE;SET @MIGRATION_1607346406_IS_ACTIVE = TRUE;SET @MIGRATION_1607346406_IS_ACTIVE = TRUE;SET @MIGRATION_1607346407_IS_ACTIVE = TRUE;SET @MIGRATION_1607346407_IS_ACTIVE = TRUE;SET @MIGRATION_1607346407_IS_ACTIVE = TRUE;SET @MIGRATION_1607346407_IS_ACTIVE = TRUE;SET @MIGRATION_1607346408_IS_ACTIVE = TRUE;SET @MIGRATION_1607346409_IS_ACTIVE = TRUE;SET @MIGRATION_1607346410_IS_ACTIVE = TRUE;SET @MIGRATION_1681820337_IS_ACTIVE = TRUE;SET @MIGRATION_1558500331_IS_ACTIVE = TRUE;SET @MIGRATION_1615911875_IS_ACTIVE = TRUE;SET @MIGRATION_1646211291_IS_ACTIVE = TRUE;SET @MIGRATION_1667812857_IS_ACTIVE = TRUE;SET @MIGRATION_1589874100_IS_ACTIVE = TRUE;SET @MIGRATION_1589874100_IS_ACTIVE = TRUE;SET @MIGRATION_1589874110_IS_ACTIVE = TRUE;SET @MIGRATION_1589874120_IS_ACTIVE = TRUE;SET @MIGRATION_1589889217_IS_ACTIVE = TRUE;SET @MIGRATION_1589889230_IS_ACTIVE = TRUE;SET @MIGRATION_1589889270_IS_ACTIVE = TRUE;SET @MIGRATION_1593762780_IS_ACTIVE = TRUE;SET @MIGRATION_1594368835_IS_ACTIVE = TRUE;SET @MIGRATION_1595512263_IS_ACTIVE = TRUE;SET @MIGRATION_1599142075_IS_ACTIVE = TRUE;SET @MIGRATION_1632494010_IS_ACTIVE = TRUE;SET @MIGRATION_1633079483_IS_ACTIVE = TRUE;SET @MIGRATION_1647342007_IS_ACTIVE = TRUE;SET @MIGRATION_1647342008_IS_ACTIVE = TRUE;SET @MIGRATION_1657031888_IS_ACTIVE = TRUE;SET @MIGRATION_1677657367_IS_ACTIVE = TRUE;SET @MIGRATION_1677657400_IS_ACTIVE = TRUE;SET @MIGRATION_1589874100_IS_ACTIVE = TRUE;SET @MIGRATION_1589874100_IS_ACTIVE = TRUE;SET @MIGRATION_1594718000_IS_ACTIVE = TRUE;SET @MIGRATION_1607346372_IS_ACTIVE = TRUE;SET @MIGRATION_1607346372_IS_ACTIVE = TRUE;

SELECT 
  `id`, 
  `old_url`, 
  `new_url`, 
  `old_url_regex`, 
  `search_url_by`, 
  `temporary`, 
  : url0 REGEXP `old_url_regex` as regex0, 
  : url2 REGEXP `old_url_regex` as regex2, 
  : url3 REGEXP `old_url_regex` as regex3 
FROM 
  `acris_seo_redirect` 
WHERE 
  `active` = : active 
  AND (
    (
      NOT (
        `search_url_by` = : searchByUrlRegex
      ) 
      AND (
        (
          `old_url` = : url0 
          OR `old_url` = : url2 
          OR `old_url` = : url3
        )
      )
    ) 
    OR (
      `search_url_by` = : searchByUrlRegex 
      AND (
        (
          : url0 REGEXP `old_url_regex` 
          OR : url2 REGEXP `old_url_regex` 
          OR : url3 REGEXP `old_url_regex`
        )
      )
    )
  ) 
LIMIT 
  6;

SELECT `id`, `old_url`, `new_url`, `old_url_regex`, `search_url_by` ,`temporary`, '/robots.txt' REGEXP `old_url_regex` as regex0, 'https://dvdw.generationshop.dev/robots.txt' REGEXP `old_url_regex` as regex2, 'dvdw.generationshop.dev/robots.txt' REGEXP `old_url_regex` as regex3 FROM `acris_seo_redirect` WHERE `active` = 1 AND ((NOT (`search_url_by` = 'regex') AND ((`old_url` = '/robots.txt' OR `old_url` = 'https://dvdw.generationshop.dev/robots.txt' OR `old_url` = 'dvdw.generationshop.dev/robots.txt'))) OR (`search_url_by` = 'regex' AND (('/robots.txt' REGEXP `old_url_regex` OR 'https://dvdw.generationshop.dev/robots.txt' REGEXP `old_url_regex` OR 'dvdw.generationshop.dev/robots.txt' REGEXP `old_url_regex`)))) LIMIT 6;;