[ DB ] CONNECT:[ UseTime:0.006835s ] 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.008386s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" [ RunTime:0.002666s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.002729s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.001841s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001942s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" [ RunTime:0.001607s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 52 LIMIT 1 [ RunTime:0.001458s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 52 LIMIT 1 [ RunTime:0.001395s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "parent_id" = 52 AND "status" = '1' [ RunTime:0.001615s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001408s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_images' AND COLUMN_NAME = 'cate_id' [ RunTime:0.011737s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_images' AND COLUMN_NAME = 'deletetime' [ RunTime:0.011214s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_images' [ RunTime:0.005088s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_images" WHERE "status" = '1' AND "cate_id" IN (175) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,12 [ RunTime:0.001622s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_images" WHERE "status" = '1' AND "cate_id" IN (175) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.001464s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001601s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001331s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001426s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001613s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001606s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001552s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001659s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.002095s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001633s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001496s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001544s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.002129s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_images' AND COLUMN_NAME = 'cate_id' [ RunTime:0.011492s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_images' AND COLUMN_NAME = 'deletetime' [ RunTime:0.010733s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_images" WHERE "status" = '1' AND "cate_id" IN (175) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,12 [ RunTime:0.001998s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_images" WHERE "status" = '1' AND "cate_id" IN (175) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.001597s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001551s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001461s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001540s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001264s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001407s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001538s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001602s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001915s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001639s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001435s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001173s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001402s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_images" WHERE "status" = '1' AND "cate_id" IN (175) ORDER BY "weigh","id" LIMIT 0,4 [ RunTime:0.001698s ]