Digital Scrapbooking > Search: natural spring > Isabel Mendez: A Cherry On Top

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

Total App Time: 0.99

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.112')

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 fab4fca2618a48ba6bd40fe54bc83745:

From DB (0 seconds):

SELECT name FROM store_folders WHERE id=8322

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 Cache 3eee0b95bc35e98d088cc11c9e412e99:

From Cache 8f41c7723363f875a82c6818e1a6a83c:

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=8322)) 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 b13c5d766497bfaf5df7737f0dce00e3:

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=8322)) 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 af2039817b33b598ea8738ec70467edc:

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=8322)) 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 361791da5afb4a1149378610dc36023c:

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=8322)) 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 88ead67885b6278ac51019fb4a06e526:

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=8322)) 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 4f074a33f5245269fda7b852ff1a3181:

From Cache 1e34131d0ab783f3456dbee79d13054b:

From Cache 6dbfa683ea65d482c8f21cc46c6c4187:

From Cache 4d51ba714cefe31a81fc9fadd1c7f019:

From Cache 2346200d9304f52065ae1bbebeff9d22: