SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001766s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001190s ]
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.000405s ]
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.000388s ]
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.000329s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000499s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001402s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 480850 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000779s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000396s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000738s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',480850,') > 0 ) AND `status` = 1 [ RunTime:0.000516s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.223938s ]
SELECT * FROM `tp_soft` WHERE `id` IN (165105,320347,149278,321329,131032,140480,193351,435395,214861,184961,136403,473870,121920,211505,279725,185727) AND `status` = '1' AND `id` <> 480850 [ RunTime:0.004735s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '宝宝认蚂%' AND `status` = '1' AND `id` NOT IN (480850,121920,131032,136403,140480,149278,165105,184961,185727,193351,211505,214861,279725,320347,321329,435395,473870) [ RunTime:0.007127s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.580164s ]
SELECT * FROM `tp_soft` WHERE `id` IN (464434,247429,255656,237044,262718) AND `id` NOT IN (480850,121920,131032,136403,140480,149278,165105,184961,185727,193351,211505,214861,279725,320347,321329,435395,473870,191328,235981) [ RunTime:0.001646s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.318903s ]
SELECT * FROM `tp_soft` WHERE `id` IN (150517,469938,468549,157514,159093) AND `status` = '1' AND `id` NOT IN (480850,121920,131032,136403,140480,149278,165105,184961,185727,193351,211505,214861,279725,320347,321329,435395,473870,191328,235981,237044,247429,255656,262718,464434) [ RunTime:0.002248s ]
共有 0条评论