Profiler

View last 10 Profile for: GET https://lifetv.satelliteapps.co.nz/life-story/tracey by 216.73.216.81 at Thu, 26 Jun 2025 08:43:27 +0000

Queries

SELECT id FROM bolt_pages WHERE (status = :oldstatus) AND (datepublish < :currenttime)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"timed","newstatus":"published","currenttime":{"date":"2025-06-26 08:43:27.069705","timezone_type":3,"timezone":"UTC"}}
Time: 2.62 ms
SELECT id FROM bolt_pages WHERE (status = :oldstatus) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"published","newstatus":"held","zeroday":"1900-01-01 00:00:01","currenttime":{"date":"2025-06-26 08:43:27.072397","timezone_type":3,"timezone":"UTC"}}
Time: 0.92 ms
SELECT id FROM bolt_series WHERE (status = :oldstatus) AND (datepublish < :currenttime)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"timed","newstatus":"published","currenttime":{"date":"2025-06-26 08:43:27.073366","timezone_type":3,"timezone":"UTC"}}
Time: 1.64 ms
SELECT id FROM bolt_series WHERE (status = :oldstatus) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"published","newstatus":"held","zeroday":"1900-01-01 00:00:01","currenttime":{"date":"2025-06-26 08:43:27.075054","timezone_type":3,"timezone":"UTC"}}
Time: 0.86 ms
SELECT id FROM bolt_topics WHERE (status = :oldstatus) AND (datepublish < :currenttime)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"timed","newstatus":"published","currenttime":{"date":"2025-06-26 08:43:27.075956","timezone_type":3,"timezone":"UTC"}}
Time: 2.24 ms
SELECT id FROM bolt_topics WHERE (status = :oldstatus) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"published","newstatus":"held","zeroday":"1900-01-01 00:00:01","currenttime":{"date":"2025-06-26 08:43:27.078241","timezone_type":3,"timezone":"UTC"}}
Time: 1.22 ms
SELECT id FROM bolt_episodes WHERE (status = :oldstatus) AND (datepublish < :currenttime)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"timed","newstatus":"published","currenttime":{"date":"2025-06-26 08:43:27.079511","timezone_type":3,"timezone":"UTC"}}
Time: 1.87 ms
SELECT id FROM bolt_episodes WHERE (status = :oldstatus) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"published","newstatus":"held","zeroday":"1900-01-01 00:00:01","currenttime":{"date":"2025-06-26 08:43:27.081414","timezone_type":3,"timezone":"UTC"}}
Time: 0.86 ms
SELECT id FROM bolt_life_stories WHERE (status = :oldstatus) AND (datepublish < :currenttime)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"timed","newstatus":"published","currenttime":{"date":"2025-06-26 08:43:27.082318","timezone_type":3,"timezone":"UTC"}}
Time: 2.39 ms
SELECT id FROM bolt_life_stories WHERE (status = :oldstatus) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"published","newstatus":"held","zeroday":"1900-01-01 00:00:01","currenttime":{"date":"2025-06-26 08:43:27.084750","timezone_type":3,"timezone":"UTC"}}
Time: 0.87 ms
SELECT id FROM bolt_motivations WHERE (status = :oldstatus) AND (datepublish < :currenttime)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"timed","newstatus":"published","currenttime":{"date":"2025-06-26 08:43:27.085666","timezone_type":3,"timezone":"UTC"}}
Time: 2.20 ms
SELECT id FROM bolt_motivations WHERE (status = :oldstatus) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"published","newstatus":"held","zeroday":"1900-01-01 00:00:01","currenttime":{"date":"2025-06-26 08:43:27.087910","timezone_type":3,"timezone":"UTC"}}
Time: 0.84 ms
SELECT id FROM bolt_team_members WHERE (status = :oldstatus) AND (datepublish < :currenttime)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"timed","newstatus":"published","currenttime":{"date":"2025-06-26 08:43:27.088797","timezone_type":3,"timezone":"UTC"}}
Time: 3.11 ms
SELECT id FROM bolt_team_members WHERE (status = :oldstatus) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"published","newstatus":"held","zeroday":"1900-01-01 00:00:01","currenttime":{"date":"2025-06-26 08:43:27.091947","timezone_type":3,"timezone":"UTC"}}
Time: 0.83 ms
SELECT id FROM bolt_slides WHERE (status = :oldstatus) AND (datepublish < :currenttime)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"timed","newstatus":"published","currenttime":{"date":"2025-06-26 08:43:27.092816","timezone_type":3,"timezone":"UTC"}}
Time: 2.40 ms
SELECT id FROM bolt_slides WHERE (status = :oldstatus) AND (datedepublish <= :currenttime) AND (datedepublish > :zeroday) AND (datechanged < datedepublish)

