Symfony Profiler

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

[
  1762120402
  "site_domain_acb4e494e0c66d128fa7d826d0416529"
]

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

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

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

SELECT object_Blogs.id AS id, object_Blogs.type AS `type` FROM object_Blogs WHERE (`url` = 'how-to-attract-higher-paying-clients'  AND  object_Blogs.type IN ('variant','object')) AND object_Blogs.published = 1 LIMIT 1

[]

SELECT
  object_Blogs.id AS id,
  object_Blogs.type AS `type`
FROM
  object_Blogs
WHERE
  (
    `url` = 'how-to-attract-higher-paying-clients'
    AND object_Blogs.type IN ('variant', 'object')
  )
  AND object_Blogs.published = 1
LIMIT
  1

SELECT object_Blogs.id AS id, object_Blogs.type AS `type` FROM object_Blogs WHERE (`url` = 'how-to-attract-higher-paying-clients'  AND  object_Blogs.type IN ('variant','object')) AND object_Blogs.published = 1 LIMIT 1;

SELECT object_Blogs.id AS id, object_Blogs.type AS `type` FROM object_Blogs WHERE (url != ? AND  object_Blogs.type IN ('object','variant','folder')) AND object_Blogs.published = 1 LIMIT 3

[
  "how-to-attract-higher-paying-clients"
]

SELECT
  object_Blogs.id AS id,
  object_Blogs.type AS `type`
FROM
  object_Blogs
WHERE
  (
    url != ?
    AND object_Blogs.type IN ('object', 'variant', 'folder')
  )
  AND object_Blogs.published = 1
LIMIT
  3

SELECT object_Blogs.id AS id, object_Blogs.type AS `type` FROM object_Blogs WHERE (url != 'how-to-attract-higher-paying-clients' AND  object_Blogs.type IN ('object','variant','folder')) AND object_Blogs.published = 1 LIMIT 3;

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

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

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

[
  "/blog/"
  "how-to-attract-higher-paying-clients"
]

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

SELECT id FROM documents WHERE `path` = BINARY '/blog/' AND `key` = BINARY 'how-to-attract-higher-paying-clients';

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

[
  1762120402
  "output\x01tags\x01"
  "navigation\x01tags\x01"
  "document_2\x01tags\x01"
  "document_4\x01tags\x01"
  "document_28\x01tags\x01"
  "document_32\x01tags\x01"
  "document_33\x01tags\x01"
  "document_34\x01tags\x01"
  "document_35\x01tags\x01"
  "document_6\x01tags\x01"
  "document_5\x01tags\x01"
  "document_7\x01tags\x01"
  "document_8\x01tags\x01"
  "document_9\x01tags\x01"
  "document_23\x01tags\x01"
  "document_24\x01tags\x01"
  "document_25\x01tags\x01"
  "document_41\x01tags\x01"
  "document_21\x01tags\x01"
  "document_10\x01tags\x01"
  "document_12\x01tags\x01"
  "document_17\x01tags\x01"
  "document_18\x01tags\x01"
  "document_19\x01tags\x01"
  "document_20\x01tags\x01"
  "document_11\x01tags\x01"
  "document_26\x01tags\x01"
  "document_27\x01tags\x01"
  "document_37\x01tags\x01"
  "document_39\x01tags\x01"
  "document_40\x01tags\x01"
  "document_42\x01tags\x01"
  "document_43\x01tags\x01"
  "document_44\x01tags\x01"
  "document_45\x01tags\x01"
  "document_46\x01tags\x01"
  "document_36\x01tags\x01"
  "document_29\x01tags\x01"
  "document_48\x01tags\x01"
  "document_49\x01tags\x01"
  "document_47\x01tags\x01"
  "document_53\x01tags\x01"
  "document_52\x01tags\x01"
  "document_51\x01tags\x01"
  "document_50\x01tags\x01"
  "document_55\x01tags\x01"
  "document_56\x01tags\x01"
  "document_57\x01tags\x01"
  "document_58\x01tags\x01"
  "document_59\x01tags\x01"
  "document_60\x01tags\x01"
  "document_61\x01tags\x01"
  "document_62\x01tags\x01"
  "document_63\x01tags\x01"
  "document_64\x01tags\x01"
  "document_65\x01tags\x01"
  "document_66\x01tags\x01"
  "document_67\x01tags\x01"
  "document_68\x01tags\x01"
  "document_69\x01tags\x01"
  "document_70\x01tags\x01"
  "document_71\x01tags\x01"
  "document_72\x01tags\x01"
  "document_73\x01tags\x01"
  "document_74\x01tags\x01"
  "document_54\x01tags\x01"
  "document_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 > 1762120402 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output
tags
', 'navigation
tags
', 'document_2
tags
', 'document_4
tags
', 'document_28
tags
', 'document_32
tags
', 'document_33
tags
', 'document_34
tags
', 'document_35
tags
', 'document_6
tags
', 'document_5
tags
', 'document_7
tags
', 'document_8
tags
', 'document_9
tags
', 'document_23
tags
', 'document_24
tags
', 'document_25
tags
', 'document_41
tags
', 'document_21
tags
', 'document_10
tags
', 'document_12
tags
', 'document_17
tags
', 'document_18
tags
', 'document_19
tags
', 'document_20
tags
', 'document_11
tags
', 'document_26
tags
', 'document_27
tags
', 'document_37
tags
', 'document_39
tags
', 'document_40
tags
', 'document_42
tags
', 'document_43
tags
', 'document_44
tags
', 'document_45
tags
', 'document_46
tags
', 'document_36
tags
', 'document_29
tags
', 'document_48
tags
', 'document_49
tags
', 'document_47
tags
', 'document_53
tags
', 'document_52
tags
', 'document_51
tags
', 'document_50
tags
', 'document_55
tags
', 'document_56
tags
', 'document_57
tags
', 'document_58
tags
', 'document_59
tags
', 'document_60
tags
', 'document_61
tags
', 'document_62
tags
', 'document_63
tags
', 'document_64
tags
', 'document_65
tags
', 'document_66
tags
', 'document_67
tags
', 'document_68
tags
', 'document_69
tags
', 'document_70
tags
', 'document_71
tags
', 'document_72
tags
', 'document_73
tags
', 'document_74
tags
', 'document_54
tags
', 'document_75
tags
');

SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?

[
  311
]

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 311;

SELECT * FROM object_relations_Blogs WHERE src_id = ?

[
  134
]

SELECT
  *
FROM
  object_relations_Blogs
WHERE
  src_id = ?

SELECT * FROM object_relations_Blogs WHERE src_id = 134;

SELECT * FROM tmp_store WHERE id = ?

[
  "maintenance_mode"
]

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

SELECT customSettings FROM assets WHERE id = ?

[
  311
]

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 311;

SELECT name FROM classes WHERE id = ?

[
  "Blogs"
]

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'Blogs';

SELECT id FROM documents_page WHERE prettyUrl = ?

[
  "/blog/how-to-attract-higher-paying-clients"
]

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/blog/how-to-attract-higher-paying-clients';

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

[
  1762120402
  "document_1\x01tags\x01"
  "asset_5\x01tags\x01"
  "asset_8\x01tags\x01"
  "asset_9\x01tags\x01"
  "asset_10\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 > 1762120402 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1
tags
', 'asset_5
tags
', 'asset_8
tags
', 'asset_9
tags
', 'asset_10
tags
', 'asset_7
tags
');