Links
Categories: Unclassifiable, 0 wordsSend feedback •Permalink
http://grahamshevlin.com/b2evo///htsrv/trackback.php/984
No Comments/Trackbacks/Pingbacks for this post yet...
| Timers | |||
|---|---|---|---|
| Category | Time | % | Count |
| total | 0.183 | 100.00% | 1 |
| main.inc | 0.095 | 51.91% | 1 |
| skin/_main.inc | 0.072 | 39.34% | 1 |
| sql_queries | 0.058 | 31.69% | 22 |
| _blog_main.inc | 0.010 | 5.46% | 1 |
| plugins_register | 0.005 | 2.73% | 2 |
| + 7 < 0.005s | |||
SELECT set_name, set_value
FROM evo_settings
SELECT agnt_ID
FROM evo_useragents
WHERE agnt_signature = "CCBot/1.0 (+http://www.commoncrawl.org/bot.html)"
AND agnt_type = "unknown"
INSERT INTO evo_sessions( sess_key, sess_lastseen, sess_ipaddress )
VALUES (
'Cr4bz3fD3Fel992WJoQWrkkJJJnhIlgQ',
'2008-08-28 05:26:14',
'38.103.63.59'
)
SELECT pevt_plug_ID, pevt_event
FROM evo_pluginevents INNER JOIN evo_plugins ON pevt_plug_ID = plug_ID
WHERE pevt_enabled > 0
AND plug_status = "enabled"
ORDER BY plug_priority, plug_classname
SELECT
loc_locale, loc_charset, loc_datefmt, loc_timefmt, loc_startofweek,
loc_name, loc_messages, loc_priority, loc_enabled
FROM evo_locales
ORDER BY loc_priority
SET NAMES latin1
SELECT *
FROM evo_blogs
WHERE blog_urlname = 'techlink'
SELECT DISTINCT post_ID
FROM evo_posts INNER JOIN evo_postcats ON post_ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE (post_urltitle = 'zen_habits')
AND (cat_blog_ID = 5)
AND ( ( post_status IN ('published') ) )
AND (post_datestart <= '2008-08-28 05:26:14')
ORDER BY post_datestart DESC
SELECT *
FROM evo_posts
WHERE post_ID IN (984)
ORDER BY post_datestart DESC
SELECT cat_ID, cat_parent_ID, cat_name, cat_blog_ID
FROM evo_categories
ORDER BY cat_name
SELECT COUNT( DISTINCT post_ID )
FROM evo_posts INNER JOIN evo_postcats ON post_ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE (post_urltitle = 'zen_habits')
AND (cat_blog_ID = 5)
AND ( ( post_status IN ('published') ) )
AND (post_datestart <= '2008-08-28 05:26:14')
SELECT plug_ID, plug_priority, plug_classname, plug_code, plug_name, plug_shortdesc, plug_apply_rendering, plug_status, plug_version, plug_spam_weight
FROM evo_plugins
WHERE plug_status = "enabled"
ORDER BY plug_priority, plug_classname
SELECT *
FROM evo_posts
WHERE post_urltitle = 'zen_habits'
SELECT *
FROM evo_blogs
ORDER BY blog_ID
SELECT postcat_post_ID, postcat_cat_ID
FROM evo_postcats
WHERE postcat_post_ID IN (984)
ORDER BY postcat_post_ID, postcat_cat_ID
SELECT hit_ID
FROM evo_hitlog INNER JOIN evo_useragents
ON hit_agnt_ID = agnt_ID
WHERE hit_datetime > "2008-08-28 05:21:14"
AND hit_remote_addr = '38.103.63.59'
AND hit_uri = "/b2evo///index.php/techlink/2007/11/06/zen_habits"
AND agnt_signature = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
LIMIT 1
UPDATE evo_posts
SET post_views = post_views + 1
WHERE post_ID = 984
SELECT itpr_content_prerendered
FROM evo_item__prerendering
WHERE itpr_itm_ID = 984
AND itpr_format = "htmlbody"
AND itpr_renderers = "b2evALnk.b2WPAutP"
SELECT comment_post_ID, comment_type, comment_status, COUNT(*) AS type_count
FROM evo_comments
WHERE comment_post_ID IN (984)
GROUP BY comment_post_ID, comment_type, comment_status
SELECT DISTINCT evo_comments.*
FROM evo_comments INNER JOIN evo_posts ON comment_post_ID = post_ID
WHERE comment_post_ID = 984
AND comment_type IN ('comment','trackback','pingback')
AND comment_status IN ('published')
AND ( post_status IN ('published') )
ORDER BY comment_date ASC
SELECT pset_plug_ID, pset_name, pset_value
FROM evo_pluginsettings
WHERE pset_plug_ID = "8"
INSERT INTO evo_hitlog(
hit_sess_ID, hit_datetime, hit_uri, hit_referer_type,
hit_referer, hit_referer_dom_ID, hit_blog_ID, hit_remote_addr, hit_agnt_ID )
VALUES( "616727",
FROM_UNIXTIME(1219915574), "/b2evo///index.php/techlink/2007/11/06/zen_habits", "direct", "", NULL, 5, "38.103.63.59", 3956
)