SHOW FULL COLUMNS FROM `videos` [ RunTime:0.000258s ]
SELECT * FROM `videos` WHERE `subject_areas` IS NOT NULL AND `abstract` IS NOT NULL AND `publish_date` IS NOT NULL AND `pdf_url` IS NOT NULL AND `view_count` > 0 ORDER BY `id` ASC LIMIT 18,9 [ RunTime:0.000234s ]
SELECT COUNT(*) AS think_count FROM `videos` WHERE `subject_areas` IS NOT NULL AND `abstract` IS NOT NULL AND `publish_date` IS NOT NULL AND `pdf_url` IS NOT NULL AND `view_count` > 0 LIMIT 1 [ RunTime:0.000142s ]
SELECT * FROM `videos` WHERE `subject_areas` IS NOT NULL AND `view_count` > 0 ORDER BY `view_count` DESC LIMIT 5 [ RunTime:0.000312s ]
SinoXiv