Symfony Profiler

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

[
  1783996978
  "site_domain_8d1db1fa9cb5292f870898f126262070"
]

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

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

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

SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC

[
  "/"
  "path"
  "auto_create"
  "/"
  "path_query"
  "http://www.geminipolska.com.pl/"
  "entire_uri"
]

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = ?
      AND (
        `type` = ?
        OR `type` = ?
      )
    )
    OR (
      source = ?
      AND `type` = ?
    )
    OR (
      source = ?
      AND `type` = ?
    )
  )
  AND active = 1
  AND (
    regex IS NULL
    OR regex = 0
  )
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/' AND `type` = 'path_query') OR
                (source = 'http://www.geminipolska.com.pl/' AND `type` = 'entire_uri')
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

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

[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]

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

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

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

[
  "/"
  ""
]

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

SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY '';

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

[
  1783996978
  "output\x01tags\x01"
  "navigation\x01tags\x01"
  "document_35\x01tags\x01"
  "document_33\x01tags\x01"
  "document_34\x01tags\x01"
  "document_2\x01tags\x01"
  "document_7\x01tags\x01"
  "document_3\x01tags\x01"
  "document_10\x01tags\x01"
  "document_11\x01tags\x01"
  "document_41\x01tags\x01"
  "document_12\x01tags\x01"
  "document_13\x01tags\x01"
  "document_43\x01tags\x01"
  "document_45\x01tags\x01"
  "document_42\x01tags\x01"
  "document_15\x01tags\x01"
  "document_16\x01tags\x01"
  "document_14\x01tags\x01"
  "document_27\x01tags\x01"
  "document_28\x01tags\x01"
  "document_30\x01tags\x01"
  "document_31\x01tags\x01"
  "document_32\x01tags\x01"
  "document_26\x01tags\x01"
  "document_17\x01tags\x01"
  "document_18\x01tags\x01"
  "document_19\x01tags\x01"
  "document_23\x01tags\x01"
  "document_24\x01tags\x01"
  "document_36\x01tags\x01"
  "document_48\x01tags\x01"
  "document_51\x01tags\x01"
  "document_56\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 > 1783996978 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output
tags
', 'navigation
tags
', 'document_35
tags
', 'document_33
tags
', 'document_34
tags
', 'document_2
tags
', 'document_7
tags
', 'document_3
tags
', 'document_10
tags
', 'document_11
tags
', 'document_41
tags
', 'document_12
tags
', 'document_13
tags
', 'document_43
tags
', 'document_45
tags
', 'document_42
tags
', 'document_15
tags
', 'document_16
tags
', 'document_14
tags
', 'document_27
tags
', 'document_28
tags
', 'document_30
tags
', 'document_31
tags
', 'document_32
tags
', 'document_26
tags
', 'document_17
tags
', 'document_18
tags
', 'document_19
tags
', 'document_23
tags
', 'document_24
tags
', 'document_36
tags
', 'document_48
tags
', 'document_51
tags
', 'document_56
tags
');

SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?

[
  566
]

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 566;

SELECT * FROM object_url_slugs WHERE slug = '/' AND siteId = 0 ORDER BY siteId DESC LIMIT 1

[]

SELECT
  *
FROM
  object_url_slugs
WHERE
  slug = '/'
  AND siteId = 0
ORDER BY
  siteId DESC
LIMIT
  1

SELECT * FROM object_url_slugs WHERE slug = '/' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;

SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC

[]

SELECT
  id
FROM
  sites
ORDER BY
  (
    SELECT
      LENGTH(
        CONCAT(`path`, `key`)
      )
    FROM
      documents
    WHERE
      documents.id = sites.rootId
  ) DESC

SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC ;

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

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

[
  1783996978
  "document_1\x01tags\x01"
  "asset_431\x01tags\x01"
  "asset_528\x01tags\x01"
  "asset_535\x01tags\x01"
  "asset_539\x01tags\x01"
  "asset_542\x01tags\x01"
  "asset_564\x01tags\x01"
  "asset_565\x01tags\x01"
  "asset_573\x01tags\x01"
  "asset_585\x01tags\x01"
  "asset_592\x01tags\x01"
  "asset_136\x01tags\x01"
  "asset_130\x01tags\x01"
  "asset_120\x01tags\x01"
  "asset_7\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 > 1783996978 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1
tags
', 'asset_431
tags
', 'asset_528
tags
', 'asset_535
tags
', 'asset_539
tags
', 'asset_542
tags
', 'asset_564
tags
', 'asset_565
tags
', 'asset_573
tags
', 'asset_585
tags
', 'asset_592
tags
', 'asset_136
tags
', 'asset_130
tags
', 'asset_120
tags
', 'asset_7
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 documents_editables WHERE documentId = ?

[
  4
]

SELECT
  *
FROM
  documents_editables
WHERE
  documentId = ?

SELECT * FROM documents_editables WHERE documentId = 4;

SELECT customSettings FROM assets WHERE id = ?

[
  566
]

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 566;