| N | Query | Execution Time |
|---|
| 1 | SELECT COALESCE(PRProductid, COUNT(PRProductid)) FROM `PRProduct` WHERE PRProductSEOLink='jimlegington' LIMIT 0, 1 | 0.00047 |
| 2 | SELECT COALESCE(`ALAffiliatelinkid`, COUNT(`ALAffiliatelinkid`)) FROM `ALAffiliatelink` WHERE ALAffiliatelinkname='jimlegington' LIMIT 0, 1 | 0.21271 |
| 3 | SELECT COALESCE(`APAuthorid`, COUNT(`APAuthorid`)) FROM `APAuthorpage` WHERE `APTitle`='jimlegington' LIMIT 0, 1 | 0.00051 |
| 4 | SELECT * FROM `APAuthorpage` WHERE APTitle = LOWER('jimlegington') LIMIT 0, 1 | 0.00049 |
| 5 | SELECT COALESCE(COUNT(`IP`), `IP`) FROM `BlockListIP` WHERE `IP` = '10.250.15.161' AND `Enabled` = '1' LIMIT 0, 1 | 0.06029 |
| 6 | 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.00026 |
| 7 | SHOW COLUMNS FROM `APAuthorpage` | 0.00168 |
| 8 | SELECT COALESCE(APAuthorid, COUNT(APAuthorid)) FROM `APAuthorpage` WHERE APAuthorid=2616 LIMIT 0, 1 | 0.00041 |
| 9 | SELECT * FROM `APAuthorpage` WHERE APAuthorid=2616 | 0.00043 |
| 10 | SHOW COLUMNS FROM `UDUserdetails` | 0.00389 |
| 11 | SELECT COALESCE(UDUserid, COUNT(UDUserid)) FROM `UDUserdetails` WHERE UDUserid=3775 LIMIT 0, 1 | 0.00043 |
| 12 | SELECT * FROM `UDUserdetails` WHERE UDUserid=3775 | 0.00077 |
| 13 | SELECT * FROM ACAuthorcategory
INNER JOIN CPCategoryproduct ON CPAuthorcategoryid = ACAuthorcategoryid
WHERE ACAuthorid='2616'
GROUP BY ACAuthorcategoryid | 0.00049 |
| 14 | SELECT * FROM CPCategoryproduct
INNER JOIN PRProduct ON PRProductid = CPProductid
INNER JOIN PIProductimage ON PIProductid = PRProductid
INNER JOIN PTDDProducttype ON PTDDProducttypeid = PRProducttypeid
WHERE CPAuthorcategoryid='' AND PIProductfile !=''
GROUP BY CPProductid | 0.06435 |
| Total DB queries count: 14 | 0.34716 |
