Symfony Profiler

Queries

• SELECT users.* FROM bolt_users users
  
  Parameters: []
  Time: 0,76 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,43 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE ("bolt_pages"."id" = '6' AND "bolt_pages"."status" = 'published') ORDER BY "datepublish" DESC LIMIT 1
  
  Parameters: []
  Time: 0,77 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["6"],"pages",["sections","categories","tags","groups"]]
  Time: 1,41 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["pages",["6"]]
  Time: 0,57 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["pages",["6"]]
  Time: 0,55 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE ("bolt_pages"."slug" = 'projets' AND "bolt_pages"."status" = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 0,62 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE ("bolt_pages"."slug" = 'a-propos' AND "bolt_pages"."status" = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 1,12 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE ("bolt_pages"."slug" = 'presse' AND "bolt_pages"."status" = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 0,59 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE ("bolt_pages"."slug" = 'blog' AND "bolt_pages"."status" = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 0,42 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: 0,80 ms
• SELECT COUNT(*) as count FROM bolt_projets WHERE ("bolt_projets"."une" = '1' AND "bolt_projets"."status" = 'published')
  
  Parameters: []
  Time: 7,67 ms
• SELECT bolt_projets.* FROM bolt_projets WHERE ("bolt_projets"."une" = '1' AND "bolt_projets"."status" = 'published') ORDER BY "date" DESC LIMIT 1
  
  Parameters: []
  Time: 1,00 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["77"],"projets",["sections","categories","tags","groups"]]
  Time: 1,20 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["projets",["77"]]
  Time: 0,39 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["projets",["77"]]
  Time: 0,38 ms
• SELECT COUNT(*) as count FROM bolt_projets WHERE ("bolt_projets"."status" = 'published')
  
  Parameters: []
  Time: 0,37 ms
• SELECT bolt_projets.* FROM bolt_projets WHERE ("bolt_projets"."status" = 'published') ORDER BY "date" DESC LIMIT 9
  
  Parameters: []
  Time: 26,26 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["82","81","80","79","78","77","76","73","74"],"projets",["sections","categories","tags","groups"]]
  Time: 4,77 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["projets",["82","81","80","79","78","77","76","73","74"]]
  Time: 0,43 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["projets",["82","81","80","79","78","77","76","73","74"]]
  Time: 0,40 ms
• SELECT COUNT(*) as count FROM bolt_presse WHERE ("bolt_presse"."status" = 'published')
  
  Parameters: []
  Time: 0,78 ms
• SELECT bolt_presse.* FROM bolt_presse WHERE ("bolt_presse"."status" = 'published') ORDER BY "date" DESC LIMIT 10
  
  Parameters: []
  Time: 16,13 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["109","108","110","111","106","107","103","104","105","100"],"presse",["sections","categories","tags","groups"]]
  Time: 0,50 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["presse",["109","108","110","111","106","107","103","104","105","100"]]
  Time: 0,45 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["presse",["109","108","110","111","106","107","103","104","105","100"]]
  Time: 0,41 ms
• SELECT COUNT(*) as count FROM bolt_articles WHERE ("bolt_articles"."status" = 'published')
  
  Parameters: []
  Time: 1,28 ms
• SELECT bolt_articles.* FROM bolt_articles WHERE ("bolt_articles"."status" = 'published') ORDER BY "datearticle" DESC LIMIT 6
  
  Parameters: []
  Time: 122,61 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["239","236","237","235","233","234"],"articles",["sections","categories","tags","groups"]]
  Time: 8,62 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["articles",["239","236","237","235","233","234"]]
  Time: 0,52 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["articles",["239","236","237","235","233","234"]]
  Time: 0,43 ms
• SELECT bolt_blocks.* FROM bolt_blocks WHERE ("bolt_blocks"."slug" = 'texte-footer' AND "bolt_blocks"."status" = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters: []
  Time: 1,05 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["2"],"blocks",["sections","categories","tags","groups"]]
  Time: 0,42 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["blocks",["2"]]
  Time: 0,39 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["blocks",["2"]]
  Time: 0,38 ms
