方法1:
select * from table_name where uid=7103 limit 0,10;
时间: 0.029s
方法2:
select * from saas_food where id >= (select id from saas_food where uid=7103 limit 0,1)and uid=7103 limit 10;
时间: 0.030s
经过多次查询,两个方法查询效率差不多
方法1:
select * from table_name where uid=7103 limit 0,10;
时间: 0.029s
方法2:
select * from saas_food where id >= (select id from saas_food where uid=7103 limit 0,1)and uid=7103 limit 10;
时间: 0.030s
经过多次查询,两个方法查询效率差不多