После миграции c Shopkeeper на miniShop долго грузится сайт

Делал миграцию на 3 сайтах по инструкции bezumkin.ru/modx/minishop2/solutions/2049/. На двух все работает отлично. А вот на одном долго грузится вывод товаров, причем только, когда подключаю TV
0.0001130: pdoTools loaded.
0.0010719: Conditions prepared
0.0000298: xPDO query object created
0.0006380: Included list of tvs: picture_url_product, availability_product, isPromo, work_width_sel, depth_sel
0.0001700: leftJoined msProductData as Data
0.0001001: leftJoined msVendor as Vendor
0.0000961: leftJoined modTemplateVarResource as TVpicture_url_product
0.0000930: leftJoined modTemplateVarResource as TVavailability_product
0.0000911: leftJoined modTemplateVarResource as TVispromo
0.0000911: leftJoined modTemplateVarResource as TVwork_width_sel
0.0001040: leftJoined modTemplateVarResource as TVdepth_sel
0.0000050: Grouped by msProduct.id
0.0000818: Added selection of msProduct: SQL_CALC_FOUND_ROWS `id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `alias_visible`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`
0.0000501: Added selection of msProductData: `article`, `price`, `old_price`, `weight`, `image`, `thumb`, `vendor`, `made_in`, `new`, `popular`, `favorite`, `tags`, `color`, `size`, `source`, `currency_id`, `currency_set_id`, `msmc_price`, `msmc_old_price`
0.0000372: Added selection of msVendor: `name` AS `vendor.name`, `resource` AS `vendor.resource`, `country` AS `vendor.country`, `logo` AS `vendor.logo`, `address` AS `vendor.address`, `phone` AS `vendor.phone`, `fax` AS `vendor.fax`, `email` AS `vendor.email`, `description` AS `vendor.description`, `properties` AS `vendor.properties`
0.0000091: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `picture_url_product`
0.0000072: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `availability_product`
0.0000060: Added selection of modTemplateVarResource: IFNULL(`value`, '0') AS `isPromo`
0.0000050: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `work_width_sel`
0.0000050: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `depth_sel`
0.0000470: Replaced TV conditions
0.0010481: Processed additional conditions
0.0012670: Added where condition: class_key=msProduct, msProduct.parent:IN(2209,2648,4233,4261,4266,4270,5306,5314,5318,5323,5330,5345,5352,5358,2649,2657,2650,2651,2652,2653,2654,2655,2656,2658,2659,2660,2661,4150,4234,4237,4249,4260,4235,4236,4238,4239,4240,4242,4243,4244,4245,4246,4247,4248,4250,4256,4258,4252,4259,4255,4251,4254,4253,4257,4262,4263,4267,4268,4269,4265,4271,4272,4273,4274,4275,4276,4277,4278,4279,4280,4281,5307,5308,5309,5310,5311,5312,5313,5315,5316,5317,5319,5320,5321,5322,5324,5325,5326,5327,5328,5329,5331,5332,5333,5334,5335,5336,5337,5338,5339,5340,5341,5342,5343,5344,5346,5347,5348,5349,5350,5351,5353,5354,5355,5356,5357,5359,5360,5361,5362,5363,5364,5365,5366,5367,5368,5369,5370), msProduct.published=1, msProduct.deleted=0, msProduct.isfolder=0
0.0000069: Replaced TV conditions
0.0000820: Sorted by msProduct.menuindex, ASC
0.0000021: Limited to 60, offset 0
0.0004020: SQL prepared "SELECT SQL_CALC_FOUND_ROWS `msProduct`.`id`, `msProduct`.`type`, `msProduct`.`contentType`, `msProduct`.`pagetitle`, `msProduct`.`longtitle`, `msProduct`.`description`, `msProduct`.`alias`, `msProduct`.`alias_visible`, `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`, `Data`.`currency_id`, `Data`.`currency_set_id`, `Data`.`msmc_price`, `Data`.`msmc_old_price`, `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`, IFNULL(`TVpicture_url_product`.`value`, '') AS `picture_url_product`, IFNULL(`TVavailability_product`.`value`, '') AS `availability_product`, IFNULL(`TVispromo`.`value`, '0') AS `isPromo`, IFNULL(`TVwork_width_sel`.`value`, '') AS `work_width_sel`, IFNULL(`TVdepth_sel`.`value`, '') AS `depth_sel` FROM `modxlocal_site_content` AS `msProduct` LEFT JOIN `modxlocal_ms2_products` `Data` ON `msProduct`.`id` =  `Data`.`id` LEFT JOIN `modxlocal_ms2_vendors` `Vendor` ON Data.vendor=Vendor.id LEFT JOIN `modxlocal_site_tmplvar_contentvalues` `TVpicture_url_product` ON `TVpicture_url_product`.`contentid` = `msProduct`.`id` AND `TVpicture_url_product`.`tmplvarid` = 7 LEFT JOIN `modxlocal_site_tmplvar_contentvalues` `TVavailability_product` ON `TVavailability_product`.`contentid` = `msProduct`.`id` AND `TVavailability_product`.`tmplvarid` = 10 LEFT JOIN `modxlocal_site_tmplvar_contentvalues` `TVispromo` ON `TVispromo`.`contentid` = `msProduct`.`id` AND `TVispromo`.`tmplvarid` = 14 LEFT JOIN `modxlocal_site_tmplvar_contentvalues` `TVwork_width_sel` ON `TVwork_width_sel`.`contentid` = `msProduct`.`id` AND `TVwork_width_sel`.`tmplvarid` = 22 LEFT JOIN `modxlocal_site_tmplvar_contentvalues` `TVdepth_sel` ON `TVdepth_sel`.`contentid` = `msProduct`.`id` AND `TVdepth_sel`.`tmplvarid` = 23 WHERE  ( `msProduct`.`class_key` = 'msProduct' AND `msProduct`.`parent` IN (2209,2648,4233,4261,4266,4270,5306,5314,5318,5323,5330,5345,5352,5358,2649,2657,2650,2651,2652,2653,2654,2655,2656,2658,2659,2660,2661,4150,4234,4237,4249,4260,4235,4236,4238,4239,4240,4242,4243,4244,4245,4246,4247,4248,4250,4256,4258,4252,4259,4255,4251,4254,4253,4257,4262,4263,4267,4268,4269,4265,4271,4272,4273,4274,4275,4276,4277,4278,4279,4280,4281,5307,5308,5309,5310,5311,5312,5313,5315,5316,5317,5319,5320,5321,5322,5324,5325,5326,5327,5328,5329,5331,5332,5333,5334,5335,5336,5337,5338,5339,5340,5341,5342,5343,5344,5346,5347,5348,5349,5350,5351,5353,5354,5355,5356,5357,5359,5360,5361,5362,5363,5364,5365,5366,5367,5368,5369,5370) AND `msProduct`.`published` = 1 AND `msProduct`.`deleted` = 0 AND `msProduct`.`isfolder` = 0 )  GROUP BY msProduct.id ORDER BY msProduct.menuindex ASC LIMIT 60 "
5.6989260: SQL executed
0.0001812: Total rows: 106
0.0005510: Rows fetched
0.0003698: Returning raw data
0.0021882: Checked the active modifiers
0.0052578: Loaded "modChunk" with name "product-item-sel"
0.0398130: Time to load products options
5.8039079: Total time
12 582 912: Memory usage
0.0009749: pdoTools loaded
0.0002050: Created inline "modChunk" with name "f7da63f2d337d08ca9dcacc531069c1e"
0.0061219: Loaded "modSnippet" with name "msProducts"
5.8159230: Created inline "modChunk" with name "5412949f8419d87e4477caa8ddf011d6"
0.0001521: Created inline "modChunk" with name "4f3e5113475c9912619244e9a35de906"
0.0001531: Created inline "modChunk" with name "2705f364c1156b49778eecee9a2b4f18"
0.0001359: Created inline "modChunk" with name "70824ca308e06c8e375e53759cd03674"
0.0001330: Created inline "modChunk" with name "e6747421ac951eec87076a3f44c6a184"
5.8238380: Total time
12 582 912: Memory usage
Наверно что-то не то с запросом к БД с этими TV… Буду благодарен за любую помощь.
Дмитрий
02 октября 2021, 23:04
modx.pro
408
0

Комментарии: 2

Наумов Алексей
04 октября 2021, 10:58
0
У кого-то здесь недавно была схожая проблема. Оказалось, что при переносе сайта не создались индексы в БД. Стоит посмотреть, есть ли они у используемых таблиц.
    Дмитрий
    04 октября 2021, 12:32
    0
    Спасибо огромное!!! Действительно, в этом и была проблема проблема.
    Авторизуйтесь или зарегистрируйтесь, чтобы оставлять комментарии.
    2