Ночью запустили лог, а нагрузка вся с 7-8 утра до 16-00. Спасибо будем искать.
Добавлено спустя 30 минут 23 секунды:Вот лог, может кто подсказать
Добавлено спустя 3 минуты 29 секунд:Reading from STDIN ...
# 44.6s user time, 3.7s system time, 33.49M rss, 114.46M vsz
# Current date: Sat Apr 17 06:41:41 2021
# Hostname: liberty.beget.ru
# Files: STDIN
# Overall: 23.67k total, 116 unique, 1.64 QPS, 0.19x concurrency _________
# Time range: 2021-04-17T02:41:42 to 2021-04-17T06:41:40
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 2731s 100ms 2s 115ms 100ms 105ms 100ms
# Lock time 0 0 0 0 0 0 0
# Query size 21.53M 19 2.59k 953.83 1.69k 413.48 793.42
# id 994.01G 42.64M 43.35M 43.00M 42.20M 0 42.20M
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============== ===== ====== ===== ==============
# 1 0x4FB6224D5A3C1D87 996.4267 36.5% 7549 0.1320 0.16 SELECT ok_brands ok_products ok_lang_brands ok_products_categories
# 2 0x0E11DFB8AA487654 450.7700 16.5% 3905 0.1154 0.11 SELECT ok_features_values ok_products_features_values ok_features ok_products ok_lang_features_values ok_products_categories
# 3 0x029D8C19A9424B36 273.9246 10.0% 2502 0.1095 0.07 SELECT ok_features_values ok_products_features_values ok_features ok_lang_features_values ok_products_categories
# 4 0x4434E7D71AF1FF33 160.3756 5.9% 1584 0.1012 0.00 SELECT ok_brands ok_products ok_lang_brands
# 5 0xB23630AF63BDA63F 107.4234 3.9% 993 0.1082 0.06 SELECT ok_brands ok_products ok_lang_brands ok_products_categories ok_products_features_values ok_lang_features_values ok_products ok_features_values
# 6 0x2BE109654F5C841C 69.7823 2.6% 665 0.1049 0.03 SELECT ok_features_values ok_products_features_values ok_features ok_products ok_lang_features_values ok_products_categories ok_products_features_values ok_features_values ok_lang_features_values
# 7 0x0337298D62963C8D 67.4087 2.5% 667 0.1011 0.00 SELECT ok_products ok_router_cache ok_lang_products ok_products_categories
# 8 0xA86FE6BC63F14E63 61.6545 2.3% 549 0.1123 0.09 SELECT ok_brands ok_products ok_lang_brands ok_products_categories ok_products_features_values ok_lang_features_values ok_products ok_features_values
# 9 0x250BC011881DFDFF 52.0123 1.9% 518 0.1004 0.00 SELECT ok_categories ok_lang_categories ok_router_cache
# 10 0x89F0C827D4DEA345 26.0276 1.0% 247 0.1054 0.04 SELECT ok_products ok_router_cache ok_lang_products ok_products_categories ok_variants ok_currencies ok_products_features_values ok_lang_features_values ok_products ok_features_values ok_variants
# 11 0x231ECE52CF90A96D 26.0072 1.0% 222 0.1171 0.12 SELECT ok_features_values ok_products_features_values ok_features ok_products ok_lang_features_values ok_products_categories ok_products_features_values ok_features_values ok_lang_features_values ok_products_features_values ok_features_values ok_lang_features_values
# 12 0x22E38EEB07E2AF4B 20.9572 0.8% 199 0.1053 0.04 SELECT ok_brands ok_products ok_lang_brands ok_products_categories ok_products_features_values ok_lang_features_values ok_products ok_features_values
# 13 0xCB691BB2F34E8523 20.0696 0.7% 190 0.1056 0.04 SELECT ok_products ok_router_cache ok_lang_products ok_products_categories ok_variants ok_currencies ok_variants
# 14 0x4AFBB8E511751400 18.3973 0.7% 182 0.1011 0.00 SELECT ok_features_values ok_products_features_values ok_features ok_products ok_lang_features_values ok_products_categories ok_products
# 15 0x0CE9C8D536AEDC50 16.2449 0.6% 161 0.1009 0.00 SELECT ok_features_values ok_products_features_values ok_features ok_products ok_lang_features_values ok_products_categories ok_products_features_values ok_features_values ok_lang_features_values ok_products_features_values ok_features_values ok_lang_features_values ok_products_features_values ok_features_values ok_lang_features_values
# 16 0x6A20DE8370487539 15.0611 0.6% 125 0.1205 0.19 SELECT ok_pages ok_lang_pages
# 17 0x3B8BCFEB280BCB4F 14.6623 0.5% 146 0.1004 0.00 SELECT ok_modules
# 18 0xC16AF51FC8058CF6 12.2113 0.4% 121 0.1009 0.00 SELECT ok_products ok_lang_products ok_products_categories ok_products_features_values ok_lang_features_values ok_products ok_features_values ok_variants ok_currencies
# 19 0x8B5D1370BE519A3A 12.0057 0.4% 119 0.1009 0.00 SELECT ok_variants ok_currencies ok_lang_variants
# 20 0x090C3AF5F34EDD11 11.9039 0.4% 118 0.1009 0.00 SELECT ok_products ok_lang_products ok_products_categories ok_variants ok_currencies ok_products_features_values ok_lang_features_values ok_products ok_features_values ok_variants
# MISC 0xMISC 297.5077 10.9% 2907 0.1023 0.0 <96 ITEMS>
# Query 1: 0.52 QPS, 0.07x concurrency, ID 0x4FB6224D5A3C1D87 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.16
# Time range: 2021-04-17T02:41:42 to 2021-04-17T06:41:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 31 7549
# Exec time 36 996s 100ms 1s 132ms 198ms 146ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 27 5.97M 619 1.15k 828.61 1.14k 86.89 793.42
# id 31 317.09G 42.64M 43.35M 43.01M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`b`.`id`,
`b`.`url`,
`b`.`image`,
`b`.`last_modify`,
`b`.`visible`,
`b`.`position`,
`l`.`name`,
`l`.`meta_title`,
`l`.`meta_keywords`,
`l`.`meta_description`,
`l`.`annotation`,
`l`.`description`
FROM
`ok_brands` AS `b`
LEFT JOIN `ok_products` AS `p` ON `p`.`brand_id`=`b`.`id`
LEFT JOIN `ok_lang_brands` AS `l` ON `l`.`brand_id` = `b`.`id` AND `l`.`lang_id` = 1
LEFT JOIN `ok_products_categories` `pc` ON `p`.`id` = `pc`.`product_id`
WHERE
`pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285, 160, 212, 272, 149, 280, 151, 275, 163, 158, 143, 277, 260, 185, 159, 94, 155, 96, 222, 211, 87)
AND `b`.`visible` = 1
AND `p`.`visible` = 1
ORDER BY
`b`.`position`\G
# Query 2: 0.27 QPS, 0.03x concurrency, ID 0x0E11DFB8AA487654 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.11
# Time range: 2021-04-17T02:41:43 to 2021-04-17T06:41:38
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 16 3905
# Exec time 16 451s 100ms 1s 115ms 100ms 112ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 16 3.60M 786 1.29k 966.17 918.49 80.08 918.49
# id 16 164.01G 42.64M 43.35M 43.01M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`fv`.`id`,
`fv`.`feature_id`,
`fv`.`position`,
`fv`.`to_index`,
`l`.`value`,
`l`.`translit`
FROM
`ok_features_values` AS `fv`
LEFT JOIN `ok_products_features_values` AS `pf` ON `pf`.`value_id`=`fv`.`id`
LEFT JOIN `ok_features` AS `f` ON `f`.`id`=`fv`.`feature_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_lang_features_values` AS `l` ON `l`.`feature_value_id` = `fv`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `pc`.`product_id`=`pf`.`product_id` AND `pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285, 160, 212, 272, 149, 280, 151, 275, 163, 158, 143, 277, 260, 185, 159, 94, 155, 96, 222, 211, 87)
WHERE
`p`.`visible`=1
AND `fv`.`feature_id` IN (116, 117, 118, 119, 121, 122, 123, 124)
GROUP BY
`fv`.`id`
ORDER BY
`fv`.`position` ASC,
`l`.`value` ASC\G
# Query 3: 0.17 QPS, 0.02x concurrency, ID 0x029D8C19A9424B36 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.07
# Time range: 2021-04-17T02:41:43 to 2021-04-17T06:41:33
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 10 2502
# Exec time 10 274s 100ms 1s 109ms 100ms 89ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 9 1.94M 629 1.13k 814.60 1.09k 88.18 755.64
# id 10 105.05G 42.64M 43.35M 42.99M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`fv`.`id`,
`fv`.`feature_id`,
`fv`.`position`,
`fv`.`to_index`,
`l`.`value`,
`l`.`translit`
FROM
`ok_features_values` AS `fv`
LEFT JOIN `ok_products_features_values` AS `pf` ON `pf`.`value_id`=`fv`.`id`
LEFT JOIN `ok_features` AS `f` ON `f`.`id`=`fv`.`feature_id`
LEFT JOIN `ok_lang_features_values` AS `l` ON `l`.`feature_value_id` = `fv`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `pc`.`product_id`=`pf`.`product_id` AND `pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285, 160, 212, 272, 149, 280, 151, 275, 163, 158, 143, 277, 260, 185, 159, 94, 155, 96, 222, 211, 87)
GROUP BY
`fv`.`id`
ORDER BY
`fv`.`position` ASC,
`l`.`value` ASC\G
# Query 4: 0.11 QPS, 0.01x concurrency, ID 0x4434E7D71AF1FF33 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T02:43:04 to 2021-04-17T06:41:32
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 6 1584
# Exec time 5 160s 100ms 202ms 101ms 100ms 6ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 2 517.14k 262 423 334.31 381.65 40.14 329.68
# id 6 66.59G 42.64M 43.35M 43.05M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_brands`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`b`.`url`
FROM
`ok_brands` AS `b`
LEFT JOIN `ok_products` AS `p` ON `p`.`brand_id`=`b`.`id`
LEFT JOIN `ok_lang_brands` AS `l` ON `l`.`brand_id` = `b`.`id` AND `l`.`lang_id` = 1
WHERE
`b`.`url` IN ('acana', 'advance', 'essential', 'grandorf', 'monge', 'now-fresh', 'nutram', 'purina-pro-plan')
ORDER BY
`b`.`position` ASC\G
# Query 5: 0.08 QPS, 0.01x concurrency, ID 0xB23630AF63BDA63F at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.06
# Time range: 2021-04-17T03:08:22 to 2021-04-17T06:41:32
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 4 993
# Exec time 3 107s 100ms 1s 108ms 100ms 80ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 5 1.28M 1.12k 1.72k 1.32k 1.33k 61.53 1.26k
# id 4 41.76G 42.72M 43.35M 43.06M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`b`.`id`,
`b`.`url`,
`b`.`image`,
`b`.`last_modify`,
`b`.`visible`,
`b`.`position`,
`l`.`name`,
`l`.`meta_title`,
`l`.`meta_keywords`,
`l`.`meta_description`,
`l`.`annotation`,
`l`.`description`
FROM
`ok_brands` AS `b`
LEFT JOIN `ok_products` AS `p` ON `p`.`brand_id`=`b`.`id`
LEFT JOIN `ok_lang_brands` AS `l` ON `l`.`brand_id` = `b`.`id` AND `l`.`lang_id` = 1
LEFT JOIN `ok_products_categories` `pc` ON `p`.`id` = `pc`.`product_id`
WHERE
`pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
AND `b`.`visible` = 1
AND `p`.`visible` = 1
AND `p`.`id` IN (SELECT
`pf`.`product_id`
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `pf`.`value_id`=`lfv`.`feature_value_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
WHERE
`lfv`.`lang_id`=1
AND `p`.`visible` = 1
AND ((`lfv`.`translit` IN ('indejka', 'seld', 'govyadina') AND `fv`.`feature_id`=119))
GROUP BY
`pf`.`product_id`
HAVING
COUNT(*) >=1)
ORDER BY
`b`.`position`\G
# Query 6: 0.06 QPS, 0.01x concurrency, ID 0x2BE109654F5C841C at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.03
# Time range: 2021-04-17T03:23:11 to 2021-04-17T06:41:34
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 665
# Exec time 2 70s 100ms 1s 105ms 100ms 60ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 4 901.82k 1.25k 1.75k 1.36k 1.33k 62.87 1.33k
# id 2 27.94G 42.77M 43.35M 43.02M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`fv`.`id`,
`fv`.`feature_id`,
`fv`.`position`,
`fv`.`to_index`,
`l`.`value`,
`l`.`translit`
FROM
`ok_features_values` AS `fv`
LEFT JOIN `ok_products_features_values` AS `pf` ON `pf`.`value_id`=`fv`.`id`
LEFT JOIN `ok_features` AS `f` ON `f`.`id`=`fv`.`feature_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_lang_features_values` AS `l` ON `l`.`feature_value_id` = `fv`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `pc`.`product_id`=`pf`.`product_id` AND `pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
WHERE
(`fv`.`feature_id` =124 OR `p`.`id` IN (SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `fv`.`id`=`lfv`.`feature_value_id`
WHERE
`lfv`.`lang_id`=1
AND (`lfv`.`translit` IN ('italiya', 'niderlandy', 'frantsiya', 'rossiya', 'belgiya', 'shvetsiya', 'velikobritaniya') AND `fv`.`feature_id`=124)))
AND `p`.`visible`=1
AND `fv`.`feature_id` IN (116, 117, 118, 119, 121, 122, 123, 124)
GROUP BY
`fv`.`id`
ORDER BY
`fv`.`position` ASC,
`l`.`value` ASC\G
# Query 7: 0.05 QPS, 0.00x concurrency, ID 0x0337298D62963C8D at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T02:41:43 to 2021-04-17T06:41:23
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 667
# Exec time 2 67s 100ms 202ms 101ms 100ms 4ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 1 411.99k 541 970 632.49 964.41 103.41 592.07
# id 2 28.02G 42.64M 43.35M 43.02M 42.20M 0.50 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_router_cache'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_router_cache`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`p`.`last_modify`
FROM
`ok_products` AS `p`
LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`p`.`url` AND `r`.`type`="product"
LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `p`.`id` = `pc`.`product_id` AND `pc`.`category_id` IN(139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285, 160, 212, 272, 149, 280, 151, 275, 163, 158, 143, 277, 260, 185, 159, 94, 155, 96, 222, 211, 87)
GROUP BY
`p`.`id`
ORDER BY
`p`.`last_modify` DESC
LIMIT 1\G
# Query 8: 0.04 QPS, 0.00x concurrency, ID 0xA86FE6BC63F14E63 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.09
# Time range: 2021-04-17T02:41:44 to 2021-04-17T06:37:09
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 549
# Exec time 2 62s 100ms 1s 112ms 100ms 100ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 3 808.46k 1.29k 1.84k 1.47k 1.69k 101.10 1.46k
# id 2 22.98G 42.64M 43.33M 42.86M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`b`.`id`,
`b`.`url`,
`b`.`image`,
`b`.`last_modify`,
`b`.`visible`,
`b`.`position`,
`l`.`name`,
`l`.`meta_title`,
`l`.`meta_keywords`,
`l`.`meta_description`,
`l`.`annotation`,
`l`.`description`
FROM
`ok_brands` AS `b`
LEFT JOIN `ok_products` AS `p` ON `p`.`brand_id`=`b`.`id`
LEFT JOIN `ok_lang_brands` AS `l` ON `l`.`brand_id` = `b`.`id` AND `l`.`lang_id` = 1
LEFT JOIN `ok_products_categories` `pc` ON `p`.`id` = `pc`.`product_id`
WHERE
`pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 95 items ...*/)
AND `b`.`visible` = 1
AND `p`.`visible` = 1
AND `p`.`id` IN (SELECT
`pf`.`product_id`
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `pf`.`value_id`=`lfv`.`feature_value_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
WHERE
`lfv`.`lang_id`=1
AND `p`.`visible` = 1
AND ((`lfv`.`translit` IN ('kuritsa', 'tsukkini', 'fosfor', 'glyukozamin') AND `fv`.`feature_id`=119) OR (`lfv`.`translit` IN ('sobaki') AND `fv`.`feature_id`=123))
GROUP BY
`pf`.`product_id`
HAVING
COUNT(*) >=2)
ORDER BY
`b`.`position`\G
# Query 9: 0.04 QPS, 0.00x concurrency, ID 0x250BC011881DFDFF at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T02:42:58 to 2021-04-17T06:40:49
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 518
# Exec time 1 52s 100ms 101ms 100ms 100ms 0 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 1 384.96k 761 761 761 761 0 761
# id 2 21.77G 42.64M 43.35M 43.03M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_router_cache'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_router_cache`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT
`c`.`id`,
`c`.`parent_id`,
`c`.`url`,
`c`.`image`,
`c`.`position`,
`c`.`visible`,
`c`.`external_id`,
`c`.`level_depth`,
`c`.`last_modify`,
`c`.`created`,
`r`.`slug_url`,
`l`.`name`,
`l`.`name_h1`,
`l`.`auto_h1`,
`l`.`meta_title`,
`l`.`meta_keywords`,
`l`.`meta_description`,
`l`.`annotation`,
`l`.`description`,
`l`.`auto_meta_title`,
`l`.`auto_meta_keywords`,
`l`.`auto_meta_desc`,
`l`.`auto_description`
FROM
`ok_categories` AS `c`
LEFT JOIN `ok_lang_categories` AS `l` ON `l`.`category_id` = `c`.`id` AND `l`.`lang_id` = 1
LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`c`.`url` AND `r`.`type`="category"
ORDER BY
`c`.`parent_id`,
`c`.`position`\G
# Query 10: 0.02 QPS, 0.00x concurrency, ID 0x89F0C827D4DEA345 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.04
# Time range: 2021-04-17T03:22:37 to 2021-04-17T06:41:27
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 247
# Exec time 0 26s 100ms 1s 105ms 100ms 67ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 2 490.82k 1.88k 2.37k 1.99k 1.96k 82.20 1.96k
# id 1 10.39G 42.77M 43.35M 43.07M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_router_cache'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_router_cache`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_variants'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_variants`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_currencies'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_currencies`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_variants'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_variants`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`p`.`id`,
`p`.`url`,
`p`.`brand_id`,
`p`.`visible`,
`p`.`position`,
`p`.`created`,
`p`.`featured`,
`p`.`external_id`,
`p`.`rating`,
`p`.`votes`,
`p`.`last_modify`,
`p`.`main_category_id`,
`p`.`main_image_id`,
`r`.`slug_url`,
`l`.`name`,
`l`.`annotation`,
`l`.`special`
FROM
`ok_products` AS `p`
LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`p`.`url` AND `r`.`type`="product"
LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `p`.`id` = `pc`.`product_id` AND `pc`.`category_id` IN(139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id`
LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id`
INNER JOIN (
SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `pf`.`value_id`=`lfv`.`feature_value_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
WHERE
`lfv`.`lang_id`=1
AND `p`.`visible` = 1
AND ((`lfv`.`translit` IN ('ovoschi', 'fazan', 'apelsin', 'mintaj', 'telyatina') AND `fv`.`feature_id`=119))
GROUP BY
product_id
HAVING
COUNT(*) >=1
) AS `products_features` ON `products_features`.`product_id`=`p`.`id`
WHERE
`p`.`visible` = 1
GROUP BY
`p`.`id`
ORDER BY
((SELECT count(`pv`.`id`) FROM ok_variants pv WHERE (`pv`.`stock` IS NULL OR `pv`.`stock`>0) AND `p`.`id` = `pv`.`product_id`)>0) DESC,
`p`.`position` DESC
LIMIT 24\G
# Query 11: 0.02 QPS, 0.00x concurrency, ID 0x231ECE52CF90A96D at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.12
# Time range: 2021-04-17T02:43:00 to 2021-04-17T06:41:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 222
# Exec time 0 26s 100ms 1s 117ms 100ms 119ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 1 403.50k 1.62k 2.19k 1.82k 2.06k 152.30 1.69k
# id 0 9.34G 42.64M 43.35M 43.08M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`fv`.`id`,
`fv`.`feature_id`,
`fv`.`position`,
`fv`.`to_index`,
`l`.`value`,
`l`.`translit`
FROM
`ok_features_values` AS `fv`
LEFT JOIN `ok_products_features_values` AS `pf` ON `pf`.`value_id`=`fv`.`id`
LEFT JOIN `ok_features` AS `f` ON `f`.`id`=`fv`.`feature_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_lang_features_values` AS `l` ON `l`.`feature_value_id` = `fv`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `pc`.`product_id`=`pf`.`product_id` AND `pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 95 items ...*/)
WHERE
(`fv`.`feature_id` =119 OR `p`.`id` IN (SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `fv`.`id`=`lfv`.`feature_value_id`
WHERE
`lfv`.`lang_id`=1
AND (`lfv`.`translit` IN ('kuritsa', 'tsukkini', 'ptitsa') AND `fv`.`feature_id`=119)))
AND (`fv`.`feature_id` =123 OR `p`.`id` IN (SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `fv`.`id`=`lfv`.`feature_value_id`
WHERE
`lfv`.`lang_id`=1
AND (`lfv`.`translit` IN ('sobaki') AND `fv`.`feature_id`=123)))
AND `p`.`visible`=1
AND `fv`.`feature_id` IN (116, 117, 118, 119, 120, 121, 122, 123, 124)
GROUP BY
`fv`.`id`
ORDER BY
`fv`.`position` ASC,
`l`.`value` ASC\G
# Query 12: 0.01 QPS, 0.00x concurrency, ID 0x22E38EEB07E2AF4B at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.04
# Time range: 2021-04-17T02:41:45 to 2021-04-17T06:40:16
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 199
# Exec time 0 21s 100ms 1s 105ms 100ms 63ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 1 305.78k 1.41k 1.78k 1.54k 1.53k 45.01 1.53k
# id 0 8.31G 42.64M 43.34M 42.74M 42.20M 0.50 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`b`.`id`,
`b`.`url`,
`b`.`image`,
`b`.`last_modify`,
`b`.`visible`,
`b`.`position`,
`l`.`name`,
`l`.`meta_title`,
`l`.`meta_keywords`,
`l`.`meta_description`,
`l`.`annotation`,
`l`.`description`
FROM
`ok_brands` AS `b`
LEFT JOIN `ok_products` AS `p` ON `p`.`brand_id`=`b`.`id`
LEFT JOIN `ok_lang_brands` AS `l` ON `l`.`brand_id` = `b`.`id` AND `l`.`lang_id` = 1
LEFT JOIN `ok_products_categories` `pc` ON `p`.`id` = `pc`.`product_id`
WHERE
`pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
AND `b`.`visible` = 1
AND `p`.`visible` = 1
AND `p`.`id` IN (SELECT
`pf`.`product_id`
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `pf`.`value_id`=`lfv`.`feature_value_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
WHERE
`lfv`.`lang_id`=1
AND `p`.`visible` = 1
AND ((`lfv`.`translit` IN ('nizkozernovoj') AND `fv`.`feature_id`=121) OR (`lfv`.`translit` IN ('supersppremium', 'premium', 'holistic') AND `fv`.`feature_id`=122) OR (`lfv`.`translit` IN ('germaniya', 'kanada', 'belgiya', 'angliya', 'ssha', 'shvetsiya', 'italiya', 'velikobritaniya', 'chehiya', 'frantsiya') AND `fv`.`feature_id`=124))
GROUP BY
`pf`.`product_id`
HAVING
COUNT(*) >=3)
ORDER BY
`b`.`position`\G
# Query 13: 0.02 QPS, 0.00x concurrency, ID 0xCB691BB2F34E8523 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.04
# Time range: 2021-04-17T03:21:59 to 2021-04-17T06:31:32
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 190
# Exec time 0 20s 101ms 1s 106ms 100ms 65ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 1 240.78k 1.24k 1.30k 1.27k 1.26k 28.48 1.26k
# id 0 7.99G 42.77M 43.32M 43.07M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_router_cache'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_router_cache`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_variants'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_variants`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_currencies'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_currencies`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_variants'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_variants`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`p`.`id`,
`p`.`url`,
`p`.`brand_id`,
`p`.`visible`,
`p`.`position`,
`p`.`created`,
`p`.`featured`,
`p`.`external_id`,
`p`.`rating`,
`p`.`votes`,
`p`.`last_modify`,
`p`.`main_category_id`,
`p`.`main_image_id`,
`r`.`slug_url`,
`l`.`name`,
`l`.`annotation`,
`l`.`special`
FROM
`ok_products` AS `p`
LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`p`.`url` AND `r`.`type`="product"
LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `p`.`id` = `pc`.`product_id` AND `pc`.`category_id` IN(139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id`
LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id`
WHERE
`p`.`visible` = 1
AND `p`.`brand_id` IN ('134', '269', '127', '126', '207', '131', '174')
GROUP BY
`p`.`id`
ORDER BY
((SELECT count(`pv`.`id`) FROM ok_variants pv WHERE (`pv`.`stock` IS NULL OR `pv`.`stock`>0) AND `p`.`id` = `pv`.`product_id`)>0) DESC,
`p`.`position` DESC
LIMIT 24\G
# Query 14: 0.02 QPS, 0.00x concurrency, ID 0x4AFBB8E511751400 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T03:22:03 to 2021-04-17T06:25:55
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 182
# Exec time 0 18s 100ms 139ms 101ms 100ms 3ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 0 193.24k 1.02k 1.33k 1.06k 1.04k 23.34 1.04k
# id 0 7.65G 42.77M 43.30M 43.07M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`fv`.`id`,
`fv`.`feature_id`,
`fv`.`position`,
`fv`.`to_index`,
`l`.`value`,
`l`.`translit`
FROM
`ok_features_values` AS `fv`
LEFT JOIN `ok_products_features_values` AS `pf` ON `pf`.`value_id`=`fv`.`id`
LEFT JOIN `ok_features` AS `f` ON `f`.`id`=`fv`.`feature_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_lang_features_values` AS `l` ON `l`.`feature_value_id` = `fv`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `pc`.`product_id`=`pf`.`product_id` AND `pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
WHERE
`p`.`visible`=1
AND `fv`.`feature_id` IN (116, 117, 118, 119, 121, 122, 123, 124)
AND `pf`.`product_id` IN (SELECT id FROM ok_products WHERE brand_id IN ('134', '271', '123', '269', '227', '226', '121', '142'))
GROUP BY
`fv`.`id`
ORDER BY
`fv`.`position` ASC,
`l`.`value` ASC\G
# Query 15: 0.01 QPS, 0.00x concurrency, ID 0x0CE9C8D536AEDC50 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T02:41:47 to 2021-04-17T06:21:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 161
# Exec time 0 16s 100ms 102ms 101ms 100ms 0 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 1 352.78k 2.09k 2.43k 2.19k 2.16k 36.05 2.16k
# id 0 6.72G 42.64M 43.29M 42.73M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`fv`.`id`,
`fv`.`feature_id`,
`fv`.`position`,
`fv`.`to_index`,
`l`.`value`,
`l`.`translit`
FROM
`ok_features_values` AS `fv`
LEFT JOIN `ok_products_features_values` AS `pf` ON `pf`.`value_id`=`fv`.`id`
LEFT JOIN `ok_features` AS `f` ON `f`.`id`=`fv`.`feature_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_lang_features_values` AS `l` ON `l`.`feature_value_id` = `fv`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `pc`.`product_id`=`pf`.`product_id` AND `pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
WHERE
(`fv`.`feature_id` =119 OR `p`.`id` IN (SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `fv`.`id`=`lfv`.`feature_value_id`
WHERE
`lfv`.`lang_id`=1
AND (`lfv`.`translit` IN ('sardina') AND `fv`.`feature_id`=119)))
AND (`fv`.`feature_id` =122 OR `p`.`id` IN (SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `fv`.`id`=`lfv`.`feature_value_id`
WHERE
`lfv`.`lang_id`=1
AND (`lfv`.`translit` IN ('supersppremium', 'premium', 'holistic') AND `fv`.`feature_id`=122)))
AND (`fv`.`feature_id` =124 OR `p`.`id` IN (SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `fv`.`id`=`lfv`.`feature_value_id`
WHERE
`lfv`.`lang_id`=1
AND (`lfv`.`translit` IN ('italiya', 'frantsiya', 'germaniya', 'angliya', 'ssha', 'kanada', 'velikobritaniya', 'belgiya', 'chehiya') AND `fv`.`feature_id`=124)))
AND `p`.`visible`=1
AND `fv`.`feature_id` IN (116, 117, 118, 119, 121, 122, 123, 124)
GROUP BY
`fv`.`id`
ORDER BY
`fv`.`position` ASC,
`l`.`value` ASC\G
# Query 16: 0.01 QPS, 0.00x concurrency, ID 0x6A20DE8370487539 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.19
# Time range: 2021-04-17T02:43:14 to 2021-04-17T06:40:30
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 125
# Exec time 0 15s 100ms 2s 120ms 100ms 150ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 0 49.80k 408 408 408 408 0 408
# id 0 5.25G 42.64M 43.35M 42.99M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_pages'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_pages`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_pages'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_pages`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`p`.`id`,
`p`.`url`,
`p`.`visible`,
`p`.`position`,
`p`.`last_modify`,
`l`.`name`,
`l`.`name_h1`,
`l`.`meta_title`,
`l`.`meta_keywords`,
`l`.`meta_description`,
`l`.`description`
FROM
`ok_pages` AS `p`
LEFT JOIN `ok_lang_pages` AS `l` ON `l`.`page_id` = `p`.`id` AND `l`.`lang_id` = 1
WHERE
`p`.`visible` = 1
ORDER BY
`p`.`position` ASC\G
# Query 17: 0.01 QPS, 0.00x concurrency, ID 0x3B8BCFEB280BCB4F at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T02:41:54 to 2021-04-17T06:38:42
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 146
# Exec time 0 15s 100ms 102ms 100ms 100ms 0 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 0 14.73k 97 114 103.34 112.70 4.99 102.22
# id 0 6.13G 42.64M 43.34M 43.01M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_modules'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_modules`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT
enabled
FROM
`ok_modules`
WHERE
vendor = 'OkayCMS'
AND module_name = 'PayKeeper'\G
# Query 18: 0.01 QPS, 0.00x concurrency, ID 0xC16AF51FC8058CF6 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T03:24:03 to 2021-04-17T06:41:21
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 121
# Exec time 0 12s 100ms 101ms 101ms 100ms 0 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 0 195.03k 1.57k 1.99k 1.61k 1.61k 71.87 1.53k
# id 0 5.09G 42.77M 43.35M 43.07M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_variants'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_variants`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_currencies'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_currencies`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT
floor(min(IF(`pv`.`currency_id`=0 OR `c`.`id` is null,`pv`.`price`, `pv`.`price`*`c`.`rate_to`/`c`.`rate_from`)*1)) AS `min`,
floor(max(IF(`pv`.`currency_id`=0 OR `c`.`id` is null,`pv`.`price`, `pv`.`price`*`c`.`rate_to`/`c`.`rate_from`)*1)) AS `max`
FROM
`ok_products` AS `p`
LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `p`.`id` = `pc`.`product_id` AND `pc`.`category_id` IN(139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
INNER JOIN (
SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `pf`.`value_id`=`lfv`.`feature_value_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
WHERE
`lfv`.`lang_id`=1
AND `p`.`visible` = 1
AND ((`lfv`.`translit` IN ('italiya', 'niderlandy', 'frantsiya', 'rossiya', 'belgiya', 'shvetsiya') AND `fv`.`feature_id`=124))
GROUP BY
product_id
HAVING
COUNT(*) >=1
) AS `products_features` ON `products_features`.`product_id`=`p`.`id`
LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id`
LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id`
WHERE
`p`.`visible` = 1\G
.......
Ночью запустили лог, а нагрузка вся с 7-8 утра до 16-00. Спасибо будем искать.
Вот лог, может кто подсказать
[attachment=0]mysql_query_va290498_zoo.log[/attachment]
Reading from STDIN ...
# 44.6s user time, 3.7s system time, 33.49M rss, 114.46M vsz
# Current date: Sat Apr 17 06:41:41 2021
# Hostname: liberty.beget.ru
# Files: STDIN
# Overall: 23.67k total, 116 unique, 1.64 QPS, 0.19x concurrency _________
# Time range: 2021-04-17T02:41:42 to 2021-04-17T06:41:40
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 2731s 100ms 2s 115ms 100ms 105ms 100ms
# Lock time 0 0 0 0 0 0 0
# Query size 21.53M 19 2.59k 953.83 1.69k 413.48 793.42
# id 994.01G 42.64M 43.35M 43.00M 42.20M 0 42.20M
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============== ===== ====== ===== ==============
# 1 0x4FB6224D5A3C1D87 996.4267 36.5% 7549 0.1320 0.16 SELECT ok_brands ok_products ok_lang_brands ok_products_categories
# 2 0x0E11DFB8AA487654 450.7700 16.5% 3905 0.1154 0.11 SELECT ok_features_values ok_products_features_values ok_features ok_products ok_lang_features_values ok_products_categories
# 3 0x029D8C19A9424B36 273.9246 10.0% 2502 0.1095 0.07 SELECT ok_features_values ok_products_features_values ok_features ok_lang_features_values ok_products_categories
# 4 0x4434E7D71AF1FF33 160.3756 5.9% 1584 0.1012 0.00 SELECT ok_brands ok_products ok_lang_brands
# 5 0xB23630AF63BDA63F 107.4234 3.9% 993 0.1082 0.06 SELECT ok_brands ok_products ok_lang_brands ok_products_categories ok_products_features_values ok_lang_features_values ok_products ok_features_values
# 6 0x2BE109654F5C841C 69.7823 2.6% 665 0.1049 0.03 SELECT ok_features_values ok_products_features_values ok_features ok_products ok_lang_features_values ok_products_categories ok_products_features_values ok_features_values ok_lang_features_values
# 7 0x0337298D62963C8D 67.4087 2.5% 667 0.1011 0.00 SELECT ok_products ok_router_cache ok_lang_products ok_products_categories
# 8 0xA86FE6BC63F14E63 61.6545 2.3% 549 0.1123 0.09 SELECT ok_brands ok_products ok_lang_brands ok_products_categories ok_products_features_values ok_lang_features_values ok_products ok_features_values
# 9 0x250BC011881DFDFF 52.0123 1.9% 518 0.1004 0.00 SELECT ok_categories ok_lang_categories ok_router_cache
# 10 0x89F0C827D4DEA345 26.0276 1.0% 247 0.1054 0.04 SELECT ok_products ok_router_cache ok_lang_products ok_products_categories ok_variants ok_currencies ok_products_features_values ok_lang_features_values ok_products ok_features_values ok_variants
# 11 0x231ECE52CF90A96D 26.0072 1.0% 222 0.1171 0.12 SELECT ok_features_values ok_products_features_values ok_features ok_products ok_lang_features_values ok_products_categories ok_products_features_values ok_features_values ok_lang_features_values ok_products_features_values ok_features_values ok_lang_features_values
# 12 0x22E38EEB07E2AF4B 20.9572 0.8% 199 0.1053 0.04 SELECT ok_brands ok_products ok_lang_brands ok_products_categories ok_products_features_values ok_lang_features_values ok_products ok_features_values
# 13 0xCB691BB2F34E8523 20.0696 0.7% 190 0.1056 0.04 SELECT ok_products ok_router_cache ok_lang_products ok_products_categories ok_variants ok_currencies ok_variants
# 14 0x4AFBB8E511751400 18.3973 0.7% 182 0.1011 0.00 SELECT ok_features_values ok_products_features_values ok_features ok_products ok_lang_features_values ok_products_categories ok_products
# 15 0x0CE9C8D536AEDC50 16.2449 0.6% 161 0.1009 0.00 SELECT ok_features_values ok_products_features_values ok_features ok_products ok_lang_features_values ok_products_categories ok_products_features_values ok_features_values ok_lang_features_values ok_products_features_values ok_features_values ok_lang_features_values ok_products_features_values ok_features_values ok_lang_features_values
# 16 0x6A20DE8370487539 15.0611 0.6% 125 0.1205 0.19 SELECT ok_pages ok_lang_pages
# 17 0x3B8BCFEB280BCB4F 14.6623 0.5% 146 0.1004 0.00 SELECT ok_modules
# 18 0xC16AF51FC8058CF6 12.2113 0.4% 121 0.1009 0.00 SELECT ok_products ok_lang_products ok_products_categories ok_products_features_values ok_lang_features_values ok_products ok_features_values ok_variants ok_currencies
# 19 0x8B5D1370BE519A3A 12.0057 0.4% 119 0.1009 0.00 SELECT ok_variants ok_currencies ok_lang_variants
# 20 0x090C3AF5F34EDD11 11.9039 0.4% 118 0.1009 0.00 SELECT ok_products ok_lang_products ok_products_categories ok_variants ok_currencies ok_products_features_values ok_lang_features_values ok_products ok_features_values ok_variants
# MISC 0xMISC 297.5077 10.9% 2907 0.1023 0.0 <96 ITEMS>
# Query 1: 0.52 QPS, 0.07x concurrency, ID 0x4FB6224D5A3C1D87 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.16
# Time range: 2021-04-17T02:41:42 to 2021-04-17T06:41:40
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 31 7549
# Exec time 36 996s 100ms 1s 132ms 198ms 146ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 27 5.97M 619 1.15k 828.61 1.14k 86.89 793.42
# id 31 317.09G 42.64M 43.35M 43.01M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`b`.`id`,
`b`.`url`,
`b`.`image`,
`b`.`last_modify`,
`b`.`visible`,
`b`.`position`,
`l`.`name`,
`l`.`meta_title`,
`l`.`meta_keywords`,
`l`.`meta_description`,
`l`.`annotation`,
`l`.`description`
FROM
`ok_brands` AS `b`
LEFT JOIN `ok_products` AS `p` ON `p`.`brand_id`=`b`.`id`
LEFT JOIN `ok_lang_brands` AS `l` ON `l`.`brand_id` = `b`.`id` AND `l`.`lang_id` = 1
LEFT JOIN `ok_products_categories` `pc` ON `p`.`id` = `pc`.`product_id`
WHERE
`pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285, 160, 212, 272, 149, 280, 151, 275, 163, 158, 143, 277, 260, 185, 159, 94, 155, 96, 222, 211, 87)
AND `b`.`visible` = 1
AND `p`.`visible` = 1
ORDER BY
`b`.`position`\G
# Query 2: 0.27 QPS, 0.03x concurrency, ID 0x0E11DFB8AA487654 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.11
# Time range: 2021-04-17T02:41:43 to 2021-04-17T06:41:38
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 16 3905
# Exec time 16 451s 100ms 1s 115ms 100ms 112ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 16 3.60M 786 1.29k 966.17 918.49 80.08 918.49
# id 16 164.01G 42.64M 43.35M 43.01M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`fv`.`id`,
`fv`.`feature_id`,
`fv`.`position`,
`fv`.`to_index`,
`l`.`value`,
`l`.`translit`
FROM
`ok_features_values` AS `fv`
LEFT JOIN `ok_products_features_values` AS `pf` ON `pf`.`value_id`=`fv`.`id`
LEFT JOIN `ok_features` AS `f` ON `f`.`id`=`fv`.`feature_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_lang_features_values` AS `l` ON `l`.`feature_value_id` = `fv`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `pc`.`product_id`=`pf`.`product_id` AND `pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285, 160, 212, 272, 149, 280, 151, 275, 163, 158, 143, 277, 260, 185, 159, 94, 155, 96, 222, 211, 87)
WHERE
`p`.`visible`=1
AND `fv`.`feature_id` IN (116, 117, 118, 119, 121, 122, 123, 124)
GROUP BY
`fv`.`id`
ORDER BY
`fv`.`position` ASC,
`l`.`value` ASC\G
# Query 3: 0.17 QPS, 0.02x concurrency, ID 0x029D8C19A9424B36 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.07
# Time range: 2021-04-17T02:41:43 to 2021-04-17T06:41:33
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 10 2502
# Exec time 10 274s 100ms 1s 109ms 100ms 89ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 9 1.94M 629 1.13k 814.60 1.09k 88.18 755.64
# id 10 105.05G 42.64M 43.35M 42.99M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`fv`.`id`,
`fv`.`feature_id`,
`fv`.`position`,
`fv`.`to_index`,
`l`.`value`,
`l`.`translit`
FROM
`ok_features_values` AS `fv`
LEFT JOIN `ok_products_features_values` AS `pf` ON `pf`.`value_id`=`fv`.`id`
LEFT JOIN `ok_features` AS `f` ON `f`.`id`=`fv`.`feature_id`
LEFT JOIN `ok_lang_features_values` AS `l` ON `l`.`feature_value_id` = `fv`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `pc`.`product_id`=`pf`.`product_id` AND `pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285, 160, 212, 272, 149, 280, 151, 275, 163, 158, 143, 277, 260, 185, 159, 94, 155, 96, 222, 211, 87)
GROUP BY
`fv`.`id`
ORDER BY
`fv`.`position` ASC,
`l`.`value` ASC\G
# Query 4: 0.11 QPS, 0.01x concurrency, ID 0x4434E7D71AF1FF33 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T02:43:04 to 2021-04-17T06:41:32
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 6 1584
# Exec time 5 160s 100ms 202ms 101ms 100ms 6ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 2 517.14k 262 423 334.31 381.65 40.14 329.68
# id 6 66.59G 42.64M 43.35M 43.05M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_brands`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`b`.`url`
FROM
`ok_brands` AS `b`
LEFT JOIN `ok_products` AS `p` ON `p`.`brand_id`=`b`.`id`
LEFT JOIN `ok_lang_brands` AS `l` ON `l`.`brand_id` = `b`.`id` AND `l`.`lang_id` = 1
WHERE
`b`.`url` IN ('acana', 'advance', 'essential', 'grandorf', 'monge', 'now-fresh', 'nutram', 'purina-pro-plan')
ORDER BY
`b`.`position` ASC\G
# Query 5: 0.08 QPS, 0.01x concurrency, ID 0xB23630AF63BDA63F at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.06
# Time range: 2021-04-17T03:08:22 to 2021-04-17T06:41:32
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 4 993
# Exec time 3 107s 100ms 1s 108ms 100ms 80ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 5 1.28M 1.12k 1.72k 1.32k 1.33k 61.53 1.26k
# id 4 41.76G 42.72M 43.35M 43.06M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`b`.`id`,
`b`.`url`,
`b`.`image`,
`b`.`last_modify`,
`b`.`visible`,
`b`.`position`,
`l`.`name`,
`l`.`meta_title`,
`l`.`meta_keywords`,
`l`.`meta_description`,
`l`.`annotation`,
`l`.`description`
FROM
`ok_brands` AS `b`
LEFT JOIN `ok_products` AS `p` ON `p`.`brand_id`=`b`.`id`
LEFT JOIN `ok_lang_brands` AS `l` ON `l`.`brand_id` = `b`.`id` AND `l`.`lang_id` = 1
LEFT JOIN `ok_products_categories` `pc` ON `p`.`id` = `pc`.`product_id`
WHERE
`pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
AND `b`.`visible` = 1
AND `p`.`visible` = 1
AND `p`.`id` IN (SELECT
`pf`.`product_id`
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `pf`.`value_id`=`lfv`.`feature_value_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
WHERE
`lfv`.`lang_id`=1
AND `p`.`visible` = 1
AND ((`lfv`.`translit` IN ('indejka', 'seld', 'govyadina') AND `fv`.`feature_id`=119))
GROUP BY
`pf`.`product_id`
HAVING
COUNT(*) >=1)
ORDER BY
`b`.`position`\G
# Query 6: 0.06 QPS, 0.01x concurrency, ID 0x2BE109654F5C841C at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.03
# Time range: 2021-04-17T03:23:11 to 2021-04-17T06:41:34
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 665
# Exec time 2 70s 100ms 1s 105ms 100ms 60ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 4 901.82k 1.25k 1.75k 1.36k 1.33k 62.87 1.33k
# id 2 27.94G 42.77M 43.35M 43.02M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`fv`.`id`,
`fv`.`feature_id`,
`fv`.`position`,
`fv`.`to_index`,
`l`.`value`,
`l`.`translit`
FROM
`ok_features_values` AS `fv`
LEFT JOIN `ok_products_features_values` AS `pf` ON `pf`.`value_id`=`fv`.`id`
LEFT JOIN `ok_features` AS `f` ON `f`.`id`=`fv`.`feature_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_lang_features_values` AS `l` ON `l`.`feature_value_id` = `fv`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `pc`.`product_id`=`pf`.`product_id` AND `pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
WHERE
(`fv`.`feature_id` =124 OR `p`.`id` IN (SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `fv`.`id`=`lfv`.`feature_value_id`
WHERE
`lfv`.`lang_id`=1
AND (`lfv`.`translit` IN ('italiya', 'niderlandy', 'frantsiya', 'rossiya', 'belgiya', 'shvetsiya', 'velikobritaniya') AND `fv`.`feature_id`=124)))
AND `p`.`visible`=1
AND `fv`.`feature_id` IN (116, 117, 118, 119, 121, 122, 123, 124)
GROUP BY
`fv`.`id`
ORDER BY
`fv`.`position` ASC,
`l`.`value` ASC\G
# Query 7: 0.05 QPS, 0.00x concurrency, ID 0x0337298D62963C8D at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T02:41:43 to 2021-04-17T06:41:23
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 667
# Exec time 2 67s 100ms 202ms 101ms 100ms 4ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 1 411.99k 541 970 632.49 964.41 103.41 592.07
# id 2 28.02G 42.64M 43.35M 43.02M 42.20M 0.50 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_router_cache'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_router_cache`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`p`.`last_modify`
FROM
`ok_products` AS `p`
LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`p`.`url` AND `r`.`type`="product"
LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `p`.`id` = `pc`.`product_id` AND `pc`.`category_id` IN(139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285, 160, 212, 272, 149, 280, 151, 275, 163, 158, 143, 277, 260, 185, 159, 94, 155, 96, 222, 211, 87)
GROUP BY
`p`.`id`
ORDER BY
`p`.`last_modify` DESC
LIMIT 1\G
# Query 8: 0.04 QPS, 0.00x concurrency, ID 0xA86FE6BC63F14E63 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.09
# Time range: 2021-04-17T02:41:44 to 2021-04-17T06:37:09
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 549
# Exec time 2 62s 100ms 1s 112ms 100ms 100ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 3 808.46k 1.29k 1.84k 1.47k 1.69k 101.10 1.46k
# id 2 22.98G 42.64M 43.33M 42.86M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`b`.`id`,
`b`.`url`,
`b`.`image`,
`b`.`last_modify`,
`b`.`visible`,
`b`.`position`,
`l`.`name`,
`l`.`meta_title`,
`l`.`meta_keywords`,
`l`.`meta_description`,
`l`.`annotation`,
`l`.`description`
FROM
`ok_brands` AS `b`
LEFT JOIN `ok_products` AS `p` ON `p`.`brand_id`=`b`.`id`
LEFT JOIN `ok_lang_brands` AS `l` ON `l`.`brand_id` = `b`.`id` AND `l`.`lang_id` = 1
LEFT JOIN `ok_products_categories` `pc` ON `p`.`id` = `pc`.`product_id`
WHERE
`pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 95 items ...*/)
AND `b`.`visible` = 1
AND `p`.`visible` = 1
AND `p`.`id` IN (SELECT
`pf`.`product_id`
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `pf`.`value_id`=`lfv`.`feature_value_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
WHERE
`lfv`.`lang_id`=1
AND `p`.`visible` = 1
AND ((`lfv`.`translit` IN ('kuritsa', 'tsukkini', 'fosfor', 'glyukozamin') AND `fv`.`feature_id`=119) OR (`lfv`.`translit` IN ('sobaki') AND `fv`.`feature_id`=123))
GROUP BY
`pf`.`product_id`
HAVING
COUNT(*) >=2)
ORDER BY
`b`.`position`\G
# Query 9: 0.04 QPS, 0.00x concurrency, ID 0x250BC011881DFDFF at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T02:42:58 to 2021-04-17T06:40:49
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 518
# Exec time 1 52s 100ms 101ms 100ms 100ms 0 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 1 384.96k 761 761 761 761 0 761
# id 2 21.77G 42.64M 43.35M 43.03M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_router_cache'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_router_cache`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT
`c`.`id`,
`c`.`parent_id`,
`c`.`url`,
`c`.`image`,
`c`.`position`,
`c`.`visible`,
`c`.`external_id`,
`c`.`level_depth`,
`c`.`last_modify`,
`c`.`created`,
`r`.`slug_url`,
`l`.`name`,
`l`.`name_h1`,
`l`.`auto_h1`,
`l`.`meta_title`,
`l`.`meta_keywords`,
`l`.`meta_description`,
`l`.`annotation`,
`l`.`description`,
`l`.`auto_meta_title`,
`l`.`auto_meta_keywords`,
`l`.`auto_meta_desc`,
`l`.`auto_description`
FROM
`ok_categories` AS `c`
LEFT JOIN `ok_lang_categories` AS `l` ON `l`.`category_id` = `c`.`id` AND `l`.`lang_id` = 1
LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`c`.`url` AND `r`.`type`="category"
ORDER BY
`c`.`parent_id`,
`c`.`position`\G
# Query 10: 0.02 QPS, 0.00x concurrency, ID 0x89F0C827D4DEA345 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.04
# Time range: 2021-04-17T03:22:37 to 2021-04-17T06:41:27
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 247
# Exec time 0 26s 100ms 1s 105ms 100ms 67ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 2 490.82k 1.88k 2.37k 1.99k 1.96k 82.20 1.96k
# id 1 10.39G 42.77M 43.35M 43.07M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_router_cache'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_router_cache`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_variants'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_variants`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_currencies'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_currencies`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_variants'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_variants`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`p`.`id`,
`p`.`url`,
`p`.`brand_id`,
`p`.`visible`,
`p`.`position`,
`p`.`created`,
`p`.`featured`,
`p`.`external_id`,
`p`.`rating`,
`p`.`votes`,
`p`.`last_modify`,
`p`.`main_category_id`,
`p`.`main_image_id`,
`r`.`slug_url`,
`l`.`name`,
`l`.`annotation`,
`l`.`special`
FROM
`ok_products` AS `p`
LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`p`.`url` AND `r`.`type`="product"
LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `p`.`id` = `pc`.`product_id` AND `pc`.`category_id` IN(139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id`
LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id`
INNER JOIN (
SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `pf`.`value_id`=`lfv`.`feature_value_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
WHERE
`lfv`.`lang_id`=1
AND `p`.`visible` = 1
AND ((`lfv`.`translit` IN ('ovoschi', 'fazan', 'apelsin', 'mintaj', 'telyatina') AND `fv`.`feature_id`=119))
GROUP BY
product_id
HAVING
COUNT(*) >=1
) AS `products_features` ON `products_features`.`product_id`=`p`.`id`
WHERE
`p`.`visible` = 1
GROUP BY
`p`.`id`
ORDER BY
((SELECT count(`pv`.`id`) FROM ok_variants pv WHERE (`pv`.`stock` IS NULL OR `pv`.`stock`>0) AND `p`.`id` = `pv`.`product_id`)>0) DESC,
`p`.`position` DESC
LIMIT 24\G
# Query 11: 0.02 QPS, 0.00x concurrency, ID 0x231ECE52CF90A96D at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.12
# Time range: 2021-04-17T02:43:00 to 2021-04-17T06:41:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 222
# Exec time 0 26s 100ms 1s 117ms 100ms 119ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 1 403.50k 1.62k 2.19k 1.82k 2.06k 152.30 1.69k
# id 0 9.34G 42.64M 43.35M 43.08M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`fv`.`id`,
`fv`.`feature_id`,
`fv`.`position`,
`fv`.`to_index`,
`l`.`value`,
`l`.`translit`
FROM
`ok_features_values` AS `fv`
LEFT JOIN `ok_products_features_values` AS `pf` ON `pf`.`value_id`=`fv`.`id`
LEFT JOIN `ok_features` AS `f` ON `f`.`id`=`fv`.`feature_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_lang_features_values` AS `l` ON `l`.`feature_value_id` = `fv`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `pc`.`product_id`=`pf`.`product_id` AND `pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 95 items ...*/)
WHERE
(`fv`.`feature_id` =119 OR `p`.`id` IN (SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `fv`.`id`=`lfv`.`feature_value_id`
WHERE
`lfv`.`lang_id`=1
AND (`lfv`.`translit` IN ('kuritsa', 'tsukkini', 'ptitsa') AND `fv`.`feature_id`=119)))
AND (`fv`.`feature_id` =123 OR `p`.`id` IN (SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `fv`.`id`=`lfv`.`feature_value_id`
WHERE
`lfv`.`lang_id`=1
AND (`lfv`.`translit` IN ('sobaki') AND `fv`.`feature_id`=123)))
AND `p`.`visible`=1
AND `fv`.`feature_id` IN (116, 117, 118, 119, 120, 121, 122, 123, 124)
GROUP BY
`fv`.`id`
ORDER BY
`fv`.`position` ASC,
`l`.`value` ASC\G
# Query 12: 0.01 QPS, 0.00x concurrency, ID 0x22E38EEB07E2AF4B at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.04
# Time range: 2021-04-17T02:41:45 to 2021-04-17T06:40:16
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 199
# Exec time 0 21s 100ms 1s 105ms 100ms 63ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 1 305.78k 1.41k 1.78k 1.54k 1.53k 45.01 1.53k
# id 0 8.31G 42.64M 43.34M 42.74M 42.20M 0.50 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_brands'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_brands`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`b`.`id`,
`b`.`url`,
`b`.`image`,
`b`.`last_modify`,
`b`.`visible`,
`b`.`position`,
`l`.`name`,
`l`.`meta_title`,
`l`.`meta_keywords`,
`l`.`meta_description`,
`l`.`annotation`,
`l`.`description`
FROM
`ok_brands` AS `b`
LEFT JOIN `ok_products` AS `p` ON `p`.`brand_id`=`b`.`id`
LEFT JOIN `ok_lang_brands` AS `l` ON `l`.`brand_id` = `b`.`id` AND `l`.`lang_id` = 1
LEFT JOIN `ok_products_categories` `pc` ON `p`.`id` = `pc`.`product_id`
WHERE
`pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
AND `b`.`visible` = 1
AND `p`.`visible` = 1
AND `p`.`id` IN (SELECT
`pf`.`product_id`
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `pf`.`value_id`=`lfv`.`feature_value_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
WHERE
`lfv`.`lang_id`=1
AND `p`.`visible` = 1
AND ((`lfv`.`translit` IN ('nizkozernovoj') AND `fv`.`feature_id`=121) OR (`lfv`.`translit` IN ('supersppremium', 'premium', 'holistic') AND `fv`.`feature_id`=122) OR (`lfv`.`translit` IN ('germaniya', 'kanada', 'belgiya', 'angliya', 'ssha', 'shvetsiya', 'italiya', 'velikobritaniya', 'chehiya', 'frantsiya') AND `fv`.`feature_id`=124))
GROUP BY
`pf`.`product_id`
HAVING
COUNT(*) >=3)
ORDER BY
`b`.`position`\G
# Query 13: 0.02 QPS, 0.00x concurrency, ID 0xCB691BB2F34E8523 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.04
# Time range: 2021-04-17T03:21:59 to 2021-04-17T06:31:32
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 190
# Exec time 0 20s 101ms 1s 106ms 100ms 65ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 1 240.78k 1.24k 1.30k 1.27k 1.26k 28.48 1.26k
# id 0 7.99G 42.77M 43.32M 43.07M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_router_cache'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_router_cache`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_variants'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_variants`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_currencies'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_currencies`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_variants'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_variants`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`p`.`id`,
`p`.`url`,
`p`.`brand_id`,
`p`.`visible`,
`p`.`position`,
`p`.`created`,
`p`.`featured`,
`p`.`external_id`,
`p`.`rating`,
`p`.`votes`,
`p`.`last_modify`,
`p`.`main_category_id`,
`p`.`main_image_id`,
`r`.`slug_url`,
`l`.`name`,
`l`.`annotation`,
`l`.`special`
FROM
`ok_products` AS `p`
LEFT JOIN `ok_router_cache` AS `r` ON `r`.`url`=`p`.`url` AND `r`.`type`="product"
LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `p`.`id` = `pc`.`product_id` AND `pc`.`category_id` IN(139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id`
LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id`
WHERE
`p`.`visible` = 1
AND `p`.`brand_id` IN ('134', '269', '127', '126', '207', '131', '174')
GROUP BY
`p`.`id`
ORDER BY
((SELECT count(`pv`.`id`) FROM ok_variants pv WHERE (`pv`.`stock` IS NULL OR `pv`.`stock`>0) AND `p`.`id` = `pv`.`product_id`)>0) DESC,
`p`.`position` DESC
LIMIT 24\G
# Query 14: 0.02 QPS, 0.00x concurrency, ID 0x4AFBB8E511751400 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T03:22:03 to 2021-04-17T06:25:55
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 182
# Exec time 0 18s 100ms 139ms 101ms 100ms 3ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 0 193.24k 1.02k 1.33k 1.06k 1.04k 23.34 1.04k
# id 0 7.65G 42.77M 43.30M 43.07M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`fv`.`id`,
`fv`.`feature_id`,
`fv`.`position`,
`fv`.`to_index`,
`l`.`value`,
`l`.`translit`
FROM
`ok_features_values` AS `fv`
LEFT JOIN `ok_products_features_values` AS `pf` ON `pf`.`value_id`=`fv`.`id`
LEFT JOIN `ok_features` AS `f` ON `f`.`id`=`fv`.`feature_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_lang_features_values` AS `l` ON `l`.`feature_value_id` = `fv`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `pc`.`product_id`=`pf`.`product_id` AND `pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
WHERE
`p`.`visible`=1
AND `fv`.`feature_id` IN (116, 117, 118, 119, 121, 122, 123, 124)
AND `pf`.`product_id` IN (SELECT id FROM ok_products WHERE brand_id IN ('134', '271', '123', '269', '227', '226', '121', '142'))
GROUP BY
`fv`.`id`
ORDER BY
`fv`.`position` ASC,
`l`.`value` ASC\G
# Query 15: 0.01 QPS, 0.00x concurrency, ID 0x0CE9C8D536AEDC50 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T02:41:47 to 2021-04-17T06:21:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 161
# Exec time 0 16s 100ms 102ms 101ms 100ms 0 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 1 352.78k 2.09k 2.43k 2.19k 2.16k 36.05 2.16k
# id 0 6.72G 42.64M 43.29M 42.73M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`fv`.`id`,
`fv`.`feature_id`,
`fv`.`position`,
`fv`.`to_index`,
`l`.`value`,
`l`.`translit`
FROM
`ok_features_values` AS `fv`
LEFT JOIN `ok_products_features_values` AS `pf` ON `pf`.`value_id`=`fv`.`id`
LEFT JOIN `ok_features` AS `f` ON `f`.`id`=`fv`.`feature_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_lang_features_values` AS `l` ON `l`.`feature_value_id` = `fv`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `pc`.`product_id`=`pf`.`product_id` AND `pc`.`category_id` IN (139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
WHERE
(`fv`.`feature_id` =119 OR `p`.`id` IN (SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `fv`.`id`=`lfv`.`feature_value_id`
WHERE
`lfv`.`lang_id`=1
AND (`lfv`.`translit` IN ('sardina') AND `fv`.`feature_id`=119)))
AND (`fv`.`feature_id` =122 OR `p`.`id` IN (SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `fv`.`id`=`lfv`.`feature_value_id`
WHERE
`lfv`.`lang_id`=1
AND (`lfv`.`translit` IN ('supersppremium', 'premium', 'holistic') AND `fv`.`feature_id`=122)))
AND (`fv`.`feature_id` =124 OR `p`.`id` IN (SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `fv`.`id`=`lfv`.`feature_value_id`
WHERE
`lfv`.`lang_id`=1
AND (`lfv`.`translit` IN ('italiya', 'frantsiya', 'germaniya', 'angliya', 'ssha', 'kanada', 'velikobritaniya', 'belgiya', 'chehiya') AND `fv`.`feature_id`=124)))
AND `p`.`visible`=1
AND `fv`.`feature_id` IN (116, 117, 118, 119, 121, 122, 123, 124)
GROUP BY
`fv`.`id`
ORDER BY
`fv`.`position` ASC,
`l`.`value` ASC\G
# Query 16: 0.01 QPS, 0.00x concurrency, ID 0x6A20DE8370487539 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.19
# Time range: 2021-04-17T02:43:14 to 2021-04-17T06:40:30
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 125
# Exec time 0 15s 100ms 2s 120ms 100ms 150ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 0 49.80k 408 408 408 408 0 408
# id 0 5.25G 42.64M 43.35M 42.99M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_pages'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_pages`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_pages'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_pages`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT DISTINCT
`p`.`id`,
`p`.`url`,
`p`.`visible`,
`p`.`position`,
`p`.`last_modify`,
`l`.`name`,
`l`.`name_h1`,
`l`.`meta_title`,
`l`.`meta_keywords`,
`l`.`meta_description`,
`l`.`description`
FROM
`ok_pages` AS `p`
LEFT JOIN `ok_lang_pages` AS `l` ON `l`.`page_id` = `p`.`id` AND `l`.`lang_id` = 1
WHERE
`p`.`visible` = 1
ORDER BY
`p`.`position` ASC\G
# Query 17: 0.01 QPS, 0.00x concurrency, ID 0x3B8BCFEB280BCB4F at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T02:41:54 to 2021-04-17T06:38:42
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 146
# Exec time 0 15s 100ms 102ms 100ms 100ms 0 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 0 14.73k 97 114 103.34 112.70 4.99 102.22
# id 0 6.13G 42.64M 43.34M 43.01M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_modules'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_modules`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT
enabled
FROM
`ok_modules`
WHERE
vendor = 'OkayCMS'
AND module_name = 'PayKeeper'\G
# Query 18: 0.01 QPS, 0.00x concurrency, ID 0xC16AF51FC8058CF6 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2021-04-17T03:24:03 to 2021-04-17T06:41:21
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 121
# Exec time 0 12s 100ms 101ms 101ms 100ms 0 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 0 195.03k 1.57k 1.99k 1.61k 1.61k 71.87 1.53k
# id 0 5.09G 42.77M 43.35M 43.07M 42.20M 0 42.20M
# String:
# Databases va290498_zoo
# Hosts localhost
# Users va290498_zoo
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_products'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_products`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_categories'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_categories`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_products_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_products_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_lang_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_lang_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_features_values'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_features_values`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_variants'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_variants`\G
# SHOW TABLE STATUS FROM `va290498_zoo` LIKE 'ok_currencies'\G
# SHOW CREATE TABLE `va290498_zoo`.`ok_currencies`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT
floor(min(IF(`pv`.`currency_id`=0 OR `c`.`id` is null,`pv`.`price`, `pv`.`price`*`c`.`rate_to`/`c`.`rate_from`)*1)) AS `min`,
floor(max(IF(`pv`.`currency_id`=0 OR `c`.`id` is null,`pv`.`price`, `pv`.`price`*`c`.`rate_to`/`c`.`rate_from`)*1)) AS `max`
FROM
`ok_products` AS `p`
LEFT JOIN `ok_lang_products` AS `l` ON `l`.`product_id` = `p`.`id` AND `l`.`lang_id` = 1
INNER JOIN `ok_products_categories` AS `pc` ON `p`.`id` = `pc`.`product_id` AND `pc`.`category_id` IN(139, 165, 302, 282, 130, 270, 265, 197, 131, 129, 189, 133, 190, 89, 91, 152, 267, 88, 144, 285/*... omitted 20 items ...*/)
INNER JOIN (
SELECT
DISTINCT(`pf`.`product_id`)
FROM
`ok_products_features_values` AS `pf`
LEFT JOIN `ok_lang_features_values` AS `lfv` ON `pf`.`value_id`=`lfv`.`feature_value_id`
LEFT JOIN `ok_products` AS `p` ON `p`.`id`=`pf`.`product_id`
LEFT JOIN `ok_features_values` AS `fv` ON `fv`.`id`=`pf`.`value_id`
WHERE
`lfv`.`lang_id`=1
AND `p`.`visible` = 1
AND ((`lfv`.`translit` IN ('italiya', 'niderlandy', 'frantsiya', 'rossiya', 'belgiya', 'shvetsiya') AND `fv`.`feature_id`=124))
GROUP BY
product_id
HAVING
COUNT(*) >=1
) AS `products_features` ON `products_features`.`product_id`=`p`.`id`
LEFT JOIN `ok_variants` AS `pv` ON `pv`.`product_id` = `p`.`id`
LEFT JOIN `ok_currencies` AS `c` ON `c`.`id`=`pv`.`currency_id`
WHERE
`p`.`visible` = 1\G
.......