Медленно открываются страницы с товаром

Reading from STDIN ...

# 34.8s user time, 3.8s system time, 32.76M rss, 111.54M vsz
# Current date: Wed Apr 19 15:39:08 2017
# Hostname: vader3.beget.ru
# Files: STDIN
# Overall: 400 total, 74 unique, 0.03 QPS, 0.00x concurrency _____________
# Time range: 2017-04-19T11:43:25 to 2017-04-19T15:36:30
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time            43s   100ms      1s   109ms   100ms    57ms   100ms
# Lock time              0       0       0       0       0       0       0
# Query size       311.01k      16   5.53k  796.17   2.27k  647.00  755.64
# id                 4.56G  11.40M  12.28M  11.68M  11.87M 228.17k  11.30M

# Profile
# Rank Query ID           Response time Calls R/Call V/M   Item
# ==== ================== ============= ===== ====== ===== ===============
#    1 0xBDE5344E78116E2A 14.6705 33.8%   124 0.1183  0.07 SELECT modx_site_htmlsnippets
#    2 0xB6F5AECA3DCA931C  2.8183  6.5%    28 0.1007  0.00 SELECT modx_site_content modx_ms?_products modx_ms?_vendors
#    3 0x8541FC5558A3F262  1.8088  4.2%    18 0.1005  0.00 SELECT modx_ms?_product_options modx_ms?_options modx_categories
#    4 0x4AA5E035B715F8D3  1.5063  3.5%    15 0.1004  0.00 SELECT modx_register_messages modx_register_topics
#    5 0x42864619A7362314  1.3062  3.0%    13 0.1005  0.00 SELECT modx_site_plugin_events modx_site_plugins
#    6 0xD9670D0CFA9DCCE4  1.3061  3.0%    10 0.1306  0.03 SELECT modx_extension_packages modx_namespaces
#    7 0xE7C462E75B08AC19  1.2071  2.8%    12 0.1006  0.00 SELECT modx_site_content
#    8 0x0A77B201CE42B30C  1.2054  2.8%    12 0.1005  0.00 SELECT modx_system_settings
#    9 0x382EE35D8837CC98  0.9041  2.1%     9 0.1005  0.00 SELECT modx_site_tmplvar_contentvalues
#   10 0x1FE28C277028D4C7  0.8047  1.9%     8 0.1006  0.00 SELECT modx_site_content
#   11 0x0D91CA04364D6E99  0.8042  1.9%     6 0.1340  0.04 SELECT modx_session
#   12 0xEF8F68A880F50AEC  0.7048  1.6%     7 0.1007  0.00 SELECT modx_ms?_product_categories
#   13 0x41145E5C309F206F  0.7034  1.6%     5 0.1407  0.04 SELECT modx_site_tmplvars modx_media_sources
#   14 0x3F696B7F2EB44AC0  0.7033  1.6%     7 0.1005  0.00 SELECT modx_register_queues
#   15 0x9A067AFC7F4AFCFC  0.7029  1.6%     7 0.1004  0.00 SELECT modx_users
#   16 0xBE2A544E72783B29  0.6027  1.4%     5 0.1205  0.01 SELECT modx_site_content modx_ms?_products modx_ms?_product_categories modx_ms?_vendors modx_site_content
#   17 0xE27F53EC879E9C1D  0.6023  1.4%     6 0.1004  0.00 SELECT modx_site_content
#   18 0x65F26B26A439B841  0.5027  1.2%     5 0.1005  0.00 SET
#   19 0xFD5EE8778F456352  0.4031  0.9%     4 0.1008  0.00 SELECT modx_documentgroup_names modx_site_tmplvar_access
#   20 0xE47015294C449561  0.4019  0.9%     4 0.1005  0.00 SELECT modx_context_setting
# MISC 0xMISC              9.7465 22.4%    95 0.1026   0.0 <54 ITEMS>

