SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001488s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000537s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001176s ]
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.004712s ]
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.000435s ]
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.000324s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000482s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001307s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 479611 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000877s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000417s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001038s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',479611,') > 0 ) AND `status` = 1 [ RunTime:0.000612s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.407001s ]
SELECT * FROM `tp_soft` WHERE `id` IN (349427,477408,467526,263825,227320,254822,170703,161602,236336,296094,463899,209508,252607,341351,241152,271366) AND `status` = '1' AND `id` <> 479611 [ RunTime:0.002188s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE 'MT m%' AND `status` = '1' AND `id` NOT IN (479611,161602,170703,209508,227320,236336,241152,252607,254822,263825,271366,296094,341351,349427,463899,467526,477408) [ RunTime:0.003766s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.384926s ]
SELECT * FROM `tp_soft` WHERE `id` IN (458970,479450,180860,299792,262504) AND `id` NOT IN (479611,161602,170703,209508,227320,236336,241152,252607,254822,263825,271366,296094,341351,349427,463899,467526,477408,160645) [ RunTime:0.012900s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.516752s ]
SELECT * FROM `tp_soft` WHERE `id` IN (195163,119836,139881,152668,95165) AND `status` = '1' AND `id` NOT IN (479611,161602,170703,209508,227320,236336,241152,252607,254822,263825,271366,296094,341351,349427,463899,467526,477408,160645,180860,262504,299792,458970,479450) [ RunTime:0.015870s ]
共有 0条评论