[ DB ] CONNECT:[ UseTime:0.007267s ] 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.008834s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" [ RunTime:0.003417s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.002692s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.001978s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001821s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" [ RunTime:0.001571s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 52 LIMIT 1 [ RunTime:0.001626s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 52 LIMIT 1 [ RunTime:0.001548s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "parent_id" = 52 AND "status" = '1' [ RunTime:0.001633s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001501s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_images' AND COLUMN_NAME = 'cate_id' [ RunTime:0.011781s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_images' AND COLUMN_NAME = 'deletetime' [ RunTime:0.011029s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_images' [ RunTime:0.005005s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_images" WHERE "status" = '1' AND "cate_id" IN (174) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,12 [ RunTime:0.001691s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_images" WHERE "status" = '1' AND "cate_id" IN (174) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.001740s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001606s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001572s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001599s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001556s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001306s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001433s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001591s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001135s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001617s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001531s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_images' AND COLUMN_NAME = 'cate_id' [ RunTime:0.011370s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_images' AND COLUMN_NAME = 'deletetime' [ RunTime:0.011444s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_images" WHERE "status" = '1' AND "cate_id" IN (174) AND "deletetime" IS NULL ORDER BY "weigh" DESC,"id" DESC LIMIT 0,12 [ RunTime:0.002464s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ZG_KYXCL."zg_images" WHERE "status" = '1' AND "cate_id" IN (174) AND "deletetime" IS NULL LIMIT 1 [ RunTime:0.001768s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001930s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001460s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001273s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001438s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001161s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001717s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001635s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001665s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 174 LIMIT 1 [ RunTime:0.001655s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001310s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_images" WHERE "status" = '1' AND "cate_id" IN (174) ORDER BY "weigh","id" LIMIT 0,4 [ RunTime:0.001561s ]