Advertisement
AlexPopov

Products by all params

Feb 2nd, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.64 KB | None | 0 0
  1. SQL (5.2ms)  SELECT  DISTINCT "products"."id", activities.created_at AS alias_0 FROM "products" LEFT OUTER JOIN "brands" ON "brands"."id" = "products"."brand_id" LEFT OUTER JOIN "categories" ON "categories"."id" = "products"."category_id" LEFT OUTER JOIN "activities" ON "activities"."product_id" = "products"."id" LEFT OUTER JOIN "users" ON "users"."id" = "activities"."user_id" INNER JOIN "products_showrooms" ON "products"."id" = "products_showrooms"."product_id" WHERE "products_showrooms"."showroom_id" = $1 AND "users"."id" = $2 AND (LOWER(products.name) LIKE '%form%') AND "products"."brand_id" = 416901 AND "products"."category_id" = $3 AND "activities"."type" = $4  ORDER BY activities.created_at DESC LIMIT 50  [["showroom_id", 1], ["id", 45], ["category_id", 3481], ["type", "Save"]]
  2.   SQL (1.6ms)  SELECT "products"."id" AS t0_r0, "products"."name" AS t0_r1, "products"."brand_id" AS t0_r2, "products"."created_at" AS t0_r3, "products"."updated_at" AS t0_r4, "products"."category_id" AS t0_r5, "products"."default_image" AS t0_r6, "products"."additional_images" AS t0_r7, "brands"."id" AS t1_r0, "brands"."name" AS t1_r1, "brands"."created_at" AS t1_r2, "brands"."updated_at" AS t1_r3, "brands"."products_count" AS t1_r4, "categories"."id" AS t2_r0, "categories"."name" AS t2_r1, "categories"."parent_id" AS t2_r2, "categories"."created_at" AS t2_r3, "categories"."updated_at" AS t2_r4, "activities"."id" AS t3_r0, "activities"."user_id" AS t3_r1, "activities"."product_id" AS t3_r2, "activities"."showroom_id" AS t3_r3, "activities"."type" AS t3_r4, "activities"."created_at" AS t3_r5, "activities"."updated_at" AS t3_r6, "users"."id" AS t4_r0, "users"."email" AS t4_r1, "users"."password_digest" AS t4_r2, "users"."mobile_phone" AS t4_r3, "users"."auth_token" AS t4_r4, "users"."created_at" AS t4_r5, "users"."updated_at" AS t4_r6, "users"."first_name" AS t4_r7, "users"."last_name" AS t4_r8, "users"."company" AS t4_r9, "users"."registered" AS t4_r10 FROM "products" LEFT OUTER JOIN "brands" ON "brands"."id" = "products"."brand_id" LEFT OUTER JOIN "categories" ON "categories"."id" = "products"."category_id" LEFT OUTER JOIN "activities" ON "activities"."product_id" = "products"."id" LEFT OUTER JOIN "users" ON "users"."id" = "activities"."user_id" INNER JOIN "products_showrooms" ON "products"."id" = "products_showrooms"."product_id" WHERE "products_showrooms"."showroom_id" = $1 AND "users"."id" = $2 AND (LOWER(products.name) LIKE '%form%') AND "products"."brand_id" = 416901 AND "products"."category_id" = $3 AND "activities"."type" = $4 AND "products"."id" IN (129)  ORDER BY activities.created_at DESC  [["showroom_id", 1], ["id", 45], ["category_id", 3481], ["type", "Save"]]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement