Symfony Profiler

• Pimcore
• Request / Response
• Performance
• Validator
• Exception
• Logs
• 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 (?)

[
  1757109316
  "site_domain_7a5580d16d8f60478778f9fe8d471130"
]

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

SELECT * FROM tmp_store WHERE id = ?

[
  "maintenance_mode"
]

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

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

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

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

[
  "_auto_ef447ca4d6badf317345433c12d3b5c0"
  "pimcore_image_thumbnails"
]

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

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

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

[
  1757109316
  "output\x01tags\x01"
  "navigation\x01tags\x01"
  "document_109\x01tags\x01"
  "document_110\x01tags\x01"
  "document_111\x01tags\x01"
  "document_113\x01tags\x01"
  "document_112\x01tags\x01"
  "document_96\x01tags\x01"
  "document_115\x01tags\x01"
  "document_116\x01tags\x01"
  "document_117\x01tags\x01"
  "document_118\x01tags\x01"
  "document_119\x01tags\x01"
  "document_121\x01tags\x01"
  "document_127\x01tags\x01"
  "document_122\x01tags\x01"
  "document_125\x01tags\x01"
  "document_114\x01tags\x01"
  "document_126\x01tags\x01"
  "document_124\x01tags\x01"
  "document_123\x01tags\x01"
  "document_93\x01tags\x01"
  "document_108\x01tags\x01"
  "document_98\x01tags\x01"
  "document_100\x01tags\x01"
  "document_99\x01tags\x01"
  "document_107\x01tags\x01"
  "document_106\x01tags\x01"
  "document_105\x01tags\x01"
  "document_104\x01tags\x01"
  "document_101\x01tags\x01"
  "document_103\x01tags\x01"
  "document_102\x01tags\x01"
  "document_94\x01tags\x01"
  "document_95\x01tags\x01"
  "document_92\x01tags\x01"
  "document_134\x01tags\x01"
  "document_136\x01tags\x01"
  "document_137\x01tags\x01"
  "document_138\x01tags\x01"
  "document_139\x01tags\x01"
  "document_135\x01tags\x01"
  "document_130\x01tags\x01"
  "document_141\x01tags\x01"
  "document_142\x01tags\x01"
  "document_140\x01tags\x01"
  "document_131\x01tags\x01"
  "document_132\x01tags\x01"
  "document_129\x01tags\x01"
  "document_29\x01tags\x01"
  "document_150\x01tags\x01"
  "document_152\x01tags\x01"
  "document_32\x01tags\x01"
  "document_151\x01tags\x01"
  "document_33\x01tags\x01"
  "document_18\x01tags\x01"
  "document_31\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 > 1757109316 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output
tags
', 'navigation
tags
', 'document_109
tags
', 'document_110
tags
', 'document_111
tags
', 'document_113
tags
', 'document_112
tags
', 'document_96
tags
', 'document_115
tags
', 'document_116
tags
', 'document_117
tags
', 'document_118
tags
', 'document_119
tags
', 'document_121
tags
', 'document_127
tags
', 'document_122
tags
', 'document_125
tags
', 'document_114
tags
', 'document_126
tags
', 'document_124
tags
', 'document_123
tags
', 'document_93
tags
', 'document_108
tags
', 'document_98
tags
', 'document_100
tags
', 'document_99
tags
', 'document_107
tags
', 'document_106
tags
', 'document_105
tags
', 'document_104
tags
', 'document_101
tags
', 'document_103
tags
', 'document_102
tags
', 'document_94
tags
', 'document_95
tags
', 'document_92
tags
', 'document_134
tags
', 'document_136
tags
', 'document_137
tags
', 'document_138
tags
', 'document_139
tags
', 'document_135
tags
', 'document_130
tags
', 'document_141
tags
', 'document_142
tags
', 'document_140
tags
', 'document_131
tags
', 'document_132
tags
', 'document_129
tags
', 'document_29
tags
', 'document_150
tags
', 'document_152
tags
', 'document_32
tags
', 'document_151
tags
', 'document_33
tags
', 'document_18
tags
', 'document_31
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 (?, ?, ?)

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

SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?

[
  290
]

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 290;

SELECT customSettings FROM assets WHERE id = ?

[
  290
]

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 290;

SELECT * FROM object_url_slugs WHERE slug = '/logistics_equipment/service_programme/floor_protection_fleece' AND (siteId = 2 OR siteId = 0) ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/logistics_equipment/service_programme/floor_protection_fleece'
  AND (
    siteId = 2
    OR siteId = 0
  )
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/logistics_equipment/service_programme/floor_protection_fleece' AND (siteId = 2 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?

[
  "/en/%"
  "/logistics_equipment/service_programme/floor_protection_fleece"
]

SELECT
  documents.id
FROM
  documents
  LEFT JOIN documents_page ON documents.id = documents_page.id
WHERE
  documents.path LIKE ?
  AND documents_page.prettyUrl = ?

SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE '/en/%' AND documents_page.prettyUrl = '/logistics_equipment/service_programme/floor_protection_fleece';

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

[
  "/en/logistics_equipment/service_programme/"
  "floor_protection_fleece"
]

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

SELECT id FROM documents WHERE `path` = BINARY '/en/logistics_equipment/service_programme/' AND `key` = BINARY 'floor_protection_fleece';

SELECT * FROM documents_editables WHERE documentId = ?

[
  98
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 98;

SELECT id FROM documents_page WHERE prettyUrl = ?

[
  "/en/logistics_equipment/service_programme/floor_protection_fleece"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/en/logistics_equipment/service_programme/floor_protection_fleece';

SELECT * FROM translations_messages LIMIT 1;

[]

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;