SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001269s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000478s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000904s ]
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.000430s ]
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.000467s ]
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.000413s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000527s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001018s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 475213 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000705s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000415s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000817s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',475213,') > 0 ) AND `status` = 1 [ RunTime:0.000561s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.196494s ]
SELECT * FROM `tp_soft` WHERE `id` IN (263245,270123,269855,175296,463941,175537,201276,479667,484186,221975,162226,224798,296763,467261,246844,204047) AND `status` = '1' AND `id` <> 475213 [ RunTime:0.002550s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE 'fitd%' AND `status` = '1' AND `id` NOT IN (475213,162226,175296,175537,201276,204047,221975,224798,246844,263245,269855,270123,296763,463941,467261,479667,484186) [ RunTime:0.004964s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.210108s ]
SELECT * FROM `tp_soft` WHERE `id` IN (251262,464321,183491,450968,459951) AND `id` NOT IN (475213,162226,175296,175537,201276,204047,221975,224798,246844,263245,269855,270123,296763,463941,467261,479667,484186,179497,130175) [ RunTime:0.001322s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.172661s ]
SELECT * FROM `tp_soft` WHERE `id` IN (112399,117898,199305,110039,193666) AND `status` = '1' AND `id` NOT IN (475213,162226,175296,175537,201276,204047,221975,224798,246844,263245,269855,270123,296763,463941,467261,479667,484186,179497,130175,183491,251262,450968,459951,464321) [ RunTime:0.001707s ]
共有 0条评论