
=============================================================================
Time:2020-12-28 23:17:39
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`Creat' at line 1
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%'%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2020-12-28 23:17:39
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%'' at line 1
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%'%'
=============================================================================
Time:2020-12-28 23:17:41
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`Cre' at line 1
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%'--%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2020-12-28 23:17:41
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--%'' at line 1
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%'--%'
=============================================================================
Time:2020-12-28 23:17:42
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/*%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`Cre' at line 1
sql:SELECT a.*,b.`CategoryName`,b.`Visible` AS `CategoryVisible`,b.`ParentID`,c.`CategoryName` AS `ParentName`,c.`Visible` AS `ParentVisible`,d.`AverageStar`,d.`TotalNO` FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%'/*%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2020-12-28 23:17:42
Type:sql error
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/*%'' at line 1
sql:SELECT COUNT(*) FROM `product` a LEFT JOIN `category` b ON a.`CategoryID`=b.`CategoryID` LEFT JOIN `category` c ON b.`ParentID`=c.`CategoryID` LEFT JOIN (SELECT `ProductID`,(SUM(`Stars`) / COUNT(*)) AS `AverageStar`,COUNT(*) AS `TotalNO`,`CreatedTime` FROM `comment` WHERE `CreatedTime`<=date(now()) GROUP BY `ProductID`) d ON a.`ProductID`=d.`ProductID` WHERE a.`Visible`='1' AND b.`Visible`='1' AND (c.`Visible`='1' OR b.`ParentID`='0') AND a.`ProductName` LIKE '%'/*%'