# 11.6s user time, 120ms system time, 32.62M rss, 175.04M vsz
# Current date: Thu Nov 14 19:39:15 2013
# Files: /var/lib/mysql/mysql-slow.log
# Overall: 2.78k total, 269 unique, 0.01 QPS, 0.00x concurrency __________
# Time range: 2013-11-10 18:49:02 to 2013-11-14 19:38:21
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 1031s 100ms 102s 370ms 857ms 2s 180ms
# Lock time 16s 0 3s 6ms 799us 81ms 194us
# Rows sent 54.84k 0 765 20.18 38.53 89.79 0
# Rows examine 6.98M 0 164.42k 2.57k 21.38k 7.64k 2.90
# Query size 2.37M 25 15.04k 893.34 3.52k 1.25k 202.40
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============== ===== ======= ===== =============
# 1 0xE6F05D29E7F679E6 155.2529 15.1% 11 14.1139 55.83 SELECT information_schema.TABLES
# 2 0x2CE3D349814704A5 143.7938 13.9% 307 0.4684 0.40 INSERT maillog
# 3 0xAFC0DD278228530A 59.5739 5.8% 246 0.2422 0.16 REPLACE SELECT cscart_stored_sessions cscart_sessions
# 4 0x1543E6DFC49E1EF0 49.1282 4.8% 66 0.7444 0.00 SELECT cscart_product_feature_variants cscart_product_feature_variant_descriptions cscart_product_features_values cscart_product_features cscart_seo_names
# 5 0xD65D7926B1674FD0 41.2148 4.0% 11 3.7468 26.07 SELECT information_schema.TABLES
# 6 0x7194135125B38CDE 35.6636 3.5% 24 1.4860 0.46 SELECT information_schema.tables
# 7 0xF64E6026FD36734A 34.8187 3.4% 127 0.2742 0.46 DELETE cscart_stored_sessions
# 8 0xA818789EF5D1CA62 29.3907 2.9% 116 0.2534 0.05 SELECT nivxq?o?g_bwps_log
# 9 0xAAB1A4BB8262D565 24.7821 2.4% 51 0.4859 0.14 SELECT cscart_orders cscart_order_docs cscart_companies cscart_order_data
# 10 0xE08A720756D8F9A8 21.7203 2.1% 70 0.3103 0.17 SELECT cscart_products cscart_product_prices cscart_product_descriptions cscart_products_categories cscart_categories cscart_product_popularity cscart_seo_names cscart_product_point_prices cscart_product_sales cscart_discussion
# 11 0x0437334A74016DC2 20.1894 2.0% 98 0.2060 0.07 SELECT cscart_stat_sessions
# 12 0x73B82FC190CB664A 18.5491 1.8% 65 0.2854 0.24 SELECT cscart_products cscart_product_descriptions cscart_product_prices cscart_products_categories cscart_categories cscart_seo_names
# 13 0x5E9A5EC84A83CE6F 14.6545 1.4% 58 0.2527 0.11 REPLACE cscart_sessions
# 14 0x4C1676B6F9A1F648 14.2338 1.4% 48 0.2965 0.24 SELECT cscart_stored_sessions
# 15 0xB174B54D7229E515 13.2919 1.3% 36 0.3692 0.15 REPLACE SELECT cscart_stored_sessions cscart_sessions
# 16 0x74451F964DFEF973 12.7197 1.2% 70 0.1817 0.12 SELECT cscart_products cscart_product_descriptions cscart_product_prices cscart_products_categories cscart_categories cscart_also_bought_products cscart_seo_names
# 17 0x47B7279693127726 11.0434 1.1% 26 0.4247 0.13 UPDATE x?hd?z?kb_options
# 18 0xBE0D45B9A02D10F8 9.9459 1.0% 4 2.4865 0.12 SHOW COLUMNS
# 19 0x54158123C19799B3 9.8871 1.0% 35 0.2825 0.18 SELECT cscart_bm_snapping cscart_bm_blocks cscart_bm_block_statuses cscart_bm_blocks_descriptions cscart_bm_blocks_content
# 20 0xF5CD90AE42F5F8CD 8.9065 0.9% 3 2.9688 4.61 SELECT cscart_product_subscriptions
# MISC 0xMISC 302.0432 29.3% 1311 0.2304 0.0 <249 ITEMS>
# Query 1: 0.00 QPS, 0.00x concurrency, ID 0xE6F05D29E7F679E6 at byte 1623231
# This item is included in the report because it matches --limit.
# Scores: V/M = 55.83
# Time range: 2013-11-10 18:49:02 to 2013-11-12 21:32:44
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 11
# Exec time 15 155s 549ms 102s 14s 32s 28s 936ms
# Lock time 0 3ms 206us 288us 233us 260us 25us 224us
# Rows sent 0 33 3 3 3 3 0 3
# Rows examine 0 38.17k 3.47k 3.47k 3.47k 3.47k 0 3.47k
# Query size 0 2.05k 191 191 191 191 0 191
# String:
# Databases lotusm_cs2... (7/63%), bling888_w... (2/18%)... 1 more
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #####################
# 10s+ ################################
# Tables
# SHOW TABLE STATUS FROM `information_schema` LIKE 'TABLES'\G
# SHOW CREATE TABLE `information_schema`.`TABLES`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT ENGINE,SUM(DATA_LENGTH),COUNT(ENGINE) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND ENGINE IS NOT NULL GROUP BY ENGINE ORDER BY ENGINE ASC\G
# Query 2: 0.00 QPS, 0.00x concurrency, ID 0x2CE3D349814704A5 at byte 368414
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.40
# Time range: 2013-11-10 19:10:34 to 2013-11-14 19:19:09
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 11 307
# Exec time 13 144s 101ms 2s 468ms 1s 431ms 266ms
# Lock time 0 124ms 265us 681us 403us 515us 79us 366us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 44 1.06M 1.31k 6.38k 3.55k 5.20k 1.08k 3.35k
# String:
# Databases mailscanner
# Hosts localhost
# Users mailwatch
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ############
# 10s+
# Tables
# SHOW TABLE STATUS FROM `mailscanner` LIKE 'maillog'\G
# SHOW CREATE TABLE `mailscanner`.`maillog`\G
INSERT INTO maillog (timestamp, id, size, from_address, from_domain, to_address, to_domain, subject, clientip, archive, isspam, ishighspam, issaspam, isrblspam, spamwhitelisted, spamblacklisted, sascore, spamreport, virusinfected, nameinfected, otherinfected, report, ismcp, ishighmcp, issamcp, mcpwhitelisted, mcpblacklisted, mcpsascore, mcpreport, hostname, date, time, headers, quarantined) VALUES ('2013-11-11 09:44:17','1VfvWt-0005gF-25','10800','[email protected]','newsfounders.biz','[email protected]','lotusmoon.biz',' Franchise guidance and information from industry leaders','173.213.70.20','','1','1','1',NULL,'0','0','8.675','spam, SpamAssassin (not cached, score=8.675, required 5, DKIM_SIGNED 0.10, DKIM_VALID -0.10, DKIM_VALID_AU -0.10, FROM_12LTRDOM 0.10, HTML_MESSAGE 0.00, INVALID_MSGID 1.17, MIME_HTML_ONLY 1.10, RCVD_IN_BRBL_LASTEXT 1.64, RDNS_NONE 1.27, SPF_PASS -0.00, T_REMOTE_IMAGE 0.01, URIBL_BLACK 1.77, URIBL_DBL_SPAM 1.70)','0','0','0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'server.smbessentials.com','2013-11-11','09:44:17','Received: from [173.213.70.20] (port=43101 helo=zha5.newsfounders.biz)\n by server.smbessentials.com with esmtp (Exim 4.80.1)\n (envelope-from <[email protected]>)\n id 1VfvWt-0005gF-25\n for [email][email protected][/email]; Mon, 11 Nov 2013 09:44:09 -0800\nDKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; s=default; d=newsfounders.biz;\n h=To:Subject:Date:From:Message-ID:MIME-Version:Content-Type; [email protected];\n bh=dL2kATMJiMSBC/RaH9FATSDsQIs=;\n b=KLBGvXLhuUEuO+BWNPrQ0kdtFb05yx6jEJl6CfJNKejKUMbOldCxHMvI8FgQ2pcg3eY2dbGy4hJd\n 0hk0O33b5XYNoxdnUgmTaOG0QOvkhs8AAq75WBynHAkDZR8N3KEwREPL8JfkQubzAFN7RDW9S7pj\n KpRIZEhqw7uzD2FAvEo=\nDomainKey-Signature: a=rsa-sha1; c=nofws; q=dns; s=default; d=newsfounders.biz;\n b=pbsUaNkx84k9qizTcQugC54IruD+Fcimw9iWrh+6jx5+gA07tGIL7xpprLDSQJf3Rz4NRdKctMyx\n W7PetEX05V9Ier4tBiMV8kO2Ka6QaEh8WV0DpYmlubpynMYZzWjlKYMguCZhhxd9orl6Rp8V9itO\n rOc7Nhiksc2ccqBy2hM=;\nTo: <[email protected]>\nSubject: Franchise guidance and information from industry leaders\nDate: Mon, 11 Nov 2013 10:17:37 -0700\nFrom: \"Franchise\" <[email protected]>\nMessage-ID: [email][email protected][/email]\nMIME-Version: 1.0\nContent-Type: text/html\nX-Spam-Subject: ***SPAM*** Franchise guidance and information from industry leaders\nX-Spam-Status: Yes, score=8.7\nX-Spam-Score: 87\nX-Spam-Bar: ++++++++\nX-Spam-Report: Spam detection software, running on the system \"server.smbessentials.com\", has\n identified this incoming email as possible spam. The original message\n has been attached to this so you can view it (if it isn\'t spam) or label\n similar future email. If you have any questions, see\n root\\@localhost for details.\n \n Content preview: Franchise New franchise opportunities available Look into\n a frachise investment and you could own your own business. [...] \n \n Content analysis details: (8.7 points, 5.0 required)\n \n pts rule name description\n ---- ---------------------- --------------------------------------------------\n 1.6 RCVD_IN_BRBL_LASTEXT RBL: RCVD_IN_BRBL_LASTEXT\n [173.213.70.20 listed in bb.barracudacentral.org]\n 1.8 URIBL_BLACK Contains an URL listed in the URIBL blacklist\n [URIs: newsfounders.biz]\n -0.0 SPF_PASS SPF: sender matches SPF record\n 1.7 URIBL_DBL_SPAM Contains an URL listed in the DBL blocklist\n [URIs: newsfounders.biz]\n 0.0 HTML_MESSAGE BODY: HTML included in message\n 1.1 MIME_HTML_ONLY BODY: Message only has text/html MIME parts\n -0.1 DKIM_VALID_AU Message has a valid DKIM or DK signature from author\'s\n domain\n -0.1 DKIM_VALID Message has at least one valid DKIM or DK signature\n 0.1 DKIM_SIGNED Message has a DKIM or DK signature, not necessarily valid\n 1.3 RDNS_NONE Delivered to internal network by a host with no rDNS\n 1.2 INVALID_MSGID Message-Id is not valid, according to RFC 2822\n 0.1 FROM_12LTRDOM From a 12-letter domain\n 0.0 T_REMOTE_IMAGE Message contains an external image\nX-Spam-Flag: YES','0')\G
# Query 3: 0.00 QPS, 0.00x concurrency, ID 0xAFC0DD278228530A at byte 886141
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.16
# Time range: 2013-11-10 19:06:25 to 2013-11-14 19:20:59
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 8 246
# Exec time 5 60s 100ms 2s 242ms 640ms 199ms 163ms
# Lock time 8 1s 112us 443ms 6ms 214us 42ms 152us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 2.27k 0 233 9.45 22.53 22.21 4.96
# Query size 0 23.54k 98 98 98 98 0 98
# String:
# Databases lotusm_cs2... (213/86%), plainjan_c... (33/13%)
# Hosts localhost
# Users lotusm_cs3... (213/86%), plainjan_c... (33/13%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_stored_sessions'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_stored_sessions`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_sessions'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_sessions`\G
REPLACE INTO cscart_stored_sessions SELECT * FROM cscart_sessions WHERE 1 AND expiry < 1384223474\G
# Query 4: 0.00 QPS, 0.00x concurrency, ID 0x1543E6DFC49E1EF0 at byte 3016404
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2013-11-13 14:29:13 to 2013-11-14 19:26:44
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 66
# Exec time 4 49s 718ms 831ms 744ms 777ms 28ms 705ms
# Lock time 0 28ms 389us 481us 423us 445us 18us 403us
# Rows sent 4 2.58k 40 40 40 40 0 40
# Rows examine 17 1.19M 18.46k 18.56k 18.51k 18.47k 52 18.47k
# Query size 3 81.69k 1.24k 1.24k 1.24k 1.20k 0 1.20k
# String:
# Databases lotusm_cs2cart
# Hosts localhost
# Users lotusm_cs3admin
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_product_feature_variants'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_product_feature_variants`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_product_feature_variant_descriptions'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_product_feature_variant_descriptions`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_product_features_values'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_product_features_values`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_product_features'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_product_features`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_seo_names'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_seo_names`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT cscart_product_feature_variant_descriptions.*, cscart_product_feature_variants.*, cscart_product_features_values.variant_id as selected, cscart_product_features.feature_type, cscart_seo_names.name as seo_name FROM cscart_product_feature_variants LEFT JOIN cscart_product_feature_variant_descriptions ON cscart_product_feature_variant_descriptions.variant_id = cscart_product_feature_variants.variant_id AND cscart_product_feature_variant_descriptions.lang_code = 'EN' LEFT JOIN cscart_product_features_values ON cscart_product_features_values.variant_id = cscart_product_feature_variants.variant_id AND cscart_product_features_values.lang_code = 'EN' AND cscart_product_features_values.product_id = 342 LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_feature_variants.feature_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_product_feature_variants.variant_id AND cscart_seo_names.type = 'e' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'EN' WHERE 1 AND cscart_product_feature_variants.feature_id IN ('7') GROUP BY cscart_product_feature_variants.variant_id ORDER BY cscart_product_feature_variants.position, cscart_product_feature_variant_descriptions.variant LIMIT 0, 40\G
# Query 5: 0.00 QPS, 0.00x concurrency, ID 0xD65D7926B1674FD0 at byte 1623569
# This item is included in the report because it matches --limit.
# Scores: V/M = 26.07
# Time range: 2013-11-10 18:49:03 to 2013-11-12 21:32:44
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 11
# Exec time 3 41s 513ms 35s 4s 816ms 10s 501ms
# Lock time 0 3ms 196us 325us 231us 236us 31us 214us
# Rows sent 0 11 1 1 1 1 0 1
# Rows examine 0 38.10k 3.46k 3.46k 3.46k 3.46k 0 3.46k
# Query size 0 1.65k 154 154 154 154 0 154
# String:
# Databases lotusm_cs2... (7/63%), bling888_w... (2/18%)... 1 more
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+ ######
# Tables
# SHOW TABLE STATUS FROM `information_schema` LIKE 'TABLES'\G
# SHOW CREATE TABLE `information_schema`.`TABLES`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND Data_free > 0 AND NOT ENGINE='MEMORY'\G
# Query 6: 0.00 QPS, 0.00x concurrency, ID 0x7194135125B38CDE at byte 804139
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.46
# Time range: 2013-11-10 20:30:03 to 2013-11-14 16:30:03
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 24
# Exec time 3 36s 1s 5s 1s 2s 826ms 1s
# Lock time 0 5ms 178us 281us 212us 224us 22us 204us
# Rows sent 1 792 33 33 33 33 0 33
# Rows examine 1 86.30k 3.60k 3.60k 3.60k 3.60k 0 3.60k
# Query size 0 2.95k 126 126 126 126 0 126
# String:
# Databases mysql
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `information_schema` LIKE 'tables'\G
# SHOW CREATE TABLE `information_schema`.`tables`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA\G
# Query 7: 0.00 QPS, 0.00x concurrency, ID 0xF64E6026FD36734A at byte 2491855
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.46
# Time range: 2013-11-10 19:06:25 to 2013-11-14 19:38:21
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 4 127
# Exec time 3 35s 101ms 4s 274ms 580ms 355ms 171ms
# Lock time 1 207ms 83us 191ms 2ms 176us 17ms 113us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 1.31k 0 615 10.54 21.45 52.59 1.96
# Query size 0 7.44k 60 60 60 60 0 60
# String:
# Databases lotusm_cs2... (119/93%), plainjan_c... (6/4%)... 2 more
# Hosts localhost
# Users lotusm_cs3... (119/93%), plainjan_c... (6/4%)... 2 more
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_stored_sessions'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_stored_sessions`\G
DELETE FROM cscart_stored_sessions WHERE expiry < 1383214238\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select * from cscart_stored_sessions WHERE expiry < 1383214238\G
# Query 8: 0.00 QPS, 0.00x concurrency, ID 0xA818789EF5D1CA62 at byte 2691747
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.05
# Time range: 2013-11-10 19:10:03 to 2013-11-14 19:10:24
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 4 116
# Exec time 2 29s 164ms 844ms 253ms 433ms 107ms 219ms
# Lock time 0 20ms 142us 378us 171us 204us 25us 159us
# Rows sent 0 116 1 1 1 1 0 1
# Rows examine 36 2.56M 22.43k 22.72k 22.59k 22.45k 146.50 22.45k
# Query size 0 11.93k 103 108 105.29 102.22 0.93 102.22
# String:
# Databases eco888_wpdb
# Hosts localhost
# Users eco888_wpusr
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `eco888_wpdb` LIKE 'nivxq1o0g_bwps_log'\G
# SHOW CREATE TABLE `eco888_wpdb`.`nivxq1o0g_bwps_log`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM `nivxq1o0g_bwps_log` WHERE type=2 AND host='146.0.73.155' AND timestamp > 1384424306\G
# Query 9: 0.00 QPS, 0.00x concurrency, ID 0xAAB1A4BB8262D565 at byte 1966970
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.14
# Time range: 2013-11-11 09:04:22 to 2013-11-14 15:02:15
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 51
# Exec time 2 25s 330ms 1s 486ms 1s 261ms 339ms
# Lock time 0 21ms 374us 439us 410us 424us 16us 403us
# Rows sent 1 612 12 12 12 12 0 12
# Rows examine 6 499.93k 9.79k 9.83k 9.80k 9.80k 20 9.80k
# Query size 2 52.46k 1.03k 1.03k 1.03k 1012.63 0 1012.63
# String:
# Databases lotusm_cs2cart
# Hosts localhost
# Users lotusm_cs3admin
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ########
# 10s+
# Tables
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_orders'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_orders`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_order_docs'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_order_docs`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_companies'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_companies`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_order_data'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_order_data`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT distinct cscart_orders.order_id, cscart_orders.user_id, cscart_orders.is_parent_order, cscart_orders.parent_order_id, cscart_orders.company_id, cscart_orders.timestamp, cscart_orders.firstname, cscart_orders.lastname, cscart_orders.email, cscart_orders.status, cscart_orders.total, invoice_docs.doc_id as invoice_id, memo_docs.doc_id as credit_memo_id, cscart_companies.company as company_name, cscart_order_data.data as points FROM cscart_orders LEFT JOIN cscart_order_docs as invoice_docs ON invoice_docs.order_id = cscart_orders.order_id AND invoice_docs.type = 'I' LEFT JOIN cscart_order_docs as memo_docs ON memo_docs.order_id = cscart_orders.order_id AND memo_docs.type = 'C' LEFT JOIN cscart_companies ON cscart_companies.company_id = cscart_orders.company_id LEFT JOIN cscart_order_data ON cscart_order_data.order_id = cscart_orders.order_id AND cscart_order_data.type = 'W' WHERE 1 AND cscart_orders.is_parent_order != 'Y' AND cscart_orders.status != 'N' ORDER BY cscart_orders.timestamp desc, cscart_orders.order_id desc LIMIT 0, 12\G
# Query 10: 0.00 QPS, 0.00x concurrency, ID 0xE08A720756D8F9A8 at byte 832775
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.17
# Time range: 2013-11-10 19:49:55 to 2013-11-14 19:01:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 70
# Exec time 2 22s 102ms 1s 310ms 672ms 229ms 219ms
# Lock time 6 1s 749us 627ms 15ms 14ms 77ms 799us
# Rows sent 0 70 1 1 1 1 0 1
# Rows examine 0 1.79k 6 68 26.23 44.60 14.01 19.46
# Query size 6 165.24k 2.36k 2.36k 2.36k 2.27k 0 2.27k
# String:
# Databases lotusm_cs2... (47/67%), plainjan_c... (23/32%)
# Hosts localhost
# Users lotusm_cs3... (47/67%), plainjan_c... (23/32%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_products'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_products`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_product_prices'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_product_prices`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_product_descriptions'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_product_descriptions`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_products_categories'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_products_categories`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_categories'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_categories`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_product_popularity'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_product_popularity`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_seo_names'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_seo_names`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_product_point_prices'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_product_point_prices`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_product_sales'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_product_sales`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_discussion'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_discussion`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT cscart_products.*, cscart_product_descriptions.*, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price, GROUP_CONCAT(IF(cscart_products_categories.link_type = 'M', CONCAT(cscart_products_categories.category_id, 'M'), cscart_products_categories.category_id)) as category_ids, popularity.total as popularity, cscart_seo_names.name as seo_name, MIN(point_prices.point_price) as point_price, cscart_product_sales.amount as sales_amount, cscart_discussion.type as discussion_type FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id AND cscart_product_descriptions.lang_code = 'EN' INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND (cscart_products.usergroup_ids = '' OR FIND_IN_SET(0, cscart_products.usergroup_ids) OR FIND_IN_SET(1, cscart_products.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_products.status IN ('A', 'H') LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = cscart_products.product_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 260 AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'EN' LEFT JOIN cscart_product_point_prices as point_prices ON point_prices.product_id = cscart_products.product_id AND point_prices.lower_limit = 1 AND point_prices.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = cscart_products.product_id AND cscart_product_sales.category_id = 67 LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_products.product_id AND cscart_discussion.object_type = 'P' WHERE cscart_products.product_id = 260 AND cscart_products.company_id = 0 GROUP BY cscart_products.product_id\G
# Query 11: 0.00 QPS, 0.00x concurrency, ID 0x0437334A74016DC2 at byte 2186408
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.07
# Time range: 2013-11-10 18:52:29 to 2013-11-14 18:44:50
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 3 98
# Exec time 1 20s 100ms 725ms 206ms 477ms 120ms 163ms
# Lock time 0 19ms 111us 340us 190us 236us 35us 176us
# Rows sent 0 6 0 1 0.06 0.99 0.24 0
# Rows examine 0 12 0 2 0.12 1.96 0.47 0
# Query size 0 14.07k 147 147 147 147 0 147
# String:
# Databases lotusm_cs2... (81/82%), plainjan_c... (17/17%)
# Hosts localhost
# Users lotusm_cs3... (81/82%), plainjan_c... (17/17%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_stat_sessions'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_stat_sessions`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT sess_id FROM cscart_stat_sessions WHERE session = 'b258e1d9f077977abfab428973a8bd28' AND expiry > 1384373907 ORDER BY timestamp DESC LIMIT 1\G
# Query 12: 0.00 QPS, 0.00x concurrency, ID 0x73B82FC190CB664A at byte 447026
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.24
# Time range: 2013-11-10 23:42:08 to 2013-11-14 15:40:12
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 65
# Exec time 1 19s 101ms 1s 285ms 640ms 260ms 148ms
# Lock time 4 690ms 0 256ms 11ms 2ms 45ms 626us
# Rows sent 0 545 0 31 8.38 23.65 6.22 6.98
# Rows examine 0 5.28k 0 288 83.23 212.52 67.34 62.76
# Query size 4 109.07k 1.68k 1.68k 1.68k 1.61k 0 1.61k
# String:
# Databases lotusm_cs2... (49/75%), plainjan_c... (16/24%)
# Hosts localhost
# Users lotusm_cs3... (49/75%), plainjan_c... (16/24%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ####
# 10s+
# Tables
# SHOW TABLE STATUS FROM `plainjan_cscart1db` LIKE 'cscart_products'\G
# SHOW CREATE TABLE `plainjan_cscart1db`.`cscart_products`\G
# SHOW TABLE STATUS FROM `plainjan_cscart1db` LIKE 'cscart_product_descriptions'\G
# SHOW CREATE TABLE `plainjan_cscart1db`.`cscart_product_descriptions`\G
# SHOW TABLE STATUS FROM `plainjan_cscart1db` LIKE 'cscart_product_prices'\G
# SHOW CREATE TABLE `plainjan_cscart1db`.`cscart_product_prices`\G
# SHOW TABLE STATUS FROM `plainjan_cscart1db` LIKE 'cscart_products_categories'\G
# SHOW CREATE TABLE `plainjan_cscart1db`.`cscart_products_categories`\G
# SHOW TABLE STATUS FROM `plainjan_cscart1db` LIKE 'cscart_categories'\G
# SHOW CREATE TABLE `plainjan_cscart1db`.`cscart_categories`\G
# SHOW TABLE STATUS FROM `plainjan_cscart1db` LIKE 'cscart_seo_names'\G
# SHOW CREATE TABLE `plainjan_cscart1db`.`cscart_seo_names`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT SQL_CALC_FOUND_ROWS products.*, descr1.product as product, MIN(IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100)) as price, descr1.short_description, IF(descr1.short_description = '', descr1.full_description, '') as full_description, GROUP_CONCAT(IF(products_categories.link_type = 'M', CONCAT(products_categories.category_id, 'M'), products_categories.category_id)) as category_ids, products_categories.position, cscart_seo_names.name as seo_name FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'EN' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = products.product_id AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'EN' WHERE 1 AND cscart_categories.category_id IN (36) AND products.company_id = 0 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id ORDER BY products_categories.position asc LIMIT 0, 96\G
# Query 13: 0.00 QPS, 0.00x concurrency, ID 0x5E9A5EC84A83CE6F at byte 2765203
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.11
# Time range: 2013-11-10 19:23:55 to 2013-11-14 13:19:13
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 58
# Exec time 1 15s 101ms 958ms 253ms 501ms 163ms 189ms
# Lock time 2 442ms 170us 267ms 8ms 3ms 38ms 236us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 4 108.75k 854 12.31k 1.88k 4.07k 1.67k 1.26k
# String:
# Databases lotusm_cs2... (47/81%), plainjan_c... (11/18%)
# Hosts localhost
# Users lotusm_cs3... (47/81%), plainjan_c... (11/18%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_sessions'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_sessions`\G
REPLACE INTO cscart_sessions (`session_id`, `area`, `expiry`, `data`) VALUES ('67be3351f2a29d09dda28025738ee580', 'C', '1384471151', '_validator_data|a:1:{s:2:\"ua\";s:188:\"User-Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET CLR 1.1.4322; .NET4.0C; .NET4.0E)\";}settings|a:2:{s:14:\"cart_languageC\";a:2:{s:5:\"value\";s:2:\"EN\";s:6:\"expiry\";i:1385068632;}s:19:\"secondary_currencyC\";a:2:{s:5:\"value\";s:3:\"USD\";s:6:\"expiry\";i:1385068632;}}auth|a:13:{s:4:\"area\";s:1:\"C\";s:7:\"user_id\";i:0;s:9:\"user_type\";s:1:\"C\";s:10:\"tax_exempt\";s:1:\"N\";s:10:\"last_login\";i:0;s:13:\"usergroup_ids\";a:2:{i:0;i:0;i:1;i:1;}s:9:\"order_ids\";a:0:{}s:11:\"act_as_user\";b:0;s:10:\"this_login\";i:1384463832;s:25:\"password_change_timestamp\";i:0;s:10:\"company_id\";i:0;s:7:\"is_root\";s:1:\"N\";s:7:\"referer\";s:88:\"http://www.prweb.com/releases/anti-aging-lactic-acid/toner-lotus-moon/prweb11332884.htm/\";}cart|a:4:{s:8:\"products\";a:0:{}s:11:\"recalculate\";b:0;s:9:\"user_data\";a:0:{}s:11:\"points_info\";a:1:{s:6:\"reward\";i:0;}}device|s:0:\"\";twg_user_agent|s:7:\"unknown\";twg_ua|s:188:\"User-Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET CLR 1.1.4322; .NET4.0C; .NET4.0E)\";cache_mobile_frontend|s:1:\"N\";')\G
# Query 14: 0.00 QPS, 0.00x concurrency, ID 0x4C1676B6F9A1F648 at byte 708687
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.24
# Time range: 2013-11-10 18:49:18 to 2013-11-14 12:38:01
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 48
# Exec time 1 14s 102ms 2s 297ms 526ms 265ms 219ms
# Lock time 1 248ms 111us 121ms 5ms 236us 23ms 152us
# Rows sent 0 14 0 1 0.29 0.99 0.45 0
# Rows examine 0 14 0 1 0.29 0.99 0.45 0
# Query size 0 5.39k 115 115 115 115 0 115
# String:
# Databases lotusm_cs2... (43/89%), plainjan_c... (5/10%)
# Hosts localhost
# Users lotusm_cs3... (43/89%), plainjan_c... (5/10%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `plainjan_cscart1db` LIKE 'cscart_stored_sessions'\G
# SHOW CREATE TABLE `plainjan_cscart1db`.`cscart_stored_sessions`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT data FROM cscart_stored_sessions WHERE 1 AND session_id = '59c2b42f95b24d2b0eada4b55706d785' AND area = 'C'\G
# Query 15: 0.00 QPS, 0.00x concurrency, ID 0xB174B54D7229E515 at byte 2684383
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.15
# Time range: 2013-11-10 19:34:57 to 2013-11-14 19:16:09
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 36
# Exec time 1 13s 104ms 1s 369ms 900ms 233ms 279ms
# Lock time 0 6ms 140us 222us 169us 204us 18us 159us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 5 359.22k 27 10.80k 9.98k 10.29k 2.35k 10.29k
# Query size 0 4.11k 117 117 117 117 0 117
# String:
# Databases detoxrx_CS... (34/94%), son888_CSU... (2/5%)
# Hosts localhost
# Users detoxrx_cs... (34/94%), son888_csu... (2/5%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `detoxrx_CSE1` LIKE 'cscart_stored_sessions'\G
# SHOW CREATE TABLE `detoxrx_CSE1`.`cscart_stored_sessions`\G
# SHOW TABLE STATUS FROM `detoxrx_CSE1` LIKE 'cscart_sessions'\G
# SHOW CREATE TABLE `detoxrx_CSE1`.`cscart_sessions`\G
REPLACE INTO cscart_stored_sessions SELECT * FROM cscart_sessions WHERE 1 AND expiry < 1384452846 AND company_id = 0\G
# Query 16: 0.00 QPS, 0.00x concurrency, ID 0x74451F964DFEF973 at byte 790618
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.12
# Time range: 2013-11-10 19:02:30 to 2013-11-14 18:39:02
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 70
# Exec time 1 13s 102ms 1s 182ms 356ms 150ms 141ms
# Lock time 0 69ms 647us 19ms 984us 1ms 2ms 657us
# Rows sent 0 280 4 4 4 4 0 4
# Rows examine 1 74.60k 325 1.57k 1.07k 1.46k 333.47 1.09k
# Query size 5 121.88k 1.74k 1.74k 1.74k 1.74k 0 1.74k
# String:
# Databases lotusm_cs2cart
# Hosts localhost
# Users lotusm_cs3admin
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_products'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_products`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_product_descriptions'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_product_descriptions`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_product_prices'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_product_prices`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_products_categories'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_products_categories`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_categories'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_categories`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_also_bought_products'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_also_bought_products`\G
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_seo_names'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_seo_names`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT SQL_CALC_FOUND_ROWS products.*, descr1.product as product, MIN(IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100)) as price, GROUP_CONCAT(IF(products_categories.link_type = 'M', CONCAT(products_categories.category_id, 'M'), products_categories.category_id)) as category_ids, products_categories.position, SUM(cscart_also_bought_products.amount) amnt, cscart_seo_names.name as seo_name FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'EN' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') LEFT JOIN cscart_also_bought_products ON cscart_also_bought_products.related_id = products.product_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = products.product_id AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'EN' WHERE 1 AND products.company_id = 0 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND cscart_also_bought_products.product_id = 246 GROUP BY cscart_also_bought_products.related_id ORDER BY products_categories.position asc LIMIT 0, 4\G
# Query 17: 0.00 QPS, 0.00x concurrency, ID 0x47B7279693127726 at byte 1812100
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.13
# Time range: 2013-11-13 01:32:12 to 05:15:29
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 26
# Exec time 1 11s 123ms 1s 425ms 609ms 234ms 412ms
# Lock time 0 5ms 148us 338us 209us 301us 53us 185us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 26 1 1 1 1 0 1
# Query size 1 28.09k 162 1.65k 1.08k 1.61k 390.19 1.14k
# String:
# Databases bling888_wpblog
# Hosts localhost
# Users bling888_wpadmin
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ##
# 10s+
# Tables
# SHOW TABLE STATUS FROM `bling888_wpblog` LIKE 'x9hd5z90kb_options'\G
# SHOW CREATE TABLE `bling888_wpblog`.`x9hd5z90kb_options`\G
UPDATE `x9hd5z90kb_options` SET `option_value` = 'O:8:\"stdClass\":3:{s:12:\"last_checked\";i:1384339252;s:8:\"response\";a:2:{s:45:\"bulletproof-security/bulletproof-security.php\";O:8:\"stdClass\":6:{s:2:\"id\";s:5:\"14569\";s:4:\"slug\";s:20:\"bulletproof-security\";s:11:\"new_version\";s:5:\".49.6\";s:14:\"upgrade_notice\";s:300:\"Bonus Code Dismiss Notice Added: Author ID / User ID / Username BOT Probe Protection Code: \nProtects against hacker Bot Probes looking for WordPress author enumeration (a numbered list of Author ID's / User ID's) to exploit. \nGenerates a standard WordPress 404 Error instead of displaying A\";s:3:\"url\";s:51:\"https://wordpress.org/plugins/bulletproof-security/\";s:7:\"package\";s:70:\"https://downloads.wordpress.org/plugin/bulletproof-security.0.49.6.zip\";}s:67:\"social-networks-auto-poster-facebook-twitter-g/NextScripts_SNAP.php\";O:8:\"stdClass\":5:{s:2:\"id\";s:5:\"29712\";s:4:\"slug\";s:46:\"social-networks-auto-poster-facebook-twitter-g\";s:11:\"new_version\";s:5:\"3.0.7\";s:3:\"url\";s:77:\"https://wordpress.org/plugins/social-networks-auto-poster-facebook-twitter-g/\";s:7:\"package\";s:89:\"https://downloads.wordpress.org/plugin/social-networks-auto-poster-facebook-twitter-g.zip\";}}s:12:\"translations\";a:0:{}}' WHERE `option_name` = '_site_transient_update_plugins'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `option_value` = 'O:8:\"stdClass\":3:{s:12:\"last_checked\";i:1384339252;s:8:\"response\";a:2:{s:45:\"bulletproof-security/bulletproof-security.php\";O:8:\"stdClass\":6:{s:2:\"id\";s:5:\"14569\";s:4:\"slug\";s:20:\"bulletproof-security\";s:11:\"new_version\";s:5:\".49.6\";s:14:\"upgrade_notice\";s:300:\"Bonus Code Dismiss Notice Added: Author ID / User ID / Username BOT Probe Protection Code: \nProtects against hacker Bot Probes looking for WordPress author enumeration (a numbered list of Author ID's / User ID's) to exploit. \nGenerates a standard WordPress 404 Error instead of displaying A\";s:3:\"url\";s:51:\"https://wordpress.org/plugins/bulletproof-security/\";s:7:\"package\";s:70:\"https://downloads.wordpress.org/plugin/bulletproof-security.0.49.6.zip\";}s:67:\"social-networks-auto-poster-facebook-twitter-g/NextScripts_SNAP.php\";O:8:\"stdClass\":5:{s:2:\"id\";s:5:\"29712\";s:4:\"slug\";s:46:\"social-networks-auto-poster-facebook-twitter-g\";s:11:\"new_version\";s:5:\"3.0.7\";s:3:\"url\";s:77:\"https://wordpress.org/plugins/social-networks-auto-poster-facebook-twitter-g/\";s:7:\"package\";s:89:\"https://downloads.wordpress.org/plugin/social-networks-auto-poster-facebook-twitter-g.zip\";}}s:12:\"translations\";a:0:{}}' from `x9hd5z90kb_options` where `option_name` = '_site_transient_update_plugins'\G
# Query 18: 0 QPS, 0x concurrency, ID 0xBE0D45B9A02D10F8 at byte 748164 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.12
# Time range: all events occurred at 2013-11-11 16:19:53
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 4
# Exec time 0 10s 2s 3s 2s 3s 542ms 3s
# Lock time 47 8s 1s 3s 2s 3s 512ms 2s
# Rows sent 0 16 4 4 4 4 0 4
# Rows examine 0 16 4 4 4 4 0 4
# Query size 0 132 33 33 33 33 0 33
# String:
# Databases lotusm_cs2cart
# Hosts localhost
# Users lotusm_cs3admin
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `lotusm_cs2cart` LIKE 'cscart_sessions'\G
# SHOW CREATE TABLE `lotusm_cs2cart`.`cscart_sessions`\G
SHOW COLUMNS FROM cscart_sessions\G
# Query 19: 0.00 QPS, 0.00x concurrency, ID 0x54158123C19799B3 at byte 556322
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.18
# Time range: 2013-11-10 19:49:48 to 2013-11-14 19:01:41
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 35
# Exec time 0 10s 103ms 994ms 282ms 740ms 223ms 180ms
# Lock time 4 744ms 0 618ms 21ms 34ms 102ms 515us
# Rows sent 1 851 0 31 24.31 30.19 6.97 23.65
# Rows examine 0 9.69k 0 388 283.46 381.65 104.97 258.32
# Query size 2 50.25k 1.40k 1.45k 1.44k 1.39k 0 1.39k
# String:
# Databases lotusm_cs2... (26/74%), plainjan_c... (9/25%)
# Hosts localhost
# Users lotusm_cs3... (26/74%), plainjan_c... (9/25%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `plainjan_cscart1db` LIKE 'cscart_bm_snapping'\G
# SHOW CREATE TABLE `plainjan_cscart1db`.`cscart_bm_snapping`\G
# SHOW TABLE STATUS FROM `plainjan_cscart1db` LIKE 'cscart_bm_blocks'\G
# SHOW CREATE TABLE `plainjan_cscart1db`.`cscart_bm_blocks`\G
# SHOW TABLE STATUS FROM `plainjan_cscart1db` LIKE 'cscart_bm_block_statuses'\G
# SHOW CREATE TABLE `plainjan_cscart1db`.`cscart_bm_block_statuses`\G
# SHOW TABLE STATUS FROM `plainjan_cscart1db` LIKE 'cscart_bm_blocks_descriptions'\G
# SHOW CREATE TABLE `plainjan_cscart1db`.`cscart_bm_blocks_descriptions`\G
# SHOW TABLE STATUS FROM `plainjan_cscart1db` LIKE 'cscart_bm_blocks_content'\G
# SHOW CREATE TABLE `plainjan_cscart1db`.`cscart_bm_blocks_content`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE 'products' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 24 AND dynamic_object_content.object_type like 'products' WHERE cscart_bm_snapping.grid_id IN (5, 34, 97, 98, 42, 43, 44, 45, 52, 53, 62, 65) AND cscart_bm_blocks_descriptions.lang_code='EN' ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id\G
# Query 20: 0.00 QPS, 0.00x concurrency, ID 0xF5CD90AE42F5F8CD at byte 716008
# This item is included in the report because it matches --limit.
# Scores: V/M = 4.61
# Time range: 2013-11-11 16:19:01 to 2013-11-12 02:14:47
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 3
# Exec time 0 9s 176ms 8s 3s 8s 4s 308ms
# Lock time 0 584us 151us 232us 194us 224us 32us 194us
# Rows sent 0 5 0 5 1.67 4.96 2.34 0
# Rows examine 0 5 0 5 1.67 4.96 2.34 0
# Query size 0 284 94 95 94.67 92.72 0 92.72
# String:
# Databases lotusm_cs2... (2/66%), plainjan_c... (1/33%)
# Hosts localhost
# Users lotusm_cs3... (2/66%), plainjan_c... (1/33%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `plainjan_cscart1db` LIKE 'cscart_product_subscriptions'\G
# SHOW CREATE TABLE `plainjan_cscart1db`.`cscart_product_subscriptions`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT subscription_id FROM cscart_product_subscriptions WHERE product_id = 20 AND user_id = 0\G
