Now available in the WordPress Repository

Posted on March 26, 2012 by Eli Scheetz

I just released my new Anti-Malware plugin for WordPress. It is still in BETA but I think it will be very helpful in removing malicious scripts and patching security vulnerabilities.

An example scan that found some threats

Please leave feedback and donate whenever possible.

Download of GOTMLS from WordPress.org

ACTA sounds even worse than SOPA and PROTECT IP

Posted on February 24, 2012 by Eli Scheetz

If you thought SOPA and PROTECT IP were bad, then check this out.

[youtube]N8Xg_C2YmG0[/youtube]

What is this world coming to?

I’m working on an Anti-Malware plugin for WordPress.

Posted on February 23, 2012 by Eli Scheetz

I haven’t posted anything this whole month because one of my servers got hacked and I’ve spent the last three week working on a new plugin to scan and remove malicious software from my server.

It wasn’t enough for me to just remove the hack. I had to make sure it wouldn’t come back and because it was such a widespread exploit I thought it would be good to release a plugin for other website admins to check their site for themselves.

I looks like my infestation of nasty scripts came in through a vulnerability in an older version of timthumb.php. Apparently any version older that 2.0 can be used to place a file on the server. If that file is a back-door of some kind then the person who put it there could have full access to your server.

I’m still testing and working out the kinks in my security scanner but it should be ready soon…

Download of GOTMLS from WordPress.org

Google announced that signed-in users will, by default, be routed to the SSL version of Google Search

Posted on January 23, 2012 by Eli Scheetz

