 |
Location: Netherlands Expertise: Internet Marketing, Affiliate Marketing, Article Marketing, Personal Development and Blogging Author Bio: Robert is an Internet entrepreneur who has been online for JUST 3 years (since 2004). |
|
| N | Type | Trace Data |
|---|---|---|
| 1. | string | robertmollers founded in Authorpage |
| 2. | string | WebPage_AffiliatePage::on_Init |
| 3. | string | Variable name: Product ID 2362 |
| 4. | string | Variable name: Product ID 2362 |
| Success query |
| Success query, but needs optimization |
| Invalid query |
| N | Query | Execution Time |
|---|---|---|
| 1 | SELECT COALESCE(PRProductid, COUNT(PRProductid)) FROM `PRProduct` WHERE PRProductSEOLink='robertmollers' LIMIT 0, 1 | 0.00045 |
| 2 | SELECT COALESCE(`ALAffiliatelinkid`, COUNT(`ALAffiliatelinkid`)) FROM `ALAffiliatelink` WHERE ALAffiliatelinkname='robertmollers' LIMIT 0, 1 | 0.30638 |
| 3 | SELECT COALESCE(`APAuthorid`, COUNT(`APAuthorid`)) FROM `APAuthorpage` WHERE `APTitle`='robertmollers' LIMIT 0, 1 | 0.00060 |
| 4 | SELECT * FROM `APAuthorpage` WHERE APTitle = LOWER('robertmollers') LIMIT 0, 1 | 0.00136 |
| 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.00199 |
| 8 | SELECT COALESCE(APAuthorid, COUNT(APAuthorid)) FROM `APAuthorpage` WHERE APAuthorid=2362 LIMIT 0, 1 | 0.00061 |
| 9 | SELECT * FROM `APAuthorpage` WHERE APAuthorid=2362 | 0.00055 |
| 10 | SHOW COLUMNS FROM `UDUserdetails` | 0.06762 |
| 11 | SELECT COALESCE(UDUserid, COUNT(UDUserid)) FROM `UDUserdetails` WHERE UDUserid=2822 LIMIT 0, 1 | 0.00056 |
| 12 | SELECT * FROM `UDUserdetails` WHERE UDUserid=2822 | 0.00109 |
| 13 | SELECT * FROM ACAuthorcategory INNER JOIN CPCategoryproduct ON CPAuthorcategoryid = ACAuthorcategoryid WHERE ACAuthorid='2362' GROUP BY ACAuthorcategoryid | 0.00110 |
| 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.00325 |
| Total DB queries count: 14 | 0.38613 | |
