Symfony Profiler

Queries

• SET NAMES ? COLLATE ?
  
  Parameters: ["utf8","utf8_unicode_ci"]
  Time: 4,59 ms
• SET SESSION group_concat_max_len = ?
  
  Parameters: [100000]
  Time: 1,40 ms
• SELECT users.* FROM bolt_users users
  
  Parameters: []
  Time: 4,70 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":"2024-09-28 15:47:00.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"timed"}
  Time: 5,90 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_soins t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='soins' WHERE (t.status = :status) AND (status = :status) AND (datepublish < :currenttime) GROUP BY t.id
  
  Parameters: {"currenttime":{"date":"2024-09-28 15:47:00.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"timed"}
  Time: 2,76 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_champs t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='champs' WHERE (t.status = :status) AND (status = :status) AND (datepublish < :currenttime) GROUP BY t.id
  
  Parameters: {"currenttime":{"date":"2024-09-28 15:47:00.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"timed"}
  Time: 2,49 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(categoriesfaqs.id ORDER BY categoriesfaqs.id ASC SEPARATOR '|') as _categoriesfaqs_id, GROUP_CONCAT(categoriesfaqs.slug ORDER BY categoriesfaqs.id ASC SEPARATOR '|') as _categoriesfaqs_slug, GROUP_CONCAT(categoriesfaqs.name ORDER BY categoriesfaqs.id ASC SEPARATOR '|') as _categoriesfaqs_name, GROUP_CONCAT(categoriesfaqs.taxonomytype ORDER BY categoriesfaqs.id ASC SEPARATOR '|') as _categoriesfaqs_taxonomytype FROM bolt_faqs t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='faqs' LEFT JOIN bolt_taxonomy `categoriesfaqs` ON t.id = `categoriesfaqs`.content_id AND `categoriesfaqs`.contenttype='faqs' AND `categoriesfaqs`.taxonomytype='categoriesfaqs' WHERE (t.status = :status) AND (status = :status) AND (datepublish < :currenttime) GROUP BY t.id, t.id
  
  Parameters: {"currenttime":{"date":"2024-09-28 15:47:00.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"timed"}
  Time: 3,41 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_temoignages t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='temoignages' WHERE (t.status = :status) AND (status = :status) AND (datepublish < :currenttime) GROUP BY t.id
  
  Parameters: {"currenttime":{"date":"2024-09-28 15:47:00.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"timed"}
  Time: 2,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, GROUP_CONCAT(groups.id ORDER BY groups.id ASC SEPARATOR '|') as _groups_id, GROUP_CONCAT(groups.slug ORDER BY groups.id ASC SEPARATOR '|') as _groups_slug, GROUP_CONCAT(groups.name ORDER BY groups.id ASC SEPARATOR '|') as _groups_name, GROUP_CONCAT(groups.taxonomytype ORDER BY groups.id 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":"2024-09-28 15:47:00.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"timed"}
  Time: 2,85 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":"2024-09-28 15:47:00.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 1,31 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_soins t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='soins' WHERE (t.status = :status) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish) GROUP BY t.id
  
  Parameters: {"currenttime":{"date":"2024-09-28 15:47:00.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 1,20 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_champs t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='champs' WHERE (t.status = :status) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish) GROUP BY t.id
  
  Parameters: {"currenttime":{"date":"2024-09-28 15:47:00.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 1,14 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(categoriesfaqs.id ORDER BY categoriesfaqs.id ASC SEPARATOR '|') as _categoriesfaqs_id, GROUP_CONCAT(categoriesfaqs.slug ORDER BY categoriesfaqs.id ASC SEPARATOR '|') as _categoriesfaqs_slug, GROUP_CONCAT(categoriesfaqs.name ORDER BY categoriesfaqs.id ASC SEPARATOR '|') as _categoriesfaqs_name, GROUP_CONCAT(categoriesfaqs.taxonomytype ORDER BY categoriesfaqs.id ASC SEPARATOR '|') as _categoriesfaqs_taxonomytype FROM bolt_faqs t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='faqs' LEFT JOIN bolt_taxonomy `categoriesfaqs` ON t.id = `categoriesfaqs`.content_id AND `categoriesfaqs`.contenttype='faqs' AND `categoriesfaqs`.taxonomytype='categoriesfaqs' WHERE (t.status = :status) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish) GROUP BY t.id, t.id
  
  Parameters: {"currenttime":{"date":"2024-09-28 15:47:00.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 1,27 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_temoignages t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='temoignages' WHERE (t.status = :status) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish) GROUP BY t.id
  
  Parameters: {"currenttime":{"date":"2024-09-28 15:47:00.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 1,20 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.id ORDER BY groups.id ASC SEPARATOR '|') as _groups_id, GROUP_CONCAT(groups.slug ORDER BY groups.id ASC SEPARATOR '|') as _groups_slug, GROUP_CONCAT(groups.name ORDER BY groups.id ASC SEPARATOR '|') as _groups_name, GROUP_CONCAT(groups.taxonomytype ORDER BY groups.id 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":"2024-09-28 15:47:00.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"published","zeroday":"1900-01-01 00:00:01"}
  Time: 1,92 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,79 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["1"],"homepage",["categoriesfaqs"]]
  Time: 0,89 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["homepage",["1"]]
  Time: 0,71 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["homepage",["1"]]
  Time: 0,54 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE (`bolt_pages`.`slug` = 'votre-therapeute' AND `bolt_pages`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 4,21 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE (`bolt_pages`.`slug` = 'vos-questions' AND `bolt_pages`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 1,42 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE (`bolt_pages`.`slug` = 'me-trouver' AND `bolt_pages`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 0,78 ms
• SELECT bolt_soins.* FROM bolt_soins WHERE (`bolt_soins`.`slug` = 'hypnotherapie' AND `bolt_soins`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 2,13 ms
• SELECT bolt_soins.* FROM bolt_soins WHERE (`bolt_soins`.`slug` = 'massage-kobido' AND `bolt_soins`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 2,41 ms
• SELECT bolt_soins.* FROM bolt_soins WHERE (`bolt_soins`.`slug` = 'soin-hypno-kobido' AND `bolt_soins`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 1,09 ms
• SELECT bolt_soins.* FROM bolt_soins WHERE (`bolt_soins`.`slug` = 'massage-bien-etre' AND `bolt_soins`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 1,06 ms
• SELECT bolt_soins.* FROM bolt_soins WHERE (`bolt_soins`.`slug` = 'methode-eft' AND `bolt_soins`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 1,10 ms
• SELECT bolt_soins.* FROM bolt_soins WHERE (`bolt_soins`.`slug` = 'routine-bien-etre' AND `bolt_soins`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 1,00 ms
• SELECT COUNT(*) as count FROM bolt_soins WHERE (`bolt_soins`.`status` = 'published')
  
  Parameters: []
  Time: 1,49 ms
• SELECT bolt_soins.* FROM bolt_soins WHERE (`bolt_soins`.`status` = 'published') ORDER BY datepublish DESC LIMIT 9999
  
  Parameters: []
  Time: 2,94 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["1","2","4","5","6","7"],"soins",["categoriesfaqs"]]
  Time: 1,62 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["soins",["1","2","4","5","6","7"]]
  Time: 1,48 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["soins",["1","2","4","5","6","7"]]
  Time: 0,73 ms
• SELECT COUNT(*) as count FROM bolt_champs WHERE (`bolt_champs`.`status` = 'published')
  
  Parameters: []
  Time: 1,23 ms
• SELECT bolt_champs.* FROM bolt_champs WHERE (`bolt_champs`.`status` = 'published') ORDER BY datepublish DESC LIMIT 9999
  
  Parameters: []
  Time: 0,81 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["1","2","3"],"champs",["categoriesfaqs"]]
  Time: 1,26 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["champs",["1","2","3"]]
  Time: 1,21 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["champs",["1","2","3"]]
  Time: 0,75 ms
• SELECT COUNT(*) as count FROM bolt_temoignages WHERE (`bolt_temoignages`.`status` = 'published')
  
  Parameters: []
  Time: 1,85 ms
• SELECT bolt_temoignages.* FROM bolt_temoignages WHERE (`bolt_temoignages`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 4
  
  Parameters: []
  Time: 0,92 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["5","4","3","2"],"temoignages",["categoriesfaqs"]]
  Time: 1,31 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["temoignages",["5","4","3","2"]]
  Time: 1,17 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["temoignages",["5","4","3","2"]]
  Time: 0,99 ms