SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001214s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000572s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001055s ]
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.000586s ]
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.000611s ]
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.000584s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000690s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001229s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 469952 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000799s ]
SELECT * FROM `tp_cate` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000542s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000590s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001100s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',469952,') > 0 ) AND `status` = 1 [ RunTime:0.000761s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 40 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.157589s ]
SELECT * FROM `tp_soft` WHERE `id` IN (115836,244005,474960,433349,178713,167486,152715,301764,280606,280505,277561,90590,91417,321361,122657,302512) AND `status` = '1' AND `id` <> 469952 [ RunTime:0.002365s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '我的钓鱼%' AND `status` = '1' AND `id` NOT IN (469952,90590,91417,115836,122657,152715,167486,178713,244005,277561,280505,280606,301764,302512,321361,433349,474960) [ RunTime:0.004854s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.233438s ]
SELECT * FROM `tp_soft` WHERE `id` IN (238404,219943,263612,171123,161589) AND `id` NOT IN (469952,90590,91417,115836,122657,152715,167486,178713,244005,277561,280505,280606,301764,302512,321361,433349,474960,320983,298944,210823,125802,460957,238330,280579,125813) [ RunTime:0.001569s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.194466s ]
SELECT * FROM `tp_soft` WHERE `id` IN (123241,110811,188914,106326,136969) AND `status` = '1' AND `id` NOT IN (469952,90590,91417,115836,122657,152715,167486,178713,244005,277561,280505,280606,301764,302512,321361,433349,474960,320983,298944,210823,125802,460957,238330,280579,125813,161589,171123,219943,238404,263612) [ RunTime:0.002114s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000654s ]
共有 0条评论