SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001857s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000629s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001615s ]
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.000553s ]
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.000474s ]
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.000448s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000660s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001806s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 473478 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000987s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000518s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001357s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',473478,') > 0 ) AND `status` = 1 [ RunTime:0.000794s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.535141s ]
SELECT * FROM `tp_soft` WHERE `id` IN (213104,231204,266760,248536,259749,464930,241273,232082,230426,227684,473523,209128,183118,216985,204037,463146) AND `status` = '1' AND `id` <> 473478 [ RunTime:0.004075s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '计算机二%' AND `status` = '1' AND `id` NOT IN (473478,183118,204037,209128,213104,216985,227684,230426,231204,232082,241273,248536,259749,266760,463146,464930,473523) [ RunTime:0.008373s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.535380s ]
SELECT * FROM `tp_soft` WHERE `id` IN (222908,303341,475738,245994,201244) AND `id` NOT IN (473478,183118,204037,209128,213104,216985,227684,230426,231204,232082,241273,248536,259749,266760,463146,464930,473523,180463,203773,479146,479148,142922,479145,145025,479144,231352,142921,145305,435724,479151) [ RunTime:0.001977s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.387607s ]
SELECT * FROM `tp_soft` WHERE `id` IN (472769,92010,91483,214161,209212) AND `status` = '1' AND `id` NOT IN (473478,183118,204037,209128,213104,216985,227684,230426,231204,232082,241273,248536,259749,266760,463146,464930,473523,180463,203773,479146,479148,142922,479145,145025,479144,231352,142921,145305,435724,479151,201244,222908,245994,303341,475738) [ RunTime:0.001659s ]
共有 0条评论