Symfony Profiler

• OpenDXP
• Request / Response
• Performance
• Validator
• Exception
• Logs 29
• Events
• Routing
• Cache
• Translation 2
• Security
• Twig
• Doctrine
• Debug
• Messages
• Emails
• Serializer
• Configuration

Query Metrics

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

[
  "BUNDLE_INSTALLED__OpenDxp\Bundle\SeoBundle\OpenDxpSeoBundle"
  "opendxp"
]

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

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__OpenDxp\\Bundle\\SeoBundle\\OpenDxpSeoBundle' AND scope = 'opendxp';

SELECT * FROM translations_admin WHERE `key` = ? AND `language` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY `creationDate`

[
  "Enter your username and opendxp will send a login link to your email address"
  "ca"
  "cs"
  "de"
  "en"
  "es"
  "fr"
  "hu"
  "it"
  "ja"
  "nl"
  "pl"
  "pt"
  "ru"
  "sk"
  "sv"
  "th"
  "tr"
  "uk"
  "zh_Hans"
]

SELECT
  *
FROM
  translations_admin
WHERE
  `key` = ?
  AND `language` IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )
ORDER BY
  `creationDate`

SELECT * FROM translations_admin WHERE `key` = 'Enter your username and opendxp will send a login link to your email address' AND `language` IN ('ca', 'cs', 'de', 'en', 'es', 'fr', 'hu', 'it', 'ja', 'nl', 'pl', 'pt', 'ru', 'sk', 'sv', 'th', 'tr', 'uk', 'zh_Hans') ORDER BY `creationDate`;

SELECT * FROM translations_admin LIMIT 1

[]

SELECT
  *
FROM
  translations_admin
LIMIT
  1

SELECT * FROM translations_admin LIMIT 1;

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 (?)

[
  1779463855
  "translation_data_2e364d315ad5ad984609e7f4beedf0f7"
]

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 > 1779463855 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translation_data_2e364d315ad5ad984609e7f4beedf0f7');

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 (?, ?)

[
  1779463855
  "translator\x01tags\x01"
  "translate\x01tags\x01"
]

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 > 1779463855 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translator
tags
', 'translate
tags
');

SELECT * FROM tmp_store WHERE id = ?

[
  "maintenance_mode"
]

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';