API tools faq
paste
Advertisement
gerberb2

Mariadb Query Log

gerberb2
Jan 26th, 2017
163
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.16 KB | None | 0 0
raw download clone embed print report
  1. /usr/sbin/mysqld, Version: 10.0.28-MariaDB (SLE 12 SP1 package). started with:
  2. Tcp port: 0 Unix socket: (null)
  3. Time Id Command Argument
  4. 170126 20:23:19 4 Connect slh@localhost as anonymous on microfibercleaningclothes
  5. 4 Query select `weight` from `products` where `sku` = '1124A'
  6. 4 Query select `sale_price` from `products` where `sku` = '1124A'
  7. 4 Query select `price` from `products` where `sku` = '1124A'
  8. 4 Query select `related` from `products` where `sku` = '1124A'
  9. 4 Query select `weight` from `products` where `sku` = '1124A'
  10. 4 Query select `sale_price` from `products` where `sku` = '1124A'
  11. 4 Query select `price` from `products` where `sku` = '1124A'
  12. 4 Query select `related` from `products` where `sku` = '1124A'
  13. 4 Query select `weight` from `products` where `sku` = '1124A'
  14. 4 Quit
  15. 170126 20:23:20 5 Connect slh@localhost as anonymous on microfibercleaningclothes
  16. 5 Query select `weight` from `products` where `sku` = '1124A'
  17. 5 Query select `sale_price` from `products` where `sku` = '1124A'
  18. 5 Query select `price` from `products` where `sku` = '1124A'
  19. 5 Query select `related` from `products` where `sku` = '1124A'
  20. 5 Query select `weight` from `products` where `sku` = '1124A'
  21. 5 Query select `sale_price` from `products` where `sku` = '1124A'
  22. 5 Query select `price` from `products` where `sku` = '1124A'
  23. 5 Query select `related` from `products` where `sku` = '1124A'
  24. 5 Query select `weight` from `products` where `sku` = '1124A'
  25. 5 Query select `sale_price` from `products` where `sku` = '1124A'
  26. 5 Query select `price` from `products` where `sku` = '1124A'
  27. 5 Query select `related` from `products` where `sku` = '1124A'
  28. 5 Query select `sale_price` from `products` where `sku` = '1124A'
  29. 5 Query select `price` from `products` where `sku` = '1124A'
  30. 5 Query select `related` from `products` where `sku` = '1124A'
  31. 5 Query select * from country
  32. 5 Query select * from state
  33. 5 Quit
  34. 170126 20:23:28 6 Connect slh@localhost as anonymous on microfibercleaningclothes
  35. 6 Query select `weight` from `products` where `sku` = '1124A'
  36. 6 Query select `sale_price` from `products` where `sku` = '1124A'
  37. 6 Query select `price` from `products` where `sku` = '1124A'
  38. 6 Query select `related` from `products` where `sku` = '1124A'
  39. 6 Query select `weight` from `products` where `sku` = '1124A'
  40. 6 Query select `sale_price` from `products` where `sku` = '1124A'
  41. 6 Query select `price` from `products` where `sku` = '1124A'
  42. 6 Query select `related` from `products` where `sku` = '1124A'
  43. 6 Query select `weight` from `products` where `sku` = '1124A'
  44. 6 Query select `shipmodes` from `state` WHERE `state` = 'UT' AND `country` = 'US'
  45. 6 Query select `shipmodes` from `country` where `code` = 'US'
  46. 6 Query select `sale_price` from `products` where `sku` = '1124A'
  47. 6 Query select `price` from `products` where `sku` = '1124A'
  48. 6 Query select `related` from `products` where `sku` = '1124A'
  49. 6 Query select `weight` from `products` where `sku` = '1124A'
  50. 6 Query select `weight` from `products` where `sku` = '1124A'
  51. 6 Query select `weight` from `products` where `sku` = '1124A'
  52. 6 Query select `weight` from `products` where `sku` = '1124A'
  53. 6 Query select `sale_price` from `products` where `sku` = '1124A'
  54. 6 Query select `price` from `products` where `sku` = '1124A'
  55. 6 Query select `related` from `products` where `sku` = '1124A'
  56. 6 Query select `weight` from `products` where `sku` = '1124A'
  57. 6 Query select `weight` from `products` where `sku` = '1124A'
  58. 6 Query select `weight` from `products` where `sku` = '1124A'
  59. 6 Query select `weight` from `products` where `sku` = '1124A'
  60. 6 Quit
  61. 170126 20:23:36 7 Connect slh@localhost as anonymous on microfibercleaningclothes
  62. 7 Query select shipmodes from state where state = 'UT' and country = 'US'
  63. 7 Query select `shipmodes` from `country` where `code` = 'US'
  64. 7 Query select `weight` from `products` where `sku` = '1124A'
  65. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  66. 7 Query select `price` from `products` where `sku` = '1124A'
  67. 7 Query select `related` from `products` where `sku` = '1124A'
  68. 7 Query select `weight` from `products` where `sku` = '1124A'
  69. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  70. 7 Query select `price` from `products` where `sku` = '1124A'
  71. 7 Query select `related` from `products` where `sku` = '1124A'
  72. 7 Query select `weight` from `products` where `sku` = '1124A'
  73. 7 Query select * from `pricing` where `sku` = '1124A'
  74. 7 Query select * from `options` where `code` = '1124A'
  75. 7 Query select `weight` from `products` where `sku` = '1124A'
  76. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  77. 7 Query select `price` from `products` where `sku` = '1124A'
  78. 7 Query select `related` from `products` where `sku` = '1124A'
  79. 7 Query select `weight` from `products` where `sku` = '1124A'
  80. 7 Query select `description` from `products` where `sku` = '1124A'
  81. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  82. 7 Query select `price` from `products` where `sku` = '1124A'
  83. 7 Query select `related` from `products` where `sku` = '1124A'
  84. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  85. 7 Query select `price` from `products` where `sku` = '1124A'
  86. 7 Query select `related` from `products` where `sku` = '1124A'
  87. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  88. 7 Query select `price` from `products` where `sku` = '1124A'
  89. 7 Query select `related` from `products` where `sku` = '1124A'
  90. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  91. 7 Query select `price` from `products` where `sku` = '1124A'
  92. 7 Query select `related` from `products` where `sku` = '1124A'
  93. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  94. 7 Query select `price` from `products` where `sku` = '1124A'
  95. 7 Query select `related` from `products` where `sku` = '1124A'
  96. 7 Query select `weight` from `products` where `sku` = '1124A'
  97. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  98. 7 Query select `price` from `products` where `sku` = '1124A'
  99. 7 Query select `related` from `products` where `sku` = '1124A'
  100. 7 Query select `weight` from `products` where `sku` = '1124A'
  101. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  102. 7 Query select `price` from `products` where `sku` = '1124A'
  103. 7 Query select `related` from `products` where `sku` = '1124A'
  104. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  105. 7 Query select `price` from `products` where `sku` = '1124A'
  106. 7 Query select `related` from `products` where `sku` = '1124A'
  107. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  108. 7 Query select `price` from `products` where `sku` = '1124A'
  109. 7 Query select `related` from `products` where `sku` = '1124A'
  110. 7 Query select `mail_list` from `userdb` where `username` = 'slh'
  111. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  112. 7 Query select `price` from `products` where `sku` = '1124A'
  113. 7 Query select `related` from `products` where `sku` = '1124A'
  114. 7 Query select `weight` from `products` where `sku` = '1124A'
  115. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  116. 7 Query select `price` from `products` where `sku` = '1124A'
  117. 7 Query select `related` from `products` where `sku` = '1124A'
  118. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  119. 7 Query select `price` from `products` where `sku` = '1124A'
  120. 7 Query select `related` from `products` where `sku` = '1124A'
  121. 7 Query select `sale_price` from `products` where `sku` = '1124A'
  122. 7 Query select `price` from `products` where `sku` = '1124A'
  123. 7 Query select `related` from `products` where `sku` = '1124A'
  124. 7 Query select `credit_limit` from `userdb` where `username` = 'slh'
  125. 7 Quit
  126. 170126 20:24:08 8 Connect slh@localhost as anonymous on microfibercleaningclothes
  127. 8 Query select `quantity` from `inventory` where `sku` = '1124A'
  128. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  129. 8 Query select `price` from `products` where `sku` = '1124A'
  130. 8 Query select `related` from `products` where `sku` = '1124A'
  131. 8 Query select `weight` from `products` where `sku` = '1124A'
  132. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  133. 8 Query select `price` from `products` where `sku` = '1124A'
  134. 8 Query select `related` from `products` where `sku` = '1124A'
  135. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  136. 8 Query select `price` from `products` where `sku` = '1124A'
  137. 8 Query select `related` from `products` where `sku` = '1124A'
  138. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  139. 8 Query select `price` from `products` where `sku` = '1124A'
  140. 8 Query select `related` from `products` where `sku` = '1124A'
  141. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  142. 8 Query select `price` from `products` where `sku` = '1124A'
  143. 8 Query select `related` from `products` where `sku` = '1124A'
  144. 8 Query select `weight` from `products` where `sku` = '1124A'
  145. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  146. 8 Query select `price` from `products` where `sku` = '1124A'
  147. 8 Query select `related` from `products` where `sku` = '1124A'
  148. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  149. 8 Query select `price` from `products` where `sku` = '1124A'
  150. 8 Query select `related` from `products` where `sku` = '1124A'
  151. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  152. 8 Query select `price` from `products` where `sku` = '1124A'
  153. 8 Query select `related` from `products` where `sku` = '1124A'
  154. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  155. 8 Query select `price` from `products` where `sku` = '1124A'
  156. 8 Query select `related` from `products` where `sku` = '1124A'
  157. 8 Query select `weight` from `products` where `sku` = '1124A'
  158. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  159. 8 Query select `price` from `products` where `sku` = '1124A'
  160. 8 Query select `related` from `products` where `sku` = '1124A'
  161. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  162. 8 Query select `price` from `products` where `sku` = '1124A'
  163. 8 Query select `related` from `products` where `sku` = '1124A'
  164. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  165. 8 Query select `price` from `products` where `sku` = '1124A'
  166. 8 Query select `related` from `products` where `sku` = '1124A'
  167. 170126 20:24:09 8 Query select usernick from userdb where usernick = 'U00031'
  168. 8 Query select `username` from `userdb` where `username` = 'U00031'
  169. 8 Query select `username` from `userdb` where `username` = 'U00031'
  170. 8 Query insert into `userdb` (`username`) VALUES ('U00031')
  171. 8 Query update `userdb` SET `usernick` = 'U00031' where `username` = 'U00031'
  172. 8 Query select `username` from `userdb` where `username` = 'U00031'
  173. 8 Query insert into `userdb` (`username`) VALUES ('U00031')
  174. 8 Query update `userdb` SET `password` = '$2y$13$vdWvosNBeyKXM9a2mACTZgXzZzONVfWxx5yRHPcCodcBm1L7wKvWc' where `username` = 'U00031'
  175. 8 Query select `username` from `userdb` where `username` = 'U00031'
  176. 8 Query insert into `userdb` (`username`) VALUES ('U00031')
  177. 8 Query update `userdb` SET `created` = '2017-01-26 20:24:09' where `username` = 'U00031'
  178. 8 Query select `username` from `userdb` where `username` = 'U00031'
  179. 8 Query select username from userdb where usernick = 'U00031'
  180. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  181. 8 Query select `price` from `products` where `sku` = '1124A'
  182. 8 Query select `related` from `products` where `sku` = '1124A'
  183. 8 Query select `weight` from `products` where `sku` = '1124A'
  184. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  185. 8 Query select `price` from `products` where `sku` = '1124A'
  186. 8 Query select `related` from `products` where `sku` = '1124A'
  187. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  188. 8 Query select `price` from `products` where `sku` = '1124A'
  189. 8 Query select `related` from `products` where `sku` = '1124A'
  190. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  191. 8 Query select `price` from `products` where `sku` = '1124A'
  192. 8 Query select `related` from `products` where `sku` = '1124A'
  193. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  194. 8 Query select `price` from `products` where `sku` = '1124A'
  195. 8 Query select `related` from `products` where `sku` = '1124A'
  196. 8 Query select `weight` from `products` where `sku` = '1124A'
  197. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  198. 8 Query select `price` from `products` where `sku` = '1124A'
  199. 8 Query select `related` from `products` where `sku` = '1124A'
  200. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  201. 8 Query select `price` from `products` where `sku` = '1124A'
  202. 8 Query select `related` from `products` where `sku` = '1124A'
  203. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  204. 8 Query select `price` from `products` where `sku` = '1124A'
  205. 8 Query select `related` from `products` where `sku` = '1124A'
  206. 8 Query select `code` from `transactions` where `code` = '1014'
  207. 8 Query INSERT INTO `transactions` VALUES ('1014', '', '1014', 'Ikjq6pAS', '', 'free_or_upsg (UPS Ground)', '1', '16.8', '5.93', '0.00', '1.15', '23.88', 'Boyd Lynn', 'Gerber', 'ZENEZ', '1042 East Fort UnionBlvd. #135', '', 'Midvale', 'UT', '84047', 'US', '801-849-0213', '801-849-0213', NULL, 'gerberb@zenez.com', '', '', '', '', '', '', '', '', '', '', '20170126 20:24:09', '20170126', '4', 'credit_card', '', '', '', '', NULL, 'pending', '', '', '', '', '0', '0', '0', '', NULL, NULL, NULL)
  208. 8 Query select `weight` from `products` where `sku` = '1124A'
  209. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  210. 8 Query select `price` from `products` where `sku` = '1124A'
  211. 8 Query select `related` from `products` where `sku` = '1124A'
  212. 8 Query select `weight` from `products` where `sku` = '1124A'
  213. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  214. 8 Query select `price` from `products` where `sku` = '1124A'
  215. 8 Query select `related` from `products` where `sku` = '1124A'
  216. 8 Query select `weight` from `products` where `sku` = '1124A'
  217. 8 Query select * from `pricing` where `sku` = '1124A'
  218. 8 Query select * from `options` where `code` = '1124A'
  219. 8 Query select `weight` from `products` where `sku` = '1124A'
  220. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  221. 8 Query select `price` from `products` where `sku` = '1124A'
  222. 8 Query select `related` from `products` where `sku` = '1124A'
  223. 8 Query select `weight` from `products` where `sku` = '1124A'
  224. 8 Query select `description` from `products` where `sku` = '1124A'
  225. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  226. 8 Query select `price` from `products` where `sku` = '1124A'
  227. 8 Query select `related` from `products` where `sku` = '1124A'
  228. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  229. 8 Query select `price` from `products` where `sku` = '1124A'
  230. 8 Query select `related` from `products` where `sku` = '1124A'
  231. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  232. 8 Query select `price` from `products` where `sku` = '1124A'
  233. 8 Query select `related` from `products` where `sku` = '1124A'
  234. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  235. 8 Query select `price` from `products` where `sku` = '1124A'
  236. 8 Query select `related` from `products` where `sku` = '1124A'
  237. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  238. 8 Query select `price` from `products` where `sku` = '1124A'
  239. 8 Query select `related` from `products` where `sku` = '1124A'
  240. 8 Query select `weight` from `products` where `sku` = '1124A'
  241. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  242. 8 Query select `price` from `products` where `sku` = '1124A'
  243. 8 Query select `related` from `products` where `sku` = '1124A'
  244. 8 Query select `weight` from `products` where `sku` = '1124A'
  245. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  246. 8 Query select `price` from `products` where `sku` = '1124A'
  247. 8 Query select `related` from `products` where `sku` = '1124A'
  248. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  249. 8 Query select `price` from `products` where `sku` = '1124A'
  250. 8 Query select `related` from `products` where `sku` = '1124A'
  251. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  252. 8 Query select `price` from `products` where `sku` = '1124A'
  253. 8 Query select `related` from `products` where `sku` = '1124A'
  254. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  255. 8 Query select `price` from `products` where `sku` = '1124A'
  256. 8 Query select `related` from `products` where `sku` = '1124A'
  257. 8 Query select `weight` from `products` where `sku` = '1124A'
  258. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  259. 8 Query select `price` from `products` where `sku` = '1124A'
  260. 8 Query select `related` from `products` where `sku` = '1124A'
  261. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  262. 8 Query select `price` from `products` where `sku` = '1124A'
  263. 8 Query select `related` from `products` where `sku` = '1124A'
  264. 8 Query select `sale_price` from `products` where `sku` = '1124A'
  265. 8 Query select `price` from `products` where `sku` = '1124A'
  266. 8 Query select `related` from `products` where `sku` = '1124A'
  267. 8 Query select `credit_limit` from `userdb` where `username` = ''
  268. 8 Quit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!