[ DB ] CONNECT:[ UseTime:0.007174s ] dm:host=10.0.2.37;port=5236;dbname=ZG_KYXCL;charset=utf8
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_cate' [ RunTime:0.009032s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" [ RunTime:0.002824s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.002373s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.001348s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001666s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" [ RunTime:0.001612s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001666s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001481s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_news' [ RunTime:0.005138s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "cate_id" = 178 AND "status" = '1' AND "weigh" IS NOT NULL ORDER BY "weigh" DESC LIMIT 1 [ RunTime:0.003012s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001654s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "parent_id" = 59 AND "status" = '1' [ RunTime:0.001707s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001335s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.012372s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.011892s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (178) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,10 [ RunTime:0.003820s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (178) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.001814s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.002066s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001578s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001622s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001250s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001494s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001699s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001645s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001391s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001640s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001457s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001460s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001871s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001515s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001173s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001653s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001524s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001415s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001296s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001514s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001600s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001572s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001248s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001650s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001745s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001567s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001678s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001622s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001783s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001582s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001734s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001555s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001771s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001689s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001523s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001550s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001744s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001396s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001715s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001543s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001715s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001657s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.002104s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.012503s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.012704s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (178) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,10 [ RunTime:0.003532s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (178) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.002120s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001774s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.002095s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001224s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001690s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001666s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001532s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001407s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001455s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001691s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001714s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001480s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001555s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001562s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.002015s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.002210s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001568s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001584s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001330s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001563s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001271s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001623s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001564s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001242s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001480s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001590s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001252s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001580s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.002020s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001599s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001846s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001584s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001732s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001606s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001573s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.002425s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001720s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001434s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001607s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001944s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001523s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001465s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001460s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (178) ORDER BY "weigh","id" LIMIT 0,4 [ RunTime:0.002756s ]
