SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001126s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000399s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000780s ]
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.000483s ]
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.000398s ]
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.000419s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000489s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.000946s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 480300 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000790s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000337s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000777s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',480300,') > 0 ) AND `status` = 1 [ RunTime:0.000544s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.168940s ]
SELECT * FROM `tp_soft` WHERE `id` IN (472881,110409,149941,119364,109341,280043,185938,278579,470675,278494,280989,468942,481256,472020,91272,113232) AND `status` = '1' AND `id` <> 480300 [ RunTime:0.003124s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '五关六将%' AND `status` = '1' AND `id` NOT IN (480300,91272,109341,110409,113232,119364,149941,185938,278494,278579,280043,280989,468942,470675,472020,472881,481256) [ RunTime:0.005034s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.209613s ]
SELECT * FROM `tp_soft` WHERE `id` IN (294636,474191,175599,300970,240867) AND `id` NOT IN (480300,91272,109341,110409,113232,119364,149941,185938,278494,278579,280043,280989,468942,470675,472020,472881,481256) [ RunTime:0.001142s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.171430s ]
SELECT * FROM `tp_soft` WHERE `id` IN (185346,135387,140403,173179,481237) AND `status` = '1' AND `id` NOT IN (480300,91272,109341,110409,113232,119364,149941,185938,278494,278579,280043,280989,468942,470675,472020,472881,481256,175599,240867,294636,300970,474191) [ RunTime:0.001691s ]
共有 0条评论