Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

7 Database Queries

3 Different statements

8.44 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
7.20 ms (85.36%)	5	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: [`1770980063 [ "\x00tags\x00data_director_installed" "data_director_installed" ]`] 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 > 1770980063 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0data_director_installed', 'data_director_installed');
0.72 ms (8.52%)	1	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "BUNDLE_INSTALLED__Reaze\HeadlessBundle\ReazeHeadlessBundle" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Reaze\\HeadlessBundle\\ReazeHeadlessBundle' AND scope = 'pimcore';
0.52 ms (6.12%)	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;;

Time▼

Count

Info

7.20 ms
(85.36%)

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:

[
  1770980063
  [
    "\x00tags\x00data_director_installed"
    "data_director_installed"
  ]
]

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 > 1770980063 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0data_director_installed', 'data_director_installed');

0.72 ms
(8.52%)

SELECT * FROM settings_store WHERE id = :id AND scope = :scope

Parameters:

[
  "id" => "BUNDLE_INSTALLED__Reaze\HeadlessBundle\ReazeHeadlessBundle"
  "scope" => "pimcore"
]

View formatted query View runnable query Explain query

SELECT
  *
FROM
  settings_store
WHERE
  id = :id
  AND scope = :scope

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Reaze\\HeadlessBundle\\ReazeHeadlessBundle' AND scope = 'pimcore';

0.52 ms
(6.12%)

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;;

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

http://feature-testfeature.schunk-pimcore.reaze.cloud/admin/login?perspective=

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache