SHOW FULL COLUMNS FROM `tb_competition_new` [ RunTime:0.005007s ]
SELECT *,(case when start_enroll > "2025-07-05 00:26:52" then 1 when end_enroll < "2025-07-05 00:26:52" then 3 else 2 end) as join_status,(app_view + m_view + pc_view) as total_view,(case when start_enroll > "2025-07-05 00:26:52" then `start_enroll` when end_enroll < "2025-07-05 00:26:52" then `end_enroll` else `end_enroll` end) as order_date FROM `tb_competition_new` WHERE `is_deleted` = 1 AND `is_hide` = 0 AND ( status=2 ) ORDER BY `join_status` ASC,`order_date` ASC,`id_compete` DESC LIMIT 0,20 [ RunTime:0.011843s ]
SELECT COUNT(*) AS think_count FROM `tb_competition_new` WHERE `is_deleted` = 1 AND `is_hide` = 0 AND ( status=2 ) [ RunTime:0.009526s ]