Symfony Profiler

• Pimcore
• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 51
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine
• Debug
• Messages
• Emails
• Configuration

Query Metrics

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

[
  1783777227
  "site_domain_4e30aedb8e2c5fc83efd241a45e67258"
]

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

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

[
  1783777227
  "system\x01tags\x01"
  "site\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 > 1783777227 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'site
tags
');

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

[
  1783777227
  "output\x01tags\x01"
  "navigation\x01tags\x01"
  "document_172\x01tags\x01"
  "document_173\x01tags\x01"
  "document_174\x01tags\x01"
  "document_175\x01tags\x01"
  "document_168\x01tags\x01"
  "document_171\x01tags\x01"
  "document_96\x01tags\x01"
  "document_98\x01tags\x01"
  "document_184\x01tags\x01"
  "document_97\x01tags\x01"
  "document_99\x01tags\x01"
  "document_100\x01tags\x01"
  "document_104\x01tags\x01"
  "document_15\x01tags\x01"
  "document_95\x01tags\x01"
  "document_17\x01tags\x01"
  "document_6\x01tags\x01"
  "document_70\x01tags\x01"
  "document_110\x01tags\x01"
  "document_111\x01tags\x01"
  "document_115\x01tags\x01"
  "document_116\x01tags\x01"
  "document_127\x01tags\x01"
  "document_112\x01tags\x01"
  "document_8\x01tags\x01"
  "document_7\x01tags\x01"
  "document_54\x01tags\x01"
  "document_19\x01tags\x01"
  "document_20\x01tags\x01"
  "document_21\x01tags\x01"
  "document_11\x01tags\x01"
  "document_122\x01tags\x01"
  "document_155\x01tags\x01"
  "document_123\x01tags\x01"
  "document_12\x01tags\x01"
  "document_64\x01tags\x01"
  "document_65\x01tags\x01"
  "document_153\x01tags\x01"
  "document_66\x01tags\x01"
  "document_67\x01tags\x01"
  "document_158\x01tags\x01"
  "document_84\x01tags\x01"
  "document_85\x01tags\x01"
  "document_159\x01tags\x01"
  "document_86\x01tags\x01"
  "document_94\x01tags\x01"
  "document_156\x01tags\x01"
  "document_93\x01tags\x01"
  "document_74\x01tags\x01"
  "document_87\x01tags\x01"
  "document_162\x01tags\x01"
  "document_178\x01tags\x01"
  "document_180\x01tags\x01"
  "document_181\x01tags\x01"
  "document_182\x01tags\x01"
  "document_63\x01tags\x01"
  "document_73\x01tags\x01"
  "document_82\x01tags\x01"
  "document_83\x01tags\x01"
  "document_179\x01tags\x01"
  "document_72\x01tags\x01"
  "document_161\x01tags\x01"
  "document_160\x01tags\x01"
  "document_62\x01tags\x01"
  "document_22\x01tags\x01"
  "document_61\x01tags\x01"
  "document_152\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 > 1783777227 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output
tags
', 'navigation
tags
', 'document_172
tags
', 'document_173
tags
', 'document_174
tags
', 'document_175
tags
', 'document_168
tags
', 'document_171
tags
', 'document_96
tags
', 'document_98
tags
', 'document_184
tags
', 'document_97
tags
', 'document_99
tags
', 'document_100
tags
', 'document_104
tags
', 'document_15
tags
', 'document_95
tags
', 'document_17
tags
', 'document_6
tags
', 'document_70
tags
', 'document_110
tags
', 'document_111
tags
', 'document_115
tags
', 'document_116
tags
', 'document_127
tags
', 'document_112
tags
', 'document_8
tags
', 'document_7
tags
', 'document_54
tags
', 'document_19
tags
', 'document_20
tags
', 'document_21
tags
', 'document_11
tags
', 'document_122
tags
', 'document_155
tags
', 'document_123
tags
', 'document_12
tags
', 'document_64
tags
', 'document_65
tags
', 'document_153
tags
', 'document_66
tags
', 'document_67
tags
', 'document_158
tags
', 'document_84
tags
', 'document_85
tags
', 'document_159
tags
', 'document_86
tags
', 'document_94
tags
', 'document_156
tags
', 'document_93
tags
', 'document_74
tags
', 'document_87
tags
', 'document_162
tags
', 'document_178
tags
', 'document_180
tags
', 'document_181
tags
', 'document_182
tags
', 'document_63
tags
', 'document_73
tags
', 'document_82
tags
', 'document_83
tags
', 'document_179
tags
', 'document_72
tags
', 'document_161
tags
', 'document_160
tags
', 'document_62
tags
', 'document_22
tags
', 'document_61
tags
', 'document_152
tags
');

SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?

[
  "/bby.bws-tfo.com/"
  "babysitter-und-co"
]

SELECT
  id
FROM
  documents
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM documents WHERE `path` = BINARY '/bby.bws-tfo.com/' AND `key` = BINARY 'babysitter-und-co';

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

[
  1783777227
  "document_52\x01tags\x01"
  "asset_70\x01tags\x01"
  "document_97\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 > 1783777227 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_52
tags
', 'asset_70
tags
', 'document_97
tags
');

SELECT customSettings FROM assets WHERE id = ?

[
  75
]

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 75;

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

[
  "favicon"
  "pimcore_image_thumbnails"
]

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

SELECT * FROM settings_store WHERE id = 'favicon' AND scope = 'pimcore_image_thumbnails';

SELECT id FROM documents_page WHERE prettyUrl = ?

[
  "//footer"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '//footer';

SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?

[
  75
]

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 75;

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

[
  1783777227
  "website_config\x01tags\x01"
  "system\x01tags\x01"
  "config\x01tags\x01"
  "output\x01tags\x01"
  "asset_75\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 > 1783777227 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_config
tags
', 'system
tags
', 'config
tags
', 'output
tags
', 'asset_75
tags
');

SELECT * FROM tmp_store WHERE id = ?

[
  "maintenance_mode"
]

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

SELECT * FROM translations_messages LIMIT 1;

[]

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

SELECT * FROM translations_admin LIMIT 1;

[]

SELECT
  *
FROM
  translations_admin
LIMIT
  1;

SELECT * FROM translations_admin LIMIT 1;;

SELECT sourceId FROM documents_translations WHERE id = ?

[
  168
]

SELECT
  sourceId
FROM
  documents_translations
WHERE
  id = ?

SELECT sourceId FROM documents_translations WHERE id = 168;

SELECT * FROM object_url_slugs WHERE slug = '/babysitter-und-co' AND (siteId = 1 OR siteId = 0) ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/babysitter-und-co'
  AND (
    siteId = 1
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/babysitter-und-co' AND (siteId = 1 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

SELECT * FROM documents_editables WHERE documentId = ?

[
  168
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 168;

SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?

[
  168
  168
  168
]

SELECT
  id,
  language
FROM
  documents_translations
WHERE
  sourceId IN(?, ?)
UNION
SELECT
  sourceId as id,
  "source"
FROM
  documents_translations
WHERE
  id = ?

SELECT id,language FROM documents_translations WHERE sourceId IN(168, 168) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 168;