medusa: TypeORM produces bad query for /products route

Bug report

Describe the bug

The routes GET /products stop working properly when dealing with a large number of products (~100.000-200.000). The ProductService.listAndCount method has a temporary fix for typeorm’s query strategy mode, but it generates a peculiar SQL query that completely hangs the database due to a problematic subquery.

System information

Medusa version (including plugins): 1.11.0 Node.js version: 18.16.0 Database: PostgreSQL Operating system: Ubuntu 22.04 Browser (if relevant): Google Chrome

Steps to reproduce the behavior

1. Add plenty of products (~100-200 thousands)
2. GET /admin/products?offset=0&limit=1

Expected behavior

Modify productRepo.findWithRelationsAndCount in ProductService.listAndCount to prevent it from generating incorrect queries.

Code snippets

Example of query:

select
    distinct "distinctAlias"."product_id" as "ids_product_id",
    "distinctAlias"."product_created_at"
from
    (
    select
        "product"."id" as "product_id",
        "product"."created_at" as "product_created_at"
    from
        "product" "product"
    left join "product_category_product" "product_categories" on
        "product_categories"."product_id" = "product"."id"
    left join "product_category" "categories" on
        "categories"."id" = "product_categories"."product_category_id"
    where
        "product"."deleted_at" is null
        ) "distinctAlias"
order by
    "distinctAlias"."product_created_at" desc,
    "product_id" asc
limit 1;