SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001626s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000525s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.010106s ]
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.003681s ]
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.000364s ]
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.000342s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000502s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001273s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 484460 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000801s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.001711s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001149s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',484460,') > 0 ) AND `status` = 1 [ RunTime:0.000629s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.422288s ]
SELECT * FROM `tp_soft` WHERE `id` IN (269393,296064,482180,479708,255163,297612,474504,229758,459735,464674,253200,240861,209456,231005,247547,244495) AND `status` = '1' AND `id` <> 484460 [ RunTime:0.003426s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '江湖免费%' AND `status` = '1' AND `id` NOT IN (484460,209456,229758,231005,240861,244495,247547,253200,255163,269393,296064,297612,459735,464674,474504,479708,482180) [ RunTime:0.005548s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.432200s ]
SELECT * FROM `tp_soft` WHERE `id` IN (300368,477677,461644,241235,201534) AND `id` NOT IN (484460,209456,229758,231005,240861,244495,247547,253200,255163,269393,296064,297612,459735,464674,474504,479708,482180,130930) [ RunTime:0.001494s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.394578s ]
SELECT * FROM `tp_soft` WHERE `id` IN (150165,168736,435813,125447,94972) AND `status` = '1' AND `id` NOT IN (484460,209456,229758,231005,240861,244495,247547,253200,255163,269393,296064,297612,459735,464674,474504,479708,482180,130930,201534,241235,300368,461644,477677) [ RunTime:0.012680s ]
共有 0条评论