SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001439s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000661s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001142s ]
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.000597s ]
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.000599s ]
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.000599s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000711s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001452s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 476216 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000997s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000596s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001128s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',476216,') > 0 ) AND `status` = 1 [ RunTime:0.000838s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.195672s ]
SELECT * FROM `tp_soft` WHERE `id` IN (202270,113077,91484,471437,481227,433548,137471,193153,114227,349383,163909,135041,159100,216754,472783,141131) AND `status` = '1' AND `id` <> 476216 [ RunTime:0.002848s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE 'psp高%' AND `status` = '1' AND `id` NOT IN (476216,91484,113077,114227,135041,137471,141131,159100,163909,193153,202270,216754,349383,433548,471437,472783,481227) [ RunTime:0.016167s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.276857s ]
SELECT * FROM `tp_soft` WHERE `id` IN (304831,240045,247258,479659,268661) AND `id` NOT IN (476216,91484,113077,114227,135041,137471,141131,159100,163909,193153,202270,216754,349383,433548,471437,472783,481227) [ RunTime:0.001504s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.224459s ]
SELECT * FROM `tp_soft` WHERE `id` IN (156768,274957,186101,214319,137948) AND `status` = '1' AND `id` NOT IN (476216,91484,113077,114227,135041,137471,141131,159100,163909,193153,202270,216754,349383,433548,471437,472783,481227,240045,247258,268661,304831,479659) [ RunTime:0.001929s ]
共有 0条评论