Digital Scrapbooking > Search: natural spring > Paper > Jasmine Low (Jasbeanie): A Cherry On Top

Total Queries: 22
Total Errors: 0
Total Cached Queries: 7
Total Cache Saved: 11
Total Query Time: 0.72

Total App Time: 0.99

Toggle Log

From DB (0 seconds):

SET NAMES 'utf8'

From Cache 9b20b9d3222bb9d8c163b4101cec1286:

Start of shop.class.php:parse_uri()

From Cache 4d51ba714cefe31a81fc9fadd1c7f019:

From DB (0.72 seconds):

INSERT INTO search_history (search,uid,`when`) VALUES ('natural%20spring','4c5304d27e59f',NOW()) ON DUPLICATE KEY UPDATE `when`=NOW()

From Cache 6b412bc809463590b10eaacd6ec36ecd:

From DB (0 seconds):

SELECT name FROM store_folders WHERE id=5351

From DB (0 seconds):

SELECT id,name FROM store_folders WHERE name='jasmine low (jasbeanie)' AND type=3 LIMIT 1

Saved 6ad2bbe2844d8a0da3a287dd49c64cf9:

From DB (0 seconds):

SELECT name FROM store_folders WHERE id=5412

From DB (0 seconds):

SELECT company FROM products WHERE artist=5412 LIMIT 1

Saved 42c2a295f2f255950516aa5153098234:

From Cache 4d51ba714cefe31a81fc9fadd1c7f019:

From DB (0 seconds):

SELECT name,value FROM sg._users_settings WHERE uid='4c5304d27e59f'

Saved cad2918eaaee5fc8a6d9cc267a201dd7:

End of shop.class.php:parse_uri()

From DB (0 seconds):

SELECT _permissions.id,_permissions.name,_users_permissions.enabled, UNIX_TIMESTAMP(_users_permissions.expires) expires, UNIX_TIMESTAMP(_users_permissions.date_start) date_start FROM sg._permissions JOIN sg._users_permissions ON (_permissions.id=_users_permissions.permission_id) WHERE _users_permissions.uid='4c5304d27e59f'

Saved c915278d4dcdac327b26ba9e43758191:

From Cache 2fc4cda7002c762debf43c3e645c3b6a:

From Cache 350e214b8d395e419b5b78447a51d435:

From DB (0 seconds):

SELECT text FROM store_descriptions WHERE folder_id=5412 AND sid=3 AND landing=0

Saved 714b465806651d365f31ea4e96c30774:

From DB (0 seconds):

SELECT * FROM store_folders_landing WHERE folder_id=5412 AND sid=3

Saved b10762b0504cdee21a8f59f877fadbc4:

From DB (0 seconds):

SELECT COUNT(*) FROM products JOIN product_cats AS product_cats_subcat ON (products.pid=product_cats_subcat.pid) JOIN current_inventory ON (current_inventory.pid=products.pid) WHERE (products.store & 8=8) AND ((products.pid IN (9004879, 9004880, 9004890, 9004891, 9005109, 107477, 107471, 107476, 9008199, 9002994, 9002995, 9002996, 9003003, 9007862, 9007867, 9005517, 9005535, 9002755, 9002756, 9002761, 9007861, 9007863, 9007925, 9007927, 9007928, 9007931, 9008119, 9005184, 9007417, 9007415, 9007418, 9007660, 9005779, 9005782, 9005785, 9005787, 9005795, 9005799, 9005806, 9005807, 9005810, 9008049))) AND ((product_cats_subcat.id=5351)) AND ((products.artist=5412)) AND (current_inventory.show=1) AND (products.missingimage=0) AND 12=12

Saved 3342d8e510d6986c5e357136a50f9eb0:

