Duration: 3.64425 ms , Query= select count(*) as t from `product` where state>0 and classid in (537) and ( (name like '%eye%') or itemno ='eye') Duration: 6.8325 ms , Query= select * from `product` where state>0 and classid in (537) and ( (name like '%eye%') or itemno ='eye') order by id desc limit 0,12 Duration: 0.2165 ms , Query= select classid as v from product where id=23070 Duration: 0.18525 ms , Query= select classid as v from product where id=23068 Duration: 0.16 ms , Query= select classid as v from product where id=23051 Duration: 0.16025 ms , Query= select classid as v from product where id=20069 Duration: 0.19525 ms , Query= select classid as v from product where id=11406 Duration: 0.15975 ms , Query= select classid as v from product where id=11402 Duration: 0.15175 ms , Query= select classid as v from product where id=11394 Duration: 0.1305 ms , Query= select classid as v from product where id=11392 Duration: 0.16625 ms , Query= select classid as v from product where id=11391 Duration: 0.16525 ms , Query= select classid as v from product where id=2497 Duration: 0.1745 ms , Query= select * from ptaglist where type>=0 Duration: 0.35775 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(537) group by tid Duration: 0.13475 ms , Query= select content,id from infoclass where id in (0)