Медленно открываются страницы с товаром
Подскажите, пожалуйста, почему страницы открываются по 30-40 секунд? Только в minishop2, остальные страницы на сайте работают быстро, админка работает быстро. Никаких скриптов дополнительных не ставил. Проблема только на одном сайте, другие с minishop2 летают.
Вот что ответил суппорт хостинга:
«Больших затыков нет, но все равно страница формируется долго, для формирования страницы используется 115501 обращения к файлу /home/g/givi61gq/lifetimekidsrooms.ru/public_html/core/cache/lexicon_topics/lexicon/ru/core/tv_widget.cache.php возможно где-то идет зацикливание, обратитесь к разработчику вашего сайта.»
Связано ли это с минишопом? Буду благодарен за любую информацию!
Логи
Вот что ответил суппорт хостинга:
«Больших затыков нет, но все равно страница формируется долго, для формирования страницы используется 115501 обращения к файлу /home/g/givi61gq/lifetimekidsrooms.ru/public_html/core/cache/lexicon_topics/lexicon/ru/core/tv_widget.cache.php возможно где-то идет зацикливание, обратитесь к разработчику вашего сайта.»
Связано ли это с минишопом? Буду благодарен за любую информацию!
Логи
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