• SELECT COUNT(*) as count FROM bolt_projets WHERE ("id" IN (SELECT content_id AS id FROM bolt_taxonomy where "bolt_taxonomy"."taxonomytype" = 'sections' AND ( "bolt_taxonomy"."slug" = 'grands appartements' OR "bolt_taxonomy"."name" = 'grands appartements' ) AND "bolt_taxonomy"."contenttype" = 'projets') AND "bolt_projets"."status" = 'published')
  
  Parameters: []
  Time: 1,15 ms
• SELECT bolt_projets.* FROM bolt_projets WHERE ("id" IN (SELECT content_id AS id FROM bolt_taxonomy where "bolt_taxonomy"."taxonomytype" = 'sections' AND ( "bolt_taxonomy"."slug" = 'grands appartements' OR "bolt_taxonomy"."name" = 'grands appartements' ) AND "bolt_taxonomy"."contenttype" = 'projets') AND "bolt_projets"."status" = 'published') ORDER BY "date" DESC LIMIT 9999
  
  Parameters: []
  Time: 0,72 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["82","76","73","74","75","70","72","67","66","65","64","56","58","57","54","53","52","51","45","44","41","40","39","38","36","4","35","12","8","16","13"],"projets",["sections","categories","tags","groups"]]
  Time: 0,48 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["projets",["82","76","73","74","75","70","72","67","66","65","64","56","58","57","54","53","52","51","45","44","41","40","39","38","36","4","35","12","8","16","13"]]
  Time: 0,43 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["projets",["82","76","73","74","75","70","72","67","66","65","64","56","58","57","54","53","52","51","45","44","41","40","39","38","36","4","35","12","8","16","13"]]
  Time: 0,42 ms
• SELECT COUNT(*) as count FROM bolt_projets WHERE ("id" IN (SELECT content_id AS id FROM bolt_taxonomy where "bolt_taxonomy"."taxonomytype" = 'sections' AND ( "bolt_taxonomy"."slug" = 'petits appartements' OR "bolt_taxonomy"."name" = 'petits appartements' ) AND "bolt_taxonomy"."contenttype" = 'projets') AND "bolt_projets"."status" = 'published')
  
  Parameters: []
  Time: 0,46 ms
• SELECT bolt_projets.* FROM bolt_projets WHERE ("id" IN (SELECT content_id AS id FROM bolt_taxonomy where "bolt_taxonomy"."taxonomytype" = 'sections' AND ( "bolt_taxonomy"."slug" = 'petits appartements' OR "bolt_taxonomy"."name" = 'petits appartements' ) AND "bolt_taxonomy"."contenttype" = 'projets') AND "bolt_projets"."status" = 'published') ORDER BY "date" DESC LIMIT 9999
  
  Parameters: []
  Time: 0,49 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["80","69","71","62","59","60","55","42"],"projets",["sections","categories","tags","groups"]]
  Time: 0,45 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["projets",["80","69","71","62","59","60","55","42"]]
  Time: 0,45 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["projets",["80","69","71","62","59","60","55","42"]]
  Time: 0,42 ms
• SELECT COUNT(*) as count FROM bolt_projets WHERE ("id" IN (SELECT content_id AS id FROM bolt_taxonomy where "bolt_taxonomy"."taxonomytype" = 'sections' AND ( "bolt_taxonomy"."slug" = 'boutiques - bureaux' OR "bolt_taxonomy"."name" = 'boutiques - bureaux' ) AND "bolt_taxonomy"."contenttype" = 'projets') AND "bolt_projets"."status" = 'published')
  
  Parameters: []
  Time: 0,44 ms
• SELECT bolt_projets.* FROM bolt_projets WHERE ("id" IN (SELECT content_id AS id FROM bolt_taxonomy where "bolt_taxonomy"."taxonomytype" = 'sections' AND ( "bolt_taxonomy"."slug" = 'boutiques - bureaux' OR "bolt_taxonomy"."name" = 'boutiques - bureaux' ) AND "bolt_taxonomy"."contenttype" = 'projets') AND "bolt_projets"."status" = 'published') ORDER BY "date" DESC LIMIT 9999
  
  Parameters: []
  Time: 0,48 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["37"],"projets",["sections","categories","tags","groups"]]
  Time: 0,68 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["projets",["37"]]
  Time: 0,45 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["projets",["37"]]
  Time: 0,56 ms
