SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001674s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000592s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001467s ]
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.000423s ]
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.000495s ]
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.000323s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000498s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001414s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 480825 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000918s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000455s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001092s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',480825,') > 0 ) AND `status` = 1 [ RunTime:0.001102s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.444188s ]
SELECT * FROM `tp_soft` WHERE `id` IN (140483,110322,140192,276875,475035,111056,94494,434716,190496,278223,473131,150200,110794,216753,157195,319410) AND `status` = '1' AND `id` <> 480825 [ RunTime:0.016437s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '宝宝帮帮%' AND `status` = '1' AND `id` NOT IN (480825,94494,110322,110794,111056,140192,140483,150200,157195,190496,216753,276875,278223,319410,434716,473131,475035) [ RunTime:0.006772s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.500453s ]
SELECT * FROM `tp_soft` WHERE `id` IN (170887,479567,238295,258257,464230) AND `id` NOT IN (480825,94494,110322,110794,111056,140192,140483,150200,157195,190496,216753,276875,278223,319410,434716,473131,475035) [ RunTime:0.003873s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.377429s ]
SELECT * FROM `tp_soft` WHERE `id` IN (470674,178228,146378,110818,321648) AND `status` = '1' AND `id` NOT IN (480825,94494,110322,110794,111056,140192,140483,150200,157195,190496,216753,276875,278223,319410,434716,473131,475035,170887,238295,258257,464230,479567) [ RunTime:0.003652s ]
共有 0条评论