SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001895s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000585s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001396s ]
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.000596s ]
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.000424s ]
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.000405s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000548s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001469s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 481208 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000892s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000479s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001262s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',481208,') > 0 ) AND `status` = 1 [ RunTime:0.000898s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.400562s ]
SELECT * FROM `tp_soft` WHERE `id` IN (149120,114721,272331,135015,178862,114056,274844,189764,275489,110901,142783,280973,211097,476520,177655,473878) AND `status` = '1' AND `id` <> 481208 [ RunTime:0.004861s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '异教徒模%' AND `status` = '1' AND `id` NOT IN (481208,110901,114056,114721,135015,142783,149120,177655,178862,189764,211097,272331,274844,275489,280973,473878,476520) [ RunTime:0.025758s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.465132s ]
SELECT * FROM `tp_soft` WHERE `id` IN (266614,233397,221812,474019,319087) AND `id` NOT IN (481208,110901,114056,114721,135015,142783,149120,177655,178862,189764,211097,272331,274844,275489,280973,473878,476520,468574,95805,172365) [ RunTime:0.001831s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.394437s ]
SELECT * FROM `tp_soft` WHERE `id` IN (158942,348586,110621,109459,174060) AND `status` = '1' AND `id` NOT IN (481208,110901,114056,114721,135015,142783,149120,177655,178862,189764,211097,272331,274844,275489,280973,473878,476520,468574,95805,172365,221812,233397,266614,319087,474019) [ RunTime:0.001987s ]
共有 0条评论