|
0.2401 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;
|
|
0.1180 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;
|
|
0.1168 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/3.214.184.223/1695756976.4847' LIMIT 1;
|
|
0.1919 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'at_options' LIMIT 1;
|
|
0.1190 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_edit_links_calypso_redirect' LIMIT 1;
|
|
0.1431 [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.1340 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
|
0.0851 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;
|
|
0.0851 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;
|
|
0.1521 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;
|
|
0.1171 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;
|
|
0.0842 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;
|
|
0.2198 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_navigation_enabled' LIMIT 1;
|
|
0.0830 [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.1180 [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.0861 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_platform_checkout' LIMIT 1;
|
|
0.0939 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_customer_multi_currency' LIMIT 1;
|
|
0.0992 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;
|
|
0.2902 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;
|
|
0.0989 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;
|
|
2.3799 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;
|
|
0.1421 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_upe' LIMIT 1;
|
|
0.1690 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;
|
|
0.2310 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;
|
|
0.0839 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;
|
|
0.1199 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_services' LIMIT 1;
|
|
0.0830 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_setup_automated_taxes' LIMIT 1;
|
|
0.1459 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_disabled_plugins' LIMIT 1;
|
|
0.1669 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1676 LIMIT 1;
|
|
0.0930 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcs_do_subscriptions_exist' LIMIT 1;
|
|
0.0920 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcs_do_subscriptions_exist' LIMIT 1;
|
|
0.1140 [ms]
|
SELECT ID FROM wp_posts WHERE post_type = 'shop_subscription' LIMIT 1;;
|
|
0.1101 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;
|
|
0.0830 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;
|
|
0.2379 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;
|
|
0.0811 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;
|
|
0.0792 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;
|
|
0.0868 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;
|
|
0.1009 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_retrieval_error' LIMIT 1;
|
|
0.0801 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;
|
|
0.0801 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;
|
|
0.0658 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;
|
|
0.0629 [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.0520 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enable_auto_currency' LIMIT 1;
|
|
0.0801 [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.0789 [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.0801 [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.0801 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_delivery_settings' LIMIT 1;
|
|
0.0658 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_pickup_settings' LIMIT 1;
|
|
0.0551 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1;
|
|
0.0808 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_doing_cron' LIMIT 1;
|
|
0.5980 [ms]
|
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1695756976.8403589725494384765625', 'yes') ON
DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
|
0.3211 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM wp_posts
WHERE post_name IN ('my-new-sql-reports-plugin-for-your-wordpress-admin')
AND post_type IN ('page','attachment')
;
|
|
0.2151 [ms]
|
SELECT wp_posts.*
FROM wp_posts
WHERE 1=1 AND wp_posts.post_name = 'my-new-sql-reports-plugin-for-your-wordpress-admin' AND wp_posts.post_type = 'post'
ORDER BY wp_posts.post_date DESC
;
|
|
0.3130 [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 (171)
ORDER BY t.name ASC
;
|
|
0.2010 [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,36,35,108);
|
|
0.1440 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (171) ORDER BY meta_id ASC;
|
|
0.1011 [ms]
|
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REMOTE_ADDR' AND meta_value = '3.214.184.223';
|
|
0.1349 [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.0920 [ms]
|
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value = '/my-new-sql-reports-plugin-for-your-wordpress-admin/';
|
|
0.4301 [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',
40690, 7541, 16079, 1214, '2023-09-26 19:36:17', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2023-09-26 19:36:17', wp_user = 0, hit_count = hit_count +
1;
|
|
0.1221 [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.0701 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;
|
|
0.1180 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'sharedaddy_disable_resources' LIMIT 1;
|
|
0.1562 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;
|
|
0.0830 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;
|
|
0.1268 [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.3030 [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.3161 [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.1950 [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.1540 [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.2110 [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 (171)
ORDER BY t.name ASC
;
|
|
0.3300 [ms]
|
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;
|
|
0.1302 [ms]
|
SELECT * FROM wp_users WHERE ID IN (1);
|
|
0.1271 [ms]
|
SELECT p.ID FROM wp_posts AS p WHERE p.post_date < '2011-12-13 13:34:25' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date
DESC LIMIT 1;
|
|
0.0999 [ms]
|
SELECT * FROM wp_posts WHERE ID = 151 LIMIT 1;
|
|
0.1590 [ms]
|
SELECT p.ID FROM wp_posts AS p WHERE p.post_date > '2011-12-13 13:34:25' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date
ASC LIMIT 1;
|
|
0.1371 [ms]
|
SELECT * FROM wp_posts WHERE ID = 183 LIMIT 1;
|
|
0.2170 [ms]
|
SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 171 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.1321 [ms]
|
SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (196);
|
|
0.1760 [ms]
|
SELECT wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 171 AND comment_parent IN ( 196 ) AND comment_type != 'order_note' AND comment_type !=
'webhook_delivery'
ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC
;
|
|
0.1190 [ms]
|
SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (197);
|
|
0.1979 [ms]
|
SELECT wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 171 AND comment_parent IN ( 197 ) AND comment_type != 'order_note' AND comment_type !=
'webhook_delivery'
ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC
;
|
|
0.1180 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'akismet_comment_nonce' LIMIT 1;
|
Is there any way to put the results of the reports in a page? Some shortcode or other way? I am fairly new to this, so I thank you for your help!
That is a great idea. I originally designed this plugin to make custom reports in the WP Admin. Being able to put a report on a Page is a worthy request. I will add a shortcode for that now and release an update to the repository.
Thanks so much for the suggestion!