# 4.8s user time, 960ms system time, 32.46M rss, 103.33M vsz
# Current date: Thu Feb  3 11:23:09 2022
# Hostname: logstorage.beget.ru
# Files: /dev/fd/63
# Overall: 390 total, 4 unique, 0.01 QPS, 0.15x concurrency ______________
# Time range: 2022-02-02T21:01:14 to 2022-02-03T08:22:37
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time          5953s      2s     38s     15s     33s     14s      3s
# Lock time           92ms    62us     5ms   234us   403us   288us   176us
# Rows sent         23.40k       0     374   61.43  363.48   88.50   69.19
# Rows examine      14.25M  25.16k  50.56k  37.40k  49.01k  11.48k  25.99k
# Rows affecte           0       0       0       0       0       0       0
# Bytes sent         2.08M     169  32.11k   5.47k  31.59k   7.65k   6.31k
# Query size       446.65k     130   1.29k   1.15k   1.14k   80.88   1.09k

# Profile
# Rank Query ID           Response time   Calls R/Call  V/M   Item
# ==== ================== =============== ===== ======= ===== ============
#    1 0x65A17A8DDE28DFBC 5420.3095 91.1%   180 30.1128  0.22 SELECT u?ija_virtuemart_products u?ija_virtuemart_products_ru_ru u?ija_virtuemart_product_shoppergroups u?ija_virtuemart_product_categories u?ija_virtuemart_product_prices
#    2 0xEA98833A51228680  452.9735  7.6%   180  2.5165  0.05 SELECT u?ija_virtuemart_products u?ija_virtuemart_products_ru_ru u?ija_virtuemart_product_shoppergroups u?ija_virtuemart_product_categories u?ija_virtuemart_product_prices
#    3 0x8942942EDAB23BBF   71.8046  1.2%    28  2.5644  0.06 SELECT u?ija_virtuemart_products u?ija_virtuemart_products_ru_ru u?ija_virtuemart_product_shoppergroups u?ija_virtuemart_product_categories u?ija_virtuemart_product_prices
# MISC 0xMISC                7.5725  0.1%     2  3.7863   0.0 <1 ITEMS>

# Query 1: 0.00 QPS, 0.13x concurrency, ID 0x65A17A8DDE28DFBC at byte 5220428
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.22
# Time range: 2022-02-02T21:01:45 to 2022-02-03T08:22:37
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         46     180
# Exec time     91   5420s     27s     38s     30s     35s      3s     29s
# Lock time     44    41ms   148us     5ms   228us   247us   338us   176us
# Rows sent      3     900       5       5       5       5       0       5
# Rows examine  62   8.87M  50.33k  50.56k  50.48k  49.01k       0  49.01k
# Rows affecte   0       0       0       0       0       0       0       0
# Bytes sent     5 116.47k     523     836  662.61  755.64   56.87  652.75
# Query size    47 213.01k   1.18k   1.29k   1.18k   1.14k   12.59   1.14k
# String:
# Databases    mnb1356_main
# Hosts        localhost
# Last errno   0
# Users        mnb1356_main
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms
#    1s
#  10s+  ################################################################
# Tables
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_products'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_products`\G
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_products_ru_ru'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_products_ru_ru`\G
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_product_shoppergroups'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_product_shoppergroups`\G
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_product_categories'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_product_categories`\G
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_product_prices'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_product_prices`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT  p.`virtuemart_product_id`, l.product_name 
		FROM `u9ija_virtuemart_products` as p   
