SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001348s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001111s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000873s ]
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.000449s ]
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.000469s ]
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.000498s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000569s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001040s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 481312 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000679s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000527s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000794s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',481312,') > 0 ) AND `status` = 1 [ RunTime:0.000635s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.168424s ]
SELECT * FROM `tp_soft` WHERE `id` IN (476864,140355,280660,121877,90396,207600,216065,139172,349171,89990,116181,110751,322766,101782,142731,136376) AND `status` = '1' AND `id` <> 481312 [ RunTime:0.002213s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '滚动的天%' AND `status` = '1' AND `id` NOT IN (481312,89990,90396,101782,110751,116181,121877,136376,139172,140355,142731,207600,216065,280660,322766,349171,476864) [ RunTime:0.006019s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.185789s ]
SELECT * FROM `tp_soft` WHERE `id` IN (252047,392369,260813,296775,465221) AND `id` NOT IN (481312,89990,90396,101782,110751,116181,121877,136376,139172,140355,142731,207600,216065,280660,322766,349171,476864,188022,118662,168757,274679,249561,477099,89694,246603,118663,480109,192198,485420,89960,118660,224138,178381,118661,481313,279664,118658,246604,83018,274892,81032,481314,192197,118664,118659,475018,113107,118657,166796,485421,155172,463696,246601,109923,481315) [ RunTime:0.001465s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.181401s ]
SELECT * FROM `tp_soft` WHERE `id` IN (90065,140197,109000,82857,137008) AND `status` = '1' AND `id` NOT IN (481312,89990,90396,101782,110751,116181,121877,136376,139172,140355,142731,207600,216065,280660,322766,349171,476864,188022,118662,168757,274679,249561,477099,89694,246603,118663,480109,192198,485420,89960,118660,224138,178381,118661,481313,279664,118658,246604,83018,274892,81032,481314,192197,118664,118659,475018,113107,118657,166796,485421,155172,463696,246601,109923,481315,252047,260813,296775,392369,465221) [ RunTime:0.002397s ]
共有 0条评论