Misiur

Untitled

Feb 16th, 2014
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.33 KB | None | 0 0
  1. /usr/sbin/mysqld, Version: 5.5.35-0ubuntu0.13.10.2-log ((Ubuntu)). started WITH:
  2. Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
  3. TIME                 Id Command    Argument
  4. # USER@Host: SAMP_1[SAMP_1] @ localhost []
  5. # Query_time: 0.000898  Lock_time: 0.000196 Rows_sent: 1  Rows_examined: 1
  6. SET TIMESTAMP=1392563913;
  7. SELECT password FROM users WHERE name = 'Foo_Bar';
  8. # TIME: 140216 16:18:39
  9. # USER@Host: SAMP_1[SAMP_1] @ localhost []
  10. # Query_time: 0.048960  Lock_time: 0.000185 Rows_sent: 0  Rows_examined: 0
  11. SET TIMESTAMP=1392563919;
  12. INSERT INTO logs VALUES (NULL, 'logins', '(16/2/2014)[16:18:39] Foo_Bar Has accepted the terms and conditions.');
  13. # TIME: 140216 16:18:41
  14. # USER@Host: SAMP_1[SAMP_1] @ localhost []
  15. # Query_time: 0.001915  Lock_time: 0.000237 Rows_sent: 1  Rows_examined: 1
  16. SET TIMESTAMP=1392563921;
  17. SELECT u.* FROM users u WHERE u.name = 'Foo_Bar' LIMIT 0,1;
  18. # USER@Host: SAMP_1[SAMP_1] @ localhost []
  19. # Query_time: 0.000061  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
  20. SET TIMESTAMP=1392563921;
  21. SELECT * FROM (SELECT 0 AS mark, ua.id AS id, ua.uid AS uid, ua.offset AS colThird, ua.VALUE AS colFourth, NULL AS colFifth FROM `user_achievements` ua UNION ALL SELECT 1, uiw.* FROM `user_inv_weapons` uiw UNION ALL SELECT 2, ul.*, NULL FROM `user_licenses` ul UNION ALL SELECT 3, un.*, NULL FROM `user_notes` un    UNION ALL SELECT 4, ups.*, NULL FROM `user_punishments` ups UNION ALL SELECT 5, us.*, NULL FROM `user_skills` us UNION ALL SELECT 6, uw.* FROM `user_weapons` uw UNION ALL SELECT 7, upk.*, NULL FROM `user_perks` upk ) AS uqq WHERE uqq.uid = 1 ORDER BY mark ASC, id ASC;
  22. # TIME: 140216 16:18:42
  23. # USER@Host: SAMP_1[SAMP_1] @ localhost []
  24. # Query_time: 0.024080  Lock_time: 0.000114 Rows_sent: 0  Rows_examined: 0
  25. SET TIMESTAMP=1392563922;
  26. INSERT INTO user_aliases VALUES (NULL, '87.115.246.0', 'Foo_Bar') ON DUPLICATE KEY UPDATE id = id;
  27. # USER@Host: SAMP_1[SAMP_1] @ localhost []
  28. # Query_time: 0.024783  Lock_time: 0.000098 Rows_sent: 0  Rows_examined: 0
  29. SET TIMESTAMP=1392563922;
  30. INSERT INTO logs VALUES (NULL, 'logins', '(16/2/2014)[16:18:42] Foo_Bar Has logged in under IP 87.115.246.0.');
  31. # USER@Host: SAMP_1[SAMP_1] @ localhost []
  32. # Query_time: 0.000502  Lock_time: 0.000128 Rows_sent: 2  Rows_examined: 12
  33. SET TIMESTAMP=1392563922;
  34. SELECT * FROM vehicles WHERE owner = 'Foo_Bar' ORDER BY id ASC LIMIT 0, 2;
Advertisement
Add Comment
Please, Sign In to add comment