[ DB ] CONNECT:[ UseTime:0.007428s ] 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.009041s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" [ RunTime:0.003169s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.002449s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.001739s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001809s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" [ RunTime:0.001514s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001679s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001682s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_news' [ RunTime:0.005469s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "cate_id" = 176 AND "status" = '1' ORDER BY "id" DESC LIMIT 3 [ RunTime:0.002886s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001806s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001579s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001549s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "parent_id" = 59 AND "status" = '1' [ RunTime:0.001679s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001470s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.012736s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.011910s ]
[ 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.003117s ]
[ 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.001959s ]
[ 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.001731s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001266s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001399s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001501s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001478s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001624s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001780s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001428s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001659s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001623s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001349s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001509s ]
[ 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.001311s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001386s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001742s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001472s ]
[ 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.001920s ]
[ 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.001254s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001438s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001369s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001634s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.012460s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.011920s ]
[ 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.003018s ]
[ 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.002018s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001576s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001626s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001315s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001471s ]
[ 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.001575s ]
[ 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.001285s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001448s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001520s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001413s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001809s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001364s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001508s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001608s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001562s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001782s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.002229s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001733s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001664s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001674s ]
[ 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.001653s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001621s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001476s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (176) ORDER BY "weigh","id" LIMIT 0,4 [ RunTime:0.002735s ]