Digital Scrapbooking > Scrapbooking Companies: A Cherry On Top

Total Queries: 40
Total Errors: 0
Total Cached Queries: 34
Total Cache Saved: 0
Total Query Time: 0

Total App Time: 0.14

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 Cache 1e34131d0ab783f3456dbee79d13054b:

From Cache 6dbfa683ea65d482c8f21cc46c6c4187:

From Cache 4d51ba714cefe31a81fc9fadd1c7f019:

From Cache d1599bb25afa11db6863aac4085db276:

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 72301e3756dc1c8ac5bdd212c4a1664b:

From Cache 0928b8caa363ddf263466fd819e4bf8b:

From Cache 350e214b8d395e419b5b78447a51d435:

From Cache 1f56238475f62bf5bd352df78f3b26cc:

From Cache b19689bdb1b3a12628ae9e2cddb06a03:

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 472d65523056eee2760c8652fb2b8f53:

From Cache ac897055e5834ec1af1fa2282f3aa44f:

From Cache 5ea34fb7bc60aafbd06a26e45fe55ad7:

From Cache 0b13b350844d54e81ec00fbb89073c33:

From Cache 4536dbcadeaa79894c2aae11856d1a86:

From Cache efaaa73852150991c8625e1f176ac66e:

From Cache 65065bdfbd6c2b38ec01ec19ccf95b5c:

From Cache 4e9a07e02032569557dd9d903752ae47:

From Cache e69da56aa53603c6a48f03d1be86d421:

From Cache cbc2660079db885461407830e5a4b18e:

From Cache c634a72b4ac6d3628dee32b8395e3f6f:

From Cache e941d22f2f407a204915656a7915c0ef:

From Cache 0931536b36ed442434aa0d419a27e15a:

From Cache 11efea30df57d9ab371e89b8ec35f118:

From Cache c4a574d5174d875f22faae160718b267:

From Cache eecf909b42203c85568e4f4af3ccf654:

From Cache 0008defa3a786240b5b274e4b7eb32ac:

From Cache 5753d075e34c952371d652aeaf32f420: