| Success query |
| Success query, but needs optimization |
| Invalid query |
| N | Query | Execution Time |
|---|---|---|
| 1 | SELECT COALESCE(COUNT(`IP`), `IP`) FROM `BlockListIP` WHERE `IP` = '10.250.15.161' AND `Enabled` = '1' LIMIT 0, 1 | 0.00025 |
| 2 | 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 |
| Total DB queries count: 2 | 0.00051 | |