View Single Post
Old December 31st, 2005, 01:56 PM   #2 (permalink)
ludachris
Member
Verified Customer
 
Join Date: Feb 2002
Posts: 247
Here's what the debugging says:

Page generated in 0.37720 seconds with 17 queries
1: SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,u.membergroupids FROM user u LEFT JOIN session s ON s.userid=u.userid WHERE u.userid='1' (0.00113 sec)
2: SELECT groupid,cpaccess,modaccess,uploadsize,uploads,comments,editpho,editposts,reqmod,highlight,bold,italic FROM ppc_usergroups WHERE groupid=6 LIMIT 1 (0.00018 sec)
3: SELECT id,ugnoupload,ugnoanno,ugnoview,ugnopost,catname,parent,children,thumbs,header,footer,headtags FROM ppc_categories (0.00014 sec)
4: SELECT id,header,footer,headtags,template FROM ppc_categories WHERE id=500 (0.00009 sec)
5: REPLACE INTO ppc_iponline (userid,ipaddr,date,what,item) VALUES ('ludachris','24.9.187.231','1136056351','index','') (0.00022 sec)
6: DELETE FROM ppc_iponline WHERE date < 1136055751 (0.00022 sec)
7: DELETE FROM ppc_iponline WHERE date < 1136055751 (0.00010 sec)
8: SELECT c.id, c.catname, c.description, c.catorder, c.parent, c.thumbs, c.children, c.products, p.id, p.user, p.userid, p.date FROM ppc_categories c LEFT JOIN ppc_products p ON c.lastproduct=p.id ORDER BY c.catorder ASC (0.00068 sec)
9: SELECT cat,laston FROM ppc_laston WHERE userid=1 (0.00011 sec)
10: SELECT item, count(*) FROM ppc_iponline GROUP BY item (0.00045 sec)
11: SELECT data FROM datastore WHERE title = 'userstats' (0.00009 sec)
12: SELECT SUM(views), count(*) FROM ppc_products WHERE approved=1 (0.00010 sec)
13: SELECT count(*) FROM ppc_comments (0.00006 sec)
14: SELECT amt_sold,ads_sold FROM ppc_stats (0.00006 sec)
15: SELECT userid,date FROM ppc_iponline ORDER BY date DESC (0.00032 sec)
16: SELECT id,user,userid,cat,title,bigimage,views, id*0+RAND() as rand_col FROM ppc_products WHERE approved=1 AND status=0 AND cat != 1 ORDER BY rand_col DESC (0.13006 sec)
ludachris is offline   Reply With Quote