[ DB ] CONNECT:[ UseTime:0.007957s ] dm:host=10.0.2.37;port=5236;dbname=ZG_MIMR;charset=utf8
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_cate' [ RunTime:0.016119s ]
[ SQL ] SELECT * FROM "zg_cate" [ RunTime:0.004028s ]
[ SQL ] SELECT * FROM "zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.003341s ]
[ SQL ] SELECT "id","parent_id","name" FROM "zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.002411s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_banner' [ RunTime:0.012327s ]
[ SQL ] SELECT * FROM "zg_banner" WHERE "status" = 'normal' AND "deletetime" IS NULL [ RunTime:0.002318s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_news' [ RunTime:0.012795s ]
[ SQL ] SELECT * FROM "zg_news" WHERE "status" = '1' AND "recommend" = 1 AND "deletetime" IS NULL ORDER BY "weigh" DESC,"publishtime" DESC [ RunTime:0.013999s ]
[ SQL ] SELECT * FROM "zg_cate" WHERE "status" = '1' AND "parent_id" = 71 AND "type" = 'list' LIMIT 4 [ RunTime:0.002290s ]
[ SQL ] SELECT * FROM "zg_news" WHERE "status" = '1' AND "cate_id" = 89 AND "deletetime" IS NULL ORDER BY "weigh" DESC,"publishtime" DESC,"id" DESC LIMIT 6 [ RunTime:0.013631s ]
[ SQL ] SELECT * FROM "zg_news" WHERE "status" = '1' AND "cate_id" = 90 AND "deletetime" IS NULL ORDER BY "weigh" DESC,"publishtime" DESC,"id" DESC LIMIT 6 [ RunTime:0.013055s ]
[ SQL ] SELECT * FROM "zg_news" WHERE "status" = '1' AND "cate_id" = 91 AND "deletetime" IS NULL ORDER BY "weigh" DESC,"publishtime" DESC,"id" DESC LIMIT 6 [ RunTime:0.013715s ]
[ SQL ] SELECT * FROM "zg_news" WHERE "status" = '1' AND "cate_id" = 92 AND "deletetime" IS NULL ORDER BY "weigh" DESC,"publishtime" DESC,"id" DESC LIMIT 6 [ RunTime:0.013134s ]