From DB (0 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 product_cats AS product_cats_subcat ON (products.pid=product_cats_subcat.pid) 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 (products.store & 8=8) AND ((products.pid IN (9004879, 9004880, 9004890, 9004891, 9005109, 107477, 107471, 107476, 9008199, 9002994, 9002995, 9002996, 9003003, 9007862, 9007867, 9005517, 9005535, 9002755, 9002756, 9002761, 9007861, 9007863, 9007925, 9007927, 9007928, 9007931, 9008119, 9005184, 9007417, 9007415, 9007418, 9007660, 9005779, 9005782, 9005785, 9005787, 9005795, 9005799, 9005806, 9005807, 9005810, 9008049))) AND ((product_cats_subcat.id=5351)) AND ((products.artist=5412)) AND (current_inventory.show=1) AND (products.missingimage=0) ORDER BY products.date_ol DESC, products.description LIMIT 0,12

Saved a6508a641e8e8ebc7f34b4640c6ac4a3:

From DB (0 seconds): Narrow by subsubcat

SELECT store_folders.id,store_folders.name,COUNT(*) ct FROM products JOIN product_cats AS product_cats_subcat ON (products.pid=product_cats_subcat.pid) 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=2) WHERE (products.store & 8=8) AND ((products.pid IN (9004879, 9004880, 9004890, 9004891, 9005109, 107477, 107471, 107476, 9008199, 9002994, 9002995, 9002996, 9003003, 9007862, 9007867, 9005517, 9005535, 9002755, 9002756, 9002761, 9007861, 9007863, 9007925, 9007927, 9007928, 9007931, 9008119, 9005184, 9007417, 9007415, 9007418, 9007660, 9005779, 9005782, 9005785, 9005787, 9005795, 9005799, 9005806, 9005807, 9005810, 9008049))) AND ((product_cats_subcat.id=5351)) AND ((products.artist=5412)) AND (current_inventory.show=1) AND (products.missingimage=0) AND store_folders.master=5351 GROUP BY gb_product_cats.id ORDER BY store_folders.name

Saved a9b203b91b4555780eb5a14bae68083c: Narrow by subsubcat

From DB (0 seconds): Narrow by theme

SELECT store_folders.id,store_folders.name,COUNT(*) ct FROM products JOIN product_cats AS product_cats_subcat ON (products.pid=product_cats_subcat.pid) 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 (products.store & 8=8) AND ((products.pid IN (9004879, 9004880, 9004890, 9004891, 9005109, 107477, 107471, 107476, 9008199, 9002994, 9002995, 9002996, 9003003, 9007862, 9007867, 9005517, 9005535, 9002755, 9002756, 9002761, 9007861, 9007863, 9007925, 9007927, 9007928, 9007931, 9008119, 9005184, 9007417, 9007415, 9007418, 9007660, 9005779, 9005782, 9005785, 9005787, 9005795, 9005799, 9005806, 9005807, 9005810, 9008049))) AND ((product_cats_subcat.id=5351)) AND ((products.artist=5412)) AND (current_inventory.show=1) AND (products.missingimage=0) GROUP BY gb_product_cats.id ORDER BY store_folders.name

Saved 24806214d9a2e5cb46433881df7545f1: Narrow by theme

From DB (0 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 product_cats AS product_cats_subcat ON (products.pid=product_cats_subcat.pid) JOIN current_inventory ON (current_inventory.pid=products.pid) WHERE (products.store & 8=8) AND ((products.pid IN (9004879, 9004880, 9004890, 9004891, 9005109, 107477, 107471, 107476, 9008199, 9002994, 9002995, 9002996, 9003003, 9007862, 9007867, 9005517, 9005535, 9002755, 9002756, 9002761, 9007861, 9007863, 9007925, 9007927, 9007928, 9007931, 9008119, 9005184, 9007417, 9007415, 9007418, 9007660, 9005779, 9005782, 9005785, 9005787, 9005795, 9005799, 9005806, 9005807, 9005810, 9008049))) AND ((product_cats_subcat.id=5351)) AND ((products.artist=5412)) AND (current_inventory.show=1) AND (products.missingimage=0) GROUP BY name ORDER BY IF(currentsaleprice>0 AND currentsaleprice<sellingprice,currentsaleprice,sellingprice)

Saved 162124afb36917dd6d752fc00a7f5dd0: Narrow by price