[ DB ] CONNECT:[ UseTime:0.008330s ] dm:host=10.0.2.89;port=5236;dbname=ZG_TY;charset=utf8
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_cate' [ RunTime:0.016567s ]
[ SQL ] SELECT * FROM ZG_TY."zg_cate" [ RunTime:0.003080s ]
[ SQL ] SELECT * FROM ZG_TY."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.002503s ]
[ SQL ] SELECT * FROM ZG_TY."zg_cate" WHERE "outlink" = '/tianyuan/index/news?id=27&page=1' LIMIT 1 [ RunTime:0.001537s ]
[ SQL ] SELECT * FROM ZG_TY."zg_cate" WHERE "id" = 27 LIMIT 1 [ RunTime:0.001682s ]
[ SQL ] SELECT * FROM ZG_TY."zg_cate" WHERE "id" = 5 LIMIT 1 [ RunTime:0.001370s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_TY."zg_cate" [ RunTime:0.001527s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_TY' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.002596s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_TY' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.002660s ]
[ SQL ] 'zg_news'ZG_TY'elect * from user_tab_columns where TABLE_NAME = 'zg_news' [ RunTime:0.023368s ]
[ SQL ] SELECT * FROM ZG_TY."zg_news" WHERE "status" = '1' AND "cate_id" IN (27) AND "deletetime" IS NULL ORDER BY "publishtime" DESC,"id" DESC LIMIT 0,10 [ RunTime:0.014677s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_TY."zg_news" WHERE "status" = '1' AND "cate_id" IN (27) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.005942s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_TY."zg_cate" [ RunTime:0.001730s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_TY' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.002477s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_TY' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.002441s ]
[ SQL ] SELECT * FROM ZG_TY."zg_news" WHERE "status" = '1' AND "cate_id" IN (27) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,10 [ RunTime:0.011858s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_TY."zg_news" WHERE "status" = '1' AND "cate_id" IN (27) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.005836s ]
