IceBB Debug

SQL (Total Queries: 8 / Total Time: 0.059881sec)

DB Engine: mysql
SELECT * FROM icebb_cache
Table:icebb_cache
Type:ALL
Rows returned:14
Time: 0.000404sec
SELECT * FROM `icebb_session_data` AS s LEFT JOIN `icebb_users` AS u ON s.user_id=u.id LEFT JOIN `icebb_groups` AS g ON u.user_group=g.gid WHERE (s.sid='5314f3255a6fe3dfd17a2a4f6f3d1198' AND s.ip='38.107.191.100') OR (u.id=0 AND s.ip='38.107.191.100') ORDER BY `id` DESC LIMIT 1
Table:s
Type:ALL
Rows returned:100
Time: 0.001776sec
INSERT INTO icebb_session_data (sid,user_id,username,ip,user_agent,last_action) VALUES('ae83b8385ff9d29978fa106677f274ff','0','Guest','38.107.191.100','CCBot/1.0 (+http://www.commoncrawl.org/bot.html)','1283658569')
Shutdown Query
Time: 7.7E-5sec
UPDATE icebb_users SET ip='38.107.191.100',last_visit='1283658569' WHERE id='0'
Shutdown Query
Time: 4.4E-5sec
SELECT u.*,g.* FROM icebb_users AS u LEFT JOIN icebb_groups AS g ON u.user_group=g.gid WHERE u.id=0 LIMIT 1
Table:u
Type:const
Possible keys:PRIMARY
Key:PRIMARY
Key Length:4
Reference:const
Rows returned:1
Time: 0.004021sec
SELECT * FROM icebb_moderators
Table:icebb_moderators
Type:system
Time: 0.000187sec
UPDATE icebb_session_data SET last_action='1283658569',act='',func='',topic=0,forum=0,profile=0 WHERE sid='5314f3255a6fe3dfd17a2a4f6f3d1198'
Time: 0.000874sec
SELECT u.id,u.user_group,s.*,g.* FROM icebb_session_data AS s LEFT JOIN icebb_users AS u ON s.user_id=u.id LEFT JOIN icebb_groups AS g ON g.gid=u.user_group WHERE last_action>1283657669
Table:s
Type:ALL
Rows returned:100
Time: 0.003826sec
SELECT * FROM icebb_ra_logs WHERE forum_id IN(1,2,3,4,5,6,8,9,10,14) ORDER BY time DESC LIMIT 0,5
Table:icebb_ra_logs
Type:ALL
Rows returned:205
Time: 0.001013sec
SELECT f.*,u.id as lastpost_authorid FROM icebb_forums AS f LEFT JOIN icebb_users AS u ON f.lastpost_author=u.username ORDER BY f.sort ASC
Table:f
Type:ALL
Rows returned:11
Time: 0.047659sec

Skin

Skin ID: default
Loaded templates: home, global
IceBB 1.0 / Back to forum