SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001173s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000560s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000984s ]
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.000519s ]
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.000412s ]
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.000325s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000441s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001404s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 479259 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000867s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000441s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001091s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',479259,') > 0 ) AND `status` = 1 [ RunTime:0.000575s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.222805s ]
SELECT * FROM `tp_soft` WHERE `id` IN (224821,267607,470682,236378,221821,325767,253850,242106,222906,231505,236771,257912,221433,302025,269249,259308) AND `status` = '1' AND `id` <> 479259 [ RunTime:0.002390s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '北京市肛%' AND `status` = '1' AND `id` NOT IN (479259,221433,221821,222906,224821,231505,236378,236771,242106,253850,257912,259308,267607,269249,302025,325767,470682) [ RunTime:0.004156s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.237162s ]
SELECT * FROM `tp_soft` WHERE `id` IN (463045,245300,199676,209394,179848) AND `id` NOT IN (479259,221433,221821,222906,224821,231505,236378,236771,242106,253850,257912,259308,267607,269249,302025,325767,470682) [ RunTime:0.001513s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.325352s ]
SELECT * FROM `tp_soft` WHERE `id` IN (473823,116729,158114,275046,157417) AND `status` = '1' AND `id` NOT IN (479259,221433,221821,222906,224821,231505,236378,236771,242106,253850,257912,259308,267607,269249,302025,325767,470682,179848,199676,209394,245300,463045) [ RunTime:0.002155s ]
共有 0条评论