@cnxsoft, it only stores the link.
Can you provide the screenshot of the results of the query monitor just to check what’s going on?
@cnxsoft 0.1 doesn’t seem, to me, a slow query. That’s strange. As You can see the SQL select query is returning the same meta_value used in where clause and returning also the post_id… So it’s returning only the image file path.
Anyway, can you go to your database table wp_postmeta and add an index for meta_key and another for meta_value and check if that “slow” warning goes away?
@cnxsoft also, the function that’s being called is attachment_url_to_postid. Even though the monitor is saying that is from our plugin that is a default WP function.
Thanks. I’ve done it, and the slow query is done.
If somebody has the same issue that’s the command I ran in mysql:
ALTER TABLE $wpdb->postmeta ADD INDEX meta_key_meta_value (meta_key(191), meta_value (64));
There’s some more info @ https://core.trac.wordpress.org/ticket/41281
It’s not directly related to simple author box and happens on blogs with many (thousands) of posts.
@cnxsoft thanks for the type.