-- Microsoft.EntityFrameworkCore 11.0.0
-- runtime 11.0.0

-- GET /orders?customerId=42&page=1
info: 11/10/2026 18:52:20.663 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (24ms) [Parameters=[@customerId='?' (DbType = Int32), @p='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT o0."Id", o0."BillingAddressId", o0."CarrierId", o0."CustomerId", o0."OrderedAt", o0."ShippingAddressId", o0."Status", c."Id", c."Country", c."Email", c."Name"
      FROM (
          SELECT o."Id", o."BillingAddressId", o."CarrierId", o."CustomerId", o."OrderedAt", o."ShippingAddressId", o."Status"
          FROM "Orders" AS o
          WHERE o."CustomerId" = @customerId
          ORDER BY o."OrderedAt" DESC, o."Id"
          LIMIT @p OFFSET @p
      ) AS o0
      INNER JOIN "Customers" AS c ON o0."CustomerId" = c."Id"
      ORDER BY o0."OrderedAt" DESC, o0."Id"
info: 11/10/2026 18:52:20.685 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (2ms) [Parameters=[@customerId='?' (DbType = Int32), @p='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT s."Id", s."OrderId", s."ProductId", s."Quantity", s."UnitPrice", s."Id0", s."Name", s."Price", s."Sku", o0."Id"
      FROM (
          SELECT o."Id", o."OrderedAt"
          FROM "Orders" AS o
          WHERE o."CustomerId" = @customerId
          ORDER BY o."OrderedAt" DESC, o."Id"
          LIMIT @p OFFSET @p
      ) AS o0
      INNER JOIN (
          SELECT o1."Id", o1."OrderId", o1."ProductId", o1."Quantity", o1."UnitPrice", p."Id" AS "Id0", p."Name", p."Price", p."Sku"
          FROM "OrderLines" AS o1
          INNER JOIN "Products" AS p ON o1."ProductId" = p."Id"
      ) AS s ON o0."Id" = s."OrderId"
      ORDER BY o0."OrderedAt" DESC, o0."Id"
info: 11/10/2026 18:52:20.689 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (1ms) [Parameters=[@customerId='?' (DbType = Int32), @p='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT p0."Id", p0."Amount", p0."Method", p0."OrderId", p0."PaidAt", o0."Id"
      FROM (
          SELECT o."Id", o."OrderedAt"
          FROM "Orders" AS o
          WHERE o."CustomerId" = @customerId
          ORDER BY o."OrderedAt" DESC, o."Id"
          LIMIT @p OFFSET @p
      ) AS o0
      INNER JOIN "Payments" AS p0 ON o0."Id" = p0."OrderId"
      ORDER BY o0."OrderedAt" DESC, o0."Id"

-- GET /orders/report?from=2026-10-01&days=3
info: 11/10/2026 18:52:20.713 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (3ms) [Parameters=[@from='?' (DbType = DateTime), @to='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30']
      SELECT o."Id", o."BillingAddressId", o."CarrierId", o."CustomerId", o."OrderedAt", o."ShippingAddressId", o."Status", c."Id", c."Country", c."Email", c."Name"
      FROM "Orders" AS o
      INNER JOIN "Customers" AS c ON o."CustomerId" = c."Id"
      WHERE o."OrderedAt" >= @from AND o."OrderedAt" < @to
      ORDER BY o."Id"
info: 11/10/2026 18:52:20.727 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (7ms) [Parameters=[@from='?' (DbType = DateTime), @to='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30']
      SELECT s."Id", s."OrderId", s."ProductId", s."Quantity", s."UnitPrice", s."Id0", s."Name", s."Price", s."Sku", o."Id"
      FROM "Orders" AS o
      INNER JOIN (
          SELECT o0."Id", o0."OrderId", o0."ProductId", o0."Quantity", o0."UnitPrice", p."Id" AS "Id0", p."Name", p."Price", p."Sku"
          FROM "OrderLines" AS o0
          INNER JOIN "Products" AS p ON o0."ProductId" = p."Id"
      ) AS s ON o."Id" = s."OrderId"
      WHERE o."OrderedAt" >= @from AND o."OrderedAt" < @to
      ORDER BY o."Id"
info: 11/10/2026 18:52:20.755 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (3ms) [Parameters=[@from='?' (DbType = DateTime), @to='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30']
      SELECT p0."Id", p0."Amount", p0."Method", p0."OrderId", p0."PaidAt", o."Id"
      FROM "Orders" AS o
      INNER JOIN "Payments" AS p0 ON o."Id" = p0."OrderId"
      WHERE o."OrderedAt" >= @from AND o."OrderedAt" < @to
      ORDER BY o."Id"

-- GET /orders?customerId=42&page=1, with four references
info: 11/10/2026 18:52:20.820 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (2ms) [Parameters=[@customerId='?' (DbType = Int32), @p='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT o0."Id", o0."BillingAddressId", o0."CarrierId", o0."CustomerId", o0."OrderedAt", o0."ShippingAddressId", o0."Status", c."Id", c."Country", c."Email", c."Name", a."Id", a."City", a."Country", a."PostalCode", a."Street", a0."Id", a0."City", a0."Country", a0."PostalCode", a0."Street", c0."Id", c0."Name"
      FROM (
          SELECT o."Id", o."BillingAddressId", o."CarrierId", o."CustomerId", o."OrderedAt", o."ShippingAddressId", o."Status"
          FROM "Orders" AS o
          WHERE o."CustomerId" = @customerId
          ORDER BY o."OrderedAt" DESC, o."Id"
          LIMIT @p OFFSET @p
      ) AS o0
      INNER JOIN "Customers" AS c ON o0."CustomerId" = c."Id"
      INNER JOIN "Addresses" AS a ON o0."ShippingAddressId" = a."Id"
      LEFT JOIN "Addresses" AS a0 ON o0."BillingAddressId" = a0."Id"
      LEFT JOIN "Carriers" AS c0 ON o0."CarrierId" = c0."Id"
      ORDER BY o0."OrderedAt" DESC, o0."Id"
info: 11/10/2026 18:52:20.824 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (1ms) [Parameters=[@customerId='?' (DbType = Int32), @p='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT s."Id", s."OrderId", s."ProductId", s."Quantity", s."UnitPrice", s."Id0", s."Name", s."Price", s."Sku", o0."Id"
      FROM (
          SELECT o."Id", o."OrderedAt", o."ShippingAddressId"
          FROM "Orders" AS o
          WHERE o."CustomerId" = @customerId
          ORDER BY o."OrderedAt" DESC, o."Id"
          LIMIT @p OFFSET @p
      ) AS o0
      INNER JOIN "Addresses" AS a ON o0."ShippingAddressId" = a."Id"
      INNER JOIN (
          SELECT o1."Id", o1."OrderId", o1."ProductId", o1."Quantity", o1."UnitPrice", p."Id" AS "Id0", p."Name", p."Price", p."Sku"
          FROM "OrderLines" AS o1
          INNER JOIN "Products" AS p ON o1."ProductId" = p."Id"
      ) AS s ON o0."Id" = s."OrderId"
      ORDER BY o0."OrderedAt" DESC, o0."Id"
info: 11/10/2026 18:52:20.825 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (1ms) [Parameters=[@customerId='?' (DbType = Int32), @p='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT p0."Id", p0."Amount", p0."Method", p0."OrderId", p0."PaidAt", o0."Id"
      FROM (
          SELECT o."Id", o."OrderedAt", o."ShippingAddressId"
          FROM "Orders" AS o
          WHERE o."CustomerId" = @customerId
          ORDER BY o."OrderedAt" DESC, o."Id"
          LIMIT @p OFFSET @p
      ) AS o0
      INNER JOIN "Addresses" AS a ON o0."ShippingAddressId" = a."Id"
      INNER JOIN "Payments" AS p0 ON o0."Id" = p0."OrderId"
      ORDER BY o0."OrderedAt" DESC, o0."Id"

-- GET /orders/report?from=2026-10-01&days=3, with four references
info: 11/10/2026 18:52:20.849 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (6ms) [Parameters=[@from='?' (DbType = DateTime), @to='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30']
      SELECT o."Id", o."BillingAddressId", o."CarrierId", o."CustomerId", o."OrderedAt", o."ShippingAddressId", o."Status", c."Id", c."Country", c."Email", c."Name", a."Id", a."City", a."Country", a."PostalCode", a."Street", a0."Id", a0."City", a0."Country", a0."PostalCode", a0."Street", c0."Id", c0."Name"
      FROM "Orders" AS o
      INNER JOIN "Customers" AS c ON o."CustomerId" = c."Id"
      INNER JOIN "Addresses" AS a ON o."ShippingAddressId" = a."Id"
      LEFT JOIN "Addresses" AS a0 ON o."BillingAddressId" = a0."Id"
      LEFT JOIN "Carriers" AS c0 ON o."CarrierId" = c0."Id"
      WHERE o."OrderedAt" >= @from AND o."OrderedAt" < @to
      ORDER BY o."Id"
info: 11/10/2026 18:52:20.868 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (7ms) [Parameters=[@from='?' (DbType = DateTime), @to='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30']
      SELECT s."Id", s."OrderId", s."ProductId", s."Quantity", s."UnitPrice", s."Id0", s."Name", s."Price", s."Sku", o."Id"
      FROM "Orders" AS o
      INNER JOIN "Addresses" AS a ON o."ShippingAddressId" = a."Id"
      INNER JOIN (
          SELECT o0."Id", o0."OrderId", o0."ProductId", o0."Quantity", o0."UnitPrice", p."Id" AS "Id0", p."Name", p."Price", p."Sku"
          FROM "OrderLines" AS o0
          INNER JOIN "Products" AS p ON o0."ProductId" = p."Id"
      ) AS s ON o."Id" = s."OrderId"
      WHERE o."OrderedAt" >= @from AND o."OrderedAt" < @to
      ORDER BY o."Id"
info: 11/10/2026 18:52:20.902 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (4ms) [Parameters=[@from='?' (DbType = DateTime), @to='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30']
      SELECT p0."Id", p0."Amount", p0."Method", p0."OrderId", p0."PaidAt", o."Id"
      FROM "Orders" AS o
      INNER JOIN "Addresses" AS a ON o."ShippingAddressId" = a."Id"
      INNER JOIN "Payments" AS p0 ON o."Id" = p0."OrderId"
      WHERE o."OrderedAt" >= @from AND o."OrderedAt" < @to
      ORDER BY o."Id"

-- Two required references, Customer included first
info: 11/10/2026 18:52:20.956 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT o."Id", o."BillingAddressId", o."CarrierId", o."CustomerId", o."OrderedAt", o."ShippingAddressId", o."Status", c."Id", c."Country", c."Email", c."Name", a."Id", a."City", a."Country", a."PostalCode", a."Street"
      FROM "Orders" AS o
      INNER JOIN "Customers" AS c ON o."CustomerId" = c."Id"
      INNER JOIN "Addresses" AS a ON o."ShippingAddressId" = a."Id"
      WHERE o."Id" <= 20
      ORDER BY o."Id"
info: 11/10/2026 18:52:20.959 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT p."Id", p."Amount", p."Method", p."OrderId", p."PaidAt", o."Id"
      FROM "Orders" AS o
      INNER JOIN "Addresses" AS a ON o."ShippingAddressId" = a."Id"
      INNER JOIN "Payments" AS p ON o."Id" = p."OrderId"
      WHERE o."Id" <= 20
      ORDER BY o."Id"

-- Two required references, ShippingAddress included first
info: 11/10/2026 18:52:20.971 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT o."Id", o."BillingAddressId", o."CarrierId", o."CustomerId", o."OrderedAt", o."ShippingAddressId", o."Status", a."Id", a."City", a."Country", a."PostalCode", a."Street", c."Id", c."Country", c."Email", c."Name"
      FROM "Orders" AS o
      INNER JOIN "Addresses" AS a ON o."ShippingAddressId" = a."Id"
      INNER JOIN "Customers" AS c ON o."CustomerId" = c."Id"
      WHERE o."Id" <= 20
      ORDER BY o."Id"
info: 11/10/2026 18:52:20.973 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command) 
      Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT p."Id", p."Amount", p."Method", p."OrderId", p."PaidAt", o."Id"
      FROM "Orders" AS o
      INNER JOIN "Customers" AS c ON o."CustomerId" = c."Id"
      INNER JOIN "Payments" AS p ON o."Id" = p."OrderId"
      WHERE o."Id" <= 20
      ORDER BY o."Id"
