SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.002568s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000523s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001282s ]
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.000434s ]
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.000429s ]
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.000331s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000649s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001668s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 479146 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000796s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000403s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001154s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',479146,') > 0 ) AND `status` = 1 [ RunTime:0.000642s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.392503s ]
SELECT * FROM `tp_soft` WHERE `id` IN (238678,248287,175798,303356,271611,481996,222480,245375,349851,463948,209458,219531,231596,228362,469046,473476) AND `status` = '1' AND `id` <> 479146 [ RunTime:0.002469s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '计算机二%' AND `status` = '1' AND `id` NOT IN (479146,175798,209458,219531,222480,228362,231596,238678,245375,248287,271611,303356,349851,463948,469046,473476,481996) [ RunTime:0.005880s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.255220s ]
SELECT * FROM `tp_soft` WHERE `id` IN (176309,474256,237119,266496,170861) AND `id` NOT IN (479146,175798,209458,219531,222480,228362,231596,238678,245375,248287,271611,303356,349851,463948,469046,473476,481996,180463,203773,479148,473478,142922,479145,145025,479144,231352,142921,145305,435724,479151) [ RunTime:0.001534s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.249587s ]
SELECT * FROM `tp_soft` WHERE `id` IN (101203,153663,280618,119801,185353) AND `status` = '1' AND `id` NOT IN (479146,175798,209458,219531,222480,228362,231596,238678,245375,248287,271611,303356,349851,463948,469046,473476,481996,180463,203773,479148,473478,142922,479145,145025,479144,231352,142921,145305,435724,479151,170861,176309,237119,266496,474256) [ RunTime:0.002287s ]
共有 0条评论