SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001434s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000545s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001103s ]
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.000469s ]
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.000382s ]
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.000351s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000481s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001233s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 479322 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000813s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000389s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000982s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',479322,') > 0 ) AND `status` = 1 [ RunTime:0.000667s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.297797s ]
SELECT * FROM `tp_soft` WHERE `id` IN (270066,242368,266976,160909,220145,248047,294924,300903,268339,461848,239094,264582,469048,483482,459795,458990) AND `status` = '1' AND `id` <> 479322 [ RunTime:0.004409s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '医知源官%' AND `status` = '1' AND `id` NOT IN (479322,160909,220145,239094,242368,248047,264582,266976,268339,270066,294924,300903,458990,459795,461848,469048,483482) [ RunTime:0.008068s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.487708s ]
SELECT * FROM `tp_soft` WHERE `id` IN (176429,234462,213522,483533,252975) AND `id` NOT IN (479322,160909,220145,239094,242368,248047,264582,266976,268339,270066,294924,300903,458990,459795,461848,469048,483482) [ RunTime:0.001580s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.226781s ]
SELECT * FROM `tp_soft` WHERE `id` IN (166554,126779,475119,274794,468403) AND `status` = '1' AND `id` NOT IN (479322,160909,220145,239094,242368,248047,264582,266976,268339,270066,294924,300903,458990,459795,461848,469048,483482,176429,213522,234462,252975,483533) [ RunTime:0.001265s ]
共有 0条评论