SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001195s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000543s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000930s ]
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.000415s ]
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.000380s ]
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.000321s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000417s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001057s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 484681 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000703s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000816s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',484681,') > 0 ) AND `status` = 1 [ RunTime:0.000416s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.201073s ]
SELECT * FROM `tp_soft` WHERE `id` IN (469104,183408,162285,222932,162050,469893,271563,352914,269313,300987,470331,212360,269603,466178,461374,482322) AND `status` = '1' AND `id` <> 484681 [ RunTime:0.003648s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '奥克斯A%' AND `status` = '1' AND `id` NOT IN (484681,162050,162285,183408,212360,222932,269313,269603,271563,300987,352914,461374,466178,469104,469893,470331,482322) [ RunTime:0.005284s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.289847s ]
SELECT * FROM `tp_soft` WHERE `id` IN (231894,257983,196152,474765,221631) AND `id` NOT IN (484681,162050,162285,183408,212360,222932,269313,269603,271563,300987,352914,461374,466178,469104,469893,470331,482322) [ RunTime:0.001654s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.231943s ]
SELECT * FROM `tp_soft` WHERE `id` IN (481563,285437,190890,122675,149342) AND `status` = '1' AND `id` NOT IN (484681,162050,162285,183408,212360,222932,269313,269603,271563,300987,352914,461374,466178,469104,469893,470331,482322,196152,221631,231894,257983,474765) [ RunTime:0.001767s ]
共有 0条评论