|
0.2532 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;
|
|
0.1459 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;
|
|
0.1020 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/1701520346.1977' LIMIT 1;
|
|
0.2210 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'at_options' LIMIT 1;
|
|
0.1149 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_edit_links_calypso_redirect' LIMIT 1;
|
|
0.1290 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
|
|
0.2451 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;
|
|
0.1431 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
|
0.1259 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;
|
|
0.0992 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;
|
|
0.1092 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;
|
|
0.0849 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;
|
|
0.1011 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;
|
|
0.1869 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_navigation_enabled' LIMIT 1;
|
|
0.1011 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;
|
|
0.1070 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;
|
|
0.1290 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_view_subscriptions_endpoint' LIMIT 1;
|
|
0.1030 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_account_data' LIMIT 1;
|
|
0.0880 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_platform_checkout' LIMIT 1;
|
|
0.1001 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_customer_multi_currency' LIMIT 1;
|
|
0.1049 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;
|
|
0.1910 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;
|
|
0.0949 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;
|
|
2.4841 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;
|
|
0.1380 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_upe' LIMIT 1;
|
|
0.1841 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;
|
|
0.2401 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;
|
|
0.1411 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;
|
|
0.1371 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_services' LIMIT 1;
|
|
0.1240 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_setup_automated_taxes' LIMIT 1;
|
|
0.1559 [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.1042 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcs_do_subscriptions_exist' LIMIT 1;
|
|
0.0970 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcs_do_subscriptions_exist' LIMIT 1;
|
|
0.1190 [ms]
|
SELECT ID FROM wp_posts WHERE post_type = 'shop_subscription' LIMIT 1;;
|
|
0.1130 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;
|
|
0.0892 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;
|
|
0.2339 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;
|
|
0.1049 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;
|
|
0.0861 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;
|
|
0.0930 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;
|
|
0.1080 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_retrieval_error' LIMIT 1;
|
|
0.1459 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;
|
|
0.0920 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;
|
|
0.0901 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;
|
|
0.0889 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_rounding_usd' LIMIT 1;
|
|
0.0551 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_exchange_rate_usd' LIMIT 1;
|
|
0.0842 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enable_auto_currency' LIMIT 1;
|
|
0.0799 [ms]
|
SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;;
|
|
0.0780 [ms]
|
SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0;
|
|
0.0970 [ms]
|
SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0;
|
|
0.0849 [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.0792 [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.0570 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1;
|
|
0.0830 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_doing_cron' LIMIT 1;
|
|
0.4561 [ms]
|
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1701520346.5535879135131835937500', 'yes') ON
DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
|
0.3421 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM wp_posts
WHERE post_name IN ('shortcode-support-added-to-sql-reports')
AND post_type IN ('page','attachment')
;
|
|
0.2248 [ms]
|
SELECT wp_posts.*
FROM wp_posts
WHERE 1=1 AND wp_posts.post_name = 'shortcode-support-added-to-sql-reports' AND wp_posts.post_type = 'post'
ORDER BY wp_posts.post_date DESC
;
|
|
0.3591 [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 (295)
ORDER BY t.name ASC
;
|
|
0.2320 [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 (54,17,16,25,36,35);
|
|
0.1600 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (295) ORDER BY meta_id ASC;
|
|
0.1440 [ms]
|
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REMOTE_ADDR' AND meta_value = '44.220.249.141';
|
|
0.1369 [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.1020 [ms]
|
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value = '/shortcode-support-added-to-sql-reports/';
|
|
0.3991 [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, 247, '2023-12-02 12:32:27', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2023-12-02 12:32:27', wp_user = 0, hit_count = hit_count +
1;
|
|
0.0811 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cart_page_id' LIMIT 1;
|
|
0.0620 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_checkout_page_id' LIMIT 1;
|
|
0.0601 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;
|
|
0.1020 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'sharedaddy_disable_resources' LIMIT 1;
|
|
0.1211 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;
|
|
0.0870 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;
|
|
0.0961 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_demo_store' LIMIT 1;
|
|
0.1409 [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.2730 [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.3278 [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.2022 [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);
|
|
0.1559 [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.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 (295)
ORDER BY t.name ASC
;
|
|
0.3150 [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.1779 [ms]
|
SELECT p.ID FROM wp_posts AS p WHERE p.post_date < '2012-04-05 16:11:35' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date
DESC LIMIT 1;
|
|
0.1020 [ms]
|
SELECT * FROM wp_posts WHERE ID = 299 LIMIT 1;
|
|
0.1631 [ms]
|
SELECT p.ID FROM wp_posts AS p WHERE p.post_date > '2012-04-05 16:11:35' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date
ASC LIMIT 1;
|
|
0.1349 [ms]
|
SELECT * FROM wp_posts WHERE ID = 301 LIMIT 1;
|
|
19.0821 [ms]
|
SELECT StatDomain AS Domain, SUM(StatVisits) `Total Visits Referred`, COALESCE((SELECT SUM(StatVisits) FROM wp_terribl_stats WHERE StatDomain =
google_stats.StatDomain AND StatReferer LIKE '%q=&%'), 0) AS `Keywords Blocked by SSL`, CONCAT(ROUND((COALESCE((SELECT SUM(StatVisits) FROM
wp_terribl_stats WHERE StatDomain = google_stats.StatDomain AND StatReferer LIKE '%q=&%'), 0) / SUM(StatVisits)) * 100), '%') AS `Percentage Blocked`
FROM wp_terribl_stats AS google_stats WHERE StatReferer LIKE 'http://www.google.%' GROUP BY StatDomain HAVING SUM(StatVisits) > 4 ORDER BY `Total
Visits Referred` DESC, `Keywords Blocked by SSL` ASC LIMIT 4;
|
|
0.2451 [ms]
|
SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 295 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.1531 [ms]
|
SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (2089,4057);
|
|
0.2279 [ms]
|
SELECT wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 295 AND comment_parent IN ( 2089,4057 ) AND comment_type != 'order_note' AND comment_type
!= 'webhook_delivery'
ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC
;
|
|
0.1709 [ms]
|
SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (2090,4059);
|
|
0.2291 [ms]
|
SELECT wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 295 AND comment_parent IN ( 2090,4059 ) AND comment_type != 'order_note' AND comment_type
!= 'webhook_delivery'
ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC
;
|
|
0.1240 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'akismet_comment_nonce' LIMIT 1;
|
Hi Eli… great script but I’m having a slight problem. I named one of my reports with an apostrophe ‘My Report’ and now I cannot delete the report. I assume the apostrophes are screwing up the SQL delete statement? I tried deactivating your plugin and deleting all files and reinstalling plugin, but the reports remain. Can I delete them directly from SQL using phpMyAdmin, and if so, where are these report names stored? Donation will follow should you reply … scouts honor!
Thanks for bringing this to my attention I will add a fix for the apostrophe issue in my next release. For now you can delete all your saved reports with this SQL:
DELETE FROM wp_options WHERE option_name LIKE ‘ELISQLREPORTS_reports_array’
If you are WP Serialize Savvy you hack up this option in phpMyAdmin to keep your other reports or just remove the apostrophe from the name but be sure to correct the value length markers or it won’t work at all.
Hi Eli:
I am looking for a plugin that will pull custom fields and return in a report format. Not a sql programmer so not sure this will work with your plugin. But, it seems if it is in mysql it should be able to be pulled.
Thanks
Joy
Where there’s SQL, there’s a way!
If you can give me a good idea of what you want your report to look like I can help you formulate an SQL query.