SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001248s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000579s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000904s ]
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.000548s ]
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.000446s ]
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.000400s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000471s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001004s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 475676 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000728s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000530s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000859s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',475676,') > 0 ) AND `status` = 1 [ RunTime:0.000501s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.167232s ]
SELECT * FROM `tp_soft` WHERE `id` IN (114087,149701,205520,126442,275584,480325,138903,140451,272857,189785,282112,189641,156535,323564,113628,322846) AND `status` = '1' AND `id` <> 475676 [ RunTime:0.002470s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '格斗高手%' AND `status` = '1' AND `id` NOT IN (475676,113628,114087,126442,138903,140451,149701,156535,189641,189785,205520,272857,275584,282112,322846,323564,480325) [ RunTime:0.003784s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.212804s ]
SELECT * FROM `tp_soft` WHERE `id` IN (474041,171217,266064,269325,300917) AND `id` NOT IN (475676,113628,114087,126442,138903,140451,149701,156535,189641,189785,205520,272857,275584,282112,322846,323564,480325) [ RunTime:0.001178s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.173652s ]
SELECT * FROM `tp_soft` WHERE `id` IN (481108,125437,93390,116384,435388) AND `status` = '1' AND `id` NOT IN (475676,113628,114087,126442,138903,140451,149701,156535,189641,189785,205520,272857,275584,282112,322846,323564,480325,171217,266064,269325,300917,474041) [ RunTime:0.001342s ]
共有 0条评论