Symfony Profiler

Queries

• SELECT users.* FROM bolt_users users
  
  Parameters: []
  Time: 0.10 ms
• SELECT t.*, GROUP_CONCAT(incomingrelation.id) as _incomingrelation_id, GROUP_CONCAT(incomingrelation.from_id) as _incomingrelation_fromid, GROUP_CONCAT(incomingrelation.from_contenttype) as _incomingrelation_fromcontenttype FROM bolt_homepage t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='homepage' WHERE (t.status = :status) AND (status = :status) AND (datepublish < :currenttime) GROUP BY t.id
  
  Parameters: {"currenttime":{"date":"2020-12-29 20:54:16.772456","timezone_type":3,"timezone":"Europe\/Zurich"},"status":"timed"}
  Time: 1.80 ms
• SELECT t.*, GROUP_CONCAT(incomingrelation.id) as _incomingrelation_id, GROUP_CONCAT(incomingrelation.from_id) as _incomingrelation_fromid, GROUP_CONCAT(incomingrelation.from_contenttype) as _incomingrelation_fromcontenttype, GROUP_CONCAT(groups.sortorder, '|') as _groups_sortorder, GROUP_CONCAT(groups.id, '|') as _groups_id, GROUP_CONCAT(groups.slug, '|') as _groups_slug, GROUP_CONCAT(groups.name, '|') as _groups_name, GROUP_CONCAT(groups.taxonomytype, '|') as _groups_taxonomytype FROM bolt_pages t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='pages' LEFT JOIN bolt_taxonomy "groups" ON t.id = "groups".content_id AND "groups".contenttype='pages' AND "groups".taxonomytype='groups' WHERE (t.status = :status) AND (status = :status) AND (datepublish < :currenttime) GROUP BY t.id, t.id
  
  Parameters: {"currenttime":{"date":"2020-12-29 20:54:16.781640","timezone_type":3,"timezone":"Europe\/Zurich"},"status":"timed"}
  Time: 0.25 ms
• SELECT t.*, GROUP_CONCAT(pages.id) as _pages_id, GROUP_CONCAT(pages.to_id) as _pages_toid, GROUP_CONCAT(incomingrelation.id) as _incomingrelation_id, GROUP_CONCAT(incomingrelation.from_id) as _incomingrelation_fromid, GROUP_CONCAT(incomingrelation.from_contenttype) as _incomingrelation_fromcontenttype, GROUP_CONCAT(categories.id, '|') as _categories_id, GROUP_CONCAT(categories.slug, '|') as _categories_slug, GROUP_CONCAT(categories.name, '|') as _categories_name, GROUP_CONCAT(categories.taxonomytype, '|') as _categories_taxonomytype, GROUP_CONCAT(tags.id, '|') as _tags_id, GROUP_CONCAT(tags.slug, '|') as _tags_slug, GROUP_CONCAT(tags.name, '|') as _tags_name, GROUP_CONCAT(tags.taxonomytype, '|') as _tags_taxonomytype FROM bolt_entries t LEFT JOIN bolt_relations pages ON t.id = pages.from_id AND pages.from_contenttype='entries' AND pages.to_contenttype='pages' LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='entries' LEFT JOIN bolt_taxonomy "categories" ON t.id = "categories".content_id AND "categories".contenttype='entries' AND "categories".taxonomytype='categories' LEFT JOIN bolt_taxonomy "tags" ON t.id = "tags".content_id AND "tags".contenttype='entries' AND "tags".taxonomytype='tags' WHERE (t.status = :status) AND (status = :status) AND (datepublish < :currenttime) GROUP BY t.id, t.id, t.id, t.id
  
  Parameters: {"currenttime":{"date":"2020-12-29 20:54:16.784307","timezone_type":3,"timezone":"Europe\/Zurich"},"status":"timed"}
  Time: 0.63 ms
