Index WP MySQL For Speed

Speed up your WordPress site by adding high-performance keys (database indexes) to your MariaDB / MySQL database tables.

v1.5.7OllieJonesUpdated Added 50k+ installs96% rating80% support resolved
25
Score
250
Errors
255
Warnings
+0
Change

Category Scores

Security0
Repo100
Performance98
Maintainability0

Issues to Review

Prioritized issue groups from the latest Plugin Check scan

505 findings

Security

256

10 issue groups

Maintainability

186

14 issue groups

I18n

7

1 issue group

ERRORSecurityOutput is not escapedAll output should be run through an escaping function (see the Security sections in the WordPress Developer Handbooks), found '"<!--[if IE]><style type='text/css' id='internal-style-ie-{$_sID}' class='index-wp-mysql-for-speed-form-ie-style'>"'.75
Category
Security
Occurrences
75
Severity
error

Sample message

All output should be run through an escaping function (see the Security sections in the WordPress Developer Handbooks), found '"<!--[if IE]><style type='text/css' id='internal-style-ie-{$_sID}' class='index-wp-mysql-for-speed-form-ie-style'>"'.

ERRORMaintainabilityNot AllowedUse of heredoc syntax (<<<) is not allowed; use standard strings or inline HTML instead50
Category
Maintainability
Occurrences
50
Severity
error

Sample message

Use of heredoc syntax (<<<) is not allowed; use standard strings or inline HTML instead

ERRORSecuritySQL query is not preparedUse placeholders and $wpdb->prepare(); found $explainq38
Category
Security
Occurrences
38
Severity
error

Sample message

Use placeholders and $wpdb->prepare(); found $explainq

WARNINGSecurityRequest data is not unslashed$_GET[&#039;page&#039;] not unslashed before sanitization. Use wp_unslash() or similar26
Category
Security
Occurrences
26
Severity
warning

Sample message

$_GET[&#039;page&#039;] not unslashed before sanitization. Use wp_unslash() or similar

WARNINGSecurityMissing nonce verificationProcessing form data without nonce verification.25
Category
Security
Occurrences
25
Severity
warning

Sample message

Processing form data without nonce verification.

WARNINGSecurityInput is not sanitizedDetected usage of a non-sanitized input variable: $_FILES[&#039;__import&#039;]25
Category
Security
Occurrences
25
Severity
warning

Sample message

Detected usage of a non-sanitized input variable: $_FILES[&#039;__import&#039;]

WARNINGSecurityNonce verification recommendedProcessing form data without nonce verification.24
Category
Security
Occurrences
24
Severity
warning

Sample message

Processing form data without nonce verification.

WARNINGMaintainabilityslow db query meta keyDetected usage of meta_key, possible slow query.23
Category
Maintainability
Occurrences
23
Severity
warning

Sample message

Detected usage of meta_key, possible slow query.

WARNINGSecurityInput is not validatedDetected usage of a possibly undefined superglobal array index: $_FILES[&#039;__import&#039;]. Check that the array index exists before using it.20
Category
Security
Occurrences
20
Severity
warning

Sample message

Detected usage of a possibly undefined superglobal array index: $_FILES[&#039;__import&#039;]. Check that the array index exists before using it.

WARNINGMaintainabilityDirect QueryUse of a direct database call is discouraged.19
Category
Maintainability
Occurrences
19
Severity
warning

Sample message

Use of a direct database call is discouraged.

Show 15 more
WARNINGMaintainabilityNo Caching17
Category
Maintainability
Occurrences
17
Severity
warning

Sample message

Direct database call without caching detected. Consider using wp_cache_get() / wp_cache_set() or wp_cache_delete().

WARNINGMaintainabilityslow db query meta value13
Category
Maintainability
Occurrences
13
Severity
warning

Sample message

Detected usage of meta_value, possible slow query.

WARNINGMaintainabilityNon-prefixed global variable12
Category
Maintainability
Occurrences
12
Severity
warning

Sample message

Global variables defined by a theme/plugin should start with the theme/plugin prefix. Found: &quot;$_apf_sub_menus_to_sort&quot;.

ERRORMaintainabilityMissing direct file access protection11
Category
Maintainability
Occurrences
11
Severity
error

Sample message

PHP file should prevent direct access. Add a check like: if ( ! defined( 'ABSPATH' ) ) exit;

WARNINGSecurityDatabase parameter is not escaped8
Category
Security
Occurrences
8
Severity
warning

Sample message

Unescaped parameter $this used in $wpdb-&gt;get_results()

WARNINGMaintainabilityNon-prefixed hook name8
Category
Maintainability
Occurrences
8
Severity
warning

Sample message

Hook names invoked by a theme/plugin should start with the theme/plugin prefix. Found: &quot;add_meta_boxes_{$_sCurrentScreenID}&quot;.

ERRORSecurityException output is not escaped8
Category
Security
Occurrences
8
Severity
error

Sample message

All output should be run through an escaping function (see the Security sections in the WordPress Developer Handbooks), found '"Table $name invalid state $hasFastIndexes $hasStandardIndexes $hasOldIndexes"'.

ERRORMaintainabilityunlink unlink8
Category
Maintainability
Occurrences
8
Severity
error

Sample message

unlink() is discouraged. Use wp_delete_file() to delete a file.

ERRORSecurityDatabase parameter is not escaped7
Category
Security
Occurrences
7
Severity
error

Sample message

Unescaped parameter $q used in $wpdb->get_results()\n$q assigned unsafely at line 11.

ERRORMaintainabilitydate date7
Category
Maintainability
Occurrences
7
Severity
error

Sample message

date() is affected by runtime timezone changes which can cause date/time to be incorrectly displayed. Use gmdate() instead.

ERRORI18nMissing Arg Domain7
Category
I18n
Occurrences
7
Severity
error

Sample message

Missing $domain parameter in function call to __().

WARNINGMaintainabilityNon-prefixed class5
Category
Maintainability
Occurrences
5
Severity
warning

Sample message

Classes declared by a theme/plugin should start with the theme/plugin prefix. Found: &quot;Health&quot;.

WARNINGMaintainabilityerror log print r5
Category
Maintainability
Occurrences
5
Severity
warning

Sample message

print_r() found. Debug code should not normally be used in production.

WARNINGMaintainabilityDynamic hook name4
Category
Maintainability
Occurrences
4
Severity
warning

Sample message

Hook names invoked by a theme/plugin should start with the theme/plugin prefix. Found: &quot;get_class($this) . &#039;-&#039; . $_sScreenID&quot;.

WARNINGMaintainabilityerror log trigger error4
Category
Maintainability
Occurrences
4
Severity
warning

Sample message

trigger_error() found. Debug code should not normally be used in production.

Score History

First score snapshot

v1.5.7

25

Latest

Findings
505
Errors
250
Warnings
255
Check
2.0.0

Related Plugins

DietPress

2k+ active installs

100
Disable Emojis (GDPR friendly)

60k+ active installs

100
Embed Optimizer

50k+ active installs

100
Image Placeholders

60k+ active installs

100
100
Modern Image Formats

100k+ active installs

100