Symfony Profiler

SELECT
  CONCAT(
    TRIM(
      TRAILING '/'
      FROM
        domain.url
    ),
    '/'
  ) `key`,
  CONCAT(
    TRIM(
      TRAILING '/'
      FROM
        domain.url
    ),
    '/'
  ) url,
  LOWER(
    HEX(domain.id)
  ) id,
  LOWER(
    HEX(sales_channel.id)
  ) salesChannelId,
  LOWER(
    HEX(sales_channel.type_id)
  ) typeId,
  LOWER(
    HEX(domain.snippet_set_id)
  ) snippetSetId,
  LOWER(
    HEX(domain.currency_id)
  ) currencyId,
  LOWER(
    HEX(domain.language_id)
  ) languageId,
  LOWER(
    HEX(theme.id)
  ) themeId,
  sales_channel.maintenance maintenance,
  COALESCE(
    sales_channel.maintenance_ip_allowlist,
    sales_channel.maintenance_ip_whitelist
  ) maintenanceIpAllowlist,
  snippet_set.iso as locale,
  theme.technical_name as themeName,
  parentTheme.technical_name as parentThemeName
FROM
  sales_channel
  INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id
  LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id
  INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id
  LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id
  LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id
WHERE
  (
    sales_channel.type_id = UNHEX(?)
  )
  AND (sales_channel.active)

SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, COALESCE(sales_channel.maintenance_ip_allowlist, sales_channel.maintenance_ip_whitelist) maintenanceIpAllowlist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX('8a243080f92e4c719546314b577cf82b')) AND (sales_channel.active);

SELECT
  t.name,
  t.url,
  t.input_schema,
  a.name AS app_name,
  a.app_secret,
  a.version,
  tt.label,
  tt.description
FROM
  app_mcp_tool t
  INNER JOIN app a ON t.app_id = a.id
  AND a.active = 1
  LEFT JOIN app_mcp_tool_translation tt ON t.id = tt.app_mcp_tool_id
  AND tt.language_id = UNHEX(?)
WHERE
  (
    a.app_secret IS NOT NULL
    OR t.url LIKE '/%'
  )
ORDER BY
  a.name,
  t.name

SELECT
                t.name,
                t.url,
                t.input_schema,
                a.name AS app_name,
                a.app_secret,
                a.version,
                tt.label,
                tt.description
            FROM app_mcp_tool t
            INNER JOIN app a ON t.app_id = a.id AND a.active = 1
            LEFT JOIN app_mcp_tool_translation tt
                ON t.id = tt.app_mcp_tool_id
                AND tt.language_id = UNHEX('2fbb5fe2e29a4d70aa5854ce7ce3e20b')
            WHERE (a.app_secret IS NOT NULL OR t.url LIKE '/%')
            ORDER BY a.name, t.name;

SELECT
  r.name,
  r.uri,
  r.url,
  r.mime_type,
  a.name AS app_name,
  a.app_secret,
  rt.label,
  rt.description
FROM
  app_mcp_resource r
  INNER JOIN app a ON r.app_id = a.id
  AND a.active = 1
  LEFT JOIN app_mcp_resource_translation rt ON r.id = rt.app_mcp_resource_id
  AND rt.language_id = UNHEX(?)
WHERE
  a.app_secret IS NOT NULL
ORDER BY
  a.name,
  r.name

SELECT
                r.name,
                r.uri,
                r.url,
                r.mime_type,
                a.name AS app_name,
                a.app_secret,
                rt.label,
                rt.description
            FROM app_mcp_resource r
            INNER JOIN app a ON r.app_id = a.id AND a.active = 1
            LEFT JOIN app_mcp_resource_translation rt
                ON r.id = rt.app_mcp_resource_id
                AND rt.language_id = UNHEX('2fbb5fe2e29a4d70aa5854ce7ce3e20b')
            WHERE a.app_secret IS NOT NULL
            ORDER BY a.name, r.name;

SELECT
  p.name,
  p.url,
  a.name AS app_name,
  a.app_secret,
  pt.label,
  pt.description
FROM
  app_mcp_prompt p
  INNER JOIN app a ON p.app_id = a.id
  AND a.active = 1
  LEFT JOIN app_mcp_prompt_translation pt ON p.id = pt.app_mcp_prompt_id
  AND pt.language_id = UNHEX(?)
WHERE
  a.app_secret IS NOT NULL
ORDER BY
  a.name,
  p.name

SELECT
                p.name,
                p.url,
                a.name AS app_name,
                a.app_secret,
                pt.label,
                pt.description
            FROM app_mcp_prompt p
            INNER JOIN app a ON p.app_id = a.id AND a.active = 1
            LEFT JOIN app_mcp_prompt_translation pt
                ON p.id = pt.app_mcp_prompt_id
                AND pt.language_id = UNHEX('2fbb5fe2e29a4d70aa5854ce7ce3e20b')
            WHERE a.app_secret IS NOT NULL
            ORDER BY a.name, p.name;

-- seo-url::resolve
SELECT
  id,
  path_info pathInfo,
  seo_path_info seoPathInfo,
  is_canonical isCanonical,
  sales_channel_id salesChannelId
FROM
  seo_url
WHERE
  (language_id = ?)
  AND (
    (
      sales_channel_id = ?
      OR sales_channel_id IS NULL
    )
  )
  AND (seo_url.is_deleted = 0)
  AND (
    (
      seo_path_info = ?
      OR seo_path_info = ?
    )
  )

-- seo-url::resolve
SELECT id, path_info pathInfo, seo_path_info seoPathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x0191AF45824471D5AD201B1775030788) AND ((sales_channel_id = 0x0195C81F5D1974F69310049D0B37EA8B OR sales_channel_id IS NULL)) AND (seo_url.is_deleted = 0) AND ((seo_path_info = '_ignition/execute-solution' OR seo_path_info = '_ignition/execute-solution/'));

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
  `key`,
  `value`
FROM
  `app_config`

SELECT `key`, `value` FROM `app_config`;

-- seo-url::resolve-fallback
SELECT
  path_info pathInfo,
  seo_path_info seoPathInfo
FROM
  seo_url
WHERE
  (language_id = ?)
  AND (sales_channel_id = ?)
  AND (path_info = ?)
  AND (is_canonical = 1)
  AND (is_deleted = 0)
LIMIT
  1

-- seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x0191AF45824471D5AD201B1775030788) AND (sales_channel_id = 0x0195C81F5D1974F69310049D0B37EA8B) AND (path_info = '/_ignition/execute-solution') AND (is_canonical = 1) AND (is_deleted = 0) LIMIT 1;

# 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,
  custom_entity.flags
FROM
  custom_entity
  LEFT JOIN app ON app.id = custom_entity.app_id
WHERE
  (
    custom_entity.app_id IS NULL
    OR app.active = 1
  )
  AND custom_entity.deleted_at IS NULL;

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
            ;