Links
Categories: Industry News, 0 wordsSend feedback •Permalink
http://grahamshevlin.com/b2evo///htsrv/trackback.php/554
No Comments/Trackbacks/Pingbacks for this post yet...
| Timers | |||
|---|---|---|---|
| Category | Time | % | Count |
| total | 0.242 | 100.00% | 1 |
| skin/_main.inc | 0.118 | 48.76% | 1 |
| sql_queries | 0.114 | 47.11% | 22 |
| main.inc | 0.098 | 40.50% | 1 |
| _blog_main.inc | 0.020 | 8.26% | 1 |
| plugins_register | 0.005 | 2.07% | 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 (
'7f3pZi2A3C7bD6XLDxQow3AGiQgLNpbT',
'2008-08-28 05:17:00',
'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 = 'loosely_coupled')
AND (cat_blog_ID = 5)
AND ( ( post_status IN ('published') ) )
AND (post_datestart <= '2008-08-28 05:17:00')
ORDER BY post_datestart DESC
SELECT *
FROM evo_posts
WHERE post_ID IN (554)
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 = 'loosely_coupled')
AND (cat_blog_ID = 5)
AND ( ( post_status IN ('published') ) )
AND (post_datestart <= '2008-08-28 05:17:00')
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 = 'loosely_coupled'
SELECT *
FROM evo_blogs
ORDER BY blog_ID
SELECT postcat_post_ID, postcat_cat_ID
FROM evo_postcats
WHERE postcat_post_ID IN (554)
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:12:00"
AND hit_remote_addr = '38.103.63.59'
AND hit_uri = "/b2evo///index.php/techlink/2006/01/04/loosely_coupled"
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 = 554
SELECT itpr_content_prerendered
FROM evo_item__prerendering
WHERE itpr_itm_ID = 554
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 (554)
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 = 554
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( "616697",
FROM_UNIXTIME(1219915020), "/b2evo///index.php/techlink/2006/01/04/loosely_coupled", "direct", "", NULL, 5, "38.103.63.59", 3956
)