[ DB ] CONNECT:[ UseTime:0.006215s ] 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.008344s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" [ RunTime:0.002891s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.002367s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.001690s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001611s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" [ RunTime:0.001521s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001438s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001571s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_news' [ RunTime:0.005144s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "cate_id" = 178 AND "status" = '1' AND "weigh" IS NOT NULL ORDER BY "weigh" DESC LIMIT 1 [ RunTime:0.002995s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001725s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "parent_id" = 59 AND "status" = '1' [ RunTime:0.001817s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001426s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.013283s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.013028s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (178) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,10 [ RunTime:0.003740s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (178) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.001700s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001658s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001590s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001485s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001612s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001348s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001758s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001458s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001359s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001367s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001526s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001461s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001424s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001598s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001488s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001567s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001179s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001613s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001348s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001391s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001353s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001285s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001551s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001473s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001581s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001631s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001594s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001471s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001591s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001617s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001607s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001455s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001402s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001603s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001664s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001444s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001660s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001309s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001645s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001283s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001660s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001445s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001749s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.013514s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.015135s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (178) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,10 [ RunTime:0.004096s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (178) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.001907s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.002007s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001815s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001557s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001899s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001614s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001591s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001450s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001504s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001396s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001265s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001415s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001274s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001856s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001244s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001179s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001707s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.024578s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001755s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001736s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001732s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001635s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.002059s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001730s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001297s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001967s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001779s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001865s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001759s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001956s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001242s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001423s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001377s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001618s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001642s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001479s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001441s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001300s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001295s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001361s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001568s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 178 LIMIT 1 [ RunTime:0.001273s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001928s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (178) ORDER BY "weigh","id" LIMIT 0,4 [ RunTime:0.002823s ]
