Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

10 Database Queries

3 Different statements

5.57 ms Query time

0 Invalid entities

Time▼	Count	Info
2.68 ms (48.08%)	5	SELECT id FROM documents WHERE path = :path AND `key` = :key Parameters: [`"key" => "create-store" "path" => "/admin/classificationstore/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = : path AND `key` = : key SELECT id FROM documents WHERE path = '/admin/classificationstore/' AND `key` = 'create-store';
2.32 ms (41.56%)	4	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/admin/classificationstore/create-store"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = : prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/admin/classificationstore/create-store';
0.58 ms (10.35%)	1	SELECT * FROM object_url_slugs WHERE slug = '/admin/classificationstore/create-store' AND siteId = '0' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/admin/classificationstore/create-store' AND siteId = '0' SELECT * FROM object_url_slugs WHERE slug = '/admin/classificationstore/create-store' AND siteId = '0';

Time▼

Count

Info

2.68 ms
(48.08%)

SELECT id FROM documents WHERE path = :path AND `key` = :key

Parameters:

[
  "key" => "create-store"
  "path" => "/admin/classificationstore/"
]

View formatted query View runnable query Explain query

SELECT 
  id 
FROM 
  documents 
WHERE 
  path = : path 
  AND `key` = : key

SELECT id FROM documents WHERE path = '/admin/classificationstore/' AND `key` = 'create-store';

2.32 ms
(41.56%)

SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl

Parameters:

[
  "prettyUrl" => "/admin/classificationstore/create-store"
]

View formatted query View runnable query Explain query

SELECT 
  id 
FROM 
  documents_page 
WHERE 
  prettyUrl = : prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/admin/classificationstore/create-store';

0.58 ms
(10.35%)

SELECT * FROM object_url_slugs WHERE slug = '/admin/classificationstore/create-store' AND siteId = '0'

Parameters:

[]

View formatted query View runnable query Explain query

SELECT 
  * 
FROM 
  object_url_slugs 
WHERE 
  slug = '/admin/classificationstore/create-store' 
  AND siteId = '0'

SELECT * FROM object_url_slugs WHERE slug = '/admin/classificationstore/create-store' AND siteId = '0';

Name	Service
default	doctrine.dbal.default_connection