а какой sql в showLog?
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.inStock, Data.opt_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 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.pagetitle LIKE '%товар%' OR msProduct.content LIKE '%товар%' OR Data.article LIKE '%товар%' AND msProduct.parent IN (15) AND msProduct.published = 1 AND msProduct.deleted = 0 ) GROUP BY msProduct.id ORDER BY msProduct.menuindex ASC LIMIT 36