Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Feb 8th, 2013  |  syntax: SQL  |  size: 1.02 KB  |  views: 44  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. 0.37ms  SELECT * FROM `events` WHERE `id` = '9' LIMIT 1
  2. 0.26ms  SELECT * FROM `users` WHERE `id` = '69' LIMIT 1
  3. 0.28ms  SELECT * FROM `locations` WHERE `id` = '123' LIMIT 1
  4. 78.27ms UPDATE `events` SET `description` = 'testj' WHERE `id` = '9'
  5. 38.78ms UPDATE `locations` SET `lat` = '18.799718087569', `lng` = '-6.4599609375', `tile_id` = '4248105250', `address` = 'Oualata, Мавритания', `country` = 'Мавритания', `state` = 'Ход-эш-Шарки' WHERE `id` = '123'
  6. 0.36ms  SELECT `tags`.*, `tag_event`.`id` AS `pivot_id`, `tag_event`.`event_id` AS `pivot_event_id`, `tag_event`.`tag_id` AS `pivot_tag_id` FROM `tags` INNER JOIN `tag_event` ON `tags`.`id` = `tag_event`.`tag_id` WHERE `tag_event`.`event_id` = '9'
  7. 33.29ms INSERT IGNORE INTO `tags` (`name`) VALUES ('catch'), ('try')
  8. 0.28ms  SELECT `id` FROM `tags` WHERE `name` IN ('catch', 'try')
  9. 30.55ms INSERT INTO `tag_event` (`event_id`, `tag_id`) VALUES ('9', '152'), ('9', '146')
  10. 26.39ms DELETE FROM `tag_event` WHERE `event_id` = '9' AND `tag_id` IN ('117', '148')