Guest User

Untitled

a guest
Feb 20th, 2019
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 3.23 KB | None | 0 0
  1. sql> SELECT * from mailing_list where `group`='kalancha'
  2. [2019-02-20 11:48:25] 33 rows retrieved starting from 1 in 512ms (execution: 202ms, fetching: 310ms)
  3. sql> INSERT INTO mailing_list (email, `group`) VALUE ('makarovlanton@yandex.ru', 'kalancha')
  4. [2019-02-20 12:01:57] 1 row affected in 32ms
  5. sql> DELETE FROM zeon.mailing_list where `group` = 'kalancha'
  6. [2019-02-20 12:10:50] 34 rows affected in 44ms
  7. sql> SELECT * from mailing_list where `group`='kalancha'
  8. [2019-02-20 12:10:55] 0 rows retrieved in 76ms (execution: 64ms, fetching: 12ms)
  9. sql> SELECT * from mailing_list
  10. [2019-02-20 12:11:19] 500 rows retrieved starting from 1 in 180ms (execution: 90ms, fetching: 90ms)
  11. sql> INSERT INTO mailing_list (email, `group`) VALUE ('makarovlanton@yandex.ru', 'kalancha')
  12. [2019-02-20 12:11:29] 1 row affected in 30ms
  13. sql> SELECT * from mailing_list where `group`='kalancha'
  14. [2019-02-20 12:11:38] 1 row retrieved starting from 1 in 73ms (execution: 59ms, fetching: 14ms)
  15. sql> SELECT * from mailing_list where `group`='kalancha'
  16. [2019-02-20 12:14:25] 34 rows retrieved starting from 1 in 93ms (execution: 82ms, fetching: 11ms)
  17. sql> DELETE FROM zeon.mailing_list where `group` = 'kalancha'
  18. [2019-02-20 12:28:51] 34 rows affected in 38ms
  19. sql> INSERT INTO mailing_list (email, `group`) VALUE ('freeman_999@mail.ru', 'kalancha')
  20. [2019-02-20 12:28:57] 1 row affected in 29ms
  21. sql> SELECT * from mailing_list where `group`='kalancha'
  22. [2019-02-20 12:29:00] 1 row retrieved starting from 1 in 69ms (execution: 59ms, fetching: 10ms)
  23. sql> INSERT INTO mailing_list (email, `group`) VALUE ('makarovlanton@yandex.ru', 'kalancha')
  24. [2019-02-20 12:29:33] 1 row affected in 30ms
  25. sql> SELECT * from mailing_list where `group`='kalancha'
  26. [2019-02-20 12:29:51] 35 rows retrieved starting from 1 in 66ms (execution: 57ms, fetching: 9ms)
  27. sql> use zeon
  28. [2019-02-20 12:35:05] completed in 16ms
  29. sql> use zeon
  30. [2019-02-20 12:35:48] completed in 16ms
  31. sql> SELECT COUNT(*) AS emails, email FROM mailing_list
  32. [2019-02-20 12:42:11] 1 row retrieved starting from 1 in 63ms (execution: 56ms, fetching: 7ms)
  33. sql> SELECT COUNT(*) FROM mailing_list
  34. [2019-02-20 12:43:16] 1 row retrieved starting from 1 in 62ms (execution: 53ms, fetching: 9ms)
  35. sql> SELECT created from mailqueue where subject = 'Уважаемые клиенты!'
  36. [2019-02-20 12:56:55] 40 rows retrieved starting from 1 in 8s 790ms (execution: 8s 764ms, fetching: 26ms)
  37. sql> SELECT * from mailqueue where subject = 'Уважаемые клиенты!' and created > '2019-02-20 11:52:01'
  38. [2019-02-20 12:56:55] 2 rows retrieved starting from 1 in 91ms (execution: 61ms, fetching: 30ms)
  39. sql> SELECT * from mailqueue where subject = 'Уважаемые клиенты!' and created > '2019-02-20 09:52:01'
  40. [2019-02-20 13:00:12] 40 rows retrieved starting from 1 in 479ms (execution: 402ms, fetching: 77ms)
  41. sql> SELECT * from mailqueue where subject = 'Уважаемые клиенты!' and created > '2019-02-20 09:52:01'
  42. [2019-02-20 13:06:46] 40 rows retrieved starting from 1 in 445ms (execution: 384ms, fetching: 61ms)
  43. sql> SELECT * from mailqueue where subject = 'Уважаемые клиенты!' and created > '2019-02-20 09:52:01'
  44. [2019-02-20 13:07:14] 40 rows retrieved starting from 1 in 455ms (execution: 396ms, fetching: 59ms)
Add Comment
Please, Sign In to add comment