SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001147s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.005365s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001194s ]
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.000480s ]
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.000363s ]
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.000423s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000518s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001288s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 480398 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000783s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000362s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001036s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',480398,') > 0 ) AND `status` = 1 [ RunTime:0.000661s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.338022s ]
SELECT * FROM `tp_soft` WHERE `id` IN (178928,81396,143035,90936,204771,193459,173053,149135,434478,137181,100439,114782,276010,189853,82186,138311) AND `status` = '1' AND `id` <> 480398 [ RunTime:0.002804s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE 'null%' AND `status` = '1' AND `id` NOT IN (480398,81396,82186,90936,100439,114782,137181,138311,143035,149135,173053,178928,189853,193459,204771,276010,434478) [ RunTime:0.007773s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.294499s ]
SELECT * FROM `tp_soft` WHERE `id` IN (475569,220607,464053,259426,236528) AND `id` NOT IN (480398,81396,82186,90936,100439,114782,137181,138311,143035,149135,173053,178928,189853,193459,204771,276010,434478,268711,469574,272965,177539,469765,177532,239419,264696,275512,165472,110644,320295,114246,169270,469573,273099,110802) [ RunTime:0.001558s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.268271s ]
SELECT * FROM `tp_soft` WHERE `id` IN (159380,476059,123248,119091,476101) AND `status` = '1' AND `id` NOT IN (480398,81396,82186,90936,100439,114782,137181,138311,143035,149135,173053,178928,189853,193459,204771,276010,434478,268711,469574,272965,177539,469765,177532,239419,264696,275512,165472,110644,320295,114246,169270,469573,273099,110802,220607,236528,259426,464053,475569) [ RunTime:0.001686s ]
共有 0条评论