SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001423s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000608s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001007s ]
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.000618s ]
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.000530s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000583s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001224s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 478775 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000885s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000492s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000939s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',478775,') > 0 ) AND `status` = 1 [ RunTime:0.000669s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.195948s ]
SELECT * FROM `tp_soft` WHERE `id` IN (482609,261093,182705,477787,175893,268448,243277,181240,233196,251010,245712,228240,461623,214554,263395,225996) AND `status` = '1' AND `id` <> 478775 [ RunTime:0.002485s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '101贝%' AND `status` = '1' AND `id` NOT IN (478775,175893,181240,182705,214554,225996,228240,233196,243277,245712,251010,261093,263395,268448,461623,477787,482609) [ RunTime:0.007260s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.370172s ]
SELECT * FROM `tp_soft` WHERE `id` IN (160920,223061,282986,161260,225559) AND `id` NOT IN (478775,175893,181240,182705,214554,225996,228240,233196,243277,245712,251010,261093,263395,268448,461623,477787,482609,468461,258442,277539,88912,175154,87825,239237,242140) [ RunTime:0.001541s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.197741s ]
SELECT * FROM `tp_soft` WHERE `id` IN (91035,178247,138495,119761,156578) AND `status` = '1' AND `id` NOT IN (478775,175893,181240,182705,214554,225996,228240,233196,243277,245712,251010,261093,263395,268448,461623,477787,482609,468461,258442,277539,88912,175154,87825,239237,242140,160920,161260,223061,225559,282986) [ RunTime:0.001599s ]
共有 0条评论