Products by name

Showroom LOAD (2.1ms)  SELECT  "showrooms".* FROM "showrooms" WHERE "showrooms"."auth_token" = $1 LIMIT 1  [["auth_token", "f701d9e8c728351481ef887d91b313b7"]]
  USER LOAD (3.7ms)  SELECT  "users".* FROM "users" WHERE "users"."auth_token" IS NULL LIMIT 1
  Product LOAD (95.3ms)  SELECT "products".* FROM "products" INNER JOIN "products_showrooms" ON "products"."id" = "products_showrooms"."product_id" WHERE "products_showrooms"."showroom_id" = $1 AND (LOWER(products.name) LIKE '%sub%')  [["showroom_id", 1]]
  Brand LOAD (3.3ms)  SELECT "brands".* FROM "brands" WHERE "brands"."id" IN (1)
  Category LOAD (2.4ms)  SELECT "categories".* FROM "categories" WHERE "categories"."id" IN (3481)