• SELECT t.*, GROUP_CONCAT(entries.id) as _entries_id, GROUP_CONCAT(entries.to_id) as _entries_toid, GROUP_CONCAT(pages.id) as _pages_id, GROUP_CONCAT(pages.to_id) as _pages_toid, GROUP_CONCAT(incomingrelation.id) as _incomingrelation_id, GROUP_CONCAT(incomingrelation.from_id) as _incomingrelation_fromid, GROUP_CONCAT(incomingrelation.from_contenttype) as _incomingrelation_fromcontenttype, GROUP_CONCAT(categories.id, '|') as _categories_id, GROUP_CONCAT(categories.slug, '|') as _categories_slug, GROUP_CONCAT(categories.name, '|') as _categories_name, GROUP_CONCAT(categories.taxonomytype, '|') as _categories_taxonomytype, GROUP_CONCAT(tags.id, '|') as _tags_id, GROUP_CONCAT(tags.slug, '|') as _tags_slug, GROUP_CONCAT(tags.name, '|') as _tags_name, GROUP_CONCAT(tags.taxonomytype, '|') as _tags_taxonomytype, (SELECT GROUP_CONCAT(DISTINCT f.name||'_'||f.grouping||'_'||f.id) FROM bolt_field_value f WHERE f.content_id = t.id AND f.contenttype='showcases' AND f.name = 'repeater') as repeater FROM bolt_showcases t LEFT JOIN bolt_relations entries ON t.id = entries.from_id AND entries.from_contenttype='showcases' AND entries.to_contenttype='entries' LEFT JOIN bolt_relations pages ON t.id = pages.from_id AND pages.from_contenttype='showcases' AND pages.to_contenttype='pages' LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='showcases' LEFT JOIN bolt_taxonomy "categories" ON t.id = "categories".content_id AND "categories".contenttype='showcases' AND "categories".taxonomytype='categories' LEFT JOIN bolt_taxonomy "tags" ON t.id = "tags".content_id AND "tags".contenttype='showcases' AND "tags".taxonomytype='tags' WHERE (t.status = :status) AND (status = :status) AND (datepublish < :currenttime) GROUP BY t.id, t.id, t.id, t.id, t.id
  
  Parameters: {"currenttime":{"date":"2020-12-29 20:54:16.786345","timezone_type":3,"timezone":"Europe\/Zurich"},"status":"timed"}
  Time: 0.45 ms
• SELECT t.*, GROUP_CONCAT(incomingrelation.id) as _incomingrelation_id, GROUP_CONCAT(incomingrelation.from_id) as _incomingrelation_fromid, GROUP_CONCAT(incomingrelation.from_contenttype) as _incomingrelation_fromcontenttype FROM bolt_blocks t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='blocks' WHERE (t.status = :status) AND (status = :status) AND (datepublish < :currenttime) GROUP BY t.id
  
  Parameters: {"currenttime":{"date":"2020-12-29 20:54:16.801759","timezone_type":3,"timezone":"Europe\/Zurich"},"status":"timed"}
  Time: 0.15 ms
