[ DB ] CONNECT:[ UseTime:0.007109s ] 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.009456s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" [ RunTime:0.003310s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.003025s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.002015s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001983s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" [ RunTime:0.001841s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001766s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001841s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_news' [ RunTime:0.005750s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "cate_id" = 176 AND "status" = '1' ORDER BY "id" DESC LIMIT 3 [ RunTime:0.003236s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001753s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001622s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001983s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "parent_id" = 59 AND "status" = '1' [ RunTime:0.002354s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001588s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.015583s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.017121s ]
[ 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.003199s ]
[ 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.002373s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001880s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001877s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.002312s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001580s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001862s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001912s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001966s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001863s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.002122s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001879s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001858s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001807s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001514s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001755s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001903s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.002236s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001652s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001734s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.002017s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001918s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001975s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001869s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001866s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001674s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001790s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.015445s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.015434s ]
[ 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.003473s ]
[ 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.002015s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.002437s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.002025s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.005512s ]
[ 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.001540s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001479s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001201s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001641s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001569s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001351s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001412s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001347s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001525s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001748s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001644s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001533s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001406s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001541s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001654s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001775s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001490s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001513s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001775s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001324s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001417s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (176) ORDER BY "weigh","id" LIMIT 0,4 [ RunTime:0.002613s ]