Misiur

Untitled

Feb 16th, 2014
162
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.34 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.000818  Lock_time: 0.000196 Rows_sent: 1  Rows_examined: 1
  6. SET TIMESTAMP=1392561327;
  7. SELECT password FROM users WHERE name = 'Foo_Bar';
  8. # TIME: 140216 15:35:32
  9. # USER@Host: SAMP_1[SAMP_1] @ localhost []
  10. # Query_time: 0.053365  Lock_time: 0.000182 Rows_sent: 0  Rows_examined: 0
  11. SET TIMESTAMP=1392561332;
  12. INSERT INTO logs VALUES (NULL, 'logins', '(16/2/2014)[15:35:32] Foo_Bar Has accepted the terms and conditions.');
  13. # TIME: 140216 15:35:33
  14. # USER@Host: SAMP_1[SAMP_1] @ localhost []
  15. # Query_time: 0.001927  Lock_time: 0.000226 Rows_sent: 1  Rows_examined: 1
  16. SET TIMESTAMP=1392561333;
  17. SELECT u.* FROM users u WHERE u.name = 'Foo_Bar' LIMIT 0,1;
  18. # TIME: 140216 15:35:36
  19. # USER@Host: SAMP_1[SAMP_1] @ localhost []
  20. # Query_time: 2.778103  Lock_time: 0.000504 Rows_sent: 84  Rows_examined: 507332
  21. SET TIMESTAMP=1392561336;
  22. 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;
  23. # USER@Host: SAMP_1[SAMP_1] @ localhost []
  24. # Query_time: 0.031083  Lock_time: 0.000129 Rows_sent: 0  Rows_examined: 0
  25. SET TIMESTAMP=1392561336;
  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.024639  Lock_time: 0.000105 Rows_sent: 0  Rows_examined: 0
  29. SET TIMESTAMP=1392561336;
  30. INSERT INTO logs VALUES (NULL, 'logins', '(16/2/2014)[15:35:36] Foo_Bar Has logged in under IP 87.115.246.0.');
  31. # USER@Host: SAMP_1[SAMP_1] @ localhost []
  32. # Query_time: 0.000504  Lock_time: 0.000139 Rows_sent: 0  Rows_examined: 12
  33. SET TIMESTAMP=1392561336;
  34. SELECT * FROM vehicles WHERE owner = 'Foo_Bar' ORDER BY id ASC LIMIT 0, 2;
Advertisement
Add Comment
Please, Sign In to add comment