That was the week, that was: January 9th 2010

With ongoing grateful thanks to the Wall Street Journal for kindly providing such a neat summary, and so – for Saturday January ^9th 2010 – here’s what was hot during the past week, and what……wasn’t;

March 2010
M	T	W	T	F	S	S
« Feb
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

No.	Query	Time (ms)
1	SELECT option_value FROM wp_options WHERE option_name = '' LIMIT 1	0.2
2	SELECT option_value FROM wp_options WHERE option_name = 'widget_killer_recent_entries' LIMIT 1	0.1
3	SELECT option_value FROM wp_options WHERE option_name = 'regplus_password' LIMIT 1	0.1
4	SELECT option_value FROM wp_options WHERE option_name = 'regplus_code' LIMIT 1	0.1
5	SELECT option_value FROM wp_options WHERE option_name = 'regplus_codepass' LIMIT 1	0.1
6	SELECT option_value FROM wp_options WHERE option_name = 'regplus_captcha' LIMIT 1	0.1
7	SELECT autoload FROM wp_options WHERE option_name = 'regplus_password'	0.1
8	SELECT autoload FROM wp_options WHERE option_name = 'regplus_code'	0.1
9	SELECT autoload FROM wp_options WHERE option_name = 'regplus_codepass'	0.1
10	SELECT autoload FROM wp_options WHERE option_name = 'regplus_captcha'	0.1
11	SELECT user_id, meta_value FROM wp_usermeta WHERE meta_key='email_verify_date'	0.1
12	SHOW TABLES LIKE 'wp_subscribe2'	0.3
13	SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = 'that-was-the-week-that-was-20100109' AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC	0.6
14	SELECT t., tt., tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (6709) ORDER BY t.name ASC	0.7
15	SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (6709)	0.2
16	SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (6709) ORDER BY t.name ASC	0.4
17	SELECT * FROM wp_posts WHERE ID = 5 LIMIT 1	0.1
18	SELECT * FROM wp_posts WHERE ID = 3 LIMIT 1	0.1
19	SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 5 AND wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC	0.1
20	SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 3 AND wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC	0.1
21	SELECT * FROM wp_users WHERE ID = 2 LIMIT 1	0.1
22	SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = 2	0.1
23	SELECT * FROM wp_comments WHERE comment_post_ID = 6709 AND comment_approved = '1' ORDER BY comment_date_gmt ASC	0.3
24	SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2010-01-09 07:00:08' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date DESC LIMIT 1	0.3
25	SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2010-01-09 07:00:08' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date ASC LIMIT 1	0.6
26	SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND tt.count > 0 ORDER BY t.name ASC	0.2
27	SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year FROM wp_posts WHERE post_date < '2010-03-01' AND post_type = 'post' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1	0.1
28	SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year FROM wp_posts WHERE post_date > '2010-03-01' AND MONTH( post_date ) != MONTH( '2010-03-01' ) AND post_type = 'post' AND post_status = 'publish' ORDER BY post_date ASC LIMIT 1	0.1
29	SELECT DISTINCT DAYOFMONTH(post_date) FROM wp_posts WHERE MONTH(post_date) = '03' AND YEAR(post_date) = '2010' AND post_type = 'post' AND post_status = 'publish' AND post_date < '2010-03-10 14:57:31'	1.2
30	SELECT post_title, DAYOFMONTH(post_date) as dom FROM wp_posts WHERE YEAR(post_date) = '2010' AND MONTH(post_date) = '03' AND post_date < '2010-03-10 14:57:31' AND post_type = 'post' AND post_status = 'publish'	3.9
31	SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC	0.1
32	SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('link_category') AND tt.count > 0 ORDER BY t.name ASC	0.1
33	SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 8 ) AND taxonomy = 'link_category' ORDER BY link_name ASC	0.1
34	SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 9 ) AND taxonomy = 'link_category' ORDER BY link_name ASC	0.2
35	SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 10 ) AND taxonomy = 'link_category' ORDER BY link_name ASC	0.2
36	SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 11 ) AND taxonomy = 'link_category' ORDER BY link_name ASC	0.2
37	SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 12 ) AND taxonomy = 'link_category' ORDER BY link_name ASC	0.2
38	SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 14 ) AND taxonomy = 'link_category' ORDER BY link_name ASC	0.1
39	SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 15 ) AND taxonomy = 'link_category' ORDER BY link_name ASC	0.2
40	SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 16 ) AND taxonomy = 'link_category' ORDER BY link_name ASC	0.2
41	SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 17 ) AND taxonomy = 'link_category' ORDER BY link_name ASC	0.2
42	SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 18 ) AND taxonomy = 'link_category' ORDER BY link_name ASC	0.1
43	SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 19 ) AND taxonomy = 'link_category' ORDER BY link_name ASC	0.2
Total time: 12.5 ms

No.

Query

Time (ms)

SELECT option_value FROM wp_options WHERE option_name = '' LIMIT 1

0.2

SELECT option_value FROM wp_options WHERE option_name = 'widget_killer_recent_entries' LIMIT 1

0.1

SELECT option_value FROM wp_options WHERE option_name = 'regplus_password' LIMIT 1

0.1

SELECT option_value FROM wp_options WHERE option_name = 'regplus_code' LIMIT 1

0.1

SELECT option_value FROM wp_options WHERE option_name = 'regplus_codepass' LIMIT 1

0.1

SELECT option_value FROM wp_options WHERE option_name = 'regplus_captcha' LIMIT 1

0.1

SELECT autoload FROM wp_options WHERE option_name = 'regplus_password'