# Query 1: 0.01 QPS, 0.00x concurrency, ID 0xBDE5344E78116E2A at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.07
# Time range: 2017-04-19T11:43:29 to 2017-04-19T15:12:44
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         31     124
# Exec time     33     15s   100ms      1s   118ms   100ms    94ms   100ms
# Lock time      0       0       0       0       0       0       0       0
# Query size    29  92.48k     737     765  763.71  755.64    8.30  755.64
# id            30   1.39G  11.40M  12.19M  11.52M  11.30M 113.84k  11.30M
# String:
# Databases    givi61gq_modx1
# Hosts        localhost
# Users        givi61gq_modx1
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s  #
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `givi61gq_modx1` LIKE 'modx_site_htmlsnippets'\G
#    SHOW CREATE TABLE `givi61gq_modx1`.`modx_site_htmlsnippets`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `modChunk`.`id` AS `modChunk_id`, `modChunk`.`source` AS `modChunk_source`, `modChunk`.`property_preprocess` AS `modChunk_property_preprocess`, `modChunk`.`name` AS `modChunk_name`, `modChunk`.`description` AS `modChunk_description`, `modChunk`.`editor_type` AS `modChunk_editor_type`, `modChunk`.`category` AS `modChunk_category`, `modChunk`.`cache_type` AS `modChunk_cache_type`, `modChunk`.`snippet` AS `modChunk_snippet`, `modChunk`.`locked` AS `modChunk_locked`, `modChunk`.`properties` AS `modChunk_properties`, `modChunk`.`static` AS `modChunk_static`, `modChunk`.`static_file` AS `modChunk_static_file` FROM `modx_site_htmlsnippets` AS `modChunk` WHERE  ( `modChunk`.`id` = 'ShopPostFullCollInfotpl' OR `modChunk`.`name` = 'ShopPostFullCollInfotpl' )\G

# Query 2: 0.01 QPS, 0.00x concurrency, ID 0xB6F5AECA3DCA931C at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-04-19T11:43:27 to 2017-04-19T12:51:12
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          7      28
# Exec time      6      3s   100ms   105ms   101ms   100ms       0   100ms
# Lock time      0       0       0       0       0       0       0       0
# Query size    20  64.02k   2.29k   2.30k   2.29k   2.27k    0.00   2.27k
# id             6 322.53M  11.40M  11.64M  11.52M  11.30M       0  11.30M
# String:
# Databases    givi61gq_modx1
# Hosts        localhost
# Users        givi61gq_modx1
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `givi61gq_modx1` LIKE 'modx_site_content'\G
#    SHOW CREATE TABLE `givi61gq_modx1`.`modx_site_content`\G
#    SHOW TABLE STATUS FROM `givi61gq_modx1` LIKE 'modx_ms2_products'\G
#    SHOW CREATE TABLE `givi61gq_modx1`.`modx_ms2_products`\G
#    SHOW TABLE STATUS FROM `givi61gq_modx1` LIKE 'modx_ms2_vendors'\G
#    SHOW CREATE TABLE `givi61gq_modx1`.`modx_ms2_vendors`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT SQL_CALC_FOUND_ROWS `msProduct`.`id`, `msProduct`.`type`, `msProduct`.`contentType`, `msProduct`.`pagetitle`, `msProduct`.`longtitle`, `msProduct`.`description`, `msProduct`.`alias`, `msProduct`.`link_attributes`, `msProduct`.`published`, `msProduct`.`pub_date`, `msProduct`.`unpub_date`, `msProduct`.`parent`, `msProduct`.`isfolder`, `msProduct`.`introtext`, `msProduct`.`richtext`, `msProduct`.`template`, `msProduct`.`menuindex`, `msProduct`.`searchable`, `msProduct`.`cacheable`, `msProduct`.`createdby`, `msProduct`.`createdon`, `msProduct`.`editedby`, `msProduct`.`editedon`, `msProduct`.`deleted`, `msProduct`.`deletedon`, `msProduct`.`deletedby`, `msProduct`.`publishedon`, `msProduct`.`publishedby`, `msProduct`.`menutitle`, `msProduct`.`donthit`, `msProduct`.`privateweb`, `msProduct`.`privatemgr`, `msProduct`.`content_dispo`, `msProduct`.`hidemenu`, `msProduct`.`class_key`, `msProduct`.`context_key`, `msProduct`.`content_type`, `msProduct`.`uri`, `msProduct`.`uri_override`, `msProduct`.`hide_children_in_tree`, `msProduct`.`show_in_tree`, `msProduct`.`properties`, `Data`.`article`, `Data`.`price`, `Data`.`old_price`, `Data`.`weight`, `Data`.`image`, `Data`.`thumb`, `Data`.`vendor`, `Data`.`made_in`, `Data`.`new`, `Data`.`popular`, `Data`.`favorite`, `Data`.`tags`, `Data`.`color`, `Data`.`size`, `Data`.`source`, `Vendor`.`name` AS `vendor.name`, `Vendor`.`resource` AS `vendor.resource`, `Vendor`.`country` AS `vendor.country`, `Vendor`.`logo` AS `vendor.logo`, `Vendor`.`address` AS `vendor.address`, `Vendor`.`phone` AS `vendor.phone`, `Vendor`.`fax` AS `vendor.fax`, `Vendor`.`email` AS `vendor.email`, `Vendor`.`description` AS `vendor.description`, `Vendor`.`properties` AS `vendor.properties` FROM `modx_site_content` AS `msProduct` LEFT JOIN `modx_ms2_products` `Data` ON `msProduct`.`id` =  `Data`.`id` LEFT JOIN `modx_ms2_vendors` `Vendor` ON Data.vendor=Vendor.id WHERE  ( `msProduct`.`class_key` = 'msProduct' AND `msProduct`.`id` IN (554) AND `msProduct`.`parent` IN (239,497,495,496,498,547,565,566,568,569,592,594,570,571,572,577,578,579,588,549/*... omitted 33 items ...*/) AND `msProduct`.`published` = 1 AND `msProduct`.`deleted` = 0 )  GROUP BY msProduct.id ORDER BY msProduct.id ASC LIMIT 10\G

