SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001911s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000639s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001370s ]
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.000518s ]
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.000419s ]
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.000397s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000567s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001514s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 480502 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000983s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000474s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001219s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',480502,') > 0 ) AND `status` = 1 [ RunTime:0.000698s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.438545s ]
SELECT * FROM `tp_soft` WHERE `id` IN (114471,476920,474003,135052,323150,323724,157225,476815,209202,188537,189744,141830,150640,114654,166009,110731) AND `status` = '1' AND `id` <> 480502 [ RunTime:0.004237s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE 'berr%' AND `status` = '1' AND `id` NOT IN (480502,110731,114471,114654,135052,141830,150640,157225,166009,188537,189744,209202,323150,323724,474003,476815,476920) [ RunTime:0.006697s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.255146s ]
SELECT * FROM `tp_soft` WHERE `id` IN (232532,179397,177131,213710,264349) AND `id` NOT IN (480502,110731,114471,114654,135052,141830,150640,157225,166009,188537,189744,209202,323150,323724,474003,476815,476920,464784,277697,134348) [ RunTime:0.001537s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.389491s ]
SELECT * FROM `tp_soft` WHERE `id` IN (149184,154854,126918,137309,95007) AND `status` = '1' AND `id` NOT IN (480502,110731,114471,114654,135052,141830,150640,157225,166009,188537,189744,209202,323150,323724,474003,476815,476920,464784,277697,134348,177131,179397,213710,232532,264349) [ RunTime:0.002351s ]
共有 0条评论