2023-09-23 04:29:46 [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
ORDER BY p.sort_order=0 asc,p.sort_order ASC,p.product_id DESC LIMIT 1 [code:512] /var/www/wwwroot/web27348/wwwroot/includes/classes/db.cls.php[line:240]
2023-09-23 04:29:46 [USER WARNING:]Error found while excuting this SQL statement: SELECT COUNT(*) as _temp_cnt 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
[code:512] /var/www/wwwroot/web27348/wwwroot/includes/classes/db.cls.php[line:240]
2023-09-23 04:29:46 [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.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
ORDER BY p.sort_order=0 asc,p.sort_order ASC,p.product_id DESC LIMIT 12 OFFSET 0[code:512] /var/www/wwwroot/web27348/wwwroot/includes/classes/db.cls.php[line:240]