Defend Internet Privacy

Posted on December 1, 2012 by Eli Scheetz

Internet freedom needs a global network behind it. fightforthefuture.org has launched The Internet Defense League. Now you can defend the net by broadcasting action messages on your own sites using this widget. You can also tell the world that you are a member of the league by displaying one of the IDL badges hosted by internetdefenseleague.org.

Download of StopSopa-Again from WordPress.org

The ITU could put the Internet behind closed doors

Posted on November 14, 2012 by Eli Scheetz

Display Name If No Gravatar

Posted on November 8, 2012 by Eli Scheetz

I created a new Plugin for WordPress that uses 0gravatar.com to generate an image of the user’s display_name if they do not yet have a Gravatar. This Plugin replaces the get_avatar function in pluggable.php to pass an alternate image to gravatar.com to use if they do not yet have a gravatar.

Comment on this post with an email address that you have not setup a gravatar on and see how it woks.

Download of 0gravatar from WordPress.org

Can you read this?

Posted on November 3, 2012 by Eli Scheetz

I added a Shortcode feature my Testimonials Plugin

Posted on November 2, 2012 by Eli Scheetz

Now you can place your choice Comments on any Page or Post using a Shortcode.

Examples:

`Random Testimonial`

SQL Report plugin is easy to use. It saves me a lot of time an works perfect. Thanks. -- Paul

This would display 1 random Comments with the Karma Value of 0 under the heading Random Testimonial

`Client Testimonials`

I'm excited for this! Your GOTMLS plugin is amazing and I have heard many issues with BackupBuddy and ManageWP so I cant wait to use it. Thanks for your great work and I'll keep donating! -J -- Social Media Titans

This would display your 8 most recent Comments with the Karma Value of 100 under the heading Client Testimonials

Please Let me know if have any questions, comments, or suggestions.

Aloha, Eli

Download of Comment-Testimonials from WordPress.org

A simple Widget to list choice comments as Testimonials

Posted on October 27, 2012 by Eli Scheetz

I wrote this little Widget for my Anti-Malware Pligins’ site, GOTMLS.NET. I get so many wonderful testimonials via comments from my … and I wanted to display some of my favorites in the sidebar. I’ve release this little Testimonials Widget on the WordPress Repository because I didn’t see any other plugin that did this simple task.

Just set the Comment Karma on your favorite comments then set the Karma value in the Widget settings to match. Otherwise this plugin just queries all the comments with the default Karma of 0.

I plan on adding a few more features when I have time but the idea here is to keep it simple: Display some rotating comments as Testimonials.

Let me know what you think in the comments.

Download of Comment-Testimonials from WordPress.org

Happy Birthday Blog

Posted on October 8, 2012 by Eli Scheetz

This Blog is one year old today. Now I can use the SMALY Widget that I wrote for the SHH Blog on this Blog. You can see links to my one-year-old posts on the sidebar under “THIS TIME LAST YEAR”.

Download of SMALY-Widget from WordPress.org

New scan engine that works better on large file systems

Posted on October 6, 2012 by Eli Scheetz

I released the new scan engine in version 1.2.10.05 today. This is the scan process that I’ve had available as a BETA for a couple months but it was not ready for release until now. It take longer because it breaks the scan into smaller processes that complete independently of the scan initiation process. This has a better success rate (especially on server with lots of files or minimal memory) and allows for better error handling.

So there are now two types of scans:

Quick Scan – Good for small file systems, fast servers, or sites that have post restriction.
Complete Scan – Good for large file systems, servers with irregular permission issues, or low memory allocation.

The Automatic Fix process and File Viewer have been improved too. It loads nicer now and you can move this new pop-up window around on the page :-).

Please give me feedback on these new features and scan options.

Aloha, Eli

Download of GOTMLS from WordPress.org

Z-Type

Posted on September 13, 2012 by Eli Scheetz

Here is a cool JavaScript game that’s good for typing practice.

http://www.phoboslab.org/ztype/

Profiler Initiaded	0.0000 ms	38679 kB
Profiler Noise	0.0041 ms	38679 kB
Profiler Stopped	478.3380 ms	112377 kB

