Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

3.99 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	3.99 ms	SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?) Parameters: [ 0 => 1775395521, 1 => [ 0 => translation_data_admin_en ] ] 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 > 1775395521 THEN data ELSE NULL END) as data FROM cache WHERE id IN ('translation_data_admin_en');

#▲

Time

Info

3.99 ms

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

Parameters: [ 0 => 1775395521, 1 => [ 0 => translation_data_admin_en ] ]

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 > 1775395521 THEN data ELSE NULL END) as data
            FROM cache WHERE id IN ('translation_data_admin_en');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Symfony Profiler

https://pim.kingpower.com/admin/login

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping