Pomelo.EntityFrameworkCore.MySql icon indicating copy to clipboard operation
Pomelo.EntityFrameworkCore.MySql copied to clipboard

Paging generate SQL

Open HaoQianCheng opened this issue 3 years ago • 1 comments

var list = _adminContext.GiveMoneyLog.Include(s => s.UserClerk).Include(s => s.UserSimple).Where(exp).OrderByDescending(m => m.CreateTime).Skip((page - 1) * limit).Take(limit).ToList();

The generated SQL is as follows:

SELECT *
FROM (
    SELECT *
    FROM `GiveMoneyLog` AS `g`
    ORDER BY `g`.`CreateTime` DESC
  LIMIT 10 OFFSET 1
) AS `t`
INNER JOIN `UserClerk` AS `u` ON `t`.`UserClerkId` = `u`.`Id`
INNER JOIN (
    SELECT *
    FROM `UserSimple` AS `u0`
    WHERE `u0`.`IsDelete` = 0
) AS `t0` ON `t`.`CreateUserId` = `t0`.`Id`
ORDER BY `t`.`CreateTime` DESC

Why does paging come after join?

HaoQianCheng avatar Apr 06 '22 10:04 HaoQianCheng

00df67c5006fe176cb4e2506772489f

HaoQianCheng avatar Apr 06 '22 10:04 HaoQianCheng