Parameters: {"datechanged":"2025-06-26 08:43:27","oldstatus":"published","newstatus":"held","zeroday":"1900-01-01 00:00:01","currenttime":{"date":"2025-06-26 08:43:27.095255","timezone_type":3,"timezone":"UTC"}}
Time: 2.43 ms
SELECT * FROM bolt_users

Parameters: []
Time: 2.37 ms
SELECT count(*) FROM information_schema.tables WHERE table_schema = 'lifetv_dev2' AND table_name = 'bolt_life_stories';

Parameters: []
Time: 1.57 ms
SELECT bolt_life_stories.* FROM bolt_life_stories WHERE (`bolt_life_stories`.`slug` = 'tracey' AND `bolt_life_stories`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"48":"48"},"life-stories",["categories","tags"]]
Time: 6.16 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["life-stories",{"48":"48"}]
Time: 5.27 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["life-stories",{"48":"48"}]
Time: 0.89 ms
SELECT count(*) FROM information_schema.tables WHERE table_schema = 'lifetv_dev2' AND table_name = 'bolt_life_stories';

Parameters: []
Time: 1.65 ms
SELECT COUNT(*) as count FROM bolt_life_stories WHERE (`id` IN (SELECT content_id AS id FROM bolt_taxonomy where `bolt_taxonomy`.`taxonomytype` = 'tags' AND ( ( `bolt_taxonomy`.`slug` = 'hope' OR `bolt_taxonomy`.`slug` = 'healing' ) OR ( `bolt_taxonomy`.`name` = 'hope' OR `bolt_taxonomy`.`name` = 'healing' ) ) AND `bolt_taxonomy`.`contenttype` = 'life-stories') AND `bolt_life_stories`.`status` = 'published')

Parameters: []
Time: 5.79 ms
SELECT bolt_life_stories.* FROM bolt_life_stories WHERE (`id` IN (SELECT content_id AS id FROM bolt_taxonomy where `bolt_taxonomy`.`taxonomytype` = 'tags' AND ( ( `bolt_taxonomy`.`slug` = 'hope' OR `bolt_taxonomy`.`slug` = 'healing' ) OR ( `bolt_taxonomy`.`name` = 'hope' OR `bolt_taxonomy`.`name` = 'healing' ) ) AND `bolt_taxonomy`.`contenttype` = 'life-stories') AND `bolt_life_stories`.`status` = 'published') ORDER BY `name` LIMIT 15

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

Parameters: [{"228":"228","135":"135","12":"12","215":"215","131":"131","172":"172","138":"138","27":"27","24":"24","218":"218","86":"86","149":"149","95":"95","126":"126","175":"175"},"life-stories",["categories","tags"]]
Time: 1.75 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["life-stories",{"228":"228","135":"135","12":"12","215":"215","131":"131","172":"172","138":"138","27":"27","24":"24","218":"218","86":"86","149":"149","95":"95","126":"126","175":"175"}]
Time: 2.48 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["life-stories",{"228":"228","135":"135","12":"12","215":"215","131":"131","172":"172","138":"138","27":"27","24":"24","218":"218","86":"86","149":"149","95":"95","126":"126","175":"175"}]
Time: 0.99 ms
SELECT count(*) FROM information_schema.tables WHERE table_schema = 'lifetv_dev2' AND table_name = 'bolt_topics';

Parameters: []
Time: 1.65 ms
SELECT COUNT(*) as count FROM bolt_topics WHERE (`bolt_topics`.`status` = 'published')

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

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