0.2651 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;`
0.1230 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;`
0.2439 [ms]	SELECT * FROM `wp_posts` WHERE post_type = 'gotmls_results' AND post_name = '5c9e6a1400c4f6ba98da2bb3bd6ec5d6';
0.2110 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_edit_links_calypso_redirect' LIMIT 1;`
0.1259 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1;`
0.2110 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_logs_default_handler' LIMIT 1;`
0.1299 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_logs_level_threshold' LIMIT 1;`
0.1280 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_custom_orders_table_data_sync_enabled' LIMIT 1;`
0.1199 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_custom_orders_table_background_sync_mode' LIMIT 1;`
0.1218 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wc_installing' LIMIT 1;`
0.1180 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wc_installing' LIMIT 1;`
0.0811 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_feature_marketplace_enabled' LIMIT 1;`
0.2341 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_check_subscriptions_eligibility_after_onboarding' LIMIT 1;`
0.1070 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;`
0.1140 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;`
0.0880 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;`
0.0839 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;`
0.0882 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'has_jetpack_search_product' LIMIT 1;`
0.1240 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'instant_search_enabled' LIMIT 1;`
0.0830 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_blocks_disabled' LIMIT 1;`
0.0839 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;`
0.1211 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;`
0.0868 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;`
0.2041 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;`
0.1209 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;`
0.1218 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_pickup_location_settings' LIMIT 1;`
0.1280 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_account_data' LIMIT 1;`
0.2160 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_customer_multi_currency' LIMIT 1;`
0.1469 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;`
0.1369 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;`
0.1431 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;`
2.4400 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;`
0.1650 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_upe_appearance_theme' LIMIT 1;`
0.0830 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_upe_appearance_theme' LIMIT 1;`
0.1240 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_woocommerce_payments_woopay_available_countries' LIMIT 1;`
0.1440 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_woopay_direct_checkout' LIMIT 1;`
0.1259 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_stripe_billing' LIMIT 1;`
0.2229 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;`
0.1619 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_onboarding' LIMIT 1;`
0.2449 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_product_download_dir_sync_page' LIMIT 1;`
0.1359 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;`
0.1369 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;`
0.2069 [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.1490 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cheque_settings' LIMIT 1;`
0.0920 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_bacs_settings' LIMIT 1;`
0.0880 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cod_settings' LIMIT 1;`
0.1540 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;`
0.1311 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;`
0.0930 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;`
0.0899 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;`
0.1221 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;`
0.1280 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;`
0.1152 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data' LIMIT 1;`
0.2491 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_woocommerce_blocks_asset_api_script_data' LIMIT 1;`
0.1590 [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.1860 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cart_page_id' LIMIT 1;`
0.1020 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_checkout_page_id' LIMIT 1;`
0.1240 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_onboarding_test_mode' LIMIT 1;`
0.1359 [ms]	`SELECT * FROM wp_posts WHERE ID = 1678 LIMIT 1;`
0.1400 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;`
0.1240 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;`
0.0870 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;`
0.0870 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_rounding_usd' LIMIT 1;`
0.0830 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_exchange_rate_usd' LIMIT 1;`
0.1240 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_cart_checkout_content_sources' LIMIT 1;`
0.0980 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_cart_checkout_content_sources' LIMIT 1;`
0.0641 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_additional_blocks_on_cart_page' LIMIT 1;`
0.0598 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_additional_blocks_on_cart_page' LIMIT 1;`
0.0570 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_additional_blocks_on_checkout_page' LIMIT 1;`
0.0579 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_additional_blocks_on_checkout_page' LIMIT 1;`
0.0880 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enable_auto_currency' LIMIT 1;`
0.1080 [ms]	`SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;;`
0.1330 [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.0858 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_flat_rate_settings' LIMIT 1;`
0.0820 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_free_shipping_settings' LIMIT 1;`
0.0811 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_international_delivery_settings' LIMIT 1;`
0.0830 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_delivery_settings' LIMIT 1;`
0.0830 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_pickup_settings' LIMIT 1;`
0.1440 [ms]	`SELECT * FROM wp_users WHERE user_nicename = 'admin' LIMIT 1;`
0.3290 [ms]	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;`
0.3920 [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 10, 10;`
0.0589 [ms]	`SELECT FOUND_ROWS();`
0.1681 [ms]	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (406,394,397,386,381,388,375,368,384,349);`
0.2849 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (406,394,397,386,381,388,375,368,384,349) ORDER BY meta_id ASC;`
0.5569 [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 (406, 394, 397, 386, 381, 388, 375, 368, 384, 349) ORDER BY t.name ASC ;`
0.6249 [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 (81,40,44,33,60,73,56,83,79,61,74,82,90,91,92,29,77,80,71,31,75,76,24,86,55,57,1,78,20,108,42);`
0.1771 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REMOTE_ADDR' AND meta_value = '3.139.86.56';`
0.1700 [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.1380 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_REFERER' AND meta_value = '';`
0.0970 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value = '/author/admin/page/2/';`
0.4539 [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', 64985, 64970, 16079, 158, '2024-04-19 07:08:32', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2024-04-19 07:08:32', wp_user = 0, hit_count = hit_count + 1;
0.1130 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;`
0.1912 [ms]	`SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;`
0.1330 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;`
0.1371 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_demo_store' LIMIT 1;`
0.1869 [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.3281 [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.5200 [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.2000 [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,21,84,35);`
0.1659 [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.2739 [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 (406) ORDER BY t.name ASC ;`
0.2282 [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 (394) ORDER BY t.name ASC ;`
0.2022 [ms]	`SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '1861119ec7b0478cd7097d250b578f59' AND wp_posts.post_type = 'oembed_cache' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC ;`
0.2210 [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 (397) ORDER BY t.name ASC ;`
0.2291 [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 (386) ORDER BY t.name ASC ;`
0.1819 [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 (381) ORDER BY t.name ASC ;`
0.1762 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (382) ORDER BY meta_id ASC;`
0.1769 [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 (388) ORDER BY t.name ASC ;`
0.6678 [ms]	`SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND comment_karma = 100 AND comment_parent = 0 AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt DESC ;`
0.1569 [ms]	`SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (29350,10043);`
0.1371 [ms]	`SELECT * FROM wp_posts WHERE ID = 263 LIMIT 1;`
0.7889 [ms]	`SELECT wp_comments.comment_ID FROM wp_comments WHERE ( comment_approved = '1' ) AND wp_comments.comment_ID NOT IN ( 29350 ) AND comment_karma = 100 AND comment_parent = 0 AND comment_type != 'order_note' AND comment_type != 'webhook_delivery' ORDER BY wp_comments.comment_date_gmt DESC LIMIT 0,8;`
0.1650 [ms]	`SELECT * FROM wp_posts WHERE ID = 637 LIMIT 1;`
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 (375) ORDER BY t.name ASC ;`
0.2069 [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 (368) ORDER BY t.name ASC ;`
0.2301 [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 (384) ORDER BY t.name ASC ;`
0.1769 [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 (349) ORDER BY t.name ASC ;`
0.2689 [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.1919 [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.1180 [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.3011 [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