Advertisement
Guest User

Untitled

a guest
Feb 8th, 2013
237
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.02 KB | None | 0 0
  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')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement