SHOW FULL COLUMNS FROM `ti_file_type` [ RunTime:0.003356s ]
SELECT * FROM `ti_file_type` WHERE `nav_id` = 48 AND `status` = 1 ORDER BY `sort` DESC [ RunTime:0.003197s ]
SELECT * FROM `ti_file_type` WHERE `nav_id` = 48 AND `status` = 1 ORDER BY `sort` DESC LIMIT 1 [ RunTime:0.003139s ]
SHOW FULL COLUMNS FROM `ti_file_listing` [ RunTime:0.003336s ]
SELECT * FROM `ti_file_listing` WHERE `status` = 1 AND `lang` = 'cn' AND `type_id` = 7 GROUP BY `year` ORDER BY `year` DESC [ RunTime:0.003229s ]
SELECT * FROM `ti_file_listing` WHERE `status` = 1 AND `lang` = 'cn' AND `type_id` = 7 GROUP BY `year` ORDER BY `year` DESC LIMIT 1 [ RunTime:0.003290s ]
SELECT COUNT(*) AS think_count FROM `ti_file_listing` WHERE `type_id` = 7 AND `lang` = 'cn' AND `year` = 2024 AND `status` = 1 LIMIT 1 [ RunTime:0.003282s ]
SELECT * FROM `ti_file_listing` WHERE `type_id` = 7 AND `lang` = 'cn' AND `year` = 2024 AND `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 20,10 [ RunTime:0.003284s ]
