Digital Scrapbooking > Search: natural spring > Stacy Molter: A Cherry On Top

Total Queries: 28
Total Errors: 0
Total Cached Queries: 13
Total Cache Saved: 7
Total Query Time: 0.8

Total App Time: 0.94

Toggle Log

From DB (0 seconds):

SET NAMES 'utf8'

From DB (0 seconds):

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

From DB (0 seconds):

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

From Cache 9b20b9d3222bb9d8c163b4101cec1286:

From Cache 4d51ba714cefe31a81fc9fadd1c7f019:

From DB (0 seconds):

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

From Cache 8483559aa515a99f9a45a07a056ae6ef:

From DB (0 seconds):

SELECT name FROM store_folders WHERE id=11027

From Cache 1e34131d0ab783f3456dbee79d13054b:

From Cache 6dbfa683ea65d482c8f21cc46c6c4187:

From Cache 4d51ba714cefe31a81fc9fadd1c7f019:

From Cache 4f648c283ddd1ea14ac3243a2e330823:

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, sg._users_permissions WHERE _permissions.id=_users_permissions.permission_id AND _users_permissions.uid='4b098871e9ebd'

From Cache 2fc4cda7002c762debf43c3e645c3b6a:

From Cache 350e214b8d395e419b5b78447a51d435:

From DB (0 seconds):

SELECT products.pid,products.description,sub_name,mybasket.qty,store_folders_company.name company_name,store_folders_line.name line_name FROM mybasket JOIN products ON (mybasket.item=products.pid) LEFT JOIN current_inventory ON (mybasket.item=current_inventory.pid) LEFT JOIN store_folders store_folders_company ON (store_folders_company.id=products.company) LEFT JOIN store_folders store_folders_line ON (store_folders_line.id=products.line) WHERE mybasket.uid='4b098871e9ebd' AND mybasket.sid=0 AND mybasket.bid=0 AND (current_inventory.count-current_inventory.pending > 0 OR (onpreorder-count_preordered>0 AND preorder_fee>0)) AND mybasket.qty>0 AND hide=0 ORDER BY mybasket.stamp DESC LIMIT 20

From DB (0 seconds):

SELECT sum(if(preorder_fee>0,preorder_fee,if(products.currentsaleprice>0,products.currentsaleprice,products.sellingprice))*mybasket.qty) FROM mybasket JOIN current_inventory ON (mybasket.item=current_inventory.pid) JOIN products ON (mybasket.item=products.pid) WHERE mybasket.uid='4b098871e9ebd' AND mybasket.sid=0 AND mybasket.bid=0 AND (current_inventory.count-current_inventory.pending > 0 OR (onpreorder-count_preordered>0 AND preorder_fee>0)) AND products.hide=0

From DB (0 seconds):

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

Saved a6b5cbc7404dcdb6bdaa5d4f69287943:

From DB (0 seconds):

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

Saved 0256c74ff2d791584e4a6fa367f49b49:

From DB (0.16 seconds):

SELECT COUNT(*) FROM (SELECT 1 FROM products JOIN current_inventory ON (current_inventory.pid=products.pid) WHERE (products.store & 8=8) AND ((match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*' IN BOOLEAN MODE))) AND ((products.artist=11027)) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) GROUP BY IF(products.parent_pid,products.parent_pid,products.pid)) AS sub WHERE 12=12

Saved 6e3c93a2d9337349ff51d3e6f4c1b461:

From DB (0.16 seconds):

SELECT match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*') as rank,products.pid,products.itemnumber,products.description,parent_product.description as pdescription,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,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) WHERE (products.store & 8=8) AND ((match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*' IN BOOLEAN MODE))) AND ((products.artist=11027)) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) GROUP BY IF(products.parent_pid,products.parent_pid,products.pid) ORDER BY products.date_ol DESC, products.description LIMIT 0,12

Saved b3dd79ca2198c64d12316557df7341b9:

From DB (0.16 seconds):

SELECT match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*') as rank,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 (products.store & 8=8) AND ((match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*' IN BOOLEAN MODE))) AND ((products.artist=11027)) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) GROUP BY products.line ORDER BY store_folders.name

Saved a329aa883fb13e7edc522993aa5a6c62:

From DB (0.16 seconds):

SELECT match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*') as rank,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=1) WHERE (products.store & 8=8) AND ((match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*' IN BOOLEAN MODE))) AND ((products.artist=11027)) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) GROUP BY gb_product_cats.id ORDER BY store_folders.name

Saved eafe467265fdf2264ed7521b23577f13:

From DB (0.16 seconds):

SELECT match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*') as rank,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 (products.store & 8=8) AND ((match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*' IN BOOLEAN MODE))) AND ((products.artist=11027)) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) GROUP BY gb_product_cats.id ORDER BY store_folders.name

Saved fab5460bfb1f774788e575faafe643a1:

From Cache 1e34131d0ab783f3456dbee79d13054b:

From Cache 6dbfa683ea65d482c8f21cc46c6c4187:

From Cache 4d51ba714cefe31a81fc9fadd1c7f019:

From Cache 2346200d9304f52065ae1bbebeff9d22: