SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001860s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000594s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001341s ]
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.000481s ]
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.000361s ]
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.000353s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000518s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001466s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 482147 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001071s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000472s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001190s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',482147,') > 0 ) AND `status` = 1 [ RunTime:0.000457s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.406793s ]
SELECT * FROM `tp_soft` WHERE `id` IN (181471,267182,269655,182405,170528,254806,161026,350338,177013,161919,478693,236296,461503,270886,260392,243806) AND `status` = '1' AND `id` <> 482147 [ RunTime:0.002511s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '掌门好老%' AND `status` = '1' AND `id` NOT IN (482147,161026,161919,170528,177013,181471,182405,236296,243806,254806,260392,267182,269655,270886,350338,461503,478693) [ RunTime:0.005689s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.255189s ]
SELECT * FROM `tp_soft` WHERE `id` IN (294234,475450,467653,243665,464880) AND `id` NOT IN (482147,161026,161919,170528,177013,181471,182405,236296,243806,254806,260392,267182,269655,270886,350338,461503,478693,470773,95124) [ RunTime:0.001346s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.241103s ]
SELECT * FROM `tp_soft` WHERE `id` IN (323938,80549,211245,212670,322828) AND `status` = '1' AND `id` NOT IN (482147,161026,161919,170528,177013,181471,182405,236296,243806,254806,260392,267182,269655,270886,350338,461503,478693,470773,95124,243665,294234,464880,467653,475450) [ RunTime:0.001470s ]
共有 0条评论