| N | Type | Trace Data |
|---|---|---|
| 1. | string | affiliatestart founded in Affiliate |
| 2. | string | WebPage_AffiliatePage::on_Init |
| 3. | string | Variable name: Product ID 0 |
| 4. | string | Variable name: Product ID 0 |
| 5. | string | Variable name: Product ID 0 |
| 6. | string | Variable name: Product ID 0 |
| 7. | string | images/pdffilesimage/NORMAL_ |
| Success query |
| Success query, but needs optimization |
| Invalid query |
| N | Query | Execution Time |
|---|---|---|
| 1 | SELECT COALESCE(PRProductid, COUNT(PRProductid)) FROM `PRProduct` WHERE PRProductSEOLink='affiliatestart' LIMIT 0, 1 | 0.00051 |
| 2 | SELECT COALESCE(`ALAffiliatelinkid`, COUNT(`ALAffiliatelinkid`)) FROM `ALAffiliatelink` WHERE ALAffiliatelinkname='affiliatestart' LIMIT 0, 1 | 0.25606 |
| 3 | SELECT * FROM `ALAffiliatelink` WHERE ALAffiliatelinkname='affiliatestart' LIMIT 0, 1 | 0.00608 |
| 4 | SELECT COALESCE(COUNT(`IP`), `IP`) FROM `BlockListIP` WHERE `IP` = '10.250.15.161' AND `Enabled` = '1' LIMIT 0, 1 | 0.00023 |
| 5 | SELECT COUNT(PTProducttagid) TagRate, PTPrimarytag1 TagName FROM PTProducttag WHERE PTPrimarytag1 IS NOT NULL AND PTPrimarytag1 != '' GROUP BY TagName ORDER BY TagRate DESC LIMIT 0, 13 | 0.02075 |
| 6 | UPDATE `ALAffiliatelink` SET ALHits = ALHits + '1' WHERE `ALAffiliatelinkid` = '6568' | 0.00050 |
| 7 | SELECT CPAuthorid FROM `CPCategoryproduct` WHERE CPProductid='0' LIMIT 0, 1 | 0.00021 |
| 8 | SHOW COLUMNS FROM `PRProduct` | 0.00143 |
| 9 | SELECT APAuthorid FROM APAuthorpage WHERE APUserid= AND APMainstatus=1 LIMIT 0, 1 Error Code: 1064; 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 'AND APMainstatus=1 LIMIT 0, 1' at line 1; | 0.00026 |
| 10 | SHOW COLUMNS FROM `APAuthorpage` | 0.00300 |
| 11 | SHOW COLUMNS FROM `PRProduct` | 0.00365 |
| 12 | SELECT * FROM `PIProductimage` WHERE `PIProductid`='' LIMIT 0, 1 | 0.00049 |
| 13 | SHOW COLUMNS FROM `UDUserdetails` | 0.00313 |
| 14 | SHOW COLUMNS FROM `PTDDProducttype` | 0.00472 |
| 15 | SELECT RVReview, RVReviewTitle, RVQualityofcontent, RVDeliveryofcontent, RVRecommend, RVAdddate,
IF (UDUserid != 0, CONCAT(UDFirstname, ' ',UDLastname), 'Anonimous') as AuthorName
FROM RVProductreview
LEFT JOIN UDUserdetails ON UDUserid = RVUserid
WHERE RVProductid= Error Code: 1064; 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 5; | 0.00045 |
| Total DB queries count: 15 | 0.30147 | |