优化一个SQL语句

where ＃＃＃ between * AND *

解决方案 »

  1.   

    SELECT * FROM atl_article WHERE category`in ( "0","3","2","4", "5",6","7",8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59","60","61","62","63","64","65","66","67","68","69","70","71" order by `id` desc limit 10
      

  2.   

    还是一样
    Processed in 14.4390 second(s), Database 14 Queries25000条记录的表。
    速度还是很慢
      

  3.   

    用exists，看看耗费的时间。SELECT * FROM atl_article WHERE category exists ( "0","3","2","4", "5",6","7",8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59","60","61","62","63","64","65","66","67","68","69","70","71" order by `id` desc limit 10
      

  4.   

    SELECT * FROM atl_article WHERE category exists ( "0","3","2","4", "5",6","7",8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59","60","61","62","63","64","65","66","67","68","69","70","71") order by `id` desc limit 10