select id,partno,brandshort from pdf order by hit desc limit 40 [ RunTime:0.007331s ]
select pdf.pdf_file_id,pdf.id,pdf.partno,pdf.note,pdf.taginfo,pdf.brandshort,pdf.hit,pdf_file.foldpath,pdf_file.foldpath2,pdf_file.page,pdf_file.brandid,pdf_file.fold,pdf_file.fold2,pdf_file.filename,pdf_file.filesize,pdf_file.page from pdf left join pdf_file on pdf.pdf_file_id=pdf_file.id where pdf_file.id in ( select t.id from (select id from pdf_file order by id desc limit 2000) as t ) order by rand() limit 6 [ RunTime:0.079044s ]
