Digital Scrapbooking > Search: natural spring

Total Queries: 28
Total Errors: 0
Total Cached Queries: 15
Total Cache Saved: 5
Total Query Time: 0.85

Total App Time: 1.02

Toggle Log

From DB (0 seconds):

SET NAMES 'utf8'

From DB (0 seconds):

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

From DB (0 seconds):

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

From Cache 9b20b9d3222bb9d8c163b4101cec1286:

From Cache 4d51ba714cefe31a81fc9fadd1c7f019:

From DB (0 seconds):

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

From Cache 014a3917d0120696bc2b4f08bde5656a:

From DB (0 seconds):

SELECT name FROM store_folders WHERE id=5349

From Cache 1e34131d0ab783f3456dbee79d13054b:

From Cache 6dbfa683ea65d482c8f21cc46c6c4187:

From Cache 4d51ba714cefe31a81fc9fadd1c7f019:

From Cache 66a4b47aa0d91719cf93fd839a8a9f0e:

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='4b089eab9d817'

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='4b089eab9d817' 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='4b089eab9d817' 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 Cache 516b4c5dd90f7d5515c94b2f4387e3d2:

From Cache 42ec0c99ee873afd70719e8590b5ef6d:

From DB (0.17 seconds):

SELECT COUNT(*) FROM (SELECT 1 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 ((match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*' IN BOOLEAN MODE))) AND ((product_cats_subcat.id=5349)) 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 e2450ba6c66e4e641060913ea6027744:

From DB (0.17 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 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) 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 ((product_cats_subcat.id=5349)) 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 243ffddb1fd1ddae101d8ca078309568:

From DB (0.17 seconds):

SELECT match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*') as rank,store_folders.name AS artist, 0 AS the_sub_level,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 store_folders ON (store_folders.id=products.artist) 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 ((product_cats_subcat.id=5349)) AND (products.hide=0) AND (products.hide_in_shop=0) AND (current_inventory.available>0) AND (products.missingimage=0) GROUP BY products.artist ORDER BY store_folders.name

Saved af0ecd575a3a9cf6ae236394c17021ce:

From DB (0.17 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 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 ((match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*' IN BOOLEAN MODE))) AND ((product_cats_subcat.id=5349)) 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 5298991faac73920e46ceea7fb066797:

From DB (0.17 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 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 ((match (products.description,products.notes,products.itemnumber,products.upc,products.keyword1,products.searchstring) against ('natural* spring*' IN BOOLEAN MODE))) AND ((product_cats_subcat.id=5349)) 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 ff4b6cef1668fc9f577cd090ecfa6e17:

From Cache 1e34131d0ab783f3456dbee79d13054b:

From Cache 6dbfa683ea65d482c8f21cc46c6c4187:

From Cache 4d51ba714cefe31a81fc9fadd1c7f019:

From Cache 3affaa231078331bd885f60877e8056f:

Alphabets