2024-03-29 02:58:22 [USER WARNING:]Error found while excuting this SQL statement: SELECT COUNT(*) AS count FROM wm_products AS p
LEFT JOIN wm_products_description AS pd ON p.product_id = pd.product_id
LEFT JOIN wm_categories AS categories ON p.cat_id = categories.cat_id
LEFT JOIN wm_categories_description AS categories_description ON categories.cat_id = categories_description.cat_id AND pd.language = categories_description.language
LEFT JOIN wm_products_to_cats AS products_to_cats ON products_to_cats.product_id = p.product_id
WHERE (p.cat_id IN () OR products_to_cats.cat_id IN ())
AND pd.language = 'zh-CN' and pd.status>0
group by p.product_id ORDER BY p.product_id DESC,p.sort_order ASC,hits DESC LIMIT 1 [code:512] /www/wwwroot/cntianhui/includes/classes/db.cls.php[line:240]
2024-03-29 02:58:22 [USER WARNING:]Error found while excuting this SQL statement: SELECT COUNT(*) AS _temp_cnt FROM (SELECT p.* FROM wm_products AS p
LEFT JOIN wm_products_description AS pd ON p.product_id = pd.product_id
LEFT JOIN wm_categories AS categories ON p.cat_id = categories.cat_id
LEFT JOIN wm_categories_description AS categories_description ON categories.cat_id = categories_description.cat_id AND pd.language = categories_description.language
LEFT JOIN wm_products_to_cats AS products_to_cats ON products_to_cats.product_id = p.product_id
WHERE (p.cat_id IN () OR products_to_cats.cat_id IN ())
AND pd.language = 'zh-CN' and pd.status>0
group by p.product_id) AS _temp_table[code:512] /www/wwwroot/cntianhui/includes/classes/db.cls.php[line:240]
2024-03-29 02:58:22 [USER WARNING:]Error found while excuting this SQL statement: SELECT p.*,p.product_id as id,pd.*,categories_description.name AS cat_name
,categories.other_dir,categories.filetype,categories.file_name as cat_file_name
FROM wm_products AS p
LEFT JOIN wm_products_description AS pd ON p.product_id = pd.product_id
LEFT JOIN wm_categories AS categories ON p.cat_id = categories.cat_id
LEFT JOIN wm_categories_description AS categories_description ON categories.cat_id = categories_description.cat_id AND pd.language = categories_description.language
LEFT JOIN wm_products_to_cats AS products_to_cats ON products_to_cats.product_id = p.product_id
WHERE (p.cat_id IN () OR products_to_cats.cat_id IN ())
AND pd.language = 'zh-CN' and pd.status>0
group by p.product_id ORDER BY p.product_id DESC,p.sort_order ASC,hits DESC LIMIT 12 OFFSET 0[code:512] /www/wwwroot/cntianhui/includes/classes/db.cls.php[line:240]
共: 条