SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001254s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000665s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001065s ]
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.000461s ]
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.000541s ]
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.000520s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000588s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.000931s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 478613 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000778s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000555s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000960s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',478613,') > 0 ) AND `status` = 1 [ RunTime:0.000562s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.217558s ]
SELECT * FROM `tp_soft` WHERE `id` IN (459009,271219,247061,462156,260473,218781,254188,195700,477439,236802,312711,174956,231731,258715,235979,343044) AND `status` = '1' AND `id` <> 478613 [ RunTime:0.002305s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '百度优选%' AND `status` = '1' AND `id` NOT IN (478613,174956,195700,218781,231731,235979,236802,247061,254188,258715,260473,271219,312711,343044,459009,462156,477439) [ RunTime:0.004160s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.242531s ]
SELECT * FROM `tp_soft` WHERE `id` IN (484681,223089,268299,237825,224957) AND `id` NOT IN (478613,174956,195700,218781,231731,235979,236802,247061,254188,258715,260473,271219,312711,343044,459009,462156,477439,335153) [ RunTime:0.001364s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.227969s ]
SELECT * FROM `tp_soft` WHERE `id` IN (474929,159058,154410,149534,80378) AND `status` = '1' AND `id` NOT IN (478613,174956,195700,218781,231731,235979,236802,247061,254188,258715,260473,271219,312711,343044,459009,462156,477439,335153,223089,224957,237825,268299,484681) [ RunTime:0.001557s ]
共有 0条评论