SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001656s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000716s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001387s ]
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.000687s ]
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.000669s ]
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.000435s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000600s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001366s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 481028 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000940s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000538s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001112s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',481028,') > 0 ) AND `status` = 1 [ RunTime:0.000879s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.235313s ]
SELECT * FROM `tp_soft` WHERE `id` IN (135035,280651,190483,109850,275139,209935,273234,276011,160690,116502,112235,95670,91184,91278,169121,470506) AND `status` = '1' AND `id` <> 481028 [ RunTime:0.003216s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '铁甲钢拳%' AND `status` = '1' AND `id` NOT IN (481028,91184,91278,95670,109850,112235,116502,135035,160690,169121,190483,209935,273234,275139,276011,280651,470506) [ RunTime:0.021326s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.212998s ]
SELECT * FROM `tp_soft` WHERE `id` IN (251838,162364,223642,229751,229604) AND `id` NOT IN (481028,91184,91278,95670,109850,112235,116502,135035,160690,169121,190483,209935,273234,275139,276011,280651,470506,213292,468908,116875,475703,173047,190380,249994,142025,94862,249618) [ RunTime:0.001463s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.167741s ]
SELECT * FROM `tp_soft` WHERE `id` IN (140210,215316,471371,154142,111058) AND `status` = '1' AND `id` NOT IN (481028,91184,91278,95670,109850,112235,116502,135035,160690,169121,190483,209935,273234,275139,276011,280651,470506,213292,468908,116875,475703,173047,190380,249994,142025,94862,249618,162364,223642,229604,229751,251838) [ RunTime:0.013091s ]
共有 0条评论