Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

2 Different statements

1.16 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.47 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1750071743 [ "site_domain_137803ff11c381cf5c2e060110fad697" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1750071743 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('site_domain_137803ff11c381cf5c2e060110fad697');
2	0.47 ms	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/" "sourcePathQuery" => "/" "sourceEntireUri" => "https://52.2.39.220/" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = : sourcePath AND ( `type` = : typePath OR `type` = : typeAuto ) ) OR ( source = : sourcePathQuery AND `type` = : typePathQuery ) OR ( source = : sourceEntireUri AND `type` = : typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/' AND `type` = 'path_query') OR (source = 'https://52.2.39.220/' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
3	0.22 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [`1750071743 [ "system_route_redirect" ]`] View formatted query View runnable query Explain query SELECT id, ( CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END ) as data FROM cache WHERE id IN (?) SELECT id, (CASE WHEN expire IS NULL OR expire > 1750071743 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('system_route_redirect');

#▲

Time

Info

0.47 ms

SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)

Parameters:

[
  1750071743
  [
    "site_domain_137803ff11c381cf5c2e060110fad697"
  ]
]

View formatted query View runnable query Explain query

SELECT 
  id, 
  (
    CASE WHEN expire IS NULL 
    OR expire > ? THEN data ELSE NULL END
  ) as data 
FROM 
  cache 
WHERE 
  id IN (?)

SELECT id, 
          (CASE WHEN expire IS NULL OR expire > 1750071743 THEN data ELSE NULL END) as data
            FROM cache WHERE id IN ('site_domain_137803ff11c381cf5c2e060110fad697');

0.47 ms

SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC

Parameters:

[
  "sourcePath" => "/"
  "sourcePathQuery" => "/"
  "sourceEntireUri" => "https://52.2.39.220/"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]

View formatted query View runnable query Explain query

SELECT 
  * 
FROM 
  redirects 
WHERE 
  (
    (
      source = : sourcePath 
      AND (
        `type` = : typePath 
        OR `type` = : typeAuto
      )
    ) 
    OR (
      source = : sourcePathQuery 
      AND `type` = : typePathQuery
    ) 
    OR (
      source = : sourceEntireUri 
      AND `type` = : typeEntireUri
    )
  ) 
  AND active = 1 
  AND regex IS NULL 
  AND (
    expiry > UNIX_TIMESTAMP() 
    OR expiry IS NULL
  ) 
  AND sourceSite IS NULL 
  AND priority = 99 
ORDER BY 
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/' AND `type` = 'path_query') OR
                (source = 'https://52.2.39.220/' AND `type` = 'entire_uri')
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

0.22 ms

SELECT id, 
          (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data
            FROM cache WHERE id IN (?)

Parameters:

[
  1750071743
  [
    "system_route_redirect"
  ]
]

View formatted query View runnable query Explain query

SELECT 
  id, 
  (
    CASE WHEN expire IS NULL 
    OR expire > ? THEN data ELSE NULL END
  ) as data 
FROM 
  cache 
WHERE 
  id IN (?)

SELECT id, 
          (CASE WHEN expire IS NULL OR expire > 1750071743 THEN data ELSE NULL END) as data
            FROM cache WHERE id IN ('system_route_redirect');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.

Symfony Profiler

https://52.2.39.220/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping