Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

3.99 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
3.99 ms (100.00%)	1	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▼

Count

Info

3.99 ms
(100.00%)

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

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping