SHOW FULL COLUMNS FROM `ti_file_type` [ RunTime:0.002844s ]
SELECT * FROM `ti_file_type` WHERE `nav_id` = 45 AND `status` = 1 ORDER BY `sort` DESC [ RunTime:0.002662s ]
SELECT * FROM `ti_file_type` WHERE `nav_id` = 45 AND `status` = 1 ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.002547s ]
SHOW FULL COLUMNS FROM `ti_file_listing` [ RunTime:0.002808s ]
SELECT * FROM `ti_file_listing` WHERE `status` = 1 AND `is_revise` = '0' AND `lang` = 'en' AND `type_id` = 4 GROUP BY `year` ORDER BY `year` DESC [ RunTime:0.002763s ]
SELECT * FROM `ti_file_listing` WHERE `status` = 1 AND `is_revise` = '1' AND `lang` = 'en' AND `type_id` = 4 GROUP BY `year` ORDER BY `year` DESC [ RunTime:0.002695s ]
SELECT COUNT(*) AS think_count FROM `ti_file_listing` WHERE `type_id` = 4 AND `lang` = 'en' AND `status` = 1 LIMIT 1 [ RunTime:0.002621s ]
SELECT * FROM `ti_file_listing` WHERE `type_id` = 4 AND `lang` = 'en' AND `status` = 1 ORDER BY `sort` DESC,`year` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.002683s ]