| N | Type | Trace Data |
|---|---|---|
| 1. | string | conqueroverwhelm founded in Products |
| 2. | string | WebPage_AffiliatePage::on_Init |
| 3. | string | Variable name: Product ID 2268 |
| 4. | string | Variable name: Product ID 2268 |
| 5. | string | Variable name: Product ID 2268 |
| 6. | string | Variable name: Product ID 2268 |
| 7. | string | images/audiofilesimage/NORMAL_vid.639310685758577.jpg |
| Success query |
| Success query, but needs optimization |
| Invalid query |
| N | Query | Execution Time |
|---|---|---|
| 1 | SELECT COALESCE(PRProductid, COUNT(PRProductid)) FROM `PRProduct` WHERE PRProductSEOLink='conqueroverwhelm' LIMIT 0, 1 | 0.00071 |
| 2 | SELECT * FROM `PRProduct` WHERE `PRProductSEOLink`='conqueroverwhelm' LIMIT 0, 1 | 0.00236 |
| 3 | SELECT COALESCE(COUNT(`IP`), `IP`) FROM `BlockListIP` WHERE `IP` = '10.250.15.161' AND `Enabled` = '1' LIMIT 0, 1 | 0.00022 |
| 4 | 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.00027 |
| 5 | SELECT CPAuthorid FROM `CPCategoryproduct` WHERE CPProductid='2268' LIMIT 0, 1 | 0.00031 |
| 6 | SHOW COLUMNS FROM `PRProduct` | 0.00142 |
| 7 | SELECT COALESCE(PRProductid, COUNT(PRProductid)) FROM `PRProduct` WHERE PRProductid=2268 LIMIT 0, 1 | 0.00036 |
| 8 | SELECT * FROM `PRProduct` WHERE PRProductid=2268 | 0.00071 |
| 9 | SELECT APAuthorid FROM APAuthorpage WHERE APUserid=3427 AND APMainstatus=1 LIMIT 0, 1 | 0.00034 |
| 10 | SHOW COLUMNS FROM `APAuthorpage` | 0.00264 |
| 11 | SELECT COALESCE(APAuthorid, COUNT(APAuthorid)) FROM `APAuthorpage` WHERE APAuthorid=2467 LIMIT 0, 1 | 0.00035 |
| 12 | SELECT * FROM `APAuthorpage` WHERE APAuthorid=2467 | 0.00040 |
| 13 | SHOW COLUMNS FROM `PRProduct` | 0.00410 |
| 14 | SELECT COALESCE(PRProductid, COUNT(PRProductid)) FROM `PRProduct` WHERE PRProductid=2268 LIMIT 0, 1 | 0.00022 |
| 15 | SELECT * FROM `PRProduct` WHERE PRProductid=2268 | 0.00132 |
| 16 | SELECT * FROM `PIProductimage` WHERE `PIProductid`='2268' LIMIT 0, 1 | 0.00048 |
| 17 | SHOW COLUMNS FROM `UDUserdetails` | 0.00313 |
| 18 | SELECT COALESCE(UDUserid, COUNT(UDUserid)) FROM `UDUserdetails` WHERE UDUserid=3427 LIMIT 0, 1 | 0.00040 |
| 19 | SELECT * FROM `UDUserdetails` WHERE UDUserid=3427 | 0.00056 |
| 20 | SELECT COALESCE(`CWLWishid`, COUNT(`CWLWishid`)) FROM `CWWishlist` WHERE `CWUserid` = 0 AND `CWProductid` = 2268 LIMIT 0, 1 | 0.00033 |
| 21 | SHOW COLUMNS FROM `PTDDProducttype` | 0.00355 |
| 22 | SELECT COALESCE(PTDDProducttypeid, COUNT(PTDDProducttypeid)) FROM `PTDDProducttype` WHERE PTDDProducttypeid=5 LIMIT 0, 1 | 0.00022 |
| 23 | SELECT * FROM `PTDDProducttype` WHERE PTDDProducttypeid=5 | 0.00023 |
| 24 | 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=2268 | 0.00053 |
| Total DB queries count: 24 | 0.02517 | |