Back in Stock > Doodlebug: A Cherry On Top

Total Queries: 20
Total Errors: 0
Total Cached Queries: 10
Total Cache Saved: 6
Total Query Time: 0.12

Total App Time: 0.32

Toggle Log

From DB (0 seconds):

SET NAMES 'utf8'

From DB (0 seconds):

SELECT * FROM sg.users WHERE uid='4c5304d27e59f'

From DB (0 seconds):

REPLACE DELAYED INTO sg.users_lastvisit (uid,last_visit,ip) VALUES ('4c5304d27e59f',NOW(),'38.107.191.107')

From Cache 9b20b9d3222bb9d8c163b4101cec1286:

Start of shop.class.php:parse_uri()

From Cache 40c36e2060176fe090252bb9d87117b4:

From DB (0 seconds):

SELECT name FROM store_folders WHERE id=313

From Cache de1cf3a875efd3dbb3100e2fa3add1a6:

From Cache cad2918eaaee5fc8a6d9cc267a201dd7:

End of shop.class.php:parse_uri()

From Cache c915278d4dcdac327b26ba9e43758191:

From Cache a687decd93b2d0ccd24e679c53f236e1:

From Cache 1f1179d33d23f548edc897a52bde00b1:

From Cache 97329a1bb6eae333c2f9ce89704f2532:

From Cache 5a96550f6dbef392ba73f061afe3773c:

From DB (0.02 seconds):

SELECT COUNT(*) FROM products JOIN current_inventory ON (current_inventory.pid=products.pid) WHERE (current_inventory.count-current_inventory.pending>0) AND (products.date_refill BETWEEN NOW()-INTERVAL 45 DAY and NOW()) AND (products.date_refill > products.datein) AND ((products.company=313)) AND (current_inventory.show=1) AND (products.missingimage=0) AND (products.store & 1=1) AND 12=12

Saved c243dd018d8fd311ed0443da9e2d7aa1:

From DB (0.02 seconds):

SELECT products.pid,products.itemnumber,products.description,parent_product.description AS pdescription,products.description_short,parent_product.description_short AS pdescription_short,products.notes,parent_product.notes as pnotes,products.sellingprice,products.currentsaleprice,products.sale,products.points_multiplier,products.score,products.aisle,products.rack,products.hook,products.parent_pid,products.sub_name,products.missingimage,products.drop_shipper_id,current_inventory.count-current_inventory.pending AS real_available,current_inventory.available,current_inventory.onorder,current_inventory.onpreorder,datediff(NOW(),products.date_ol) age,products.downloadable FROM products JOIN current_inventory ON (current_inventory.pid=products.pid) LEFT JOIN products AS parent_product ON (products.parent_pid=parent_product.pid AND products.parent_pid!=0) WHERE (current_inventory.count-current_inventory.pending>0) AND (products.date_refill BETWEEN NOW()-INTERVAL 45 DAY and NOW()) AND (products.date_refill > products.datein) AND ((products.company=313)) AND (current_inventory.show=1) AND (products.missingimage=0) AND (products.store & 1=1) ORDER BY products.date_ol DESC, products.description LIMIT 0,12

Saved e93f26c919dfecbdd16383a09ae0e21e:

From DB (0.02 seconds): Narrow by line

SELECT store_folders.name AS line, 0 AS the_sub_level,store_folders.id,store_folders.name,COUNT(*) ct FROM products JOIN current_inventory ON (current_inventory.pid=products.pid) JOIN store_folders ON (store_folders.id=products.line) WHERE (current_inventory.count-current_inventory.pending>0) AND (products.date_refill BETWEEN NOW()-INTERVAL 45 DAY and NOW()) AND (products.date_refill > products.datein) AND ((products.company=313)) AND (current_inventory.show=1) AND (products.missingimage=0) AND (products.store & 1=1) GROUP BY products.line ORDER BY store_folders.name

Saved bfbaa496ea303fa1350b63c5a2c6eeee: Narrow by line

From DB (0.02 seconds): Narrow by cat

SELECT store_folders.id,store_folders.name,COUNT(*) ct FROM products JOIN current_inventory ON (current_inventory.pid=products.pid) JOIN product_cats AS gb_product_cats ON (products.pid=gb_product_cats.pid) JOIN store_folders ON (store_folders.id=gb_product_cats.id AND gb_product_cats.cat_type=1 AND gb_product_cats.sub_level=0) WHERE (current_inventory.count-current_inventory.pending>0) AND (products.date_refill BETWEEN NOW()-INTERVAL 45 DAY and NOW()) AND (products.date_refill > products.datein) AND ((products.company=313)) AND (current_inventory.show=1) AND (products.missingimage=0) AND (products.store & 1=1) GROUP BY gb_product_cats.id ORDER BY store_folders.name

Saved 22605643064b4db8b23718c95597c283: Narrow by cat

From DB (0.02 seconds): Narrow by theme

SELECT store_folders.id,store_folders.name,COUNT(*) ct FROM products JOIN current_inventory ON (current_inventory.pid=products.pid) JOIN product_cats AS gb_product_cats ON (products.pid=gb_product_cats.pid) JOIN store_folders ON (store_folders.id=gb_product_cats.id AND gb_product_cats.cat_type=2 AND gb_product_cats.sub_level=0) WHERE (current_inventory.count-current_inventory.pending>0) AND (products.date_refill BETWEEN NOW()-INTERVAL 45 DAY and NOW()) AND (products.date_refill > products.datein) AND ((products.company=313)) AND (current_inventory.show=1) AND (products.missingimage=0) AND (products.store & 1=1) GROUP BY gb_product_cats.id ORDER BY store_folders.name

Saved 73a43e5a66a70e1e404b0b9848d589c3: Narrow by theme

From DB (0.02 seconds): Narrow by price

SELECT CASE WHEN IF(currentsaleprice>0 AND currentsaleprice<sellingprice,currentsaleprice,sellingprice) < 2 THEN 'Under $1.99' WHEN IF(currentsaleprice>0 AND currentsaleprice<sellingprice,currentsaleprice,sellingprice) >=2 AND IF(currentsaleprice>0 AND currentsaleprice<sellingprice,currentsaleprice,sellingprice) < 4 THEN '$2.00 - $3.99' WHEN IF(currentsaleprice>0 AND currentsaleprice<sellingprice,currentsaleprice,sellingprice) >=4 AND IF(currentsaleprice>0 AND currentsaleprice<sellingprice,currentsaleprice,sellingprice) < 8 THEN '$4.00 - $7.99' WHEN IF(currentsaleprice>0 AND currentsaleprice<sellingprice,currentsaleprice,sellingprice) >=8 AND IF(currentsaleprice>0 AND currentsaleprice<sellingprice,currentsaleprice,sellingprice) < 12 THEN '$8.00 - $11.99' ELSE '$12.00 & up' END as name,COUNT(*) ct FROM products JOIN current_inventory ON (current_inventory.pid=products.pid) WHERE (current_inventory.count-current_inventory.pending>0) AND (products.date_refill BETWEEN NOW()-INTERVAL 45 DAY and NOW()) AND (products.date_refill > products.datein) AND ((products.company=313)) AND (current_inventory.show=1) AND (products.missingimage=0) AND (products.store & 1=1) GROUP BY name ORDER BY IF(currentsaleprice>0 AND currentsaleprice<sellingprice,currentsaleprice,sellingprice)

Saved ef451d1a60fc0ff6df806aa4d76cc966: Narrow by price