In October of 2011 Google announced that signed-in users will, by default, be routed to the SSL version of Google Search (https://www.google.com).

What is the impact of this change for webmasters?
A web site accessed through organic search results on http://www.google.com (non-SSL) can see both that the user came from google.com and their search query.
However, for organic search results on Google’s SSL search, a web site will only know that the user came from google.com.

This is bad news for anyone who wants to know what keywords were used to find their site on Goggle.

Over two thirds (69%) of my Google Analytics Keywords now show up as “(not provided)”. This completely cripples my ability to tell how people are finding my site.

Here is a good video I found on SEOmoz that goes into more details and explains how it works:

Help Stop SOPA (Stop Online Piracy Act) and PIPA (Protect IP Act)

Posted on January 12, 2012 by Eli Scheetz

PROTECT IP / SOPA Breaks The Internet from Fight for the Future on Vimeo.

Some thoughts by Jane Wells, UX lead for WordPress:

In the U.S. our legal system maintains that the burden of proof is on the accuser, and that people are innocent until proven guilty. This tenet seems to be on the chopping block when it comes to the web if these bills pass, as companies could shut down sites based on accusation alone.
Laws are not like lines of PHP; they are not easily reverted if someone wakes up and realizes there is a better way to do things. We should not be so quick to codify something this far-reaching.
The people writing these laws are not the people writing the independent web, and they are not out to protect it. We have to stand up for it ourselves.

Go to Stop American Censorship for more information and a bunch of ways you can take action quickly, easily, and painlessly. The Senate votes in less than two weeks, and we need to help at least 41 more senators see reason before then. Please. Make your voice heard.

Artiss YouTube Embed

Posted on January 3, 2012 by Eli Scheetz

I embeded these YouTube Videos using Artiss YouTube Embed By David Artiss. It was a great Plugin for WordPress YouTube videos but it was taken over by another developer and it’s not as well liked any more. Besides which, with the new version of WordPress you can now embed YouTube videos automatically just by pasting the shortlink into a Page or Post.

Profiler Initiaded	0.0000 ms	38679 kB
Profiler Noise	0.0041 ms	38679 kB
Profiler Stopped	474.9732 ms	112071 kB

0.2482 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;`
0.1440 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;`
0.2239 [ms]	SELECT * FROM `wp_posts` WHERE post_type = 'gotmls_results' AND post_name = 'c1a830c188eff025702c7f974fae132b';
0.2379 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_edit_links_calypso_redirect' LIMIT 1;`
0.1471 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1;`
0.2480 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_logs_default_handler' LIMIT 1;`
0.1600 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_logs_level_threshold' LIMIT 1;`
0.1140 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_custom_orders_table_data_sync_enabled' LIMIT 1;`
0.0610 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_custom_orders_table_background_sync_mode' LIMIT 1;`
0.1280 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wc_installing' LIMIT 1;`
0.0730 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wc_installing' LIMIT 1;`
0.0672 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_feature_marketplace_enabled' LIMIT 1;`
0.2599 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_check_subscriptions_eligibility_after_onboarding' LIMIT 1;`
0.1361 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;`
0.1090 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;`
0.1249 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;`
0.0892 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;`
0.0920 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'has_jetpack_search_product' LIMIT 1;`
0.1531 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'instant_search_enabled' LIMIT 1;`
0.1230 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_blocks_disabled' LIMIT 1;`
0.0920 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;`
0.0710 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;`
0.0911 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;`
0.2022 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;`
0.1051 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;`
0.1321 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_pickup_location_settings' LIMIT 1;`
0.1559 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_account_data' LIMIT 1;`
0.1531 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_customer_multi_currency' LIMIT 1;`
0.1309 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;`
0.1841 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;`
0.1280 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;`
2.6181 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;`
0.1600 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_upe_appearance_theme' LIMIT 1;`
0.1159 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_upe_appearance_theme' LIMIT 1;`
0.0849 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_woocommerce_payments_woopay_available_countries' LIMIT 1;`
0.1171 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_woopay_direct_checkout' LIMIT 1;`
0.1161 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_stripe_billing' LIMIT 1;`
0.2460 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;`
0.0849 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_onboarding' LIMIT 1;`
0.2089 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_product_download_dir_sync_page' LIMIT 1;`
0.1271 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;`
0.1159 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;`
0.1729 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_task_list_tracked_completed_actions' LIMIT 1;`
0.1931 [ms]	`SELECT * FROM wp_posts WHERE ID = 1676 LIMIT 1;`
0.1218 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cheque_settings' LIMIT 1;`
0.1149 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_bacs_settings' LIMIT 1;`
0.0811 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cod_settings' LIMIT 1;`
0.1049 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;`
0.0689 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;`
0.0839 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;`
0.0799 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;`
0.0780 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;`
0.0849 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;`
0.1588 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data' LIMIT 1;`
0.1771 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_woocommerce_blocks_asset_api_script_data' LIMIT 1;`
0.1469 [ms]	`SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND ((wp_posts.post_type = 'patterns_ai_data' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 0, 1;`
0.1631 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cart_page_id' LIMIT 1;`
0.1121 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_checkout_page_id' LIMIT 1;`
0.1090 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_onboarding_test_mode' LIMIT 1;`
0.1259 [ms]	`SELECT * FROM wp_posts WHERE ID = 1678 LIMIT 1;`
0.1211 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;`
0.1111 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;`
0.1080 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;`
0.1090 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_rounding_usd' LIMIT 1;`
0.1519 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_exchange_rate_usd' LIMIT 1;`
0.0970 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_cart_checkout_content_sources' LIMIT 1;`
0.0932 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_cart_checkout_content_sources' LIMIT 1;`
0.0610 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_additional_blocks_on_cart_page' LIMIT 1;`
0.0560 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_additional_blocks_on_cart_page' LIMIT 1;`
0.0560 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_additional_blocks_on_checkout_page' LIMIT 1;`
0.0560 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_additional_blocks_on_checkout_page' LIMIT 1;`
0.0551 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enable_auto_currency' LIMIT 1;`
0.0870 [ms]	`SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;;`
0.1280 [ms]	`SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0;`
0.0880 [ms]	`SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0;`
0.0839 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_flat_rate_settings' LIMIT 1;`
0.0808 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_free_shipping_settings' LIMIT 1;`
0.0808 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_international_delivery_settings' LIMIT 1;`
0.0799 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_delivery_settings' LIMIT 1;`
0.0792 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_pickup_settings' LIMIT 1;`
0.1390 [ms]	`SELECT * FROM wp_users WHERE user_nicename = 'admin' LIMIT 1;`
0.3281 [ms]	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;`
0.3881 [ms]	`SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (wp_posts.post_author = 1) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 30, 10;`
0.0589 [ms]	`SELECT FOUND_ROWS();`
0.2060 [ms]	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (286,280,276,265,268,247,238,217,205,252);`
0.3700 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (286,280,276,265,268,247,238,217,205,252) ORDER BY meta_id ASC;`
0.5260 [ms]	`SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.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', 'post_format') AND tr.object_id IN (286, 280, 276, 265, 268, 247, 238, 217, 205, 252) ORDER BY t.name ASC ;`
0.3209 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (40,50,44,47,62,17,49,16,21,51,25,57,52,20,48,108,4,42);`
0.1280 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REMOTE_ADDR' AND meta_value = '3.146.65.212';`
0.1690 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_USER_AGENT' AND meta_value = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)';`
0.1359 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_REFERER' AND meta_value = '';`
0.1040 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value = '/author/admin/page/4/';`
0.4182 [ms]	INSERT INTO wp_shareable_hits (`MONTH_OF`, REMOTE_ADDR, HTTP_USER_AGENT, HTTP_REFERER, REQUEST_URI, last_view, wp_user, hit_count) VALUES ('2024-04', 65012, 64970, 16079, 185, '2024-04-19 13:46:22', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2024-04-19 13:46:22', wp_user = 0, hit_count = hit_count + 1;
0.1121 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;`
0.2151 [ms]	`SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;`
0.1299 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;`
0.0949 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_demo_store' LIMIT 1;`
0.1469 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 105;`
0.3099 [ms]	`SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (108) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC ;`
0.3290 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (620,623,624,626,628,629) ORDER BY meta_id ASC;`
0.1841 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (103,84,35);`
0.1190 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 22;`
0.2310 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (286) ORDER BY t.name ASC ;`
0.1740 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (287) ORDER BY meta_id ASC;`
0.2251 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (280) ORDER BY t.name ASC ;`
0.1709 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (276) ORDER BY t.name ASC ;`
0.1671 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (277) ORDER BY meta_id ASC;`
0.1681 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (265) ORDER BY t.name ASC ;`
0.2079 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (268) ORDER BY t.name ASC ;`
0.2151 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (247) ORDER BY t.name ASC ;`
0.2122 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (238) ORDER BY t.name ASC ;`
0.2050 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (217) ORDER BY t.name ASC ;`
0.2248 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (205) ORDER BY t.name ASC ;`
0.2120 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (252) ORDER BY t.name ASC ;`
0.1831 [ms]	`SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = 'f5dc4d81833816f85038ef1a269d0c6f' AND wp_posts.post_type = 'oembed_cache' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC ;`
0.1771 [ms]	`SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = 'c8f43f39b300935f41ff9db2cef1e7d0' AND wp_posts.post_type = 'oembed_cache' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC ;`
0.2091 [ms]	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.1988 [ms]	`SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ( ( YEAR( wp_posts.post_date ) = 2023 AND MONTH( wp_posts.post_date ) = 4 ) ) AND ( YEAR( wp_posts.post_date ) < 2024 ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date ASC LIMIT 0, 15;`
0.1500 [ms]	`SELECT t.term_id 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 t.term_id IN ( 43 ) AND tt.count > 0 ORDER BY t.name ASC ;`
0.1509 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (43);`
0.2189 [ms]	`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 = 43 ) AND taxonomy = 'link_category' ORDER BY link_name ASC;`

Eli's WordPress Blog

My WordPress Plugins, and other stuff.

Author Archives: Eli Scheetz