Zombie Driver Review

admin

Published: January 31, 2010Posted in: NewsTags: Zombie Driver

Game reviews on bit-tech are usually at least two pages long, stretching to double that for epics such as Mass Effect 2. When it comes to Zombie Driver though, even two pages, I think, would require serious padding – such as some speculation on the iPad and the future of the human race… and how its lack of multi-tasking means we’re all going to turn into zombies.

Link

About the Author

No.	Query	Time (ms)
1	SELECT autoload FROM il52_options WHERE option_name = 'rewrite_rules'	0.5
2	DELETE FROM il52_options WHERE option_name = 'rewrite_rules'	0.3
3	SELECT option_value FROM il52_options WHERE option_name = 'rewrite_rules' LIMIT 1	0.1
4	INSERT INTO `il52_options` (`option_name`, `option_value`, `autoload`) VALUES ('rewrite_rules', 'a:85:{s:12:\"robots\\.txt$\";s:18:\"index.php?robots=1\";s:14:\".wp-atom.php$\";s:19:\"index.php?feed=atom\";s:13:\".wp-rdf.php$\";s:18:\"index.php?feed=rdf\";s:13:\".wp-rss.php$\";s:18:\"index.php?feed=rss\";s:14:\".wp-rss2.php$\";s:19:\"index.php?feed=rss2\";s:14:\".wp-feed.php$\";s:19:\"index.php?feed=feed\";s:22:\".wp-commentsrss2.php$\";s:34:\"index.php?feed=rss2&withcomments=1\";s:32:\"feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:27:\"index.php?&feed=$matches[1]\";s:27:\"(feed\|rdf\|rss\|rss2\|atom)/?$\";s:27:\"index.php?&feed=$matches[1]\";s:20:\"page/?([0-9]{1,})/?$\";s:28:\"index.php?&paged=$matches[1]\";s:14:\"all(/(.))?/?$\";s:26:\"index.php?&all=$matches[2]\";s:41:\"comments/feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:42:\"index.php?&feed=$matches[1]&withcomments=1\";s:36:\"comments/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:42:\"index.php?&feed=$matches[1]&withcomments=1\";s:29:\"comments/page/?([0-9]{1,})/?$\";s:28:\"index.php?&paged=$matches[1]\";s:23:\"comments/all(/(.))?/?$\";s:26:\"index.php?&all=$matches[2]\";s:44:\"search/(.+)/feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:40:\"index.php?s=$matches[1]&feed=$matches[2]\";s:39:\"search/(.+)/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:40:\"index.php?s=$matches[1]&feed=$matches[2]\";s:32:\"search/(.+)/page/?([0-9]{1,})/?$\";s:41:\"index.php?s=$matches[1]&paged=$matches[2]\";s:26:\"search/(.+)/all(/(.))?/?$\";s:39:\"index.php?s=$matches[1]&all=$matches[3]\";s:14:\"search/(.+)/?$\";s:23:\"index.php?s=$matches[1]\";s:47:\"category/(.+?)/feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:52:\"index.php?category_name=$matches[1]&feed=$matches[2]\";s:42:\"category/(.+?)/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:52:\"index.php?category_name=$matches[1]&feed=$matches[2]\";s:35:\"category/(.+?)/page/?([0-9]{1,})/?$\";s:53:\"index.php?category_name=$matches[1]&paged=$matches[2]\";s:29:\"category/(.+?)/all(/(.))?/?$\";s:51:\"index.php?category_name=$matches[1]&all=$matches[3]\";s:17:\"category/(.+?)/?$\";s:35:\"index.php?category_name=$matches[1]\";s:42:\"tag/(.+?)/feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:42:\"index.php?tag=$matches[1]&feed=$matches[2]\";s:37:\"tag/(.+?)/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:42:\"index.php?tag=$matches[1]&feed=$matches[2]\";s:30:\"tag/(.+?)/page/?([0-9]{1,})/?$\";s:43:\"index.php?tag=$matches[1]&paged=$matches[2]\";s:24:\"tag/(.+?)/all(/(.))?/?$\";s:41:\"index.php?tag=$matches[1]&all=$matches[3]\";s:12:\"tag/(.+?)/?$\";s:25:\"index.php?tag=$matches[1]\";s:47:\"author/([^/]+)/feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:50:\"index.php?author_name=$matches[1]&feed=$matches[2]\";s:42:\"author/([^/]+)/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:50:\"index.php?author_name=$matches[1]&feed=$matches[2]\";s:35:\"author/([^/]+)/page/?([0-9]{1,})/?$\";s:51:\"index.php?author_name=$matches[1]&paged=$matches[2]\";s:29:\"author/([^/]+)/all(/(.))?/?$\";s:49:\"index.php?author_name=$matches[1]&all=$matches[3]\";s:17:\"author/([^/]+)/?$\";s:33:\"index.php?author_name=$matches[1]\";s:69:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:80:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]\";s:64:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:80:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]\";s:57:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/page/?([0-9]{1,})/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&paged=$matches[4]\";s:51:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/all(/(.))?/?$\";s:79:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&all=$matches[5]\";s:39:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/?$\";s:63:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]\";s:56:\"([0-9]{4})/([0-9]{1,2})/feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:64:\"index.php?year=$matches[1]&monthnum=$matches[2]&feed=$matches[3]\";s:51:\"([0-9]{4})/([0-9]{1,2})/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:64:\"index.php?year=$matches[1]&monthnum=$matches[2]&feed=$matches[3]\";s:44:\"([0-9]{4})/([0-9]{1,2})/page/?([0-9]{1,})/?$\";s:65:\"index.php?year=$matches[1]&monthnum=$matches[2]&paged=$matches[3]\";s:38:\"([0-9]{4})/([0-9]{1,2})/all(/(.))?/?$\";s:63:\"index.php?year=$matches[1]&monthnum=$matches[2]&all=$matches[4]\";s:26:\"([0-9]{4})/([0-9]{1,2})/?$\";s:47:\"index.php?year=$matches[1]&monthnum=$matches[2]\";s:43:\"([0-9]{4})/feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:43:\"index.php?year=$matches[1]&feed=$matches[2]\";s:38:\"([0-9]{4})/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:43:\"index.php?year=$matches[1]&feed=$matches[2]\";s:31:\"([0-9]{4})/page/?([0-9]{1,})/?$\";s:44:\"index.php?year=$matches[1]&paged=$matches[2]\";s:25:\"([0-9]{4})/all(/(.))?/?$\";s:42:\"index.php?year=$matches[1]&all=$matches[3]\";s:13:\"([0-9]{4})/?$\";s:26:\"index.php?year=$matches[1]\";s:47:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/?$\";s:32:\"index.php?attachment=$matches[1]\";s:57:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/trackback/?$\";s:37:\"index.php?attachment=$matches[1]&tb=1\";s:77:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:72:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:72:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/comment-page-([0-9]{1,})/?$\";s:50:\"index.php?attachment=$matches[1]&cpage=$matches[2]\";s:44:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/trackback/?$\";s:69:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&tb=1\";s:64:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&feed=$matches[4]\";s:59:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&feed=$matches[4]\";s:52:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/page/?([0-9]{1,})/?$\";s:82:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&paged=$matches[4]\";s:59:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/comment-page-([0-9]{1,})/?$\";s:82:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&cpage=$matches[4]\";s:46:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/all(/(.))?/?$\";s:80:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&all=$matches[5]\";s:48:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/all(/(.))?/?$\";s:48:\"index.php?attachment=$matches[1]&all=$matches[2]\";s:59:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/all(/(.))?/?$\";s:48:\"index.php?attachment=$matches[1]&all=$matches[2]\";s:44:\"([0-9]{4})/([0-9]{1,2})/([^/]+)(/[0-9]+)?/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&page=$matches[4]\";s:36:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/?$\";s:32:\"index.php?attachment=$matches[1]\";s:46:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/trackback/?$\";s:37:\"index.php?attachment=$matches[1]&tb=1\";s:66:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:61:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:61:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/comment-page-([0-9]{1,})/?$\";s:50:\"index.php?attachment=$matches[1]&cpage=$matches[2]\";s:51:\"([0-9]{4})/([0-9]{1,2})/comment-page-([0-9]{1,})/?$\";s:65:\"index.php?year=$matches[1]&monthnum=$matches[2]&cpage=$matches[3]\";s:38:\"([0-9]{4})/comment-page-([0-9]{1,})/?$\";s:44:\"index.php?year=$matches[1]&cpage=$matches[2]\";s:25:\".+?/attachment/([^/]+)/?$\";s:32:\"index.php?attachment=$matches[1]\";s:35:\".+?/attachment/([^/]+)/trackback/?$\";s:37:\"index.php?attachment=$matches[1]&tb=1\";s:55:\".+?/attachment/([^/]+)/feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:50:\".+?/attachment/([^/]+)/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:50:\".+?/attachment/([^/]+)/comment-page-([0-9]{1,})/?$\";s:50:\"index.php?attachment=$matches[1]&cpage=$matches[2]\";s:18:\"(.+?)/trackback/?$\";s:35:\"index.php?pagename=$matches[1]&tb=1\";s:38:\"(.+?)/feed/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:47:\"index.php?pagename=$matches[1]&feed=$matches[2]\";s:33:\"(.+?)/(feed\|rdf\|rss\|rss2\|atom)/?$\";s:47:\"index.php?pagename=$matches[1]&feed=$matches[2]\";s:26:\"(.+?)/page/?([0-9]{1,})/?$\";s:48:\"index.php?pagename=$matches[1]&paged=$matches[2]\";s:33:\"(.+?)/comment-page-([0-9]{1,})/?$\";s:48:\"index.php?pagename=$matches[1]&cpage=$matches[2]\";s:20:\"(.+?)/all(/(.))?/?$\";s:46:\"index.php?pagename=$matches[1]&all=$matches[3]\";s:26:\".+?/([^/]+)/all(/(.))?/?$\";s:48:\"index.php?attachment=$matches[1]&all=$matches[2]\";s:37:\".+?/attachment/([^/]+)/all(/(.))?/?$\";s:48:\"index.php?attachment=$matches[1]&all=$matches[2]\";s:18:\"(.+?)(/[0-9]+)?/?$\";s:47:\"index.php?pagename=$matches[1]&page=$matches[2]\";}', 'yes') ON DUPLICATE KEY* UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)	0.8
5	SELECT option_value FROM il52_options WHERE option_name = 'polldaddy_multiple_accounts' LIMIT 1	0.3
6	SELECT il52_posts.* FROM il52_posts WHERE 1=1 AND YEAR(il52_posts.post_date)='2010' AND MONTH(il52_posts.post_date)='1' AND il52_posts.post_name = 'zombie-driver-review' AND il52_posts.post_type = 'post' ORDER BY il52_posts.post_date DESC	0.8
7	SELECT t., tt., tr.object_id FROM il52_terms AS t INNER JOIN il52_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN il52_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 (2044) ORDER BY t.name ASC	1.1
8	SELECT post_id, meta_key, meta_value FROM il52_postmeta WHERE post_id IN (2044)	0.2
9	SELECT ID FROM il52_posts WHERE post_name = 'zombie-driver-review'	0.4
10	SELECT * FROM il52_users WHERE ID = 1 LIMIT 1	0.1
11	SELECT meta_key, meta_value FROM il52_usermeta WHERE user_id = 1	0.1
12	SELECT SQL_CALC_FOUND_ROWS il52_posts.* FROM il52_posts WHERE 1=1 AND il52_posts.post_type = 'post' AND (il52_posts.post_status = 'publish') ORDER BY il52_posts.ID ASC LIMIT 0, 1	0.2
13	SELECT FOUND_ROWS()	0.2
14	SELECT t., tt., tr.object_id FROM il52_terms AS t INNER JOIN il52_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN il52_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 (4) ORDER BY t.name ASC	0.1
15	SELECT post_id, meta_key, meta_value FROM il52_postmeta WHERE post_id IN (4)	0.1
16	SELECT p.* FROM il52_posts AS p WHERE p.post_date < '2010-01-31 21:42:11' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date DESC LIMIT 1	0.6
17	SELECT p.* FROM il52_posts AS p WHERE p.post_date > '2010-01-31 21:42:11' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date ASC LIMIT 1	0.5
18	select count(id) from il52_yhc_ip_logger_block where agent like '%ccbot/1.0 (+http://www.commoncrawl.org/bot.html)%'	0.5
19	select count(id) from il52_yhc_ip_logger_block where fullhost like '%38.107.191.116%'	0.1
20	select count(id) from il52_yhc_ip_logger_block where Code3 = 'USA'	0.1
21	select count(id) from il52_yhc_ip_logger_block where ip_v4 = '38.107.191.116'	0.1
22	insert into il52_yhc_ip_logger (ip_v4,url,host,user_agent,accept_language,accept_encoding,accept_charset,http_accept, CountryCode,Code3,Country,Region,City,Latitude,Longitude,ZipCode,dmacode,areacode,provider,http_referer,blocked) values ('38.107.191.116','/2010/01/zombie-driver-review/','www.hardwareslave.com','CCBot/1.0 (+http://www.commoncrawl.org/bot.html)','en-us,en;q=0.5','gzip','ISO-8859-1,utf-8;q=0.7,;q=0.7','text/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,/*;q=0.5','US','USA','United States','','','38','-97','','','','38.107.191.116','','N')	0.4
23	SELECT t., tt. FROM il52_terms AS t INNER JOIN il52_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC	0.1
24	SELECT * FROM il52_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_order, post_title ASC	0.1
25	SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM il52_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC	0.1
26	SELECT instances.link_text, links.* FROM il52_blc_instances AS instances, il52_blc_links AS links WHERE instances.source_id = 2044 AND instances.source_type = 'post' AND instances.instance_type = 'link' AND instances.link_id = links.link_id AND links.check_count > 0 AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 ) AND links.http_code <> 1	0.8
27	SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_display_in_posts' LIMIT 1	0.1
28	SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_active_services' LIMIT 1	0.1
29	SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_button_opens_new_window' LIMIT 1	0.1
30	SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_button' LIMIT 1	0.1
31	SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_onclick' LIMIT 1	0.1
32	SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_hide_embeds' LIMIT 1	0.1
33	SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_show_title' LIMIT 1	0.1
34	SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_additional_js_variables' LIMIT 1	0.1
35	SELECT * FROM il52_comments WHERE comment_post_ID = 2044 AND comment_approved = '1' ORDER BY comment_date_gmt ASC	0.3
36	SELECT t., tt. FROM il52_terms AS t INNER JOIN il52_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('post_tag') AND tt.count > 0 ORDER BY tt.count DESC LIMIT 45	0.1
Total time: 9.8 ms

