212958 : Slow Query Summary over 12 hours. # A software update is available: # 180ms user time, 40ms system time, 44.22M rss, 74.57M vsz # Current date: Fri May 12 09:49:34 2023 # Hostname: pod-212958-utility-94b45fb5d-79chh # Files: /var/log/mysql/mysql-slow.log # Overall: 64 total, 9 unique, 0.00 QPS, 0.02x concurrency _______________ # Time range: 2023-05-12T02:18:53 to 2023-05-12T09:39:22 # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 454s 5s 17s 7s 15s 3s 6s # Lock time 10ms 30us 2ms 158us 236us 172us 125us # Rows sent 3.72M 0 3.39M 59.55k 80.10 424.27k 0 # Rows examine 24.73M 783 3.39M 395.74k 961.27k 838.20k 68.96k # Rows affecte 0 0 0 0 0 0 0 # Bytes sent 109.27M 63 42.73M 1.71M 49.01k 7.64M 202.40 # Query size 77.87k 273 5.55k 1.22k 2.50k 859.92 1.09k # Profile # Rank Query ID Response time Calls R/Call V/M Item # ==== ================== ============== ===== ======= ===== ============= # 1 0x29879E2F7CC1BDE2 284.8620 62.7% 46 6.1927 0.21 SELECT # 2 0xA9760B08514C7FCC 79.6397 17.5% 8 9.9550 1.63 SELECT wp_comments # 3 0x9349203FF74E9ABE 33.3242 7.3% 2 16.6621 0.05 SELECT wp_comments # 4 0x19030063C82C2E34 14.3815 3.2% 2 7.1907 0.13 SELECT # 5 0x67A347A2812914DF 12.4841 2.7% 2 6.2421 0.45 SELECT wp_postmeta wp_comments # 6 0xA4BAC72C93866059 9.6592 2.1% 1 9.6592 0.00 SELECT wp_comments # MISC 0xMISC 19.8514 4.4% 3 6.6171 0.0 <3 ITEMS> # Query 1: 0.14 QPS, 0.87x concurrency, ID 0x29879E2F7CC1BDE2 at byte 53051 # Scores: V/M = 0.21 # Time range: 2023-05-12T05:41:22 to 2023-05-12T05:46:51 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 71 46 # Exec time 62 285s 5s 11s 6s 8s 1s 6s # Lock time 57 6ms 74us 244us 126us 167us 30us 125us # Rows sent 0 863 0 668 18.76 34.95 95.86 0 # Rows examine 10 2.56M 783 134.49k 57.05k 130.04k 43.98k 30.09k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 141.65k 187 60.16k 3.08k 6.31k 11.19k 234.30 # Query size 68 53.69k 814 1.60k 1.17k 1.39k 185.94 1.14k # String: # Databases wp_princephilippa # Hosts 127.0.0.1 # Last errno 0 # Users princephilippa # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # # EXPLAIN /*!50100 PARTITIONS*/ SELECT "visitor_cookie","visitor_id" FROM "wp_cli_visitor_details" WHERE "visitor_cookie" LIKE '%if( $$$_POST[\'$_upl\'] == \"Upload\" ) {%' ESCAPE '$' OR "visitor_cookie" LIKE '%Mister Spy%' ESCAPE '$' OR "visitor_cookie" LIKE '%$$$_POST[\'password\'] == %' ESCAPE '$' OR "visitor_cookie" LIKE '%file$_get$_contents(\'http:%' ESCAPE '$' OR "visitor_cookie" LIKE '%if (strpos($$$_SERVER[\'PHP$_SELF\'],\'subscriptions.php%' ESCAPE '$' OR "visitor_cookie" LIKE '%if(isset($$$_REQUEST[\'x\']%' ESCAPE '$' OR "visitor_cookie" LIKE '%SELECT `code` FROM `wp$_config%' ESCAPE '$' OR "visitor_cookie" LIKE '%Hmei7%' ESCAPE '$' OR "visitor_cookie" LIKE '%argaiv%' ESCAPE '$' OR "visitor_cookie" LIKE '%silaic%' ESCAPE '$' OR "visitor_cookie" LIKE '%elitcere%' ESCAPE '$' OR "visitor_cookie" LIKE '%ecnetopmi%' ESCAPE '$' OR "visitor_cookie" LIKE '%ycamrahp%' ESCAPE '$' OR "visitor_cookie" LIKE '%yadyap%' ESCAPE '$' OR "visitor_cookie" LIKE '%etirw.tnemucod%' ESCAPE '$' OR "visitor_cookie" LIKE '%46esab%' ESCAPE '$' OR "visitor_cookie" LIKE '%ecalper$_gerp%' ESCAPE '$' OR "visitor_cookie" LIKE '%etalfnizg%' ESCAPE '$' OR "visitor_cookie" LIKE '%al$_ki$_shell%' ESCAPE '$' OR "visitor_cookie" LIKE '%LCWEHH%' ESCAPE '$'\G # Query 2: 0.00 QPS, 0.00x concurrency, ID 0xA9760B08514C7FCC at byte 102161 # Scores: V/M = 1.63 # Time range: 2023-05-12T05:07:59 to 2023-05-12T09:39:22 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 12 8 # Exec time 17 80s 6s 16s 10s 15s 4s 12s # Lock time 29 3ms 127us 2ms 373us 1ms 417us 210us # Rows sent 0 8 1 1 1 1 0 1 # Rows examine 31 7.82M 1001.38k 1001.38k 1001.38k 1001.38k 0 1001.38k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 1.27k 163 163 163 163 0 163 # Query size 3 2.52k 297 369 322.25 363.48 25.56 299.03 # String: # Databases wp_lakinandstg # Hosts 127.0.0.1 # Last errno 0 # Users lakinandstg # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ ###################################### # Tables # SHOW TABLE STATUS FROM `wp_lakinandstg` LIKE 'wp_comments'\G # SHOW CREATE TABLE `wp_lakinandstg`.`wp_comments`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT comment_approved, COUNT( * ) AS num_comments FROM wp_comments WHERE comment_type != 'propertyhive_note' GROUP BY comment_approved /* From [lakinandstg.wpengine.com/wp-admin/admin.php?page=ph-settings&tab=mapsearch] in [/nas/content/live/lakinandstg/wp-content/plugins/propertyhive/includes/class-ph-comments.php:456] */\G # Query 3: 0.12 QPS, 2.08x concurrency, ID 0x9349203FF74E9ABE at byte 99140 # Scores: V/M = 0.05 # Time range: 2023-05-12T08:34:24 to 2023-05-12T08:34:40 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 2 # Exec time 7 33s 16s 17s 17s 17s 952ms 17s # Lock time 2 238us 109us 129us 119us 129us 14us 119us # Rows sent 0 1 0 1 0.50 1 0.71 0.50 # Rows examine 27 6.79M 3.39M 3.39M 3.39M 3.39M 0 3.39M # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 228 108 120 114 120 8.49 114 # Query size 0 563 281 282 281.50 282 0.71 281.50 # String: # Databases wp_mccarthyholden # Hosts 127.0.0.1 # Last errno 0 # Users mccarthyholden # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s # 10s+ ################################################################ # Tables # SHOW TABLE STATUS FROM `wp_mccarthyholden` LIKE 'wp_comments'\G # SHOW CREATE TABLE `wp_mccarthyholden`.`wp_comments`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT wp_comments.comment_ID FROM wp_comments WHERE ( ( comment_approved = '0' OR comment_approved = '1' ) ) AND comment_type != "propertyhive_note" ORDER BY wp_comments.comment_date_gmt DESC LIMIT 0,25 /* From [www.mccarthyholden.co.uk/wp-admin/] in [N/A] */\G # Query 4: 0.09 QPS, 0.65x concurrency, ID 0x19030063C82C2E34 at byte 82300 # Scores: V/M = 0.13 # Time range: 2023-05-12T05:45:47 to 2023-05-12T05:46:09 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 2 # Exec time 3 14s 7s 8s 7s 8s 974ms 7s # Lock time 2 242us 95us 147us 121us 147us 36us 121us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 60.90k 30.45k 30.45k 30.45k 30.45k 0 30.45k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 490 245 245 245 245 0 245 # Query size 7 5.55k 2.60k 2.95k 2.77k 2.95k 249.61 2.77k # String: # Databases wp_princephilippa # Hosts 127.0.0.1 # Last errno 0 # Users princephilippa # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # EXPLAIN /*!50100 PARTITIONS*/ SELECT "visitor_cookie","visitor_id" FROM "wp_cli_visitor_details" WHERE "visitor_cookie" LIKE '%free-trafficboom%' ESCAPE '$' OR "visitor_cookie" LIKE '%hotspill.com%' ESCAPE '$' OR "visitor_cookie" LIKE '%howtousemyipad.com%' ESCAPE '$' OR "visitor_cookie" LIKE '%champagnat37.com%' ESCAPE '$' OR "visitor_cookie" LIKE '%channelkolkata%' ESCAPE '$' OR "visitor_cookie" LIKE '%cheapwestcigarettes.com%' ESCAPE '$' OR "visitor_cookie" LIKE '%chesterfieldcigarettes4u.org%' ESCAPE '$' OR "visitor_cookie" LIKE '%chickneggsupply%' ESCAPE '$' OR "visitor_cookie" LIKE '%joanbeaulieu.com%' ESCAPE '$' OR "visitor_cookie" LIKE '%jurisprudenciacivi%' ESCAPE '$' OR "visitor_cookie" LIKE '%libertydining%' ESCAPE '$' OR "visitor_cookie" LIKE '%life4success.net%' ESCAPE '$' OR "visitor_cookie" LIKE '%medicalcareontheinternet.com%' ESCAPE '$' OR "visitor_cookie" LIKE '%medicationsonlinedoctor.com%' ESCAPE '$' OR "visitor_cookie" LIKE '%miracle-pregnancy%' ESCAPE '$' OR "visitor_cookie" LIKE '%mobilecontentstore.mobi%' ESCAPE '$' OR "visitor_cookie" LIKE '%onedollar.mm-project.com%' ESCAPE '$' OR "visitor_cookie" LIKE '%onenetcenter.com%' ESCAPE '$' OR "visitor_cookie" LIKE '%passionoflife.net%' ESCAPE '$' OR "visitor_cookie" LIKE '%qgas.co.uk%' ESCAPE '$'; mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T05:46:13.190919Z. started with: # Time: 2023-05-12T05:46:15.212599Z # User@Host: princephilippa[princephilippa] @ [127.0.0.1] Id: 5236850 # Schema: wp_princephilippa Last_errno: 0 Killed: 0 # Query_time: 5.394506 Lock_time: 0.000143 Rows_sent: 0 Rows_examined: 137717 Rows_affected: 0 Bytes_sent: 211 use wp_princephilippa; SET timestamp=1683870375; SELECT "log","id" FROM "wp_defender_lockout_log" WHERE "log" LIKE '%acheterdufrance%' ESCAPE '$' OR "log" LIKE ' generique%' ESCAPE '$' OR "log" LIKE '%france24%' ESCAPE '$' OR "log" LIKE '%avodart%' ESCAPE '$' OR "log" LIKE '%adalat%' ESCAPE '$' OR "log" LIKE '%personal-loan-centre%' ESCAPE '$' OR "log" LIKE '%quick-loan-lenders-online%' ESCAPE '$' OR "log" LIKE '%WriteMyPaper4Me%' ESCAPE '$' OR "log" LIKE '%dissertation freelance writers%' ESCAPE '$' OR "log" LIKE '%hangbag%' ESCAPE '$' OR "log" LIKE '%rolex%' ESCAPE '$' OR "log" LIKE '%>prada outlet%' ESCAPE '$' OR "log" LIKE '%ruqbnsmokebbq.ga%' ESCAPE '$' OR "log" LIKE '%\">les prostitu%' ESCAPE '$' OR "log" LIKE '%\">rencontre femme%' ESCAPE '$' OR "log" LIKE '%>free dating sites%' ESCAPE '$' OR "log" LIKE '%***** ray ban%' ESCAPE '$' OR "log" LIKE '%buy aciphex%' ESCAPE '$' OR "log" LIKE '%buy tramadol%' ESCAPE '$' OR "log" LIKE '%buy lexapro%' ESCAPE '$'\G # Query 5: 0.00 QPS, 0.02x concurrency, ID 0x67A347A2812914DF at byte 10222 # Scores: V/M = 0.45 # Time range: 2023-05-12T02:18:53 to 2023-05-12T02:30:58 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 2 # Exec time 2 12s 5s 7s 6s 7s 2s 6s # Lock time 0 63us 30us 33us 31us 33us 2us 31us # Rows sent 8 334.40k 130.78k 203.62k 167.20k 203.62k 51.50k 167.20k # Rows examine 1 334.40k 130.78k 203.62k 167.20k 203.62k 51.50k 167.20k # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 63 69.44M 26.71M 42.73M 34.72M 42.73M 11.33M 34.72M # Query size 11 9.18k 3.63k 5.55k 4.59k 5.55k 1.35k 4.59k # String: # Databases wp_bournee... (1/50%), wp_mccarth... (1/50%) # Hosts 10.224.53.179 # Last errno 0 # Users _wpe_root # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `wp_mccarthyholden` LIKE 'wp_postmeta'\G # SHOW CREATE TABLE `wp_mccarthyholden`.`wp_postmeta`\G # SHOW TABLE STATUS FROM `wp_mccarthyholden` LIKE 'wp_comments'\G # SHOW CREATE TABLE `wp_mccarthyholden`.`wp_comments`\G SELECT /*!40001 SQL_NO_CACHE */ * FROM `wp_postmeta`; mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:32:17.573364Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:32:28.567021Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:32:43.979849Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:33:15.433260Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:33:42.557148Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:34:04.365496Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:34:26.133507Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:34:50.528531Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:35:04.751075Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:35:20.293794Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:35:29.891147Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:35:55.106836Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:36:12.124471Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:36:32.439927Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:36:46.299222Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:37:19.499115Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:37:28.385353Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:37:41.314460Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T04:37:19.658269Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T04:52:20.947270Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T04:53:40.334090Z. started with: # Time: 2023-05-12T05:07:59.332759Z # User@Host: lakinandstg[lakinandstg] @ [127.0.0.1] Id: 5229344 # Schema: wp_lakinandstg Last_errno: 0 Killed: 0 # Query_time: 6.457983 Lock_time: 0.000118 Rows_sent: 1 Rows_examined: 1025418 Rows_affected: 0 Bytes_sent: 163 use wp_lakinandstg; SET timestamp=1683868079; SELECT comment_approved, COUNT( * ) AS num_comments FROM wp_comments WHERE comment_type != 'propertyhive_note' GROUP BY comment_approved /* From [lakinandstg.wpengine.com/wp-admin/admin.php?page=wpengine-common&tab=caching&_wpnonce=d19531606f¬ification=success] in [/nas/content/live/lakinandstg/wp-content/plugins/propertyhive/includes/class-ph-comments.php:456] */\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ SELECT /*!40001 SQL_NO_CACHE */ * FROM `wp_postmeta`; mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:32:17.573364Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:32:28.567021Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:32:43.979849Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:33:15.433260Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:33:42.557148Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:34:04.365496Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:34:26.133507Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:34:50.528531Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:35:04.751075Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:35:20.293794Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:35:29.891147Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:35:55.106836Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:36:12.124471Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:36:32.439927Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:36:46.299222Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:37:19.499115Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:37:28.385353Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T02:37:41.314460Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T04:37:19.658269Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T04:52:20.947270Z. started with: mysqld, Version: 5.7.41-44-log (Percona Server (GPL), Release '44', Revision '27f408641db'), Time: 2023-05-12T04:53:40.334090Z. started with: # Time: 2023-05-12T05:07:59.332759Z # User@Host: lakinandstg[lakinandstg] @ [127.0.0.1] Id: 5229344 # Schema: wp_lakinandstg Last_errno: 0 Killed: 0 # Query_time: 6.457983 Lock_time: 0.000118 Rows_sent: 1 Rows_examined: 1025418 Rows_affected: 0 Bytes_sent: 163 use wp_lakinandstg; SET timestamp=1683868079; SELECT comment_approved, COUNT( * ) AS num_comments FROM wp_comments WHERE comment_type != 'propertyhive_note' GROUP BY comment_approved /* From [lakinandstg.wpengine.com/wp-admin/admin.php?page=wpengine-common&tab=caching&_wpnonce=d19531606f¬ification=success] in [/nas/content/live/lakinandstg/wp-content/plugins/propertyhive/includes/class-ph-comments.php:456] */\G # Query 6: 0 QPS, 0x concurrency, ID 0xA4BAC72C93866059 at byte 104004 ___ # Scores: V/M = 0.00 # Time range: all events occurred at 2023-05-12T09:23:40 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 10s 10s 10s 10s 10s 0 10s # Lock time 1 150us 150us 150us 150us 150us 0 150us # Rows sent 91 3.39M 3.39M 3.39M 3.39M 3.39M 0 3.39M # Rows examine 13 3.39M 3.39M 3.39M 3.39M 3.39M 0 3.39M # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 36 39.69M 39.69M 39.69M 39.69M 39.69M 0 39.69M # Query size 0 405 405 405 405 405 0 405 # String: # Databases wp_mccarthyholden # Hosts 127.0.0.1 # Last errno 0 # Users mccarthyholden # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms # 1s ################################################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `wp_mccarthyholden` LIKE 'wp_comments'\G # SHOW CREATE TABLE `wp_mccarthyholden`.`wp_comments`\G # EXPLAIN /*!50100 PARTITIONS*/ select comment_ID from wp_comments where comment_approved=1 and not comment_type = 'order_note' /* From [www.mccarthyholden.co.uk/wp-admin/admin-ajax.php?action=wordfence_doScan&isFork=1&scanMode=custom&cronKey=172a145d0e13820bff790c3e9e97b880&signature=2648e887d87d6c28877eee192f51c120e81b226f76270c418ad65662e025e26e] in [/nas/content/live/mccarthyholden/wp-content/plugins/wordfence/lib/wfDB.php:99]