(1.6ms)  CREATE TABLE "schema_migrations" ("version" varchar NOT NULL) 
   (22.5ms)  select sqlite_version(*)
   (2.1ms)  CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateQaSubjectMeshTerms (20150311214117)
   (0.1ms)  begin transaction
   (0.7ms)  CREATE TABLE "qa_subject_mesh_terms" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "term_id" varchar, "term" varchar, "synonyms" text) 
   (0.2ms)  CREATE  INDEX "index_qa_subject_mesh_terms_on_term_id" ON "qa_subject_mesh_terms" ("term_id")
   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_subject_mesh_terms_on_term_id' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_subject_mesh_terms_on_term_id' AND type='index'

   (0.2ms)  CREATE  INDEX "index_qa_subject_mesh_terms_on_term" ON "qa_subject_mesh_terms" ("term")
  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20150311214117"]]
   (1.7ms)  commit transaction
Migrating to CreateQaMeshTree (20150311214118)
   (0.1ms)  begin transaction
   (0.6ms)  CREATE TABLE "qa_mesh_trees" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "term_id" varchar, "tree_number" varchar) 
   (0.2ms)  CREATE  INDEX "index_qa_mesh_trees_on_term_id" ON "qa_mesh_trees" ("term_id")
   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_mesh_trees_on_term_id' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_mesh_trees_on_term_id' AND type='index'

   (0.2ms)  CREATE  INDEX "index_qa_mesh_trees_on_tree_number" ON "qa_mesh_trees" ("tree_number")
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20150311214118"]]
   (1.5ms)  commit transaction
