some more debugging
2026-02-17 21:17:28.753 UTC [52868] - medusa - LOG: statement: select "a0"."id", "a0"."token", "a0"."revoked_at" from "api_key" as "a0" where "a0"."deleted_at" is null and "a0"."token" = 'pk_xxxx' and "a0"."type" = 'publishable' order by "a0"."id" asc
2026-02-17 21:17:28.867 UTC [52868] - medusa - LOG: statement: select "l0"."sales_channel_id", "l0"."publishable_key_id" from "publishable_api_key_sales_channel" as "l0" where "l0"."deleted_at" is null and "l0"."publishable_key_id" in ('apk_01KHPGJ8GE55F2R11WJ3WNZMMD')
2026-02-17 21:17:28.920 UTC [52868] - medusa - LOG: statement: select count(*) as "count" from "sales_channel" as "s0" where "s0"."deleted_at" is null
2026-02-17 21:17:28.921 UTC [52561] - medusa - LOG: statement: select "s0"."id" from "sales_channel" as "s0" where "s0"."deleted_at" is null order by "s0"."id" asc limit 1
2026-02-17 21:17:28.977 UTC [52868] - medusa - LOG: statement: select "p0"."id", "p0"."title", "p0"."subtitle", "p0"."description", "p0"."handle", "p0"."is_giftcard", "p0"."discountable", "p0"."thumbnail", "p0"."collection_id", "p0"."type_id", "p0"."weight", "p0"."length", "p0"."height", "p0"."width", "p0"."hs_code", "p0"."origin_country", "p0"."mid_code", "p0"."material", "p0"."created_at", "p0"."updated_at", "p0"."type_id" as "type_id", "p0"."collection_id" as "collection_id" from "product" as "p0" left join "image" as "p1" on "p0"."id" = "p1"."product_id" where "p0"."id" in (select "p0"."id" from (select "p0"."id" from "product" as "p0" left join "image" as "p1" on "p0"."id" = "p1"."product_id" where "p0"."deleted_at" is null and "p0"."status" = 'published' group by "p0"."id" order by min("p0"."id") asc, min("p1"."rank") asc limit 1) as "p0") order by "p0"."id" asc, "p1"."rank" asc
i believe this proves this is a bug as select "s0"."id" from "sales_channel" as "s0" where "s0"."deleted_at" is null order by "s0"."id" asc limit 1 select the first SC but is not passed to the subsequent query.