0.1

SELECT autoload FROM wp_options WHERE option_name = 'regplus_code'

0.1

SELECT autoload FROM wp_options WHERE option_name = 'regplus_codepass'

0.1

SELECT autoload FROM wp_options WHERE option_name = 'regplus_captcha'

0.1

SELECT user_id, meta_value FROM wp_usermeta WHERE meta_key='email_verify_date'

0.1

SHOW TABLES LIKE 'wp_subscribe2'

0.3

 SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_name = 'that-was-the-week-that-was-20100109' AND wp_posts.post_type = 'post'  ORDER BY wp_posts.post_date DESC

0.6

SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (6709) ORDER BY t.name ASC

0.7

SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (6709)

0.2

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (6709) ORDER BY t.name ASC

0.4

SELECT * FROM wp_posts WHERE ID = 5 LIMIT 1

0.1

SELECT * FROM wp_posts WHERE ID = 3 LIMIT 1

0.1

 SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_parent = 5  AND wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC

0.1

 SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_parent = 3  AND wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC

0.1

SELECT * FROM wp_users WHERE ID = 2 LIMIT 1

0.1

SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = 2

0.1

SELECT * FROM wp_comments WHERE comment_post_ID = 6709 AND comment_approved = '1' ORDER BY comment_date_gmt ASC

0.3

SELECT p.* FROM wp_posts AS p  WHERE p.post_date < '2010-01-09 07:00:08' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date DESC LIMIT 1

0.3

SELECT p.* FROM wp_posts AS p  WHERE p.post_date > '2010-01-09 07:00:08' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date ASC LIMIT 1

0.6

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category')  AND tt.count > 0 ORDER BY t.name ASC

0.2

SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year
		FROM wp_posts
		WHERE post_date < '2010-03-01'
		AND post_type = 'post' AND post_status = 'publish'
			ORDER BY post_date DESC
			LIMIT 1

0.1

SELECT	DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year
		FROM wp_posts
		WHERE post_date >	'2010-03-01'
		AND MONTH( post_date ) != MONTH( '2010-03-01' )
		AND post_type = 'post' AND post_status = 'publish'
			ORDER	BY post_date ASC
			LIMIT 1

0.1

SELECT DISTINCT DAYOFMONTH(post_date)
		FROM wp_posts WHERE MONTH(post_date) = '03'
		AND YEAR(post_date) = '2010'
		AND post_type = 'post' AND post_status = 'publish'
		AND post_date < '2010-03-10 14:57:31'

1.2

SELECT post_title, DAYOFMONTH(post_date) as dom FROM wp_posts WHERE YEAR(post_date) = '2010' AND MONTH(post_date) = '03' AND post_date < '2010-03-10 14:57:31' AND post_type = 'post' AND post_status = 'publish'

3.9

SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts  WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

0.1

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('link_category')  AND tt.count > 0 ORDER BY t.name ASC

0.1

SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 8 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC

0.1

SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 9 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC

0.2

SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 10 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC

0.2

SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 11 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC

0.2

SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 12 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC

0.2

SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 14 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC

0.1

SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 15 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC

0.2

SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 16 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC

0.2

SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 17 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC

0.2

SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 18 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC

0.1

SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 19 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC

0.2

Total time: 12.5 ms

1	muplugins_loaded
2	load_textdomain
3	load_textdomain
4	plugins_loaded
5	sanitize_comment_cookies
6	setup_theme
7	load_textdomain
8	load_textdomain
9	auth_cookie_malformed
10	set_current_user
11	init
12	load_textdomain
13	widgets_init
14	load_textdomain
15	wp_default_scripts
16	wp_default_styles
17	load_textdomain
18	parse_request
19	send_headers
20	parse_query
21	pre_get_posts
22	posts_selection
23	wp
24	template_redirect
25	get_header
26	wp_head
27	wp_enqueue_scripts
28	wp_print_styles
29	wp_print_scripts
30	thesis_hook_before_html
31	thesis_hook_before_header
32	thesis_hook_header
33	thesis_hook_before_title
34	thesis_hook_after_title
35	thesis_hook_after_header
36	thesis_hook_first_nav_item
37	parse_query
38	pre_get_posts
39	posts_selection
40	parse_query
41	pre_get_posts
42	posts_selection
43	thesis_hook_last_nav_item
44	thesis_hook_before_content_box
45	thesis_hook_before_content
46	loop_start
47	the_post
48	thesis_hook_before_post_box
49	thesis_hook_before_headline
50	thesis_hook_after_headline
51	thesis_hook_byline_item
52	thesis_hook_before_post
53	deprecated_function_run
54	thesis_hook_after_post
55	thesis_hook_after_post_box
56	thesis_hook_after_comments
57	thesis_hook_comment_field
58	thesis_hook_comment_form
59	comment_form
60	loop_end
61	thesis_hook_after_content
62	thesis_hook_before_sidebar_1
63	thesis_hook_after_sidebar_1
64	thesis_hook_before_sidebars
65	thesis_hook_before_sidebar_2
66	thesis_hook_after_sidebar_2
67	thesis_hook_after_sidebars
68	thesis_hook_after_content_box
69	thesis_hook_before_footer
70	thesis_hook_footer
71	wp_footer
72	wp_print_footer_scripts

That was the week, that was: January 9th 2010

Categories

Archives

What We Read

We read - Advocacy

We read - Economics

We read - Energy

We read - Europe/EU

We read - Fun

We read - Intl/FP

We read - Markets

We read - Miltary

We read - Misc

We read - Politics UK

We read - Politics US