SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001537s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000661s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001203s ]
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.000549s ]
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.000475s ]
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.000428s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000628s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001194s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 480099 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000790s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000512s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001121s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',480099,') > 0 ) AND `status` = 1 [ RunTime:0.000824s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.322166s ]
SELECT * FROM `tp_soft` WHERE `id` IN (121804,108858,191974,109022,275562,112290,150193,110713,83838,469800,83345,476700,109904,189720,119542,189837) AND `status` = '1' AND `id` <> 480099 [ RunTime:0.014713s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '一起来解%' AND `status` = '1' AND `id` NOT IN (480099,83345,83838,108858,109022,109904,110713,112290,119542,121804,150193,189720,189837,191974,275562,469800,476700) [ RunTime:0.009454s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.533454s ]
SELECT * FROM `tp_soft` WHERE `id` IN (162381,483462,463631,270917,208287) AND `id` NOT IN (480099,83345,83838,108858,109022,109904,110713,112290,119542,121804,150193,189720,189837,191974,275562,469800,476700,184596,134942) [ RunTime:0.001627s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.363012s ]
SELECT * FROM `tp_soft` WHERE `id` IN (119633,92601,119471,154905,476701) AND `status` = '1' AND `id` NOT IN (480099,83345,83838,108858,109022,109904,110713,112290,119542,121804,150193,189720,189837,191974,275562,469800,476700,184596,134942,162381,208287,270917,463631,483462) [ RunTime:0.001718s ]
共有 0条评论