2019-08-22 14:37:56 MSK [24736-6] shop@shop_db LOCATION:  exec_execute_message, postgres.c:2048
2019-08-22 14:38:13 MSK [26383-1] shop@shop_db LOG:  00000: duration: 302824.414 ms  execute pdo_stmt_00000019: SELECT "product".*, CASE COALESCE(min(image_id), 0) WHEN 0 THEN false ELSE true END as image_exist FROM "product" LEFT JOIN "image_to_product" ON "product"."id" = "image_to_product"."product_id" LEFT JOIN "image" ON "image_to_product"."image_id" = "image"."id" LEFT JOIN (SELECT "product_id", ceil(price * (100 + COALESCE((SELECT "surcharge_percent" FROM "customer_group_surcharge_range" WHERE "customer_group_id" = 19 AND ("stock_id" = "stock_product"."stock_id" OR "stock_id" IS NULL)  AND (CEIL("stock_product"."price") BETWEEN "min_price" AND "max_price")  ORDER BY "stock_id", "min_price" LIMIT 1), 0)) / 100) AS "sprice" FROM "stock_product" WHERE ("amount" > $1) AND ("stock_id" IN (SELECT "id" FROM "stock" WHERE ("act"=$2) AND ("id" NOT IN (SELECT "stock_id" FROM "disabled_stock_to_customer_group" WHERE "customer_group_id"=$3))))) "sprice" ON sprice.product_id = product.id WHERE ("product"."id" IN (SELECT "product_id" FROM "product_to_category" WHERE "category_id"=$4)) AND ("product"."status"=$5) AND ("product"."id" IN (SELECT "product_id" FROM "stock_product" WHERE ("amount" > $6) AND ("stock_id" IN (SELECT "id" FROM "stock" WHERE ("act"=$7) AND ("id" NOT IN (SELECT "stock_id" FROM "disabled_stock_to_customer_group" WHERE "customer_group_id"=$8)))))) AND ("product"."id" IN (SELECT "product_id" FROM "product_attribute_value_to_product" WHERE (("product_attribute_id"=$9) AND ("product_attribute_value_id"=$10)) GROUP BY "product_id" HAVING COUNT("product_id") >= $11)) GROUP BY "product"."id", "product"."id", "image_to_product"."product_id" HAVING min(sprice) between $12 and $13 ORDER BY "image_exist" DESC LIMIT 10
2019-08-22 14:38:13 MSK [26383-2] shop@shop_db DETAIL:  parameters: $1 = '0', $2 = '1', $3 = '19', $4 = '3151', $5 = '1', $6 = '0', $7 = '1', $8 = '19', $9 = '30', $10 = '688', $11 = '1', $12 = '136', $13 = '177935'