| 1 | SELECT autoload FROM il52_options WHERE option_name = 'rewrite_rules' | 0.6 |
| 2 | DELETE FROM il52_options WHERE option_name = 'rewrite_rules' | 0.5 |
| 3 | SELECT option_value FROM il52_options WHERE option_name = 'rewrite_rules' LIMIT 1 | 0.2 |
| 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.9 |
| 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 = 'all-about-epub-the-ebook-standard-for-apples-ibookstore' AND il52_posts.post_type = 'post' ORDER BY il52_posts.post_date DESC | 1.1 |
| 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 (2042) ORDER BY t.name ASC | 1.6 |
| 8 | SELECT post_id, meta_key, meta_value FROM il52_postmeta WHERE post_id IN (2042) | 23.1 |
| 9 | SELECT ID FROM il52_posts WHERE post_name = 'all-about-epub-the-ebook-standard-for-apples-ibookstore' | 0.6 |
| 10 | SELECT * FROM il52_users WHERE ID = 1 LIMIT 1 | 0.9 |
| 11 | SELECT meta_key, meta_value FROM il52_usermeta WHERE user_id = 1 | 0.7 |
| 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.1 |
| 13 | SELECT FOUND_ROWS() | 0.1 |
| 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:36:57' 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:36:57' 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.7 |
| 19 | select count(id) from il52_yhc_ip_logger_block where fullhost like '%38.107.191.119%' | 0.2 |
| 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.119' | 0.2 |
| 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.119','/2010/01/all-about-epub-the-ebook-standard-for-apples-ibookstore/','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.119','','N') | 0.5 |
| 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.4 |
| 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 = 2042
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 | 1.2 |
| 27 | SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_display_in_posts' LIMIT 1 | 0.3 |
| 28 | SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_active_services' LIMIT 1 | 0.2 |
| 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 = 2042 AND comment_approved = '1' ORDER BY comment_date_gmt ASC | 1.2 |
| 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.2 |
