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
This was one of the newest logs, I'm not familiar with cron jobs. Are these done on vB or on the server? Should I assume my host cannot handle the demands of my site?