[ DB ] CONNECT:[ UseTime:0.006799s ] 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.008824s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" [ RunTime:0.002665s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.002428s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.001785s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001729s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" [ RunTime:0.001553s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001598s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 59 LIMIT 1 [ RunTime:0.001585s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "parent_id" = 59 AND "status" = '1' [ RunTime:0.001781s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001461s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.013430s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.012501s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_news' [ RunTime:0.005837s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (186) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,10 [ RunTime:0.002553s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (186) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.001707s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001900s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001581s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001663s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001547s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001256s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001629s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001633s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.011683s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'cate_id' [ RunTime:0.013110s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_news' AND COLUMN_NAME = 'deletetime' [ RunTime:0.012245s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (186) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,10 [ RunTime:0.002610s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (186) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.001801s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001585s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001595s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001432s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001299s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001586s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001492s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 186 LIMIT 1 [ RunTime:0.001590s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001438s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_news" WHERE "status" = '1' AND "cate_id" IN (186) ORDER BY "weigh","id" LIMIT 0,4 [ RunTime:0.002116s ]
