SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001698s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000796s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001474s ]
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.000505s ]
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.000557s ]
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.000484s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000716s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001586s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 479388 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001035s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000634s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001194s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',479388,') > 0 ) AND `status` = 1 [ RunTime:0.000829s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.279370s ]
SELECT * FROM `tp_soft` WHERE `id` IN (179637,300640,220350,252852,267346,229861,199827,301719,482612,245954,464490,474723,219962,219889,328697,179928) AND `status` = '1' AND `id` <> 479388 [ RunTime:0.003331s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '印象Te%' AND `status` = '1' AND `id` NOT IN (479388,179637,179928,199827,219889,219962,220350,229861,245954,252852,267346,300640,301719,328697,464490,474723,482612) [ RunTime:0.006207s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.290164s ]
SELECT * FROM `tp_soft` WHERE `id` IN (479149,243380,462221,161677,476246) AND `id` NOT IN (479388,179637,179928,199827,219889,219962,220350,229861,245954,252852,267346,300640,301719,328697,464490,474723,482612,459606) [ RunTime:0.001707s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.227911s ]
SELECT * FROM `tp_soft` WHERE `id` IN (118165,91607,146470,112245,109010) AND `status` = '1' AND `id` NOT IN (479388,179637,179928,199827,219889,219962,220350,229861,245954,252852,267346,300640,301719,328697,464490,474723,482612,459606,161677,243380,462221,476246,479149) [ RunTime:0.002019s ]
共有 0条评论