[ DB ] CONNECT:[ UseTime:0.007693s ] 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.008556s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" [ RunTime:0.003593s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.002566s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.001755s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.002039s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" [ RunTime:0.001485s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001385s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001407s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_news' [ RunTime:0.005618s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "cate_id" = 176 AND "status" = '1' ORDER BY "id" DESC LIMIT 3 [ RunTime:0.002770s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.002152s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001517s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001637s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "parent_id" = 59 AND "status" = '1' [ RunTime:0.001836s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001342s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.012940s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.012397s ]
[ 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.003015s ]
[ 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.001906s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.002029s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.002033s ]
[ 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.001741s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001519s ]
[ 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.001543s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001518s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001408s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001477s ]
[ 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.001784s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001323s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001306s ]
[ 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.001463s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001687s ]
[ 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.001643s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001548s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001301s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001418s ]
[ 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.001655s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001791s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.012559s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.011885s ]
[ 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.002926s ]
[ 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.001952s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001833s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001860s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001751s ]
[ 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.001793s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001650s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001389s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.002077s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001716s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001312s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001457s ]
[ 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.001644s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001957s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001454s ]
[ 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.001475s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001529s ]
[ 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.001850s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001403s ]
[ 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.001288s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 176 LIMIT 1 [ RunTime:0.001468s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001429s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (176) ORDER BY "weigh","id" LIMIT 0,4 [ RunTime:0.002437s ]