SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001536s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000495s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001189s ]
SELECT `id`,`cate_name`,`cate_folder`,`module_id` FROM `tp_cate` WHERE `id` IN (14,16,8,44) OR `parent_id` IN (14,16,8,44) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000428s ]
SELECT `id`,`cate_name`,`cate_folder`,`module_id` FROM `tp_cate` WHERE `id` = 4 OR `parent_id` = 4 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000462s ]
SELECT `id`,`cate_name`,`cate_folder`,`module_id` FROM `tp_cate` WHERE `id` = 1 OR `parent_id` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000344s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000537s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001466s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 484522 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000681s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000562s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001155s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',484522,') > 0 ) AND `status` = 1 [ RunTime:0.000635s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.656335s ]
SELECT * FROM `tp_soft` WHERE `id` IN (465863,269183,261571,265738,463448,265998,477920,306527,182552,469098,227790,257206,203961,466342,227530,181355) AND `status` = '1' AND `id` <> 484522 [ RunTime:0.006074s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE 'mira%' AND `status` = '1' AND `id` NOT IN (484522,181355,182552,203961,227530,227790,257206,261571,265738,265998,269183,306527,463448,465863,466342,469098,477920) [ RunTime:0.061773s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.428662s ]
SELECT * FROM `tp_soft` WHERE `id` IN (175943,465065,226257,255072,238896) AND `id` NOT IN (484522,181355,182552,203961,227530,227790,257206,261571,265738,265998,269183,306527,463448,465863,466342,469098,477920,82342,232284,183428,251461,295120,472857) [ RunTime:0.002040s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.348018s ]
SELECT * FROM `tp_soft` WHERE `id` IN (138301,118199,436269,92954,199329) AND `status` = '1' AND `id` NOT IN (484522,181355,182552,203961,227530,227790,257206,261571,265738,265998,269183,306527,463448,465863,466342,469098,477920,82342,232284,183428,251461,295120,472857,175943,226257,238896,255072,465065) [ RunTime:0.002041s ]
共有 0条评论