Parameters: [{"12":"12","11":"11","10":"10","9":"9","8":"8","7":"7","6":"6","5":"5","4":"4","3":"3","2":"2","1":"1"},"topics",["categories","tags"]]
Time: 1.00 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["topics",{"12":"12","11":"11","10":"10","9":"9","8":"8","7":"7","6":"6","5":"5","4":"4","3":"3","2":"2","1":"1"}]
Time: 0.88 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["topics",{"12":"12","11":"11","10":"10","9":"9","8":"8","7":"7","6":"6","5":"5","4":"4","3":"3","2":"2","1":"1"}]
Time: 1.71 ms
SELECT count(*) FROM information_schema.tables WHERE table_schema = 'lifetv_dev2' AND table_name = 'bolt_episodes';

Parameters: []
Time: 1.56 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '116' AND `bolt_episodes`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"116":"116"},"episodes",["categories","tags"]]
Time: 1.68 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["episodes",{"116":"116"}]
Time: 0.81 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["episodes",{"116":"116"}]
Time: 0.83 ms
SELECT count(*) FROM information_schema.tables WHERE table_schema = 'lifetv_dev2' AND table_name = 'bolt_topics';

Parameters: []
Time: 1.50 ms
SELECT COUNT(*) as count FROM bolt_topics WHERE (( `bolt_topics`.`id` = '9' OR `bolt_topics`.`id` = '12' ) AND `bolt_topics`.`status` = 'published')

Parameters: []
Time: 0.89 ms
SELECT bolt_topics.* FROM bolt_topics WHERE (( `bolt_topics`.`id` = '9' OR `bolt_topics`.`id` = '12' ) AND `bolt_topics`.`status` = 'published') ORDER BY datepublish DESC LIMIT 9999

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

Parameters: [{"12":"12","9":"9"},"topics",["categories","tags"]]
Time: 0.89 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["topics",{"12":"12","9":"9"}]
Time: 0.81 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["topics",{"12":"12","9":"9"}]
Time: 2.25 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '72' AND `bolt_episodes`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"72":"72"},"episodes",["categories","tags"]]
Time: 0.94 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["episodes",{"72":"72"}]
Time: 1.04 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["episodes",{"72":"72"}]
Time: 0.84 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '7' AND `bolt_episodes`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"7":"7"},"episodes",["categories","tags"]]
Time: 0.98 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

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

Parameters: ["episodes",{"7":"7"}]
Time: 1.08 ms
SELECT bolt_topics.* FROM bolt_topics WHERE (`bolt_topics`.`id` = '10' AND `bolt_topics`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"10":"10"},"topics",["categories","tags"]]
Time: 0.89 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

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

Parameters: ["topics",{"10":"10"}]
Time: 1.12 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '109' AND `bolt_episodes`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"109":"109"},"episodes",["categories","tags"]]
Time: 0.98 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["episodes",{"109":"109"}]
Time: 0.90 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["episodes",{"109":"109"}]
Time: 0.83 ms
SELECT COUNT(*) as count FROM bolt_topics WHERE (( `bolt_topics`.`id` = '3' OR `bolt_topics`.`id` = '11' ) AND `bolt_topics`.`status` = 'published')

Parameters: []
Time: 0.85 ms
SELECT bolt_topics.* FROM bolt_topics WHERE (( `bolt_topics`.`id` = '3' OR `bolt_topics`.`id` = '11' ) AND `bolt_topics`.`status` = 'published') ORDER BY datepublish DESC LIMIT 9999

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

Parameters: [{"11":"11","3":"3"},"topics",["categories","tags"]]
Time: 0.86 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["topics",{"11":"11","3":"3"}]
Time: 0.79 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["topics",{"11":"11","3":"3"}]
Time: 1.49 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '70' AND `bolt_episodes`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"70":"70"},"episodes",["categories","tags"]]
Time: 0.88 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["episodes",{"70":"70"}]
Time: 1.04 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["episodes",{"70":"70"}]
Time: 0.81 ms
SELECT COUNT(*) as count FROM bolt_topics WHERE (( `bolt_topics`.`id` = '10' OR `bolt_topics`.`id` = '11' ) AND `bolt_topics`.`status` = 'published')

