Title: [Plugin: Pagerank tools] Missing Index
Last modified: August 19, 2016

---

# [Plugin: Pagerank tools] Missing Index

 *  Resolved [Steve](https://wordpress.org/support/users/steveatty/)
 * (@steveatty)
 * [15 years, 6 months ago](https://wordpress.org/support/topic/plugin-pagerank-tools-missing-index/)
 * My mysql slow log query is showing a lot of the following:
 * `SELECT * FROM wp_1_prtools_url WHERE lastupdate<1288258725 OR (lastupdate<1290418725
   AND pr=-1) ORDER BY lastupdate LIMIT 0,5;`
 * You’re missing an index on lastupdate
 * [http://wordpress.org/extend/plugins/pagerank-tools/](http://wordpress.org/extend/plugins/pagerank-tools/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Sven Wagener](https://wordpress.org/support/users/mahype/)
 * (@mahype)
 * [15 years, 4 months ago](https://wordpress.org/support/topic/plugin-pagerank-tools-missing-index/#post-1788368)
 * Hi Steve,
 * i cant follow. What do you mean?
 * Sorry for my late answer. At the moment I’m programming a pro version which is
   99% ready. Maybe it will interest you 😉
 * Thank you for your efforts!
 * Sven
 *  Thread Starter [Steve](https://wordpress.org/support/users/steveatty/)
 * (@steveatty)
 * [15 years, 3 months ago](https://wordpress.org/support/topic/plugin-pagerank-tools-missing-index/#post-1788376)
 * I mean that you’re missing an index on the table which means that the queries
   run against it have to full table scan to get the data.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘[Plugin: Pagerank tools] Missing Index’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/pagerank-tools.svg)
 * [Pagerank tools](https://wordpress.org/plugins/pagerank-tools/)
 * [Support Threads](https://wordpress.org/support/plugin/pagerank-tools/)
 * [Active Topics](https://wordpress.org/support/plugin/pagerank-tools/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/pagerank-tools/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/pagerank-tools/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Steve](https://wordpress.org/support/users/steveatty/)
 * Last activity: [15 years, 3 months ago](https://wordpress.org/support/topic/plugin-pagerank-tools-missing-index/#post-1788376)
 * Status: resolved