Log In

Or log in with these accounts:

Forgot your password?

Not a member?
Click here to register.

PCI Compliance and Malware Removal

(default) 8 queries took 10 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `wp_postmeta`	4	4	2
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb4_unicode_ci';	1	1	1
3	SHOW FULL COLUMNS FROM `wp_term_taxonomy`	6	6	1
4	SHOW FULL COLUMNS FROM `wp_posts`	23	23	1
5	SHOW FULL COLUMNS FROM `wp_term_relationships`	3	3	1
6	SHOW FULL COLUMNS FROM `wp_terms`	4	4	1
7	SHOW FULL COLUMNS FROM `settings`	6	6	2
8	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	1

(default) 8 queries took 10 ms

Query

Error

Affected

Num. rows

Took (ms)

SHOW FULL COLUMNS FROM `wp_postmeta`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb4_unicode_ci';

SHOW FULL COLUMNS FROM `wp_term_taxonomy`

SHOW FULL COLUMNS FROM `wp_posts`

SHOW FULL COLUMNS FROM `wp_term_relationships`

SHOW FULL COLUMNS FROM `wp_terms`

SHOW FULL COLUMNS FROM `settings`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';

(read) 16 queries took 21 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `WpTermTaxonomy`.`term_taxonomy_id`, `WpTermTaxonomy`.`term_id`, `WpTermTaxonomy`.`taxonomy`, `WpTermTaxonomy`.`description`, `WpTermTaxonomy`.`parent`, `WpTermTaxonomy`.`count`, (`WpTermTaxonomy`.`term_taxonomy_id`) AS `WpTermTaxonomy__id`, `WpTerm`.`term_id`, `WpTerm`.`name`, `WpTerm`.`slug`, `WpTerm`.`term_group`, (`WpTerm`.`term_id`) AS `WpTerm__id` FROM `wp_term_taxonomy` AS `WpTermTaxonomy` LEFT JOIN `wp_terms` AS `WpTerm` ON (`WpTermTaxonomy`.`term_id` = `WpTerm`.`term_id`) WHERE `slug` = 'top_menu_1' AND `taxonomy` = 'nav_menu' LIMIT 1	1	1	1
2	SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 7 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC	11	11	1
3	SELECT `WpPostMeta`.`meta_id`, `WpPostMeta`.`post_id`, `WpPostMeta`.`meta_key`, `WpPostMeta`.`meta_value`, (`WpPostMeta`.`meta_id`) AS `WpPostMeta__id` FROM `wp_postmeta` AS `WpPostMeta` WHERE post_id IN (39, 714, 653, 858, 859, 860, 650, 244, 789, 788, 252)	88	88	2
4	SELECT `WpTermTaxonomy`.`term_taxonomy_id`, `WpTermTaxonomy`.`term_id`, `WpTermTaxonomy`.`taxonomy`, `WpTermTaxonomy`.`description`, `WpTermTaxonomy`.`parent`, `WpTermTaxonomy`.`count`, (`WpTermTaxonomy`.`term_taxonomy_id`) AS `WpTermTaxonomy__id`, `WpTerm`.`term_id`, `WpTerm`.`name`, `WpTerm`.`slug`, `WpTerm`.`term_group`, (`WpTerm`.`term_id`) AS `WpTerm__id` FROM `wp_term_taxonomy` AS `WpTermTaxonomy` LEFT JOIN `wp_terms` AS `WpTerm` ON (`WpTermTaxonomy`.`term_id` = `WpTerm`.`term_id`) WHERE `slug` = 'top_menu_2' AND `taxonomy` = 'nav_menu' LIMIT 1	1	1	2
5	SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 6 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC	19	19	2
6	SELECT `WpPostMeta`.`meta_id`, `WpPostMeta`.`post_id`, `WpPostMeta`.`meta_key`, `WpPostMeta`.`meta_value`, (`WpPostMeta`.`meta_id`) AS `WpPostMeta__id` FROM `wp_postmeta` AS `WpPostMeta` WHERE post_id IN (36, 40, 787, 4830, 257, 4829, 1364, 4827, 4828, 1365, 1366, 1367, 1518, 861, 2110, 862, 863, 54, 559)	152	152	2
7	SELECT `WpTermTaxonomy`.`term_taxonomy_id`, `WpTermTaxonomy`.`term_id`, `WpTermTaxonomy`.`taxonomy`, `WpTermTaxonomy`.`description`, `WpTermTaxonomy`.`parent`, `WpTermTaxonomy`.`count`, (`WpTermTaxonomy`.`term_taxonomy_id`) AS `WpTermTaxonomy__id`, `WpTerm`.`term_id`, `WpTerm`.`name`, `WpTerm`.`slug`, `WpTerm`.`term_group`, (`WpTerm`.`term_id`) AS `WpTerm__id` FROM `wp_term_taxonomy` AS `WpTermTaxonomy` LEFT JOIN `wp_terms` AS `WpTerm` ON (`WpTermTaxonomy`.`term_id` = `WpTerm`.`term_id`) WHERE `slug` = 'footer_1' AND `taxonomy` = 'nav_menu' LIMIT 1	1	1	2
8	SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 9 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC	5	5	1
9	SELECT `WpPostMeta`.`meta_id`, `WpPostMeta`.`post_id`, `WpPostMeta`.`meta_key`, `WpPostMeta`.`meta_value`, (`WpPostMeta`.`meta_id`) AS `WpPostMeta__id` FROM `wp_postmeta` AS `WpPostMeta` WHERE post_id IN (62, 265, 3055, 3672, 3673)	40	40	1
10	SELECT `WpTermTaxonomy`.`term_taxonomy_id`, `WpTermTaxonomy`.`term_id`, `WpTermTaxonomy`.`taxonomy`, `WpTermTaxonomy`.`description`, `WpTermTaxonomy`.`parent`, `WpTermTaxonomy`.`count`, (`WpTermTaxonomy`.`term_taxonomy_id`) AS `WpTermTaxonomy__id`, `WpTerm`.`term_id`, `WpTerm`.`name`, `WpTerm`.`slug`, `WpTerm`.`term_group`, (`WpTerm`.`term_id`) AS `WpTerm__id` FROM `wp_term_taxonomy` AS `WpTermTaxonomy` LEFT JOIN `wp_terms` AS `WpTerm` ON (`WpTermTaxonomy`.`term_id` = `WpTerm`.`term_id`) WHERE `slug` = 'footer_2' AND `taxonomy` = 'nav_menu' LIMIT 1	1	1	1
11	SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 10 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC	6	6	1
12	SELECT `WpPostMeta`.`meta_id`, `WpPostMeta`.`post_id`, `WpPostMeta`.`meta_key`, `WpPostMeta`.`meta_value`, (`WpPostMeta`.`meta_id`) AS `WpPostMeta__id` FROM `wp_postmeta` AS `WpPostMeta` WHERE post_id IN (63, 64, 266, 267, 268, 269)	48	48	1
13	SELECT `WpTermTaxonomy`.`term_taxonomy_id`, `WpTermTaxonomy`.`term_id`, `WpTermTaxonomy`.`taxonomy`, `WpTermTaxonomy`.`description`, `WpTermTaxonomy`.`parent`, `WpTermTaxonomy`.`count`, (`WpTermTaxonomy`.`term_taxonomy_id`) AS `WpTermTaxonomy__id`, `WpTerm`.`term_id`, `WpTerm`.`name`, `WpTerm`.`slug`, `WpTerm`.`term_group`, (`WpTerm`.`term_id`) AS `WpTerm__id` FROM `wp_term_taxonomy` AS `WpTermTaxonomy` LEFT JOIN `wp_terms` AS `WpTerm` ON (`WpTermTaxonomy`.`term_id` = `WpTerm`.`term_id`) WHERE `slug` = 'footer_3' AND `taxonomy` = 'nav_menu' LIMIT 1	1	1	1
14	SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 11 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC	6	6	1
15	SELECT `WpPostMeta`.`meta_id`, `WpPostMeta`.`post_id`, `WpPostMeta`.`meta_key`, `WpPostMeta`.`meta_value`, (`WpPostMeta`.`meta_id`) AS `WpPostMeta__id` FROM `wp_postmeta` AS `WpPostMeta` WHERE post_id IN (65, 3713, 66, 270, 271, 4521)	48	48	1
16	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`options`, `Setting`.`is_custom`, `Setting`.`is_editable` FROM `settings` AS `Setting` WHERE `key` = 'support_email' LIMIT 1	1	1	1

