[ DB ] CONNECT:[ UseTime:0.007337s ] 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.008453s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" [ RunTime:0.003375s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.004166s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.001891s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001977s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" [ RunTime:0.001970s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001791s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001426s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "parent_id" = 59 AND "status" = '1' [ RunTime:0.001804s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001696s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.012838s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.011780s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_news' [ RunTime:0.005330s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (177) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,16 [ RunTime:0.003385s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (177) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.001904s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001544s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001588s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001595s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001706s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001594s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001416s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001924s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001418s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001795s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001768s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001651s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001434s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001270s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001493s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001215s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001600s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001379s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.017786s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001881s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001514s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001603s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001475s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001662s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.012427s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.011763s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (177) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,16 [ RunTime:0.003028s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (177) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.002062s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001812s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001556s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001434s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001576s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001646s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001452s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001762s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001379s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001469s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001282s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001401s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001616s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001560s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001550s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001445s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001805s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001283s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001293s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001575s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001628s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001438s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 177 LIMIT 1 [ RunTime:0.001343s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001296s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (177) ORDER BY "weigh","id" LIMIT 0,4 [ RunTime:0.002438s ]