select (select hp_yyname from tp_hospitalp g where a.hp_id=g.hp_id) as hp_yyname,a.hp_id,a.zxgl_dialogue,a.zxgl_id,a.zxgl_yytime,a.zxgl_lrtime,a.zxgl_name,a.zxgl_phone,a.zxgl_sex,a.zxgl_age,a.zxgl_zhenh,a.zxgl_bz,a.zxgl_status,
a.zxgl_doctor,a.zxgl_treatment,a.zxgl_jztime,a.zxgl_hfjg,b.u_name,c.zx_name,d.bz_name as ks_name,e.bz_name from tp_zxyygl a LEFT JOIN tp_user b ON a.zxgl_lrname=b.u_id LEFT JOIN tp_zxyytype c ON a.zxgl_mj=c.zx_id LEFT JOIN tp_bzgl d ON a.zxgl_ksid=d.bz_id LEFT JOIN tp_bzgl e ON a.bz_id=e.bz_id where hp_id=2 AND TO_DAYS(FROM_UNIXTIME(zxgl_lrtime))=TO_DAYS(now()) AND zxgl_lrname=58 AND 1=1 AND IF(zxgl_doctor=0,zxgl_lrname=58,1=1) order by zxgl_lrtime desc limit 0,10hp_id是索引
a.zxgl_doctor,a.zxgl_treatment,a.zxgl_jztime,a.zxgl_hfjg,b.u_name,c.zx_name,d.bz_name as ks_name,e.bz_name from tp_zxyygl a LEFT JOIN tp_user b ON a.zxgl_lrname=b.u_id LEFT JOIN tp_zxyytype c ON a.zxgl_mj=c.zx_id LEFT JOIN tp_bzgl d ON a.zxgl_ksid=d.bz_id LEFT JOIN tp_bzgl e ON a.bz_id=e.bz_id where hp_id=2 AND TO_DAYS(FROM_UNIXTIME(zxgl_lrtime))=TO_DAYS(now()) AND zxgl_lrname=58 AND 1=1 AND IF(zxgl_doctor=0,zxgl_lrname=58,1=1) order by zxgl_lrtime desc limit 0,10hp_id是索引
explain select ...
show index from ..以供分析。