[ DB ] CONNECT:[ UseTime:0.006893s ] 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.009069s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" [ RunTime:0.002971s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.002526s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" DESC [ RunTime:0.001693s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001818s ]
[ SQL ] SELECT "id","parent_id","name" FROM ZG_KYXCL."zg_cate" WHERE "isnav_switch" = 1 AND "status" = '1' ORDER BY "weigh" [ RunTime:0.001706s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 52 LIMIT 1 [ RunTime:0.001451s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 52 LIMIT 1 [ RunTime:0.001525s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "parent_id" = 52 AND "status" = '1' [ RunTime:0.001588s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001380s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_images' AND COLUMN_NAME = 'cate_id' [ RunTime:0.012944s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_images' AND COLUMN_NAME = 'deletetime' [ RunTime:0.011890s ]
[ SQL ] select * from user_tab_columns where TABLE_NAME = 'zg_images' [ RunTime:0.005451s ]
[ 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.002134s ]
[ 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.001666s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001753s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001447s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001554s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001736s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001459s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001999s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001516s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001686s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001142s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001656s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001510s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001312s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_images' AND COLUMN_NAME = 'cate_id' [ RunTime:0.012132s ]
[ SQL ] SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER = 'ZG_KYXCL' AND TABLE_NAME = 'zg_images' AND COLUMN_NAME = 'deletetime' [ RunTime:0.011220s ]
[ 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.002092s ]
[ 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.001352s ]
[ 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.001429s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001428s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001521s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001652s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001486s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001670s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001296s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001456s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001199s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_cate" WHERE "id" = 175 LIMIT 1 [ RunTime:0.001343s ]
[ SQL ] SELECT "name","id","parent_id" FROM ZG_KYXCL."zg_cate" [ RunTime:0.001643s ]
[ SQL ] SELECT * FROM ZG_KYXCL."zg_images" WHERE "status" = '1' AND "cate_id" IN (175) ORDER BY "weigh","id" LIMIT 0,4 [ RunTime:0.001545s ]