This week only. Pastebin PRO Accounts Christmas Special! Don't miss out!Want more features on Pastebin? Sign Up, it's FREE!

Uncached query

By: kotuha on Dec 3rd, 2012  |  syntax: MySQL  |  size: 2.13 KB  |  views: 25  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SHOW PROFILE for the following query:
  2.  
  3.     SELECT `topic`.* FROM `topics` AS `topic`
  4.     LEFT OUTER  JOIN `topic` AS `topic_helper` ON (`topic`.`id` = `topic_helper`.`id` AND `topic_helper`.`created_on` < `topic`.`created_on`)
  5.     GROUP BY `topic`.`id` HAVING COUNT(*) < 3
  6.     ORDER BY `topic`.`created_on` DESC;
  7.  
  8. +--------------------------------+----------+
  9. | Status                         | Duration |
  10. +--------------------------------+----------+
  11. | starting                       | 0.000021 |
  12. | Waiting for query cache lock   | 0.000004 |
  13. | Waiting on query cache mutex   | 0.000004 |
  14. | checking query cache for query | 0.000082 |
  15. | checking permissions           | 0.000006 |
  16. | checking permissions           | 0.000008 |
  17. | Opening tables                 | 0.000359 |
  18. | System lock                    | 0.000018 |
  19. | Waiting for query cache lock   | 0.000004 |
  20. | Waiting on query cache mutex   | 0.000025 |
  21. | init                           | 0.000009 |
  22. | checking permissions           | 0.000004 |
  23. | checking permissions           | 0.000004 |
  24. | checking permissions           | 0.000003 |
  25. | checking permissions           | 0.000004 |
  26. | checking permissions           | 0.000003 |
  27. | checking permissions           | 0.000003 |
  28. | checking permissions           | 0.000091 |
  29. | optimizing                     | 0.000022 |
  30. | statistics                     | 0.000081 |
  31. | preparing                      | 0.000035 |
  32. | Creating tmp table             | 0.000448 |
  33. | Sorting for group              | 0.000009 |
  34. | executing                      | 0.000004 |
  35. | Copying to tmp table           | 0.428565 |
  36. | Sorting result                 | 0.005275 |
  37. | Sending data                   | 0.000772 |
  38. | end                            | 0.000008 |
  39. | removing tmp table             | 0.002753 |
  40. | end                            | 0.000009 |
  41. | query end                      | 0.000010 |
  42. | closing tables                 | 0.000032 |
  43. | freeing items                  | 0.000318 |
  44. | logging slow query             | 0.000004 |
  45. | cleaning up                    | 0.000009 |
  46. +--------------------------------+----------+
  47. 35 rows in set (0.00 sec)
clone this paste RAW Paste Data