Parameters: []
Time: 0.82 ms
SELECT bolt_topics.* FROM bolt_topics WHERE (( `bolt_topics`.`id` = '10' OR `bolt_topics`.`id` = '11' ) AND `bolt_topics`.`status` = 'published') ORDER BY datepublish DESC LIMIT 9999

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

Parameters: [{"11":"11","10":"10"},"topics",["categories","tags"]]
Time: 0.84 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["topics",{"11":"11","10":"10"}]
Time: 0.79 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["topics",{"11":"11","10":"10"}]
Time: 1.42 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '86' AND `bolt_episodes`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"86":"86"},"episodes",["categories","tags"]]
Time: 0.91 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["episodes",{"86":"86"}]
Time: 0.80 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["episodes",{"86":"86"}]
Time: 0.83 ms
SELECT bolt_topics.* FROM bolt_topics WHERE (`bolt_topics`.`id` = '6' AND `bolt_topics`.`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: [{"6":"6"},"topics",["categories","tags"]]
Time: 0.86 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

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

Parameters: ["topics",{"6":"6"}]
Time: 1.13 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '58' AND `bolt_episodes`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"58":"58"},"episodes",["categories","tags"]]
Time: 0.94 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["episodes",{"58":"58"}]
Time: 1.03 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["episodes",{"58":"58"}]
Time: 0.86 ms
SELECT bolt_topics.* FROM bolt_topics WHERE (`bolt_topics`.`id` = '3' AND `bolt_topics`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"3":"3"},"topics",["categories","tags"]]
Time: 0.95 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["topics",{"3":"3"}]
Time: 0.90 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["topics",{"3":"3"}]
Time: 1.21 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '15' AND `bolt_episodes`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"15":"15"},"episodes",["categories","tags"]]
Time: 0.99 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

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

Parameters: ["episodes",{"15":"15"}]
Time: 0.87 ms
SELECT bolt_topics.* FROM bolt_topics WHERE (`bolt_topics`.`id` = '12' AND `bolt_topics`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"12":"12"},"topics",["categories","tags"]]
Time: 0.91 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

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

Parameters: ["topics",{"12":"12"}]
Time: 2.19 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '13' AND `bolt_episodes`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"13":"13"},"episodes",["categories","tags"]]
Time: 0.99 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

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

Parameters: ["episodes",{"13":"13"}]
Time: 0.83 ms
SELECT COUNT(*) as count FROM bolt_topics WHERE (( `bolt_topics`.`id` = '10' OR `bolt_topics`.`id` = '11' ) AND `bolt_topics`.`status` = 'published')

Parameters: []
Time: 0.83 ms
SELECT bolt_topics.* FROM bolt_topics WHERE (( `bolt_topics`.`id` = '10' OR `bolt_topics`.`id` = '11' ) AND `bolt_topics`.`status` = 'published') ORDER BY datepublish DESC LIMIT 9999

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

Parameters: [{"11":"11","10":"10"},"topics",["categories","tags"]]
Time: 0.85 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["topics",{"11":"11","10":"10"}]
Time: 0.80 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["topics",{"11":"11","10":"10"}]
Time: 1.47 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '111' AND `bolt_episodes`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"111":"111"},"episodes",["categories","tags"]]
Time: 1.43 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["episodes",{"111":"111"}]
Time: 0.96 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["episodes",{"111":"111"}]
Time: 0.80 ms
SELECT bolt_topics.* FROM bolt_topics WHERE (`bolt_topics`.`id` = '3' AND `bolt_topics`.`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: [{"3":"3"},"topics",["categories","tags"]]
Time: 0.83 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["topics",{"3":"3"}]
Time: 0.79 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["topics",{"3":"3"}]
Time: 1.09 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '44' AND `bolt_episodes`.`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: [{"44":"44"},"episodes",["categories","tags"]]
Time: 0.85 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["episodes",{"44":"44"}]
Time: 0.79 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["episodes",{"44":"44"}]
Time: 0.78 ms
SELECT bolt_topics.* FROM bolt_topics WHERE (`bolt_topics`.`id` = '12' AND `bolt_topics`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"12":"12"},"topics",["categories","tags"]]
Time: 0.82 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

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

Parameters: ["topics",{"12":"12"}]
Time: 1.09 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '78' AND `bolt_episodes`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"78":"78"},"episodes",["categories","tags"]]
Time: 0.87 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["episodes",{"78":"78"}]
Time: 0.81 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["episodes",{"78":"78"}]
Time: 0.78 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '48' AND `bolt_episodes`.`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: [{"48":"48"},"episodes",["categories","tags"]]
Time: 0.86 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["episodes",{"48":"48"}]
Time: 0.82 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["episodes",{"48":"48"}]
Time: 0.78 ms
SELECT COUNT(*) as count FROM bolt_topics WHERE (( `bolt_topics`.`id` = '5' OR `bolt_topics`.`id` = '11' ) AND `bolt_topics`.`status` = 'published')

Parameters: []
Time: 0.83 ms
SELECT bolt_topics.* FROM bolt_topics WHERE (( `bolt_topics`.`id` = '5' OR `bolt_topics`.`id` = '11' ) AND `bolt_topics`.`status` = 'published') ORDER BY datepublish DESC LIMIT 9999

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

Parameters: [{"11":"11","5":"5"},"topics",["categories","tags"]]
Time: 0.84 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["topics",{"11":"11","5":"5"}]
Time: 0.78 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["topics",{"11":"11","5":"5"}]
Time: 1.45 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '68' AND `bolt_episodes`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"68":"68"},"episodes",["categories","tags"]]
Time: 0.87 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["episodes",{"68":"68"}]
Time: 0.81 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["episodes",{"68":"68"}]
Time: 0.78 ms
SELECT COUNT(*) as count FROM bolt_topics WHERE (( `bolt_topics`.`id` = '5' OR `bolt_topics`.`id` = '11' ) AND `bolt_topics`.`status` = 'published')

