Symfony Profiler

Queries

SET NAMES utf8 COLLATE utf8_unicode_ci

Parameters: []
Time: 0.26 ms
SET SESSION group_concat_max_len = 100000

Parameters: []
Time: 0.10 ms
SELECT users.* FROM bolt_users users

Parameters: []
Time: 0.50 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(ordering.sortorder ORDER BY ordering.sortorder ASC) as _ordering_sortorder, GROUP_CONCAT(ordering.id ORDER BY ordering.sortorder ASC) as _ordering_id, GROUP_CONCAT(ordering.slug ORDER BY ordering.sortorder ASC) as _ordering_slug, GROUP_CONCAT(ordering.name ORDER BY ordering.sortorder ASC) as _ordering_name, GROUP_CONCAT(ordering.taxonomytype ORDER BY ordering.sortorder ASC) as _ordering_taxonomytype FROM bolt_sections t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='sections' LEFT JOIN bolt_taxonomy ordering ON t.id = ordering.content_id AND ordering.contenttype='sections' AND ordering.taxonomytype='ordering' WHERE (status = :status) AND (datepublish < :currenttime) GROUP BY t.id, t.id

Parameters: {"currenttime":{"date":"2025-06-15 04:33:05.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"timed"}
Time: 1.12 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_entries t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='entries' WHERE (status = :status) AND (datepublish < :currenttime) GROUP BY t.id

Parameters: {"currenttime":{"date":"2025-06-15 04:33:05.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"timed"}
Time: 0.62 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_visitas t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='visitas' WHERE (status = :status) AND (datepublish < :currenttime) GROUP BY t.id

Parameters: {"currenttime":{"date":"2025-06-15 04:33:05.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"timed"}
Time: 0.54 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(ordering.sortorder ORDER BY ordering.sortorder ASC) as _ordering_sortorder, GROUP_CONCAT(ordering.id ORDER BY ordering.sortorder ASC) as _ordering_id, GROUP_CONCAT(ordering.slug ORDER BY ordering.sortorder ASC) as _ordering_slug, GROUP_CONCAT(ordering.name ORDER BY ordering.sortorder ASC) as _ordering_name, GROUP_CONCAT(ordering.taxonomytype ORDER BY ordering.sortorder ASC) as _ordering_taxonomytype FROM bolt_sections t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='sections' LEFT JOIN bolt_taxonomy ordering ON t.id = ordering.content_id AND ordering.contenttype='sections' AND ordering.taxonomytype='ordering' WHERE (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish) GROUP BY t.id, t.id

Parameters: {"currenttime":{"date":"2025-06-15 04:33:05.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"published","zeroday":"1900-01-01 00:00:01"}
Time: 0.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 FROM bolt_entries t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='entries' WHERE (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish) GROUP BY t.id

Parameters: {"currenttime":{"date":"2025-06-15 04:33:05.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"published","zeroday":"1900-01-01 00:00:01"}
Time: 0.57 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_visitas t LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='visitas' WHERE (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish) GROUP BY t.id

Parameters: {"currenttime":{"date":"2025-06-15 04:33:05.000000","timezone_type":3,"timezone":"Europe\/Paris"},"status":"published","zeroday":"1900-01-01 00:00:01"}
Time: 0.68 ms
SELECT COUNT(*) as count FROM bolt_sections WHERE (`bolt_sections`.`status` = 'published')

Parameters: []
Time: 0.33 ms
SELECT bolt_sections.* FROM bolt_sections WHERE (`bolt_sections`.`status` = 'published') ORDER BY datepublish DESC LIMIT 9999

Parameters: []
Time: 0.44 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["23","22","21","20","19","17","16","13","12","9"],"sections",["ordering"]]
Time: 0.64 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["sections",["23","22","21","20","19","17","16","13","12","9"]]
Time: 0.38 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["sections",["23","22","21","20","19","17","16","13","12","9"]]
Time: 0.32 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '24' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.43 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["24"],"entries",["ordering"]]
Time: 0.47 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["24"]]
Time: 0.30 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["24"]]
Time: 0.27 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '6' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.41 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["6"],"entries",["ordering"]]
Time: 0.34 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["6"]]
Time: 0.28 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["6"]]
Time: 0.26 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '7' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.32 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["7"],"entries",["ordering"]]
Time: 0.32 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["7"]]
Time: 0.27 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["7"]]
Time: 0.25 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.28 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["4"],"entries",["ordering"]]
Time: 0.32 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["4"]]
Time: 0.49 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["4"]]
Time: 0.29 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '8' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.30 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["8"],"entries",["ordering"]]
Time: 0.33 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["8"]]
Time: 0.28 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["8"]]
Time: 0.26 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '9' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.28 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["9"],"entries",["ordering"]]
Time: 0.36 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["9"]]
Time: 0.27 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["9"]]
Time: 0.25 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '10' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.31 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["10"],"entries",["ordering"]]
Time: 0.31 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["10"]]
Time: 0.27 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["10"]]
Time: 0.25 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '11' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.27 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["11"],"entries",["ordering"]]
Time: 0.32 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["11"]]
Time: 0.26 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["11"]]
Time: 0.24 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '12' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.31 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["12"],"entries",["ordering"]]
Time: 0.32 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["12"]]
Time: 0.26 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["12"]]
Time: 0.24 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '20' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.28 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["20"],"entries",["ordering"]]
Time: 0.35 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["20"]]
Time: 0.26 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["20"]]
Time: 0.24 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '5' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.27 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["5"],"entries",["ordering"]]
Time: 0.30 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["5"]]
Time: 0.26 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["5"]]
Time: 0.24 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '17' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.27 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["17"],"entries",["ordering"]]
Time: 0.31 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["17"]]
Time: 0.26 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["17"]]
Time: 0.24 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '14' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.42 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["14"],"entries",["ordering"]]
Time: 0.34 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["14"]]
Time: 0.28 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["14"]]
Time: 0.26 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '15' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.38 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["15"],"entries",["ordering"]]
Time: 0.42 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["15"]]
Time: 0.29 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["15"]]
Time: 0.26 ms
SELECT bolt_entries.* FROM bolt_entries WHERE (`bolt_entries`.`id` = '13' AND `bolt_entries`.`status` = 'published') ORDER BY `datepublish` DESC LIMIT 1

Parameters: []
Time: 0.29 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["13"],"entries",["ordering"]]
Time: 0.35 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["entries",["13"]]
Time: 0.27 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["entries",["13"]]
Time: 0.25 ms
SELECT COUNT(*) as count FROM bolt_visitas WHERE (`bolt_visitas`.`status` = 'published')

Parameters: []
Time: 0.28 ms
SELECT bolt_visitas.* FROM bolt_visitas WHERE (`bolt_visitas`.`status` = 'published') ORDER BY datepublish DESC LIMIT 9999

Parameters: []
Time: 0.56 ms
SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)

Parameters: [["29","28","27","26","25","23","22","21","20","19","18","17","16","15","14","13","12","11","10","9","8","7","6","5","4","3","2","1"],"visitas",["ordering"]]
Time: 0.68 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["visitas",["29","28","27","26","25","23","22","21","20","19","18","17","16","15","14","13","12","11","10","9","8","7","6","5","4","3","2","1"]]
Time: 0.48 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["visitas",["29","28","27","26","25","23","22","21","20","19","18","17","16","15","14","13","12","11","10","9","8","7","6","5","4","3","2","1"]]
Time: 0.45 ms

Symfony Profiler

http://utopicrooms.com/

Queries