
=============================================================================
Time:2024-01-06 05:58:27
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 '-var_dump(md5(298402691))-'%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`Or' 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 '%'-var_dump(md5(298402691))-'%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2024-01-06 05:58:27
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 '-var_dump(md5(298402691))-'%'' 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 '%'-var_dump(md5(298402691))-'%'
=============================================================================
Time:2024-01-06 05:58:34
Type:sql error
Message:
XPATH syntax error: '~114c094ff27cde86959ab71ed5b941d'
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 '%123456'and/**/extractvalue(1,concat(char(126),md5(1455066758)))and'%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2024-01-06 05:58:34
Type:sql error
Message:
XPATH syntax error: '~114c094ff27cde86959ab71ed5b941d'
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 '%123456'and/**/extractvalue(1,concat(char(126),md5(1455066758)))and'%'
=============================================================================
Time:2024-01-06 05:58:44
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 'cast(md5(1616486125)as/**/int))&gt;'0%' ORDER BY a.`OrderNO` DESC,d.AverageStar ' 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 '%123456'and(select'1'from/**/cast(md5(1616486125)as/**/int))&gt;'0%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2024-01-06 05:58:44
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 'cast(md5(1616486125)as/**/int))&gt;'0%'' 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 '%123456'and(select'1'from/**/cast(md5(1616486125)as/**/int))&gt;'0%'
=============================================================================
Time:2024-01-06 05:58:47
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 '1028652668')as/**/int)&gt;0%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`Or' 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 '%123456/**/and/**/cast(md5('1028652668')as/**/int)&gt;0%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2024-01-06 05:58:47
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 '1028652668')as/**/int)&gt;0%'' 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 '%123456/**/and/**/cast(md5('1028652668')as/**/int)&gt;0%'
=============================================================================
Time:2024-01-06 05:58:52
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 'MD5','1833167022')))%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,' 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 '%convert(int,sys.fn_sqlvarbasetostr(HashBytes('MD5','1833167022')))%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2024-01-06 05:58:52
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 'MD5','1833167022')))%'' 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 '%convert(int,sys.fn_sqlvarbasetostr(HashBytes('MD5','1833167022')))%'
=============================================================================
Time:2024-01-06 05:58:56
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 'int,sys.fn_sqlvarbasetostr(HashBytes('MD5','1286486668')))&gt;'0%' ORDER BY a.`O' 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 '%123456'and/**/convert(int,sys.fn_sqlvarbasetostr(HashBytes('MD5','1286486668')))&gt;'0%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2024-01-06 05:58:56
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 'int,sys.fn_sqlvarbasetostr(HashBytes('MD5','1286486668')))&gt;'0%'' 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 '%123456'and/**/convert(int,sys.fn_sqlvarbasetostr(HashBytes('MD5','1286486668')))&gt;'0%'
=============================================================================
Time:2024-01-06 05:58:59
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 '&quot;\(%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,' 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 '%123456鎈'&quot;\(%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2024-01-06 05:58:59
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 '&quot;\(%'' 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 '%123456鎈'&quot;\(%'
=============================================================================
Time:2024-01-06 05:59:03
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 '&quot;\(%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,' 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 '%123456'&quot;\(%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2024-01-06 05:59:03
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 '&quot;\(%'' 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 '%123456'&quot;\(%'
=============================================================================
Time:2024-01-06 05:59:13
Type:sql error
Message:
Subquery returns more than 1 row
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 '%123456'and(select*from(select+sleep(0))a/**/union/**/select+1)='%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2024-01-06 05:59:13
Type:sql error
Message:
Subquery returns more than 1 row
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 '%123456'and(select*from(select+sleep(0))a/**/union/**/select+1)='%'
=============================================================================
Time:2024-01-06 05:59:19
Type:sql error
Message:
Subquery returns more than 1 row
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 '%123456'and(select*from(select+sleep(3))a/**/union/**/select+1)='%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2024-01-06 05:59:22
Type:sql error
Message:
Subquery returns more than 1 row
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 '%123456'and(select*from(select+sleep(3))a/**/union/**/select+1)='%'
=============================================================================
Time:2024-01-06 05:59:30
Type:sql error
Message:
Subquery returns more than 1 row
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 '%123456'and(select*from(select+sleep(4))a/**/union/**/select+1)='%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2024-01-06 05:59:34
Type:sql error
Message:
Subquery returns more than 1 row
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 '%123456'and(select*from(select+sleep(4))a/**/union/**/select+1)='%'
=============================================================================
Time:2024-01-06 05:59:45
Type:sql error
Message:
Subquery returns more than 1 row
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 '%123456'and(select*from(select+sleep(4))a/**/union/**/select+1)='%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2024-01-06 05:59:49
Type:sql error
Message:
Subquery returns more than 1 row
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 '%123456'and(select*from(select+sleep(4))a/**/union/**/select+1)='%'
=============================================================================
Time:2024-01-06 06:00:00
Type:sql error
Message:
Subquery returns more than 1 row
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 '%123456'and(select*from(select+sleep(4))a/**/union/**/select+1)='%' ORDER BY a.`OrderNO` DESC,d.AverageStar DESC,c.`OrderNO`,b.`OrderNO`,a.`CreatedTime` DESC LIMIT 0,20
=============================================================================
Time:2024-01-06 06:00:04
Type:sql error
Message:
Subquery returns more than 1 row
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 '%123456'and(select*from(select+sleep(4))a/**/union/**/select+1)='%'