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]