SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001901s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000669s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001512s ]
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.000563s ]
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.000441s ]
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.000359s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000458s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001095s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 479271 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000749s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000401s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000889s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',479271,') > 0 ) AND `status` = 1 [ RunTime:0.000627s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.299146s ]
SELECT * FROM `tp_soft` WHERE `id` IN (482077,227397,200558,219544,230053,483408,179458,267366,181272,225001,260617,479180,475205,264209,479744,241568) AND `status` = '1' AND `id` <> 479271 [ RunTime:0.002499s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '修正健康%' AND `status` = '1' AND `id` NOT IN (479271,179458,181272,200558,219544,225001,227397,230053,241568,260617,264209,267366,475205,479180,479744,482077,483408) [ RunTime:0.005389s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.270964s ]
SELECT * FROM `tp_soft` WHERE `id` IN (253522,462031,203984,256322,412048) AND `id` NOT IN (479271,179458,181272,200558,219544,225001,227397,230053,241568,260617,264209,267366,475205,479180,479744,482077,483408) [ RunTime:0.001384s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.274177s ]
SELECT * FROM `tp_soft` WHERE `id` IN (125396,153457,173230,188553,116977) AND `status` = '1' AND `id` NOT IN (479271,179458,181272,200558,219544,225001,227397,230053,241568,260617,264209,267366,475205,479180,479744,482077,483408,203984,253522,256322,412048,462031) [ RunTime:0.001465s ]
共有 0条评论