| N | Query | Execution Time |
|---|
| 1 | SELECT COALESCE(PRProductid, COUNT(PRProductid)) FROM `PRProduct` WHERE PRProductSEOLink='earnalivinghere' LIMIT 0, 1 | 0.00052 |
| 2 | SELECT COALESCE(`ALAffiliatelinkid`, COUNT(`ALAffiliatelinkid`)) FROM `ALAffiliatelink` WHERE ALAffiliatelinkname='earnalivinghere' LIMIT 0, 1 | 0.29831 |
| 3 | SELECT COALESCE(`APAuthorid`, COUNT(`APAuthorid`)) FROM `APAuthorpage` WHERE `APTitle`='earnalivinghere' LIMIT 0, 1 | 0.00049 |
| 4 | SELECT * FROM `APAuthorpage` WHERE APTitle = LOWER('earnalivinghere') LIMIT 0, 1 | 0.00067 |
| 5 | SELECT COALESCE(COUNT(`IP`), `IP`) FROM `BlockListIP` WHERE `IP` = '10.250.15.161' AND `Enabled` = '1' LIMIT 0, 1 | 0.00022 |
| 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.00036 |
| 7 | SHOW COLUMNS FROM `APAuthorpage` | 0.00193 |
| 8 | SELECT COALESCE(APAuthorid, COUNT(APAuthorid)) FROM `APAuthorpage` WHERE APAuthorid=5008 LIMIT 0, 1 | 0.00071 |
| 9 | SELECT * FROM `APAuthorpage` WHERE APAuthorid=5008 | 0.00213 |
| 10 | SHOW COLUMNS FROM `UDUserdetails` | 0.00469 |
| 11 | SELECT COALESCE(UDUserid, COUNT(UDUserid)) FROM `UDUserdetails` WHERE UDUserid=7744 LIMIT 0, 1 | 0.00043 |
| 12 | SELECT * FROM `UDUserdetails` WHERE UDUserid=7744 | 0.00073 |
| 13 | SELECT * FROM ACAuthorcategory
INNER JOIN CPCategoryproduct ON CPAuthorcategoryid = ACAuthorcategoryid
WHERE ACAuthorid='5008'
GROUP BY ACAuthorcategoryid | 0.00067 |
| 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.00517 |
| Total DB queries count: 14 | 0.31703 |
