SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001347s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000614s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000965s ]
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.000402s ]
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.000316s ]
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.000309s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000484s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001023s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 479828 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000750s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000354s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000842s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',479828,') > 0 ) AND `status` = 1 [ RunTime:0.000397s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.315666s ]
SELECT * FROM `tp_soft` WHERE `id` IN (263544,220173,461776,181556,175163,241928,208161,270606,175556,227715,162303,254426,461165,200040,174730,171013) AND `status` = '1' AND `id` <> 479828 [ RunTime:0.002844s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '360d%' AND `status` = '1' AND `id` NOT IN (479828,162303,171013,174730,175163,175556,181556,200040,208161,220173,227715,241928,254426,263544,270606,461165,461776) [ RunTime:0.003904s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.291623s ]
SELECT * FROM `tp_soft` WHERE `id` IN (248532,479416,482231,261894,196894) AND `id` NOT IN (479828,162303,171013,174730,175163,175556,181556,200040,208161,220173,227715,241928,254426,263544,270606,461165,461776,123157) [ RunTime:0.001284s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.426175s ]
SELECT * FROM `tp_soft` WHERE `id` IN (320386,434711,321276,109376,92979) AND `status` = '1' AND `id` NOT IN (479828,162303,171013,174730,175163,175556,181556,200040,208161,220173,227715,241928,254426,263544,270606,461165,461776,123157,196894,248532,261894,479416,482231) [ RunTime:0.003709s ]
共有 0条评论