SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.004326s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000569s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001119s ]
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.000659s ]
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.000430s ]
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.000451s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000613s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001413s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 471009 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000979s ]
SELECT * FROM `tp_cate` WHERE `id` = 43 LIMIT 1 [ RunTime:0.000653s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000574s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001063s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',471009,') > 0 ) AND `status` = 1 [ RunTime:0.000724s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 43 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.173057s ]
SELECT * FROM `tp_soft` WHERE `id` IN (212860,165948,163569,469765,200881,162861,470513,192877,469864,201846,192460,202473,219711,202737,193558,218420) AND `status` = '1' AND `id` <> 471009 [ RunTime:0.045665s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '逍遥志0%' AND `status` = '1' AND `id` NOT IN (471009,162861,163569,165948,192460,192877,193558,200881,201846,202473,202737,212860,218420,219711,469765,469864,470513) [ RunTime:0.005616s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.278008s ]
SELECT * FROM `tp_soft` WHERE `id` IN (243468,231273,266117,257041,203534) AND `id` NOT IN (471009,162861,163569,165948,192460,192877,193558,200881,201846,202473,202737,212860,218420,219711,469765,469864,470513) [ RunTime:0.001637s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.229487s ]
SELECT * FROM `tp_soft` WHERE `id` IN (217239,480542,127104,185918,140358) AND `status` = '1' AND `id` NOT IN (471009,162861,163569,165948,192460,192877,193558,200881,201846,202473,202737,212860,218420,219711,469765,469864,470513,203534,231273,243468,257041,266117) [ RunTime:0.001928s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000503s ]
共有 0条评论