API tools faq
paste
Guest User

djabbour

a guest
Nov 18th, 2009
248
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 10.84 KB | None | 0 0
raw download clone embed print report
  1. mysql> SHOW FULL processlist \G
  2. *************************** 1. ROW ***************************
  3.      Id: 48759
  4.    USER: lowestpricedglas
  5.    Host: localhost
  6.      db: lowestpricedglasses
  7. Command: Query
  8.    TIME: 26823
  9.   State: statistics
  10.    Info: SELECT COUNT(*) FROM (uc_product_options AS po1 LEFT JOIN uc_attribute_options AS ao1 ON po1.oid = ao1.oid AND po1.nid = 9), (uc_product_options AS po2 LEFT JOIN uc_attribute_options AS ao2 ON po2.oid = ao2.oid AND po2.nid = 9), (uc_product_options AS po3 LEFT JOIN uc_attribute_options AS ao3 ON po3.oid = ao3.oid AND po3.nid = 9), (uc_product_options AS po4 LEFT JOIN uc_attribute_options AS ao4 ON po4.oid = ao4.oid AND po4.nid = 9), (uc_product_options AS po5 LEFT JOIN uc_attribute_options AS ao5 ON po5.oid = ao5.oid AND po5.nid = 9), (uc_product_options AS po6 LEFT JOIN uc_attribute_options AS ao6 ON po6.oid = ao6.oid AND po6.nid = 9), (uc_product_options AS po7 LEFT JOIN uc_attribute_options AS ao7 ON po7.oid = ao7.oid AND po7.nid = 9), (uc_product_options AS po8 LEFT JOIN uc_attribute_options AS ao8 ON po8.oid = ao8.oid AND po8.nid = 9), (uc_product_options AS po9 LEFT JOIN uc_attribute_options AS ao9 ON po9.oid = ao9.oid AND po9.nid = 9), (uc_product_options AS po10 LEFT JOIN uc_attribute_options AS ao10 ON po10.oid = ao10.oid AND po10.nid = 9), (uc_product_options AS po11 LEFT JOIN uc_attribute_options AS ao11 ON po11.oid = ao11.oid AND po11.nid = 9), (uc_product_options AS po12 LEFT JOIN uc_attribute_options AS ao12 ON po12.oid = ao12.oid AND po12.nid = 9), (uc_product_options AS po13 LEFT JOIN uc_attribute_options AS ao13 ON po13.oid = ao13.oid AND po13.nid = 9), (uc_product_options AS po14 LEFT JOIN uc_attribute_options AS ao14 ON po14.oid = ao14.oid AND po14.nid = 9), (uc_product_options AS po15 LEFT JOIN uc_attribute_options AS ao15 ON po15.oid = ao15.oid AND po15.nid = 9), (uc_product_options AS po16 LEFT JOIN uc_attribute_options AS ao16 ON po16.oid = ao16.oid AND po16.nid = 9), (uc_product_options AS po17 LEFT JOIN uc_attribute_options AS ao17 ON po17.oid = ao17.oid AND po17.nid = 9), (uc_product_options AS po18 LEFT JOIN uc_attribute_options AS ao18 ON po18.oid = ao18.oid AND po18.nid = 9) WHERE ao1.aid = 1 AND ao2.aid = 13 AND ao3.aid = 19 AND ao4.aid = 9 AND ao5.aid = 8 AND ao6.aid = 7 AND ao7.aid = 3 AND ao8.aid = 5 AND ao9.aid = 4 AND ao10.aid = 6 AND ao11.aid = 18 AND ao12.aid = 17 AND ao13.aid = 16 AND ao14.aid = 15 AND ao15.aid = 14 AND ao16.aid = 12 AND ao17.aid = 10 AND ao18.aid = 11
  11. *************************** 2. ROW ***************************
  12.      Id: 48760
  13.    USER: lowestpricedglas
  14.    Host: localhost
  15.      db: lowestpricedglasses
  16. Command: Query
  17.    TIME: 26812
  18.   State: statistics
  19.    Info: SELECT COUNT(*) FROM (uc_product_options AS po1 LEFT JOIN uc_attribute_options AS ao1 ON po1.oid = ao1.oid AND po1.nid = 9), (uc_product_options AS po2 LEFT JOIN uc_attribute_options AS ao2 ON po2.oid = ao2.oid AND po2.nid = 9), (uc_product_options AS po3 LEFT JOIN uc_attribute_options AS ao3 ON po3.oid = ao3.oid AND po3.nid = 9), (uc_product_options AS po4 LEFT JOIN uc_attribute_options AS ao4 ON po4.oid = ao4.oid AND po4.nid = 9), (uc_product_options AS po5 LEFT JOIN uc_attribute_options AS ao5 ON po5.oid = ao5.oid AND po5.nid = 9), (uc_product_options AS po6 LEFT JOIN uc_attribute_options AS ao6 ON po6.oid = ao6.oid AND po6.nid = 9), (uc_product_options AS po7 LEFT JOIN uc_attribute_options AS ao7 ON po7.oid = ao7.oid AND po7.nid = 9), (uc_product_options AS po8 LEFT JOIN uc_attribute_options AS ao8 ON po8.oid = ao8.oid AND po8.nid = 9), (uc_product_options AS po9 LEFT JOIN uc_attribute_options AS ao9 ON po9.oid = ao9.oid AND po9.nid = 9), (uc_product_options AS po10 LEFT JOIN uc_attribute_options AS ao10 ON po10.oid = ao10.oid AND po10.nid = 9), (uc_product_options AS po11 LEFT JOIN uc_attribute_options AS ao11 ON po11.oid = ao11.oid AND po11.nid = 9), (uc_product_options AS po12 LEFT JOIN uc_attribute_options AS ao12 ON po12.oid = ao12.oid AND po12.nid = 9), (uc_product_options AS po13 LEFT JOIN uc_attribute_options AS ao13 ON po13.oid = ao13.oid AND po13.nid = 9), (uc_product_options AS po14 LEFT JOIN uc_attribute_options AS ao14 ON po14.oid = ao14.oid AND po14.nid = 9), (uc_product_options AS po15 LEFT JOIN uc_attribute_options AS ao15 ON po15.oid = ao15.oid AND po15.nid = 9), (uc_product_options AS po16 LEFT JOIN uc_attribute_options AS ao16 ON po16.oid = ao16.oid AND po16.nid = 9), (uc_product_options AS po17 LEFT JOIN uc_attribute_options AS ao17 ON po17.oid = ao17.oid AND po17.nid = 9), (uc_product_options AS po18 LEFT JOIN uc_attribute_options AS ao18 ON po18.oid = ao18.oid AND po18.nid = 9) WHERE ao1.aid = 1 AND ao2.aid = 13 AND ao3.aid = 19 AND ao4.aid = 9 AND ao5.aid = 8 AND ao6.aid = 7 AND ao7.aid = 3 AND ao8.aid = 5 AND ao9.aid = 4 AND ao10.aid = 6 AND ao11.aid = 18 AND ao12.aid = 17 AND ao13.aid = 16 AND ao14.aid = 15 AND ao15.aid = 14 AND ao16.aid = 12 AND ao17.aid = 10 AND ao18.aid = 11
  20. *************************** 3. ROW ***************************
  21.      Id: 48761
  22.    USER: lowestpricedglas
  23.    Host: localhost
  24.      db: lowestpricedglasses
  25. Command: Query
  26.    TIME: 26811
  27.   State: statistics
  28.    Info: SELECT COUNT(*) FROM (uc_product_options AS po1 LEFT JOIN uc_attribute_options AS ao1 ON po1.oid = ao1.oid AND po1.nid = 9), (uc_product_options AS po2 LEFT JOIN uc_attribute_options AS ao2 ON po2.oid = ao2.oid AND po2.nid = 9), (uc_product_options AS po3 LEFT JOIN uc_attribute_options AS ao3 ON po3.oid = ao3.oid AND po3.nid = 9), (uc_product_options AS po4 LEFT JOIN uc_attribute_options AS ao4 ON po4.oid = ao4.oid AND po4.nid = 9), (uc_product_options AS po5 LEFT JOIN uc_attribute_options AS ao5 ON po5.oid = ao5.oid AND po5.nid = 9), (uc_product_options AS po6 LEFT JOIN uc_attribute_options AS ao6 ON po6.oid = ao6.oid AND po6.nid = 9), (uc_product_options AS po7 LEFT JOIN uc_attribute_options AS ao7 ON po7.oid = ao7.oid AND po7.nid = 9), (uc_product_options AS po8 LEFT JOIN uc_attribute_options AS ao8 ON po8.oid = ao8.oid AND po8.nid = 9), (uc_product_options AS po9 LEFT JOIN uc_attribute_options AS ao9 ON po9.oid = ao9.oid AND po9.nid = 9), (uc_product_options AS po10 LEFT JOIN uc_attribute_options AS ao10 ON po10.oid = ao10.oid AND po10.nid = 9), (uc_product_options AS po11 LEFT JOIN uc_attribute_options AS ao11 ON po11.oid = ao11.oid AND po11.nid = 9), (uc_product_options AS po12 LEFT JOIN uc_attribute_options AS ao12 ON po12.oid = ao12.oid AND po12.nid = 9), (uc_product_options AS po13 LEFT JOIN uc_attribute_options AS ao13 ON po13.oid = ao13.oid AND po13.nid = 9), (uc_product_options AS po14 LEFT JOIN uc_attribute_options AS ao14 ON po14.oid = ao14.oid AND po14.nid = 9), (uc_product_options AS po15 LEFT JOIN uc_attribute_options AS ao15 ON po15.oid = ao15.oid AND po15.nid = 9), (uc_product_options AS po16 LEFT JOIN uc_attribute_options AS ao16 ON po16.oid = ao16.oid AND po16.nid = 9), (uc_product_options AS po17 LEFT JOIN uc_attribute_options AS ao17 ON po17.oid = ao17.oid AND po17.nid = 9), (uc_product_options AS po18 LEFT JOIN uc_attribute_options AS ao18 ON po18.oid = ao18.oid AND po18.nid = 9) WHERE ao1.aid = 1 AND ao2.aid = 13 AND ao3.aid = 19 AND ao4.aid = 9 AND ao5.aid = 8 AND ao6.aid = 7 AND ao7.aid = 3 AND ao8.aid = 5 AND ao9.aid = 4 AND ao10.aid = 6 AND ao11.aid = 18 AND ao12.aid = 17 AND ao13.aid = 16 AND ao14.aid = 15 AND ao15.aid = 14 AND ao16.aid = 12 AND ao17.aid = 10 AND ao18.aid = 11
  29. *************************** 4. ROW ***************************
  30.      Id: 48763
  31.    USER: lowestpricedglas
  32.    Host: localhost
  33.      db: lowestpricedglasses
  34. Command: Query
  35.    TIME: 26782
  36.   State: statistics
  37.    Info: SELECT COUNT(*) FROM (uc_product_options AS po1 LEFT JOIN uc_attribute_options AS ao1 ON po1.oid = ao1.oid AND po1.nid = 9), (uc_product_options AS po2 LEFT JOIN uc_attribute_options AS ao2 ON po2.oid = ao2.oid AND po2.nid = 9), (uc_product_options AS po3 LEFT JOIN uc_attribute_options AS ao3 ON po3.oid = ao3.oid AND po3.nid = 9), (uc_product_options AS po4 LEFT JOIN uc_attribute_options AS ao4 ON po4.oid = ao4.oid AND po4.nid = 9), (uc_product_options AS po5 LEFT JOIN uc_attribute_options AS ao5 ON po5.oid = ao5.oid AND po5.nid = 9), (uc_product_options AS po6 LEFT JOIN uc_attribute_options AS ao6 ON po6.oid = ao6.oid AND po6.nid = 9), (uc_product_options AS po7 LEFT JOIN uc_attribute_options AS ao7 ON po7.oid = ao7.oid AND po7.nid = 9), (uc_product_options AS po8 LEFT JOIN uc_attribute_options AS ao8 ON po8.oid = ao8.oid AND po8.nid = 9), (uc_product_options AS po9 LEFT JOIN uc_attribute_options AS ao9 ON po9.oid = ao9.oid AND po9.nid = 9), (uc_product_options AS po10 LEFT JOIN uc_attribute_options AS ao10 ON po10.oid = ao10.oid AND po10.nid = 9), (uc_product_options AS po11 LEFT JOIN uc_attribute_options AS ao11 ON po11.oid = ao11.oid AND po11.nid = 9), (uc_product_options AS po12 LEFT JOIN uc_attribute_options AS ao12 ON po12.oid = ao12.oid AND po12.nid = 9), (uc_product_options AS po13 LEFT JOIN uc_attribute_options AS ao13 ON po13.oid = ao13.oid AND po13.nid = 9), (uc_product_options AS po14 LEFT JOIN uc_attribute_options AS ao14 ON po14.oid = ao14.oid AND po14.nid = 9), (uc_product_options AS po15 LEFT JOIN uc_attribute_options AS ao15 ON po15.oid = ao15.oid AND po15.nid = 9), (uc_product_options AS po16 LEFT JOIN uc_attribute_options AS ao16 ON po16.oid = ao16.oid AND po16.nid = 9), (uc_product_options AS po17 LEFT JOIN uc_attribute_options AS ao17 ON po17.oid = ao17.oid AND po17.nid = 9), (uc_product_options AS po18 LEFT JOIN uc_attribute_options AS ao18 ON po18.oid = ao18.oid AND po18.nid = 9) WHERE ao1.aid = 1 AND ao2.aid = 13 AND ao3.aid = 19 AND ao4.aid = 9 AND ao5.aid = 8 AND ao6.aid = 7 AND ao7.aid = 3 AND ao8.aid = 5 AND ao9.aid = 4 AND ao10.aid = 6 AND ao11.aid = 18 AND ao12.aid = 17 AND ao13.aid = 16 AND ao14.aid = 15 AND ao15.aid = 14 AND ao16.aid = 12 AND ao17.aid = 10 AND ao18.aid = 11
  38. *************************** 5. ROW ***************************
  39.      Id: 49164
  40.    USER: lowestpricedglas
  41.    Host: localhost
  42.      db: lowestpricedglasses
  43. Command: Query
  44.    TIME: 6113
  45.   State: Locked
  46.    Info: DELETE ao, co, po FROM uc_attribute_options AS ao LEFT JOIN uc_product_options AS po ON ao.oid = po.oid LEFT JOIN uc_class_attribute_options AS co ON ao.oid = co.oid WHERE ao.oid = 172
  47. *************************** 6. ROW ***************************
  48.      Id: 49171
  49.    USER: lowestpricedglas
  50.    Host: localhost
  51.      db: lowestpricedglasses
  52. Command: Query
  53.    TIME: 5822
  54.   State: Locked
  55.    Info: SELECT * FROM uc_attribute_options WHERE aid = 10 ORDER BY ordering, name
  56. *************************** 7. ROW ***************************
  57.      Id: 49177
  58.    USER: lowestpricedglas
  59.    Host: localhost
  60.      db: lowestpricedglasses
  61. Command: Query
  62.    TIME: 5673
  63.   State: Locked
  64.    Info: SELECT * FROM uc_attribute_options WHERE aid = 10 ORDER BY ordering, name
  65. *************************** 8. ROW ***************************
  66.      Id: 49250
  67.    USER: root
  68.    Host: localhost
  69.      db: NULL
  70. Command: Query
  71.    TIME: 0
  72.   State: NULL
  73.    Info: SHOW FULL processlist
  74. 8 ROWS IN SET (0.00 sec)
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!