Stop worrying about the potholes in the road and enjoy the journey
Botoscope

Release Candidate 6 released

1 minutes to read

Bug fixes and small enhancements across the whole application, stock notify implemented

0

You might also like

Categories

Botoscope Uncategorized

Random posts


Memory consumed: 129,904 bites
Execution took: 0.032639980316162 seconds.
Count of queries to db: 15
Array
(
    [0] => SELECT ID AS id, post_title AS title, post_name AS slug, post_content AS content, post_date AS date, (SELECT guid FROM woof_posts WHERE id = woof_postmeta.meta_value) AS thumb_url FROM woof_posts LEFT JOIN woof_postmeta ON(id = woof_postmeta.post_id AND woof_postmeta.meta_key = '_thumbnail_id') WHERE post_type=:post_type AND post_status=:post_status AND post_name=:post_name   LIMIT 1
    [1] => SELECT post_id, meta_key, meta_value FROM woof_postmeta WHERE post_id = :post_id AND meta_key IN ('gallery')
    [2] => 
        SELECT 
            p.post_name AS slug,
            t.slug AS lang
        FROM woof_posts p
        JOIN woof_term_relationships tr ON p.ID = tr.object_id
        JOIN woof_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
        JOIN woof_terms t ON tt.term_id = t.term_id
        WHERE tt.taxonomy = 'language'
          AND p.post_type = 'post'
          AND p.post_status = 'publish'
    
    [3] => SELECT woof_terms.term_id, woof_terms.name as title, woof_terms.slug, tr.object_id as post_id FROM woof_terms LEFT JOIN woof_term_taxonomy AS tt ON woof_terms.term_id = tt.term_id LEFT JOIN woof_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (716) ORDER BY woof_terms.name ASC 
    [4] => SELECT woof_term_taxonomy.term_id as term_id, woof_term_taxonomy.count as count, woof_terms.name as name, woof_terms.slug as slug FROM woof_term_taxonomy LEFT JOIN woof_terms ON woof_term_taxonomy.term_id=woof_terms.term_id WHERE taxonomy=:taxonomy ORDER BY name ASC
    [5] => SELECT woof_terms.term_id, woof_terms.name as title, woof_terms.slug, tr.object_id as post_id FROM woof_terms LEFT JOIN woof_term_taxonomy AS tt ON woof_terms.term_id = tt.term_id LEFT JOIN woof_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (716) ORDER BY woof_terms.name ASC 
    [6] => SELECT comment_title, comment_content, comment_date, comment_karma FROM woof_comments WHERE comment_post_ID=:post_id  
    [7] => SELECT p.ID FROM woof_posts AS p WHERE p.post_date < '2025-08-13 22:27:44' AND p.post_type = 'post' AND (p.post_status = 'publish') ORDER BY p.post_date DESC LIMIT 1
    [8] => SELECT ID AS id, post_title AS title, post_name AS slug, post_date AS date, post_content AS content, (SELECT guid FROM woof_posts WHERE id = woof_postmeta.meta_value) AS thumb_url, (SELECT t.slug 
          FROM woof_term_relationships AS tr
          INNER JOIN woof_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
          INNER JOIN woof_terms AS t ON tt.term_id = t.term_id
          WHERE tt.taxonomy = 'language' AND tr.object_id = id LIMIT 1
        ) AS lang FROM woof_posts LEFT JOIN woof_postmeta ON(id = woof_postmeta.post_id AND woof_postmeta.meta_key = '_thumbnail_id') LEFT JOIN woof_term_relationships AS lang_rel ON(id = lang_rel.object_id) LEFT JOIN woof_term_taxonomy AS lang_tax ON(lang_rel.term_taxonomy_id = lang_tax.term_taxonomy_id) LEFT JOIN woof_terms AS lang_term ON(lang_tax.term_id = lang_term.term_id) WHERE post_type = :post_type AND post_status = :post_status AND lang_tax.taxonomy = 'language' AND lang_term.slug = :lang AND ID IN (713)  ORDER BY id DESC  LIMIT 1
    [9] => SELECT p.ID FROM woof_posts AS p WHERE p.post_date > '2025-08-13 22:27:44' AND p.post_type = 'post' AND (p.post_status = 'publish') ORDER BY p.post_date ASC LIMIT 1
    [10] => SELECT ID AS id, post_title AS title, post_name AS slug, post_date AS date, post_content AS content, (SELECT guid FROM woof_posts WHERE id = woof_postmeta.meta_value) AS thumb_url, (SELECT t.slug 
          FROM woof_term_relationships AS tr
          INNER JOIN woof_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
          INNER JOIN woof_terms AS t ON tt.term_id = t.term_id
          WHERE tt.taxonomy = 'language' AND tr.object_id = id LIMIT 1
        ) AS lang FROM woof_posts LEFT JOIN woof_postmeta ON(id = woof_postmeta.post_id AND woof_postmeta.meta_key = '_thumbnail_id') LEFT JOIN woof_term_relationships AS lang_rel ON(id = lang_rel.object_id) LEFT JOIN woof_term_taxonomy AS lang_tax ON(lang_rel.term_taxonomy_id = lang_tax.term_taxonomy_id) LEFT JOIN woof_terms AS lang_term ON(lang_tax.term_id = lang_term.term_id) WHERE post_type = :post_type AND post_status = :post_status AND lang_tax.taxonomy = 'language' AND lang_term.slug = :lang AND ID IN (723)  ORDER BY id DESC  LIMIT 1
    [11] => SELECT * FROM liked_posts WHERE post_id="716"  
    [12] => SELECT ID AS id, post_title AS title, post_name AS slug, post_date AS date, post_content AS content, (SELECT guid FROM woof_posts WHERE id = woof_postmeta.meta_value) AS thumb_url, (SELECT t.slug 
          FROM woof_term_relationships AS tr
          INNER JOIN woof_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
          INNER JOIN woof_terms AS t ON tt.term_id = t.term_id
          WHERE tt.taxonomy = 'language' AND tr.object_id = id LIMIT 1
        ) AS lang FROM woof_posts LEFT JOIN woof_postmeta ON(id = woof_postmeta.post_id AND woof_postmeta.meta_key = '_thumbnail_id') LEFT JOIN woof_term_relationships AS lang_rel ON(id = lang_rel.object_id) LEFT JOIN woof_term_taxonomy AS lang_tax ON(lang_rel.term_taxonomy_id = lang_tax.term_taxonomy_id) LEFT JOIN woof_terms AS lang_term ON(lang_tax.term_id = lang_term.term_id) WHERE post_type = :post_type AND post_status = :post_status AND lang_tax.taxonomy = 'language' AND lang_term.slug = :lang AND ID NOT IN (716)  ORDER BY RAND()  LIMIT 6
    [13] => SELECT woof_term_taxonomy.term_id as term_id, woof_term_taxonomy.count as count, woof_terms.name as name, woof_terms.slug as slug FROM woof_term_taxonomy LEFT JOIN woof_terms ON woof_term_taxonomy.term_id=woof_terms.term_id WHERE taxonomy=:taxonomy ORDER BY name ASC
    [14] => SELECT ID AS id, post_title AS title, post_name AS slug, post_date AS date, post_content AS content, (SELECT guid FROM woof_posts WHERE id = woof_postmeta.meta_value) AS thumb_url, (SELECT t.slug 
          FROM woof_term_relationships AS tr
          INNER JOIN woof_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
          INNER JOIN woof_terms AS t ON tt.term_id = t.term_id
          WHERE tt.taxonomy = 'language' AND tr.object_id = id LIMIT 1
        ) AS lang FROM woof_posts LEFT JOIN woof_postmeta ON(id = woof_postmeta.post_id AND woof_postmeta.meta_key = '_thumbnail_id') LEFT JOIN woof_term_relationships AS lang_rel ON(id = lang_rel.object_id) LEFT JOIN woof_term_taxonomy AS lang_tax ON(lang_rel.term_taxonomy_id = lang_tax.term_taxonomy_id) LEFT JOIN woof_terms AS lang_term ON(lang_tax.term_id = lang_term.term_id) WHERE post_type = :post_type AND post_status = :post_status AND lang_tax.taxonomy = 'language' AND lang_term.slug = :lang AND ID NOT IN (716)  ORDER BY RAND()  LIMIT 4
)
Count of included files: 17