SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001580s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000586s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001275s ]
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.000431s ]
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.000358s ]
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.000293s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000459s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001220s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 478357 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000733s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000348s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001067s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',478357,') > 0 ) AND `status` = 1 [ RunTime:0.000636s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.526182s ]
SELECT * FROM `tp_soft` WHERE `id` IN (474111,270094,478746,242317,462931,271217,467748,181691,232059,249852,251992,231127,269404,474008,233201,462908) AND `status` = '1' AND `id` <> 478357 [ RunTime:0.003292s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '萧内网萧%' AND `status` = '1' AND `id` NOT IN (478357,181691,231127,232059,233201,242317,249852,251992,269404,270094,271217,462908,462931,467748,474008,474111,478746) [ RunTime:0.006764s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.220084s ]
SELECT * FROM `tp_soft` WHERE `id` IN (461911,208279,238454,177153,458598) AND `id` NOT IN (478357,181691,231127,232059,233201,242317,249852,251992,269404,270094,271217,462908,462931,467748,474008,474111,478746) [ RunTime:0.001655s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.354356s ]
SELECT * FROM `tp_soft` WHERE `id` IN (473933,467741,156703,157042,136127) AND `status` = '1' AND `id` NOT IN (478357,181691,231127,232059,233201,242317,249852,251992,269404,270094,271217,462908,462931,467748,474008,474111,478746,177153,208279,238454,458598,461911) [ RunTime:0.002271s ]
共有 0条评论