|
0.2501 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;
|
|
0.0939 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;
|
|
0.1121 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/35.175.191.46/1695517258.601' LIMIT 1;
|
|
0.2229 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'at_options' LIMIT 1;
|
|
0.1221 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_edit_links_calypso_redirect' LIMIT 1;
|
|
0.1240 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1;
|
|
0.2232 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;
|
|
0.1490 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;
|
|
0.1011 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;
|
|
0.1080 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;
|
|
0.1819 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;
|
|
0.1180 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;
|
|
0.1149 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;
|
|
0.2310 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_navigation_enabled' LIMIT 1;
|
|
0.1020 [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.1619 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_view_subscriptions_endpoint' LIMIT 1;
|
|
0.1218 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_account_data' LIMIT 1;
|
|
0.1390 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_platform_checkout' LIMIT 1;
|
|
0.1340 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_customer_multi_currency' LIMIT 1;
|
|
0.1159 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;
|
|
0.1719 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;
|
|
0.0861 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;
|
|
3.2110 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;
|
|
0.1121 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_upe' LIMIT 1;
|
|
0.2069 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;
|
|
0.2420 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;
|
|
0.1469 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;
|
|
0.1230 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_services' LIMIT 1;
|
|
0.1011 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_setup_automated_taxes' LIMIT 1;
|
|
0.1290 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_disabled_plugins' LIMIT 1;
|
|
0.1261 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1676 LIMIT 1;
|
|
0.1099 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcs_do_subscriptions_exist' LIMIT 1;
|
|
0.0930 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_wcs_do_subscriptions_exist' LIMIT 1;
|
|
0.1869 [ms]
|
SELECT ID FROM wp_posts WHERE post_type = 'shop_subscription' LIMIT 1;;
|
|
0.1040 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;
|
|
0.0999 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;
|
|
0.2341 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;
|
|
0.0942 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;
|
|
0.1149 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;
|
|
0.1450 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;
|
|
0.1490 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_retrieval_error' LIMIT 1;
|
|
0.1121 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;
|
|
0.0880 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;
|
|
0.0730 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;
|
|
0.1040 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_rounding_usd' LIMIT 1;
|
|
0.0730 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_exchange_rate_usd' LIMIT 1;
|
|
0.0679 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enable_auto_currency' LIMIT 1;
|
|
0.0780 [ms]
|
SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;;
|
|
0.0701 [ms]
|
SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0;
|
|
0.0761 [ms]
|
SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0;
|
|
0.0780 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_flat_rate_settings' LIMIT 1;
|
|
0.0648 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_free_shipping_settings' LIMIT 1;
|
|
0.0761 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_international_delivery_settings' LIMIT 1;
|
|
0.0660 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_delivery_settings' LIMIT 1;
|
|
0.0648 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_pickup_settings' LIMIT 1;
|
|
0.0761 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1;
|
|
0.0620 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = '_transient_doing_cron' LIMIT 1;
|
|
0.5560 [ms]
|
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1695517259.0211069583892822265625', 'yes') ON
DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
|
|
0.4220 [ms]
|
SELECT ID, post_name, post_parent, post_type
FROM wp_posts
WHERE post_name IN ('added-automated-database-backups-to-my-sql-plugin')
AND post_type IN ('page','attachment')
;
|
|
0.3040 [ms]
|
SELECT wp_posts.*
FROM wp_posts
WHERE 1=1 AND wp_posts.post_name = 'added-automated-database-backups-to-my-sql-plugin' AND wp_posts.post_type = 'post'
ORDER BY wp_posts.post_date DESC
;
|
|
0.3772 [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 (544)
ORDER BY t.name ASC
;
|
|
0.2348 [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 (97,16,36,35);
|
|
0.1512 [ms]
|
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (544) 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.1252 [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.0970 [ms]
|
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_REFERER' AND meta_value = '';
|
|
0.1419 [ms]
|
SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value =
'/added-automated-database-backups-to-my-sql-plugin/?replytocom=4131';
|
|
0.4299 [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, 267, '2023-09-24 01:00:59', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2023-09-24 01:00:59', wp_user = 0, hit_count = hit_count +
1;
|
|
0.0992 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cart_page_id' LIMIT 1;
|
|
0.0861 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_checkout_page_id' LIMIT 1;
|
|
0.0689 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;
|
|
0.1922 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'sharedaddy_disable_resources' LIMIT 1;
|
|
0.1481 [ms]
|
SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;
|
|
0.1400 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;
|
|
0.1149 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_demo_store' LIMIT 1;
|
|
0.1588 [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.3290 [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.3951 [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.2060 [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.1280 [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.1929 [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 (544)
ORDER BY t.name ASC
;
|
|
0.3648 [ms]
|
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;
|
|
0.1330 [ms]
|
SELECT * FROM wp_users WHERE ID IN (1);
|
|
0.1881 [ms]
|
SELECT p.ID FROM wp_posts AS p WHERE p.post_date < '2013-06-14 13:27:51' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date
DESC LIMIT 1;
|
|
0.1378 [ms]
|
SELECT * FROM wp_posts WHERE ID = 546 LIMIT 1;
|
|
0.1719 [ms]
|
SELECT p.ID FROM wp_posts AS p WHERE p.post_date > '2013-06-14 13:27:51' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date
ASC LIMIT 1;
|
|
0.1278 [ms]
|
SELECT * FROM wp_posts WHERE ID = 577 LIMIT 1;
|
|
0.4840 [ms]
|
SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 544 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.1860 [ms]
|
SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (4071,4083,4092,4116,4128,7106,27237,27709);
|
|
0.2801 [ms]
|
SELECT wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 544 AND comment_parent IN ( 4071,4083,4092,4116,4128,7106,27237,27709 ) AND comment_type !=
'order_note' AND comment_type != 'webhook_delivery'
ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC
;
|
|
0.1729 [ms]
|
SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (4084,4093,4118,4131,8502,27238,27712);
|
|
0.1869 [ms]
|
SELECT wp_comments.comment_ID
FROM wp_comments
WHERE ( comment_approved = '1' ) AND comment_post_ID = 544 AND comment_parent IN ( 4084,4093,4118,4131,8502,27238,27712 ) AND comment_type !=
'order_note' AND comment_type != 'webhook_delivery'
ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC
;
|
|
0.1402 [ms]
|
SELECT option_value FROM wp_options WHERE option_name = 'akismet_comment_nonce' LIMIT 1;
|
Hiya, sorry haven’t quite caught your name yet. Just wanted to inform you that your shareable link isnt working or updating correctly in google’s analytics… I eat my own words just refreshed the page, Everything seems to be working accordingly. Just wanted to say thank you for linking in. I think im still kinda of new to the whole idea but am learning quite quickly. Have a good one
“the scribe” JJE
have a wonderful respected day/night
Hi, Eli.
Love the SQL reports plugin…nice and simple!
I do have a question. How would I create a report with working links?
for example…if I query the userid and username and want to make the username clickable to go to its userprofile.
Probably would need to do a check which report is requested and modify the actual output for that specific report. But how?
Keep up the nice work.
Kind regards,
Jerome.
Thanks!
Here is an example of a query that would produce a link (the exact link may not be right but you get the idea :-)
SELECT CONCAT('<a href="/user/',ID,'" rel="nofollow">', user_nicename,'</a>') AS ProfileLink, display_name FROM `wp_users`Hi Eli,
I know this is an unrelated post, but I searched for a contact form on your website and also tried to create a new thread in the wordpress forums, but both were unsuccessful.
First and foremost, I want to say how grateful I am for your plugin, it is the only software out there that’s useful for these sorts of things and you put it out for free.
I have a fairly serious problem with my site at the moment and I seem to remember reading a while back that you’re happy to take admin details and have a look at problems directly (I am a proud donator and would happily donate again).
I would really appreciate any help you can provide with this as my blog is very, very ill at the moment!
Thanks Eli,
Ed
Thanks for your kind words. Yes, I’m always willing to help. You can send your WP Admin credentials directly to my email: eli AT gotmls DOT net
Eli, can you point me to a code snippet that I can integrate into the sql of my reports to point the output to Excel, CSV or Text rather than painting the screen, or in addition to painting the screen? I have not been able to find a way to do this from the report sql.
Thanks!
I don’t know of a plugin that will do that but you can copy and HTML table from any webpage and copy paste it into an Excel spreadsheet.
With the most recent version, sub-selects are no longer working. I’m passing through results view directly into print_r array.
for example (note that I have this installed – http://auctionplugin.net/):
select CONCAT(““,Item,”“) as Item, NumBids from (select p.ID as ID,p.post_title as Item,count(b.bid) as NumBids from wp_ps101_posts p, wp_ps101_wdm_bidders b where p.ID = b.auction_id group by p.ID order by NumBids desc) as bid_count LIMIT 3
but regardless .. the sub-select fails to return results. It’s like your parsed the SQL based on the word SELECT and failed to consider sub-selects.
Thanks, JPF
Sub-queries work fine for me in the latest version. I’m not parsing on the work select either.
Your query is unfamiliar to me but I would think you should have things in a different order. I usually use sub-queries before the “from” or after the “where”. Also, I don’t see how you are expecting that sub-query to return multiple fields.
Have you tried running that whole query in PhpMyAdmin?
I’ve installed your SQL Reports plugin and all works as expected. I have embedded my report into a page and that works great. What I am trying to figure out is how to resize the columns. I am not seeing where or how to do this. Any help you could offer is appreciated!
You can use CSS to size the columns. I would need to see an example page of the report you have and a better description of what you would like it to look like in order to help you further.
Eli, I use your great plugin extensively in our website but I cannot figure out how to do any date arithmetic. None of the usual SQL date arithmetic commands work. Can you help? I want to subtract one date field from another date field and express the result as the number of days difference between the two dates.
Thanks
Frank
Try this:
SELECT DATEDIFF(date1, date2) AS DaySpan FROM …
Hello,
at the moment no queries works like :
SELECT COUNT(*) FROM wp_users
Result is everytime :
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘This SQL Query has not been allowed by an Administrator.’ at line 1
All Queries I tested before in phpmyadmin. No problems.
What can I do?
Joe
I addressed this on the WordPress Forums after the latest release in which I added this new security measure.
So now you have to copy the SQL in those sqlgetvar calls that you want to approve and you can then paste that SQL into a new report and save the report so that only the sqlgetvar calls that you have stored as reports will work.