0.2241 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;
|
0.1099 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;
|
0.1299 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/35.175.191.46/1695511471.9854' LIMIT 1;
|
0.2279 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'at_options' LIMIT 1;
|
0.1240 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_edit_links_calypso_redirect' LIMIT 1;
|
0.1440 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
|
0.2489 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;
|
0.1318 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
0.1149 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;
|
0.0710 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;
|
0.1481 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;
|
0.1149 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;
|
0.0849 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;
|
0.1850 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_navigation_enabled' LIMIT 1;
|
0.1168 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;
|
0.0999 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;
|
0.1221 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_view_subscriptions_endpoint' LIMIT 1;
|
0.0899 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_account_data' LIMIT 1;
|
0.0818 [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.0980 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;
|
0.1640 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;
|
0.0880 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;
|
2.3410 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;
|
0.1431 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_upe' LIMIT 1;
|
0.1431 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;
|
0.1240 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;
|
0.1450 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;
|
0.0958 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_services' LIMIT 1;
|
0.1209 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_setup_automated_taxes' LIMIT 1;
|
0.1419 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_disabled_plugins' LIMIT 1;
|
0.1791 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1676 LIMIT 1;
|
0.1040 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcs_do_subscriptions_exist' LIMIT 1;
|
0.0951 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcs_do_subscriptions_exist' LIMIT 1;
|
0.1509 [ms]
|
SELECT ID FROM wp_posts WHERE post_type = 'shop_subscription' LIMIT 1;;
|
0.1070 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;
|
0.1001 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;
|
0.2019 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;
|
0.1369 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;
|
0.1190 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;
|
0.0920 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;
|
0.1090 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_retrieval_error' LIMIT 1;
|
0.0858 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;
|
0.0980 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;
|
0.0818 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;
|
0.0970 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_rounding_usd' LIMIT 1;
|
0.0870 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_exchange_rate_usd' LIMIT 1;
|
0.0870 [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.0842 [ms]
|
SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0;
|
0.0570 [ms]
|
SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0;
|
0.0670 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_flat_rate_settings' LIMIT 1;
|
0.0958 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_free_shipping_settings' LIMIT 1;
|
0.0820 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_international_delivery_settings' LIMIT 1;
|
0.0989 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_delivery_settings' LIMIT 1;
|
0.0811 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_pickup_settings' LIMIT 1;
|
0.0589 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1;
|
0.0801 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_doing_cron' LIMIT 1;
|
0.5240 [ms]
|
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1695511472.3429069519042968750000', 'yes') ON
DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
0.3529 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM wp_posts
WHERE post_name IN ('thanks-for-your-donation')
AND post_type IN ('page','attachment')
;
|
0.1640 [ms]
|
SELECT * FROM wp_posts WHERE ID = 263 LIMIT 1;
|
0.1612 [ms]
|
SELECT wp_posts.*
FROM wp_posts
WHERE 1=1 AND (wp_posts.ID = '263') AND wp_posts.post_type = 'page'
ORDER BY wp_posts.post_date DESC
;
|
0.1810 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (263) ORDER BY meta_id ASC;
|
0.1490 [ms]
|
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REMOTE_ADDR' AND meta_value = '35.175.191.46';
|
0.1750 [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.1299 [ms]
|
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_REFERER' AND meta_value = '';
|
0.1440 [ms]
|
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value = '/thanks-for-your-donation/?replytocom=4135';
|
0.3600 [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-09',
40561, 7541, 16079, 9633, '2023-09-23 23:24:32', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2023-09-23 23:24:32', wp_user = 0, hit_count = hit_count +
1;
|
0.1161 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cart_page_id' LIMIT 1;
|
0.0720 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_checkout_page_id' LIMIT 1;
|
0.0710 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;
|
0.1562 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'sharedaddy_disable_resources' LIMIT 1;
|
0.1519 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;
|
0.1559 [ms]
|
SELECT wp_posts.ID
FROM wp_posts
WHERE 1=1 AND wp_posts.post_parent = 263 AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish'))
ORDER BY wp_posts.post_title ASC
LIMIT 0, 1
;
|
0.1168 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;
|
0.1271 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_demo_store' LIMIT 1;
|
0.1831 [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.3440 [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.3750 [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.2019 [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,21,84,35);
|
0.1490 [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.3371 [ms]
|
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;
|
0.1290 [ms]
|
SELECT * FROM wp_users WHERE ID IN (1);
|
0.1960 [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 (263)
ORDER BY t.name ASC
;
|
0.4029 [ms]
|
SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 263 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.1659 [ms]
|
SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (214,273,4134,4186,4219,18180);
|
0.2470 [ms]
|
SELECT wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 263 AND comment_parent IN ( 214,273,4134,4186,4219,18180 ) AND comment_type != 'order_note'
AND comment_type != 'webhook_delivery'
ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC
;
|
0.1030 [ms]
|
SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (215,274,4135,8503);
|
0.2050 [ms]
|
SELECT wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 263 AND comment_parent IN ( 215,274,4135,8503 ) AND comment_type != 'order_note' AND
comment_type != 'webhook_delivery'
ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC
;
|
0.1261 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'akismet_comment_nonce' LIMIT 1;
|
I love your plugin and thank you so much for your prompt help and support!
Thank you for the Donation!
Eli is the grooviest guy in America!
Thanks so much
BTW: ….we’re just getting warmed up!
Thanks for your donation. I look forward to helping you with your next SQL project when that comes.
Thanks for the awesome plugin. Hope you enjoy your cup of coffee or bag of chips. Thanks very much.
Thanks :-)
I love the do_shortcode function!
Please Remove the Saved reports from the WordPress menu (left side) my list is getting huge!
My latest version of the SQL Reports plugin has the optional feature to NOT have all your reports on the admin menu.
Thanks! You are awesome!
Thanks for the nice plugin, Eli and thanks for some help you recently gave me. This donation is on behalf of trisomy, where we use EZ SQL to support reports associated with our membership system.