SHOW FULL COLUMNS FROM `tp_system` [ RunTime:0.001301s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000583s ]
SHOW FULL COLUMNS FROM `tp_cate` [ RunTime:0.001040s ]
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.000517s ]
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.000550s ]
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.000462s ]
SELECT * FROM `tp_system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000629s ]
SHOW FULL COLUMNS FROM `tp_soft` [ RunTime:0.001222s ]
SELECT * FROM `tp_soft` WHERE ( `status` = '1' AND `id` = 481899 ) AND `tp_soft`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000802s ]
SELECT * FROM `tp_cate` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000490s ]
SHOW FULL COLUMNS FROM `tp_zhuanti` [ RunTime:0.000873s ]
SELECT * FROM `tp_zhuanti` WHERE ( INSTR(CONCAT(',', softid, ','), ',481899,') > 0 ) AND `status` = 1 [ RunTime:0.000569s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 16 [ RunTime:0.268395s ]
SELECT * FROM `tp_soft` WHERE `id` IN (160502,227683,268768,258978,222506,246638,474477,170582,232256,179496,343734,238618,251615,347711,229157,246640) AND `status` = '1' AND `id` <> 481899 [ RunTime:0.002098s ]
SELECT * FROM `tp_soft` WHERE `softname` LIKE '圆通网点%' AND `status` = '1' AND `id` NOT IN (481899,160502,170582,179496,222506,227683,229157,232256,238618,246638,246640,251615,258978,268768,343734,347711,474477) [ RunTime:0.003782s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 14 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.310898s ]
SELECT * FROM `tp_soft` WHERE `id` IN (181302,267859,199697,462343,482108) AND `id` NOT IN (481899,160502,170582,179496,222506,227683,229157,232256,238618,246638,246640,251615,258978,268768,343734,347711,474477) [ RunTime:0.001696s ]
SELECT `ID` FROM `tp_soft` WHERE `cate_id` = 16 AND `status` = '1' ORDER BY rand() LIMIT 5 [ RunTime:0.453097s ]
SELECT * FROM `tp_soft` WHERE `id` IN (275235,481248,135328,183995,480916) AND `status` = '1' AND `id` NOT IN (481899,160502,170582,179496,222506,227683,229157,232256,238618,246638,246640,251615,258978,268768,343734,347711,474477,181302,199697,267859,462343,482108) [ RunTime:0.002048s ]
共有 0条评论