• SELECT COUNT(*) as count FROM bolt_projets WHERE ("id" IN (SELECT content_id AS id FROM bolt_taxonomy where "bolt_taxonomy"."taxonomytype" = 'sections' AND ( "bolt_taxonomy"."slug" = 'maisons de ville - extensions' OR "bolt_taxonomy"."name" = 'maisons de ville - extensions' ) AND "bolt_taxonomy"."contenttype" = 'projets') AND "bolt_projets"."status" = 'published')
  
  Parameters: []
  Time: 0,50 ms
• SELECT bolt_projets.* FROM bolt_projets WHERE ("id" IN (SELECT content_id AS id FROM bolt_taxonomy where "bolt_taxonomy"."taxonomytype" = 'sections' AND ( "bolt_taxonomy"."slug" = 'maisons de ville - extensions' OR "bolt_taxonomy"."name" = 'maisons de ville - extensions' ) AND "bolt_taxonomy"."contenttype" = 'projets') AND "bolt_projets"."status" = 'published') ORDER BY "date" DESC LIMIT 9999
  
  Parameters: []
  Time: 0,59 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["81","79","78","77","68","63","61","50","47","43","48","49","33","29","28"],"projets",["sections","categories","tags","groups"]]
  Time: 0,51 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["projets",["81","79","78","77","68","63","61","50","47","43","48","49","33","29","28"]]
  Time: 0,48 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["projets",["81","79","78","77","68","63","61","50","47","43","48","49","33","29","28"]]
  Time: 0,48 ms
• SELECT COUNT(*) as count FROM bolt_projets WHERE ("id" IN (SELECT content_id AS id FROM bolt_taxonomy where "bolt_taxonomy"."taxonomytype" = 'sections' AND ( "bolt_taxonomy"."slug" = 'chalets' OR "bolt_taxonomy"."name" = 'chalets' ) AND "bolt_taxonomy"."contenttype" = 'projets') AND "bolt_projets"."status" = 'published')
  
  Parameters: []
  Time: 0,56 ms
• SELECT bolt_projets.* FROM bolt_projets WHERE ("id" IN (SELECT content_id AS id FROM bolt_taxonomy where "bolt_taxonomy"."taxonomytype" = 'sections' AND ( "bolt_taxonomy"."slug" = 'chalets' OR "bolt_taxonomy"."name" = 'chalets' ) AND "bolt_taxonomy"."contenttype" = 'projets') AND "bolt_projets"."status" = 'published') ORDER BY "date" DESC LIMIT 9999
  
  Parameters: []
  Time: 0,98 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters: [["46"],"projets",["sections","categories","tags","groups"]]
  Time: 0,45 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters: ["projets",["46"]]
  Time: 0,44 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters: ["projets",["46"]]
  Time: 0,43 ms
• SELECT COUNT(*) as count FROM bolt_projets WHERE ("id" IN (SELECT content_id AS id FROM bolt_taxonomy where "bolt_taxonomy"."taxonomytype" = 'sections' AND ( "bolt_taxonomy"."slug" = 'hôtels particuliers' OR "bolt_taxonomy"."name" = 'hôtels particuliers' ) AND "bolt_taxonomy"."contenttype" = 'projets') AND "bolt_projets"."status" = 'published')
  
  Parameters: []
  Time: 0,44 ms
• SELECT bolt_projets.* FROM bolt_projets WHERE ("id" IN (SELECT content_id AS id FROM bolt_taxonomy where "bolt_taxonomy"."taxonomytype" = 'sections' AND ( "bolt_taxonomy"."slug" = 'hôtels particuliers' OR "bolt_taxonomy"."name" = 'hôtels particuliers' ) AND "bolt_taxonomy"."contenttype" = 'projets') AND "bolt_projets"."status" = 'published') ORDER BY "date" DESC LIMIT 9999
  
  Parameters: []
  Time: 0,45 ms