• SELECT t.*, GROUP_CONCAT(incomingrelation.id) as _incomingrelation_id, GROUP_CONCAT(incomingrelation.from_id) as _incomingrelation_fromid, GROUP_CONCAT(incomingrelation.from_contenttype) as _incomingrelation_fromcontenttype FROM bolt_homepage t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='homepage' WHERE (t.status = :status) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish) GROUP BY t.id
  
  Parameters: {"currenttime":{"date":"2020-12-29 20:54:16.804444","timezone_type":3,"timezone":"Europe\/Zurich"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 0.18 ms
• SELECT t.*, GROUP_CONCAT(incomingrelation.id) as _incomingrelation_id, GROUP_CONCAT(incomingrelation.from_id) as _incomingrelation_fromid, GROUP_CONCAT(incomingrelation.from_contenttype) as _incomingrelation_fromcontenttype, GROUP_CONCAT(groups.sortorder, '|') as _groups_sortorder, GROUP_CONCAT(groups.id, '|') as _groups_id, GROUP_CONCAT(groups.slug, '|') as _groups_slug, GROUP_CONCAT(groups.name, '|') as _groups_name, GROUP_CONCAT(groups.taxonomytype, '|') as _groups_taxonomytype FROM bolt_pages t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='pages' LEFT JOIN bolt_taxonomy "groups" ON t.id = "groups".content_id AND "groups".contenttype='pages' AND "groups".taxonomytype='groups' WHERE (t.status = :status) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish) GROUP BY t.id, t.id
  
  Parameters: {"currenttime":{"date":"2020-12-29 20:54:16.804785","timezone_type":3,"timezone":"Europe\/Zurich"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 0.19 ms
• SELECT t.*, GROUP_CONCAT(pages.id) as _pages_id, GROUP_CONCAT(pages.to_id) as _pages_toid, GROUP_CONCAT(incomingrelation.id) as _incomingrelation_id, GROUP_CONCAT(incomingrelation.from_id) as _incomingrelation_fromid, GROUP_CONCAT(incomingrelation.from_contenttype) as _incomingrelation_fromcontenttype, GROUP_CONCAT(categories.id, '|') as _categories_id, GROUP_CONCAT(categories.slug, '|') as _categories_slug, GROUP_CONCAT(categories.name, '|') as _categories_name, GROUP_CONCAT(categories.taxonomytype, '|') as _categories_taxonomytype, GROUP_CONCAT(tags.id, '|') as _tags_id, GROUP_CONCAT(tags.slug, '|') as _tags_slug, GROUP_CONCAT(tags.name, '|') as _tags_name, GROUP_CONCAT(tags.taxonomytype, '|') as _tags_taxonomytype FROM bolt_entries t LEFT JOIN bolt_relations pages ON t.id = pages.from_id AND pages.from_contenttype='entries' AND pages.to_contenttype='pages' LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='entries' LEFT JOIN bolt_taxonomy "categories" ON t.id = "categories".content_id AND "categories".contenttype='entries' AND "categories".taxonomytype='categories' LEFT JOIN bolt_taxonomy "tags" ON t.id = "tags".content_id AND "tags".contenttype='entries' AND "tags".taxonomytype='tags' WHERE (t.status = :status) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish) GROUP BY t.id, t.id, t.id, t.id
  
  Parameters: {"currenttime":{"date":"2020-12-29 20:54:16.805167","timezone_type":3,"timezone":"Europe\/Zurich"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 0.23 ms
• SELECT t.*, GROUP_CONCAT(entries.id) as _entries_id, GROUP_CONCAT(entries.to_id) as _entries_toid, GROUP_CONCAT(pages.id) as _pages_id, GROUP_CONCAT(pages.to_id) as _pages_toid, GROUP_CONCAT(incomingrelation.id) as _incomingrelation_id, GROUP_CONCAT(incomingrelation.from_id) as _incomingrelation_fromid, GROUP_CONCAT(incomingrelation.from_contenttype) as _incomingrelation_fromcontenttype, GROUP_CONCAT(categories.id, '|') as _categories_id, GROUP_CONCAT(categories.slug, '|') as _categories_slug, GROUP_CONCAT(categories.name, '|') as _categories_name, GROUP_CONCAT(categories.taxonomytype, '|') as _categories_taxonomytype, GROUP_CONCAT(tags.id, '|') as _tags_id, GROUP_CONCAT(tags.slug, '|') as _tags_slug, GROUP_CONCAT(tags.name, '|') as _tags_name, GROUP_CONCAT(tags.taxonomytype, '|') as _tags_taxonomytype, (SELECT GROUP_CONCAT(DISTINCT f.name||'_'||f.grouping||'_'||f.id) FROM bolt_field_value f WHERE f.content_id = t.id AND f.contenttype='showcases' AND f.name = 'repeater') as repeater FROM bolt_showcases t LEFT JOIN bolt_relations entries ON t.id = entries.from_id AND entries.from_contenttype='showcases' AND entries.to_contenttype='entries' LEFT JOIN bolt_relations pages ON t.id = pages.from_id AND pages.from_contenttype='showcases' AND pages.to_contenttype='pages' LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='showcases' LEFT JOIN bolt_taxonomy "categories" ON t.id = "categories".content_id AND "categories".contenttype='showcases' AND "categories".taxonomytype='categories' LEFT JOIN bolt_taxonomy "tags" ON t.id = "tags".content_id AND "tags".contenttype='showcases' AND "tags".taxonomytype='tags' WHERE (t.status = :status) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish) GROUP BY t.id, t.id, t.id, t.id, t.id
  
  Parameters: {"currenttime":{"date":"2020-12-29 20:54:16.805590","timezone_type":3,"timezone":"Europe\/Zurich"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 0.29 ms
• SELECT t.*, GROUP_CONCAT(incomingrelation.id) as _incomingrelation_id, GROUP_CONCAT(incomingrelation.from_id) as _incomingrelation_fromid, GROUP_CONCAT(incomingrelation.from_contenttype) as _incomingrelation_fromcontenttype FROM bolt_blocks t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='blocks' WHERE (t.status = :status) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish) GROUP BY t.id
  
  Parameters: {"currenttime":{"date":"2020-12-29 20:54:16.806094","timezone_type":3,"timezone":"Europe\/Zurich"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 0.16 ms
• SELECT name FROM sqlite_master WHERE type = 'table' AND name != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name
  
  Parameters: []
  Time: 0.19 ms
• SELECT bolt_homepage.* FROM bolt_homepage WHERE ("bolt_homepage"."id" = '1' AND "bolt_homepage"."status" = 'published') ORDER BY "datepublish" DESC LIMIT 1
  
  Parameters: []
  Time: 0.12 ms
• SELECT bolt_entries.* FROM bolt_entries WHERE ("bolt_entries"."id" = '1' AND "bolt_entries"."status" = 'published') ORDER BY "datepublish" DESC LIMIT 1
  
  Parameters: []
  Time: 0.18 ms
• SELECT bolt_entries.* FROM bolt_entries WHERE ("bolt_entries"."id" = '2' AND "bolt_entries"."status" = 'published') ORDER BY "datepublish" DESC LIMIT 1
  
  Parameters: []
  Time: 0.10 ms
• SELECT bolt_entries.* FROM bolt_entries WHERE ("bolt_entries"."id" = '3' AND "bolt_entries"."status" = 'published') ORDER BY "datepublish" DESC LIMIT 1
  
  Parameters: []
  Time: 0.08 ms
• SELECT bolt_entries.* FROM bolt_entries WHERE ("bolt_entries"."id" = '4' AND "bolt_entries"."status" = 'published') ORDER BY "datepublish" DESC LIMIT 1
  
  Parameters: []
  Time: 0.08 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE ("bolt_pages"."id" = '3' AND "bolt_pages"."status" = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 0.08 ms
• SELECT bolt_homepage.* FROM bolt_homepage WHERE ("bolt_homepage"."status" = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 0.18 ms
• SELECT bolt_blocks.* FROM bolt_blocks WHERE ("bolt_blocks"."slug" = 'about-us' AND "bolt_blocks"."status" = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 0.17 ms
• SELECT COUNT(*) as count FROM bolt_pages WHERE ("bolt_pages"."status" = 'published')
  
  Parameters: []
  Time: 0.08 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE ("bolt_pages"."status" = 'published') ORDER BY "datepublish" DESC LIMIT 3
  
  Parameters: []
  Time: 0.08 ms
• SELECT COUNT(*) as count FROM bolt_entries WHERE ("bolt_entries"."status" = 'published')
  
  Parameters: []
  Time: 0.06 ms
• SELECT bolt_entries.* FROM bolt_entries WHERE ("bolt_entries"."status" = 'published') ORDER BY "datepublish" DESC LIMIT 3
  
  Parameters: []
  Time: 0.07 ms
• SELECT COUNT(*) as count FROM bolt_pages WHERE ("bolt_pages"."status" = 'published')
  
  Parameters: []
  Time: 0.07 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE ("bolt_pages"."status" = 'published') ORDER BY "datepublish" DESC LIMIT 5
  
  Parameters: []
  Time: 0.08 ms
• SELECT COUNT(*) as count FROM bolt_entries WHERE ("bolt_entries"."status" = 'published')
  
  Parameters: []
  Time: 0.05 ms
• SELECT bolt_entries.* FROM bolt_entries WHERE ("bolt_entries"."status" = 'published') ORDER BY "datepublish" DESC LIMIT 5
  
  Parameters: []
  Time: 0.10 ms
• SELECT COUNT(*) as count FROM bolt_showcases WHERE ("bolt_showcases"."status" = 'published')
  
  Parameters: []
  Time: 0.06 ms
• SELECT bolt_showcases.* FROM bolt_showcases WHERE ("bolt_showcases"."status" = 'published') ORDER BY "datepublish" DESC LIMIT 5
  
  Parameters: []
  Time: 0.11 ms