No.

Query

Time (ms)

SELECT autoload FROM il52_options WHERE option_name = 'rewrite_rules'

0.5

DELETE FROM il52_options WHERE option_name = 'rewrite_rules'

0.3

SELECT option_value FROM il52_options WHERE option_name = 'rewrite_rules' LIMIT 1

0.1

INSERT INTO `il52_options` (`option_name`, `option_value`, `autoload`) VALUES ('rewrite_rules', 'a:85:{s:12:\"robots\\.txt$\";s:18:\"index.php?robots=1\";s:14:\".*wp-atom.php$\";s:19:\"index.php?feed=atom\";s:13:\".*wp-rdf.php$\";s:18:\"index.php?feed=rdf\";s:13:\".*wp-rss.php$\";s:18:\"index.php?feed=rss\";s:14:\".*wp-rss2.php$\";s:19:\"index.php?feed=rss2\";s:14:\".*wp-feed.php$\";s:19:\"index.php?feed=feed\";s:22:\".*wp-commentsrss2.php$\";s:34:\"index.php?feed=rss2&withcomments=1\";s:32:\"feed/(feed|rdf|rss|rss2|atom)/?$\";s:27:\"index.php?&feed=$matches[1]\";s:27:\"(feed|rdf|rss|rss2|atom)/?$\";s:27:\"index.php?&feed=$matches[1]\";s:20:\"page/?([0-9]{1,})/?$\";s:28:\"index.php?&paged=$matches[1]\";s:14:\"all(/(.*))?/?$\";s:26:\"index.php?&all=$matches[2]\";s:41:\"comments/feed/(feed|rdf|rss|rss2|atom)/?$\";s:42:\"index.php?&feed=$matches[1]&withcomments=1\";s:36:\"comments/(feed|rdf|rss|rss2|atom)/?$\";s:42:\"index.php?&feed=$matches[1]&withcomments=1\";s:29:\"comments/page/?([0-9]{1,})/?$\";s:28:\"index.php?&paged=$matches[1]\";s:23:\"comments/all(/(.*))?/?$\";s:26:\"index.php?&all=$matches[2]\";s:44:\"search/(.+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:40:\"index.php?s=$matches[1]&feed=$matches[2]\";s:39:\"search/(.+)/(feed|rdf|rss|rss2|atom)/?$\";s:40:\"index.php?s=$matches[1]&feed=$matches[2]\";s:32:\"search/(.+)/page/?([0-9]{1,})/?$\";s:41:\"index.php?s=$matches[1]&paged=$matches[2]\";s:26:\"search/(.+)/all(/(.*))?/?$\";s:39:\"index.php?s=$matches[1]&all=$matches[3]\";s:14:\"search/(.+)/?$\";s:23:\"index.php?s=$matches[1]\";s:47:\"category/(.+?)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:52:\"index.php?category_name=$matches[1]&feed=$matches[2]\";s:42:\"category/(.+?)/(feed|rdf|rss|rss2|atom)/?$\";s:52:\"index.php?category_name=$matches[1]&feed=$matches[2]\";s:35:\"category/(.+?)/page/?([0-9]{1,})/?$\";s:53:\"index.php?category_name=$matches[1]&paged=$matches[2]\";s:29:\"category/(.+?)/all(/(.*))?/?$\";s:51:\"index.php?category_name=$matches[1]&all=$matches[3]\";s:17:\"category/(.+?)/?$\";s:35:\"index.php?category_name=$matches[1]\";s:42:\"tag/(.+?)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:42:\"index.php?tag=$matches[1]&feed=$matches[2]\";s:37:\"tag/(.+?)/(feed|rdf|rss|rss2|atom)/?$\";s:42:\"index.php?tag=$matches[1]&feed=$matches[2]\";s:30:\"tag/(.+?)/page/?([0-9]{1,})/?$\";s:43:\"index.php?tag=$matches[1]&paged=$matches[2]\";s:24:\"tag/(.+?)/all(/(.*))?/?$\";s:41:\"index.php?tag=$matches[1]&all=$matches[3]\";s:12:\"tag/(.+?)/?$\";s:25:\"index.php?tag=$matches[1]\";s:47:\"author/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:50:\"index.php?author_name=$matches[1]&feed=$matches[2]\";s:42:\"author/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:50:\"index.php?author_name=$matches[1]&feed=$matches[2]\";s:35:\"author/([^/]+)/page/?([0-9]{1,})/?$\";s:51:\"index.php?author_name=$matches[1]&paged=$matches[2]\";s:29:\"author/([^/]+)/all(/(.*))?/?$\";s:49:\"index.php?author_name=$matches[1]&all=$matches[3]\";s:17:\"author/([^/]+)/?$\";s:33:\"index.php?author_name=$matches[1]\";s:69:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?$\";s:80:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]\";s:64:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?$\";s:80:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]\";s:57:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/page/?([0-9]{1,})/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&paged=$matches[4]\";s:51:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/all(/(.*))?/?$\";s:79:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&all=$matches[5]\";s:39:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/?$\";s:63:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]\";s:56:\"([0-9]{4})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?$\";s:64:\"index.php?year=$matches[1]&monthnum=$matches[2]&feed=$matches[3]\";s:51:\"([0-9]{4})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?$\";s:64:\"index.php?year=$matches[1]&monthnum=$matches[2]&feed=$matches[3]\";s:44:\"([0-9]{4})/([0-9]{1,2})/page/?([0-9]{1,})/?$\";s:65:\"index.php?year=$matches[1]&monthnum=$matches[2]&paged=$matches[3]\";s:38:\"([0-9]{4})/([0-9]{1,2})/all(/(.*))?/?$\";s:63:\"index.php?year=$matches[1]&monthnum=$matches[2]&all=$matches[4]\";s:26:\"([0-9]{4})/([0-9]{1,2})/?$\";s:47:\"index.php?year=$matches[1]&monthnum=$matches[2]\";s:43:\"([0-9]{4})/feed/(feed|rdf|rss|rss2|atom)/?$\";s:43:\"index.php?year=$matches[1]&feed=$matches[2]\";s:38:\"([0-9]{4})/(feed|rdf|rss|rss2|atom)/?$\";s:43:\"index.php?year=$matches[1]&feed=$matches[2]\";s:31:\"([0-9]{4})/page/?([0-9]{1,})/?$\";s:44:\"index.php?year=$matches[1]&paged=$matches[2]\";s:25:\"([0-9]{4})/all(/(.*))?/?$\";s:42:\"index.php?year=$matches[1]&all=$matches[3]\";s:13:\"([0-9]{4})/?$\";s:26:\"index.php?year=$matches[1]\";s:47:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/?$\";s:32:\"index.php?attachment=$matches[1]\";s:57:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/trackback/?$\";s:37:\"index.php?attachment=$matches[1]&tb=1\";s:77:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:72:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:72:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/comment-page-([0-9]{1,})/?$\";s:50:\"index.php?attachment=$matches[1]&cpage=$matches[2]\";s:44:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/trackback/?$\";s:69:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&tb=1\";s:64:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&feed=$matches[4]\";s:59:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&feed=$matches[4]\";s:52:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/page/?([0-9]{1,})/?$\";s:82:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&paged=$matches[4]\";s:59:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/comment-page-([0-9]{1,})/?$\";s:82:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&cpage=$matches[4]\";s:46:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/all(/(.*))?/?$\";s:80:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&all=$matches[5]\";s:48:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/all(/(.*))?/?$\";s:48:\"index.php?attachment=$matches[1]&all=$matches[2]\";s:59:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/all(/(.*))?/?$\";s:48:\"index.php?attachment=$matches[1]&all=$matches[2]\";s:44:\"([0-9]{4})/([0-9]{1,2})/([^/]+)(/[0-9]+)?/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&page=$matches[4]\";s:36:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/?$\";s:32:\"index.php?attachment=$matches[1]\";s:46:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/trackback/?$\";s:37:\"index.php?attachment=$matches[1]&tb=1\";s:66:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:61:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:61:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/comment-page-([0-9]{1,})/?$\";s:50:\"index.php?attachment=$matches[1]&cpage=$matches[2]\";s:51:\"([0-9]{4})/([0-9]{1,2})/comment-page-([0-9]{1,})/?$\";s:65:\"index.php?year=$matches[1]&monthnum=$matches[2]&cpage=$matches[3]\";s:38:\"([0-9]{4})/comment-page-([0-9]{1,})/?$\";s:44:\"index.php?year=$matches[1]&cpage=$matches[2]\";s:25:\".+?/attachment/([^/]+)/?$\";s:32:\"index.php?attachment=$matches[1]\";s:35:\".+?/attachment/([^/]+)/trackback/?$\";s:37:\"index.php?attachment=$matches[1]&tb=1\";s:55:\".+?/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:50:\".+?/attachment/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:50:\".+?/attachment/([^/]+)/comment-page-([0-9]{1,})/?$\";s:50:\"index.php?attachment=$matches[1]&cpage=$matches[2]\";s:18:\"(.+?)/trackback/?$\";s:35:\"index.php?pagename=$matches[1]&tb=1\";s:38:\"(.+?)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:47:\"index.php?pagename=$matches[1]&feed=$matches[2]\";s:33:\"(.+?)/(feed|rdf|rss|rss2|atom)/?$\";s:47:\"index.php?pagename=$matches[1]&feed=$matches[2]\";s:26:\"(.+?)/page/?([0-9]{1,})/?$\";s:48:\"index.php?pagename=$matches[1]&paged=$matches[2]\";s:33:\"(.+?)/comment-page-([0-9]{1,})/?$\";s:48:\"index.php?pagename=$matches[1]&cpage=$matches[2]\";s:20:\"(.+?)/all(/(.*))?/?$\";s:46:\"index.php?pagename=$matches[1]&all=$matches[3]\";s:26:\".+?/([^/]+)/all(/(.*))?/?$\";s:48:\"index.php?attachment=$matches[1]&all=$matches[2]\";s:37:\".+?/attachment/([^/]+)/all(/(.*))?/?$\";s:48:\"index.php?attachment=$matches[1]&all=$matches[2]\";s:18:\"(.+?)(/[0-9]+)?/?$\";s:47:\"index.php?pagename=$matches[1]&page=$matches[2]\";}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)

0.8

SELECT option_value FROM il52_options WHERE option_name = 'polldaddy_multiple_accounts' LIMIT 1

0.3

 SELECT   il52_posts.* FROM il52_posts  WHERE 1=1  AND YEAR(il52_posts.post_date)='2010' AND MONTH(il52_posts.post_date)='1' AND il52_posts.post_name = 'zombie-driver-review' AND il52_posts.post_type = 'post'  ORDER BY il52_posts.post_date DESC

0.8

SELECT t.*, tt.*, tr.object_id FROM il52_terms AS t INNER JOIN il52_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN il52_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 (2044) ORDER BY t.name ASC

1.1

SELECT post_id, meta_key, meta_value FROM il52_postmeta WHERE post_id IN (2044)

0.2

SELECT ID FROM il52_posts WHERE post_name = 'zombie-driver-review'

0.4

SELECT * FROM il52_users WHERE ID = 1 LIMIT 1

0.1

SELECT meta_key, meta_value FROM il52_usermeta WHERE user_id = 1

0.1

 SELECT SQL_CALC_FOUND_ROWS  il52_posts.* FROM il52_posts  WHERE 1=1  AND il52_posts.post_type = 'post' AND (il52_posts.post_status = 'publish')  ORDER BY il52_posts.ID ASC LIMIT 0, 1

0.2

SELECT FOUND_ROWS()

0.2

SELECT t.*, tt.*, tr.object_id FROM il52_terms AS t INNER JOIN il52_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN il52_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 (4) ORDER BY t.name ASC

0.1

SELECT post_id, meta_key, meta_value FROM il52_postmeta WHERE post_id IN (4)

0.1

SELECT p.* FROM il52_posts AS p  WHERE p.post_date < '2010-01-31 21:42:11' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date DESC LIMIT 1

0.6

SELECT p.* FROM il52_posts AS p  WHERE p.post_date > '2010-01-31 21:42:11' AND p.post_type = 'post' AND p.post_status = 'publish'  ORDER BY p.post_date ASC LIMIT 1

0.5

select count(id) from il52_yhc_ip_logger_block where agent like '%ccbot/1.0 (+http://www.commoncrawl.org/bot.html)%'

0.5

select count(id) from il52_yhc_ip_logger_block where fullhost like '%38.107.191.116%'

0.1

select count(id) from il52_yhc_ip_logger_block where Code3 = 'USA'

0.1

select count(id) from il52_yhc_ip_logger_block where ip_v4 = '38.107.191.116'

0.1

insert into il52_yhc_ip_logger (ip_v4,url,host,user_agent,accept_language,accept_encoding,accept_charset,http_accept,
			    CountryCode,Code3,Country,Region,City,Latitude,Longitude,ZipCode,dmacode,areacode,provider,http_referer,blocked) 
			    values ('38.107.191.116','/2010/01/zombie-driver-review/','www.hardwareslave.com','CCBot/1.0 (+http://www.commoncrawl.org/bot.html)','en-us,en;q=0.5','gzip','ISO-8859-1,utf-8;q=0.7,*;q=0.7','text/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5','US','USA','United States','','','38','-97','','','','38.107.191.116','','N')

0.4

SELECT t.*, tt.* FROM il52_terms AS t INNER JOIN il52_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category')  ORDER BY t.name ASC

0.1

SELECT * FROM il52_posts  WHERE (post_type = 'page' AND post_status = 'publish')     ORDER BY menu_order, post_title ASC

0.1

SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM il52_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 instances.link_text, links.*

			FROM il52_blc_instances AS instances, il52_blc_links AS links
			
			WHERE 
				instances.source_id = 2044
				AND instances.source_type = 'post'
				AND instances.instance_type = 'link'
				
				AND instances.link_id = links.link_id
			    AND links.check_count > 0
			    AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
				AND links.http_code <> 1

0.8

SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_display_in_posts' LIMIT 1

0.1

SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_active_services' LIMIT 1

0.1

SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_button_opens_new_window' LIMIT 1

0.1

SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_button' LIMIT 1

0.1

SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_onclick' LIMIT 1

0.1

SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_hide_embeds' LIMIT 1

0.1

SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_show_title' LIMIT 1

0.1

SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_additional_js_variables' LIMIT 1

0.1

SELECT * FROM il52_comments WHERE comment_post_ID = 2044 AND comment_approved = '1' ORDER BY comment_date_gmt ASC

0.3

SELECT t.*, tt.* FROM il52_terms AS t INNER JOIN il52_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('post_tag')  AND tt.count > 0 ORDER BY tt.count DESC LIMIT 45

0.1

Total time: 9.8 ms

1	muplugins_loaded
2	wp_default_scripts
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	delete_option
13	deleted_option
14	generate_rewrite_rules
15	add_option
16	add_option_rewrite_rules
17	added_option
18	widgets_init
19	load_textdomain
20	load_textdomain
21	load_textdomain
22	load_textdomain
23	wp_default_styles
24	parse_request
25	send_headers
26	parse_query
27	pre_get_posts
28	posts_selection
29	wp
30	template_redirect
31	get_header
32	wp_head
33	wp_enqueue_scripts
34	loop_start
35	the_post
36	loop_end
37	the_post
38	wp_print_styles
39	wp_print_scripts
40	parse_query
41	pre_get_posts
42	posts_selection
43	arras_head
44	the_post
45	arras_body
46	arras_above_nav
47	arras_below_nav
48	arras_above_content
49	loop_start
50	the_post
51	arras_above_post
52	deprecated_function_run
53	deprecated_function_run
54	arras_below_post
55	comment_form
56	arras_below_comments
57	loop_end
58	arras_below_content
59	get_sidebar
60	arras_above_sidebar
61	arras_below_sidebar
62	get_footer
63	arras_before_footer
64	wp_footer
65	wp_print_footer_scripts

Zombie Driver Review

About the Author

No Comments

Leave a Reply

Tags

Copyright