SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001172s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000473s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.000927s ]
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.000427s ]
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.000386s ]
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.000347s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000533s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001559s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 478095 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.001038s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000421s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.004883s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',478095,') > 0 ) AND `status` = 1 [ RunTime:0.000809s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.652672s ]
SELECT * FROM `tp_soft` WHERE `id` IN (479523,269179,220866,478994,199602,179390,134553,265819,467012,469524,346343,299211,262387,479369,243811,269395) AND `status` = '1' AND `id` <> 478095 [ RunTime:0.014515s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE 'gitm%' AND `status` = '1' AND `id` NOT IN (478095,134553,179390,199602,220866,243811,262387,265819,269179,269395,299211,346343,467012,469524,478994,479369,479523) [ RunTime:0.006691s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.486317s ]
SELECT * FROM `tp_soft` WHERE `id` IN (261202,134058,474144,347175,261504) AND `id` NOT IN (478095,134553,179390,199602,220866,243811,262387,265819,269179,269395,299211,346343,467012,469524,478994,479369,479523,176507,472083,223052,86284) [ RunTime:0.001895s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.500832s ]
SELECT * FROM `tp_soft` WHERE `id` IN (434871,275459,121814,114417,173240) AND `status` = '1' AND `id` NOT IN (478095,134553,179390,199602,220866,243811,262387,265819,269179,269395,299211,346343,467012,469524,478994,479369,479523,176507,472083,223052,86284,134058,261202,261504,347175,474144) [ RunTime:0.002567s ]
共有 0条评论