Duration: 4.95275 ms , Query= select * from `product` where state>0 and classid in (534) and ( (name like '%eye%') or itemno ='eye') order by id desc limit 0,12 Duration: 0.29 ms , Query= select classid as v from product where id=39502 Duration: 0.24675 ms , Query= select classid as v from product where id=23357 Duration: 0.19125 ms , Query= select classid as v from product where id=23356 Duration: 0.18475 ms , Query= select classid as v from product where id=22644 Duration: 0.17375 ms , Query= select classid as v from product where id=22643 Duration: 0.17975 ms , Query= select classid as v from product where id=19512 Duration: 0.19775 ms , Query= select classid as v from product where id=19511 Duration: 0.16875 ms , Query= select classid as v from product where id=19510 Duration: 0.17 ms , Query= select classid as v from product where id=19509 Duration: 0.173 ms , Query= select classid as v from product where id=19475 Duration: 0.19775 ms , Query= select classid as v from product where id=16368 Duration: 0.22275 ms , Query= select * from ptaglist where type>=0 Duration: 0.38 ms , Query= select tid,count(tid) as num from ptag inner join product on pid=product.id and state>=0 and classid in(534) group by tid Duration: 0.17275 ms , Query= select content,id from infoclass where id in (0)