SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.002096s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000650s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001460s ]
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.000538s ]
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.000432s ]
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.000390s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000560s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001644s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 482972 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000980s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000668s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001473s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',482972,') > 0 ) AND `status` = 1 [ RunTime:0.000823s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.572200s ]
SELECT * FROM `tp_soft` WHERE `id` IN (474563,234863,237525,452000,349501,247197,250923,258821,161725,260408,477771,461296,464006,203469,465358,176285) AND `status` = '1' AND `id` <> 482972 [ RunTime:0.003767s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '三星音乐%' AND `status` = '1' AND `id` NOT IN (482972,161725,176285,203469,234863,237525,247197,250923,258821,260408,349501,452000,461296,464006,465358,474563,477771) [ RunTime:0.007958s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.477890s ]
SELECT * FROM `tp_soft` WHERE `id` IN (267613,227534,230865,262714,201116) AND `id` NOT IN (482972,161725,176285,203469,234863,237525,247197,250923,258821,260408,349501,452000,461296,464006,465358,474563,477771,253525,276687,104949,482973,212303) [ RunTime:0.014274s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.403939s ]
SELECT * FROM `tp_soft` WHERE `id` IN (134986,126732,468090,139526,216091) AND `status` = '1' AND `id` NOT IN (482972,161725,176285,203469,234863,237525,247197,250923,258821,260408,349501,452000,461296,464006,465358,474563,477771,253525,276687,104949,482973,212303,201116,227534,230865,262714,267613) [ RunTime:0.002232s ]
共有 0条评论