Symfony Profiler

Queries

• SET NAMES ? COLLATE ?
  
  Parameters: ["utf8","utf8_unicode_ci"]
  Time: 1,77 ms
• SET SESSION group_concat_max_len = ?
  
  Parameters: [100000]
  Time: 0,32 ms
• SELECT users.* FROM bolt_users users
  
  Parameters: []
  Time: 1,52 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":"2022-06-21 19:35:03.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"timed"}
  Time: 2,79 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 ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_sortorder, GROUP_CONCAT(groups.id ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_id, GROUP_CONCAT(groups.slug ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_slug, GROUP_CONCAT(groups.name ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_name, GROUP_CONCAT(groups.taxonomytype ORDER BY groups.sortorder ASC SEPARATOR '|') 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":"2022-06-21 19:35:03.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"timed"}
  Time: 2,93 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 ORDER BY categories.id ASC SEPARATOR '|') as _categories_id, GROUP_CONCAT(categories.slug ORDER BY categories.id ASC SEPARATOR '|') as _categories_slug, GROUP_CONCAT(categories.name ORDER BY categories.id ASC SEPARATOR '|') as _categories_name, GROUP_CONCAT(categories.taxonomytype ORDER BY categories.id ASC SEPARATOR '|') as _categories_taxonomytype, GROUP_CONCAT(tags.id ORDER BY tags.id ASC SEPARATOR '|') as _tags_id, GROUP_CONCAT(tags.slug ORDER BY tags.id ASC SEPARATOR '|') as _tags_slug, GROUP_CONCAT(tags.name ORDER BY tags.id ASC SEPARATOR '|') as _tags_name, GROUP_CONCAT(tags.taxonomytype ORDER BY tags.id ASC SEPARATOR '|') as _tags_taxonomytype FROM bolt_projets t LEFT JOIN bolt_relations pages ON t.id = pages.from_id AND pages.from_contenttype='projets' AND pages.to_contenttype='pages' LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='projets' LEFT JOIN bolt_taxonomy `categories` ON t.id = `categories`.content_id AND `categories`.contenttype='projets' AND `categories`.taxonomytype='categories' LEFT JOIN bolt_taxonomy `tags` ON t.id = `tags`.content_id AND `tags`.contenttype='projets' 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":"2022-06-21 19:35:03.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"timed"}
  Time: 2,61 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 ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_sortorder, GROUP_CONCAT(groups.id ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_id, GROUP_CONCAT(groups.slug ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_slug, GROUP_CONCAT(groups.name ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_name, GROUP_CONCAT(groups.taxonomytype ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_taxonomytype FROM bolt_competences t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='competences' LEFT JOIN bolt_taxonomy `groups` ON t.id = `groups`.content_id AND `groups`.contenttype='competences' AND `groups`.taxonomytype='groups' WHERE (t.status = :status) AND (status = :status) AND (datepublish < :currenttime) GROUP BY t.id, t.id
  
  Parameters: {"currenttime":{"date":"2022-06-21 19:35:03.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"timed"}
  Time: 1,91 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":"2022-06-21 19:35:03.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 2,03 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 ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_sortorder, GROUP_CONCAT(groups.id ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_id, GROUP_CONCAT(groups.slug ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_slug, GROUP_CONCAT(groups.name ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_name, GROUP_CONCAT(groups.taxonomytype ORDER BY groups.sortorder ASC SEPARATOR '|') 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":"2022-06-21 19:35:03.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 1,36 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 ORDER BY categories.id ASC SEPARATOR '|') as _categories_id, GROUP_CONCAT(categories.slug ORDER BY categories.id ASC SEPARATOR '|') as _categories_slug, GROUP_CONCAT(categories.name ORDER BY categories.id ASC SEPARATOR '|') as _categories_name, GROUP_CONCAT(categories.taxonomytype ORDER BY categories.id ASC SEPARATOR '|') as _categories_taxonomytype, GROUP_CONCAT(tags.id ORDER BY tags.id ASC SEPARATOR '|') as _tags_id, GROUP_CONCAT(tags.slug ORDER BY tags.id ASC SEPARATOR '|') as _tags_slug, GROUP_CONCAT(tags.name ORDER BY tags.id ASC SEPARATOR '|') as _tags_name, GROUP_CONCAT(tags.taxonomytype ORDER BY tags.id ASC SEPARATOR '|') as _tags_taxonomytype FROM bolt_projets t LEFT JOIN bolt_relations pages ON t.id = pages.from_id AND pages.from_contenttype='projets' AND pages.to_contenttype='pages' LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='projets' LEFT JOIN bolt_taxonomy `categories` ON t.id = `categories`.content_id AND `categories`.contenttype='projets' AND `categories`.taxonomytype='categories' LEFT JOIN bolt_taxonomy `tags` ON t.id = `tags`.content_id AND `tags`.contenttype='projets' 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":"2022-06-21 19:35:03.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 1,75 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 ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_sortorder, GROUP_CONCAT(groups.id ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_id, GROUP_CONCAT(groups.slug ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_slug, GROUP_CONCAT(groups.name ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_name, GROUP_CONCAT(groups.taxonomytype ORDER BY groups.sortorder ASC SEPARATOR '|') as _groups_taxonomytype FROM bolt_competences t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='competences' LEFT JOIN bolt_taxonomy `groups` ON t.id = `groups`.content_id AND `groups`.contenttype='competences' 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":"2022-06-21 19:35:03.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 1,43 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE (`bolt_pages`.`slug` = 'contact' AND `bolt_pages`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 1,27 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["1"],"pages",["tags","groups","categories"]]
  Time: 1,71 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["pages",["1"]]
  Time: 0,69 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["pages",["1"]]
  Time: 0,58 ms