Parameters: []
Time: 0.81 ms
SELECT bolt_topics.* FROM bolt_topics WHERE (( `bolt_topics`.`id` = '5' OR `bolt_topics`.`id` = '11' ) AND `bolt_topics`.`status` = 'published') ORDER BY datepublish DESC LIMIT 9999

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

Parameters: [{"11":"11","5":"5"},"topics",["categories","tags"]]
Time: 0.84 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["topics",{"11":"11","5":"5"}]
Time: 0.78 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["topics",{"11":"11","5":"5"}]
Time: 1.45 ms
SELECT bolt_episodes.* FROM bolt_episodes WHERE (`bolt_episodes`.`id` = '88' AND `bolt_episodes`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"88":"88"},"episodes",["categories","tags"]]
Time: 0.90 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["episodes",{"88":"88"}]
Time: 0.80 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["episodes",{"88":"88"}]
Time: 0.78 ms
SELECT bolt_topics.* FROM bolt_topics WHERE (`bolt_topics`.`id` = '9' AND `bolt_topics`.`status` = 'published') ORDER BY datepublish DESC LIMIT 1

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

Parameters: [{"9":"9"},"topics",["categories","tags"]]
Time: 0.83 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

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

Parameters: ["topics",{"9":"9"}]
Time: 1.12 ms
SELECT count(*) FROM information_schema.tables WHERE table_schema = 'lifetv_dev2' AND table_name = 'bolt_topics';

Parameters: []
Time: 1.56 ms
SELECT COUNT(*) as count FROM bolt_topics WHERE (`bolt_topics`.`status` = 'published')

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

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

Parameters: [{"12":"12","11":"11","10":"10","9":"9","8":"8","7":"7","6":"6","5":"5","4":"4","3":"3","2":"2","1":"1"},"topics",["categories","tags"]]
Time: 0.90 ms
SELECT * FROM bolt_relations WHERE from_contenttype=? AND from_id IN (?) ORDER BY id

Parameters: ["topics",{"12":"12","11":"11","10":"10","9":"9","8":"8","7":"7","6":"6","5":"5","4":"4","3":"3","2":"2","1":"1"}]
Time: 0.83 ms
SELECT * FROM bolt_relations WHERE to_contenttype=? AND to_id IN (?) ORDER BY id

Parameters: ["topics",{"12":"12","11":"11","10":"10","9":"9","8":"8","7":"7","6":"6","5":"5","4":"4","3":"3","2":"2","1":"1"}]
Time: 1.58 ms

Queries

Search

Admin