(read) 16 queries took 21 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `WpTermTaxonomy`.`term_taxonomy_id`, `WpTermTaxonomy`.`term_id`, `WpTermTaxonomy`.`taxonomy`, `WpTermTaxonomy`.`description`, `WpTermTaxonomy`.`parent`, `WpTermTaxonomy`.`count`, (`WpTermTaxonomy`.`term_taxonomy_id`) AS `WpTermTaxonomy__id`, `WpTerm`.`term_id`, `WpTerm`.`name`, `WpTerm`.`slug`, `WpTerm`.`term_group`, (`WpTerm`.`term_id`) AS `WpTerm__id` FROM `wp_term_taxonomy` AS `WpTermTaxonomy` LEFT JOIN `wp_terms` AS `WpTerm` ON (`WpTermTaxonomy`.`term_id` = `WpTerm`.`term_id`) WHERE `slug` = 'top_menu_1' AND `taxonomy` = 'nav_menu' LIMIT 1

SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 7 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC

SELECT `WpPostMeta`.`meta_id`, `WpPostMeta`.`post_id`, `WpPostMeta`.`meta_key`, `WpPostMeta`.`meta_value`, (`WpPostMeta`.`meta_id`) AS `WpPostMeta__id` FROM `wp_postmeta` AS `WpPostMeta` WHERE post_id IN (39, 714, 653, 858, 859, 860, 650, 244, 789, 788, 252)

SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 6 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC

SELECT `WpPostMeta`.`meta_id`, `WpPostMeta`.`post_id`, `WpPostMeta`.`meta_key`, `WpPostMeta`.`meta_value`, (`WpPostMeta`.`meta_id`) AS `WpPostMeta__id` FROM `wp_postmeta` AS `WpPostMeta` WHERE post_id IN (36, 40, 787, 4830, 257, 4829, 1364, 4827, 4828, 1365, 1366, 1367, 1518, 861, 2110, 862, 863, 54, 559)

152

SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 9 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC

SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 10 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC

SELECT `WpPost`.`post_title`, `WpPost`.`post_excerpt`, (`WpPost`.`ID`) AS `WpPost__id`, `WpTermRelationship`.`object_id`, `WpTermRelationship`.`term_taxonomy_id`, `WpTermRelationship`.`term_order` FROM `wp_posts` AS `WpPost` JOIN `wp_term_relationships` AS `WpTermRelationship` ON (`WpTermRelationship`.`term_taxonomy_id` = 11 AND `WpTermRelationship`.`object_id` = `WpPost`.`ID`) ORDER BY `menu_order` ASC

SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`options`, `Setting`.`is_custom`, `Setting`.`is_editable` FROM `settings` AS `Setting` WHERE `key` = 'support_email' LIMIT 1