# Query 3: 0.00 QPS, 0.00x concurrency, ID 0x8541FC5558A3F262 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-04-19T11:43:27 to 2017-04-19T15:12:47
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          4      18
# Exec time      4      2s   100ms   101ms   100ms   100ms       0   100ms
# Lock time      0       0       0       0       0       0       0       0
# Query size     2   9.21k     524     524     524     524       0     524
# id             4 208.18M  11.40M  12.19M  11.57M  11.87M 181.87k  11.30M
# String:
# Databases    givi61gq_modx1
# Hosts        localhost
# Users        givi61gq_modx1
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `givi61gq_modx1` LIKE 'modx_ms2_product_options'\G
#    SHOW CREATE TABLE `givi61gq_modx1`.`modx_ms2_product_options`\G
#    SHOW TABLE STATUS FROM `givi61gq_modx1` LIKE 'modx_ms2_options'\G
#    SHOW CREATE TABLE `givi61gq_modx1`.`modx_ms2_options`\G
#    SHOW TABLE STATUS FROM `givi61gq_modx1` LIKE 'modx_categories'\G
#    SHOW CREATE TABLE `givi61gq_modx1`.`modx_categories`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `msOption`.`id`, `msOption`.`key`, `msOption`.`caption`, `msOption`.`description`, `msOption`.`measure_unit`, `msOption`.`category`, `msOption`.`type`, `msOption`.`properties`, `msProductOption`.`product_id`, `msProductOption`.`value`, Category.category AS category_name FROM `modx_ms2_product_options` AS `msProductOption` RIGHT JOIN `modx_ms2_options` `msOption` ON msProductOption.key=msOption.key LEFT JOIN `modx_categories` `Category` ON Category.id=msOption.category WHERE `msProductOption`.`product_id` = '549'\G

# Query 4: 0.00 QPS, 0.00x concurrency, ID 0x4AA5E035B715F8D3 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-04-19T11:53:59 to 2017-04-19T15:33:40
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          3      15
# Exec time      3      2s   100ms   101ms   100ms   100ms       0   100ms
# Lock time      0       0       0       0       0       0       0       0
# Query size     1   4.67k     319     319     319     319       0     319
# id             3 178.41M  11.43M  12.27M  11.89M  11.87M 283.51k  11.30M
# String:
# Databases    givi61gq_modx1
# Hosts        localhost
# Users        givi61gq_modx1
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `givi61gq_modx1` LIKE 'modx_register_messages'\G
#    SHOW CREATE TABLE `givi61gq_modx1`.`modx_register_messages`\G
#    SHOW TABLE STATUS FROM `givi61gq_modx1` LIKE 'modx_register_topics'\G
#    SHOW CREATE TABLE `givi61gq_modx1`.`modx_register_topics`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT msg.* FROM `modx_register_messages` msg JOIN `modx_register_topics` topic ON msg.valid <= '2017-04-19 15:21:50' AND (topic.name = '/resource/d1c38a09acc34845c6be3a127a5aacaf' OR (topic.name = '/resource/' AND msg.id = 'd1c38a09acc34845c6be3a127a5aacaf')) AND topic.id = msg.topic ORDER BY msg.created ASC LIMIT 5\G