SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.002646s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000698s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001650s ]
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.000505s ]
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.000445s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000636s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001894s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 480144 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001021s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000517s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001314s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',480144,') > 0 ) AND `status` = 1 [ RunTime:0.000793s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.362968s ]
SELECT * FROM `tp_soft` WHERE `id` IN (433380,477059,351211,111669,82393,281838,114782,199409,136055,278231,278078,178273,320423,319284,320493,185133) AND `status` = '1' AND `id` <> 480144 [ RunTime:0.004010s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '太空狼人%' AND `status` = '1' AND `id` NOT IN (480144,82393,111669,114782,136055,178273,185133,199409,278078,278231,281838,319284,320423,320493,351211,433380,477059) [ RunTime:0.010425s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.597081s ]
SELECT * FROM `tp_soft` WHERE `id` IN (477356,270222,459770,298065,173377) AND `id` NOT IN (480144,82393,111669,114782,136055,178273,185133,199409,278078,278231,281838,319284,320423,320493,351211,433380,477059,218448,178013,270867,269556,273821,274915,226007,167732,468851,118102,209750,109525,109526,109527,473697,213291) [ RunTime:0.002350s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.480627s ]
SELECT * FROM `tp_soft` WHERE `id` IN (119666,279595,481356,137719,112056) AND `status` = '1' AND `id` NOT IN (480144,82393,111669,114782,136055,178273,185133,199409,278078,278231,281838,319284,320423,320493,351211,433380,477059,218448,178013,270867,269556,273821,274915,226007,167732,468851,118102,209750,109525,109526,109527,473697,213291,173377,270222,298065,459770,477356) [ RunTime:0.002923s ]
共有 0条评论