The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#5
|
|||
|
|||
![]() Code:
# Fri Feb 1 21:35:10 2013 # Query_time: 2.246202 Lock_time: 0.000078 Rows_sent: 0 Rows_examined: 1 use fromthe4_vbulletin; SET timestamp=1359779710; UPDATE cron SET nextrun = 1359783300 WHERE cronid = 29 AND nextrun = 1359779700 # Fri Feb 1 21:35:17 2013 # Query_time: 4.330291 Lock_time: 0.000187 Rows_sent: 0 Rows_examined: 6 use fromthe4_vbulletin; SET timestamp=1359779717; UPDATE blog AS blog,blog_aggregate_temp_1359779700 AS aggregate SET blog.views = blog.views + aggregate.views WHERE blog.blogid = aggregate.blogid # Fri Feb 1 21:35:22 2013 # Query_time: 4.497857 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 use fromthe4_vbulletin; SET timestamp=1359779722; DROP TABLE IF EXISTS blog_aggregate_temp_1359779700 # Fri Feb 1 21:35:40 2013 # Query_time: 9.925802 Lock_time: 3.490327 Rows_sent: 17 Rows_examined: 17 use fromthe4_vbulletin; SET timestamp=1359779740; SELECT * FROM datastore WHERE title IN ('smiliecache','bbcodecache','banemail','ranks','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream') # Fri Feb 1 21:35:47 2013 # Query_time: 6.873099 Lock_time: 4.622681 Rows_sent: 0 Rows_examined: 0 use fromthe4_vbulletin; SET timestamp=1359779747; SELECT * FROM session WHERE userid = 0 AND host = '66.249.73.132' AND idhash = '021beeb527c7c95112d9c8c95547709a' LIMIT 1 # Fri Feb 1 21:35:52 2013 # Query_time: 7.974552 Lock_time: 1.364796 Rows_sent: 1 Rows_examined: 1 use fromthe4_vbulletin; SET timestamp=1359779752; SELECT * FROM session WHERE sessionhash = 'cdd25f1b226e193ff2acd18325c3a616' AND lastactivity > 1359778844 AND idhash = '6aeb64ee0ea98ee32e7312b54577a0ec' # Fri Feb 1 21:35:52 2013 # Query_time: 11.414806 Lock_time: 4.626423 Rows_sent: 0 Rows_examined: 0 use fromthe4_vbulletin; SET timestamp=1359779752; SELECT * FROM session WHERE userid = 0 AND host = '72.223.6.85' AND idhash = 'aaebcd6f362ba57662b1cc3b0ee9b424' LIMIT 1 # Fri Feb 1 21:36:33 2013 # Query_time: 5.683098 Lock_time: 0.000054 Rows_sent: 0 Rows_examined: 1 use fromthe4_vbulletin; SET timestamp=1359779793; UPDATE cron SET nextrun = 1359779820 WHERE cronid = 32 AND nextrun = 1359779760 # Fri Feb 1 21:40:01 2013 # Query_time: 1.195400 Lock_time: 0.000120 Rows_sent: 1 Rows_examined: 1 use fromthe4_vbulletin; SET timestamp=1359780001; SELECT IF(thread.visible = 2, 1, 0) AS isdeleted, post.pagetext AS description, thread.* FROM thread AS thread LEFT JOIN post AS post ON(post.postid = thread.firstpostid) WHERE thread.threadid = 99 # Fri Feb 1 21:47:43 2013 # Query_time: 2.975253 Lock_time: 0.806965 Rows_sent: 1 Rows_examined: 1 use fromthe4_vbulletin; SET timestamp=1359780463; SELECT * FROM session WHERE userid = 0 AND host = '173.199.119.59' AND idhash = '1d41bce29a10b8fdb3d72b2fbac134e8' LIMIT 1 # Fri Feb 1 21:47:55 2013 # Query_time: 5.401879 Lock_time: 3.340980 Rows_sent: 17 Rows_examined: 17 use fromthe4_vbulletin; SET timestamp=1359780475; SELECT * FROM datastore WHERE title IN ('smiliecache','bbcodecache','mailqueue','bookmarksitecache','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream') # Fri Feb 1 21:50:45 2013 # Query_time: 4.390896 Lock_time: 2.244348 Rows_sent: 17 Rows_examined: 17 use fromthe4_vbulletin; SET timestamp=1359780645; SELECT * FROM datastore WHERE title IN ('smiliecache','bbcodecache','mailqueue','bookmarksitecache','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream') # Fri Feb 1 21:52:27 2013 # Query_time: 1.704731 Lock_time: 0.189938 Rows_sent: 2 Rows_examined: 15 use fromthe4_vbulletin; SET timestamp=1359780747; SELECT post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted, user.*, userfield.*, usertextfield.*, icon.title as icontitle, icon.iconpath, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory, postparsed.pagetext_html, postparsed.hasimages, sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid ,blog_user.entries FROM post AS post LEFT JOIN user AS user ON(user.userid = post.userid) LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid) LEFT JOIN icon AS icon ON(icon.iconid = post.iconid) LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid) LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 3 AND postparsed.languageid = 1) LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 3 AND sigparsed.languageid = 1) LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid) LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = post.userid) WHERE post.postid IN (0467,1485) ORDER BY post.dateline http://pastebin.com/4p9SaJzY Example of another, but much larger log. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|