Processing SportsController#update_positions (for 127.0.0.1 at 2008-03-26 19:40:58) [POST]
  Session ID: BAh7CToJdXNlcmkGOgxjb3VudHJ5IgdpZToOcmV0dXJuX3RvMCIKZmxhc2hJ%0AQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVz%0AZWR7AA%3D%3D--b54e6fd96bf73b96a15f6cfa6ed4fc24dcf1e642
  Parameters: {"action"=>"update_positions", "sortable_list"=>["3", "2", "4", "5", "6", "7", "8", "9", "10", "11"], "controller"=>"admin/sports"}
  Locale Load (0.000762)   SELECT * FROM `locales` 
  Locale Columns (0.002516)   SHOW FIELDS FROM `locales`
  Locale Load (0.001546)   SELECT * FROM `locales` WHERE (`locales`.`country_code` = 'ie') LIMIT 1
  Group Load (0.000514)   SELECT * FROM `groups` 
  CACHE (0.000000)   SELECT * FROM `locales` WHERE (`locales`.`country_code` = 'ie') LIMIT 1
  User Columns (0.003802)   SHOW FIELDS FROM `users`
  User Load (0.001512)   SELECT * FROM `users` WHERE (`users`.`id` = 1) LIMIT 1
  Sport Columns (0.003293)   SHOW FIELDS FROM `sports`
  Sport Load (0.000893)   SELECT * FROM `sports` WHERE (`sports`.`id` = 3) 
  Join Table Columns (0.002549)   SHOW FIELDS FROM `groups_sports`
  Group Load (0.002243)   SELECT * FROM `groups` INNER JOIN groups_sports ON groups.id = groups_sports.group_id WHERE (groups_sports.sport_id = 3 ) 
  Group Columns (0.002650)   SHOW FIELDS FROM `groups`
  SQL (0.001031)   BEGIN
  SQL (0.000315)   DELETE FROM groups_sports WHERE sport_id = 3 AND group_id IN (1,2)
  SQL (0.000740)   COMMIT
  Join Table Columns (0.002419)   SHOW FIELDS FROM `locales_sports`
  Locale Load (0.001201)   SELECT * FROM `locales` INNER JOIN locales_sports ON locales.id = locales_sports.locale_id WHERE (locales_sports.sport_id = 3 ) 
  SQL (0.000222)   BEGIN
  SQL (0.000386)   DELETE FROM locales_sports WHERE sport_id = 3 AND locale_id IN (1,2)
  SQL (0.000784)   COMMIT
  SQL (0.000225)   BEGIN
  Sport Update (0.000829)   UPDATE `sports` SET `created_at` = '2008-03-15 02:37:00', `position` = 1, `updated_at` = '2008-03-26 19:40:58', `name` = 'Rugby' WHERE `id` = 3
  SQL (0.000668)   COMMIT
  Sport Load (0.000668)   SELECT * FROM `sports` WHERE (`sports`.`id` = 3) 
  SQL (0.000156)   BEGIN
  Sport Update (0.000392)   UPDATE `sports` SET `created_at` = '2008-03-15 02:37:00', `position` = 1, `updated_at` = '2008-03-26 19:40:58', `name` = 'Rugby' WHERE `id` = 3
  SQL (0.000212)   COMMIT
  Sport Load (0.000587)   SELECT * FROM `sports` WHERE (`sports`.`id` = 2) 
  Join Table Columns (0.002631)   SHOW FIELDS FROM `groups_sports`
  Group Load (0.001124)   SELECT * FROM `groups` INNER JOIN groups_sports ON groups.id = groups_sports.group_id WHERE (groups_sports.sport_id = 2 ) 
  SQL (0.000221)   BEGIN
  SQL (0.000365)   DELETE FROM groups_sports WHERE sport_id = 2 AND group_id IN (1,2)
  SQL (0.000702)   COMMIT
  Join Table Columns (0.002110)   SHOW FIELDS FROM `locales_sports`
  Locale Load (0.001991)   SELECT * FROM `locales` INNER JOIN locales_sports ON locales.id = locales_sports.locale_id WHERE (locales_sports.sport_id = 2 ) 
  SQL (0.000253)   BEGIN
  SQL (0.000351)   DELETE FROM locales_sports WHERE sport_id = 2 AND locale_id IN (1)
  SQL (0.000850)   COMMIT
  SQL (0.000321)   BEGIN
  Sport Update (0.000456)   UPDATE `sports` SET `created_at` = '2008-03-14 22:50:23', `position` = 2, `updated_at` = '2008-03-26 19:40:58', `name` = 'Off Field' WHERE `id` = 2
  SQL (0.000661)   COMMIT
  Sport Load (0.000821)   SELECT * FROM `sports` WHERE (`sports`.`id` = 2) 
  SQL (0.000150)   BEGIN
  Sport Update (0.000262)   UPDATE `sports` SET `created_at` = '2008-03-14 22:50:23', `position` = 2, `updated_at` = '2008-03-26 19:40:58', `name` = 'Off Field' WHERE `id` = 2
  SQL (0.000149)   COMMIT
  Sport Load (0.000529)   SELECT * FROM `sports` WHERE (`sports`.`id` = 4) 
  Join Table Columns (0.003138)   SHOW FIELDS FROM `groups_sports`
  Group Load (0.001094)   SELECT * FROM `groups` INNER JOIN groups_sports ON groups.id = groups_sports.group_id WHERE (groups_sports.sport_id = 4 )