SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001247s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000494s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001054s ]
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.000437s ]
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.000348s ]
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.000334s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000443s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001097s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 480713 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000766s ]
SELECT * FROM `tp_cate` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000398s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000396s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000925s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',480713,') > 0 ) AND `status` = 1 [ RunTime:0.000621s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 42 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.182771s ]
SELECT * FROM `tp_soft` WHERE `id` IN (481689,476317,472873,473771,481691,476066,476476,473042,480422,483353,473955,475352,473028,476243,474844,480766) AND `status` = '1' AND `id` <> 480713 [ RunTime:0.003869s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '野蛮打击%' AND `status` = '1' AND `id` NOT IN (480713,472873,473028,473042,473771,473955,474844,475352,476066,476243,476317,476476,480422,480766,481689,481691,483353) [ RunTime:0.014295s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.396122s ]
SELECT * FROM `tp_soft` WHERE `id` IN (250983,163410,295974,221099,462207) AND `id` NOT IN (480713,472873,473028,473042,473771,473955,474844,475352,476066,476243,476317,476476,480422,480766,481689,481691,483353,116421,434509,191554,435364,165935,269478,269479,119998,467893) [ RunTime:0.001749s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.264798s ]
SELECT * FROM `tp_soft` WHERE `id` IN (152269,476133,119672,114183,186030) AND `status` = '1' AND `id` NOT IN (480713,472873,473028,473042,473771,473955,474844,475352,476066,476243,476317,476476,480422,480766,481689,481691,483353,116421,434509,191554,435364,165935,269478,269479,119998,467893,163410,221099,250983,295974,462207) [ RunTime:0.002641s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000549s ]
共有 0条评论