Symfony Profiler

Queries

• 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.09 ms
• SELECT id FROM bolt_pages WHERE (status = :oldstatus) AND (datepublish < :currenttime)
  
  Parameters:{"datechanged":"2024-11-14 07:06:06","oldstatus":"timed","newstatus":"published","currenttime":{"date":"2024-11-14 07:06:06.468364","timezone_type":3,"timezone":"UTC"}}
  Time:0.44 ms
• SELECT id FROM bolt_pages WHERE (status = :oldstatus) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish)
  
  Parameters:{"datechanged":"2024-11-14 07:06:06","oldstatus":"published","newstatus":"held","zeroday":"1900-01-01 00:00:01","currenttime":{"date":"2024-11-14 07:06:06.468894","timezone_type":3,"timezone":"UTC"}}
  Time:0.10 ms
• SELECT id FROM bolt_entries WHERE (status = :oldstatus) AND (datepublish < :currenttime)
  
  Parameters:{"datechanged":"2024-11-14 07:06:06","oldstatus":"timed","newstatus":"published","currenttime":{"date":"2024-11-14 07:06:06.469257","timezone_type":3,"timezone":"UTC"}}
  Time:0.07 ms
• SELECT id FROM bolt_entries WHERE (status = :oldstatus) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish)
  
  Parameters:{"datechanged":"2024-11-14 07:06:06","oldstatus":"published","newstatus":"held","zeroday":"1900-01-01 00:00:01","currenttime":{"date":"2024-11-14 07:06:06.469391","timezone_type":3,"timezone":"UTC"}}
  Time:0.08 ms
• SELECT id FROM bolt_showcases WHERE (status = :oldstatus) AND (datepublish < :currenttime)
  
  Parameters:{"datechanged":"2024-11-14 07:06:06","oldstatus":"timed","newstatus":"published","currenttime":{"date":"2024-11-14 07:06:06.469584","timezone_type":3,"timezone":"UTC"}}
  Time:0.08 ms
• SELECT id FROM bolt_showcases WHERE (status = :oldstatus) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish)
  
  Parameters:{"datechanged":"2024-11-14 07:06:06","oldstatus":"published","newstatus":"held","zeroday":"1900-01-01 00:00:01","currenttime":{"date":"2024-11-14 07:06:06.469721","timezone_type":3,"timezone":"UTC"}}
  Time:0.08 ms
• SELECT id FROM bolt_blocks WHERE (status = :oldstatus) AND (datepublish < :currenttime)
  
  Parameters:{"datechanged":"2024-11-14 07:06:06","oldstatus":"timed","newstatus":"published","currenttime":{"date":"2024-11-14 07:06:06.469896","timezone_type":3,"timezone":"UTC"}}
  Time:0.07 ms
• SELECT id FROM bolt_blocks WHERE (status = :oldstatus) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish)
  
  Parameters:{"datechanged":"2024-11-14 07:06:06","oldstatus":"published","newstatus":"held","zeroday":"1900-01-01 00:00:01","currenttime":{"date":"2024-11-14 07:06:06.470028","timezone_type":3,"timezone":"UTC"}}
  Time:0.08 ms
• SELECT COUNT(*) as count FROM bolt_pages WHERE ("bolt_pages"."status" = 'published')
  
  Parameters:[]
  Time:0.06 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE ("bolt_pages"."status" = 'published') ORDER BY "datepublish" DESC LIMIT 10000
  
  Parameters:[]
  Time:0.66 ms
• SELECT users.* FROM bolt_users users
  
  Parameters:[]
  Time:0.07 ms
• SELECT COUNT(*) as count FROM bolt_entries WHERE ("bolt_entries"."status" = 'published')
  
  Parameters:[]
  Time:0.08 ms
• SELECT bolt_entries.* FROM bolt_entries WHERE ("bolt_entries"."status" = 'published') ORDER BY "datepublish" DESC LIMIT 10000
  
  Parameters:[]
  Time:0.09 ms
• SELECT bolt_pages.* FROM bolt_pages WHERE ("bolt_pages"."id" = '12' AND "bolt_pages"."status" = 'published') ORDER BY datepublish DESC LIMIT 1
  
  Parameters:[]
  Time:0.12 ms
• SELECT * FROM bolt_taxonomy WHERE content_id IN (?) AND contenttype=? AND taxonomytype IN (?)
  
  Parameters:[{"12":"12"},"pages",["tags","groups","categories"]]
  Time:0.19 ms
• SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id
  
  Parameters:["pages",{"12":"12"}]
  Time:1.85 ms
• SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id
  
  Parameters:["pages",{"12":"12"}]
  Time:0.09 ms