Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

2 Different statements

1.30 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.76 ms (58.41%)	1	SELECT * FROM translations_admin LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_admin LIMIT 1; SELECT * FROM translations_admin LIMIT 1;;
0.54 ms (41.59%)	2	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1712193492 [ "\x00tags\x00translation_data_2e364d315ad5ad984609e7f4beedf0f7" "translation_data_2e364d315ad5ad984609e7f4beedf0f7" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1712193492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translation_data_2e364d315ad5ad984609e7f4beedf0f7', 'translation_data_2e364d315ad5ad984609e7f4beedf0f7');

Time▼

Count

Info

0.76 ms
(58.41%)

SELECT * FROM translations_admin LIMIT 1;

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  *
FROM
  translations_admin
LIMIT
  1;

SELECT * FROM translations_admin LIMIT 1;;

0.54 ms
(41.59%)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)

Parameters:

[
  1712193492
  [
    "\x00tags\x00translation_data_2e364d315ad5ad984609e7f4beedf0f7"
    "translation_data_2e364d315ad5ad984609e7f4beedf0f7"
  ]
]

View formatted query View runnable query Explain query

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN item_data ELSE NULL END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1712193492 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translation_data_2e364d315ad5ad984609e7f4beedf0f7', 'translation_data_2e364d315ad5ad984609e7f4beedf0f7');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

https://staging-pim.blackstonefootwear.com/admin/login?perspective=

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache