SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001912s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000622s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001416s ]
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.000372s ]
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.000364s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000565s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001573s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 477764 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000941s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000468s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.001187s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',477764,') > 0 ) AND `status` = 1 [ RunTime:0.000743s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.590905s ]
SELECT * FROM `tp_soft` WHERE `id` IN (243333,225299,301581,217023,269780,470699,477706,254007,253044,228361,163433,195857,246654,268033,347228,475257) AND `status` = '1' AND `id` <> 477764 [ RunTime:0.004407s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '小白影视%' AND `status` = '1' AND `id` NOT IN (477764,163433,195857,217023,225299,228361,243333,246654,253044,254007,268033,269780,301581,347228,470699,475257,477706) [ RunTime:0.008450s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.540488s ]
SELECT * FROM `tp_soft` WHERE `id` IN (264798,252488,266355,173731,237708) AND `id` NOT IN (477764,163433,195857,217023,225299,228361,243333,246654,253044,254007,268033,269780,301581,347228,470699,475257,477706) [ RunTime:0.001821s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.505888s ]
SELECT * FROM `tp_soft` WHERE `id` IN (95271,152642,94545,157075,186823) AND `status` = '1' AND `id` NOT IN (477764,163433,195857,217023,225299,228361,243333,246654,253044,254007,268033,269780,301581,347228,470699,475257,477706,173731,237708,252488,264798,266355) [ RunTime:0.011905s ]
共有 0条评论