[ DB ] CONNECT:[ UseTime:0.007142s ] 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.009069s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" [ RunTime:0.002876s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.002532s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.001463s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001711s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" [ RunTime:0.001432s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001864s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001434s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_news' [ RunTime:0.005628s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "cate_id" = 176 AND "status" = '1' ORDER BY "id" DESC LIMIT 3 [ RunTime:0.003034s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001841s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001620s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001528s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "parent_id" = 59 AND "status" = '1' [ RunTime:0.001782s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001236s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.013040s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.012010s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (176) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,6 [ RunTime:0.003156s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (176) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.001861s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001919s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001867s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001507s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001352s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001572s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001465s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001496s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001556s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001376s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001267s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001470s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001561s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001314s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001542s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001487s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001506s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001474s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001325s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001345s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001611s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001661s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001462s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001678s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001426s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001514s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.013032s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.012050s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (176) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,6 [ RunTime:0.002999s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (176) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.004000s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001611s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001463s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001384s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001281s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001369s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001373s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001545s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001526s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001424s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001627s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001464s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001431s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001453s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001719s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001421s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001492s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001983s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001738s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001460s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001575s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001615s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001581s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.002438s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001568s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001536s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (176) ORDER BY "weigh","id" LIMIT 0,4 [ RunTime:0.002222s ]