API tools faq
paste
toxicious

Untitled

toxicious
Aug 6th, 2012
221
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.30 KB | None | 0 0
raw download clone embed print report
  1. Count: 17 Time=15.88s (269s) Lock=1.38s (23s) Rows=0.0 (0), gaddons_website[gaddons_website]@localhost
  2. UPDATE mirrors SET clicks=clicks+N WHERE id=N
  3.  
  4. Count: 928 Time=0.10s (89s) Lock=0.14s (131s) Rows=21.7 (20126), gaddons_website[gaddons_website]@localhost
  5. SELECT id, name, date_added FROM addons WHERE `id` IN (SELECT DISTINCT `addon_id` FROM `addon_mirrors`) AND name LIKE 'S' ORDER BY id asc LIMIT N
  6.  
  7. Count: 7 Time=9.78s (68s) Lock=0.19s (1s) Rows=0.0 (0), gaddons_website[gaddons_website]@localhost
  8. UPDATE mirrors SET lastclick=NOW() WHERE id = N
  9.  
  10. Count: 6 Time=10.18s (61s) Lock=0.24s (1s) Rows=0.0 (0), gaddons_website[gaddons_website]@localhost
  11. INSERT INTO mirrors (mirror, user_id) VALUES ('S','S')
  12.  
  13. Count: 10 Time=4.80s (47s) Lock=0.56s (5s) Rows=8.0 (80), gaddons_website[gaddons_website]@localhost
  14. SELECT * FROM news ORDER BY date DESC LIMIT N
  15.  
  16. Count: 4 Time=9.83s (39s) Lock=0.25s (1s) Rows=0.0 (0), gaddons_website[gaddons_website]@localhost
  17. INSERT INTO addon_mirrors (addon_id, mirror_id) VALUES (N, N)
  18.  
  19. Count: 3 Time=8.51s (25s) Lock=0.00s (0s) Rows=0.0 (0), gaddons_website[gaddons_website]@localhost
  20. UPDATE addons SET date_changed = NOW() WHERE id='S'
  21.  
  22. Count: 32 Time=0.70s (22s) Lock=0.07s (2s) Rows=1.0 (32), gaddons_website[gaddons_website]@localhost
  23. SELECT COUNT(*) FROM addons WHERE name LIKE 'S' AND id IN (SELECT DISTINCT `addon_id` FROM `addon_mirrors`)
  24.  
  25. Count: 41 Time=0.47s (19s) Lock=0.23s (9s) Rows=1.0 (41), gaddons_website[gaddons_website]@localhost
  26. SELECT COUNT(*) FROM `addons` WHERE `id` IN (SELECT DISTINCT `addon_id` FROM `addon_mirrors`)
  27.  
  28. Count: 44 Time=0.42s (18s) Lock=0.18s (8s) Rows=0.0 (0), gaddons_website[gaddons_website]@localhost
  29. SELECT * FROM mirrors WHERE mirror LIKE 'S'
  30.  
  31. Count: 44 Time=0.28s (12s) Lock=0.89s (39s) Rows=37.9 (1669), gaddons_website[gaddons_website]@localhost
  32. SELECT * FROM `addons` WHERE `id` NOT IN (SELECT DISTINCT `addon_id` FROM `addon_mirrors`) ORDER BY CAST(id AS DECIMAL)
  33.  
  34. Count: 60 Time=0.17s (10s) Lock=1.69s (101s) Rows=30.0 (1800), gaddons_website[gaddons_website]@localhost
  35. SELECT nickname, message, time FROM shoutbox_messages ORDER BY time DESC LIMIT N
  36.  
  37. Count: 201 Time=0.05s (9s) Lock=0.20s (40s) Rows=0.0 (0), gaddons_website[gaddons_website]@localhost
  38. UPDATE stats SET mirrorDisplays=mirrorDisplays+N
  39.  
  40. Count: 1 Time=9.03s (9s) Lock=1.00s (1s) Rows=0.0 (0), gaddons_website[gaddons_website]@localhost
  41. INSERT INTO users (email) VALUES ('S')
  42.  
  43. Count: 1 Time=6.26s (6s) Lock=0.00s (0s) Rows=3.0 (3), gaddons_website[gaddons_website]@localhost
  44. SELECT * FROM addon_mirrors WHERE addon_id = N
  45.  
  46. Count: 1 Time=5.07s (5s) Lock=0.00s (0s) Rows=0.0 (0), gaddons_website[gaddons_website]@localhost
  47. INSERT INTO addons (id, name, date_added, date_changed) VALUES ('S', 'S', NOW(), NOW())
  48.  
  49. Count: 6 Time=0.53s (3s) Lock=0.05s (0s) Rows=1.0 (6), gaddons_website[gaddons_website]@localhost
  50. SELECT sum(clicks) FROM mirrors
  51.  
  52. Count: 39 Time=0.05s (1s) Lock=0.04s (1s) Rows=1.0 (39), gaddons_website[gaddons_website]@localhost
  53. SELECT COUNT(*) FROM `addons` WHERE `id` NOT IN (SELECT DISTINCT `addon_id` FROM `addon_mirrors`)
  54.  
  55. Count: 2 Time=0.47s (0s) Lock=0.55s (1s) Rows=25.5 (51), gaddons_website[gaddons_website]@localhost
  56. SELECT id, name, date_added FROM addons WHERE `id` IN (SELECT DISTINCT `addon_id` FROM `addon_mirrors`) AND name LIKE 'S' ORDER BY name asc LIMIT N
  57.  
  58. Count: 13 Time=0.05s (0s) Lock=0.08s (0s) Rows=1.0 (13), gaddons_website[gaddons_website]@localhost
  59. SELECT * FROM users WHERE user='S'
  60.  
  61. Count: 4 Time=0.08s (0s) Lock=0.00s (0s) Rows=1.0 (4), gaddons[gaddons]@localhost
  62. SELECT COUNT(*) FROM `gaddons_main`.`addon_mirrors`
  63.  
  64. Count: 2 Time=0.09s (0s) Lock=0.49s (0s) Rows=0.5 (1), gaddons_website[gaddons_website]@localhost
  65. SELECT * FROM users WHERE email = 'S'
  66.  
  67. Count: 1 Time=0.08s (0s) Lock=0.21s (0s) Rows=0.0 (0), gaddons[gaddons]@localhost
  68. SELECT * FROM `addon_mirrors` WHERE `mirror_id` NOT IN (SELECT `id` FROM `mirrors`)
  69. LIMIT N, N
  70.  
  71. Count: 1 Time=0.06s (0s) Lock=0.00s (0s) Rows=1.0 (1), gaddons[gaddons]@localhost
  72. SELECT SQL_CALC_FOUND_ROWS * FROM mirrors WHERE mirror LIKE 'S' AND user_id =N LIMIT N
  73.  
  74. Count: 1 Time=0.05s (0s) Lock=0.00s (0s) Rows=50.0 (50), gaddons_website[gaddons_website]@localhost
  75. SELECT id, name, date_added FROM addons WHERE `id` IN (SELECT DISTINCT `addon_id` FROM `addon_mirrors`) AND name LIKE 'S' ORDER BY date_added asc LIMIT N
  76.  
  77. Count: 1 Time=0.04s (0s) Lock=0.00s (0s) Rows=0.0 (0), gaddons[gaddons]@localhost
  78. SELECT * FROM `mirrors` WHERE `id` NOT IN (SELECT DISTINCT `mirror_id` FROM `addon_mirrors`)
  79. LIMIT N, N
  80.  
  81. Count: 6 Time=0.01s (0s) Lock=0.00s (0s) Rows=1.0 (6), gaddons_website[gaddons_website]@localhost
  82. SELECT sum(clicksScript) FROM mirrors
  83.  
  84. Count: 5 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (5), gaddons[gaddons]@localhost
  85. SELECT COUNT(*) FROM `gaddons_main`.`mirrors`
  86.  
  87. Count: 1 Time=0.02s (0s) Lock=0.00s (0s) Rows=0.0 (0), gaddons[gaddons]@localhost
  88. SELECT * FROM `addon_mirrors` WHERE `mirror_id` NOT IN (SELECT DISTINCT `id` FROM `mirrors`)
  89. LIMIT N, N
  90.  
  91. Count: 1 Time=0.02s (0s) Lock=0.00s (0s) Rows=0.0 (0), gaddons[gaddons]@localhost
  92. SELECT SQL_CALC_FOUND_ROWS * FROM `mirrors` WHERE `id` NOT IN ( SELECT DISTINCT `mirror_id`
  93. FROM `addon_mirrors` ) LIMIT N
  94.  
  95. Count: 6 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (6), gaddons_website[gaddons_website]@localhost
  96. SELECT COUNT(*) FROM mirrors
  97.  
  98. Count: 2 Time=0.01s (0s) Lock=0.00s (0s) Rows=0.5 (1), gaddons[gaddons]@localhost
  99. SELECT SQL_CALC_FOUND_ROWS * FROM `mirrors` WHERE mirror LIKE 'S' LIMIT N
  100.  
  101. Count: 2 Time=0.01s (0s) Lock=0.00s (0s) Rows=2.5 (5), gaddons[gaddons]@localhost
  102. SELECT * FROM `mirrors` WHERE mirror LIKE 'S'
  103. LIMIT N, N
  104.  
  105. Count: 1 Time=0.01s (0s) Lock=0.00s (0s) Rows=0.0 (0), gaddons[gaddons]@localhost
  106. SELECT SQL_CALC_FOUND_ROWS * FROM `addon_mirrors` WHERE `mirror_id` NOT IN ( SELECT `id`
  107. FROM `mirrors` ) LIMIT N
  108.  
  109. Count: 1 Time=0.01s (0s) Lock=0.00s (0s) Rows=50.0 (50), gaddons_website[gaddons_website]@localhost
  110. SELECT id, name, date_added FROM addons WHERE `id` IN (SELECT DISTINCT `addon_id` FROM `addon_mirrors`) AND name LIKE 'S' ORDER BY date_added desc LIMIT N
  111.  
  112. Count: 1 Time=0.01s (0s) Lock=0.00s (0s) Rows=0.0 (0), gaddons[gaddons]@localhost
  113. SELECT SQL_CALC_FOUND_ROWS * FROM `addon_mirrors` WHERE `mirror_id` NOT IN ( SELECT DISTINCT `id`
  114. FROM `mirrors` ) LIMIT N
  115.  
  116. Count: 1 Time=0.01s (0s) Lock=0.00s (0s) Rows=1.0 (1), gaddons[gaddons]@localhost
  117. SELECT SQL_CALC_FOUND_ROWS * FROM mirrors WHERE mirror LIKE 'S' LIMIT N
  118.  
  119. Count: 1 Time=0.01s (0s) Lock=0.00s (0s) Rows=1.0 (1), gaddons[gaddons]@localhost
  120. SELECT SQL_CALC_FOUND_ROWS * FROM mirrors WHERE mirror LIKE 'S' ORDER BY `mirrors`.`lastclick` DESC LIMIT N
  121.  
  122. Count: 1 Time=0.01s (0s) Lock=0.00s (0s) Rows=30.0 (30), gaddons[gaddons]@localhost
  123. SELECT * FROM mirrors WHERE mirror LIKE 'S' ORDER BY `mirrors`.`lastclick` DESC
  124. LIMIT N, N
  125.  
  126. Count: 2 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (2), gaddons[gaddons]@localhost
  127. SELECT COUNT(*) FROM `gaddons_main`.`addons`
  128.  
  129. Count: 2 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (2), gaddons[gaddons]@localhost
  130. SELECT COUNT(*) FROM `gaddons_main`.`news`
  131.  
  132. Count: 42 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), gaddons_website[gaddons_website]@localhost
  133. UPDATE stats SET mirrorDisplaysScript=mirrorDisplaysScript+N
  134.  
  135. Count: 2 Time=0.00s (0s) Lock=0.00s (0s) Rows=30.0 (60), gaddons[gaddons]@localhost
  136. SELECT * FROM `mirrors`
  137. LIMIT N, N
  138.  
  139. Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=30.0 (30), gaddons[gaddons]@localhost
  140. SELECT * FROM `addon_mirrors`
  141. LIMIT N, N
  142.  
  143. Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=30.0 (30), gaddons[gaddons]@localhost
  144. SELECT * FROM mirrors WHERE mirror LIKE 'S'
  145. LIMIT N, N
  146.  
  147. Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=30.0 (30), gaddons[gaddons]@localhost
  148. SELECT * FROM mirrors WHERE mirror LIKE 'S' AND user_id = N
  149. LIMIT N, N
  150.  
  151. Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (1), gaddons_website[gaddons_website]@localhost
  152. SELECT * FROM users WHERE user = 'S'
  153.  
  154. Count: 2 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (2), gaddons[gaddons]@localhost
  155. SELECT COUNT(*) FROM `gaddons_main`.`users`
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!