SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.002034s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000657s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001631s ]
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.000564s ]
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.000441s ]
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.000369s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000578s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001481s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 477723 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000935s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000472s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001516s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',477723,') > 0 ) AND `status` = 1 [ RunTime:0.000863s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.593613s ]
SELECT * FROM `tp_soft` WHERE `id` IN (306076,179310,261901,480907,251672,302279,458866,460504,229524,467497,176357,271973,479933,243958,259585,250730) AND `status` = '1' AND `id` <> 477723 [ RunTime:0.004372s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '202追%' AND `status` = '1' AND `id` NOT IN (477723,176357,179310,229524,243958,250730,251672,259585,261901,271973,302279,306076,458866,460504,467497,479933,480907) [ RunTime:0.008237s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.498322s ]
SELECT * FROM `tp_soft` WHERE `id` IN (482579,482068,227825,298678,199601) AND `id` NOT IN (477723,176357,179310,229524,243958,250730,251672,259585,261901,271973,302279,306076,458866,460504,467497,479933,480907) [ RunTime:0.001900s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.388952s ]
SELECT * FROM `tp_soft` WHERE `id` IN (83370,481038,115925,168888,81394) AND `status` = '1' AND `id` NOT IN (477723,176357,179310,229524,243958,250730,251672,259585,261901,271973,302279,306076,458866,460504,467497,479933,480907,199601,227825,298678,482068,482579) [ RunTime:0.001627s ]
共有 0条评论