[ DB ] CONNECT:[ UseTime:0.006703s ] 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.006924s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" [ RunTime:0.002792s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.002134s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.001519s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001238s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" [ RunTime:0.001728s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001734s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001405s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_news' [ RunTime:0.004171s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "cate_id" = 176 AND "status" = '1' ORDER BY "id" DESC LIMIT 3 [ RunTime:0.002472s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001497s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001564s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001498s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "parent_id" = 59 AND "status" = '1' [ RunTime:0.001563s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001316s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.008538s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.008568s ]
[ 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.002280s ]
[ 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.001473s ]
[ 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.001365s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001416s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001374s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001233s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001450s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001915s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001582s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001434s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001209s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001597s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001440s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001233s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001309s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001455s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001588s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001589s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001461s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001425s ]
[ 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.001425s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001415s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001698s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001291s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001689s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.009007s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.010841s ]
[ 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.002537s ]
[ 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.001578s ]
[ 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.001534s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001445s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001370s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001261s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001417s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001584s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001444s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001598s ]
[ 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.001254s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001420s ]
[ 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.001658s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001253s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001402s ]
[ 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.001574s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001295s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001498s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001394s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001466s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001527s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001406s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001424s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (176) ORDER BY "weigh","id" LIMIT 0,4 [ RunTime:0.002339s ]