0.2511 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;
|
0.1109 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;
|
0.1240 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/1701514924.8294' LIMIT 1;
|
0.2298 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'at_options' LIMIT 1;
|
0.1471 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_edit_links_calypso_redirect' LIMIT 1;
|
0.1681 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
|
0.2830 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;
|
0.1650 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
0.1509 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;
|
0.1540 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;
|
0.1349 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;
|
0.0899 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;
|
0.0942 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;
|
0.1469 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_navigation_enabled' LIMIT 1;
|
0.0980 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;
|
0.1090 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;
|
0.1109 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_view_subscriptions_endpoint' LIMIT 1;
|
0.0989 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_account_data' LIMIT 1;
|
0.0870 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_platform_checkout' LIMIT 1;
|
0.0920 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_customer_multi_currency' LIMIT 1;
|
0.1009 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;
|
0.1960 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;
|
0.0939 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;
|
2.4061 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;
|
0.1299 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_upe' LIMIT 1;
|
0.1070 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;
|
0.2232 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;
|
0.1471 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;
|
0.1221 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_services' LIMIT 1;
|
0.1280 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_setup_automated_taxes' LIMIT 1;
|
0.1001 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_disabled_plugins' LIMIT 1;
|
0.1941 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1676 LIMIT 1;
|
0.1090 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcs_do_subscriptions_exist' LIMIT 1;
|
0.1268 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcs_do_subscriptions_exist' LIMIT 1;
|
0.1490 [ms]
|
SELECT ID FROM wp_posts WHERE post_type = 'shop_subscription' LIMIT 1;;
|
0.1330 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;
|
0.1211 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;
|
0.2151 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;
|
0.1590 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;
|
0.1171 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;
|
0.0861 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;
|
0.1299 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_retrieval_error' LIMIT 1;
|
0.0842 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;
|
0.1018 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;
|
0.0811 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;
|
0.0799 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_rounding_usd' LIMIT 1;
|
0.0601 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_exchange_rate_usd' LIMIT 1;
|
0.0911 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enable_auto_currency' LIMIT 1;
|
0.0920 [ms]
|
SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;;
|
0.0899 [ms]
|
SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0;
|
0.0861 [ms]
|
SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0;
|
0.0851 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_flat_rate_settings' LIMIT 1;
|
0.0811 [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.0808 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_delivery_settings' LIMIT 1;
|
0.0529 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_pickup_settings' LIMIT 1;
|
0.0560 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1;
|
0.0842 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_doing_cron' LIMIT 1;
|
0.5751 [ms]
|
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1701514925.1886439323425292968750', 'yes') ON
DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
0.3688 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM wp_posts
WHERE post_name IN ('new-features-added-to-my-related-posts-plugin-now-downloaded-over-4000-times')
AND post_type IN ('page','attachment')
;
|
0.2210 [ms]
|
SELECT wp_posts.*
FROM wp_posts
WHERE 1=1 AND wp_posts.post_name = 'new-features-added-to-my-related-posts-plugin-now-downloaded-over-4000-times' AND wp_posts.post_type = 'post'
ORDER BY wp_posts.post_date DESC
;
|
0.3321 [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 (238)
ORDER BY t.name ASC
;
|
0.1922 [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 (16,21,108);
|
0.1478 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (238) ORDER BY meta_id ASC;
|
0.1631 [ms]
|
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REMOTE_ADDR' AND meta_value = '44.220.249.141';
|
0.1371 [ms]
|
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_USER_AGENT' AND meta_value = 'CCBot/2.0 (https://commoncrawl.org/faq/)';
|
0.1221 [ms]
|
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_REFERER' AND meta_value = '';
|
0.1280 [ms]
|
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value =
'/new-features-added-to-my-related-posts-plugin-now-downloaded-over-4000-times/?replytocom=163';
|
0.4389 [ms]
|
INSERT INTO wp_shareable_hits (`MONTH_OF`, REMOTE_ADDR, HTTP_USER_AGENT, HTTP_REFERER, REQUEST_URI, last_view, wp_user, hit_count) VALUES ('2023-12',
46447, 7541, 16079, 1528, '2023-12-02 11:02:05', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2023-12-02 11:02:05', wp_user = 0, hit_count = hit_count +
1;
|
0.0880 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cart_page_id' LIMIT 1;
|
0.0739 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_checkout_page_id' LIMIT 1;
|
0.0598 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;
|
0.1609 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'sharedaddy_disable_resources' LIMIT 1;
|
0.1550 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;
|
0.0839 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;
|
0.1190 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_demo_store' LIMIT 1;
|
0.1440 [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.3240 [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.3629 [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 (44,103,84,35);
|
0.1552 [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.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 (238)
ORDER BY t.name ASC
;
|
0.3259 [ms]
|
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;
|
0.1390 [ms]
|
SELECT * FROM wp_users WHERE ID IN (1);
|
0.1590 [ms]
|
SELECT p.ID FROM wp_posts AS p WHERE p.post_date < '2012-01-21 14:41:08' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date
DESC LIMIT 1;
|
0.1018 [ms]
|
SELECT * FROM wp_posts WHERE ID = 217 LIMIT 1;
|
0.1621 [ms]
|
SELECT p.ID FROM wp_posts AS p WHERE p.post_date > '2012-01-21 14:41:08' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date
ASC LIMIT 1;
|
0.1612 [ms]
|
SELECT * FROM wp_posts WHERE ID = 247 LIMIT 1;
|
0.2680 [ms]
|
SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 238 AND comment_parent = 0 AND comment_type != 'order_note' AND comment_type !=
'webhook_delivery'
ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC
;
|
0.1569 [ms]
|
SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (107,149,163,165);
|
0.2000 [ms]
|
SELECT wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 238 AND comment_parent IN ( 107,149,163,165 ) AND comment_type != 'order_note' AND
comment_type != 'webhook_delivery'
ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC
;
|
0.1349 [ms]
|
SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (121,150,166,167,172);
|
0.2320 [ms]
|
SELECT wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 238 AND comment_parent IN ( 121,150,166,167,172 ) AND comment_type != 'order_note' AND
comment_type != 'webhook_delivery'
ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC
;
|
0.1211 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'akismet_comment_nonce' LIMIT 1;
|
I love your plugin!
is possible to exclude 1 category in the list?
tnx bb
Around line 270 there is a foreach loop:
if ($all_tags)
foreach ($all_tags as $tag)
$tags[''.$tag->term_id] = $tag->name;
You could add a condition inside that loop that would exclude you unwanted Category. If you unwanted Category was “Hidden Posts” then your code would look something like this:
if ($all_tags)
foreach ($all_tags as $tag)
if ($tag->name != "Hidden Posts")
$tags[''.$tag->term_id] = $tag->name;
Hello!
Today i update your plugin to the new version, and now i have this error: “Warning: Invalid argument supplied for foreach() in /home/nivam/pplenka.ru/docs/wps/wp-content/plugins/spostarbust/index.php on line 457”
if i turn off your plugin, no errors…
Thanks for letting me know!
I just released version 1.2.02.17 with a fix for the Warning: “Invalid argument supplied for foreach” on line 457.
Mahalo nui, Eli
I loved your plugin, but recently it has been acting strangely – first showing nothing, though settings were the same, then showing related content beneath post, though settings were clearly set for tree view in widget only. So I’m only disabling it for now, till I have time to test what’s going on.
I recently released a new version with a lot of bug fixes. Please give it a try and see if it resolves your issues.
Is there a way to randomize which related posts are shown?
No, I’m sorry but right now the query just pulls the most recent post matching your Tags or Categories. I guess I could look into other optional parameters to pass to the query. I’ll put this on the wish list and see if I can work it into a future release.
Donations always help me come up with the time to do stuff like this ;-)
Thanks for your interest,
Eli
I added the option to change the sort criteria and RAND is one of the options. Please download version 1.2.03.14 and let me know how it works for you. Also please vote “Works” and rate Five Stars on WordPress.org