
Untitled
By: a guest on
Feb 8th, 2013 | syntax:
SQL | size: 1.02 KB | hits: 33 | expires: Never
0.37ms SELECT * FROM `events` WHERE `id` = '9' LIMIT 1
0.26ms SELECT * FROM `users` WHERE `id` = '69' LIMIT 1
0.28ms SELECT * FROM `locations` WHERE `id` = '123' LIMIT 1
78.27ms UPDATE `events` SET `description` = 'testj' WHERE `id` = '9'
38.78ms UPDATE `locations` SET `lat` = '18.799718087569', `lng` = '-6.4599609375', `tile_id` = '4248105250', `address` = 'Oualata, Мавритания', `country` = 'Мавритания', `state` = 'Ход-эш-Шарки' WHERE `id` = '123'
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'
33.29ms INSERT IGNORE INTO `tags` (`name`) VALUES ('catch'), ('try')
0.28ms SELECT `id` FROM `tags` WHERE `name` IN ('catch', 'try')
30.55ms INSERT INTO `tag_event` (`event_id`, `tag_id`) VALUES ('9', '152'), ('9', '146')
26.39ms DELETE FROM `tag_event` WHERE `event_id` = '9' AND `tag_id` IN ('117', '148')