SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001516s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000602s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001102s ]
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.000508s ]
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.000510s ]
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.000464s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000556s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001311s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 481404 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000946s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000596s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001098s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',481404,') > 0 ) AND `status` = 1 [ RunTime:0.000693s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.227399s ]
SELECT * FROM `tp_soft` WHERE `id` IN (216557,277971,109852,162876,92989,90951,275567,202574,156901,160102,114320,135777,137696,189831,186097,92516) AND `status` = '1' AND `id` <> 481404 [ RunTime:0.013169s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE 'scum%' AND `status` = '1' AND `id` NOT IN (481404,90951,92516,92989,109852,114320,135777,137696,156901,160102,162876,186097,189831,202574,216557,275567,277971) [ RunTime:0.020538s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.274604s ]
SELECT * FROM `tp_soft` WHERE `id` IN (227516,343937,182497,259368,253397) AND `id` NOT IN (481404,90951,92516,92989,109852,114320,135777,137696,156901,160102,162876,186097,189831,202574,216557,275567,277971,112731,245698,167527,110147,192535,468630,192534,223726,112732) [ RunTime:0.001720s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.223395s ]
SELECT * FROM `tp_soft` WHERE `id` IN (83256,321318,115368,156645,81442) AND `status` = '1' AND `id` NOT IN (481404,90951,92516,92989,109852,114320,135777,137696,156901,160102,162876,186097,189831,202574,216557,275567,277971,112731,245698,167527,110147,192535,468630,192534,223726,112732,182497,227516,253397,259368,343937) [ RunTime:0.018054s ]
共有 0条评论