Миша
0.0000460: pdoTools loaded.
0.0000892: Conditions prepared
0.0000150: xPDO query object created
0.0001781: Included list of tvs: instok
0.0000880: leftJoined msProductData as Data
0.0000570: leftJoined msVendor as Vendor
0.0000560: leftJoined modTemplateVarResource as TVinstok
0.0000010: Grouped by msProduct.id
0.0000648: Added selection of msProduct: SQL_CALC_FOUND_ROWS id, type, contentType, pagetitle, longtitle, description, alias, 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.0000350: Added selection of msProductData: article, price, old_price, weight, image, thumb, vendor, made_in, new, popular, favorite, tags, color, size, source
0.0000360: 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.0000060: Added selection of modTemplateVarResource: IFNULL(value, 'В наличии') AS instok
0.0000079: Replaced TV conditions
0.0000150: Processed additional conditions
0.0001121: Added where condition: class_key=msProduct, tv.TVinstok.value:LIKE=%Скоро в продаже%, msProduct.published=1, msProduct.deleted=0
0.0000021: Replaced TV conditions
0.0000329: Sorted by msProduct.id, ASC
0.0000021: Limited to 20, offset 0
0.0001500: SQL prepared "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, IFNULL(TVinstok.value, 'В наличии') AS instok 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 LEFT JOIN modx_site_tmplvar_contentvalues TVinstok ON TVinstok.contentid = msProduct.id AND TVinstok.tmplvarid = 2 WHERE ( msProduct.class_key = 'msProduct' AND tv.TVinstok LIKE '%Скоро в продаже%' AND msProduct.published = 1 AND msProduct.deleted = 0 ) GROUP BY msProduct.id ORDER BY msProduct.id ASC LIMIT 20 "
0.0002880: Could not process query, error #1054: Unknown column 'tv.TVinstok' in 'where clause'
0.0013561: Total time
6 291 456: Memory usage