LEFT JOIN `u9ija_virtuemart_products_ru_ru` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
LEFT JOIN `u9ija_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
LEFT JOIN `u9ija_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
LEFT JOIN `u9ija_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` 
WHERE ( p.`product_in_stock` - p.`product_ordered` >"0"  AND  ((p.`product_parent_id` = "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")  AND  ((p.`product_parent_id` > "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  AND  p.`published`="1"  AND  ( p.`virtuemart_product_id` NOT IN (1453,207,2129,21709,2080,458,20979,156,23214,22846,840,24471,253,5101,18485,1410,23273,20765,22433,5218/*... omitted 12 items ...*/) ) ) 
group by p.`virtuemart_product_id` 
ORDER BY RAND() LIMIT 0, 5\G

# Query 2: 0.00 QPS, 0.01x concurrency, ID 0xEA98833A51228680 at byte 5171920
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.05
# Time range: 2022-02-02T21:01:14 to 2022-02-03T08:22:06
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         46     180
# Exec time      7    453s      2s      5s      3s      3s   342ms      2s
# Lock time     42    39ms   130us     2ms   216us   236us   238us   159us
# Rows sent     54  12.66k      72      72      72      72       0      72
# Rows examine  32   4.60M  26.16k  26.19k  26.17k  25.99k       0  25.99k
# Rows affecte   0       0       0       0       0       0       0       0
# Bytes sent    53   1.12M   6.37k   6.40k   6.38k   6.31k       0   6.31k
# Query size    45 203.94k   1.13k   1.23k   1.13k   1.09k   12.00   1.09k
# String:
# Databases    mnb1356_main
# Hosts        localhost
# Last errno   0
# Users        mnb1356_main
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms
#    1s  ################################################################
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_products'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_products`\G
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_products_ru_ru'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_products_ru_ru`\G
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_product_shoppergroups'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_product_shoppergroups`\G
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_product_categories'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_product_categories`\G
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_product_prices'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_product_prices`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT  p.`virtuemart_product_id`, l.product_name 
		FROM `u9ija_virtuemart_products` as p   
LEFT JOIN `u9ija_virtuemart_products_ru_ru` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
LEFT JOIN `u9ija_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
LEFT JOIN `u9ija_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
LEFT JOIN `u9ija_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` 
WHERE ( p.`product_in_stock` - p.`product_ordered` >"0"  AND  ((p.`product_parent_id` = "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")  AND  ((p.`product_parent_id` > "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  AND p.`product_special`="1"  AND  p.`published`="1"  AND  ( p.`virtuemart_product_id` NOT IN (458,1453,207,2080,156,21709,20979,2129) ) ) 
group by p.`virtuemart_product_id` 
ORDER BY product_name ASC, p.`virtuemart_product_id` ASC LIMIT 0, 72\G

# Query 3: 0.00 QPS, 0.00x concurrency, ID 0x8942942EDAB23BBF at byte 3845388
# This item is included in the report because it matches --outliers.
# Scores: V/M = 0.06
# Time range: 2022-02-02T21:24:46 to 2022-02-03T08:21:39
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          7      28
# Exec time      1     72s      2s      4s      3s      3s   406ms      2s
# Lock time     12    11ms   151us   816us   408us   596us   164us   403us
# Rows sent     42   9.86k      36     374  360.64  363.48   60.97  363.48
# Rows examine   5 740.85k  26.13k  26.48k  26.46k  25.99k       0  25.99k
# Rows affecte   0       0       0       0       0       0       0       0
# Bytes sent    40 866.78k   3.06k  32.11k  30.96k  31.59k   5.30k  31.59k
# Query size     6  29.45k   1.05k   1.05k   1.05k   1.04k       0   1.04k
# String:
# Databases    mnb1356_main
# Hosts        localhost
# Last errno   0
# Users        mnb1356_main
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms
#    1s  ################################################################
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_products'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_products`\G
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_products_ru_ru'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_products_ru_ru`\G
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_product_shoppergroups'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_product_shoppergroups`\G
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_product_categories'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_product_categories`\G
#    SHOW TABLE STATUS FROM `mnb1356_main` LIKE 'u9ija_virtuemart_product_prices'\G
#    SHOW CREATE TABLE `mnb1356_main`.`u9ija_virtuemart_product_prices`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT  p.`virtuemart_product_id`, l.product_name 
		FROM `u9ija_virtuemart_products` as p   
LEFT JOIN `u9ija_virtuemart_products_ru_ru` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
LEFT JOIN `u9ija_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
LEFT JOIN `u9ija_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
LEFT JOIN `u9ija_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` 
WHERE ( p.`product_in_stock` - p.`product_ordered` >"0"  AND  ((p.`product_parent_id` = "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")  AND  ((p.`product_parent_id` > "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  AND p.`product_special`="1"  AND  p.`published`="1" ) 
group by p.`virtuemart_product_id` 
ORDER BY product_name ASC, p.`virtuemart_product_id` ASC LIMIT 0, 3000\G