SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.002162s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000617s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.009047s ]
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.000531s ]
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.003450s ]
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.000415s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.004505s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.005470s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 480695 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.004128s ]
SELECT * FROM `tp_cate` WHERE `id` = 39 LIMIT 1 [ RunTime:0.003766s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.004488s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.005165s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',480695,') > 0 ) AND `status` = 1 [ RunTime:0.000811s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 39 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.463236s ]
SELECT * FROM `tp_soft` WHERE `id` IN (206500,464398,298765,282178,473756,110045,154138,117167,275900,269374,110053,167058,216845,223747,113297,111581) AND `status` = '1' AND `id` <> 480695 [ RunTime:0.031268s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '白蛇仙劫%' AND `status` = '1' AND `id` NOT IN (480695,110045,110053,111581,113297,117167,154138,167058,206500,216845,223747,269374,275900,282178,298765,464398,473756) [ RunTime:0.017123s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.369664s ]
SELECT * FROM `tp_soft` WHERE `id` IN (466755,176690,240278,464835,176950) AND `id` NOT IN (480695,110045,110053,111581,113297,117167,154138,167058,206500,216845,223747,269374,275900,282178,298765,464398,473756,461196,470964,205438,126906,264468,186017,115296,470963,205436,205437) [ RunTime:0.001562s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.267057s ]
SELECT * FROM `tp_soft` WHERE `id` IN (95631,118286,278141,185801,281885) AND `status` = '1' AND `id` NOT IN (480695,110045,110053,111581,113297,117167,154138,167058,206500,216845,223747,269374,275900,282178,298765,464398,473756,461196,470964,205438,126906,264468,186017,115296,470963,205436,205437,176690,176950,240278,464835,466755) [ RunTime:0.002283s ]
SELECT * FROM `tp_cate` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000466s ]
共有 0条评论