Migrating to AddTermLowerToQaSubjectMeshTerms (20150311214119)
   (0.1ms)  begin transaction
   (0.6ms)  ALTER TABLE "qa_subject_mesh_terms" ADD "term_lower" varchar
   (0.2ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_subject_mesh_terms_on_term' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_subject_mesh_terms_on_term' AND type='index'

   (0.2ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_subject_mesh_terms_on_term_id' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_subject_mesh_terms_on_term_id' AND type='index'

   (0.5ms)  CREATE  INDEX "index_qa_subject_mesh_terms_on_term_lower" ON "qa_subject_mesh_terms" ("term_lower")
   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_subject_mesh_terms_on_term_lower' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_subject_mesh_terms_on_term_lower' AND type='index'

   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_subject_mesh_terms_on_term' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_subject_mesh_terms_on_term' AND type='index'

   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_subject_mesh_terms_on_term_id' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_subject_mesh_terms_on_term_id' AND type='index'

   (27.6ms)  DROP INDEX "index_qa_subject_mesh_terms_on_term"
  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20150311214119"]]
   (1.9ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_mesh_trees_on_tree_number' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_mesh_trees_on_tree_number' AND type='index'

   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_mesh_trees_on_term_id' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_mesh_trees_on_term_id' AND type='index'

   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_subject_mesh_terms_on_term_lower' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_subject_mesh_terms_on_term_lower' AND type='index'

   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_subject_mesh_terms_on_term_id' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_subject_mesh_terms_on_term_id' AND type='index'

  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_mesh_trees_on_tree_number' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_mesh_trees_on_tree_number' AND type='index'

   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_mesh_trees_on_term_id' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_mesh_trees_on_term_id' AND type='index'

   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_subject_mesh_terms_on_term_lower' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_subject_mesh_terms_on_term_lower' AND type='index'

   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_subject_mesh_terms_on_term_id' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_subject_mesh_terms_on_term_id' AND type='index'

   (1.9ms)  CREATE TABLE "qa_mesh_trees" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "term_id" varchar, "tree_number" varchar) 
   (0.1ms)  select sqlite_version(*)
   (1.2ms)  CREATE  INDEX "index_qa_mesh_trees_on_term_id" ON "qa_mesh_trees" ("term_id")
   (0.2ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_mesh_trees_on_term_id' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_mesh_trees_on_term_id' AND type='index'

   (1.4ms)  CREATE  INDEX "index_qa_mesh_trees_on_tree_number" ON "qa_mesh_trees" ("tree_number")
   (1.7ms)  CREATE TABLE "qa_subject_mesh_terms" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "term_id" varchar, "term" varchar, "synonyms" text, "term_lower" varchar) 
   (1.9ms)  CREATE  INDEX "index_qa_subject_mesh_terms_on_term_id" ON "qa_subject_mesh_terms" ("term_id")
   (0.1ms)              SELECT sql
            FROM sqlite_master
            WHERE name='index_qa_subject_mesh_terms_on_term_id' AND type='index'
            UNION ALL
            SELECT sql
            FROM sqlite_temp_master
            WHERE name='index_qa_subject_mesh_terms_on_term_id' AND type='index'

   (1.5ms)  CREATE  INDEX "index_qa_subject_mesh_terms_on_term_lower" ON "qa_subject_mesh_terms" ("term_lower")
   (1.5ms)  CREATE TABLE "schema_migrations" ("version" varchar NOT NULL) 
   (1.3ms)  CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
   (0.2ms)  SELECT version FROM "schema_migrations"
   (1.4ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150311214119')
   (1.4ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150311214117')
   (1.4ms)  INSERT INTO "schema_migrations" (version) VALUES ('20150311214118')
   (0.5ms)  begin transaction
   (0.2ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.3ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.2ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.5ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.3ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.2ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.3ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.4ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.3ms)  rollback transaction
   (0.6ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.3ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.4ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.3ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.2ms)  select sqlite_version(*)
  Class Create Many Without Validations Or Callbacks (0.7ms)  INSERT INTO "qa_subject_mesh_terms" ("term_id","term","term_lower","synonyms") VALUES ('5','test','test','')
  Qa::SubjectMeshTerm Load (0.2ms)  SELECT  "qa_subject_mesh_terms".* FROM "qa_subject_mesh_terms" WHERE "qa_subject_mesh_terms"."term_id" = ? LIMIT 1  [["term_id", "5"]]
   (0.6ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.3ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.2ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.2ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
Processing by Qa::TermsController#search as HTML
  Parameters: {"q"=>"Tibetan", "vocab"=>"tgnlang"}
Completed 200 OK in 1ms (Views: 0.3ms | ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
Processing by Qa::TermsController#search as HTML
  Parameters: {"q"=>"Berry", "vocab"=>"loc", "sub_authority"=>"names"}
Completed 200 OK in 35ms (Views: 1.3ms | ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
Processing by Qa::TermsController#index as HTML
  Parameters: {"vocab"=>"local", "sub_authority"=>"states"}
Completed 200 OK in 26ms (Views: 2.7ms | ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
Processing by Qa::TermsController#index as HTML
  Parameters: {"vocab"=>"mesh"}
  Qa::SubjectMeshTerm Load (0.2ms)  SELECT "qa_subject_mesh_terms".* FROM "qa_subject_mesh_terms"
Completed 200 OK in 3ms (Views: 0.1ms | ActiveRecord: 0.2ms)
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
Processing by Qa::TermsController#index as HTML
  Parameters: {"vocab"=>"loc", "sub_authority"=>"relators"}
Completed 200 OK in 1ms (Views: 0.4ms | ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
Processing by Qa::TermsController#index as HTML
  Parameters: {"vocab"=>"tgnlang"}
Completed 200 OK in 0ms (Views: 0.1ms | ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
Processing by Qa::TermsController#index as HTML
  Parameters: {"vocab"=>"oclcts", "sub_authority"=>"mesh"}
Completed 200 OK in 0ms (Views: 0.1ms | ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
Processing by Qa::TermsController#search as HTML
  Parameters: {"q"=>"a query", "vocab"=>""}
Filter chain halted as :check_vocab_param rendered or redirected
Completed 404 Not Found in 0ms (ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
Processing by Qa::TermsController#show as HTML
  Parameters: {"vocab"=>"loc", "sub_authority"=>"subjects", "id"=>"sh85077565"}
Completed 200 OK in 44ms (Views: 18.2ms | ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
Processing by Qa::TermsController#show as HTML
  Parameters: {"vocab"=>"local", "sub_authority"=>"states", "id"=>"OH"}
Completed 200 OK in 5ms (Views: 0.2ms | ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
Processing by Qa::TermsController#show as HTML
  Parameters: {"vocab"=>"mesh", "id"=>"D000001"}
  Qa::SubjectMeshTerm Load (0.2ms)  SELECT  "qa_subject_mesh_terms".* FROM "qa_subject_mesh_terms" WHERE "qa_subject_mesh_terms"."term_id" = ?  ORDER BY "qa_subject_mesh_terms"."id" ASC LIMIT 1  [["term_id", "D000001"]]
Completed 200 OK in 2ms (Views: 0.1ms | ActiveRecord: 0.2ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
Processing by Qa::TermsController#search as HTML
  Parameters: {"q"=>"a query", "vocab"=>"loc"}
Filter chain halted as :init_authority rendered or redirected
Completed 404 Not Found in 2ms (ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.5ms)  begin transaction
Processing by Qa::TermsController#search as HTML
  Parameters: {"q"=>"a query", "vocab"=>"oclcts"}
Filter chain halted as :init_authority rendered or redirected
Completed 404 Not Found in 1ms (ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
Processing by Qa::TermsController#search as HTML
  Parameters: {"q"=>"a query", "vocab"=>"non-existent-authority"}
Filter chain halted as :init_authority rendered or redirected
Completed 404 Not Found in 1ms (ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
Processing by Qa::TermsController#search as HTML
  Parameters: {"q"=>"a query", "vocab"=>"loc", "sub_authority"=>"non-existent-subauthority"}
Filter chain halted as :init_authority rendered or redirected
Completed 404 Not Found in 2ms (ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
Processing by Qa::TermsController#search as HTML
  Parameters: {"q"=>"", "vocab"=>"tgnlang"}
Filter chain halted as :check_query_param rendered or redirected
Completed 404 Not Found in 1ms (ActiveRecord: 0.0ms)
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.3ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
  Class Create Many Without Validations Or Callbacks (0.4ms)  INSERT INTO "qa_subject_mesh_terms" ("term_id","term","term_lower","synonyms") VALUES ('D008288','Malaria','malaria','Marsh Fever|Plasmodium Infections|Remittent Fever|Infections, Plasmodium|Paludism|Fever, Marsh|Fever, Remittent|Infection, Plasmodium|Plasmodium Infection'),('D000001','Calcimycin','calcimycin','A-23187|A23187|Antibiotic A23187|A 23187|A23187, Antibiotic'),('D005260','Female','female','Females'),('D005261','Female Urogenital Diseases and Pregnancy Complications','female urogenital diseases and pregnancy complications',''),('D010272','Parasitic Diseases','parasitic diseases','Disease, Parasitic|Diseases, Parasitic|Parasitic Disease'),('D011528','Protozoan Infections','protozoan infections','Histomoniasis|Infections, Protozoan|Histomoniases|Infection, Protozoan|Protozoan Infection'),('D062310','Tropical Diseases','tropical diseases','Disease, Tropical|Diseases, Tropical|Tropical Disease'),('D013568','Pathological Conditions, Signs and Symptoms','pathological conditions, signs and symptoms','Symptoms and General Pathology'),('D001583','Benzoxazoles','benzoxazoles',''),('D006574','Heterocyclic Compounds, 2-Ring','heterocyclic compounds, 2-ring','2-Ring Heterocyclic Compounds|Compounds, 2-Ring Heterocyclic|Heterocyclic Compounds, 2 Ring'),('D006571','Heterocyclic Compounds','heterocyclic compounds','Compounds, Heterocyclic')
  Class Create Many Without Validations Or Callbacks (0.3ms)  INSERT INTO "qa_mesh_trees" ("term_id","tree_number") VALUES ('D008288','C03.752.530'),('D008288','C23.996.660'),('D000001','D03.438.221.173'),('D005261','C13'),('D010272','C03'),('D011528','C03.752'),('D062310','C03.883'),('D062310','C23.996'),('D013568','C23'),('D001583','D03.438.221'),('D006574','D03.438'),('D006571','D03')
  Qa::SubjectMeshTerm Load (0.1ms)  SELECT "qa_subject_mesh_terms".* FROM "qa_subject_mesh_terms" WHERE "qa_subject_mesh_terms"."term_lower" = ?  [["term_lower", "malaria"]]
  Qa::SubjectMeshTerm Load (0.1ms)  SELECT "qa_subject_mesh_terms".* FROM "qa_subject_mesh_terms" WHERE "qa_subject_mesh_terms"."term" = ?  [["term", "Malaria"]]
  Qa::SubjectMeshTerm Load (0.1ms)  SELECT "qa_subject_mesh_terms".* FROM "qa_subject_mesh_terms" WHERE "qa_subject_mesh_terms"."term_id" = ?  [["term_id", "D008288"]]
  Qa::SubjectMeshTerm Load (0.1ms)  SELECT "qa_subject_mesh_terms".* FROM "qa_subject_mesh_terms"
   (0.7ms)  rollback transaction
   (0.1ms)  begin transaction
  SQL (0.3ms)  INSERT INTO "qa_subject_mesh_terms" ("term_id", "term", "term_lower") VALUES (?, ?, ?)  [["term_id", "1"], ["term", "Mr Plow"], ["term_lower", "mr plow"]]
   (1.6ms)  commit transaction
   (0.1ms)  begin transaction
  SQL (0.3ms)  INSERT INTO "qa_subject_mesh_terms" ("term_id", "term", "term_lower") VALUES (?, ?, ?)  [["term_id", "2"], ["term", "Mr Snow"], ["term_lower", "mr snow"]]
   (1.4ms)  commit transaction
   (0.1ms)  begin transaction
  SQL (0.3ms)  INSERT INTO "qa_subject_mesh_terms" ("term_id", "term", "term_lower") VALUES (?, ?, ?)  [["term_id", "3"], ["term", "Mrs Fields"], ["term_lower", "mrs fields"]]
   (1.4ms)  commit transaction
   (0.1ms)  begin transaction
  Qa::SubjectMeshTerm Load (0.2ms)  SELECT "qa_subject_mesh_terms".* FROM "qa_subject_mesh_terms"
  Qa::SubjectMeshTerm Load (0.1ms)  SELECT "qa_subject_mesh_terms".* FROM "qa_subject_mesh_terms"
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
  Qa::SubjectMeshTerm Load (0.1ms)  SELECT  "qa_subject_mesh_terms".* FROM "qa_subject_mesh_terms" WHERE (term_lower LIKE '%') LIMIT 10
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Qa::SubjectMeshTerm Load (0.1ms)  SELECT  "qa_subject_mesh_terms".* FROM "qa_subject_mesh_terms" WHERE "qa_subject_mesh_terms"."term_id" = ?  ORDER BY "qa_subject_mesh_terms"."id" ASC LIMIT 1  [["term_id", "2"]]
   (0.1ms)  rollback transaction
  SQL (1.8ms)  DELETE FROM "qa_subject_mesh_terms"
   (0.1ms)  begin transaction
  SQL (0.3ms)  INSERT INTO "qa_subject_mesh_terms" ("term_id", "term") VALUES (?, ?)  [["term_id", "ABCDEFG"], ["term", "Glyphon"]]
   (1.5ms)  commit transaction
   (0.1ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.4ms)  INSERT INTO "qa_mesh_trees" ("term_id", "tree_number") VALUES (?, ?)  [["term_id", "ABCDEFG"], ["tree_number", "D1.2.3.4"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
  Qa::SubjectMeshTerm Load (0.3ms)  SELECT "qa_subject_mesh_terms".* FROM "qa_subject_mesh_terms" INNER JOIN qa_mesh_trees ON qa_subject_mesh_terms.term_id = qa_mesh_trees.term_id WHERE (qa_mesh_trees.tree_number = 'D1.2.3.4')
   (0.7ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.5ms)  INSERT INTO "qa_subject_mesh_terms" ("term_id", "synonyms") VALUES (?, ?)  [["term_id", "a"], ["synonyms", "b|c"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.6ms)  rollback transaction
   (0.1ms)  begin transaction
  Qa::MeshTree Load (0.2ms)  SELECT "qa_mesh_trees".* FROM "qa_mesh_trees" WHERE "qa_mesh_trees"."term_id" = ?  [["term_id", "ABCDEFG"]]
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
  SQL (0.3ms)  DELETE FROM "qa_subject_mesh_terms" WHERE "qa_subject_mesh_terms"."id" = ?  [["id", 4]]
   (1.7ms)  commit transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.4ms)  begin transaction
   (0.3ms)  rollback transaction
   (0.2ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.2ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.8ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.6ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.3ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.4ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.2ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.3ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.5ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.4ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction