SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.002818s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000651s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001378s ]
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.000493s ]
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.000362s ]
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.000350s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000533s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001511s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 473941 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000997s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000436s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001205s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',473941,') > 0 ) AND `status` = 1 [ RunTime:0.000712s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.257380s ]
SELECT * FROM `tp_soft` WHERE `id` IN (480272,151740,476014,480761,471779,278631,164488,481222,154901,115254,481410,320330,466868,152656,472901,193019) AND `status` = '1' AND `id` <> 473941 [ RunTime:0.021676s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE 'Brai%' AND `status` = '1' AND `id` NOT IN (473941,115254,151740,152656,154901,164488,193019,278631,320330,466868,471779,472901,476014,480272,480761,481222,481410) [ RunTime:0.005476s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.239243s ]
SELECT * FROM `tp_soft` WHERE `id` IN (479892,237657,235566,463360,347575) AND `id` NOT IN (473941,115254,151740,152656,154901,164488,193019,278631,320330,466868,471779,472901,476014,480272,480761,481222,481410,258686,463610,262693) [ RunTime:0.001233s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.162247s ]
SELECT * FROM `tp_soft` WHERE `id` IN (146564,272932,193492,137426,321605) AND `status` = '1' AND `id` NOT IN (473941,115254,151740,152656,154901,164488,193019,278631,320330,466868,471779,472901,476014,480272,480761,481222,481410,258686,463610,262693,235566,237657,347575,463360,479892) [ RunTime:0.001528s ]
共有 0条评论